Consolidations: Forecasts Made Easy - With all the Bells!
Consolidations: Forecasts Made Easy - With all the Bells!
With Forecast 5, consolidating forecasts for your group is easy; the software does it all for you!
- Currency conversion? Forecast 5 handles this and produces the group consolidated forecast in your chosen base currency
- Eliminate – or set off - intergroup loans? Forecast 5 handles it.
Complicated group structure with minority interests or associate interests in multiple companies? Forecast 5 handles it all.
Eliminate intercompany profits and losses? Forecast 5 handles it.
Parent company allocates overheads to be carried by subsidiaries? Forecast 5 handles this.
We often wonder how we used to cope previously with all of these tricky situations when we tried to do this in a spreadsheet using multiple tabs and formulae that grew exponentially as we added more divisions, departments or subsidiaries.
Consolidations of spreadsheets was accompanied by constant reworking of the formulae that may – or more often, did not - balance and all the other errors inherent in software not built for the job. Or just getting one’s mind around minority interests and goodwill was always an issue – at least for this scribe – but with Forecast 5 its amazingly easy.
Forecast 5 focusses exclusively on budgeting, forecasting and actuals. Sure, there are various add-ons to make the users’ life easier - like integrations with your favourite accounting or ERP to bring in opening balances and actual results automatically.
It does it well, all the way up from simple company forecasts to very complex group forecasts with multiple companies or even multiple levels of consolidations.
And with each forecast, the software produces a balanced suite of forecast reports of
Profit and Loss,
Balance Sheets,
Cashflows, and
Funds Flows (think “Statement of Cashflows” in IFRS or UK GAAP terms).
All for up to 15 years, and, after actuals, rolling forecasts and variance analyses for each of these reports!
Over the next few weeks, please look out for articles that cover how Forecast 5 deals with:
- Eliminating intercompany profits and losses and intercompany loans;
- Multiple currencies in a group forecast
- A parent or head office company allocating overheads to subsidiaries (this is not strictly a consolidation issue, but an issue in a group context, nevertheless);
- Consolidations of companies with actual results (ie not simply budgets but the production of group variance analyses and group rolling forecasts);
- Subsidiaries, branches and departments;
- Minority & associate interests and treatment of impairment of goodwill.
If you’d like to see the power of Forecast 5 for yourself, please download a free 21 day trial | Already using Forecast 5? Why not book a free demo with us to make sure you're getting the most out of all the features! |
Images by: Photo by Words as Pictures on StockSnap & Canva