Question
12. (EAIR in loans) Youre considering buying a new top- of- the- line luxury car. The cars list price is $99,000. The dealer has offered
12. (EAIR in loans) Youre considering buying a new top- of- the- line luxury car. The cars list price is $99,000. The dealer has offered you two alternatives for purchasing thecar: You can buy the car for $90,000 in cash and get a $9,000 discount in the bargain. 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 $60,000 is a zero- interest loan to be paid back in equal install-ments over 36months.Alternatively, 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).Decide how to finance the car:Bank loan or zero- interest loan with the dealer, or cash payment. Please show only how do in excel and which formulas are used.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started