Projected Value of Increasing Deposits with a Break in Deposits
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.
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. 
Calculated Projected Value shows $31,711.60.