The statements · in 15 models

Operating costs and margins

Cost of sales, opex, EBITDA.

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

On this subject: operating costs and margins.Updated 4 November 2026

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 lines between revenue and EBIT. Cost of sales is usually a gross margin; operating expenses are split by how they behave, a variable share of revenue for selling costs and a fixed base for overheads that rises with inflation and steps up when revenue outgrows the capacity of the cost base. Depreciation comes from the fixed-asset schedule. Because part of the cost base is fixed, EBIT moves further than revenue in both directions, and the degree of operating leverage measures by how much.

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
  • Assumptions, rows 15–19: Gross margin, base case, Gross margin, upside case, Gross margin, downside case, Gross margin, selected scenario…
  • Assumptions, rows 22–27: Selling and distribution, % of revenue, FY3A as filed, Selling and distribution costs, % of revenue, Fixed overheads, FY3A as filed, Fixed overheads, annual inflation…
  • Income Statement, rows 13–21: Selling and distribution costs (variable), Capacity step in fixed overheads, Fixed overheads (general and administrative), Operating expenses…
  • Operating Leverage, rows 6–15: Revenue, Revenue growth, Variable costs: cost of goods sold and selling, Contribution…
  • Operating Leverage, rows 18–20: EBIT growth, Degree of operating leverage, Change in EBIT margin
  • Operating Leverage, rows 23–31: Revenue growth increment, Fixed overheads increment, Fixed overheads, FY4E ($m), EBIT margin, FY4E…
Regulated utility model: electricity network
  • Assumptions, rows 26–30: Operating cost allowance, FY0 prices, Actual operating costs, FY0 prices, Cost inflation, Pass-through costs, FY0…
  • Earnings, rows 19–21: Operating cost allowance, Allowance less actual operating costs, EBITDA, % of revenue net of pass-through
Telecom tower model: tenancies per tower
  • Assumptions, rows 43–48: Ground rent per ground tower, FY0, Rooftop rent per rooftop, FY0, Site rent escalator, Maintenance per site, FY0…
  • Costs & EBITDAaL, rows 6–11: Cost index, Energy, recovered from tenants, Maintenance, Colocation servicing…
  • Costs & EBITDAaL, rows 14–19: Total revenue, Portfolio revenue, EBITDA, Site rents…
  • Costs & EBITDAaL, rows 22–27: EBITDA margin, on total revenue, EBITDA margin, excluding pass-through, EBITDAaL margin, on total revenue, EBITDAaL margin, excluding pass-through…
Container shipping model: liner company
  • Assumptions, rows 40–48: Charter hire, FY0, Charter hire growth, base case, Cargo handling, FY0, Port and canal charges, FY0…
  • Operating Costs, rows 6–13: Bunker fuel, Charter hire, Charter hire, Cargo handling…
  • Operating Costs, rows 16–19: Revenue, EBITDA, EBITDA margin, EBITDA per TEU lifted
  • Operating Costs, rows 22–25: Operating costs per TEU lifted, EBITDA break-even freight rate, Freight rate above break-even, Change in EBITDA for a 1% change in the freight rate
Consumer lending model: loan vintages
  • Assumptions, rows 40–44: Acquisition cost per loan, FY0A, Servicing and collections, % of average receivables, Technology and overhead, FY0A, Cost inflation…
  • Income Statement, rows 19–24: Customer acquisition, Customer acquisition, % of originations, Servicing and collections, Technology and overhead…
Restaurant franchise roll-out model
  • Assumptions, rows 60–64: Corporate costs, FY0, Field management per company restaurant, FY0, Franchise support per franchised restaurant, FY0, Corporate costs taken out per restaurant refranchised…
  • Profit, rows 23–32: Restaurant margin, Franchise revenue, Field management of company restaurants, Franchise support…
  • Profit, rows 35–43: Depreciation, Gain on refranchising, Loss on closures, EBIT…
Payments processing and monetisation model
  • Assumptions, rows 61–69: Processing cost per transaction, Hosting and cloud, % of net revenue, Fraud and chargeback losses, Employees, end of FY0A…
  • Income Statement, rows 14–19: Processing, Hosting and cloud, Fraud and chargeback losses, Cost of revenue…
  • Income Statement, rows 22–30: Employees, closing, Net hires, Employees, average, Pay and cost index…
  • Income Statement, rows 33–44: EBITDA, EBITDA margin, % of net revenue, EBITDA, per unit of TPV, Incremental EBITDA margin…
Telecom operator model: mobile and fibre
  • Assumptions, rows 48–59: Direct costs, % of service revenue, Mobile network costs, FY0, Fixed network costs per home passed, FY0, Acquisition cost per postpaid gross addition, FY0…
  • Costs & EBITDAaL, rows 6–16: Cost of equipment sold, Direct costs, Mobile network costs, Fixed network costs…
  • Costs & EBITDAaL, rows 19–27: Revenue, EBITDA, EBITDA margin, Lease costs…
Semiconductor foundry model
  • Assumptions, rows 13–15: R&D, SG&A, Tax rate on EBIT
  • Profit and Cash Flow, rows 6–16: Revenue, Gross profit, R&D, SG&A…
Duolingo operating model
  • Reported, rows 14–25: Cost of revenues, Research and development, Sales and marketing, General and administrative…
  • Derived, rows 12–21: Gross profit, Gross margin, Research and development, % of revenue, Sales and marketing, % of revenue…
  • Forecast, rows 25–44: Gross margin, base, Gross margin, downside, Gross margin, upside, Gross margin, selected…
  • P&L & Cash Flow, rows 15–26: Cost of revenues, Gross profit, Gross margin, Research and development…
