Alibaba Group Holding Limited (BABA) - Intrinsic Value Analysis

P/E Valuation

Inputs
EPS (TTM) $6.87
Median historical P/E 16.73
Expected growth rate 12.00%
Margin of Safety 25.00%
Conservative growth rate 8.00%
Discount rate 9.00%
Calculations
Year EPS*Growth rate
1 $7.42
2 $8.01
3 $8.65
4 $9.35
5 $10.09
Value in 5 years $168.86
Present value $109.57
Present value (with MoS) $82.18

DCF Valuation

Inputs
Cash & Cash Equivalents $453.28B
Total Liabilities $652.23B
Free cash flow (TTM) $96.25B
Shares outstanding 2.38B
Expected growth rate 12.00%
Margin of Safety 25.00%
Conservative growth rate 0.00%
Growth decline rate 5.00%
Discount rate 9.00%
Year 10 FCF multiplier 12
Calculations
Year FCF * Growth rate NPV FCF
1 $107.80B $98.90B
2 $118.58B $99.88B
3 $127.01B $98.21B
4 $133.36B $94.75B
5 $138.69B $90.49B
6 $143.23B $85.74B
7 $147.09B $80.79B
8 $150.40B $75.79B
9 $153.26B $70.83B
10 $155.73B $66.01B
Total NPV FCF $861.40B
Year 10 FCF value $1,868.79B
Cash & Equivalents $453.28B
Total Liabilities $652.23B
Company value: $2,531.24B
Per share value: $1,063.55
Per share value (with MoS): $797.66

Financial Ratios

Debt to Equity (D/E): 24.14%
Current Ratio: 1.48
Quick Ratio (acid-test ratio): 1.22

Analysis Summary

Alibaba Group (BABA) presents a compelling investment opportunity based on both P/E and DCF valuation models:

Comparison of current price with intrinsic value:

Based on P/E valuation: Current price is 61.5% above the conservative intrinsic value

Based on DCF valuation: Current price is 83.4% below the conservative intrinsic value

Financial Health Assessment:

Alibaba maintains a healthy financial position with a low debt-to-equity ratio of 24.14%, indicating conservative leverage. The current ratio of 1.48 and quick ratio of 1.22 suggest adequate liquidity to meet short-term obligations. The company generates substantial free cash flow ($96.25B), which supports its long-term growth initiatives and potential shareholder returns.

Growth Prospects:

With a forward P/E of 13.12 (lower than its trailing P/E of 19.32), the market expects continued earnings growth. Quarterly revenue growth of 7.60% year-over-year and impressive quarterly earnings growth of 237.50% demonstrate strong operational performance. The dividend yield of 1.49% offers a modest income component to the investment thesis.

Investment Recommendation:

While the P/E valuation suggests Alibaba may be overvalued at current prices, the more comprehensive DCF model indicates significant undervaluation. Given Alibaba's strong financial position, consistent cash flow generation, and growth potential in the e-commerce and cloud computing sectors, the stock appears undervalued at its current price. The large divergence between valuation models suggests investors should conduct further research on growth assumptions and consider the impact of regulatory and geopolitical risks specific to Chinese technology companies.