3-Statement Financial Model: How to Build One

If there is one skill that separates candidates who get investment banking offers from those who do not, it is the ability to build a financial model from scratch. Every valuation methodology, every deal analysis, and every transaction model you will encounter in banking is built on top of a 3-statement financial model. The DCF depends on it. The LBO depends on it. The merger model depends on it. Without a working 3-statement model, none of those analyses are possible.

The 3-statement model is exactly what it sounds like: an integrated projection of a company's income statement, balance sheet, and cash flow statement that links together so that changes in one statement automatically flow through to the others. When you increase revenue assumptions, net income rises, cash flow improves, and the cash balance on the balance sheet grows. When you add debt, interest expense hits the income statement, debt appears on the balance sheet, and cash flows reflect the borrowing.

This article walks you through how to build a 3-statement model step by step, from gathering historical data to handling the circular reference that trips up most beginners. If you already understand how the three statements link conceptually, this takes you to the next level: actually building the model in a spreadsheet.

Before opening Excel, you need to understand the model's structure. A well-built 3-statement model has distinct sections that feed into each other in a specific order.

3-Statement Financial Model

An integrated spreadsheet model that projects a company's income statement, balance sheet, and cash flow statement over a forecast period (typically 3-5 years). The three statements are mathematically linked so that changes in assumptions automatically flow through the entire model, ensuring internal consistency.

The typical model layout includes:

The model flows in one direction: assumptions drive the income statement, the income statement and supporting schedules drive the balance sheet, and the balance sheet drives the cash flow statement. The one exception is the circular reference between interest expense and cash, which we will address later.

Start by collecting three to five years of historical financial data from the company's 10-K filings (annual reports) or investor presentations. You need complete income statements, balance sheets, and cash flow statements.

Set up your spreadsheet with historical years on the left and forecast years on the right. A common layout uses annual periods for a 5-year forecast, though quarterly models are used for near-term analysis. Color-code your model from the start: blue font for hard-coded inputs and black font for formulas. This industry-standard convention makes models instantly readable to anyone reviewing your work.

Calculate key historical ratios and metrics that will become your forecast drivers:

These historical ratios become the basis for your forecast assumptions.

The income statement is the first statement you project because it drives much of the balance sheet and cash flow statement. Build it line by line from revenue to net income.

Revenue

Revenue is the single most important assumption in your model because everything else scales off it. For a basic model, you can project revenue using a simple growth rate assumption (for example, 8% annual growth). For more sophisticated models, build a revenue build-up by segment, product line, or geography.

Check your assumptions against analyst consensus estimates, management guidance, and industry growth rates. A revenue growth assumption that diverges significantly from consensus needs a clear rationale.

Cost of Goods Sold and Gross Profit

Project COGS as a percentage of revenue based on historical margins. If the company has been improving gross margins by 50 basis points per year, you might project continued modest improvement. If margins are stable, hold them flat.

Operating Expenses

Project SG&A, R&D, and other operating expenses as percentages of revenue, again based on historical trends. Consider whether the company has operating leverage (expenses growing slower than revenue) or is investing heavily in growth.

EBITDA and Operating Income

EBITDA is calculated by adding depreciation and amortization back to operating income. While EBITDA is not a line item you project directly, it serves as a critical check on your model. Compare your projected EBITDA margins to historical trends and peer companies.

Below the Line

Once you have operating income, you will come back later to add:

Supporting schedules are the backbone of a clean model. They calculate the detailed line items that feed into the main financial statements.

PP&E and Depreciation Schedule

PP&E Schedule

A supporting schedule that tracks the gross balance of property, plant, and equipment over time. It starts with the beginning balance, adds capital expenditures, subtracts disposals, and arrives at the ending gross balance. A separate line tracks accumulated depreciation to calculate the net PP&E that appears on the balance sheet.

The PP&E schedule follows a simple roll-forward:

Project capex as a percentage of revenue based on historical levels. Depreciation can be modeled as a percentage of the prior year's gross PP&E balance or as a percentage of revenue, depending on the company. The key is ensuring that depreciation in the income statement matches what flows from this schedule.

Working Capital Schedule

Working capital items (accounts receivable, inventory, accounts payable, and accrued liabilities) are forecast using days-based metrics:

