TechnologyCore · ~50 minWorking draft · 9 sheets · 993 formulas

Uber operating model

Uber from its 10-Ks: Gross Bookings by segment, what each keeps, tax releases, cash, value. Build a three-segment marketplace from Gross Bookings, derive what each segment keeps of a dollar as revenue and as adjusted EBITDA, rebuild adjusted EBITDA from GAAP lines, take the stakes’ revaluation and the tax releases out of net income, read free cash flow after stock-based compensation and after the insurance reserves built, and see what the forecast is worth without mistaking it for a view on the shares.

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

On this subject: uber operating model.Updated 20 November 2026

Who builds it, and for whatThe model an internet equity analyst, a growth investor or a mobility and delivery finance team builds from a platform’s filings: Gross Bookings by segment first, then the share of them each segment records as revenue and keeps as profit, then the costs the company leaves out of its own measure, then the cash, with the money held against insurance claims kept apart. Uber is the subject because its three segments keep very different shares of a dollar, its reported net income in 2024 and 2025 was mostly tax allowance releases and the revaluation of stakes in other companies, and its free cash flow includes cash set aside for claims.

Every sheet below, in your browser, with its outputs and checks

Starter workbook free with an account. Worked model: one a month with Plus, every one with Pro. Downloads

Inspect the workbook
All checks read zero100%
Every value, every sheet, as the workbook holds it.
ABCDEFGHIJKL
1Reported
2$m unless stated, as filed. Blue cells are typed from the documents named on the Sources sheet; nothing here is adjusted, and nothing here is a forecast.
4$mUnitFY2023AFY2024AFY2025AFY2026EFY2027EFY2028EFY2029EFY2030ENotes
5Key metrics (Form 10-K, Item 7, Financial and Operational Highlights; not XBRL-tagged)
6Monthly Active Platform Consumers (MAPCs), fourth quarterm people150.0171.0202.0The number of unique consumers who completed a Mobility ride or received a Delivery order at least once in a month, averaged over the quarter. FY2025 10-K Item 7; FY2023 from the FY2024 10-K. Not XBRL-tagged.
7Tripsm trips9,448.011,273.013,567.0Completed Mobility rides and Delivery orders. An UberX Share ride with three paying riders is three trips. FY2025 10-K Item 7; FY2023 from the FY2024 10-K. Not XBRL-tagged.
8Gross Bookings$m137,865.0162,773.0193,454.0The total dollar value, taxes, tolls and fees included, of Mobility rides and Delivery orders (before discounts, refunds, driver and merchant earnings and driver incentives) and Freight revenue; tips excluded. Not Uber’s revenue. FY2025 10-K Item 7; FY2023 from the FY2024 10-K. Not XBRL-tagged.
10Gross Bookings by segment and quarter (Form 10-K, Item 7, Key Metrics; not XBRL-tagged)
11Mobility Gross Bookings, Q1$m14,981.018,670.021,182.0The quarterly table in Item 7: 2024 and 2025 from the FY2025 10-K, 2023 from the FY2024 10-K. Uber gives segment Gross Bookings by quarter only; the year is the sum, on the Derived sheet. Not XBRL-tagged.
12Mobility Gross Bookings, Q2$m16,728.020,554.023,762.0The quarterly table in Item 7: 2024 and 2025 from the FY2025 10-K, 2023 from the FY2024 10-K. Uber gives segment Gross Bookings by quarter only; the year is the sum, on the Derived sheet. Not XBRL-tagged.
13Mobility Gross Bookings, Q3$m17,903.021,002.025,111.0The quarterly table in Item 7: 2024 and 2025 from the FY2025 10-K, 2023 from the FY2024 10-K. Uber gives segment Gross Bookings by quarter only; the year is the sum, on the Derived sheet. Not XBRL-tagged.
14Mobility Gross Bookings, Q4$m19,285.022,798.027,442.0The quarterly table in Item 7: 2024 and 2025 from the FY2025 10-K, 2023 from the FY2024 10-K. Uber gives segment Gross Bookings by quarter only; the year is the sum, on the Derived sheet. Not XBRL-tagged.
15Delivery Gross Bookings, Q1$m15,026.017,699.020,377.0The quarterly table in Item 7: 2024 and 2025 from the FY2025 10-K, 2023 from the FY2024 10-K. Uber gives segment Gross Bookings by quarter only; the year is the sum, on the Derived sheet. Not XBRL-tagged.
16Delivery Gross Bookings, Q2$m15,595.018,126.021,734.0The quarterly table in Item 7: 2024 and 2025 from the FY2025 10-K, 2023 from the FY2024 10-K. Uber gives segment Gross Bookings by quarter only; the year is the sum, on the Derived sheet. Not XBRL-tagged.
17Delivery Gross Bookings, Q3$m16,094.018,663.023,322.0The quarterly table in Item 7: 2024 and 2025 from the FY2025 10-K, 2023 from the FY2024 10-K. Uber gives segment Gross Bookings by quarter only; the year is the sum, on the Derived sheet. Not XBRL-tagged.
18Delivery Gross Bookings, Q4$m17,011.020,126.025,431.0The quarterly table in Item 7: 2024 and 2025 from the FY2025 10-K, 2023 from the FY2024 10-K. Uber gives segment Gross Bookings by quarter only; the year is the sum, on the Derived sheet. Not XBRL-tagged.
19Freight Gross Bookings, Q1$m1,401.01,282.01,259.0The quarterly table in Item 7: 2024 and 2025 from the FY2025 10-K, 2023 from the FY2024 10-K. Uber gives segment Gross Bookings by quarter only; the year is the sum, on the Derived sheet. Not XBRL-tagged.
20Freight Gross Bookings, Q2$m1,278.01,272.01,260.0The quarterly table in Item 7: 2024 and 2025 from the FY2025 10-K, 2023 from the FY2024 10-K. Uber gives segment Gross Bookings by quarter only; the year is the sum, on the Derived sheet. Not XBRL-tagged.
21Freight Gross Bookings, Q3$m1,284.01,308.01,307.0The quarterly table in Item 7: 2024 and 2025 from the FY2025 10-K, 2023 from the FY2024 10-K. Uber gives segment Gross Bookings by quarter only; the year is the sum, on the Derived sheet. Not XBRL-tagged.
22Freight Gross Bookings, Q4$m1,279.01,273.01,267.0The quarterly table in Item 7: 2024 and 2025 from the FY2025 10-K, 2023 from the FY2024 10-K. Uber gives segment Gross Bookings by quarter only; the year is the sum, on the Derived sheet. Not XBRL-tagged.
24Revenue and adjusted EBITDA by segment (Form 10-K, Note 13, Segment Information)
25Mobility revenue$m19,832.025,087.029,670.0us-gaap:Revenues on the Mobility segment member, read from the inline XBRL (the companyfacts record serves the consolidated figure only). Includes financial partnerships and advertising.
26Delivery revenue$m12,204.013,750.017,248.0us-gaap:Revenues on the Delivery segment member, from the inline XBRL. Includes advertising.
27Freight revenue$m5,245.05,141.05,099.0us-gaap:Revenues on the Freight segment member, from the inline XBRL. Recorded gross: Freight revenue is its Gross Bookings.
28Mobility segment adjusted EBITDA$m4,963.06,497.07,899.0uber:AdjustedEarningsBeforeInterestTaxesDepreciationAndAmortization on the segment member (a company tag, read from the inline XBRL). Non-GAAP, Uber’s measure of segment profit.
29Delivery segment adjusted EBITDA$m1,506.02,471.03,572.0The same company tag on the Delivery member.
30Freight segment adjusted EBITDA$m(64.0)(74.0)(33.0)The same company tag on the Freight member. A loss in every year.
31Corporate G&A and Platform R&D$m(2,353.0)(2,410.0)(2,708.0)Note 13 and Item 7: costs not allocated to a segment, net of stock-based compensation and the other items Uber excludes. Shown negative, as filed.
32Adjusted EBITDA, as reported$m4,052.06,484.08,730.0Non-GAAP. FY2025 10-K Item 7, Reconciliations of Non-GAAP Financial Measures; FY2023 from the FY2024 10-K. The total is not XBRL-tagged.
34Statement of operations (Form 10-K for 2025, Item 8)
35Revenue$m37,281.043,978.052,017.0us-gaap:Revenues.
36Cost of revenue, exclusive of depreciation and amortisation$m22,457.026,651.031,338.0us-gaap:CostOfGoodsAndServiceExcludingDepreciationDepletionAndAmortization. Insurance, payment processing, hosting and the costs of the businesses Uber runs gross.
37Operations and support$m2,689.02,732.02,854.0uber:OperationsAndSupportExpense (company tag, from the inline XBRL).
38Sales and marketing$m4,356.04,337.04,898.0us-gaap:SellingAndMarketingExpense.
39Research and development$m3,164.03,109.03,402.0us-gaap:ResearchAndDevelopmentExpense.
40General and administrative$m2,682.03,639.03,241.0us-gaap:GeneralAndAdministrativeExpense. FY2024 carries $1,123m of legal, tax and regulatory reserve changes and settlements.
41Depreciation and amortisation$m823.0711.0719.0us-gaap:DepreciationDepletionAndAmortization (income statement). The cash flow statement’s add-back is higher (737, 747 in 2024 and 2025).
42Total costs and expenses$m36,171.041,179.046,452.0us-gaap:CostsAndExpenses.
43Income from operations$m1,110.02,799.05,565.0us-gaap:OperatingIncomeLoss.
44Interest expense$m633.0523.0440.0us-gaap:InterestExpenseNonoperating, shown as positive: an expense.
45Interest income$m484.0721.0743.0us-gaap:InvestmentIncomeInterest. Earned on cash, short-term investments, restricted cash and restricted investments; the 10-K does not split it. Presented on its own line from the FY2025 10-K; the FY2024 10-K carried it inside other income.
46Other income (expense), net$m1,360.01,128.0(68.0)us-gaap:OtherNonoperatingIncomeExpense, as presented in the FY2025 10-K (without interest income).
47Income before income taxes and income (loss) from equity method investments$m2,321.04,125.05,800.0us-gaap:IncomeLossFromContinuingOperationsBeforeIncomeTaxesMinorityInterestAndIncomeLossFromEquityMethodInvestments.
48Provision for (benefit from) income taxes$m213.0(5,758.0)(4,346.0)us-gaap:IncomeTaxExpenseBenefit. FY2024 and FY2025 are benefits, from the valuation allowance releases below.
49Income (loss) from equity method investments$m48.0(38.0)(53.0)us-gaap:IncomeLossFromEquityMethodInvestments.
50Net income including non-controlling interests$m2,156.09,845.010,093.0us-gaap:ProfitLoss.
51Net income (loss) attributable to non-controlling interests$m269.0(11.0)40.0us-gaap:NetIncomeLossAttributableToNoncontrollingInterest.
52Net income attributable to Uber Technologies, Inc.$m1,887.09,856.010,053.0us-gaap:NetIncomeLoss.
53Net income per share, basic$ per share0.934.714.82us-gaap:EarningsPerShareBasic.
54Net income per share, diluted$ per share0.874.564.73us-gaap:EarningsPerShareDiluted. The diluted numerator carries adjustments of its own (Note 12), so it is not net income over diluted shares.
55Weighted-average shares, basicm shares2,035.72,094.62,085.3us-gaap:WeightedAverageNumberOfSharesOutstandingBasic.
56Weighted-average shares, dilutedm shares2,091.82,150.52,119.7us-gaap:WeightedAverageNumberOfDilutedSharesOutstanding.
58Other income (expense), by kind (Form 10-K for 2025, Note 9, Supplemental Financial Statement Information)
59Foreign currency exchange gains (losses), net$m(182.0)(391.0)89.0us-gaap:ForeignCurrencyTransactionGainLossBeforeTax.
60Gain on business divestitures, net$m204.0--Note 9. FY2023 only.
61Loss from sale of investments$m(74.0)--Note 9. FY2023 only.
62Unrealized gain (loss) on debt and equity securities, net$m1,610.01,832.0(97.0)us-gaap:DebtAndEquitySecuritiesUnrealizedGainLoss. Mostly the revaluation of equity stakes in other companies: in 2025 Aurora (802) and Lucid (155) down, Didi (409), Waabi (179) and Grab (145) up; in 2024 Grab (723), Aurora (629) and Didi (357) up (Item 7).
63Acquisition termination fee$m-(236.0)-Note 9. FY2024: the terminated Foodpanda Taiwan acquisition, settled in cash in April 2025.
64Other, net$m(198.0)(77.0)(60.0)Note 9.
66Tax: the valuation allowance releases (Form 10-K for 2025, Item 7 and Note 11, Income Taxes)
67Valuation allowance released on deferred tax assets (one-time benefit)$m-6,400.05,011.0FY2024: $6.4bn on US federal ($5.2bn) and state ($1.2bn) deferred tax assets, as Item 7 and Note 11 round it. FY2025: the Netherlands, 5,011 in the rate reconciliation (us-gaap:IncomeTaxReconciliationChangeInDeferredTaxAssetsValuationAllowance on the Netherlands member), "$5.0 billion" in Item 7. FY2023: no release of note (the allowance line was 2.8% of pre-tax income). Non-cash.
68Deferred tax assets, net (balance sheet)$m170.06,171.010,951.0us-gaap:DeferredIncomeTaxAssetsNet. What lets cash tax run far below book tax while it is used.
69Income taxes paid, net of refunds$m234.0324.0345.0us-gaap:IncomeTaxesPaidNet; supplemental cash flow disclosures.
71Adjusted EBITDA reconciliation, the company’s own lines (Form 10-K, Item 7, Reconciliations of Non-GAAP Financial Measures)
72Stock-based compensation expense$m1,935.01,796.01,826.0us-gaap:ShareBasedCompensation. The same figure in the cash flow statement and the reconciliation.
73Legal, non-income tax and regulatory reserve changes and settlements$m9.01,123.0564.0uber:LegalNonIncomeTaxAndRegulatoryReserveChangesAndSettlements (company tag). FY2023 from the FY2024 10-K, where the line read "legal, tax, and regulatory".
74Goodwill and asset impairments, loss on sale of assets, net$m84.03.02.0Reconciliation line.
75Acquisition, financing and divestitures related expenses$m36.025.043.0Reconciliation line.
76Loss on lease arrangements, net$m4.02.02.0Reconciliation line.
77Restructuring and related charges$m51.025.09.0Reconciliation line.
79Cash flow (consolidated statements of cash flows; free cash flow reconciliation, Item 7)
80Net cash provided by operating activities$m3,585.07,137.010,099.0us-gaap:NetCashProvidedByUsedInOperatingActivities.
81Of which: increase in accrued insurance reserves$m2,230.02,819.02,660.0uber:IncreaseDecreaseInInsuranceReserve (company tag). Claims accrued in the year less claims paid: cash kept now for claims paid later, most of it moved into restricted investments.
82Of which: deferred income taxes$m26.0(6,027.0)(4,779.0)us-gaap:DeferredIncomeTaxExpenseBenefit. FY2024 and FY2025 carry the non-cash releases.
83Of which: unrealized (gain) loss on debt and equity securities, taken out$m(1,610.0)(1,832.0)97.0The revaluation is not cash, so the cash flow statement takes it back out of net income.
84Purchases of property and equipment$m223.0242.0336.0us-gaap:PaymentsToAcquirePropertyPlantAndEquipment, shown as positive: an outflow.
85Free cash flow, as reported$m3,362.06,895.09,763.0Non-GAAP: operating cash flow less capital expenditures, nothing else. FY2023 from the FY2024 10-K. Not XBRL-tagged.
86Net cash used in investing activities$m(3,226.0)(3,177.0)(3,564.0)us-gaap:NetCashProvidedByUsedInInvestingActivities. Includes the purchase of restricted investments with the insurance cash.
87Net cash used in financing activities$m(95.0)(2,087.0)(5,713.0)us-gaap:NetCashProvidedByUsedInFinancingActivities.
88Effect of exchange rate changes on cash and restricted cash$m63.0(267.0)215.0Cash flow statement.
89Cash, cash equivalents, restricted cash and restricted cash equivalents, year end$m7,004.08,610.09,647.0us-gaap:CashCashEquivalentsRestrictedCashAndRestrictedCashEquivalents. INCLUDES restricted cash held against insurance claims: not the company’s liquidity.
90The same, at 31 December 2022$m6,677.0us-gaap:CashCashEquivalentsRestrictedCashAndRestrictedCashEquivalents; the opening balance for 2023 on the FY2025 cash flow statement.
91Repurchases of common stock$m-1,252.06,523.0us-gaap:PaymentsForRepurchaseOfCommonStock, shown as positive: an outflow.
93Balance sheet at 31 December (consolidated balance sheets and Notes 2 and 8)
94Cash and cash equivalents$m4,680.05,893.07,105.0us-gaap:CashAndCashEquivalentsAtCarryingValue. 31 December 2023 from the FY2024 10-K.
95Short-term investments$m727.01,084.0528.0us-gaap:MarketableSecuritiesCurrent. Marketable debt securities.
96Restricted cash and cash equivalents, current$m805.0545.0631.0us-gaap:RestrictedCashAndCashEquivalentsAtCarryingValue. Pledged for letters of credit and insurance collateral.
97Restricted cash and cash equivalents, non-current$m1,519.02,172.01,911.0us-gaap:RestrictedCashAndCashEquivalentsNoncurrent.
98Restricted investments$m4,779.07,019.08,874.0us-gaap:RestrictedInvestments. Marketable debt securities held in trust under contracts with insurance providers (Note 1).
99Investments$m6,101.08,460.09,178.0uber:MarketableAndNonMarketableInvestments (company tag). The equity stakes and a note receivable, below; at fair value, so their revaluation runs through other income.
100Of which: Didi (non-marketable equity)$m2,245.02,602.03,011.0Note 2, Investments: uber:NonMarketableEquitySecurities on the Didi member.
101Of which: other non-marketable equity$m329.0608.01,455.0Note 2.
102Of which: Grab (marketable equity)$m1,806.02,529.02,674.0Note 2: uber:MarketableEquitySecurities on the Grab member.
103Of which: Aurora (marketable equity)$m1,425.02,054.01,252.0Note 2. About 48% of the Aurora stake is pledged against the 2028 exchangeable notes.
104Of which: other marketable equity$m170.0523.0667.0Note 2.
105Of which: notes receivable from a related party$m126.0144.0119.0Note 2: the Lime convertible note. us-gaap:NotesReceivableNet.
106Equity method investments$m353.0302.0287.0us-gaap:EquityMethodInvestments.
107Short-term insurance reserves$m2,077.02,754.03,387.0uber:InsuranceReserveCurrent (company tag). Unpaid losses and loss adjustment expenses: auto liability, uninsured motorist, physical damage, general liability, workers’ compensation.
108Long-term insurance reserves$m4,909.07,042.09,076.0uber:InsuranceReserveNoncurrent (company tag). $12.5bn in total at 31 December 2025, a critical audit matter.
109Total debt, principal$m9,561.09,575.010,600.0Note 8, Long-Term Debt: before unamortised discount and issuance costs (77, 78, 79). us-gaap:LongTermDebt at 31 December 2025. Includes the 2028 convertible notes ($1,725m at 0.875%) and the 2028 exchangeable notes ($1,125m at 0%), the latter exchangeable into Aurora shares.
110Operating lease liabilities, current and non-current$m1,740.01,629.01,559.0us-gaap:OperatingLeaseLiability.
111Total Uber Technologies, Inc. stockholders’ equity$m11,249.021,558.027,041.0us-gaap:StockholdersEquity. 31 December 2023 from the FY2024 10-K.
112Total equity$m12,028.022,383.027,918.0us-gaap:StockholdersEquityIncludingPortionAttributableToNoncontrollingInterest.
113Redeemable non-controlling interests$m654.093.0165.0us-gaap:RedeemableNoncontrollingInterestEquityCarryingAmount, outside equity.
114Common shares outstanding at year endm shares2,071.12,108.02,067.9us-gaap:CommonStockSharesOutstanding.

