Please help me with the formulars and the samples as to how the answers should like are being provided here. I need the formulars clearly done on an excel file with the instructions.

of return for the investment. 14-10. You are considering purchasing a new car. The price would be $18,239. You would pay $2,000 now and the rest monthly in a four-year loan. The automobile dealership is offering a sales promotion where either (a) you will receive a $1,000 rebate check right now and the annual interest rate on the loan will be 11.9% or (b) the annual interest rate on the loan will be 1.9% but there is no rebate. Create a worksheet to compare the two options by calculating the present value of each of the options, assuming an 8% discount rate. Which is the better deal? Write a paragraph to justify your