News & Events
Forecasted Group Financial Statements with Invest for Excel Enterprise
November 16, 2021
More and more groups do their long-term financial planning with Invest for Excel® Enterprise edition. The program has a powerful CONSOLIDATION function with ELIMINATIONS of internal transactions. The consolidation function is logical and easy to use. It also works well for international groups with subsidiaries planning in local currencies, thanks to the currency conversion function that converts on the go, while consolidating.
This is how it works in practice:
Every subsidiary has a separate Workbook. The main rows of the Income Statement are named the same (the grey rows). The sub-rows (yellow) may differ freely. Each subsidiary’s workbook includes an Eliminations -sheet. The Eliminations sheet includes functionality to easily define what should be eliminated on different group levels. Up to 25 group levels are supported.
The software user selects the files for the consolidation in the dialogue window and clicks the ”Consolidate’’ button in the software. The consolidated Workbook is created showing the correct Income Statement, Balance Sheet, Cash flow Statement, the overall profitability report and more.
For more information, contact Jens Westerbladh,
+46 73 0334 952.
Picture above shows an example group structure with a sub-group.