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.