Question

An A&E firm planning for a future expansion deposited $30,000 each year for 5 years into...

An A&E firm planning for a future expansion deposited $30,000 each year for 5 years into a sinking (investment) fund that was to pay an unknown rate of return. If the account had a total of $450,000 immediately after the fifth deposit, what rate of return did the company make on these deposits? The rate of return that the company made was ____%.

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

Future value = Annual deposit x F/A(r%, N)

450,000 = 30,000 x F/A(r%, 5)

Using excel, Rate of Return is computed as follows.

Future Value (FV) ($) = 4,50,000
Annual deposit (PMT) ($) = -30,000
Number of years (NPER) = 5
Rate of Return = 57.07%

畜 E 315 HomePage Layout Formulas t Review View ovaPDF Cut Calibri E Copy Paste FFormat Painter B 1 u▼田 Or▼A |三三|但坦 困Merge & Center▼ | Clipboard Font Alignment A4 | Rate of Return = 1 Future Value (FV) ($) 2 Annual deposit (PMT) (S) 3 Number of years (NPER)5 4 Rate of Return - 450000 30000 RATE(B3,B2,,B1)

Add a comment
Know the answer?
Add Answer to:
An A&E firm planning for a future expansion deposited $30,000 each year for 5 years into...
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
  • An A&E firm planning for a future expansion deposited $40,000 each year for 5 years into...

    An A&E firm planning for a future expansion deposited $40,000 each year for 5 years into a sinking (investment) fund that was to pay an unknown rate of return. If the account had a total of $451,000 immediately after the fifth deposit, what rate of return did the company make on these deposits? The rate of return that the company made was %

  • An A&E firm planning for a future expansion deposited $38,000 each year for 5 years into...

    An A&E firm planning for a future expansion deposited $38,000 each year for 5 years into a sinking investment fund that was to pay an unknown rate of return. If the account had a total of $455,000 immediately after the fifth deposit, what rate of return did the company make on these deposits? 30.11 The rate of return that the company made was [ 1%

  • n A&E firm planning for a future expansion deposited $44,000 each year for 5 years into...

    n A&E firm planning for a future expansion deposited $44,000 each year for 5 years into a sinking (investment) fund that was to pay an unknown rate of return. If the account had a total of $457,000 immediately after the fifth deposit, what rate of return did the company make on these deposits? The rate of return that the company made was 7%

  • please I want only the answer without the solution please An ASE form planning for a...

    please I want only the answer without the solution please An ASE form planning for a future expansion deposited $30.000 each year for 5 years into a sinking investment fund that was to pay an unknown rate of return the account had a total of $450.000 immediately after the fifth deposit what rate of retum did the company make on these deposits? The rate of return that the company made was

  • 6,7 pls 6. A person deposits $1,000 in an account each year for five years beginning...

    6,7 pls 6. A person deposits $1,000 in an account each year for five years beginning at the end of year 1). At the end of the fifth year (immediately after the deposit), one half of the account balance is withdrawn. $2,000 is deposited annually for five more years (starting at the end of year 6), and the total balance is withdrawn at the end of the 15th year. There are no additional deposits made in years 11 - 15....

  • answers only please How much must be deposited at the beginning of each year an account...

    answers only please How much must be deposited at the beginning of each year an account that pays 7%, compounded annually so that the account will contain $32,000 at the end of 5 years? (Round your answer to the nearest cent) $ Need Help? What is the size of the payments that be deposited at the beginning of each 6-month period in an account that pays 5.2%, compounded semiannually, so that the account will have a future value of $140,000...

  • 3) Asad is planning for the future and deposits $5,000 into an investment account that earns...

    3) Asad is planning for the future and deposits $5,000 into an investment account that earns a 11% annual return. Bob hears about this great investment and plans to invest in it as well. But Bob has spent all his money on tattoos, junk food, and games for his PS4. So it takes a year of saving before Bob can deposit $5,000 in the investment account. Ten years from today, how much money will Asad and Bob have in their...

  • Raven’s parents wanted to help her with college expenses. When she was born they deposited $4,000...

    Raven’s parents wanted to help her with college expenses. When she was born they deposited $4,000 into an account that paid 4% compounded annually. They continued to make annual deposits into the account, decreasing the amount by $200 each subsequent year. They made the last deposit at the end of year 10. At the end of year 13, Raven’s parents deposited $3,000 into the account. After high school, Raven waited a bit before starting school. When she began college at...

  • (Future value of an annuity) Upon graduating from college 35 years ago, Dr. Nick Riviera was...

    (Future value of an annuity) Upon graduating from college 35 years ago, Dr. Nick Riviera was already planning for his retirement. Since then, he has made deposits into a retirement fund on a quarterly basis in the amount of $300. Nick has just completed his final payment and is at last ready to retire. His retirement fund has earned 8 percent compounded quarterly. Use five decimal places for the periodic interest rate in your calculations. a. How much has Nick...

  • Q4 (20 pts): At the end of each year, an investor deposits $200 into a fund....

    Q4 (20 pts): At the end of each year, an investor deposits $200 into a fund. The same amount is deposited each year, and after 4 years, the account contains $2,000. Estimate the rate of return of this investment. (Use linear interpolation)

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