Question

Suppose you want to have $500,000 by the end of 7 years. You decide to deposit...

Suppose you want to have $500,000 by the end of 7 years. You decide to deposit an equal amount of money each month (starting next month) into a bank account that advertises a nominal rate of 4% compounded monthly. How much should you deposit each month?

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

Please refer to below spreadsheet for calculation and answer. Cell reference also provided.

A B. FV I 2 3 Amount required at end 7 years APR Monthly interest rate No of monthly deposit in 7 years $500,000.00 4% 0.3333

Cell reference -

A В. FV 3 Amount required at end 7 years APR Monthly interest rate No of monthly deposit in 7 years 500000 0.04 =C3/12 =7*12

Hope this will help, please do comment if you need any further explanation. Your feedback would be highly appreciated.

Add a comment
Know the answer?
Add Answer to:
Suppose you want to have $500,000 by the end of 7 years. You decide to deposit...
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
  • 1. Suppose you accumulated $500,000, perhaps from many years of saving. You put the money in...

    1. Suppose you accumulated $500,000, perhaps from many years of saving. You put the money in a savings plan earning 6% compounded monthly. If you want to withdraw $4,000 at the beginning of each month, how long before the savings plan is exhausted? 2. Suppose you accumulated $500,000, perhaps from many years of saving. You put the money in a savings plan earning 6% compounded monthly. If you want the plan to last 40 years, how much can you withdraw...

  • Problem 1- Saving Money You want to deposit money into a bank account that pays 1.5%...

    Problem 1- Saving Money You want to deposit money into a bank account that pays 1.5% compounded monthly. Answer the following questions: f depositing $4000, how much is avaiable in the account at the end of S years? .How much do you have to deposit now in order to have $5000 available at the end of 5 years? Instead of depositing one sum of money at the beginning of the 5-year period, suppose you wish to make monthly payments. How...

  • 1. How much would you need to deposit in an account now in order to have $5000 in the account in 15 years? Assume the ac...

    1. How much would you need to deposit in an account now in order to have $5000 in the account in 15 years? Assume the account earns 5% interest compounded monthly. 2. You currently have $7,700 (Present Value) in an account that has an interest rate of 3% per year compounded quarterly (4 times per year). You want to withdraw all your money when it reaches $18,480 (Future Value). In how many years will you be able to withdraw all...

  • If you want to have $87654 in the bank at the end of 10 years and...

    If you want to have $87654 in the bank at the end of 10 years and you get a 3% interest rate per year. How much money do you need to deposit each month if a) monthly compounding? b) semi-annual compounding? a quarterly compounding? d) daily compounding?

  • You deposit $2,500 at the end of the year ( 0) into an account that pays interest at a rate of 7% compounded a...

    You deposit $2,500 at the end of the year ( 0) into an account that pays interest at a rate of 7% compounded annually. Two years after your deposit, the savings account interest rate changes to 12% nominal interest compounded monthly. Five years after your deposit, the savings account again changes its interest rate this time the interest rate becomes 8% nominal interest compounded quarterly Nine years after your deposit, the saving account changes its rate once more to 6%...

  • You deposit $3,000 at the end of the year (k = 0) into an account that pays interest at a rate of 7% compounded annually. A year after your deposit, the savings account interest rate changes to 1 2%...

    You deposit $3,000 at the end of the year (k = 0) into an account that pays interest at a rate of 7% compounded annually. A year after your deposit, the savings account interest rate changes to 1 2% nominal interest compounded month y Five years after ur de o the savings account aga changes it interest rate this time e interest rate becomes 8% nominal interest compounded quarterly. Eight years after your deposit, the saving account changes its rate...

  • Suppose you want to buy a car today. If you can afford payments of $493 per...

    Suppose you want to buy a car today. If you can afford payments of $493 per month and want to pay the loan back over the next 7 years. Assuming no down payment is required, how much can you borrow if the bank will charge you an annual percentage rate of 3% APR? (Work out the problem on separate sheet of paper before entering the answer.) Answer: Check Suppose you racked up $33317 of student loan and the interest is...

  • You deposit $1,000 at the end of the year (k = 0) into an account that...

    You deposit $1,000 at the end of the year (k = 0) into an account that pays interest at a rate of 6% compounded annually. Two years after your deposit, the savings account interest rate changes to 12% nominal interest compounded monthly. Five years after your deposit, the savings account again changes its interest rate, this time the interest rate becomes 8% nominal interest compounded quarterly. Eight years after your deposit, the saving account changes its rate once more to...

  • 21. You are about to deposit $139 into one of the following saving accounts to be left on deposit for 25 years, each ban...

    21. You are about to deposit $139 into one of the following saving accounts to be left on deposit for 25 years, each bank offers an account with a different interest rate and compounding period. Assuming you want to maximize your wealth, how much money would be in the bank account that offers the best effective rate of return after 25 years? Bank A. 9.5 percent rate compounded semi annually Bank B. 9.4 percent rate compounded monthly Bank C. 9.3...

  • For retirement planning, you decide to deposit $1,119 at the end of every quarter and increase...

    For retirement planning, you decide to deposit $1,119 at the end of every quarter and increase your deposit by $54 each quarter. How much will you have at the end of 25 years if the bank pays a nominal annual rate of 6% compounded quarterly? Enter your answer as follows: 12345 Round your answer. Do not use a dollar sign ("$"), any commas ()") or a decimal point ("").

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