Hold these days metrics flat at historical averages unless you have a reason to change them (for example, a company improving its collections process). The change in working capital from period to period flows into the cash flow statement.

Debt Schedule

The debt schedule tracks each tranche of debt separately: revolving credit facility, term loans, bonds, and any other borrowings. For each tranche, track:

If the company has a revolver, it acts as the balancing mechanism: the company draws on the revolver when it needs cash and repays it when cash is sufficient. This is where the circular reference originates, which we will address in Step 6.

Share Count and Equity Schedule

Track diluted shares outstanding by rolling forward the share count:

The equity section of the balance sheet also needs a retained earnings roll-forward:

With the income statement and supporting schedules built, you can now assemble the balance sheet projection.

At this point, your balance sheet will not balance because you have not yet filled in the cash line on assets or completed the interest expense line on the income statement. That is expected and gets resolved in the next steps.

Get the complete technical framework: Download our comprehensive 160-page PDF covering valuation, modeling, and deal structure questions. Access the IB Interview Guide for in-depth preparation.

The cash flow statement ties everything together. It reconciles net income with the actual cash generated or consumed during the period.

Cash From Operations

Start with net income and make the following adjustments:

Cash From Investing

Cash From Financing

Ending Cash Balance

This ending cash balance flows back to the balance sheet as the cash line item. At this point, your balance sheet should balance: total assets should equal total liabilities plus equity. If it does not, you have a linking error somewhere that needs to be traced and fixed.

The circular reference is the most conceptually challenging part of building a 3-statement model, and it is the question most likely to come up in a modeling test.

Here is the problem. Interest expense depends on the average debt balance. But the debt balance depends on how much cash the company generates. And cash generation depends on net income, which is reduced by interest expense. So interest expense depends on itself, creating a loop.

Circular Reference (Financial Modeling)

A situation in a financial model where a formula's output depends, directly or indirectly, on its own input. In 3-statement models, this most commonly occurs when interest expense is calculated using average debt balances, because the debt balance itself depends on cash flow, which depends on net income, which is reduced by interest expense.

There are three common approaches to resolving this:

Approach 1: Use beginning-of-period balances. Calculate interest expense based on the beginning debt balance rather than the average. This eliminates the circularity entirely because the beginning balance is known and does not depend on current-period cash flows. This is the simplest approach and is acceptable in most interview and modeling test contexts.

Approach 2: Enable iterative calculations. In Excel, go to File > Options > Formulas and check "Enable iterative calculation." This tells Excel to solve the circular formula by recalculating multiple times until the values converge. Use average debt balances for interest expense. This is technically more accurate but can mask errors if other unintended circular references exist in the model.

Approach 3: Use a circular reference switch. Create a toggle cell (1 = on, 0 = off) that multiplies your interest expense formula. When turned off, it breaks the circularity by setting interest to zero. When turned on, Excel iterates to solve it. If the model ever produces an error, you flip the switch off to reset it. This is the most common approach at investment banks.

Master interview fundamentals: Practice 400+ technical and behavioral questions, including financial modeling topics. Download our iOS app for comprehensive interview prep.

A model that runs without errors is not necessarily a correct model. Validation is critical before using any 3-statement model for analysis.

Key Checks

Common Errors to Watch For

Investment banks have strong opinions about how models should look and function. Following these conventions signals professionalism.

The 3-statement model is tested both conceptually and practically in investment banking interviews.

Building a 3-statement financial model is the most fundamental technical skill in investment banking. It teaches you how the financial statements connect, how business decisions flow through the numbers, and how to create a framework for answering virtually any analytical question about a company. Every other model you will build in your career, from DCF valuations to LBO analyses, is an extension of this foundation.

The process is methodical: gather historical data, project the income statement using margin and growth assumptions, build supporting schedules for assets and liabilities, assemble the balance sheet, construct the cash flow statement to solve for cash, and handle the circular reference between interest expense and the debt/cash balances. The model is complete when all three statements balance, all schedules reconcile, and changing any single assumption cascades correctly through the entire system.

Practice building 3-statement models repeatedly on real companies. Download 10-K filings, set up the structure, and build. Speed and accuracy come from repetition, not from reading about the process. The candidates who perform best in modeling tests are those who have built dozens of models and can construct the framework from muscle memory, freeing their mental energy to focus on the assumptions that actually drive the analysis.