If your work requires that you enter individual cash flows, you can let TValue sort them and consolidate them into a manageable series or multiple series. When you choose Compress from the Rearrange group on the Home ribbon, TValue consolidates associated cash flow lines into a series on one cash flow line. For example, if your compound period is monthly and you have six individual payment lines of the same amount on consecutive months, TValue will create a single cash flow line that specifies the series of six monthly payments.
When Compress is chosen, TValue attempts to consolidate into a series all cash flows based on the compounding period that is in effect. Any cash flow lines that cannot be consolidated into a series will be left as individual events.
Note: A Rate Change Event changes the compound period that is in effect for the cash flow lines following it.
To compress associated cash flows into a series from a single cash flow line
- Select the first cash flow line for the series.
- From the Home ribbon's Rearrange group, choose the Compress menu button.
- From the drop-down menu select This line.
To compress all cash flows for the entire schedule
- From the Home ribbon's Rearrange group, choose the Compress menu button.
- From the drop-down menu select All lines.
Tip: If you do not like the results of the Compress command, choose the Undo button from the Quick Access Toolbar or press [Ctrl]+[Z].