Select a cell to see its row, its schedule and the type of cell. Font colours: blue for inputs, black for formulas, green for links to other sheets. Scroll sideways to see every period.

Download

Uber operating model: the workbook

An Excel workbook with working formulas, no macros and no external links: the same model you can work with on this page.

  1. Browse without an accountPreview every model online, sheet by sheet, with its outputs and checks.
  2. Free accountWork with every model online: change the inputs, switch the case, see every formula. And every starter workbook, with its key schedules left blank to build.
  3. L3VLUP Plus$4.99/monthEverything in Free, and one worked model each billing month as an Excel file: every schedule built, formulas live, checks at zero, yours to keep.
  4. L3VLUP Pro$25/monthEverything in Plus, every worked model in the library, and the Pro applications.
The worked model
9 sheets and 993 live formulas, all 9 schedules built and linked, every check reading zero. Change an input in Excel and the whole model moves.
The starter
The same inputs and layout with the contribution margin left blank for you to build, each blank cell marked. The worked model is its answer.

What the base case says

FY2025A Gross Bookings
$193,454.0m
FY2025A Mobility segment adjusted EBITDA / Gross Bookings
8.1%
FY2025A net income without the revaluation and the releases
$5,139.0m
FY2025A free cash flow less SBC and the insurance reserves built
$5,277.0m
FY2030E adjusted EBITDA, selected case
$19,596.4m
Value per share the forecast implies
84.56

