Automatic calculation of quarterly estimates for next year

At the end of the year, the next year quarterly estimates can be automatically calculated using a macro. In order to run the macro, do the following:

1. Select "Generate next year Q estimates" from the drop-down menu in the upper left corner of the I-divQ -sheet.
2. Press "Run macro".

Calculation of Net sales and EBIT

The macro calculates seasonal variation percentages to the tables on the right side of "User's own area". The absolute quarterly Net sales and EBIT are then calculated based on these percentages.

Please note

The seasonal variation estimates are based on the variation of only two previous years and are easily affected by considerable one-time variation in the figures.
You should always critically assess the validity of the automatically created estimates and also change them to account for possible new development in the company's operations.

Calculation of items in the income statement

The following items in the income statement are calculated by allocating the whole-year estimate evenly to the quarters:

Other operating income
Depreciation (tangible, intangible)
Impairment charges
Share of profits in associated companies
Net financials
Other items
Minority interest
Extraordinaries

The item Taxes is calculated by multiplying the quarterly Pre-tax profit with the full year tax rate from the I-main sheet.