Question

You are considering the purchase of a brand new Mercedes car but are worried about the...

You are considering the purchase of a brand new Mercedes car but are worried about the maintenance cost of the car relative to other cars. You plan to keep the car for 10 years and have done some online research that seems to indicate that the cost of maintain the car will be $500 in the first year and increase on average by 5% per year. If you wanted to have a fund that would cover the maintenance costs, how much money will you need to deposit in the fund today to cover the maintenance costs for the next 10 years. Assume your fund earns 7% interest. <include a cash flow diagram>

0 0
Add a comment Improve this question Transcribed image text
Answer #1

ANSWER:

All the calculations have been done in excel as the diagram couldn't be uploaded due to some technical problem.

year 0 1 2 3 4 5 6 7 8 9 10
maintenance cost 500 525 551.25 578.8125 607.7531 638.1408 670.0478 703.5502 738.7277 775.6641
present worth $4,298.81

in excel we will use the npv function.

=npv(rate,cash flow from year 1 to year 10)

=npv(7%,500,525,551.25,578.8125,607.7531,638.1408,670.0478,703.5502,738.7277,775.6641)

=4,298.81

so the fund that needs to cover the maintenance costs is $4,298.81

Add a comment
Know the answer?
Add Answer to:
You are considering the purchase of a brand new Mercedes car but are worried about the...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • When you purchase a car, you may consider buying a brand-new car or a used one....

    When you purchase a car, you may consider buying a brand-new car or a used one. A fundamental tradeoff in this case is whether you pay repair bills (uncertain at the time you buy the car) or make loan payments that are certain. Consider two cars, a new one that costs $15,000 and a used one with 75,000 miles for $5,500. Let us assume that your current car’ s value and your available cash amount to $5,500, so you could...

  • After deciding to buy a new Mercedes-Benz C Class sedan, you can either lease the car...

    After deciding to buy a new Mercedes-Benz C Class sedan, you can either lease the car or purchase it on a three-year loan. The car you wish to buy costs $35,000. The dealer has a special leasing arrangement where you pay $99 today and $499 per month for the next three years. If you purchase the car, you will pay it off in monthly payments over the next three years at a 6 percent APR compounded monthly. You believe you...

  • After deciding to buy a new Mercedes-Benz C Class sedan, you can either lease the car...

    After deciding to buy a new Mercedes-Benz C Class sedan, you can either lease the car or purchase it on a three-year loan. The car you wish to buy costs $35,000. The dealer has a special leasing arrangement where you pay $99 today and $499 per month for the next three years. If you purchase the car, you will pay it off in monthly payments over the next three years at a 6 percent APR compounded monthly. You believe you...

  • Irene just purchased a new sports car and want to also set aside cash for future maintenance expenses. The car has...

    Irene just purchased a new sports car and want to also set aside cash for future maintenance expenses. The car has a bumper-to- bumper warranty for the first five years. Irene estimates that she will need approximately $2000 per year in maintenance expenses for years 6-10, at which time she will sell the vehicle. How much money should Irene deposit into an account today, at 8% per year, so that she will have sufficient funds in that account to cover...

  • You are an engineer Disney World. You expect one of your brand new major attractions will...

    You are an engineer Disney World. You expect one of your brand new major attractions will begin having significant maintenance expenses starting at the end of year 4 with a $60,000 expense. This maintenance expense will increase by $4,000 each year after this inital year 4 expense through the end of year 8. How much money would you have to invest today into an account paying 3% interest compounded annually to completely cover all future maintenance costs for this attraction?

  • Solve it by using DecisionTools software When you purchase a car, you may consider buying a...

    Solve it by using DecisionTools software When you purchase a car, you may consider buying a brand-new car or a used one. A fundamental trade-offin this case is whether you pay repair bills (uncertain at the time you buy the car) or make loan payments that are certain. Consider two cars, a new one that costs $15,000 and a used one with 75,000 miles for $5,500. Let us assume that your current car's value and your available cash amount to...

  • 1. You set up a college fund in which you pay $2500 each year at the...

    1. You set up a college fund in which you pay $2500 each year at the end of the year. How much money will you have accumulated in the fund after 10 years, if your fund earns 13% compounded annually? Your Answer: 2. Lauren knows she can afford to make monthly payments of $300 for 36 months. How much will the bank lend her today on a 3% APR car loan in exchange for her promised monthly payments? Your Answer:...

  • 4-54 It is estimated that the maintenance cost on a new car will be $500 the...

    4-54 It is estimated that the maintenance cost on a new car will be $500 the first year. Each subsequent year, this cost is expected to increase by $150. How much would you need to set aside when you bought a new car to pay all future maintenance costs if you planned to keep the vehicle for 10 years? Assume interest is 5% per year.

  • Assume that you want to buy a new car in 5 years, and that the price...

    Assume that you want to buy a new car in 5 years, and that the price of the car will be $30,000. (Assume all cash flows occur at the end of the period throughout all of the Excel problems throughout our entire course.) Use Excel time value of money functions to solve the problems outlined below (one or more of these: PV, FV, RATE, NPER, PMT) (This question doesn't require a text box with written answers, but you need to...

  • You would like to purchase a car in 3 years and expect it will cost $35,000....

    You would like to purchase a car in 3 years and expect it will cost $35,000. You have access to an investment account that earns 10%, compounded annually. How much must you put in the account today?

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT