Working in the Forecasting Detail Page

Select Forecasting > Detail from the menu.

Select a What If model from the drop-down list.

For a fiscal year budget, it is necessary to create a yearly model.

Select the Organization that the forecast applies to.

You can enter forecasts at the top organization or at the branch and center level. Forecasts that you apply at branches and centers must be consolidated to the top organization.

Select the Account Type that you want to forecast.

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.

Select the time frames to show while forecasting in the Select Time Frames dialog box, and then select Apply.

Historical time frames show in darker blue, and you can select them for reference data. Up to 120 months can appear in the grid.

Select an option from the View drop-down list.

Only views that apply to the current account show in the list.

Default

This view shows Month End Balance, Average Balance, and New Volume for all asset and liability accounts. It also shows Interest Income, Yield, and Offering Rate for rate-bearing accounts.

Current Volume Cash Flows

This view provides contractual and behavioral cash flow schedules for accounts with cash flows. It provides an editable Add'l Prepay % row that lets you make quick adjustments to an account's prepayment schedule. The account's Total Month End Balance, Yield, Contractual Weighted Life, and Forecasted Weighted Average Life appear.

Current/New Volume

This view shows the same data items as the default view, along with breakouts of the projected data items by current volume and new volume.

Instrument Detail

This view shows the instrument details associated with a detail-level account. In the Instrument Detail grid, you can filter the data, export the data, and add or remove columns that correspond to all the data fields that were brought into the Forecasting module. In this grid, you can use the Adjust Maturity Date setting to model instrument sales.

For example, if you must model something like selling off your mortgage portfolio or muni bonds during a certain projected month, then decrease the maturity dates of the affected instruments to the necessary month. This adjustment models the instruments being removed from the balance sheet.

You can select an Account Number to view the Cash Flows page.

Account Statistics

This view provides the projected number of new and closed accounts and allows you to forecast Avg/Accounts, # New Accounts, and Avg/New Accounts.

Growth Statistics

This view compares projected results to prior periods.

Balancing Accounts

This view shows the projected balances for the two accounts set up as balancing accounts.

Key Rate Tie

This view shows the projected rates feeding into the key rate tie formula for applicable accounts.

Multiple Accounts

This view allows a selection of one data item at a time, and then the view updates to show the projected value across multiple accounts.

Multiple Organizations

This view allows a selection of one data item at a time, and then the view updates to show the projected value across multiple organizations.

Multiple Organizations & Accounts

This view allows a selection of one data item and one time frame at a time, and then the view updates to show the projected value across multiple accounts and in multiple organizations.

Comparison

This view compares one data item in the current what-if model with the same data item in another what-if model across time frames. The grid shows calculations of dollar and percentage difference values.

Audit Trail

This view provides a log of all forecast actions on the current account. When this view appears, you can also add explanatory comments. You can export the audit trail log and any comments separately for the current account or for all accounts.

You can select Manage Views to save user-defined groups of data items as custom views.

Set up and select the additional options as needed.

Layout

Use this option to change how the data appears in the grid area.

Select Flip Grid Layout to switch the layout of rows and columns so that the data in the grid appears either horizontally or vertically.
Select Both to show the projected data in both a grid and a graph.
Select Grid to show the projected data only in a grid.
Select Graph to show the projected data only in a graph.

Comments

Use this option if you must enter a narrative for the projected values. The comments include your username and date. You can export comments as an Excel® file. The Comments option shows the number of comments if any are available to view.

Data Entry Mode

Use this option to enter amounts, rates, and numbers quickly and manually without waiting for the grid to perform its normal calculations and refresh after every edit. When you turn off this option or perform a projection, balance, or save, the modified grids perform the related calculations and refresh.

MTD/YTD

Use this option to show either month-to-date totals or year-to-date totals. This option is available based on the selected Account Type.

Project

Use this option to show forecasting techniques to help you quickly update your assumptions for each projected account. Only those options that are available for the current screen and account appear active.

Reset

Use this option to undo recent changes incrementally back to the point of the last time you saved the forecasting data.

Balance

Use this option to run the balancing routine manually for the current organization or all organizations.

Chart of Accounts

Use this option to leave the Forecasting Detail page in its current state without saving and go directly to the Chart of Accounts setup page. On the Chart of Accounts page, you can view an account's setup information and make setup changes. You can also view or edit other accounts on this page.

To continue your work in Forecasting Detail, select Forecasting Detail.

Select the value and time frame that you want to use as a base value for the forecast within the selected grid.

The base value is usually the current month-end balance.

You can choose to enter values into a projected time frame manually and use that value and time frame as the starting point for that data item's forecast. Select the appropriate cell in the grid and manually enter a value.

Select Save to apply distribution actions to the projected time frames.