Creating an Advanced Quick Forecast

An Advanced Quick Forecast is a template that allows you to enter and save forecast assumptions for all accounts and apply them each month as you upload new data to the model.

1. Select Forecasting > Advanced Quick Forecast.
   You can also find Advanced Quick Forecast listed as a forecasting technique when you select the Project option from within other Forecasting pages.
2. Select the What If model that the new template belongs to.
   Later, when you define and save the Advanced Quick Forecast, you can copy it to another model by selecting Copy.
3. Select Add to begin the process of creating a template.
4. Enter a unique template Name.
5. Select the Forecast Type.
   • All: Includes all account types in the forecast.
   • Rates Only: Allows you to create a forecast that only contains offering rates and key rates.

     You can use these forecasts as rate shock scenarios in the ALM module.

6. Select the Edit Forecast link.
7. Select the type of accounts to forecast from the Data Item drop-down list.
   • Assets/Int Inc
   • Liab & Equity/Int Exp
   • Non-Int Inc/Exp
   • Offering Rates
   • Key Rates
   • Supplemental Data

   If you are creating a Rates Only forecast, only Offering Rates and Key Rates appear in the drop-down menu.

8. Select Expand next to an account (or rate) type in the Accounts column in the grid to access detailed accounts.
9. Use the Data Item column to specify Month End or New Volume for the projection.
10. Select a projection action for every account from the Project Action column.

    As you determine a projection action, consider the following:

    • The default setting is No Change. Only those projection actions that apply to the type of accounts that you want to project display in the grid. You cannot project Calculated accounts.
    • For many actions, when projecting a parent account, there is a pro-rata distribution of values from the subtotal level down to the child account level based on the month-end balances of the child accounts.
    • For other actions, such as No Change, Flat, Grow by %, and Calculate Roll-Off, the same action at the parent level applies to all the child-level accounts. You can still individually adjust the child accounts after you project the parent account.
    • When you apply an action to a detailed account, the action only affects that single account.

    The list of possible projection actions includes:

    No Change

    The values in all projected time frames remain unchanged.

    Flat

    Values in all projected time frames remain the same as the current month or the same as the last projected month of a forecast up to a certain date.

    Grow by %

    This option projects an annualized growth on the percentage that you enter from the selected value and time frame in the grid.

    Growth % Over Last Year

    This option allows you to grow the balance at the rate that you specify while maintaining seasonal trends from the previous 12 months.

    Grow by Value

    This option uses the amount that you enter to increase or decrease all future periods.

    Add-On Value

    This option adds the amount that you enter to the existing value for all projected months.

    Calculate Roll-Off

    This option removes new volumes from the projected periods, causing the month-end balances to roll off according to the maturity schedule.

    It is available for any account when you select the Cash Flow check box in the Chart of Accounts.

    YTD Value

    This option uses the entered amount as the projected fiscal year total.

    The YTD historical amount subtracts from the amount entered in the Value column if part of the fiscal year includes historical months. The remaining amount, positive or negative, distributes evenly over the remaining months of the year.

    This technique is only available for non-interest income/expense accounts.

    Add-On YTD Value

    This option divides the amount entered by the remaining, editable time frames in the current fiscal year. It adds the calculated amount to the existing value in each of the current year's projected time frames. It does not affect monthly values in subsequent projected years.

    This technique is only available for non-interest income/expense accounts.

    Growth % on YTD Value

    This option defines a growth percentage over the previous year's year-to-date amount, and then the calculated total distributes evenly over the remaining, projected months in the year. This technique is only available for non-interest income/expense accounts.

    Zero Out

    This option resets targeted account values in all their projected time frames to zero.

    It is available for any account when you set the Cash Flows to No, as well as for non-interest income/expense, offering rates, key rates, and supplemental data.

    Target Value

    This option allows you to specify a date to achieve a target amount. It applies a straight-line growth assumption to all time frames between the beginning and ending dates.

11. Specify a percentage or an amount in any projection actions that require it in the editable field that appears in the Value column.
12. Use the Time Frame column to either apply the default All Remaining setting or specify an end date for an action.

    The default All Remaining setting appears if a single projection action applies to an account.

    When specifying an end date for an action, the application adds another line for the account automatically with a Flat projected action for all the remaining time frames.

13. Continue working through the account lists until you have applied assumptions to all the necessary accounts.
    No changes occur to any other accounts with the default Project Action of No Change.
14. Select Save, and then select Back to return to the initial Advanced Quick Forecast page.
15. Apply the saved projection template.
    1. Select whether you want to run the template immediately or later.
       Specify a date and time if you want to schedule when to run the forecast.
    2. Select the organizations that you want the forecast to apply to.
    3. Select Run or Schedule depending on your Run Forecast setting.

To remove a Quick Forecast permanently from the list, select Delete next to the forecast's name. Use to reposition the forecasts if more than one Quick Forecast exists.