Please do this in excel!

You are interested in arranging financing to purchase a new car from Bloomington Cars, Inc. The car that you want has a sticker price of $42,000, an instant rebate of $3,500, a fair market value of $39,000, and a great sound system. The salesperson, while smoothing over his comb-over, taps his pinky ring on the hood of the car and tells you, You picked the best car we have. I can also kick in a free Bloomington Cars coffee mug. Since you love the car, you hop up and down and say, Sold! Ill take it. You sign a loan contract for 60 monthly payments based on a rate of 7.3% per year and drive home with your new car and coffee mug, listening to that great sound system. (Your market rate of return for the risks you pose for a car loan is 5.5%.)

the answer is c, not sure how to get to it though. thank you.

How much value did you destroy in pursuit of that great sound system and your free coffee mug (round the payments to two places and then round your final answer to two places)? a. $ 499.86 b. $3,000.06 c. $1,197.03 d. $2,324.09 e. None of the above