Consolidated Financial Statements
Originally published: 08/06/2020 07:08
Publication number: ELQ-43006-1
View all versions & Certificate

Consolidated Financial Statements

An Excel Model Template of Consolidated Financial Statements.

This financial model is the summary of a company’s performance based on certain variables that help the business forecast future financial performance. In other words, it helps a company see the likely financial results of a decision in quantitative terms.

The measurements and skills used to construct the model include:
-knowledge of the company’s operations, accounting, corporate finance, and excel spreadsheets
-Consolidation of the financial report using one file

Key inputs/outputs

All cells in green are input cells
The green cells are in the green tabs only
The outcome are the dark blue tabs
Enter the data in the green cells in the sheets "TB Company1" and "TB Company2"
Select the current month by choosing the selection boxes under coloum V
Select the company name by choosing the selection boxes under coloum V

We hope you like this model template in order to save your valuable time and for decision-making purpose.

This model contains Macros. Only download the model if your MS Excel supports Macros

You can find the full instruction in the instruction sheet.

Conclusion and customization
This is a highly versatile, very sophisticated financial model template, and is also user-friendly.
If you have any inquiries, modification request or other requests of assistance to customize the model template for your business case please contact us here:

This Best Practice includes
Excel Template

Acquire business license for $25.00

Add to cart

Add to bookmarks



  • Rate this Downloadable Best Practice

    Write a review

  • Melanie Lee(last updated: 05/03/2021 00:43)

People using this Best Practice also downloaded


More Best Practices from ECF Consultancy

See all

Any questions on Consolidated Financial Statements?

The user community and author are here to help. Go ahead!

5.0 / 5 (1 votes)

please wait...