# Bus. Math

posted by
**julie** on
.

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.