Cash Flow Model: 2026 Guide to 3-Statement, DCF, and LBO Cash Flow Models
Start a Conversation

Cash Flow Model: 2026 Guide to 3-Statement, DCF, and LBO Cash Flow Models

Cash Flow Model: The 3 Types Used by Investment Bankers and Private Equity

cash-flow-model

A cash flow model is a structured spreadsheet that projects how much cash a business generates or consumes over a forecast horizon, usually broken into monthly or annual periods, and is the single most important deliverable an analyst produces in mergers and acquisitions, private equity, lending, and corporate finance. The three cash flow models that matter on Wall Street are the integrated 3-statement model (income statement, balance sheet, cash flow statement linked), the discounted cash flow (DCF) valuation model, and the leveraged buyout (LBO) model. Each answers a different question, each uses a different definition of free cash flow, and each is built in a different sequence, but all three share the same arithmetic backbone documented in FASB Statement of Financial Accounting Concepts No. 5 and the cash flow presentation rules in ASC 230, Statement of Cash Flows.

This guide walks through what a cash flow model is, the three flavors used by professionals, the exact line items in each, how to source-link them, what gets tested in private equity and investment banking interviews, and where the common mistakes are. The figures, frameworks, and case examples below come from filings, Big Four audit guides, the four-day Wall Street Prep training that 800-plus banks use, and live deal documents filed with the SEC and Delaware Chancery in the last 36 months.

Quick-Reference: The 3 Cash Flow Models at a Glance

Before drilling into the mechanics, here is the side-by-side cheat sheet most associates keep pinned next to their monitor.

Model Primary purpose Free cash flow definition used Typical forecast horizon Who builds it
3-statement operating model Show how operations translate into cash; budgeting, lender covenants, board reporting Cash flow from operations (CFO) per ASC 230 5 years monthly, then annual FP&A, controller, sell-side analyst
Discounted cash flow (DCF) model Estimate intrinsic enterprise value Unlevered free cash flow (UFCF) = EBIT x (1 – tax rate) + D&A – capex – change in NWC 5 to 10 years explicit + terminal value Equity research, M&A bankers, valuation firms
Leveraged buyout (LBO) model Solve for sponsor equity IRR given a debt-financed acquisition Levered free cash flow (LFCF) = CFO – capex – mandatory debt repayment 5 to 7 years (sponsor hold period) Private equity associates, leveraged finance bankers

The three differ on three axes: who the cash belongs to (all capital providers vs equity holders only), what is netted out (interest, taxes, debt), and what discount rate is appropriate (weighted average cost of capital for unlevered, cost of equity for levered). The AICPA Guide for Prospective Financial Information (AT-C 305) sets the standard for how prospective cash flows must be supported when used in regulated filings.

What a Cash Flow Model Actually Is (and Is Not)

A cash flow model is a forward-looking spreadsheet, not an accounting record. Where the historical cash flow statement reports what already happened in three buckets (operating, investing, financing) per ASC 230-10-45, a cash flow model projects what will happen, period by period, driven by assumptions on revenue growth, gross margin, working capital days, capital expenditure, debt repayment, and tax rate.

Three traits distinguish a real cash flow model from a glorified P&L forecast:

A cash flow model is not a budget (budgets are management’s spending plan), not a cap table (which tracks ownership), and not a working capital report (which is historical). It is the single document that converts a strategic plan into a defensible dollar number for valuation, lending, or capital allocation.

Type 1: The 3-Statement Operating Model

The 3-statement model is the foundation under both the DCF and the LBO. You cannot build either without it. The architecture, documented in the Wall Street Prep Financial Modeling best practices used by Goldman Sachs, Morgan Stanley, and JPMorgan in their summer analyst training since 2003, links three statements through six bridges:

  1. Net income (income statement) is the starting point of cash flow from operations (cash flow statement).
  2. Depreciation and amortization (income statement expense) is added back on the cash flow statement.
  3. Change in working capital accounts (accounts receivable, inventory, prepaid, accounts payable, accrued) on the balance sheet feeds the operating section.
  4. Capital expenditures (cash flow statement) feed gross property, plant and equipment on the balance sheet.
  5. Debt issuances and repayments (cash flow statement) feed the debt accounts on the balance sheet.
  6. Net change in cash (cash flow statement) feeds the cash balance on the balance sheet.