Read from the workbook as served, every input at its default. Periods: FY2023A, FY2024A, FY2025A, FY2026E, FY2027E, FY2028E, FY2029E, FY2030E. Built from Uber Technologies, Inc.’s Forms 10-K for 2025 and 2024, each figure cited with its XBRL tag or the statement that it is untagged on the Reported sheet; the forecast, the margins by segment, the discount rate and the terminal assumptions are editorial judgements, labelled on the Forecast sheet, and move with whatever you type in. Company guidance is not used.

What changes the answer

Every figure below is the workbook recalculated by its own formulas: the cases it carries, each key assumption moved a tenth either way, and the sensitivity grids from its own sheets. Nothing is estimated outside the model.

The cases, side by side

The scenario switch on the Forecast sheet, set to each option in turn. Every check in the workbook reads zero in every case.

OutputBaseas shippedDownsideUpside
FY2025A Gross Bookings$193,454.0m$193,454.0m$193,454.0m
FY2025A Mobility segment adjusted EBITDA / Gross Bookings8.1%8.1%8.1%
FY2025A net income without the revaluation and the releases$5,139.0m$5,139.0m$5,139.0m
FY2025A free cash flow less SBC and the insurance reserves built$5,277.0m$5,277.0m$5,277.0m
FY2030E adjusted EBITDA, selected case$19,596.4m$11,474.1m-$8,122.2m$24,855.6m+$5,259.2m
Value per share the forecast implies84.5647.67-36.89108.61+24.05
What each case assumes
Mobility growth, selected17.0%12.0%20.0%
Delivery growth, selected18.0%12.0%21.0%
Mobility revenue / Gross Bookings, selected30.3%30.0%30.5%
Delivery revenue / Gross Bookings, selected19.0%18.8%19.1%
Mobility margin on Gross Bookings, selected8.2%8.0%8.4%
Delivery margin on Gross Bookings, selected4.1%3.9%4.2%
Corporate costs, % of Gross Bookings, selected1.4%1.4%1.3%
Stock-based compensation, % of revenue, selected3.4%3.5%3.4%

