Napkin Math Valuation- JD.Com ($JD)

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!

submitted by /u/thelastsubject123
[link] [comments] https://www.reddit.com/r/stocks/comments/14mhbds/napkin_math_valuation_jdcom_jd/
Creato 2y | 30 giu 2023, 08:21:16


Accedi per aggiungere un commento

Altri post in questo gruppo

Rate My Portfolio - r/Stocks Quarterly Thread September 2023

Please use this thread to discuss your portfolio, learn of other stock tickers, and help out users by giving constructive criticism.

Why quarterly? Public comp

21 ott 2023, 01:20:16 | reddit stocks
Tax planning when selling one stock to buy another stock?

When you sell a stock to buy another stock, do you prefer to set the estimated amount of the capital gains taxes aside in a money market or do you think it better to

18 ott 2023, 06:20:11 | reddit stocks
Retirement Planning's-3 stocks could help power your investment portfolio and make you wealthier by retirement.

Saving for retirement is crucial, but relying solely on a 401(k) might not be enough due to high inflation. Consider investing in growth stocks, especially in the tec

18 ott 2023, 01:51:00 | reddit stocks
r/Stocks Daily Discussion Monday - Oct 16, 2023

These daily discussions run from Monday to Friday including during our themed posts.

Some helpful links:

18 ott 2023, 01:50:58 | reddit stocks
Discovery Financial Services (DFS). Any good ?

I’m think this is not a good investment as there is no chatter at all on the 52 week low. They are involved in a class action lawsuits by investors and credit card co

18 ott 2023, 01:50:56 | reddit stocks
Tax implications of selling one etf for a dividend etf?

Sorry if this is the wrong sub. Let’s say I had $1 million in VOO but I wanted to sell half of it to buy SCHD. It would suck to pay taxes on $500k. So how would you g

18 ott 2023, 01:50:53 | reddit stocks
Crocs Stock Analysis (CROX)

Hey guys, I did a deep dive into Crocs. In this analysis, I will do a brief breakdown of the company and go over some quantitative data, qualitative data and estimate

18 ott 2023, 01:50:51 | reddit stocks