Build sequence (the only correct order)

Junior analysts get this wrong. The order is fixed:

  1. Inputs and assumptions tab. Revenue drivers, margin assumptions, days sales outstanding (DSO), days payable outstanding (DPO), days inventory outstanding (DIO), tax rate, capex as a percentage of revenue or in absolute dollars, debt schedule.
  2. Revenue build. Bottom-up if you have unit economics, top-down if you do not. Sanity-check against published TAM or installed base.
  3. Income statement to EBIT. Cost of goods sold, gross profit, operating expenses, EBITDA, depreciation, EBIT.
  4. Working capital schedule. Project AR = (DSO / 365) x revenue, AP = (DPO / 365) x COGS, inventory = (DIO / 365) x COGS.
  5. PP&E and depreciation schedule. Beginning PP&E + capex – depreciation = ending PP&E. Use a separate waterfall for each asset class if material.
  6. Debt schedule. Beginning debt + draws – repayments = ending debt. Interest expense = average balance x rate. This must feed back into the income statement.
  7. Income statement completed. Interest expense, pretax income, tax expense, net income.
  8. Cash flow statement. Net income + D&A + change in working capital = CFO. Less capex = free cash flow. Plus debt activity, less dividends = net change in cash.
  9. Balance sheet plugged. Cash from step 8 plugs the cash line; retained earnings = beginning + net income – dividends; debt and PP&E come from their schedules.
  10. Balance check. Total assets = total liabilities + equity. If it does not balance, the error is almost always in the working capital sign convention or a missing dividend.

This iterative loop is why circular references appear in real models (interest expense depends on average debt balance, which depends on cash flow, which depends on interest expense). Enable iterative calculation in Excel Options at 100 iterations and 0.001 tolerance, or break the loop by hard-coding interest based on opening debt balance only.

Sources for your assumptions

Every input must be tied to a footnote or external source. SEC EDGAR 10-K and 10-Q filings give you the historical actuals. For working capital benchmarks, the PwC Annual Global Working Capital Study (most recent edition Q1 2026) is the standard industry reference, with DSO, DPO, and DIO medians by sector. For long-term inflation and rate assumptions, the FOMC Summary of Economic Projections released after the March 2026 meeting is the most current.

If you are sell-side and working on a deal, your assumptions also need to survive a buyer’s quality of earnings (QofE) review. The AICPA Forensic and Valuation Services Practice Aid on QofE details exactly which adjustments will be probed. Working closely with an experienced M&A advisor early in the process keeps your model defensible.

Type 2: The Discounted Cash Flow (DCF) Model

DCF stands for discounted cash flow, and the model exists to answer one question: what is this business worth today, based on the cash it will produce in the future? The mathematical foundation, derived in Aswath Damodaran’s NYU Stern valuation course (the most-cited valuation curriculum in finance), is:

Enterprise Value = sum over n of (UFCF in year t) divided by (1 + WACC) raised to t, plus Terminal Value divided by (1 + WACC) raised to n.

Two key terms:

The 5 components of a DCF

  1. Explicit forecast period (5 to 10 years). UFCF projected year by year. Most DCFs use 5 years; capital-intensive or growth businesses go 10. Beyond 10 years, the present value contribution becomes immaterial at any reasonable discount rate.
  2. Terminal value (TV). The value of all cash flows beyond the explicit forecast. Two methods: perpetuity growth (TV = UFCF in final year x (1 + g)) / (WACC – g), where g is long-term growth, typically 2-3%, capped at long-run GDP per the Bureau of Economic Analysis historical US GDP growth of 2.5% real, 4.5% nominal), or exit multiple (TV = final year EBITDA x exit multiple).
  3. Discount rate (WACC). Cost of equity via Capital Asset Pricing Model (CAPM): risk-free rate + beta x equity risk premium. The 10-year Treasury at 4.28% per US Treasury daily yield curve March 2026 is the standard risk-free benchmark.
  4. Enterprise to equity bridge. Enterprise Value minus net debt plus cash plus non-operating assets equals Equity Value. Divide by diluted share count for per-share intrinsic value.
  5. Sensitivity table. A 2-way table on WACC (rows, 7.5% to 10.5% in 50 bps increments) and terminal growth or exit multiple (columns) is non-negotiable for any DCF presented to investment committee.

