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

Fantastic news! We've Found the answer you've been seeking!

Question:

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 clearly label your answers to parts a, b, and c.)

a. How much do you need to deposit in an account today, if you want to have $30,000 in the account in 5 years, assuming the account earns 8% interest rate annually?

b. If you deposit $22,000 in the account today, what rate of interest would you need to earn annually in order to have exactly $30,000 in the account in 5 years?

c. Assuming your account earns 0.5% interest rate every month, and that you make an initial deposit of $10,000 today, how much do you need to deposit every month in your account in order to have exactly $30,000 in 5 years? (Hint: use the PMT variable to represent the monthly deposit; make sure you use the number of months for the number of periods.)