$2.$ You want to purchase a $2022$ Porsche Cayenne Coup that costs $$77,400.$

$2$A$.$Calculate your monthly payment assuming that you finance the full amount $($$$77,400)$ for $6$ years at an annual interest rate of $5\mathrm{.}5\%.$

$2$B$.$ Construct a full amortization schedule in excel.

$2$C$.$ How much total interest will you pay over the lifetime of this loan?

$2$D$.$ If you decide to add an additional $$200$ a month to your monthly payment, how much

will you save in interest over the course of the loan?

$2$E$.$ If you can only afford a $$650$ a month car payment, what is the max you can afford to finance given the same loan terms $(6$ years, at $5\mathrm{.}5\%)?$