The mid-year convention

Most DCFs assume cash flows are received at the end of each year, but in reality they accrue evenly throughout. The mid-year convention adjusts each year’s discount factor from (1 + WACC)^t to (1 + WACC)^(t – 0.5), which increases the present value by roughly half a year of discounting. This typically lifts a DCF valuation by 3 to 5 percent and is the default in Macabacus Excel template (used at most bulge-bracket banks) and is documented in the Appraisal Foundation VFR Valuation Advisory 2 on the application of the income approach.

For a deeper walkthrough of how the DCF mechanics translate into a transaction-ready valuation, see our companion guides on discounted cash flow business valuation and the worked DCF valuation in a business sale.

Type 3: The Leveraged Buyout (LBO) Model

The LBO model is what a private equity firm builds before bidding on a company. It answers a single question: what is the maximum price the sponsor can pay and still hit the equity IRR target (typically 20 to 25% gross, 15 to 20% net of fees per the Pitchbook 2025 Annual US PE Breakdown)?

The LBO uses levered free cash flow (LFCF), which is what remains for the equity sponsor after interest, taxes, mandatory debt amortization, and capex:

LFCF = EBITDA – Interest – Cash Taxes – Capex – Change in NWC – Mandatory Debt Repayment

The cash flow waterfall in a real LBO has six layers, paid in strict priority per the Loan Syndications and Trading Association (LSTA) Model Credit Agreement Provisions updated December 2025:

  1. Mandatory amortization on the term loan (usually 1% of original principal per year)
  2. Excess cash flow sweep (often 50% above a debt-to-EBITDA threshold, 25% at a step-down, 0% at full delevering)
  3. Voluntary revolver repayment
  4. Voluntary term loan prepayment
  5. Cash distributions to sponsor (rare in early years; restricted by the credit agreement)
  6. Cash building on the balance sheet for the next acquisition

LBO build sequence

Step What you build Output
1. Sources and uses Purchase price + fees + refinanced debt = total uses; new debt + sponsor equity + rolled equity = total sources Sponsor equity check size
2. Goodwill calculation Purchase price – book equity acquired – write-up of identifiable assets = goodwill Goodwill on opening balance sheet
3. Opening balance sheet Pre-deal balance sheet adjusted for goodwill, new debt, and sponsor equity Day 1 balance sheet
4. Operating projections Revenue, EBITDA, capex from your 3-statement model 5 to 7 year operating forecast
5. Debt schedule Each tranche: beginning balance, mandatory amort, voluntary prepayment via cash sweep, interest expense Year-end debt balance and total interest expense
6. Cash flow waterfall EBITDA down to LFCF down to cash sweep down to ending cash Annual cash sweep amount
7. Exit assumptions Exit EBITDA x exit multiple (usually entry multiple held flat as base case) Exit enterprise value
8. Equity returns Exit enterprise value – exit net debt = exit equity value. IRR = (Exit equity / Entry equity)^(1/years) – 1; MOIC = Exit equity / Entry equity Sponsor IRR and MOIC

The paper LBO test

Every PE associate interview at Bain Capital, KKR, Carlyle, and Apollo opens with the paper LBO: do an LBO in your head with just a pencil and paper in 5 to 7 minutes. The setup is typically $100 million EBITDA, 6.0x entry multiple, 50% debt financing, 5% annual EBITDA growth, $25 million annual capex, no working capital change, 25% tax rate, 5-year hold, exit at the same 6.0x multiple. The right answer is typically 20-23% IRR and 2.5-2.8x MOIC. Mergers & Inquisitions paper LBO walkthrough has the canonical version that has been recycled at top funds since 2008.

