Example
Calculate the account value in 20 years with monthly deposits of $100 occurring during the first 10 years, increasing annually by 2% per year. Assume a 6% rate of return.
Data Entry
Use the following values for the prompts:
Prompt |
Value |
|
Calculation Type |
Accumulation |
|
Calculate |
Projected Value |
|
Current Account Value |
0 |
|
Interest Rate |
6% |
|
Number of Years |
20 |
|
Deposits per Year |
12 |
|
Amount of Each Deposit |
100 |
|
Type of Deposits |
Annual Increase by a % |
|
Annual Increase in Deposit |
2 |
|
Deposits Made at |
Beginning of Period |
Be sure the "Grid" tab is selected on the right, and then enter zeros ('0') in the Annual Deposits column for years 11 through 20.
| Note: | If the check box Carry Values Down Column is marked (found below the grid), after editing the value for year 11, the entered value (zero) will be carried down for all subsequent years. |
Result
Calculated Projected Value shows $31,711.60.
