Last version published: 06/08/2019 07:27
Publication number: ELQ-30657-3
View all versions & Certificate
Three Statement Financial Model Excel Template
This is a starting template for a three statement corporate forecasting model in Excel.
The model has a monthly timeline with the statements presented both monthly and annually.
The model includes functionality to receive historic values in financial statement format, which are then combined with forecast values before being presented on the model's outputs.
The model is complete to Gross Profit and provides the three statement structure and a framework for creating a full corporate forecasting model tailored to your particular business. Existing calculations (set out below) can be easily copied and reused to generate your own bespoke calculations:
- Timeline set up (monthly and financial years),
- Modelling time with flags and counters,
- Growth and seasonality,
- Payments/receipts that do not align with the timeline,
- Combination of historic and forecast values,
- Calculation of balance sheet items,
- Summarising monthly IS/BS/CF into annual FY values.
User documentation is included to give an overview of the model's purpose and its structure. The 'Guide!' sheet also provides details of the colours and formats that have been applied through the model to aid the user.
A dashboard has been incorporated that facilitates an 'at a glance' analysis of Gross Profit, together with functionality to sensitise the model for growth assumptions.
The model applies generally accepted financial modelling best practices as well as the FAST standard (https://www.fast-standard.org/ ).
This Best Practice includes
1 Excel file
John Dimberline offers you this Best Practice for free!
download for free
Add to bookmarks
Generating forecasts to support business strategy or to support transactions.
4.8 / 5 (16 votes)
- Rate this Downloadable Tool
Write a review
- Atinuke Ajao(last updated: 14/05/2020 13:54)
- Gabriel Adetayo(last updated: 27/04/2020 08:11)
- Andrew Piechocki(last updated: 12/04/2020 04:57)
- Amir Ganic(last updated: 01/04/2020 15:41)
- Andreas Pungkar(last updated: 23/03/2020 22:13)
- Giles Male(last updated: 12/03/2020 09:43)
- Tibor Rusiňák(last updated: 10/03/2020 21:21)
- Nilesh Kumar(last updated: 03/03/2020 13:49)
- Alaa El Behary(last updated: 05/01/2020 13:02)
- Mustaffa Abdul Latiff(last updated: 19/11/2019 02:36)
- Santosh Daddimani(last updated: 04/11/2019 09:11)
- Dr Abdul Malik Syed(last updated: 20/10/2019 18:09)
- Yanli Hou Queenie(last updated: 25/08/2019 12:52)
- Prince Chakax(last updated: 09/08/2019 12:28)
- Vivek Krishnan(last updated: 08/08/2019 06:20)
- Alexandr Marchenko(last updated: 27/07/2019 19:36)
People using this Best Practice also downloaded
Start Up Restaurant Financial Model TemplateExcel model for a start up or already operating restaurant business for you to download and use.feasibilitysalesbusiness plancash flowcustomer525add_shopping_cart
Airline Operator Financial Excel ModelAirline Operator Financial Model presents the case of a company operating an airline business.valuationdcfwaccfinancial modelexcel83add_shopping_cart$79.00by Big4WallStreet
Air Business Bundle (Airline & Airport Models)Bundle with Airline and Airport Financial Modelsinvestmentfinancevaluationfinancial modelexcel85add_shopping_cart$140.00by Big4WallStreet
COVID-19 100% FREE MODEL - PRE-SCHOOL CARE BUSINESS PLAN FINANCIAL MODEL EXCEL TEMPLATEGet the Preschool Business Plan template. Find out how is owning a preschool profitable. Check what you need on startingfinancial modelexcel modelpre-school business plan60add_shopping_cartfreeby Henry Sheykin
Commercial Bank Financial ModelCommercial Banking Financial Model presents the case of a commercial bank with regulatory thresholds based on Basel 3.dividendsbankdividend discount modelfinancial modelbanking484add_shopping_cart$119.00by Big4WallStreet
Start Up Car Park Excel Model and Valuation TemplateA full & detailed Excel Model of a Car park business with 3 statements & investment metrics - to download and use.business planmodelvaluationfinancial modelexcel468add_shopping_cart
Real Estate Financial Model Template BundleFor professionals with commercial projects or business ventures that need assistance with building financial models.developmentreal estatefinancial modelexcel modelcommercial real estate544add_shopping_cart$90.00by Big4WallStreet
Steel Industry Financial Model Excel TemplateThis Model presents the case of the operation of a steel plant using the mini mill technology.valuationcost of debtdiscounted cash flowsfinancial modelexcel model144add_shopping_cart$99.00by Big4WallStreet
Pre-Sold Apartments Real Estate Model Excel TemplateModel presents the case where a land plot is purchased and an apartment complex is built and pre sold to clients.cash flowreal estatefinancial modelexcel modelinternal rate of return217add_shopping_cart
Online Shop Financial ModelOnline Shop Financial Model presents the business case of a brand new start up Online Shop with an upfront investment inirrdcffinancial modelexcelexcel model734add_shopping_cart$69.00by Big4WallStreet
Any questions on Three Statement Financial Model Excel Template?
The user community and author are here to help. Go ahead!