Question

Using Excel: Your goal is to have $5,000 in five years from now, and your mother...

Using Excel: Your goal is to have $5,000 in five years from now, and your mother help to get started and give you $500 now. From your income you plan to make five additional deposits, one at the end of each year. The first deposit from your money is made at the end of the first year. If you deposit the money in a bank that pays 7% interest, how much must your annual deposit be.

Homework Answers

Answer #1

ANSWER:

Below is the excel sheet.
year 0 1 2 3 4 5
initial deposit from mother 500
annual deposit 747.51 747.51 747.51 747.51 747.51
cash flows 500 747.51 747.51 747.51 747.51 747.51
future value $701.28 $979.83 $915.73 $855.82 $799.84 $747.51
total future value $5,000.01

in excel we will solve via trial and error as the total future value has to be $5,000 at the end of 5 years as given in the question.

future value is calculated in excel using the fv function.

=-fv(rate,nper,pmt,pv,type)

for year 0 future value

=-fv(7%,5,,500) = $701.28

similarly for year 1

=-fv(7%,4,,747.51) = $979.83

the value in the annual deposit will be changed manually so the total future value comes up to $5,000.

The correct answer is $747.51

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
Assume that 5 years from now you will need RM2000. Your bank compounds interest at a...
Assume that 5 years from now you will need RM2000. Your bank compounds interest at a 6% annual rate. b. If you want to make equal payments at the end of Years 1 through 5 to accumulate the RM2,000, how large must each of the 5 payments be? c. If your father were to offer either to make the payments calculated in part (b) or to give you a lump sum of RM1,050 one year from now, which would you...
1. You would like to have $50,000 in 15 years. To accumulate this amount you plan...
1. You would like to have $50,000 in 15 years. To accumulate this amount you plan to deposit each year an equal sum in the bank, which will earn 7% interest annually. Your first payment will be made at the end of the year. o How much must you deposit annually to accumulate this amount? o If you decide to make a large lump-sum deposit today instead of the annual deposits, how large should this lump-sum deposit be? o At...
Your goal is to have $7,500 in your bank account by the end of 12 years....
Your goal is to have $7,500 in your bank account by the end of 12 years. If the interest rate remains constant at 9% and you want to make annual identical deposits, how much will you need to deposit in your account at the end of each year to reach your goal? (Note: Round your answer for PMT to two decimal places.) $372.38 $335.14 $297.90 $409.62 If your deposits were made at the beginning of each year rather than an...
You want to accumulate $1 million by your retirement date, which is 25 years from now....
You want to accumulate $1 million by your retirement date, which is 25 years from now. You will make 25 deposits in your bank, with the first payment occurring today. The bank pays 8% interest, compounded annually. You expect to receive annual raises of 3% which will offset inflation, and you will let the amount you deposit each year also grow by 3% (i.e., your second deposit will be 3% greater than your first, the third will be 3% greater...
You want to have $75,000 in your savings account 12 years from now, and you’re prepared...
You want to have $75,000 in your savings account 12 years from now, and you’re prepared to make equal annual deposits into the account at the end of each year. If the account pays 6.8 percent interest, what amount must you deposit each year? How to input the formula in Excel?
Reaching a Financial Goal You need to accumulate $10,000. To do so, you plan to make...
Reaching a Financial Goal You need to accumulate $10,000. To do so, you plan to make deposits of $1,400 per year - with the first payment being made a year from today - into a bank account that pays 7.44% annual interest. Your last deposit will be less than $1,400 if less is needed to round out to $10,000. How many years will it take you to reach your $10,000 goal? Round your answer up to the nearest whole number....
You are interested in saving money for your first house.  Your plan is to make regular deposits...
You are interested in saving money for your first house.  Your plan is to make regular deposits into a brokerage account which will earn 14 percent. Your first deposit of $5,000 will be made today.  You also plan to make four additional deposits at the beginning of each of the next four years.  Your plan is to increase your deposits by 10 percent a year.  (That is, you plan to deposit $5,500 at t = 1, and $6,050 at t = 2, etc.)  How much...
You would like to have $41,000 in 15 years. To accumulate this​ amount, you plan to...
You would like to have $41,000 in 15 years. To accumulate this​ amount, you plan to deposit each year an equal sum in the​ bank, which will earn 7 percent interest compounded annually. Your first payment will be made at the end of the year. At the end of 4 years you will receive $9,000 and deposit this in the bank toward your goal of $41,000 at the end of 15 years. In addition to this​ deposit, how much must...
7. Calculate annuity cash flows Your goal is to have $20,000 in your bank account by...
7. Calculate annuity cash flows Your goal is to have $20,000 in your bank account by the end of nine years. If the interest rate remains constant at 10% and you want to make annual identical deposits, you'll have to deposit (1,325.53, 1178.25, 1767.37, 1030.97,1472.81, or 1620.09)   into your account at the end of each year to reach your goal. If your deposits were made at the beginning of each year rather than an at the end, the amount of...
1a. Your grandmother will be giving you $3,000 per year for the next four years, the...
1a. Your grandmother will be giving you $3,000 per year for the next four years, the first payment beginning at the end of the first year What is the future value of these receivables in year 4 , if the interest rate is 6%? b. Your grandmother will be giving you $3,000 per year for the next four years, the first payment beginning at the end of the first year What is the future value of these receivables in year...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT