# finance management

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?

1. 👍 0
2. 👎 0
3. 👁 140
1. An Excel spreadsheet is very good for these types of problems.

1. 👍 0
2. 👎 0
2. It may help if I knew how to do the equation.

1. 👍 0
2. 👎 0
posted by cj
3. 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.

1. 👍 0
2. 👎 0

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

asked by tippy on January 22, 2008
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

asked by nora on December 19, 2007
3. ### math

John's specialty store uses a perpetual inveentory system. the following are some inventory transaction for the month of may 2009. John's purchased merchandise on account for \$5,000. Freight charges of \$300 were paid in

asked by Bobbi Loffredo on March 19, 2011
4. ### accounting

John wants to dissolve his business.His balance sheet shows assets with a value of \$250,000 in total. Liabilities are shown at 200,000 leaving equity of \$50,000 for John.He only expects to get \$180,00,000 for his assets when he

asked by Matt on March 30, 2010
5. ### accounting

John's specialty store uses a perpetual inveentory system. the following are some inventory transaction for the month of may 2009. John's purchased merchandise on account for \$5,000. FREIGHT CHARGE OF \$300 WERE PAID IN CASH.

asked by Marty on November 28, 2010
6. ### 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?

asked by Unknown on April 27, 2010
7. ### finance

Mrs. Kay who is 24 years old plans to retire at the age of 60. Mrs. Kay would like to be able to withdraw \$120,000 per year from her retirement account for 40 years after retirement beginning a year after her retirement. She

asked by julia on April 17, 2013
8. ### Personal 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 end of the seventh year? Mary and Joe would like to save up

asked by Linda on March 23, 2010
9. ### Math

Luis has \$150,000 in his retirement account at his present company. Because he is assuming a position with another company, Luis is planning to "roll over" his assets to a new account. Luis also plans to put \$3000/quarter into the

asked by Terri on April 29, 2012
10. ### math

john told raquel that if he spent up to \$30 from his saving account, his savings account would have 3/4 as much in it as it has now. From John's statement, raquel can deduce that the least amount of money that john could have in

asked by jordyn on February 25, 2015

More Similar Questions