Answered step by step
Verified Expert Solution
Link Copied!
Question
1 Approved Answer

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!

image text in transcribed
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

Step: 1

blur-text-image
Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Microsoft Excel For Accounting The First Course

Authors: L Murphy Smith, Katherine Smith

1st Edition

0130085529, 978-0130085528

More Books

Students explore these related Accounting questions