Posted by **julie** on Thursday, November 2, 2006 at 11:25am.

How much money should be deposited each year for 30 years at 3% to accumulate $1000,000?

I find that an EXCEL spreadsheet is very helpful for these kinds of problems.

If one deposits an amount P, growing for 30 years, the amount will grow to P*(1.03)^30. You want to solve for P such that:

P*1.03^30 + P*1.03^29 + ... P*1.03^1 = 1,000,000. Factor out the P, use EXCEL to calculate the sumation series, divide the 1M by the sumation and tada, you have your answer.

## Answer This Question

## Related Questions

- Math - A person wants to establish an annuity for retirement purposes. He wants ...
- math - At the beginning of every year, a man deposited $ 10,000 in a financial ...
- math - At the beginning of every year, a man deposited $ 10,000 in a financial ...
- math - How much money would have to be deposited into a compound interest ...
- Calc - A person deposits money into a retirement account, which pays 7% interest...
- calculating annuity - IF a company will generate 80,000 in annual revenue each ...
- math - The Derr-McGee Manufacturing Company plans to build a new $50,000 ...
- Math - a company will need $30,000 IN 7 YEARS FOR AN ADDTION. TO MEET THIS GOAL ...
- MATH - A company will need 65,000 in 6 years to add an addition. to meet this ...
- Math - The winner of a popular lottery is offered one of two options: i) a lump ...

More Related Questions