Within Cashflow Data, users can run a Deal Cashflow report. With this template, a user can customize their view of projected cash flows for the deal, including collateral, bond-related fields, and bond steps, which are steps from the waterfall. This report will show collateral and bond fields by default.
When creating a new Deal Cashflow report, the user can customize the report by choosing which sections to include, which scenario to execute, from which date this report will be generated, and whether to display the historical data, projected data, or both.
Report Sections:
To customize the reports sections, click on "Choose Reports Sections."
Note: The sections will update accordingly based on the collateral within the deal.
The user can also configure the specific fields that will be shown in the report by clicking on the "Report Field Configuration" drop-down. The fields can be manually searched or narrowed down by the Category drop-down list (which will also be updated by the collateral type).
By clicking on a field, the user can see the description of the field below.
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.
Report 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, and First Interest Payment Date for reports that include Bonds. 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 it is provided. Historical data is displayed as given but taken into account in future projections.
The Report:
Once clicking "Generate", the Report will be displayed with the parameters chosen.