You're considering buying a new top-of-the-line luxury car. The car's list price is $99,000. The dealer has offered you two alternatives for purchasing the car:

• You can buy the car for $90,000 in cash and get a $9,000 discount in the bargain. Assuming that you have no cash, if you decide to choose this option, you will borrow $90,000 from your bank. Your local bank is willing to give you a car loan at an annual interest rate of 10%, compounded monthly (that is, 10%/12 per month).
• You can buy the car for the list of $99,000. In this case, the dealer is willing to take $39,000 as an initial payment. The remainder of the $60,000 is a "zero-interest loan" to be paid back in equal installments over 36 months.

Decide how to finance the car: take the bank loan so you can pay cash to the dealer or take the zero-interest loan with the dealer.

**Please use Excel**