The statements · in 13 models

Revenue build

Where the top line comes from.

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

On this subject: revenue build.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 top of every operating forecast. A growth rate or a volume-times-price build turns last year’s revenue into next year’s, and every cost, working-capital balance and capex line is driven from the result. The scenario switch usually lives here, because growth is the assumption a case is most often run on.

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 9–12: Revenue growth, base case, Revenue growth, upside case, Revenue growth, downside case, Revenue growth, selected scenario
  • Income Statement, rows 6–10: Revenue, Revenue growth, Cost of goods sold, Gross profit…
Discounted cash flow model
  • Assumptions, rows 6–8: Revenue, last reported year, Revenue growth, EBITDA margin
  • Forecast, rows 6–12: Revenue, Revenue growth, EBITDA, EBIT…
Leveraged buyout model
  • Assumptions, rows 31–36: Revenue growth, base case, Revenue growth, downside case, Revenue growth, selected scenario, EBITDA margin, base case…
  • Operating Model, rows 6–11: Year number, Revenue, EBITDA, EBITDA margin…
  • Operating Model, rows 15–17: Profit before tax, Net income
Telecom tower model: tenancies per tower
  • Assumptions, rows 29–40: Anchor fee per ground tower, FY0, Anchor fee per rooftop, FY0, Inflation, Anchor escalator cap…
  • Revenue, rows 6–9: Inflation, Anchor escalator: inflation between the floor and the cap, Anchor fee per site, ground, Anchor fee per site, rooftop
  • Revenue, rows 12–13: Colocation rent per tenancy, ground, Colocation rent per tenancy, rooftop
  • Revenue, rows 16–27: Anchor revenue, ground, Anchor revenue, rooftops, Anchor revenue, Colocation revenue, ground…
  • Revenue, rows 30–32: Energy cost, recovered from tenants, Total revenue, Pass-through, % of total revenue
Mining model: copper-gold mine NAV
  • Assumptions, rows 13–18: Copper price, base deck, Copper price, price fall, Copper price, selected scenario, Gold price, base deck…
  • Assumptions, rows 33–40: Concentrate grade, Payable copper, Payable gold, Treatment charge…
  • Revenue, rows 6–11: Copper price, Gold price, Copper revenue, Gold revenue…
  • Revenue, rows 14–19: Less: treatment charges, Less: refining charges, Less: concentrate freight, Net smelter return…
Restaurant franchise roll-out model
  • Assumptions, rows 55–57: Royalty, % of franchised sales, Initial franchise fee per restaurant, Advertising fund contribution, % of sales
  • Profit, rows 6–13: System sales, Company restaurant sales, Royalties, Initial franchise fees…
  • Profit, rows 16–20: Contributions from franchised restaurants, Contributions from company restaurants, Less: advertising spent by the fund, Fund surplus…
Telecom operator model: mobile and fibre
  • Assumptions, rows 19–27: Postpaid ARPU, FY0, Postpaid ARPU growth, base case, Prepaid ARPU, FY0, Prepaid ARPU growth, base case…
  • Revenue, rows 6–11: Postpaid ARPU, Prepaid ARPU, Postpaid service revenue, Prepaid service revenue…
  • Revenue, rows 14–17: Broadband ARPU, Broadband revenue, Business and wholesale revenue, Fixed service revenue
  • Revenue, rows 20–26: Service revenue, Service revenue growth, Handsets sold, Equipment revenue…
Semiconductor foundry model
  • Assumptions, rows 36–37: Price per wafer, FY0A, Price change a year
  • Scenarios, rows 14–17: Price change, base, Price change, bear, Price change, bull, Price change, selected case
  • Revenue, rows 6–14: Advanced: price per wafer, Mainstream: price per wafer, Mature: price per wafer, Advanced: revenue…
  • Revenue, rows 17–22: Advanced, % of revenue, Mainstream, % of revenue, Mature, % of revenue, Check: node shares of revenue - 100%…
ICG management buyout model
  • Assumptions, rows 55–62: Revenue growth, base, Revenue growth, downside, Revenue growth, upside, Revenue growth, selected scenario…
  • Assumptions, rows 65–72: Revenue growth, base, Revenue growth, downside, Revenue growth, upside, Revenue growth, selected scenario…
  • Operating Case, rows 6–8: Revenue (including inter-segment), EBITDA, EBITDA margin
  • Operating Case, rows 11–13: Revenue (including inter-segment), EBITDA, EBITDA margin
  • Operating Case, rows 16–21: Group revenue, Group EBITDA, Group EBITDA margin, EBITDA growth…
