1. Working with Planning Modules
  2. Working With Financials
  3. Planning Using Balance Sheets
  4. Specifying Balance Sheet Drivers

Specifying Balance Sheet Drivers

To specify balance sheet drivers:

  1. Click Driver and Trend Based driver or trend, and then for indirect cash flow click Driver Based Balance Sheet Planning. For direct cash flow, click Calculated Balance Sheet, or Trend Based Balance Sheet.
    For rolling forecasts, click Rolling Forecast Rolling Forecast, and then Driver Based Balance Sheet Planning or Trend Based Balance Sheet.
  2. Specify your context by selecting point of view dimensions such as specific product line or type of expense such as operating expenses, and then click go.
  3. Set your assumptions for Trend, and then adjust them by % increase or decrease. The annual value projected is based on the value of the timeframe ( prior year, for example) that you specify, and will follow the same monthly/quarerly pattern. By setting a percentage increase or decrease assumption, you can impact the projected value. For example, you may assume an expense or driver may increase due to inflation.
  4. Double click Year Total to calculate assumed values.
  5. View values for driver-calculated accounts:
    1. Click Driver Based Balance Sheet, and then Calculated Year Total to view your annual, quarterly, or monthly driver-derived values. If they’re insufficient or incorrect, or inappropriate, you can override them in any period.
    2. Specify your context by selecting point of view dimensions such the year and scenario, and then click go.
    3. Expand Adjust Year Total to access the period for which to modify driver derived values, and enter new values.
  6. To adjust calculated values for accounts for trends for rolling forecasts, click Trend Adjustment and then enter a value in the Adjustment (+/ -).