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

complete in excel please
complete in excel please Question 4 An auto dealership is advertising that

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!