Duolingo operating model
  • Reported, rows 6–11: Subscription revenue, Advertising revenue, Duolingo English Test revenue, In-app purchases…
  • Derived, rows 6–9: Revenue growth, Subscription revenue growth, Subscription share of revenue, Other revenue (advertising, English Test, in-app, other)
  • Forecast, rows 11–22: Paid subscriber growth, base, Paid subscriber growth, downside, Paid subscriber growth, upside, Paid subscriber growth, selected…
  • P&L & Cash Flow, rows 6–12: Paid subscribers at period end, Average paid subscribers, Subscription revenue per average subscriber, Subscription revenue…
  • P&L & Cash Flow, rows 61–66: FY2025A revenue, More subscribers, at FY2025A revenue per subscriber, Higher revenue per subscriber, on FY2030E subscribers, Other revenue growth…
Airbnb operating model
  • Reported, rows 6–7: Nights and Seats Booked, Gross Booking Value (GBV)
  • Reported, rows 10–21: Nights and Seats Booked, North America, Nights and Seats Booked, Europe, the Middle East and Africa, Nights and Seats Booked, Latin America, Nights and Seats Booked, Asia Pacific…
  • Reported, rows 118–123: Nights and Seats Booked, first half of 2025, Nights and Seats Booked, first half of 2026, GBV, first half of 2025, GBV, first half of 2026…
  • Derived, rows 6–20: Nights and Seats Booked growth, GBV per night booked (ADR), derived, ADR growth, GBV growth…
  • Forecast, rows 11–22: Second-half nights growth on H2 2025, base (editorial), Second-half nights growth, downside (editorial), Second-half nights growth, upside (editorial), Second-half ADR growth on H2 2025, base (editorial)…
  • Forecast, rows 25–32: Nights and Seats Booked growth, base (editorial), Nights growth, downside (editorial), Nights growth, upside (editorial), Nights growth, selected…
  • P&L & Cash Flow, rows 6–10: Nights and Seats Booked, Nights growth, GBV per night booked (ADR), Gross Booking Value (GBV)…
  • P&L & Cash Flow, rows 73–78: FY2025A revenue, More nights, at FY2025A ADR and take rate, A higher price per night, on FY2030E nights at the FY2025A take rate, The change in the take rate, on FY2030E GBV…
Spotify operating model
  • Reported, rows 6–14: Premium revenue, Ad-Supported revenue, Revenue, Premium cost of revenue…
  • Derived, rows 6–10: Revenue growth, Premium revenue growth, Ad-Supported revenue growth, Premium share of revenue…
  • Forecast, rows 11–19: Premium Subscriber growth, base (editorial), Premium Subscriber growth, downside (editorial), Premium Subscriber growth, upside (editorial), Premium Subscriber growth, selected…
  • Forecast, rows 22–29: Ad-Supported MAU growth, base (editorial), Ad-Supported MAU growth, downside (editorial), Ad-Supported MAU growth, upside (editorial), Ad-Supported MAU growth, selected…
  • P&L & Cash Flow, rows 6–17: Premium Subscribers, period end, Average Premium Subscribers (mean of year-end counts), Premium ARPU, Premium revenue…
  • P&L & Cash Flow, rows 63–68: FY2025A revenue, More Premium Subscribers, at FY2025A revenue per subscriber, Higher Premium ARPU and the proxy ratio, on FY2030E subscribers, Ad-Supported growth…
CoreWeave operating model
  • Forecast, rows 17–21: Revenue per average active MW, base (editorial), Revenue per average active MW, downside (editorial), Revenue per average active MW, upside (editorial), Revenue per average active MW, selected…
  • P&L & Cash Flow, rows 6–10: Average active power, Revenue, Revenue growth, Revenue per average active MW…

What a reviewer looks for

  • Growth hardcoded into the revenue row itself, so the scenario selector does nothing.
  • A single growth rate for every year when the case is about deceleration.
  • A percentage in the driver row stored as a whole number.

Learn it, then build it

Vocabulary: The Three Financial Statements.

Other the statements