Skip to main content
/2 min read

3 Statement Financial Modeling Overview

The 3 Statements

Income Statement

Revenue down to net income — performance over a period.

Balance Sheet

Assets, liabilities, equity at a point in time — must balance.

Cash Flow Statement

Operating, investing, financing — reconciles net income to cash change.

How They Link

Net income flows to retained earnings; cash flow ties to balance sheet cash.

Master Financial Modeling at Noble Desktop

Noble Desktop's Financial Analyst Training Program covers financial modeling, valuation, accounting, and Excel for finance.

Learn about the fundamental components and benefits of a three-statement financial model, which includes the income statement, balance sheet, and cash flow statement, and explore the steps required to construct one.

A 3 statement model links the income statement, balance sheet, and cash flow statement into one dynamically connected financial model.

3 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.

There are two common approaches to structuring a 3 statement model: single worksheet and multi-worksheet. While both approaches are acceptable.

Advantages of a single worksheet model includes easy navigation (don’t have to switch between tabs). However, if the model is complex sometimes you would want to build it on several worksheets, so it wouldn’t take thousands of rows and it would be easier to navigate in that case scenario.

You can see an example of a single worksheet 3 statement financial model here.

There are several steps required to build a three statement model. Let me walk you through them:

  1. Input historical financial information into Excel
  2. Determine the assumptions that will drive the forecast
  3. Build Supporting schedules for working capital, debt, depreciation and retained earnings
  4. Forecast the income statement, BS and CFS

In the next videos, we will walk you through each of the above steps to build a 3 statement model.

Video Transcript4 sections

1Full Video Transcript

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 upon which more advanced financial models are built, such as discounted cash flow or DCF models, merger models, leveraged buyout (LBO) models, and various other types of financial models.

2Model Structure Approaches

There are two common approaches to structuring a three statement model: single worksheet and multi-worksheet. While both approaches are acceptable, advantages of a single worksheet model include easy navigation as you don't have to switch between tabs. However, if the model is complex, sometimes you would want to build it on several worksheets so it wouldn't take thousands of rows and it would be easier to navigate. In that case scenario, you can see an example of a single worksheet three statement financial model here.