finance management
posted by cj .
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?

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

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

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
Similar Questions

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 … 
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 … 
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? 
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 … 
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? 
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 … 
Engineering Econonmy
You decide to open an IRSapproved 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 … 
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 … 
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 … 
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 …