Entering Forecast Assumptions

You can enter forecast assumptions at the summary and/or detailed account level on the Forecasting Detail page.

To watch a training video that explains this process, enroll in the FPS Distributed Forecasting - How to Forecast Your Budget training video course on Jack Henry University. You can also enroll in the Distributed Forecasting in Financial Performance Suite learning plan.
You can choose to enter forecast assumptions at the summary level, at the detailed account level, or a combination of the two. Summary-level forecasted values and assumptions filter down to the detailed accounts.
  1. Select Forecasting > Detail from the menu.
  2. Select a What If model from the drop-down list.
    These options can be predefined based on your user permissions.
  3. Select the Organization that the forecast applies to.
    These options can be predefined based on your user permissions.
  4. Select the time frames to show while forecasting in the Select Time Frames dialog box, and then select Apply.
  5. Select the Account Type that you want to forecast.
    You can select Assets/Interest Income, Liabilities & Equity/Interest Expense, or Non-Interest Income Expense.
  6. Use the expand option next to Account Type to select detailed accounts based on the selected type.

    Applying forecast assumptions at the subtotal level includes the accounts that add into the subtotal.

    You can switch the Show GL # option to On to view this information for accounts that include it. You can also use the Filter option to narrow the results.

  7. Select the value/time frame in the forecasting grid that you want to use as a base value for the forecast in the account that you are working with.

    Typically, your selection is the current month-end balance or the column highlighted in yellow. When you select a current month time frame, a light blue highlight appears around the cell.


    Forecast Assumptions Month-End Balance.

    You can choose to select the appropriate value/time frame and enter a value manually as the base value for the forecast of that account.

  8. Select a Project option from the drop-down list to choose and apply your forecast technique to the account after selecting the account and starting value/time frame.
    CAUTION:
    The Basic Quick Forecast and Advanced Quick Forecast techniques are not recommended for end-user forecasting.
    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.
    YTD Value

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

    The YTD historical amount is subtracted 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/expenses, offering rates, key rates, and supplemental data.

    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.

    Target Value
    This option allows you to specify a date to achieve a target amount. It applies a straight-line growth assumption to all the time frames between the beginning and ending dates.
    Tip: In addition to the provided forecasting actions, you can enter values into the forecast manually, or copy and paste from a spreadsheet.
Parent topic: Distributed Forecasting Training Videos - End User Tasks