Description

Forecast Method

Short Name

Info

Do Not Forecast

NULL

No Forecast

Selecting 'Do not Forecast' will force the full year total to be ZERO. Note: For Balance Sheet account 'Do Not Forecast' will force a movement in the 1st forecast month to be the inverse of the Opening Balance.

Previous Year Estimate plus X

PYESTaddVAL

PY Est + X

Adds a fixed amount to the 'prior year's full year estimate'.  For the current forecast year, the year-to-date actual is deducted from the planned full year value.

Previous Year Estimate plus X%

PYESTaddPER

PY Est + X%

A percentage of the 'prior year's full year estimate'.  For the current forecast year, the year-to-date actual is deducted from the planned full year value.

Current Year Estimate plus X

CYESTaddVAL

CY Est. + X

Adds a fixed amount to the current year's full year estimate of reference version. If no current version is selected the current planning version is used.

Current Year Estimate plus X%

CYESTaddPER

CY Est. + X%

A percentage increase to the current year full year estimate of the default reference version or other nominated version.

Year to go Estimate plus X

YTGESTaddVAL

YTG Est. + X

Add at a fixed amount to the remaining forecast month estimate for the reference version.

Year to go Estimate plus X%

YTGESTaddPER

YTG Est. + X%

A percentage of the remaining forecast month's estimate for the reference version.

FY Entry

FYENTRY

FY Entry

Manually enter the full year Plan Value. For the current forecast year, the year-to-date actual is deducted from the planned full year value.

Entry per Month

MTHENTRY

per Mth Entry

Manually enter the Plan Value for each month. Note: This method must be used to enable data entry via spreading.

Month Entry Per Item

ITEM

Per Item

Enter a breakdown of the items that makeup to Forecast/Budget.

YTG Entry

YTGENTRY

YTG Entry

Relevant for Working Forecast only. When this method is selected the user manually enters the desired value for the sum of the remaining months of the year (Year to Go 'YTG').

18Mth Run Rate + X

18RRMEANaddVAL

18Mth Mean + X

Relevant for P&L accounts only (i.e. for Expense and Revenue planning). This method takes the 18 month rolling average (from the last month of actual reference data) as the monthly value and adds a fixed value inputted by the user. Note: the input value is a yearly not monthly value.

18Mth Run Rate + X%

18RRMEANaddPER

18Mth Mean + X%

Relevant for P&L accounts only (i.e. for Expense and Revenue planning). This method takes the 18 month rolling average (from the last month of actual reference data) as the monthly value and adds a percent change inputted by the user.

6M Run Rate plus X

6RRMEANaddVAL

6Mth Mean + X

Relevant for P&L accounts only (i.e. for Expense and Revenue planning). This method takes the 6 month rolling average (from the last month of actual reference data) as the monthly value and adds a fixed value inputted by the user. Note: the input value is a yearly not monthly value.

6M Run Rate plus X%

6RRMEANaddPER

6Mth Mean + X%

Relevant for P&L accounts only (i.e. for Expense and Revenue planning). This method takes the 6 month rolling average (from the last month of actual reference data) as the monthly value and adds a percent change inputted by the user.

3M Run Rate plus X

3RRMEANaddVAL

3Mth Mean + X

Relevant for P&L accounts only (i.e. for Expense and Revenue planning). This method takes the 3 month rolling average (from the last month of actual reference data) as the monthly value and adds a fixed value inputted by the user. Note: the input value is a yearly not monthly value.

3M Run Rate plus X%

3RRMEANaddPER

3Mth Mean + X%

Relevant for P&L accounts only (i.e. for Expense and Revenue planning). This method takes the 3 month rolling average (from the last month of actual reference data) as the monthly value and adds a percent change inputted by the user.

12M Run Rate plus X

12RRMEANaddVAL

12Mth Mean + X

Relevant for P&L accounts only (i.e. for Expense and Revenue planning). This method takes the 12 month rolling average (from the last month of actual reference data) as the monthly value and adds a fixed value inputted by the user. Note: the input value is a yearly not monthly value.

12M Run Rate plus X%

12RRMEANaddPER

12Mth Mean + X%

Relevant for P&L accounts only (i.e. for Expense and Revenue planning). This method takes the 12 month rolling average (from the last month of actual reference data) as the monthly value and adds a percent change inputted by the user.

% of Reference Account

%REFACCOUNT

