# 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.

## 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