QUESTION 19 From: Principles of Finance with Excel 3rd ed,, Benninga and Mofkadi, O 2018, 2011, 2006 You are considering buying a new top-of-the line luxury car. The car's list price is $100,000. The dealer has offerecd you two alternatives for purchasing the car. You can buy the car for $90,000 in cash and get a $10,000 discount in the bargain. OR You can buy the car for the list price of $100,000. In this case, the dealer is willing to take $40,000 as an initial payment. The remainder of the cost of the car is a "zero interest loan" to be paid back in equal installments over 36 months Alternatively, your local bank is willing to give you a car loan at an APR of 10%, compounded monthly. (.10/12) Decide how to finance the cak: Bank loan or zero-interest loan with the dealer Bank loan or zero-interest loan with the dealer Car Price: Purchase Discount Amount: $ Bank Loan Rate Monthly Rate Bank EAIR Term in Months 100,000.00 10,000.00 10.00% Dealer "Zero Interest" Deal Initial Payment: Monthly Payment: $40,000.00 #N/A #N/A #N/A Zero Interest EAIR Purchase or Take "Deal" #N/A #N/A ' 36 Create an IF Statement