Make your own free website on Tripod.com

  Savings Worksheet

  This worksheet will help you determine the monthly payment necessary, to
  save for an item, depending on the following variables:
  The values below are for example purposes only .
  Replace them with your own values.


(1) Enter the cost of an item you wish to purchase.

(2) Enter the annual percentage increase in cost for the item(usually 3%).

(3) Enter number of years you wish to set aside for saving.

(4) Enter your tax rate.

(5) Expected annual return on the short-term investment you've chosen.

(6) Lump-sum amount that you can set aside now.

(7) Choose a monthly savings factor from the chart below.

  Monthly savings required is


Savings Factor
Clicking on the number displays the Savings Factor in field 7.
Expected Return

6.00

6.25

6.50

6.75

7.00

7.25

7.50

7.75

8.00

12 mos.








18 mos.








24 mos.








30 mos.








36 mos.








42 mos.








48 mos.








54 mos.








60 mos.