A car dealership is offering a choice of a 0% loan or $5,000 cash back on the purchase of a $29,061 car

Finance Dec 22, 2020

A car dealership is offering a choice of a 0% loan or $5,000 cash back on the purchase of a $29,061 car.

a) If someone took the 0% offer, calculate the amount of the monthly payments for 5 years.

b) Someone took the cash-back offer and used the money as a downpayment on the car. She can borrow money from a local bank at 6% interest compounded monthly for 5 years. How much is her monthly payment?

c) Which of the 2 offers is more favorable? why?

PLEASE DO IT ON EXCEL AND SHOW VALUES FOR

Expert Solution

PFA

Download Solution Attachment (PDF/Doc)

Archived Solution

Unlocked Solution

You have full access to this solution. To save a copy with all formatting and attachments, use the button below.

Already a member? Sign In

Important Note: This solution is from our archive and has been purchased by others. Submitting it as-is may trigger plagiarism detection. Use it for reference only.

For ready-to-submit work, please order a fresh solution below.

Or get 100% fresh solution

Get Custom Quote