ReesNet.com — the FINANCIAL CALCULATOR — Calculating the Savings Variables

CALCULATING THE LEVEL DEPOSIT

REQUIRED INPUTS — You must supply the following information in order to calculate the Level deposit:

(1)

Deposit plan

(2)

No. of deposits (enter as an integer [whole number], for example, 5.762793 should be entered as 6)

(3)

Annual rate (for example, 5.762793% should be entered as 5.762793)

(4)

Opening date (this will be used if you use Report Options — Savings & Investments report (remember to enter dates in the format MM/DD/YYYY)

(5)

OPTION: enter Opening balance (for example, $1,437,365.29 should be entered as 1437365.29)

(6)

OPTION: enter Future balance (for example, $129,362.36 should be entered as 129362.36)

(7)

OPTION: specify Payments/deposits at: in the Calculation & Report Options (the calculator will automatically use the option it sees displayed, so if you want to change it, do so)

NOTE - When you press the button, the Ellwood Factors are automatically updated using the information you supplied. The field to the right of the Ellwood Factors title will tell you that the source of the factors is S & I, which stands for Savings and Investments.

HOW IT WORKS

 

The Level deposit is computed from the following equation:

Level deposit = LC [ (PV)(FutureBalance) - (Opening balance) ]

For a full discussion of the functions PV and LC, refer to the articles covered by the Ellwood Factors.