Question: complete in excel please Question 4 An auto dealership is advertising that a new car with a sticker price of $45,600 is on sale for
Question 4 An auto dealership is advertising that a new car with a sticker price of $45,600 is on sale for $34,995 if payment is made in full at the time of purchase, or it can be financed at 0% interest for 60 months, but you will be charged the full amount of $45,600 in monthly payments. This is clearly a case where the dealership is hiding the effective interest rate. If you make the payment in full, the total amount you pay will be $10,605 less than the amount you pay if you finance the car. Task 1: You need to set this question up yourself in the "Question 4" worksheet. If you choose the 0% financing option, how much would be the effective interest rate? Hint: You can use the PMT() function with an arbitrary interest rate and calculate the monthly payment amount. Then use the Goal Seek tool to find the interest rate that gives you the monthly payment amount you have in here (45,600/60=$760). Task 2: Protect all the cells in the "Qhestion 4" worksheet except the interest rate and the monthly payment cells. Do not put any password for protection
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