The first period of each assumption row the switch sets directly, in the order of the columns above.

What moves the value per share the forecast implies most

Value per share the forecast implies is 84.56 in the base case. Each bar moves one assumption 10% below and 10% above its own value, with everything else held, and shows where the output lands.

  • Discount rate

    10% lower: 99.6310% higher: 73.43

  • Mobility segment adjusted EBITDA / Gross Bookings in FY2030E

    10% lower: 76.6210% higher: 92.51

  • Delivery segment adjusted EBITDA / Gross Bookings in FY2030E

    10% lower: 80.6910% higher: 88.43

  • Terminal growth

    10% lower: 81.3010% higher: 88.16

  • Mobility Gross Bookings growth

    10% lower: 81.3010% higher: 87.97

  • Corporate G&A and Platform R&D

    10% lower: 86.6910% higher: 82.43

Assumption 10% lowerAssumption 10% higherBase case, 84.56

The sensitivity grids, as heatmaps

Value per share: discount rate by terminal growth

Value per share ($), by discount rate down and terminal growth across. From the Sensitivity sheet.
Discount rate ↓ / Terminal growth →2.0%2.5%3.0%3.5%4.0%
7.0%105.21115.03127.30143.08164.11
8.0%87.4693.90101.64111.10122.92
9.0%74.7979.3084.5690.7898.23
10.0%65.3168.6172.3876.7281.79
11.0%57.9560.4563.2566.4370.06
Lower than the base caseHigher than the base caseThe base case, as the workbook ships

