The statements · in 12 models

Cash flow statement

Indirect method, closing on balance-sheet cash.

By Surojit Chakraverti, founder of L3VLUP and an investor running a long-short healthcare and technology equities strategy.

On this subject: cash flow statement.Updated 30 September 2026

Part of m&a and private equity models, with the models, labs and guides around it.

Part of project finance and infrastructure models, with the models, labs and guides around it.

Part of technology company financial models, with the models, labs and guides around it.

What it does

The indirect method: start from net income, add back non-cash charges, subtract the increase in working capital, and you have operating cash flow. Investing takes capex; financing takes debt movements and dividends. The closing cash is the balance-sheet cash. In an LBO the same logic is compressed into cash flow available for debt service.

Where it lives

The same schedule in each model that carries it, with the rows to open. Open a model in the browser, go to the sheet, and click the lines.

Integrated three-statement model
  • Cash Flow, rows 6–9: Net income, Depreciation, Increase in net working capital, Cash from operations
  • Cash Flow, rows 23–25: Net change in cash, Opening cash, Closing cash
Discounted cash flow model
  • Forecast, row 15: Add back depreciation and amortisation
  • Forecast, rows 19–20: Unlevered free cash flow, Cash conversion
Leveraged buyout model
  • Operating Model, rows 20–21: Add back depreciation and amortisation, Add back financing fee amortisation
  • Operating Model, rows 25–26: Free cash flow before debt repayment, Free cash flow / EBITDA
Airline operating and valuation model
  • Financials, rows 34–44: Net income, Add depreciation and amortisation, Less increase in net working capital, Cash from operations…
Multi-store retail model
  • Cash Flow, rows 27–40: EBITDA under IFRS 16, Tax, Less: increase in net working capital, Interest earned on cash…
Restaurant franchise roll-out model
  • Cash Flow, rows 19–28: EBITDA, Tax, Interest, Less: increase in net working capital…
Duolingo operating model
  • Reported, rows 35–39: Net cash provided by operating activities, Purchases of property and equipment, Capitalised software development costs and intangibles, Free cash flow, as reported (current definition)…
  • Reported, rows 42–45: Cash and cash equivalents, Deferred revenues (current), Operating lease liabilities, Stockholders’ equity
  • Forecast, rows 47–53: Depreciation and amortisation, % of revenue, Capital spending (property and software), % of revenue, Deferred revenue / revenue, Other working capital outflow, % of revenue growth…
  • P&L & Cash Flow, rows 38–45: Change in deferred revenue, Other working capital outflow, Net cash from operating activities, Property, equipment and capitalised software…
Airbnb operating model
  • Reported, rows 69–84: Net cash provided by operating activities, Change in unearned fees (operating cash flow), Deferred income taxes (operating cash flow), Cash paid for income taxes, net of refunds…
  • Derived, rows 87–101: Gross Booking Value, Less what GBV carried beyond Airbnb’s own revenue, including timing (a residual), Less incentives and refunds netted from revenue, Revenue: Airbnb’s service fees…
  • Derived, rows 126–136: Repurchases / free cash flow, Average price paid per share repurchased, derived, Shares issued to employees, net (change in shares outstanding + shares repurchased), Shares issued to employees, % of opening shares outstanding…
  • Forecast, rows 77–87: Depreciation and amortisation, % of revenue (editorial), Purchases of property and equipment, % of revenue (editorial), Interest earned on opening company liquidity (editorial), Share of interest income earned on customer funds (editorial)…
  • P&L & Cash Flow, rows 36–45: Opening company liquidity (cash + short-term investments), Interest income, Of which on company liquidity, Of which on customer funds (editorial share)…
  • P&L & Cash Flow, rows 54–60: Deferred tax: book tax less tax paid in cash, Other operating items (other working capital), Net cash provided by operating activities, Purchases of property and equipment…
  • P&L & Cash Flow, rows 63–70: Repurchases of common stock, Taxes paid on equity awards, Debt at year end: the convertible notes, then the senior notes, Debt issued less repaid…
Spotify operating model
  • Reported, rows 54–60: Net cash flows from operating activities, Purchases of property and equipment (capital expenditures), Change in restricted cash (investing), Free Cash Flow, as reported (non-IFRS)…
  • Derived, rows 46–53: Free cash flow rebuilt: operating cash flow - capex + change in restricted cash, Free cash flow margin, Free cash flow less share-based compensation, Free cash flow less SBC / net income…
  • Forecast, rows 61–70: Depreciation and amortisation, % of revenue (editorial), Capital expenditures, % of revenue (editorial), Working capital inflow, % of the increase in revenue (editorial), Lease payments a year (editorial)…
  • P&L & Cash Flow, rows 51–60: Book tax not paid in cash, Working capital and other operating items, Net cash flows from operating activities, Capital expenditures less the change in restricted cash…
CoreWeave operating model
  • Reported, rows 33–45: Depreciation and amortisation, Change in deferred revenue (operating cash flow), Change in accounts receivable (operating cash flow, as a cash flow), Net cash provided by operating activities…
  • Reported, rows 192–212: Revenue, first half of 2025, Revenue, first half of 2026, Total operating expenses, first half of 2026, Operating loss, first half of 2026…
  • Derived, rows 26–31: Deferred revenue at the year end, current and non-current, Cash from customers, approximated: revenue + rise in deferred revenue - rise in receivables, Operating cash flow less purchases of property and equipment, The same, less stock-based compensation…
  • P&L & Cash Flow, rows 31–36: Gain (loss) on fair value adjustments, Interest expense, net, Other income, net, Income (loss) before tax…
  • P&L & Cash Flow, rows 39–45: Accounts receivable at the year end, Deferred revenue at the year end: customer prepayments not yet earned, Cash from customers: revenue + rise in deferred revenue - rise in receivables, Net cash provided by operating activities…
Adyen operating model
  • Reported, rows 69–75: Net cash flows from operating activities, Change in payables to merchants and financial institutions, Change in receivables from merchants and financial institutions, Income taxes paid…
  • Derived, rows 105–110: Free cash flow rebuilt: EBITDA less CapEx and lease payments, Free cash flow conversion, % of EBITDA, CapEx, % of net revenue, Lease payments, % of net revenue…
  • P&L & Cash Flow, rows 75–82: CapEx, Lease payments, excluding interest, Free cash flow (Adyen’s definition), Free cash flow conversion, % of EBITDA…
AerCap operating model
  • Reported, rows 63–70: Net cash provided by operating activities, Purchase of flight equipment, Prepayments on flight equipment paid, Proceeds from sale or disposal of assets…

What a reviewer looks for

  • Signs: a use of cash shown as a source.
  • An item that moves on the balance sheet with no line here to carry it.
  • Closing cash entered as a hardcoded number rather than derived.

Learn it, then build it

Vocabulary: The Three Financial Statements, Working Capital.

Other the statements