%REFACCOUNT

For P&L Accounts (in Expense and Revenue Planning). This method multiplies the value of the inputted reference account by the inputted percent for the selected BSEG intersection.

Statistical Account Multiplier

MULTREFACCOUNT

MULTREFACCOUNT

For P&L Accounts (in Expense and Revenue Planning). This method multiplies the value of the inputted reference account by the inputted multiplier for the selected BSEG intersection. Note: the reference account would typically be a statistical account (e.g. for forecasting training expense multiply a fixed value per employee by the Headcount statistical account).

Description

Forecast Method

Short Name

Info

Do Not Forecast

NULL

No Forecast

Selecting 'Do not Forecast' will force the full year total to be ZERO. Note: For Balance Sheet account 'Do Not Forecast' will force a movement in the 1st forecast month to be the inverse of the Opening Balance.

Previous Year Estimate plus X

PYESTaddVAL

PY Est + X

Adds a fixed amount to the 'prior year's full year estimate'.  For the current forecast year, the year-to-date actual is deducted from the planned full year value.

Previous Year Estimate plus X%

PYESTaddPER

PY Est + X%

A percentage of the 'prior year's full year estimate'.  For the current forecast year, the year-to-date actual is deducted from the planned full year value.

Current Year Estimate plus X

CYESTaddVAL

CY Est. + X

Adds a fixed amount to the current year's full year estimate of reference version. If no current version is selected the current planning version is used.

Current Year Estimate plus X%

CYESTaddPER

CY Est. + X%

A percentage increase to the current year full year estimate of the default reference version or other nominated version.

Year to go Estimate plus X

YTGESTaddVAL

YTG Est. + X

Add at a fixed amount to the remaining forecast month estimate for the reference version.

Year to go Estimate plus X%

YTGESTaddPER

YTG Est. + X%

A percentage of the remaining forecast month's estimate for the reference version.

FY Entry

FYENTRY

FY Entry

Manually enter the full year Plan Value. For the current forecast year, the year-to-date actual is deducted from the planned full year value.

Entry per Month

MTHENTRY

per Mth Entry

Manually enter the Plan Value for each month. Note: This method must be used to enable data entry via spreading.

Month Entry Per Item

ITEM

Per Item

Enter a breakdown of the items that makeup to Forecast/Budget.

YTG Entry

YTGENTRY

YTG Entry

Relevant for Working Forecast only. When this method is selected the user manually enters the desired value for the sum of the remaining months of the year (Year to Go 'YTG').

18Mth Run Rate + X

18RRMEANaddVAL

18Mth Mean + X

Relevant for P&L accounts only (i.e. for Expense and Revenue planning). This method takes the 18 month rolling average (from the last month of actual reference data) as the monthly value and adds a fixed value inputted by the user. Note: the input value is a yearly not monthly value.

18Mth Run Rate + X%

18RRMEANaddPER

18Mth Mean + X%

Relevant for P&L accounts only (i.e. for Expense and Revenue planning). This method takes the 18 month rolling average (from the last month of actual reference data) as the monthly value and adds a percent change inputted by the user.

6M Run Rate plus X

6RRMEANaddVAL

6Mth Mean + X

Relevant for P&L accounts only (i.e. for Expense and Revenue planning). This method takes the 6 month rolling average (from the last month of actual reference data) as the monthly value and adds a fixed value inputted by the user. Note: the input value is a yearly not monthly value.

6M Run Rate plus X%

6RRMEANaddPER

6Mth Mean + X%

Relevant for P&L accounts only (i.e. for Expense and Revenue planning). This method takes the 6 month rolling average (from the last month of actual reference data) as the monthly value and adds a percent change inputted by the user.

3M Run Rate plus X

3RRMEANaddVAL

3Mth Mean + X

Relevant for P&L accounts only (i.e. for Expense and Revenue planning). This method takes the 3 month rolling average (from the last month of actual reference data) as the monthly value and adds a fixed value inputted by the user. Note: the input value is a yearly not monthly value.

3M Run Rate plus X%

3RRMEANaddPER

3Mth Mean + X%

Relevant for P&L accounts only (i.e. for Expense and Revenue planning). This method takes the 3 month rolling average (from the last month of actual reference data) as the monthly value and adds a percent change inputted by the user.

12M Run Rate plus X

12RRMEANaddVAL

12Mth Mean + X

