← All financial models

Alibaba Group (BABA) Financial Model

📊 Download Model

Three-statement Excel model · 21 quarters and 5 fiscal years of history · 11 quarters and 5 fiscal years of projections

current ✓ C13 recon ✓ C14 trace ✓ C15 terminals

About the BABA model

This three-statement Excel model covers Alibaba Group Holding Limited (BABA): its income statement, balance sheet and cash flow statement. It holds 21 quarters and 5 fiscal years of history and 11 quarters and 5 fiscal years of projections.

Projected revenue is built from KPI drivers: Prior-year comparable revenue × growth by line, plus elimination rate on gross segment revenue, across 4 segments.

Beyond the income statement, the workbook has these sections: Non-GAAP Reconciliation, KPI Drivers, Balance Sheet, Cash Flow Statement and Forecast Roll-forwards.

Model thesis: Cloud growth and marketplace monetization lift earnings as AI investment delays cash flow recovery.

On November 14, 2026, the model passed checks C13 (every subtotal reconciles to the reported figure at $0), C14 (every projected revenue cell traces to a KPI driver row) and C15 (each driver ends in a rate, a count or a historical anchor, never a typed-in projected dollar level). It was last updated November 14, 2026.

History
21 quarters and 5 fiscal years
Projections
11 quarters and 5 fiscal years
KPI
Prior-year comparable revenue × growth by line, plus elimination rate on gross segment revenue
Segments
4
Units
RMB millions, except per-share data and share counts
Verified
Updated
File
Excel workbook (.xlsx), 235 KB
Access
Free account required: 3 different models a month at no charge, then $9 a month.

Income statement preview

Columns 2024–2026 are actual results and 2027E–2029E are our estimates. Figures were recalculated in Excel on November 14, 2026. RMB millions, except per-share data and share counts.

