Three-statement Excel model · 21 quarters and 5 fiscal years of history · 11 quarters and 5 fiscal years of projections
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.
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 | ||||||
|---|---|---|---|---|---|---|
| Actual | Estimate | |||||
| 2024 | 2025 | 2026 | 2027E | 2028E | 2029E | |
| Customer management | 304,009.0 | 322,346.0 | 343,867.0 | 345,828.5 | 367,269.9 | 394,080.6 |
| Direct sales, logistics and others | 110,405.0 | 103,180.0 | 105,518.0 | 104,871.0 | 102,983.3 | 104,322.1 |
| China Quick Commerce | 78,520.0 | 254,318.9 | 315,355.4 | 378,426.5 | ||
| China commerce wholesale | 20,479.0 | 24,301.0 | 26,312.0 | 0.0 | 0.0 | 0.0 |
| International E-commerce | 81,654.0 | 108,465.0 | 117,731.0 | 124,427.7 | 141,225.5 | 160,997.1 |
| International commerce wholesale | 20,944.0 | 23,835.0 | 26,439.0 | 0.0 | 0.0 | 0.0 |
| Global Wholesale | 56,899.6 | 62,589.6 | 68,848.6 | |||
| AI Cloud and Compute Services | 106,374.0 | 118,028.0 | 158,132.0 | 236,516.2 | 332,305.3 | 453,596.8 |
| AI Labs and Applications | 15,145.5 | 19,234.7 | 24,043.4 | |||
| Cainiao Smart Logistics Network | 99,020.0 | 101,272.0 | 0.0 | 0.0 | 0.0 | |
| Local Services Group | 59,802.0 | 67,076.0 | 0.0 | 0.0 | 0.0 | |
| Digital Media and Entertainment | 21,145.0 | 22,267.0 | 0.0 | 0.0 | 0.0 | |
| All others | 192,331.0 | 206,269.0 | 254,367.0 | 126,047.6 | 132,980.3 | 141,624.0 |
| Unallocated | 1,297.0 | 1,924.0 | 2,340.0 | 2,695.1 | 2,843.3 | 3,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.0 | 0.0 |
| Other gains, net | 761.0 | 1,848.0 | 289.0 | 0.0 | 0.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, net | 6,157.0 | 3,387.0 | 1,518.0 | 1,865.8 | 2,064.5 | 2,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.0 | 2,785.0 | 3,675.7 | 5,505.5 | 8,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 interests | 8,677.0 | 4,133.0 | 1,465.0 | 809.7 | 688.2 | 643.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.0 | 0.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 notes | 0.0 | 235.0 | 309.0 | 340.4 | 352.6 | 345.2 |
| Dilution from assumed exchange of exchangeable bonds | 0.0 | (1,556.0) | 0.0 | 0.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 shares | 20,182.000 | 18,791.000 | 18,568.000 | 19,075.705 | 19,266.296 | 19,085.528 |
| Diluted weighted average ordinary shares | 20,359.000 | 19,318.000 | 19,235.000 | 19,722.700 | 19,866.296 | 19,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 Growth | 8.3% | 5.9% | 2.7% | 15.6% | 16.4% | 16.8% |
| Gross Margin | 37.7% | 40.0% | 39.8% | 38.5% | 39.8% | 41.2% |
| Effective Tax Rate | 22.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.
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
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.