DCF vs LBO vs 3-Statement: Which Financial Model Should You Use?

The three-statement model, DCF, and LBO are the cornerstones of financial analysis - but many professionals don't know when to use each one. A 3-statement model is your foundation for forecasting; DCF is for valuation; and LBO is for private equity deals. Choose the right model for your use case, and you'll produce analysis that actually drives decisions.

Financial modelling can feel overwhelming when you're starting out. Which model should you build? How do they connect? And when do you actually need all three?

The answer lies in understanding the purpose of each model. The 3-statement financial model is a forecast engine. The DCF model is a valuation calculator. The LBO model is a return optimizer for leveraged acquisitions.

This guide walks you through all three, shows how they connect, and reveals exactly when to use each one.

How the 3-Statement Model Feeds Both DCF and LBO Analyses

The 3-Statement Model: Your Forecasting Foundation

Purpose

The 3-statement financial model is the bedrock of corporate finance. It links three financial statements - the income statement, balance sheet, and cash flow statement - into one dynamically connected system. Changes in one statement flow through to the others automatically.

The 3-statement model answers the question: If the company grows at this rate, with these margins, and these working capital needs, what will its financial position look like in three to five years?

When to Use It

• Financial forecasting: You need forward-looking projections of revenue, expenses, and cash flow.
• Scenario analysis: You want to stress-test how changes in assumptions (growth rate, operating margin, CapEx) affect financial outcomes.
• Baseline for other models: A 3-statement model is the input foundation for DCF and LBO models.
• General due diligence: Any M&A, equity investment, or lending decision starts with a solid 3-statement forecast.

The Mechanics: How It Works

The 3-statement model works in three steps:

1. Build the Income Statement. Start with revenue and project operating expenses (COGS, S&M, R&D, G&A) to arrive at operating income. Then calculate interest expense, taxes, and net income.

2. Build the Balance Sheet. Link net income to retained earnings. Project working capital (AR, inventory, AP) based on business metrics like Days Sales Outstanding (DSO). Add a debt schedule and a PP&E schedule to track how those assets change over time.

3. Build the Cash Flow Statement. Start with net income, add back depreciation (non-cash), adjust for changes in working capital, subtract CapEx, and account for debt changes. This gives you the net change in cash each year.

The final connection: Closing Cash from the CFS links back to the Cash line on the Balance Sheet. This makes the model "dynamic" - change a revenue growth assumption, and cash automatically updates.

For a detailed step-by-step walkthrough, see our guide to building a 3-statement financial model.

Key Outputs

• Projected P&L (revenue, EBIT, net income)
• Projected balance sheet (assets, liabilities, equity)
• Projected free cash flow (cash available to all investors)
• Working capital requirements
• Net debt trajectory

The DCF Model: Valuation Through Discounting

Purpose

The DCF (Discounted Cash Flow) model takes future free cash flows from a 3-statement model and discounts them back to present value to calculate what a business is worth today.

The DCF answers the question: If a company will generate these cash flows, what is the intrinsic value of those cash flows in today's dollars?

DCF is the most theoretically rigorous valuation method. It's based on a simple principle: a cash flow in the future is worth less than the same cash flow today (because you could invest it and earn a return). DCF calculates that discount factor.

When to Use It

• Equity research: Valuing public companies for buy/sell/hold recommendations.
• M&A valuation: Determining the intrinsic value of an acquisition target.
• Investment decisions: Assessing whether a company is undervalued or overvalued.
• Capital budgeting: Evaluating whether a project will create shareholder value.
• Startup valuations: Projecting long-term cash flows to justify early-stage valuations.

The Mechanics: How It Works

DCF requires four inputs:

1. Explicit Forecast Period. Project free cash flow for 5-10 years using your 3-statement model. This is your detailed phase.

2. Terminal Value. Estimate the value of the company beyond your explicit forecast period (often 95% of DCF value). Two methods:

   • Gordon Growth Model: TV = Final Year FCF × (1 + g) / (WACC - g), where g is a perpetual growth rate (typically 2-3%).
   • Exit Multiple: TV = Final Year EBITDA × Exit Multiple (e.g., 8x).