Value per share: discount rate by exit multiple

Value per share ($), by discount rate down and exit multiple across. From the Sensitivity sheet.
Discount rate ↓ / Exit multiple →11.0x13.0x15.0x17.0x19.0x
7.0%80.2591.03101.80112.58123.35
8.0%77.0387.3297.60107.89118.17
9.0%73.9883.8093.62103.45113.27
10.0%71.0880.4789.8599.24108.62
11.0%68.3477.3186.2795.24104.21
Lower than the base caseHigher than the base caseThe base case, as the workbook ships

Presenting these figures? In Deck Studio a slide can carry any output above, with the case and the cell printed as its source.Open Deck Studio

What this model is

An operating model of Uber Technologies, Inc., the ride-hailing, delivery and freight platform, built from its filed results for 2023 to 2025 and carried five years forward in three editorial cases.

It keeps apart numbers that move together and mean different things. Gross Bookings are the value of rides, orders and freight; revenue is the part Uber records, about 30 cents of a Mobility dollar and 19 cents of a Delivery dollar; segment adjusted EBITDA is what each segment keeps after its own costs; net income in 2024 and 2025 was mostly tax allowance releases and the revaluation of equity stakes.

The Reported sheet holds only what the company filed, each row with its document and XBRL tag, or the statement that it is untagged, as Gross Bookings and the non-GAAP measures are. The Derived sheet does arithmetic on them: Gross Bookings by segment for a year, what each segment keeps of a dollar, adjusted EBITDA rebuilt from GAAP lines, net income without the two items, free cash flow after stock-based compensation and after the insurance reserves built. The Forecast sheet is where judgement enters, and says so on every row.

