Overview

A 3 statement model template connects the income statement, balance sheet, and cash flow statement into one dynamically linked financial model.

This model has an assumptions and drivers section which is used to build the forecast in the 3 financial statements. The model is built in a single tab (worksheet) format. Why should financial analysts or anyone working in the finance industry learn about the three statement models? The 3 statement model template is the foundation on which more advanced financial models are built such as discounted cash flow DCF models, mergers models, leveraged buyout LBO models, and various other types of financial models. Advantages of a single worksheet model are:
  • Easier to navigate (don’t have to switch between tabs)
  • Less risk of mislinking formulas (all time periods are in the same column)
  • More organized with the use of grouping cells
  • Allows more room for consolidating multi-business companies
 

Building a 3 Statement Financial Model Template

There are several steps required to build a 3 statement model, including:
  1. Input the historical financial information into Excel
  2. Determine the assumptions that will drive the forecast
  3. Forecast the income statement
  4. Forecast capital assets
  5. Forecast financing activity
  6. Forecast the balance sheet
  7. Complete the cash flow statement
Some general best practices include keeping all assumptions in one area, using consistent formatting, keeping formulas simple (avoid long complex ones), and using charts and graphs to display results. If you want to learn more about how this 3 statement model template was built, check out CFI's financial modeling courses.  

This business tool includes 1 Excel Model

Share
Reviews Add a review
Avatar
Shaun Walsh

Can’t see how to download this. Any advice welcome!

    Corporate Finance Institute®
    Corporate Finance Institute®

    Hi Shaun,
    To download the template, click “Add to Cart” and then “View cart” to see all the items you want to download. Click “Proceed to checkout” to confirm your details and read terms and conditions. Finally, click “Place Order” to complete the checkout and your selected template will appear in your dashboard.

Avatar
Ron

Thank you.

Avatar
Peter Aitken

Excellent

Avatar
Nenad
Avatar
Lezi

Excellent

Avatar
Lezi
Avatar
Faz
Avatar
Tristan Margot
Avatar
Khalil Shahin
Avatar
Vitor Bishu

Simple 3 statement model template, thanks for sharing

More From Corporate Finance Institute®

Browse our top rated business templates. See All
restructuring financial model template preview 1 Restructuring Financial Model Template
162
0
This restructuring financial model template is used to demonstrate the financial interactions behind the restructuring process. Adjust this model to…
TMT Financial Model Template Preview TMT Financial Model Template
241
0
This TMT financial model template is used to value technology, media, and telecom firms. This model provides a template to…
bank financial model template preview 1 Bank Financial Model Template
254
0
This bank financial model template is used to value financial institutions group (FIG) companies. This is a comprehensive model that…
Synthetic Call Chart Option Profit/Loss Graph Maker
818
232
This free Option Profit/Loss Graph Maker allows the user to combine up to ten different types of options as well…
Directional Trading Strategies Template Directional Trading Strategies Template
651
0
The directional trading strategies template allow users to determine the profit when buying options. This template focuses on directional strategies…
HELOC Calculator Template Home Equity Line of Credit (HELOC) Calculator
386
104
This home equity line of credit (HELOC) calculator can calculate the maximum amount of loan a homeowner is eligible to…