You can create projected values in a few ways. You can enter values manually in projected time frames and use a combination of the following forecasting techniques to make the process faster.
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.
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.
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.
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.
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:
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.
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.
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.
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.