calcualte the PV in excel with a monthly payment of $$350,$ down payment $$2000,$ interest $7$ percent and $36$ month term $\backslash$table$[[,$Car $1,,$Car $2,$Car $3],[$Monthly payment,$$,350\mathrm{.}00,$$$,400\mathrm{.}00,$$$375\mathrm{.}00],[$Down payment,$$,2,000\mathrm{.}00,$$$,5,000\mathrm{.}00,],[$Annual interest rate,,$7\mathrm{.}00\%,,6\mathrm{.}25\%,5\mathrm{.}00\%],[$Term $($months$),,36,,,60],[$Amount financed$],[$Cost of car,,,,$$20,054\mathrm{.}42,$$$28,000\mathrm{.}00],[$Payoff date,,,,,$]]$ Compute the amount financed, total cost, and payoff date for Car $1,$ assuming you purchase the car today and payments are made monthly at the END of each month.

Click the Auto sheet and select cell B$7.$

Begin the formula $=-$PV and then complete the formula assuming payments are made at the end of the period.

Select cell B$8$ and enter a formula for the total cost of car $1.$

Select cell B$9$ and compute the payoff date, $36$ months from today.

Compute the number of monthly payments and payoff date for Car $2,$ assuming you purchase the car today and payments are made monthly at the END of each month.

Click the Auto sheet and select cell C$6.$

Begin the formula $=$NPER and then complete the formula assuming payments are made at the end of the period.

Select cell C$9$ and compute the payoff date and the number of monthly payments computed in cell C$6.$

Compute the amount financed, payoff date and the required down payment for Car $3,$ assuming you purchase the car today and payments are made monthly at the END of each month.

Click the Auto sheet and select cell D$7.$

Begin the formula $=-$PV and then complete the formula assuming payments are made at the end of the period.

Select cell D$4$ and compute the amount of the required down payment $($Cost of car minus the amount financed$).$

Select cell D$9$ and compute the payoff date, $60$ months from today.