1. Planning Administrator - Planning Analyst User Guide
  2. OFS Balance Sheet Planning
  3. Planning Interfaces
  4. Planning and Analysis Functions

4.2.5 Planning and Analysis Functions

The following are the Planning and Analysis functions:

  • Bulk Forecast Balance: Click this to display the Bulk Forecast Balance window.

    Figure 4-7 Bulk Forecast Balance window


    This window displays the Planning Product, Currency, Forecast Balance Method, and time buckets. Select a Forecast Balance Method for the Planning Product and enter the relevant values each month. The values indicate the amount for all except Target Growth to which the value will be %.

  • Select a Forecast Balance Method for the Planning Product and enter the relevant values each month. The values indicate the amount for all except Target Growth to which the value will be %.
    The acceptable ranges for the Forecast Balance Methods are as follows:
    • No New Business: All bucketing column fields values should be removed and disabled
    • New Add: -100,000,000,000 to +100,000,000,000
    • Target Average: -100,000,000,000 to +100,000,000,000
    • Target End: -100,000,000,000 to +100,000,000,000
    • Target Growth: -99.99 to +99.99
  • Click Save or Apply to save the details. Clicking Save will save the details and exit the screen. Clicking Apply will save the details and remains on the same screen and allows you to update any further details.
  • Bulk Pricing Margin: Click this to display the Bulk Pricing Margin window where you can select the Pricing Margin Method and define values (in %) for the New Add Spread and New Add Net Rate fields. The acceptable ranges are:
    • New Add Spread: -100,000,000,000 to +100,000,000,000
    • New Add Net Rate: -99.99 to +99.99
  • Detailed Planning: Click this to display the Detailed Planning window. More details about Detailed Planning are explained as follows:
  • Forecast Drivers: This allows you to update the details of the forecast drivers if you want to rerun the Cash Flow. The Forecast Drivers section of the window displays Prior Forecast Methods (if available).

    Figure 4-8 Forecast Drivers


    This allows you to update the details of the forecast drivers if you want to rerun the Cash Flow. The Forecast Drivers section of the window displays Prior Forecast Methods (if available).

  • Forecast Results: This section of the window displays different Forecast Results. You can select Total Business or Current Book or New Business to see the Forecast Results. If you select Total Business, the Forecast Results are displayed for both current and new business. You can click the down arrow next to the Forecast Result and view the Current Book and New Business forecast results. You can use the switch to scroll the results together for Current Forecast and Prior Forecast results at the same time. If this switch is on, then both Current and Prior Forecast Results are displayed on horizontal scrolling. If the switch is off, then you can scroll only through the Current Forecast Results.

    Figure 4-9 Forecast Results


    This section of the window displays different Forecast Results. You can select Total Business or Current Book or New Business to see the Forecast Results.

  • Management Ledger Data: This section of the window displays the Management Ledger Data for the Actual and Budget (planned) with details for Ending Balance, Average Balance, and Net Interest Margin. Here too you can use the switch to scroll the results together for Actual and Budget results at the same time.

    Figure 4-10 Management Ledger Data


    This section of the window displays the Management Ledger data for the Actual and Budget (planned) with details for Ending Balance, Average Balance, and Net Interest Margin.

  • Process Cash Flow: You can select one or multiple Planning Products and Run the Cash Flows.
  • Download: You can select one or multiple Planning Products and download the forecast results in CSV format.