3. Discount Rate (WACC). Calculate the Weighted Average Cost of Capital, which is the blended cost of funding (debt + equity). WACC reflects the risk of the business.

   WACC = (E/V × Re) + (D/V × Rd × (1 - Tax Rate))
   

   Where:

   • E = market value of equity
   • D = market value of debt
   • V = E + D (total value)
   • Re = cost of equity (often calculated using CAPM)
   • Rd = cost of debt (interest rate on borrowings)

4. Present Value Calculation. Discount each year's free cash flow to present value using WACC as the discount rate:

   PV = FCF₁ / (1 + WACC)¹ + FCF₂ / (1 + WACC)² + ... + FCF₅ / (1 + WACC)⁵ + TV / (1 + WACC)⁵
   

The sum of all discounted cash flows (including terminal value) is the Enterprise Value of the business. Subtract net debt, and you have Equity Value.

For a detailed DCF tutorial, see our guide to building a DCF model in Excel.

Key Outputs

• Enterprise Value (what the business is worth)
• Equity Value (what shareholders own)
• Implied valuation multiples (price-to-earnings, EV/EBITDA)
• Sensitivity tables (how value changes with WACC and terminal growth rate)
• Upside/downside case scenarios

The LBO Model: Optimizing Returns in a Leveraged Deal

Purpose

The LBO (Leveraged Buyout) model is specialized for private equity transactions. It answers the question: If we buy this company with 60% debt and 40% equity, hold it for five years, and improve operations, what returns will we generate for the sponsor (investor)?

LBO models are fundamentally different from DCF. They don't value the business; they model the investor's return on the deal structure.

When to Use It

• Private equity investment decisions: Assessing whether a leveraged acquisition will hit return targets (typically 20-30% IRR).
• LBO structuring: Determining debt capacity and equity sizing.
• Dividend recapitalization: Modeling cash returns to sponsors during the holding period.
• Exit strategy analysis: Comparing different sale scenarios (IPO, strategic sale, secondary buyout).
• M&A deal contingency: Testing whether a deal makes sense under a leveraged structure.

The Mechanics: How It Works

LBO models are more complex than DCF because they track the sponsor's investment and returns across a holding period (typically 5-7 years). The key mechanics:

1. Sources and Uses. Calculate the purchase price and how it's funded.

   • Uses: Enterprise Value of acquisition + transaction fees + working capital adjustments
   • Sources: Debt financing + sponsor equity

2. Debt Schedule. Track debt paydown over time. This is critical because:

   • Interest expense is calculated on declining debt balances.
   • Debt paydown reduces leverage (a key sponsor KPI).
   • Debt capacity is often driven by maintaining debt/EBITDA covenants.

3. Operating Projections. Use a 3-statement model to project revenue, EBIT margin, and free cash flow. The LBO assumes operational improvements (revenue synergies, cost cuts) to boost cash generation.

4. Debt Paydown vs. Dividends. The model allocates excess cash to either:

   • Debt repayment (required if covenants are tight)
   • Sponsor dividends (if the deal generates excess cash)
   • Retained cash (for growth CapEx)

5. Exit Analysis. Project the exit value after 5-7 years using:

   • Exit revenue × exit multiple (e.g., 8x EBITDA)
   • Or assume a growth in EBITDA and apply a multiple

6. Returns Analysis. Calculate the sponsor's IRR and Money Multiple (cash returned ÷ cash invested):

   • IRR = the annual return the sponsor earns on their equity investment
   • MoM (Money Multiple) = total cash returned (dividends + exit proceeds) ÷ initial equity investment

The goal: achieve 20-30% IRR and a 2-3x money multiple over the holding period.

For a detailed LBO tutorial, see our guide to building an LBO model.

Key Outputs

• Debt schedule (opening balance, new debt, repayments, closing balance, leverage ratios)
• Free cash flow waterfall (operating cash flow minus CapEx and debt paydown)
• Sponsor returns (dividends and exit proceeds)
• IRR and money multiple analysis
• Sensitivity tables (IRR sensitivity to EBITDA exit multiple and leverage)
• Covenant compliance (debt/EBITDA, interest coverage ratio)

Side-by-Side Comparison

How They Connect: The Modelling Hierarchy

flowchart TD
    A[3-Statement Model] -->|Free Cash Flow| B[DCF Model]
    A -->|Operating Projections| C[LBO Model]
    B -->|Valuation| D[Investment Decision]
    C -->|Returns Analysis| E[PE Investment Decision]
    A -->|Financial Forecast| F[Scenario Analysis]

The 3-statement model sits at the foundation. It produces:

