Project - Forecasting Techniques

The following forecasting techniques appear when you select the Project option from various Forecasting module pages. Not all techniques are available on all pages or for all accounts.

Add-On Value

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

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.

Advanced Quick Forecast

This technique is a template that allows you to enter and save forecast assumptions for all accounts, and then apply them each month as you upload new data to the model. You can save multiple templates to make the creation of what-if forecasting scenarios easier.

When you select this technique, you can choose an existing Advanced Quick Forecast from the drop-down list or the Project Setup option to open the Advanced Quick Forecast page.

Apply Economic Scenarios Forecast

This option provides a forecast for several key rates and macroeconomic data, stored as supplemental data items, in different economic outlooks.

This feature requires a separate license option. Contact FPS support at FPSSupport@jackhenry.com for more information.

Basic Quick Forecast

This technique allows you to use the Basic Quick Forecast Setup page to apply summary-level forecast assumptions, and then save them until the next time that you choose to modify them.

For each account or rate type, do the following:

• Select the appropriate forecasting technique in the Project Action column.
• Enter the projected value where necessary.

• Use the corresponding date box in the Time Frame column to select the future time frame in which the forecast assumption ends.

  This final action is only necessary if you want to enter a second growth assumption in the Project Action column for a later range of projected time frames.

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.

Flat

This option specifies that 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.

Grow by Value

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

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.

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.

No Change

This option specifies that the values in all projected time frames remain unchanged.

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.

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.

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.