You can apply account-level forecast
assumptions on the Forecasting Detail page.
-
Select 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.
- 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.