Enterprise Edition:Time frame of the plan

The Scenario Manager can be used to set a plan time frame for each scenario. The time frame may be 12 months, but may also be a longer or shorter period. A shorter scenario time frame may be advisable in the case of a stub period. A longer scenario time frame allows you to plan on a monthly basis for periods longer than one year or to plan on a rotating basis in which the plan period is continually extended. The opening balance sheet is set to the plan-from month (as an opening balance; changes in the balance of the plan-from month are calculated into the plan value of the balance for the plan-from month.

Plan time frame and calculations

Depending on the table involved, the plan time frame defined in the Scenario Manager limits the calculations that are initiated by plan data entry. For example, if revenue (“Revenue” table) from outside the plan time frame is entered, no further calculations such as the profit and loss statement or the financial plan are performed.

Please ensure that your data entries correspond to the defined plan time frame!

Nevertheless, the mathematical logic of certain planning areas (e.g. loan planning) does not preclude the possibility of entering data outside the defined plan time frame. The following overview shows the values that are calculated for periods before or after the planning horizon and the values to which the limits of the planning horizon apply.

Table	Value before planning horizon	Value within planning horizon	Value after planning horizon
Revenue		Sales
Types of revenue reduction		Revenue reduction
Variable costs		Variable costs
Personnel costs		Personnel costs
Other fixed costs and revenues		Other costs/revenues
Depreciations		Depreciation	Depreciation
New investments		Acquisition
Existing investments		Depreciation
Disinvestments		Sale proceeds
Loan master data	Borrowing	Borrowing	Borrowing
Loan	Repayment, interest	Repayment, interest	Repayment, interest
Provisions		Change
Reserves		Change
Interest		Interest
Profit tax master data		Tax rate
Profit taxes		Tax
Balance sheet parameters		Value
Regular tax burden		Receipt, disposal	Disposal
Warehouse		Purchase, withdrawal	Purchase
Flow statement		Value	Value
Balance sheet		Value
Income statement		Value
Financial budget – direct method		Value	Wert
Financial budget – indirect method		Value	Value
Profit and loss structure, aggregate cost method		Value
Expense distribution sheet		Value
Services		Value
Charges for services		Value

Direct financial plan, indirect financial plan

Values are copied here from other tables, even if the values apply to periods outside the plan time frame. The most important such values are payments after the planning horizon that arise from entries within the planning horizon.

Values not included are depreciations from investment planning and repayment and interest payments from loan planning. These must be recalculated when the plan time frame is extended. The final cash result is calculated within the planning time frame only.

Flow statement

Here the most important calculations are the changes in working capital (accounts receivable and accounts payable) that occur outside the plan time frame. These calculations are performed from other tables whose underlying values lie within the planning time frame.

The following values are calculated within the plan time frame only

By limiting the data entry in tables to the plan time frame:

• Revenue
• Revenue reduction
• Variable costs
• Personnel costs
• Other fixed costs and revenues
• Balance sheet parameters
• Provisions
• Reserves

Payments from all these tables are calculated in the appropriate table even for periods after the planning horizon, but not for periods before the planning horizon as this is already included in the opening balance sheet.

Investments

New investments: Only a month within the planning horizon can be specified as the date of acquisition. Depreciations are calculated beyond the planning horizon as well.

Loans

Neither the Loan Master Data table nor the Loans table is limited. The formulas for repayment and interest payments calculate into the Loans table until the end of the life of the loan. Only values within the plan time frame are calculated into the Earnings tables.

Analyses

The following properties will be carried forward up to the planning horizon:

• Bilanzgewinn_GuV
• Bilanzgewinn_Bilanz
• Cashvortrag_DirFP
• Cashendstand_Bank
• Cashvortrag_IndirFP