Relevant for P&L accounts only (i.e. for Expense and Revenue planning). This method takes the 12 month rolling average (from the last month of actual reference data) as the monthly value and adds a fixed value inputted by the user. Note: the input value is a yearly not monthly value.

12M Run Rate plus X%

12RRMEANaddPER

12Mth Mean + X%

Relevant for P&L accounts only (i.e. for Expense and Revenue planning). This method takes the 12 month rolling average (from the last month of actual reference data) as the monthly value and adds a percent change inputted by the user.

% of Reference Account

%REFACCOUNT

%REFACCOUNT

For P&L Accounts (in Expense and Revenue Planning). This method multiplies the value of the inputted reference account by the inputted percent for the selected BSEG intersection.

Statistical Account Multiplier

MULTREFACCOUNT

MULTREFACCOUNT

For P&L Accounts (in Expense and Revenue Planning). This method multiplies the value of the inputted reference account by the inputted multiplier for the selected BSEG intersection. Note: the reference account would typically be a statistical account (e.g. for forecasting training expense multiply a fixed value per employee by the Headcount statistical account).

Workforce Model

FIN Expense Workforce Planning

Workforce

For Employee related accounts in Expense Planning. This method will pull the values from the more detailed Workforce sub-module for the selected BSEG intersection.

Marketing Expense Model

FIN Expense Marketing Planning

Marketing

For Marketing and Advertising related accounts in Expense Planning. This method will pull the values from the more detailed Marketing Expenses sub-module for the selected BSEG intersection.

Travel and Entertainment

FIN Expense Travel Planning

T&E

For Travel and Entertainment related accounts in Expense Planning. This method will pull the values from the more detailed T&E Expenses sub-module for the selected BSEG intersection.

FIN Balance Sheet Description

Forecast Method

FIN Balance Sheet Info

Do Not Forecast

NULL

No movement in the account.

Previous Year Closing Balance plus X

PYESTaddVAL

The closing balance for the same month in the previous year plus a monthly adjustment to the closing balance.

Previous Year Closing Balance plus %

PYESTaddPER

The closing balance for the same month in the pervious year plus a percentage change in the closing balance.

Current Year Closing Balance plus X

CYESTaddVAL

The same closing balance as the reference version plus a monthly adjustment to the closing balance. The reference version can be pick for the account or default reference version for the planning version.

Current Year Closing Balance plus %

CYESTaddPER

The closing balance of the reference version plus a percentage change to the monthly closing balance. The reference version can be pick for the account or default reference version for the planning version.

Full Year Closing Balance

FYENTRY

Enter the closing balance for the year.

Enter Monthly Closing Balance

MTHENTRY

Enter the monthly closing balance for the account.

6 Mth Closing Balance plus X

6RRMEANaddVAL

The 6 month average closing balance plus a monthly adjustment to the closing balance.

6 Mth Closing Balance plus %

6RRMEANaddPER

The 6 month average closing balance plus a percentage change to the closing balance

3 Mth Closing Balance plus X

3RRMEANaddVAL

The 3 month average closing balance plus a monthly adjustment to the closing balance.

3 Mth Closing Balance plus %

3RRMEANaddPER

The 3 month average closing balance plus a percentage change to the closing balance

Interest Income

IntIncCalc

Interest income on the previous month's closing balance of short-term cash and cash equivalents. If the previous month's short-term cash and cash equivalents is negative, the movement in the account is the Interest Expense on the negative balance.

Effective Tax

TaxEffCalc

Effective Tax payable of the Operating Profit before Tax. The rate is set in the Corporate Drivers page.

Interest Expense

IntExpCalc

Interest expense on short-term debt plus the Interest expense on long-term debt.

Days Sales Outstanding

DSO

Revenue times the Days Sales Outstanding. Enter the monthly Days Sales Outstanding or leave as zero to use the calculated Day Sales Outstanding for the last Actual Month. There are 30 days in a month.

Days Payment  Outstanding

DPO

Cost of Goods Sold times the Days Payable Outstanding. Enter the Monthly Days Payable Outstanding for the month or leave as zero to use the calculated Day Payable Outstanding for the last Actual Month. There are 30 days in a month.

Days In Inventory

DII

Cost of Goods Sold time the Day In Inventory. Enter the Monthly Days in Inventory for the month or leave as zero to use the calculated Days in Inventory for the last Actual Month. There are 30 days in a month.