finance management

posted by .

John Roberts has $42,180.53 in a brokerage account, and he plans to contribute an addtional $5,000.00 to the account at the end of the year. the brokerage account has an expected annual return of 12%. If John's goal is to accumulate $250,000.00 in the account, how many years will it take John to reach his goal?

  • finance management -

    An Excel spreadsheet is very good for these types of problems.

  • finance management -

    It may help if I knew how to do the equation.

  • finance management -

    In year 0, he has B0=42,180.53
    In year 1, he has B1=B0*1.12 + 5000.
    In year 2, he has B2=B1*1.12 + 5000.
    Continue until Bn >= 250000.

Respond to this Question

First Name
School Subject
Your Answer

Similar Questions

  1. Finance

    John Roberts has $42,180.53 in a brokerage account, and he plans to contribute an additional $5,000 to the account at the end of every year. The brokerage account has an expected annual return of 12 percent. If John’s goal is to …
  2. finance

    John Roberts has $42,180.53 in a brokerage account, and he plans to contribute an additional $5,000 to the account at the end of every year. The brokerage account has an expected annual return of 12 percent. If John’s goal is to …
  3. Finance

    Mary just deposited $33,000 in an account paying 7% interest. She plans to leave the money in this account for eight years. How much will she have in the account at the ned of the seventh year?
  4. Finance

    john deposited 3000 into an account with 5% annual interest rate compounde quarterly at the beginning of 2011. the bank guarantees that 5% annual interest rate for the next 10 years if john deposits 3000 every two years. assume that …
  5. finance

    You currently have $22,500 in your retirement account. What annual rate of return will you need to make on your investment in order to have $1,000,000 in the account on your 60th birthday?
  6. Finance

    You are planning to save for retirement over the next 35 years. To do this, you will invest $770 a month in a stock account and $370 a month in a bond account. The return of the stock account is expected to be 9.7 percent, and the …
  7. Engineering Econonmy

    You decide to open an IRS-approved retirement account at your local brokerage firm. Your best estimate is that it will earn 9 percent. At the end of each year for the next 25 years, you will deposit $4000 per year into the account …
  8. Finance

    You are planning to save for retirement over the next 15 years. To do this, you will invest $1,100 a month in a stock account and $500 a month in a bond account. The return on the stock account is expected to be 7%, and the bond account …
  9. Finance

    You are planning to save for retirement over the next 15 years. To do this, you will invest $1,100 a month in a stock account and $500 a month in a bond account. The return on the stock account is expected to be 7%, and the bond account …
  10. Math / Finance

    You are planning to save for retirement over the next 15 years. To do this, you will invest $1,100 a month in a stock account and $500 a month in a bond account. The return on the stock account is expected to be 7%, and the bond account …

More Similar Questions