Seats: Equity research and hedge funds, Product and technology, Investment banking, Venture capital.

Careers that do this work: growth equity, venture capital, equity research, corp dev / m&a, bizops / strategy & ops.

How the schedules connect

Every row in the workbook is tagged with the schedule it belongs to; the inspector above shows the tag when you click a row. These are the schedules this model is made of and where each one lives.

Revenue build

Where the top line comes from

Reported, rows 6–8 · Reported, rows 11–22 · Reported, rows 25–32 · Derived, rows 6–16 · Forecast, rows 11–19 · P&L & Cash Flow, rows 6–10

Take rate

From GMV to net revenue

Derived, rows 19–32 · Forecast, rows 22–29 · P&L & Cash Flow, rows 13–21

Contribution margin

What an order leaves after the costs it brings

Derived, rows 35–42 · Forecast, rows 32–45 · P&L & Cash Flow, rows 24–35

Operating costs and margins

Cost of sales, opex, EBITDA

Reported, rows 35–56 · Reported, rows 59–64 · Reported, rows 67–69 · Reported, rows 72–77 · Derived, rows 45–54 · Derived, rows 57–63 · Forecast, rows 48–54 · P&L & Cash Flow, rows 38–43

Working capital schedule

Receivables, inventory and payables in days

Derived, rows 74–78 · Forecast, rows 57–58 · P&L & Cash Flow, rows 59–61

