Time Value of Money Problem

You would like to buy a new car in five years for cash. The price of the car today is $56,000 and you expect that the price will increase by 6% per year. You plan to save for this car starting today with a deposit in your savings account, which currently has a balance of $1,800 and earns 4% compounded annually.

You know that you will be receiving an inheritance of $3,500 three years from today, which you will deposit in your savings account for the car. If you make a deposit every month for the next five years beginning one month from today, how much will the deposit have to be in order for you to be able to pay cash for the car?

Required:

Complete the assignment using the formulas embedded in Excel and/or a financial calculator. Include an Excel document that shows your calculations.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s