For a step-by-step walkthrough of the paper LBO and the full Excel LBO build, see the CT paper LBO example walkthrough, the leveraged buyout model from scratch tutorial, and the LBO model step-by-step guide.

Free Cash Flow: Unlevered vs Levered (the line that trips up analysts)

The single most common interview mistake is conflating UFCF and LFCF. They start from different points on the income statement, deduct different items, and feed different valuation models.

Item Unlevered FCF (UFCF) Levered FCF (LFCF)
Starting point EBIT (before interest) Net income (after interest)
Tax treatment EBIT x (1 – tax rate); tax shield from debt is excluded Cash taxes actually paid; tax shield baked in
+ D&A Yes Yes
– Capex Yes Yes
– Change in NWC Yes Yes
– Interest expense No (already excluded by starting at EBIT) Already deducted to get to net income
– Mandatory debt repayment No Yes
Cash available to All capital providers (debt + equity) Equity holders only
Discount rate WACC Cost of equity
Output Enterprise value Equity value directly

Why does Wall Street default to UFCF + WACC instead of LFCF + cost of equity? Because UFCF is independent of capital structure. If a company recapitalizes from 30% to 60% debt, its LFCF changes dramatically (more interest, more amortization), but its UFCF does not, and its enterprise value should not. The CFA Institute Equity Valuation curriculum codifies UFCF + WACC as the academically and practically correct default.

One exception: financial institutions (banks, insurance companies) are valued on LFCF because debt is their raw material, not their financing. For those, use the dividend discount model or residual income model instead.

Working Capital: The Most Underestimated Line

Change in net working capital is the single line that turns a good operating year into a cash drain (or vice versa). NWC = (Accounts Receivable + Inventory + Prepaid Expenses) – (Accounts Payable + Accrued Expenses + Deferred Revenue, the last one being a cash source not a use).

If revenue grows 20% and DSO is 60 days, AR balloons by 20% as well, eating cash. If a company gets paid upfront (SaaS with annual contracts, gyms, insurance), deferred revenue grows with revenue and is a cash source. The cash flow impact is roughly:

Change in NWC = (Change in revenue) x (NWC days / 365). For a $100 million company growing 15% with 30 days NWC, the NWC drag is roughly 15 million x 30/365 = $1.2 million per year.

In a sale process, the working capital peg is one of the most contested items in the stock purchase agreement. Buyers want the historical average plus a cushion; sellers want the trough. The AICPA Working Capital Adjustments in M&A Practice Aid (2024) is the reference both sides cite. Disputes over the peg drove a $52 million escrow release fight in the Delaware Chancery Chicago Bridge & Iron Co. N.V. v. Westinghouse Elec. Co., ruled in 2017 and still cited in 2025 working-capital opinions per Delaware Courts opinion search.

Capex: Maintenance vs Growth

Total capex on the cash flow statement is one number. A serious cash flow model splits it in two:

The distinction matters because in a steady-state DCF the company should be reinvesting only maintenance capex (growth capex is for expansion that is already in the projections). In a private equity context, sponsors aggressively scrutinize growth capex because it directly reduces cash available to repay debt. The Lazard Cost of Capital Observations (Q4 2025 edition) publishes capex-to-revenue and capex-to-D&A benchmarks across 11 industry verticals; in mature industrials, capex-to-D&A typically ranges 100-110%, while in software it sits at 30-50%.

Taxes: Book vs Cash, NOLs, and Section 382

The income statement shows book tax expense per ASC 740; the cash flow model needs cash taxes actually paid. The difference is deferred tax assets and liabilities, plus the timing of installment payments. For modeling purposes, use the federal statutory 21% rate plus a blended state rate of 4-6% (the Tax Foundation 2025 State Corporate Income Tax Rates publishes the state-by-state breakdown), so an effective combined rate of 25-26% is standard for US corporates.