Cash flow statement

Indirect method, closing on balance-sheet cash

Reported, rows 80–91 · Derived, rows 66–71 · Forecast, rows 61–67 · P&L & Cash Flow, rows 46–56 · P&L & Cash Flow, rows 64–69 · P&L & Cash Flow, rows 72–77 · P&L & Cash Flow, rows 80–86

Enterprise value to equity value

Debt off, cash on, per share

Reported, rows 94–114 · Derived, rows 81–92 · Valuation, rows 27–42

Discounting and terminal value

Discount factors, two terminal methods, reconciled

Forecast, rows 70–72 · Valuation, rows 6–12 · Valuation, rows 16–24 · Valuation, rows 45–49

Sensitivity tables

Two assumptions at once, without a data table

Sensitivity, rows 5–7 · Sensitivity, rows 10–15 · Sensitivity, rows 18–26

What you should be able to explain

  • Why Gross Bookings are not revenue: they include what drivers, couriers, merchants and carriers earn, and Uber records about 30 cents of a Mobility dollar and 19 cents of a Delivery dollar, while Freight is recorded gross.
  • How segment adjusted EBITDA as a share of Gross Bookings shows what each business keeps, and why Delivery’s rising margin and Freight’s losses matter more to the total than their revenue suggests.
  • Why a valuation allowance release lifts net income without lifting earning power, and why the revaluation of equity stakes belongs in the bridge to equity value rather than in a forecast of earnings.
  • What insurance reserves are, why their growth is inside operating cash flow, and why the cash behind them sits in restricted assets a holder cannot spend.
  • How adjusted EBITDA is rebuilt from net income, what its add-backs are worth, and which of them are real costs.

What a reviewer looks for

  • Calling Gross Bookings revenue, or applying a margin on revenue to Gross Bookings.
  • Treating 2024 net income of $9.9bn as earnings when $6.4bn of it is a tax allowance release and $1.8bn the revaluation of stakes.
  • Forecasting gains on the equity stakes, or valuing the stakes twice: once in earnings and again in the bridge.
  • Counting restricted cash and investments as company liquidity, or taking the cash flow statement’s cash, which includes restricted cash, as the company’s.
  • Discounting free cash flow that includes the insurance reserves built while leaving the reserves out of the bridge to equity value.
  • Adding back legal and regulatory settlements as if they never recur for a platform in hundreds of cities.
  • Adding back stock-based compensation in the valuation and presenting the result as the value, rather than as a memo beside it.

Conventions this workbook uses

