An Amount Step series generates a series of amounts that increase or decrease by a fixed dollar amount after a specified number of payments. This is sometimes referred to as a dollar step series.
To enter payments that increase or decrease by a set amount
- From the Detail group on the Home ribbon, click the Special Series menu button.
Tip: You could also press [F2] from the Amount field of a cash flow line.
- Select Amount Step from the drop-down menu. The cash flow line will expand to include the Special Series detail.
- Enter the first payment amount in the Starting amount field. If the first payment amount is unknown, type [U].
- Enter the change amount in the Amount change per level field. For example, if you want the payment amount to increase by $100 after twelve payments, enter 100 here. If you want it to decrease, precede it with a minus (-) sign.
- Enter the number of payments that occur before each change in the Number made before change field. For example, if you want twelve payments and then an increase, enter 12.
After editing the series detail, you can continue on to the Number field by pressing [Tab]. TValue will automatically calculate the payment amounts when the amortization schedule is prepared.
Example screenshots
Cash Flow Matrix
Amortization Schedule Report
