Question: Please use Excel to complete the question, give the details. Thank you! Business math question, use Excel to complete it. Please show all the details.

Please use Excel to complete the question, give the details. Thank you!

Please use Excel to complete the question, give the details. Thank you!

Business math question, use Excel to complete it. Please show all the details. Here is an o'er by a car dealer: $69.53 weekly (plus tax) for 84 months at 0.99% Assume the actual payment (after tax) covers all costs for the car. (a) Calculate the actual payment (after the tax is added, tax rate is 15%), and use it to determine that actual price paid for the car (after fees and taxes); that is, the car loan. (b) The ne print lists the car with an MSRP of $21,198, eight and delivery fees of $1,350, (unlisted) dealer fees, and taxes (15%). How much are the dealer fees? (c) Construct the amortization table for the actual car loan. ((1) Suppose you get tired of the car and would like to trade it in for a new one at the end of the third year. Surprisingly, the car maintained its value relatively well and you can get $13,500 for it. You decide to pay your bank the $1,500 penalty and pay off the remainder of the loan. What is the out-ofpocket cost for the 3 years of ownership

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 Accounting Questions!