Question

Derek will deposit $6,745.00 per year for 11.00 years into an account that earns 10.00%, The...

Derek will deposit $6,745.00 per year for 11.00 years into an account that earns 10.00%, The first deposit is made next year. He has $16,340.00 in his account today. How much will be in the account 40.00 years from today?

Homework Answers

Answer #1

Calculation of value of money in the account at the end of 11 years:

Rate = 10%
Nper = 11
PMT = 6745
PV = 16340

Future value can be calculated by using the following excel formula:
=FV(rate,nper,pmt,pv)
=FV(10%,11,-6745,-16340)
= $171,612.65

Calculation of value of money 40 years from today:

Rate = 10%
Nper = 40 - 11 = 29
PV = $171,612.65
PMT = 0

Future value can be calculated by using the following excel formula:
=FV(rate,nper,pmt,pv)
=FV(10%,29,0,-171612.65)
= $2,722,307.40

Value of money in the account 40 years from today = $2,722,307.40

Know the answer?
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
Similar Questions
#10 Derek will deposit $6,008.00 per year for 22.00 years into an account that earns 11.00%,...
#10 Derek will deposit $6,008.00 per year for 22.00 years into an account that earns 11.00%, The first deposit is made next year. How much will be in the account 40.00 years from today? Answer format: Currency: Round to: 2 decimal places.
Derek will deposit $5,760.00 per year for 11.00 years into an account that earns 6.00%, The...
Derek will deposit $5,760.00 per year for 11.00 years into an account that earns 6.00%, The first deposit is made next year. How much will be in the account 42.00 years from today?
Derek will deposit $3,147.00 per year for 18.00 years into an account that earns 11.00%, The...
Derek will deposit $3,147.00 per year for 18.00 years into an account that earns 11.00%, The first deposit is made next year. How much will be in the account 37.00 years from today?
1.Derek will deposit $3,788.00 per year for 14.00 years into an account that earns 12.00%. Assuming...
1.Derek will deposit $3,788.00 per year for 14.00 years into an account that earns 12.00%. Assuming the first deposit is made 6.00 years from today, how much will be in the account 33.00 years from today? 2.Derek will deposit $6,480.00 per year for 11.00 years into an account that earns 8.00%, The first deposit is made next year. He has $12,685.00 in his account today. How much will be in the account 43.00 years from today?
Derek will deposit $9,231.00 per year for 30.00 years into an account that earns 11.00%, The...
Derek will deposit $9,231.00 per year for 30.00 years into an account that earns 11.00%, The first deposit is made next year. How much will be in the account 37.00 years from today? Submit Answer format: Currency: Round to: 2 decimal places
Derek will deposit $4,576.00 per year for 15.00 years into an account that earns 10.00%. Assuming...
Derek will deposit $4,576.00 per year for 15.00 years into an account that earns 10.00%. Assuming the first deposit is made 6.00 years from today, how much will be in the account 37.00 years from today?
derek will deposit $1415.00 per year for 19 years into an account that earns 13%. The...
derek will deposit $1415.00 per year for 19 years into an account that earns 13%. The first deposit is made next year. He has $13950 in his account today. How much will be in the account 35 years from today
derek will deposit $2449 per year for 21 years into an account that earns 8% ,...
derek will deposit $2449 per year for 21 years into an account that earns 8% , the first deposit is made next year. He has $12,960 in his account today .How much will be in the account 43 years from today ?
Derek will deposit $6,593.00 per year for 26.00 years into an account that earns 14.00%, The...
Derek will deposit $6,593.00 per year for 26.00 years into an account that earns 14.00%, The first deposit is made next year. He has $12,195.00 in his account today. How much will be in the account 49.00 years from today? Answer format: Currency: Round to: 2 decimal places.
Derek will deposit $1,402.00 per year for 17.00 years into an account that earns 4.00%. The...
Derek will deposit $1,402.00 per year for 17.00 years into an account that earns 4.00%. The first deposit is made today. How much will be in the account 17.0 years from today? Note that he makes 17.0 total deposits.