Entering Forecast Assumptions

Use this information to enter forecast assumptions at the summary and/or detailed account level.

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.

Navigate to Forecasting > Detail.
Select the What If and Organization that you want to work with.
These options can be predefined based on your user permissions.
Select the time frames for the forecast from the drop-down menu.

Use the monthly check boxes to select or clear historical and forecasted time frames.

Select a situation and follow the corresponding steps to select the account that you want to forecast.

Situation	Steps
Use the Account Drop-Down List	Use the drop-down menu to select Expand to filter down to the subtotal or detailed account. Select the account that you want to work with.
Use the Account Tab	Select Account to expand the account list. Select one of the three account tabs that appear: Assets/Int Inc, Liab & Equity/Int Exp, and Non-Int Inc/Exp. Select Expand to drill down to the subtotal or detailed account. Select the account that you want to work with. Use the Find option to search for existing accounts that contain the criteria entered into the Find field. Tip: You can apply forecast assumptions at the subtotal account level using Expand. The forecast filters down to the detailed accounts that make up the subtotal.

Situation

Steps

Use the Account Drop-Down List

Use the drop-down menu to select Expand to filter down to the subtotal or detailed account.
Select the account that you want to work with.

Use the Account Tab

Select Account to expand the account list.
Select one of the three account tabs that appear: Assets/Int Inc, Liab & Equity/Int Exp, and Non-Int Inc/Exp.
Select Expand to drill down to the subtotal or detailed account.
Select the account that you want to work with.
Use the Find option to search for existing accounts that contain the criteria entered into the Find field.

Tip: You can apply forecast assumptions at the subtotal account level using Expand. The forecast filters down to the detailed accounts that make up the subtotal.

Select the value/time frame 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 orange. When you select a current month time frame, a light blue highlight appears around the cell.

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.
Select Project 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 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.

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 time frames between the beginning and ending dates.

Tip: In addition to the provided forecasting actions, you can enter in values or copy and paste from a spreadsheet into the forecast manually.

Contents

Search Results

Entering Forecast Assumptions