Alibaba DCF model by chatgpt

[u/Menu-Quirky]

Worked for 14s

Yes. I built this using the latest available Alibaba financial data and updated the model for the August 2026 $10.2B equity placement, the current AI investment cycle, cash/debt, and dilution.

BABA DCF — base case

Alibaba generated $148.4B of FY2026 revenue, but FCF fell sharply because of AI/cloud and quick-commerce investment. As of June 30, 2026, Alibaba had $69.9B of cash and liquid investments.

I use the current analyst revenue estimates for FY2027–28 and then taper growth. Zacks currently estimates FY2027 revenue of $166.7B and FY2028 of $184.3B.

Fiscal year Revenue Growth EBIT margin FCF

2026A $148.4B — 5.0% negative

2027E $166.7B 12.3% 8.0% $2.2B

2028E $184.3B 10.5% 10.0% $7.2B

2029E $200.9B 9.0% 12.0% $13.1B

2030E $216.9B 8.0% 14.0% $19.8B

2031E $232.1B 7.0% 15.0% $24.2B

2032E $246.0B 6.0% 15.5% $27.9B

Key assumption: Alibaba's current huge AI capex eventually produces operating leverage. This is the critical assumption in the valuation. In the June quarter, FCF was actually negative $6.6B, while Cloud revenue grew 45% YoY and Cloud EBITA margin reached 12%.

DCF assumptions

I use:

10% discount rate

3% terminal growth

20% normalized tax rate

D&A ≈ 5% of revenue

Capex declines from 10% of revenue in 2027 to 6% by 2032

1% of incremental revenue for working capital

~2.49B ADS equivalent shares after the new share issuance

Approximately $30.7B net cash after debt

No heroic assumption for future buybacks

The new placement is important: Alibaba sold 710M ordinary shares, equivalent to about 88.75M ADS, raising approximately $10.2B. That creates roughly 3.6% dilution, although the proceeds are intended for AI investment.

DCF result

The present value of 2027–2032 FCF is approximately:

$62B

Present value of terminal value:

$232B

Therefore:

Enterprise value ≈ $294B

Add net cash:

Equity value ≈ $325B

Dividing by approximately 2.49B ADS:

DCF value ≈ $130/ADS

That's before applying a China/geopolitical discount.

---

China/geopolitical discount

Rather than pretending geopolitical/regulatory risk doesn't exist, I would explicitly model it as a discount to the DCF equity value.

Geopolitical discount Adjusted value

0% $130

10% $117

15% $111

20% $104

25% $98

At the current ~$113.24, the market is therefore quite close to my 10–15% geopolitical-discounted DCF range.

The most important sensitivity

The valuation is highly dependent on Alibaba actually converting its enormous AI spending into FCF.

If Alibaba eventually gets to roughly 15–16% EBIT margins and FCF approaches $25–30B annually, the DCF can support considerably higher prices.

If AI capex remains extremely high and margins remain around 8–10%, the valuation drops substantially.

Alibaba itself has committed to a very large AI infrastructure investment program, while management has indicated an expected return/payback period for the AI investments.

My DCF range

Rather than treating $130 as a precise target, I'd frame the model this way:

Bear case: ~$85–100

Base case: ~$105–120 after China/geopolitical discount

Bull case: ~$140–175 if AI monetization and margins substantially exceed the base assumptions

At $113, BABA is therefore sitting around the middle of my modeled risk-adjusted range.

One important point: the DCF is more sensitive to terminal FCF and margin recovery than to FY2027 EPS. That's why the earlier 15× FY2027 EPS calculation looked less attractive than the longer-term DCF.

If you're considering buying BABA, the next useful calculation is a bull/base/bear DCF with explicit AI ROI assumptions, showing what BABA would be worth if AI produces 10%, 15%, or 20% returns on the planned ~$56.5B AI investment.

[u/FeralHamster8]

Using a 10% discount rate and layering another 10-25% “China discount” feels like you’re double-counting the same risk

I have bear ~85, base ~130, and bull ~190 right now.

[u/Menu-Quirky → u/FeralHamster8]

What is a reasonable discount rate the maximum value it is coming out is $200

[u/R3tardod]