• Net Income (feeds into valuation metrics)
• Free Cash Flow (the core input to DCF)
• Operating cash flow and working capital (required for LBO modeling)

The DCF and LBO models are built on top of the 3-statement model. They use its projections differently:

• DCF takes unlevered free cash flow (cash available before debt service) and discounts it to value the entire business.
• LBO takes levered free cash flow (after interest and debt paydown) to model sponsor equity returns.

In M&A, you typically build all three:

1. 3-statement model: Project target's financials under current ownership
2. DCF model: Calculate intrinsic valuation (seller's reference point)
3. LBO model: Calculate sponsor returns under a leveraged structure (PE buyer's reference point)

Comparing DCF value to LBO returns tells you whether a deal is attractive.

Comparing Outputs: What Each Model Tells You

3-Statement Model Outputs

• Revenue trajectory and margins over time
• Operating cash flow generation
• Working capital intensity (DSO, DIO, DPO days)
• Debt requirements and repayment capacity
• Equity growth through retained earnings

Use these outputs to: Understand the company's cash generation profile, forecast capital needs, and plan for growth.

DCF Model Outputs

• Enterprise Value (fair value of the entire business)
• Implied valuation multiples (what investors will pay for earnings and cash flow)
• Sensitivity analysis (how valuation changes with WACC and growth assumptions)
• Bull/base/bear case valuations
• Upside and downside to a reference price (e.g., current stock price)

Use these outputs to: Set a valuation range for M&A negotiations, justify an IPO price, or identify undervalued investment opportunities.

LBO Model Outputs

• Sponsor IRR and money multiple
• Debt paydown schedule and leverage ratios (debt/EBITDA)
• Implied exit multiple needed to hit return targets
• Dividend capacity during the holding period
• Sensitivity of returns to operational upside and exit multiple

Use these outputs to: Assess deal attractiveness, structure financing, and negotiate equity checks with co-investors.

Comparing the Mechanics: Build Order and Dependencies

3-Statement Model Build Order

1. Create an Assumptions sheet (revenue growth, margins, working capital drivers).
2. Build the Income Statement (top-down: revenue → EBIT → net income).
3. Build the Balance Sheet (link net income to equity; project working capital and fixed assets).
4. Build the Cash Flow Statement (indirect method: net income → operating cash flow → free cash flow).
5. Link closing cash from CFS back to the Balance Sheet.
6. Add a balance check formula (Assets = Liabilities + Equity).
7. Stress-test with scenarios (upside, base, downside cases).

DCF Model Build Order

1. Take free cash flow from the 3-statement model.
2. Project 5-10 years of detailed cash flow.
3. Calculate terminal value (Gordon Growth or Exit Multiple method).
4. Estimate WACC (cost of equity + after-tax cost of debt).
5. Discount all cash flows to present value.
6. Calculate enterprise value and subtract net debt for equity value.
7. Build sensitivity tables (IRR sensitivity to WACC and terminal growth).
8. Compare to stock price or comparable valuations.

LBO Model Build Order

1. Create a Sources and Uses table (purchase price, financing).
2. Build a debt schedule (opening → new debt → repayments → closing balance).
3. Project operating performance using a simplified 3-statement model.
4. Calculate free cash flow available for debt paydown and dividends.
5. Model debt paydown and covenant compliance (debt/EBITDA).
6. Assume an exit year and exit multiple; calculate exit proceeds.
7. Calculate sponsor returns: (Exit Proceeds + Dividends) ÷ Initial Equity = Money Multiple.
8. Calculate IRR (internal rate of return on equity investment).
9. Build sensitivity tables (IRR sensitivity to exit multiple and EBITDA growth).

How They Connect: 3-Statement Feeds DCF and LBO

The 3-statement model is the engine that powers the other two.

Connection to DCF

• The 3-statement model produces Free Cash Flow (FCF) in the Cash Flow Statement.
• DCF takes this FCF, projects it 5-10 years forward, and discounts it to present value.
• If your 3-statement assumptions are wrong (revenue growth too aggressive, margins too high), your DCF valuation will be wrong.

Connection to LBO

• The 3-statement model projects EBITDA (earnings before interest, taxes, depreciation, amortization), which drives LBO returns.
• Higher EBITDA means more cash to pay down debt, which improves sponsor returns.
• The LBO model then applies leverage (debt financing) and calculates what the sponsor earns after interest and repayment.
• If operational assumptions are weak, the LBO can't achieve return targets even with aggressive debt leverage.

A Real Example: Acquiring a SaaS Company

Imagine you're evaluating the acquisition of a SaaS company generating £10M in annual revenue with 40% EBITDA margins.

3-Statement Model: You project revenue growing 25% annually for five years, margins improving to 45% as the company scales. This gives you a path to £40M+ revenue and £18M+ EBITDA by year 5.

DCF Model: You take the free cash flow from this projection and discount it at 10% WACC. You assume the company will be valued at 8x EBITDA in year 5 (exit multiple). You calculate enterprise value of £150M.

LBO Model: You structure the acquisition with £100M debt (6.7x EBITDA at entry) and £50M sponsor equity. You model EBITDA growing to £18M, use it to pay down debt to 3x leverage, and assume a £150M exit in year 5. Sponsor returns are 25% IRR and 2.5x money multiple.

The three models tell different stories:

• 3-statement: The company will be worth more in 5 years.
• DCF: At current growth and margin assumptions, it's worth £150M.
• LBO: A leveraged sponsor can achieve 25% IRR if they can operationally improve the company.

Use-Case Walk-throughs: When to Use Each Model

Use Case 1: Corporate Development (Strategic M&A)

Scenario: Your company wants to acquire a competitor for £200M. What's the deal worth?

Models to build:

1. 3-statement model of the target's financials for the next 5 years. Project revenue synergies and cost reductions from the acquisition.
2. DCF model to calculate intrinsic value. This is your negotiating floor - if you pay more than DCF value, you're overpaying.
3. (Optional) LBO model if a PE buyer might also be interested in bidding.

Output you need: Enterprise value from DCF (fair value) and estimated synergies. This tells you the max price to pay.

Use Case 2: Private Equity Investment

Scenario: A PE fund is evaluating a leveraged acquisition of a manufacturing company. Can it hit a 20% IRR target?

Models to build:

1. 3-statement model of the target with operational improvement plans (cost cuts, revenue acceleration, CapEx efficiency).
2. LBO model with debt structured at 4x leverage, 5-year hold, 8x exit multiple.

Output you need: Sponsor IRR and money multiple. If IRR < 20%, the deal doesn't make sense without better operational upside or a lower purchase price.

Use Case 3: Investment Banking Advisory

Scenario: You're advising the seller of a business. What fairness opinion range should you provide?

Models to build:

1. 3-statement model of historical financials and projected growth (conservative case).
2. DCF model with bull, base, and bear case assumptions.
3. Comparable companies analysis (multiples approach).

Output you need: A range of valuations (e.g., £150M–£180M) based on DCF and comps. This range anchors the negotiation.

Use Case 4: Equity Research and Public Company Analysis

Scenario: You're covering a software stock trading at 30x forward earnings. Is it overvalued?

Models to build:

1. 3-statement model of the company's financials with reasonable growth assumptions (based on historical trends and competitive position).
2. DCF model with industry-standard WACC and terminal growth rate. Compare DCF value to current stock price.

Output you need: Target price from DCF and upside/downside to current price. If stock is trading above DCF value, it's expensive; if below, it's a buy.

Use Case 5: Founder Fundraising

Scenario: You're a founder raising a Series B. Investors want to see financial projections and a valuation framework.

Models to build:

1. 3-statement model of revenue (top-down by product line), expenses (headcount-based), and cash runway.
2. DCF model assuming venture scale (100x+ revenue multiple) and venture exit timeline (7-10 years). OR use comparable venture multiples (e.g., 20-50x revenue for high-growth SaaS).

Output you need: A clear 5-year forecast and a valuation that's defensible to investors. Don't use DCF directly; use market comparables and revenue multiples instead. VCs don't value using WACC and terminal growth - they use exit multiples.

Use Case 6: FP&A and Corporate Planning

Scenario: Your CFO wants a rolling 5-year forecast for budget planning and board reporting.

Models to build:

1. 3-statement model with detailed assumptions (revenue by product line, headcount plan, CapEx timeline, tax rate).
2. No DCF or LBO needed. The 3-statement model is sufficient for internal planning.

Output you need: Monthly or quarterly cash flow forecast, headcount plan, and key metrics (EBITDA margin, free cash flow, headcount ratio). Use this for investor updates and internal dashboards.