show formulas for excel on how to get answer.

C-Suppose that you have the option to buy the car with a 3 year car loan or lease the car during the same period of time. The 3 year lease option will require a $3,000 down payment and monthly payments of $350. If the salvage value of the new vehicle after 3 years is $5,000 and you can invest at a rate of return of 4%, what is your best option? (Ignore your old vehicle.) Buy Personal Investment Rate Salvage Value Car Loan Payments 4% $5,000.00 3 + Lease 2 Down Payment Monthly Payments $ 3,000.00 $ 350.00 3 4 5 6 7 8 9 NPV of Buying NPV of Leasing Buy or Lease? 0 2 3 14 15 36 37 38 39 20 31 32 93 94 95 96 Q1 Q2 Q3 Your Info + Instructions cv C-Suppose that you have the option to buy the car with a 3 year car loan or lease the car during the same period of time. The 3 year lease option will require a $3,000 down payment and monthly payments of $350. If the salvage value of the new vehicle after 3 years is $5,000 and you can invest at a rate of return of 4%, what is your best option? (Ignore your old vehicle.) Buy Personal Investment Rate Salvage Value Car Loan Payments 4% $5,000.00 3 + Lease 2 Down Payment Monthly Payments $ 3,000.00 $ 350.00 3 4 5 6 7 8 9 NPV of Buying NPV of Leasing Buy or Lease? 0 2 3 14 15 36 37 38 39 20 31 32 93 94 95 96 Q1 Q2 Q3 Your Info + Instructions cv