Hey everyone, today I'll be doing napkin math valuation to value JD.com. My valuation will be quite different from many company analysis usually seen on this subreddit as personally, I can't be bothered to read what a company actually does. I'm more interested in its financial statements. If they pass my napkin math hurdle rate of return, then maybe I'll actually read their investor presentation. To start off, let's look at JD.com.
Financial statement summary:
| in $Mn | Revenue | % YoY Growth | EBITDA | EBITDA Margin | Total Debt | Excess Cash | Market Cap | EV | EV/EBITDA |
|---|---|---|---|---|---|---|---|---|---|
| FY18 | 64,682.77 | – | 414.85 | 0.64% | $ 1,382.36 | $ 5,081.72 | $ 30,420.00 | $ 26,720.64 | 64.41 |
| FY19 | 80,764.32 | 24.86% | 1,531.32 | 1.90% | $ 1,407.14 | $ 8,620.36 | $ 51,730.00 | $ 44,516.78 | 29.07 |
| FY20 | 104,412.28 | 29.28% | 2,346.68 | 2.25% | $ 1,754.20 | $ 20,532.68 | $ 137,290.00 | $ 118,511.52 | 50.50 |
| FY21 | 133,222.88 | 27.59% | 1,344.84 | 1.01% | $ 1,314.04 | $ 25,946.34 | $ 109,620.00 | $ 84,987.70 | 63.20 |
| FY22 | 146,473.04 | 9.95% | 3,581.20 | 2.44% | $ 4,232.62 | $ 30,793.84 | $ 97,840.00 | $ 71,278.78 | 19.90 |
| CAGR | 17.76% | 5 yr average | 1.65% | Average Multiple | 45.42 |
This information was taken off of tikr. I was a little confused by their currency translation as going from RMB to USD, the revenue growth numbers were different. As a result, I just took their RMB information and multiplied it by 0.14, the current exchange rate.
The current market cap for JD is 53.64B. As we can see, JD has an astonishing 30.8B in cash with a net debt of 26.5B. After subtracting out their cash, we get a market cap of 27B.
To reiterate, their EBITDA was 3.6B. This gives us an EV/EBITDA multiple of 7.5 which is obviously crazy low. Using statista.com, we can see that the EV/EBITDA for the sp500 consumer discretionary sector is 14.44, about 92% higher.
What could JD look like in 5 years? Let's put in some assumptions: Given that retail is not known for its high growth rates and profit margins are razor thin and our goal is not to lose money, we should be pretty conservative. We'll assume a 4% revenue CAGR and a 1.5% EBITDA margin, 10% less than their 5 yr avg. We'll also assume an exit multiple of 13x, 10% less than the 2022 sp500 avg and no share dilution. In exchange for us putting our money into this stock, we'll expect a return of 15% annually. Here's the numbers:
| 2023 | $ 152,331.96 | 4% | 1.5% | $ 2,284.98 |
|---|---|---|---|---|
| 2024 | $ 158,425.24 | 4% | 1.5% | $ 2,376.38 |
| 2025 | $ 164,762.25 | 4% | 1.5% | $ 2,471.43 |
| 2026 | $ 171,352.74 | 4% | 1.5% | $ 2,570.29 |
| 2027 | $ 178,206.85 | 4% | 1.5% | $ 2,673.10 |
| Exit Multiple | 13 | |||
| EV | $ 34,750.34 | |||
| Less: Debt | $ (4,232.62) | |||
| Add: Cash | $ 30,793.84 | |||
| Market Cap | $ 61,311.56 | |||
| Diluted Shares | 1,566 | (in Mn) | ||
| Share Decrease | 0.00% | |||
| 2027 Price | $ 39.15 | |||
| Current Price: | $ 34.00 | |||
| Desired Return | 15.00% | |||
| Buy Price | $ 19.47 |
Given our assumptions, JD isn't that great of an investment and we should wait for it to drop lower before buying.
What about if we're more bullish on the stock? We'll upgrade our multiple to 14.4x and increase our revenue growth assumptions to 10% and our EBITDA margin to 2.25%.
| 2023 | $ 161,120.34 | 10% | 2.25% | $ 3,625.21 | |
|---|---|---|---|---|---|
| 2024 | $ 177,232.38 | 10% | 2.25% | $ 3,987.73 | |
| 2025 | $ 194,955.62 | 10% | 2.25% | $ 4,386.50 | |
| 2026 | $ 214,451.18 | 10% | 2.25% | $ 4,825.15 | |
| 2027 | $ 235,896.30 | 10% | 2.25% | $ 5,307.67 | |
| Exit Multiple | 14 | ||||
| EV | $ 74,307.33 | ||||
| Less: Debt | $ (4,232.62) | ||||
| Add: Cash | $ 30,793.84 | ||||
| Market Cap | $ 100,868.55 | ||||
| Diluted Shares | 1,566 | (in Mn) | |||
| Share Decrease | 0.00% | ||||
| 2027 Price | $ 64.41 | ||||
| Current Price: | $ 34.00 | ||||
| Desired Return | 15.00% | ||||
| Buy Price | $ 32.02 |
Unfortunately, JD would still be considered not a buy as it would need to drop 6% as of today's closing price of $34 to be considered a buy.
In conclusion, while JD seems extraordinarily cheap, it would need to have incredible growth over the next five years to justify buying it at its current share price. Factor in geopolitical tensions and general distrust of chinese stocks, JD is unfortunately not a buy with simple napkin math.
Let me know if you enjoyed this post and if so, leave a ticker! Criticism is always appreciated, thank you!
Leave a Reply