The loan Cashflow report presents users with the cash flows for the amortization of the loans in the Deal.
Scenarios:
The user can choose which scenario will be executed on this Report.
All scenarios defined under the Scenarios tab will appear in the drop-down.
As of Date:
The user can choose which date the report will be displayed from. This allows the user the ability to examine the deal from various points in time.
The earliest date available is the Cut-Off Date - for reports that include collateral. The user has the option to choose whether to show the Historical data, Projected data or both.
Historical data is only available in deals where they were provided. Historical data is displayed as given and not manipulated but considered in future projections.
The Report:
Once generating the Report, the user can use the buttons located at the top right which are shown in the visual below. These six icons allow the user to save the table, export to Excel, Refresh the table in case there are changes in other sections, Edit the table, mimimize the table or Delete it.
The user can also change the Scenario by clicking on the name on the top left then clicking refresh.
The user can also change the As of Date on the top left next to the Scenario name and then refresh.
Total Payments Under Loan Cashflow Report:
Use the following calculations to calculate "Total Payments" under Loan Cash Report:
| Total Payment | Net Interest + Principal + Total Penalty |
| Total Penalty | Prepayment Interest + Penalty |
| Principal | Scheduled Principal + Prepayment + Recovery |
| Net Interest | Interest = Fee |