Income statement preview for BABA. RMB millions, except per-share data and share counts. Actual fiscal years followed by our estimates.
Income Statement
ActualEstimate
2024202520262027E2028E2029E
Customer management304,009.0322,346.0343,867.0345,828.5367,269.9394,080.6
Direct sales, logistics and others110,405.0103,180.0105,518.0104,871.0102,983.3104,322.1
China Quick Commerce78,520.0254,318.9315,355.4378,426.5
China commerce wholesale20,479.024,301.026,312.00.00.00.0
International E-commerce81,654.0108,465.0117,731.0124,427.7141,225.5160,997.1
International commerce wholesale20,944.023,835.026,439.00.00.00.0
Global Wholesale56,899.662,589.668,848.6
AI Cloud and Compute Services106,374.0118,028.0158,132.0236,516.2332,305.3453,596.8
AI Labs and Applications15,145.519,234.724,043.4
Cainiao Smart Logistics Network99,020.0101,272.00.00.00.0
Local Services Group59,802.067,076.00.00.00.0
Digital Media and Entertainment21,145.022,267.00.00.00.0
All others192,331.0206,269.0254,367.0126,047.6132,980.3141,624.0
Unallocated1,297.01,924.02,340.02,695.12,843.33,013.9
Inter-segment elimination(76,292.0)(102,616.0)(89,556.0)(83,898.3)(100,421.5)(121,026.7)
Revenue¥941,168.0¥996,347.0¥1,023,670.0¥1,182,851.8¥1,376,365.7¥1,607,926.1
Cost of revenue(¥586,323.0)(¥598,285.0)(¥616,136.0)(¥727,229.9)(¥828,572.2)(¥945,460.6)
Gross Profit¥354,845.0¥398,062.0¥407,534.0¥455,622.0¥547,793.6¥662,465.6
Product development expenses(¥52,256.0)(¥57,151.0)(¥66,533.0)(¥97,468.7)(¥108,732.9)(¥120,594.5)
Sales and marketing expenses(115,141.0)(144,021.0)(245,023.0)(215,782.4)(236,734.9)(255,660.3)
General and administrative expenses(41,985.0)(44,239.0)(33,082.0)(42,866.7)(44,043.7)(49,845.7)
Amortization and impairment of intangible assets(21,592.0)(6,336.0)(5,079.0)(2,636.8)(2,115.5)(1,720.2)
Impairment of goodwill(10,521.0)(6,171.0)(9,515.0)(4,458.0)0.00.0
Other gains, net761.01,848.0289.00.00.0
Total operating expenses, net of other gains(¥241,495.0)(¥257,157.0)(¥357,384.0)(¥362,923.6)(¥391,627.0)(¥427,820.7)
Income from operations¥113,350.0¥140,905.0¥50,150.0¥92,698.4¥156,166.6¥234,644.9
Interest and investment income, net(¥9,964.0)¥20,759.0¥87,512.0¥24,160.2¥19,157.9¥18,545.3
Interest expense(7,947.0)(9,596.0)(9,793.0)(9,791.3)(10,073.7)(9,862.1)
Other income, net6,157.03,387.01,518.01,865.82,064.52,411.9
Income before income tax and share of results of equity method investees¥101,596.0¥155,455.0¥129,387.0¥108,933.2¥167,315.4¥245,740.0
Income tax expenses(22,529.0)(35,445.0)(30,045.0)(36,186.8)(43,502.0)(61,435.0)
Share of results of equity method investees(7,735.0)5,966.02,785.03,675.75,505.58,039.6
Net income¥71,332.0¥125,976.0¥102,127.0¥76,422.1¥129,318.8¥192,344.6
Net loss attributable to noncontrolling interests8,677.04,133.01,465.0809.7688.2643.2
Net income attributable to Alibaba Group Holding Limited¥80,009.0¥130,109.0¥103,592.0¥77,231.8¥130,007.0¥192,987.8
(Accretion) Reversal of accretion of mezzanine equity(268.0)(639.0)2,312.0(77.0)0.00.0
Net income attributable to ordinary shareholders¥79,741.0¥129,470.0¥105,904.0¥77,154.8¥130,007.0¥192,987.8
Dilution from subsidiary and investee share-based awards(¥228.0)(¥300.0)(¥410.0)(¥428.9)(¥481.7)(¥562.8)
Interest adjustment for convertible unsecured senior notes0.0235.0309.0340.4352.6345.2
Dilution from assumed exchange of exchangeable bonds0.0(1,556.0)0.00.0
Net income attributable to ordinary shareholders – diluted¥79,513.0¥129,405.0¥105,803.0¥75,510.3¥129,877.9¥192,770.2
Basic weighted average ordinary shares20,182.00018,791.00018,568.00019,075.70519,266.29619,085.528
Diluted weighted average ordinary shares20,359.00019,318.00019,235.00019,722.70019,866.29619,645.528
Basic earnings per ordinary share¥3.95¥6.89¥5.70¥4.04¥6.75¥10.11
Diluted earnings per ordinary share¥3.91¥6.70¥5.50¥3.83¥6.54¥9.81
Basic earnings per ADS (as filed)¥31.61¥55.12¥45.63¥32.36¥53.98¥80.89
Diluted earnings per ADS (as filed)¥31.24¥53.59¥44.00¥30.63¥52.30¥78.50
Ratios & Assumptions
YoY Revenue Growth8.3%5.9%2.7%15.6%16.4%16.8%
Gross Margin37.7%40.0%39.8%38.5%39.8%41.2%
Effective Tax Rate22.2%22.8%23.2%33.2%26.0%25.0%

The full workbook adds 21 historical and 11 projected quarters, plus Non-GAAP Reconciliation · KPI Drivers · Balance Sheet · Cash Flow Statement · Forecast Roll-forwards — every subtotal a live formula, every projection traced to a driver.

Download the full BABA model (xlsx)3 free models a month with an account, then $9 a month

Alibaba Group research

Aardvark Labs Capital Research has published 4 reports on Alibaba Group (BABA). The latest is the Q1 FY27 Earnings Recap, published August 26, 2026, rated Outperform.

Cloud Hits Every Checkpoint We Set; the Street Repriced the Bill Instead

All BABA research →

Methodology

Every projected revenue cell traces to a KPI/driver row (C14). Terminal driver cells are rates, counts, or historical anchors — never typed-in projected dollar levels (C15). Every subtotal-vs-reported reconciliation row ties to $0 (C13). Each model is written per-ticker against its actual schema — no cloning, no level-input shortcuts.