Question

15. You would like to have a balance of $600,000 at the end of 15 years...

15. You would like to have a balance of $600,000 at the end of 15 years from monthly savings of $900. If your returns are compounded monthly, what is the APR you need to meet your goal?

Enter your response as a regular percentage rate, rounded to the nearest first decimal. Do not enter dollar signs, percent signs, or commas.

For example, if you calculated the decimal 0.0489, you would enter for your answer, 4.9. Or if you calculated 12.56%, you would enter 12.6.

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

Annual rate of percentage is calculated using the RATE function:-

=RATE(nper,pmt,pv,fv)

=RATE(15*12,-900,,600000)*12

=15.0%

Add a comment
Know the answer?
Add Answer to:
15. You would like to have a balance of $600,000 at the end of 15 years...
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
  • Your financial advisor recommends buying 500 US corporate bonds currently trading at $882.18 and maturing in...

    Your financial advisor recommends buying 500 US corporate bonds currently trading at $882.18 and maturing in exactly 16 years. This is a typical US corporate bond paying a $60 coupon. What is the YTM on this bond? Enter your response as a regular percentage rate, rounded to the nearest first decimal. Do not enter dollar signs, percent signs, or commas. For example, if you calculated the decimal 0.0489, you would enter for your answer, 4.9. Or if you calculated 12.56%,...

  • You are saving up to retire in 26 years. If you would like to have $1,531,991...

    You are saving up to retire in 26 years. If you would like to have $1,531,991 when you retire and if you think you can earn 11.79% per year on average, how much will you have to deposit each week to meet your goal? Enter only numbers and decimals in your response. Round to 2 decimal places. Use your financial calculator.

  • Suppose you have $22,000 today. You would like to be able to buy a car that...

    Suppose you have $22,000 today. You would like to be able to buy a car that will cost $43,300 in 10 years. What annually compounded interest rate would you need to earn in order to be able to buy the car? Enter your answer as a percentage rounded 2 decimal places. Do not enter the % sign. Enter your answer below. Number Find the value of the following: [ (1.1)9–1] 0.1 1,220 Enter your response below, rounded to two decimal...

  • 1) (3 pts) Bob would like to have a total savings of $30,000 in 6 years...

    1) (3 pts) Bob would like to have a total savings of $30,000 in 6 years to use as a down payment on a future house purchase. He has no money saved up now, but plans on depositing $350 per month at the end of every month to save for this goal. What is the periodic interest rate Bob must earn to reach his goal? What is the Annual Percentage rate? 1 Periodic *.ㅡ I Nominal (APR)- % 2) (3...

  • An m ent will pay you 121.200 in 15 years. The stated Werest rate is 125...

    An m ent will pay you 121.200 in 15 years. The stated Werest rate is 125 APR rest is compounded continuously what is the present Enter your response below rounded to two decimal places Number Out & Beck Question MacBook Air

  • If you wish to have a comfortable retirement 25 years long by withdrawing $2000 a month...

    If you wish to have a comfortable retirement 25 years long by withdrawing $2000 a month from an account earning 3% APR compounded monthly. What approximate rate of return rounded to two decimals would you need in the accumulation phase (savings) if you deposit $300 a month in an account compounded monthly for 40 years?

  • In 4 years you would like to have $5141 for a down payment for a car....

    In 4 years you would like to have $5141 for a down payment for a car. The local bank is paying 2% interest, compounded annually. How much would you need to deposit today to reach your goal of $5141? Enter your answer as follows: 1234 Round your answer. Do not use a dollar sign("$", a comma(" or any decimal points(")

  • You would like to have $35,000 to spend on a new car in five years. You...

    You would like to have $35,000 to spend on a new car in five years. You open a savings account with an APR of 4%. How much must you deposit each quarter to reach this goal?

  • Question 8 Not yet answered Marked out of 1 You would like to save up for...

    Question 8 Not yet answered Marked out of 1 You would like to save up for a deposit of $30,000 to buy a home in exactly 9 years. You can invest your savings at an interest rate of 4.3% per year (compounded yearly) Calculate the amount that you must save at the end of each year for the next 9 years to have enough savings for this deposit. Your answer should be to the nearestdollar and you should not include...

  • Question 8 Not yet answered Marked out of 1 You would like to save up for...

    Question 8 Not yet answered Marked out of 1 You would like to save up for a deposit of $30,000 to buy a home in exactly 9 years. You can invest your savings at an interest rate of 4.3% per year (compounded yearly) Calculate the amount that you must save at the end of each year for the next 9 years to have enough savings for this deposit. Your answer should be to the nearestdollar and you should not include...

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