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.