Airbnb operating model
  • Reported, rows 24–41: Revenue, Cost of revenue, Operations and support, Product development…
  • Reported, rows 44–48: Valuation allowance released on US deferred tax assets (one-time benefit), Valuation allowance recorded against the CAMT credit deferred tax asset (one-time charge), Reduction in uncertain tax positions for prior years, as the 10-K states it, The same offset as the Q4 2025 shareholder letter states it…
  • Reported, rows 51–55: Stock-based compensation in operations and support, Stock-based compensation in product development, Stock-based compensation in sales and marketing, Stock-based compensation in general and administrative…
  • Reported, rows 58–62: Depreciation and amortisation, Acquisition-related impacts, Lodging, host withholding and transactional tax settlements and reserves, Stock-settlement obligations (employer taxes from the IPO)…
  • Derived, rows 62–69: Product development, % of revenue, Sales and marketing, % of revenue, General and administrative, % of revenue, Operating margin (GAAP)…
  • Derived, rows 72–84: EBITDA after stock-based compensation (operating income + D&A), Margin, Adjusted EBITDA rebuilt: net income + tax + other expense - interest income + D&A + SBC + acquisition, tax-settlement and IPO-tax lines, Adjusted EBITDA margin, as reported…
  • Derived, rows 104–108: Effective tax rate (tax / income before tax), Net income excluding the 2023 release and the 2025 CAMT allowance, Tax rate excluding the two items, Cash paid for income taxes / income before tax…
  • Forecast, rows 59–74: Product development, % of revenue in FY2030E, base (editorial), Downside (editorial), Upside (editorial), Sales and marketing, % of revenue in FY2030E, base (editorial)…
  • P&L & Cash Flow, rows 24–33: Product development, Sales and marketing, General and administrative, Income from operations…
Spotify operating model
  • Reported, rows 25–33: Research and development, Sales and marketing, General and administrative, Total operating expenses…
  • Derived, rows 13–18: Gross margin, Premium gross margin (as filed), Ad-Supported gross margin (as filed), Premium gross margin, recast basis…
  • Derived, rows 21–33: Research and development, % of revenue, Sales and marketing, % of revenue, General and administrative, % of revenue, Operating expenses, % of revenue…
  • Derived, rows 37–43: Research and development excluding social costs (pro rata), Sales and marketing excluding social costs (pro rata), General and administrative excluding social costs (pro rata), R&D excluding social costs, % of revenue…
  • Forecast, rows 32–58: Premium gross margin, FY2026E, every case (editorial), Ad-Supported gross margin, FY2026E, every case (editorial), Premium gross margin in FY2030E, base (editorial), Premium gross margin in FY2030E, downside (editorial)…
  • P&L & Cash Flow, rows 20–38: Premium cost of revenue, Ad-Supported cost of revenue, Premium gross profit, Ad-Supported gross profit…
CoreWeave operating model
  • Reported, rows 6–18: Revenue, Cost of revenue, Technology and infrastructure, Sales and marketing…
  • Reported, rows 21–25: In cost of revenue, In technology and infrastructure, In sales and marketing, In general and administrative…
  • Reported, rows 28–30: Adjusted EBITDA, as reported, Other income, as the reconciliation subtracts it, Acquisition related costs, added back
  • Reported, rows 48–52: Operating lease cost, Variable lease cost, Increase in data centre utilities spend, FY2025 on FY2024, Increase in data centre utilities and power spend, FY2024 on FY2023…
  • Derived, rows 6–23: Revenue growth, Operating margin, EBITDA after stock-based compensation (operating income + D&A), EBITDA after SBC, margin…
  • Forecast, rows 24–46: Lease cost per average active MW, a year, base (editorial), Lease cost per MW, downside (editorial), Lease cost per MW, upside (editorial), Lease cost per MW, selected…
  • P&L & Cash Flow, rows 13–28: Data centre and office leases (operating and variable lease cost), Power, estimated: MW x hours x utilisation x PUE x price, Staff, software and the rest, Other operating costs before D&A and leases…
Adyen operating model
  • Reported, rows 44–51: Wages and salaries (including share-based compensation), Of which share-based compensation, Social securities and pension costs, Amortization and depreciation…
  • Derived, rows 76–102: EBITDA rebuilt: income before finance income and tax plus amortisation and depreciation, EBITDA margin, % of net revenue, Incremental EBITDA margin: change in EBITDA over change in net revenue, People costs: wages and salaries plus social securities and pensions…
  • Forecast, rows 61–78: Net additions in Q4 2026, base (editorial), Net additions in Q4 2026, downside (editorial), Net additions in Q4 2026, upside (editorial), Net additions in Q4 2026, selected…
  • Forecast, rows 81–98: Other operating expenses, % of net revenue, FY2026E, every case (editorial), Other operating expenses, % of net revenue by FY2030E, base (editorial), Other operating expenses target, downside (editorial), Other operating expenses target, upside (editorial)…
  • P&L & Cash Flow, rows 40–58: Full-time equivalents at the year end, Average full-time equivalents, Net additions, People costs per average employee…
AerCap operating model
  • Derived, rows 32–37: Pre-tax income without the Ukraine recoveries, Income tax expense / pre-tax income, Total equity at the start of the year, Net income / average total equity…
  • Forecast, rows 33–39: Leasing expenses, % of total lease revenue, base (editorial), Leasing expenses, % of total lease revenue, downside (editorial), Leasing expenses, % of total lease revenue, upside (editorial), Leasing expenses, % of total lease revenue, selected…

What a reviewer looks for

  • Depreciation forecast as a share of revenue on the income statement while a PP&E schedule computes a different number.
  • Margins that expand every year with nothing in the case to explain why.
  • Every cost a flat share of revenue, so the downside case shrinks profit only as fast as revenue.

Learn it, then build it

Vocabulary: EBITDA.

Other the statements