Bus. Math

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.

  1. 👍 0
  2. 👎 0
  3. 👁 125
asked by julie

Respond to this Question

First Name

Your Response

Similar Questions

  1. math

    How much money would have to be deposited into a compound interest savings account earning 5% each year in order to accumulate $10,000 in 18 years?

    asked by Don on February 23, 2013
  2. math

    The Derr-McGee Manufacturing Company plans to build a new $50,000 warehouse seven years from now. They plan to accumulate the $50,000 in an account before beginning construction. If money is worth 7% compounded annually, how much

    asked by anonymous## on August 1, 2011
  3. MATH

    Please help check my answers to make sure they are correct. I used the "sinking fund payment and present value of an ordinary annuity" formulas to solve this story problem. Thanks! Story: Naomi Dexter is 20 years old. She decides

    asked by April on March 6, 2011
  4. Math

    Please help check my answers to make sure they are correct. I used the "sinking fund payment and present value of an ordinary annuity" formulas to solve this story problem. Thanks! Story: Naomi Dexter is 20 years old. She decides

    asked by April on March 7, 2011
  5. math

    I am reviewing for my final exam on December 11. I'm working on a practice sheet and I want to know if my answers are correct. 1) Find the equation of the line passing through the points (1,3) and (5,2). Put into slope-intercept

    asked by lijm on November 25, 2019
  6. math

    if naomi wants to accumulate 1,000,000 by investing money every year into her savings account at 3% for 30 years until retirement,how much does she need to deposit each year

    asked by darryl on June 12, 2010
  7. Finance

    Your Uncle has two alternative inheritence for you. A. You receive 5000 today and 1000 per year for the next 8 years. or B. 5000 today and nothing each year for the next 7 years and at end of 8th year receive 12,000 Which is best

    asked by Antoinette on March 18, 2007
  8. Calc

    A person deposits money into a retirement account, which pays 7% interest compounded continuously, at a rate of $1000 per year for 20 years. Calculate: a. The balance of the account at the end of 20 years b. the amount of money

    asked by James on April 8, 2008
  9. Math

    Please check my work, thank you If $7,800 is deposited into an account paying 6% interest compounded annually (at the end of each year), how much money is in the account after 2 years? A=$8,268.00 Rewrite the statement, using

    asked by Terry B on April 6, 2008
  10. Fin- Management

    David purchased a $100,000 participating whole life policy. The annual premium is $2,280. Projected dividends for the first 20 years are $15,624. The cash value after 20 years will be $35,260. If the premiums were invested at 5

    asked by KEVIN on January 13, 2011

More Similar Questions