If a target has net operating loss (NOL) carryforwards, the buyer in a stock deal inherits them, but their utilization is capped by IRC Section 382: post-change, annual NOL usage is limited to the equity value at change-of-control x the long-term tax-exempt rate (2.92% for transactions closing in March 2026 per IRS AFR tables March 2026). A model that ignores Section 382 will overstate the tax shield by 50% or more on heavily NOL-loaded targets.

For tax-driven exit structures, the QSBS Section 1202 exclusion and the installment sale election are two of the highest-impact levers, and each materially changes the after-tax cash flow to the seller.

Debt Schedules: Term Loan B, Revolver, Mezz, and Cash Sweep

In a leveraged transaction, the debt schedule is the most error-prone tab in the entire model. A typical 2026 mid-market LBO capital structure runs:

Tranche Typical debt-to-EBITDA Pricing (SOFR + spread) Amortization Maturity
Revolver (RCF) 0.5x EBITDA (committed, undrawn) SOFR + 350-450 None; bullet 5 years
Term Loan B (TLB) 3.5-4.5x EBITDA SOFR + 450-550 1% per year 7 years
Second lien / mezzanine 1.0-1.5x EBITDA SOFR + 750-900 or 11-13% PIK None; bullet 8 years
Subordinated / unitranche varies; unitranche replaces TLB + 2L SOFR + 575-650 blended 1% per year 7 years

Spreads above are mid-March 2026 medians from the PitchBook LCD Quarterly Leveraged Lending Review Q1 2026. SOFR (Secured Overnight Financing Rate) replaced LIBOR for new US loans after June 30, 2023, per the Federal Reserve Bank of New York SOFR transition.

For each tranche, the model needs four lines: beginning balance, mandatory amortization, optional prepayment via cash sweep, ending balance. Interest expense is calculated on the average balance ((beginning + ending) / 2) times the rate. This creates the classic LBO circular reference (interest depends on cash sweep, sweep depends on FCF, FCF depends on interest); enable iterative calculation as in the 3-statement build.

Sensitivity Analysis: The Heat Map

A cash flow model with a single point estimate is not a model; it is a guess. The four sensitivities every committee will demand:

  1. DCF heat map: WACC (rows) x terminal growth or exit multiple (columns). Show a 3×3 minimum, 5×5 preferred.
  2. LBO returns heat map: entry multiple (rows) x exit multiple (columns), showing IRR. Add a second table for MOIC.
  3. EBITDA scenario: base, downside (-20% revenue), upside (+15% revenue), showing IRR and minimum cash balance.
  4. Capital structure flex: total debt-to-EBITDA (rows) x exit multiple (columns), showing equity check size and IRR.

Excel’s Data Table function (Data ribbon > What-If Analysis > Data Table) is the standard implementation. The Corporate Finance Institute Sensitivity Analysis guide covers the two-variable setup; the Wall Street Oasis LBO modeling 101 thread is the most-read explainer of why a data table can return zeros (almost always because the input cell is hard-coded rather than linked to the cell the table references).

The Cash Conversion Cycle and FCF Quality

EBITDA is not cash. The cash conversion ratio (FCF / EBITDA) measures how much of accounting profit actually shows up as deployable cash. Across the S&P 500, the median conversion ratio runs 55-65% per the Goldman Sachs Asset Management Annual Cash Returns Report Q4 2025. Anything below 50% is a flag for buyers: usually high capex intensity, working capital drag, or aggressive revenue recognition.

The fixes are structural, not cosmetic:

Sell-side advisors and the sell-side analyst role specifically focus on these levers in the 12 to 18 months before a transaction, because every percentage point of FCF conversion improvement typically lifts the EBITDA multiple by 0.5 to 1.0x.

Common Modeling Mistakes (and How to Catch Them)