Stated on the cover sheet too. A model is only as trustworthy as the decisions it tells you it made.

  • Three kinds of number, on three sheets: Reported (filed, blue, cited), Derived (arithmetic on Reported, no assumption), Forecast (editorial, blue, labelled). Every other sheet is formulas over them.
  • Gross Bookings are forecast by segment; revenue is each segment’s Gross Bookings times the share it records, faded from FY2025A to a FY2030E target; Freight is held at its FY2025A ratio, about 100%, because it is recorded gross.
  • Segment adjusted EBITDA is each segment’s Gross Bookings times its margin on them, faded the same way; corporate costs are a share of total Gross Bookings. Adjusted EBITDA is their sum in every year, and in filed years ties to the reported figure.
  • Operating income is adjusted EBITDA less stock-based compensation, D&A and the items Uber excludes (legal, regulatory and other reserves and settlements), which the forecast charges at a share of revenue every year.
  • Insurance reserves are a ratio to Mobility Gross Bookings. Their increase is inside operating cash flow and Uber’s free cash flow; the forecast moves the same amount into restricted assets, so company liquidity grows by free cash flow less that increase and the repurchases.
  • The valuation discounts free cash flow after stock-based compensation, after the insurance reserves built and before all interest, at 31 December 2025; adds company liquidity and the equity stakes at their carrying value; deducts debt at principal and non-controlling interests at book. Restricted assets and insurance reserves are both left out; lease liabilities are not deducted. The value per share is what the inputs imply and nothing more.
  • FY2024 net income includes a $6.4bn tax benefit from releasing valuation allowances on US deferred tax assets, and FY2025 one of $5.0bn on Netherlands assets; FY2023 and FY2024 include unrealised gains on the stakes of $1.6bn and $1.8bn. The Derived sheet shows net income without them, and the forecast assumes none.

Build it yourself

The starter workbook

The segment margins have been cleared: what each segment keeps of a dollar of Gross Bookings on the Derived sheet, the selected margins on the Forecast sheet, and the segment adjusted EBITDA on the P&L & Cash Flow sheet. Rebuild them so each segment’s adjusted EBITDA is its Gross Bookings times its margin, the filed years still tie to the reported adjusted EBITDA, and the segments plus corporate costs still add to the total.

Blanks: Contribution margin. Download it beside the worked model.

Finished? Audit a model you built for errors, hardcodes and checks that do not tie, in your browser.

The path around this model

Understand it, drill it, read the build, then apply it to a real company.

Vocabulary: Gross Merchandise Value (GMV), Take Rate, Two-Sided Marketplace, EBITDA, Free Cash Flow (FCF), Stock-Based Compensation (SBC), GAAP vs. Non-GAAP, Deferred Tax (DTA and DTL), Enterprise Value (EV), Terminal Value.

Questions about this model

Which figures in this model are the company’s and which are the page’s?

Every figure on the Reported sheet is Uber’s, from its Forms 10-K for 2025 and 2024, each with its XBRL tag, or the statement that it is untagged, as Gross Bookings, trips and the non-GAAP measures are. Every figure on the Derived sheet is arithmetic on those, including Gross Bookings by segment for a year and what each segment keeps of a dollar. Every figure on the Forecast sheet is a judgement of this page. Uber gives an outlook each quarter; none of it is used.

How much of Uber’s net income is not operations?

In 2024, $6.4bn of the $9,856m was a tax benefit from releasing valuation allowances on US deferred tax assets and $1,832m an unrealised gain on stakes such as Grab, Aurora and Didi: 83.5% of the total. In 2025, $5,011m of the $10,053m was a release on Netherlands assets, with a small unrealised loss of $97m: 48.9%. Without both, net income was $1,624m in 2024 and $5,139m in 2025, on income from operations of $2,799m and $5,565m.

Why does the model take the insurance reserves out of free cash flow?

Because the cash is owed. Uber accrues the cost of claims when trips happen and pays them over years; the reserves grew by $2,660m in 2025, inside operating cash flow, and the cash was largely moved into restricted investments held in trust for insurers. Uber’s free cash flow of $9,763m includes it; less stock-based compensation and the reserves built it was $5,277m. The valuation leaves both the reserves and the restricted assets out and shows the other convention as a memo.

What is the value per share on the Valuation sheet?

What the selected forecast is worth at 31 December 2025 at the discount rate and terminal growth on the Forecast sheet: free cash flow after stock-based compensation and the insurance reserves built and before interest, discounted, plus company liquidity and the equity stakes at their carrying value, less debt and minority interests, over the diluted shares. It moves with every input, and the Sensitivity sheet shows how far. It is not a target, a fair value or a recommendation, and the page does not compare it with the share price.

Related models

What assumption would you challenge?

Every model rests on a few judgements. Ask how one works, or say which input you would set differently and why.

Ask about this model

No questions yet. Ask the first.

All discussions · Community rules

Share your result 📊

𝕏in💬🤖

Instagram and TikTok have no desktop share link, so copy the caption and paste it into the app.