Building a Three-Statement Model

A free guide on building three-statement models

Over 1.8 million professionals use CFI to learn accounting, financial analysis, modeling and more. Start with a free account to explore 20+ always-free courses and hundreds of finance templates and cheat sheets. Start Free

What is a Three-Statement Model?

A three-statement model links the income statement, balance sheet, and cash flow statement into one dynamically connected financial model. Three-statement models are the foundation on which more advanced financial models are built, such as discounted cash flow (DCF) models, merger models, leveraged buyout (LBO) models, and various other types of financial models.

Diagram showing the linked three-statement model as the basis for all other financial models

How Do You Build a Three-Statement Model?

There are several steps required to build a three-statement model, including:

  1. Input historical financial information into Excel
  2. Determine the assumptions that will drive the forecast
  3. Forecast the income statement
  4. Forecast long-term, capital assets
  5. Forecast financing activity (e.g., debt and equity)
  6. Complete the income statement
  7. Complete the balance sheet (excluding cash)
  8. Complete the cash flow statement and cash on the balance sheet

In this guide, we will walk you through each of the above steps. For a more detailed, video-based tutorial on how to build a model from scratch, enroll in CFI’s three-statement modeling course.

Approach and steps to building a three-statement model

Key Highlights

  • A three-statement model combines the three core financial statements (the income statement, the balance sheet, and the cash flow statement) into one fully dynamic model to forecast future results.
  • The model is built by first entering and analyzing historical results. 
  • These historical results often serve as the basis for the model’s forecast period (usually 5-10 years in the future).

Input historical information into Excel

In this step, we take the historical financial information of the company and either download, type or paste it into Excel. Once the information is in Excel, you’ll need to do some basic formatting to make the information easy to read and to make it follow the structure you want your model to take. As you can see in the screenshot below, the historical information is entered in a blue font color under the historical time periods.

Three-statement model screenshot - inputting historical information into Excel

Determining the assumptions that will drive the forecast

With the historical financial information in Excel, and in an easy-to-use format, we can start calculating some metrics to evaluate the historical performance of the company. We need to calculate metrics such as revenue growth, margins, capital expenditures and working capital terms (such as accounts payable, inventory, and accounts receivable). Below is an example of the assumptions section, which drives the forecast.

Three-statement model screenshot - assumptions section

Forecast the income statement

With the assumptions in place, it’s time to start forecasting the income statement, beginning with revenue and building down to EBITDA (earnings before interest taxes depreciation and amortization). At that point, we will require supporting schedules to be built for items such as capital assets and financing activity.

Forecast capital assets

At this point, we need to forecast capital assets such as property, plant, and equipment (PP&E), before we can finish the income statement in the model. To do this, we take the last period’s closing balance, and then add any capital expenditures, deduct depreciation, and arrive at the closing balance. Depreciation can be calculated in a variety of ways, such as straight line, declining balance, or percent of revenue.

Three-statement model screenshot - forecasting capital assets

Forecast financing activity

Next up, we have to build a debt schedule to determine interest expense on the income statement. Similar to the section above, we take last period’s closing balance, and then add any increases or decreases in debt, and arrive at the closing balance.

The interest expense can be calculated on the opening debt balance or the average debt balance. Alternatively, a detailed interest expense schedule can be followed if one is available.

Complete the income statement

Now that depreciation and interest expense have been forecast in the appropriate supporting schedules, these expenses can then be referenced back to the income statement, completing that core financial statement.

Complete the balance sheet

At this stage, it’s possible to essentially complete the balance sheet in our three-statement model, except for the cash balance, which will be the last step. Working capital items are forecast based on assumptions around average days payable and receivable, as well as inventory turns. Capital assets (PP&E, etc.) come from the schedule discussed above, as well as debt balances.

Three-statement model screenshot - forecasting the balance sheet

Complete the cash flow statement and cash on the balance sheet

With the balance sheet completed (except for cash), we can build the cash flow statement and complete our three-statement model in Excel. This section is completed, essentially, by just linking to items that have already been calculated above in the model. We have to complete each of the three main sections: cash from operations, cash from investing and cash from financing.

Three-statement model screenshot - completing the cash flow statement

Layout and structure

There are two common approaches to structuring a three-statement model: single worksheet and multi-worksheet. While both approaches are acceptable, CFI strongly recommends using a single worksheet structure.

Advantages of a single worksheet model include the following:

  • Easier to navigate (don’t have to switch between sheets)
  • Less risk of mis-linking formulas (all time periods should be in the same column)
  • More organized with the use of Excel’s grouping feature
  • Allows more room for consolidating multi-business companies

Layout of a three-statement model - single- vs. multi-worksheet models

Additional Resources

DCF Modeling Guide

Types of Financial Models

What is Cash Flow?

See all financial modeling resources

Analyst Certification FMVA® Program

Below is a break down of subject weightings in the FMVA® financial analyst program. As you can see there is a heavy focus on financial modeling, finance, Excel, business valuation, budgeting/forecasting, PowerPoint presentations, accounting and business strategy.

 

Financial Analyst certification curriculum

 

A well rounded financial analyst possesses all of the above skills!

 

Additional Questions & Answers

CFI is the global institution behind the financial modeling and valuation analyst FMVA® Designation. CFI is on a mission to enable anyone to be a great financial analyst and have a great career path. In order to help you advance your career, CFI has compiled many resources to assist you along the path.

In order to become a great financial analyst, here are some more questions and answers for you to discover:

 

0 search results for ‘