Main Menu | Reporting | My Reports | Select Group Filer (Advanced Inc. Shock) and Edit
The Projected Financial Statement report will provide a view of the General Ledger 12 months from the processing date for a given scenario using average or ending balances.
The following screen displays the system parameters that can be customized by the bank.
There are two system parameters for these reports which can be changed by the user:
Parameter 1: Scenario - The default scenario is +-0. Seven shock scenarios are available. If you change this parameter, you may need to change the header to show the appropriate scenario you're using. The report also displays the data source in the upper left hand corner which shows the scenario used for the report.
Parameter 2: Bal_Type - Select Average(Avg.) or Ending(End.). This parameter pertains to the balance sheet side of the General Ledger. The Income side will always use ending balances. The report will print which balance type you have selected in the upper right hand area, above the date columns.
The report prints in two groups. The first group is a complete Financial Statement for the first projection year, i.e. Month 1 - 12 from the current capture month. The second group is the same Financial Statement for the second projection year, i.e. Month 13 - 24 from the current capture month.
Calculations
Balance Sheet Accounts:
| • | Date columns contain respective month's Average Monthly Balances for the account (AVG) or Ending Monthly Balances (END) |
| • | Data is displayed in thousands of dollars. |
| • | The Total column is the average for the 12 months shown |
Income Statement Accounts:
| • | Date columns contain respective month's Ending Monthly Balances for the account |
| • | Data is displayed in dollars. |
| • | The Total column is the summation of the 12 months shown |