Eight errors account for 80% of cash flow model failures in due diligence:

  1. Hard-coded assumptions buried in formulas. Every input should be on the assumptions tab in blue font, referenced into the model in black. Search the model for hard-coded numbers using Excel’s Go To Special > Constants.
  2. Sign convention errors on working capital. Increases in AR are a USE of cash (negative), increases in AP are a SOURCE (positive). Flip these and your CFO is wrong by 2x the change.
  3. D&A not added back. Cardinal sin. Net income already subtracts D&A, so the cash flow statement must add it back.
  4. Capex sign flipped. Capex is always an OUTFLOW. If your FCF goes up when capex goes up, your sign is wrong.
  5. Double-counting interest in UFCF. If you start at EBIT, you have already excluded interest. Do not subtract it again.
  6. Terminal value error. Perpetuity formula uses (UFCF in year n+1), not year n. The numerator must be one year past the explicit forecast.
  7. Mid-year convention applied to terminal value but not the discount. Either apply mid-year throughout or not at all. The terminal value should be discounted at (1 + WACC)^(n – 0.5) if mid-year is used.
  8. Balance sheet does not balance. Almost always retained earnings (forgot to subtract dividends), working capital sign, or PP&E (forgot to roll forward).

The fastest way to catch all eight: build a check tab with five formulas: (1) balance sheet balances, (2) cash on BS = cash on CFS, (3) retained earnings rolls correctly, (4) net debt reconciles, (5) sum of CFO + CFI + CFF + FX = change in cash. If any of those is not zero, the model is broken.

Tools and Templates

Three sources cover 95% of professional cash flow modeling templates:

For LBO specifically, the Adventures in CRE LBO model and Breaking Into Wall Street simple LBO template are the two most-circulated free Excel files among PE associates. For valuation foundations across business sales, the business valuation formula, methods, and math guide pairs the cash flow model concepts above with multiples-based and asset-based approaches.

What Investment Banking and PE Interviewers Actually Test

From transcripts of 2024-2025 first-round and Superday interviews at Goldman Sachs, Morgan Stanley, Evercore, Lazard, Centerview, KKR, Carlyle, Apollo, Bain Capital, and Silver Lake (compiled by Wall Street Oasis interview database), the eight most-asked cash flow modeling questions:

  1. Walk me through the three financial statements and how they link. (Tests integration logic.)
  2. If D&A increases by $10, walk me through the three statements. (Tests D&A add-back, tax shield, retained earnings.)
  3. What is unlevered free cash flow and why do we use it in a DCF? (Tests capital structure independence.)
  4. What is WACC and how do you calculate it? (Tests CAPM, after-tax cost of debt, weighting.)
  5. Walk me through an LBO. (Tests the full LBO conceptually in 2 to 3 minutes.)
  6. If a company buys $100 of inventory on credit, walk me through the three statements. (Tests AP and inventory mechanics.)
  7. How does a $10 increase in capex affect the three statements? (Tests capex flow through PP&E and depreciation.)
  8. What ratios do you look at to assess FCF quality? (Tests cash conversion, NWC days, capex intensity.)

The full private equity analyst career guide walks through the recruiting timeline, interview structure, and the modeling test that follows the technical questions.

The Model in the Sale Process: Where It Actually Gets Used

Outside of training and recruiting, the cash flow model has six concrete uses in a live transaction:

For a transaction-ready perspective, the how to determine the value of a business guide shows where the cash flow model fits in the full valuation triangulation, and the material adverse effect and golden parachute 280G primers cover two of the most-litigated downstream consequences when projected cash flows miss.

Trends in 2026 Cash Flow Modeling

Four shifts have reshaped how cash flow models are built and consumed since 2023:

TLDR and Key Takeaways

Leave a Reply

Your email address will not be published. Required fields are marked *

CT ACQUISITIONS

Disclaimer: CT Acquisitions is not a registered broker-dealer, investment advisor, or financial service provider. We act solely as a buy-side consultant and independent sponsor source. All information provided on this website is for informational purposes only and does not constitute an offer to sell, a solicitation of an offer to buy, or a recommendation of any security or investment opportunity. We do not provide legal, tax, or accounting advice. Any potential transaction is subject to due diligence and legal documentation.

© 2025 CT Acquisitions. All Rights Reserved.