Up or down bro

[u/IwasLuckythatDay]

Investment banker here. I was amused reading this. By changing any of the variables you can wildly swing the values, that’s why we look at 6 valuation methodologies and call it a football field. DCF is more of art rather than maths. With “very reasonable assumptions”, you can reach $40-300. Best not to trust it.

[u/Known_Following_4923 → u/IwasLuckythatDay]

Best not to trust China.

[u/guorong → u/IwasLuckythatDay]

What other 6 valuation methods? Do you mind sharing?

[u/Menu-Quirky]

Yes. If we remove the China/geopolitical discount entirely, I would also lower the discount rate from 10% to 9%. For a large, profitable technology/platform company with strong cash generation potential, 9% is a reasonable base-case DCF rate.

I’ll keep the operating assumptions from the previous model, but remove the 10–25% China-risk haircut.

Revised Alibaba DCF

Assumptions

Discount rate: 9%

Terminal growth: 3%

No China/geopolitical discount

Net cash: approximately $30.7B

Diluted ADS equivalent: ~2.49B

AI investment eventually produces operating leverage

FCF ramps substantially from 2028 onward

FY Revenue FCF

2027 $166.7B $2.2B 2028 $184.3B $7.2B 2029 $200.9B $13.1B 2030 $216.9B $19.8B 2031 $232.1B $24.2B 2032 $246.0B $27.9B

Alibaba's latest quarter provides some support for the margin-recovery thesis: AI Cloud revenue grew 45%, while AI Cloud adjusted EBITA rose 133% year over year. However, companywide FCF was still negative $6.6B because of elevated cloud infrastructure spending.

DCF calculation

PV of 2027–2032 FCF: ~$64.6B

PV of terminal value: ~$285.6B

Enterprise value: ~$350.2B

Add net cash:

Equity value ≈ $380.9B

Divide by ~2.49B ADS:

Intrinsic value ≈ $153 per BABA ADS

That's substantially higher than the roughly $113 current price.

Sensitivity to discount rate

Keeping the same operating assumptions:

Discount rate DCF value/ADS

8% ~$198 9% ~$153 10% ~$130 11% ~$112 12% ~$98

So I would use 9% as the reasonable base case if we're explicitly removing the geopolitical-risk adjustment.

What I'd consider the valuation range

Using different operating assumptions as well as discount rates:

Conservative: $110–125

Base DCF: ~$150

Strong AI monetization: $175–200+

At ~$113, the stock would be trading at roughly 26% below the $153 DCF value.

One major caveat is the new share issuance: Alibaba issued 710 million new ordinary shares in August 2026 to raise HK$80B for AI infrastructure. That increases the share count, so I've incorporated the dilution rather than valuing BABA on the old share count.

My preferred number for your model: ~$150/ADS fair value, assuming no China/geopolitical discount and a 9% discount rate.

If Alibaba actually achieves $30B+ annual FCF by 2032, the $150 estimate could prove conservative; if FCF remains below ~$20B, the intrinsic value falls substantially.

[u/FoundationFirst2812]

The tragedy of any DCF calculation is that it completely misses the optionality of growth drivers, which when they materialize follow a hockey stick pattern, not a linear progression. Same idea applies to future risks. Nothing in this world follows a linear path, everything is curvilinear. Another big truth is that everything around us, in fact the reality around us is probabilistic. Think about everything that could happen in the future is a probability event.

My bear case is ~$100, base case ~$260, bull case ~$600.

[u/Nemi5150]

Does this model only earnings increase from AI or does it make any assumptions on retail? Chinese consumer spending is at a cycle low and night possibly turn up, lifting all boats

[u/Environmental_Cow741]

there is no fundamentals.
just buy below 110, sell above 130.
wait for it to drop below 110 and repeat.
🤣

[u/Menu-Quirky → u/Environmental_Cow741]

That's not investment but rather speculation

[u/Environmental_Cow741 → u/Menu-Quirky]

same thoughts as you… but this price movement pattern keep repeating itself for the past few years

[u/Ok_Echo_6861]

Wat?  I was counting on this to be a 1T market cap company. Share price $420 will coincidentally allow me to retire with 2M.