Projected Income Statement: Coupang, Inc.

Forecast Balance Sheet: Coupang, Inc.

Fiscal Period: December 2020 2021 2022 2023 2024 2025 2026 2027
Net Debt 1 - -2,855 -2,843 -4,229 -4,346 -5,301 -6,549 -8,247
Change - - 0.42% -48.75% -2.77% -21.97% -23.54% -25.93%
Announcement Date 2/12/21 3/2/22 2/28/23 2/27/24 2/25/25 - - -
1USD in Million
Estimates

Cash Flow Forecast: Coupang, Inc.

Fiscal Period: December 2021 2022 2023 2024 2025 2026 2027
CAPEX 1 673.7 824.3 896 879 1,134 1,210 1,312
Change - 22.36% 8.7% -1.9% 28.96% 6.76% 8.37%
Free Cash Flow (FCF) 1 -1,084 -258.8 1,756 1,016 731.5 1,372 2,026
Change - 76.13% 778.46% -42.14% -28% 87.56% 47.63%
Announcement Date 3/2/22 2/28/23 2/27/24 2/25/25 - - -
1USD in Million
Estimates

Forecast Financial Ratios: Coupang, Inc.

Fiscal Period: December 2020 2021 2022 2023 2024 2025 2026 2027

Profitability

        
EBITDA Margin (%) - -4.06% 0.58% 3.07% 3.22% 3.38% 5.54% 6.71%
EBIT Margin (%) - -6.51% -0.54% 1.94% 1.44% 2.03% 3.41% 4.73%
EBT Margin (%) - -8.38% -0.45% 2.4% 1.56% 2.49% 4.07% 5.03%
Net margin (%) - -8.38% -0.45% 5.58% 0.51% 0.89% 2.32% 3.44%
FCF margin (%) - -5.89% -1.26% 7.2% 3.36% 2.1% 3.41% 4.46%
FCF / Net Income (%) - 70.29% 281.2% 129.12% 659.74% 235.76% 147.33% 129.71%

Profitability

        
ROA - -22.5% -1.01% 11.9% 1.07% 2.11% 4.74% 7.33%
ROE - -196.17% -4.01% 41.83% 3.76% 7% 17.44% 22.62%

Financial Health

        
Leverage (Debt/EBITDA) - - - - - - - -
Debt / Free cash flow - - - - - - - -

Capital Intensity

        
CAPEX / Current Assets (%) - 3.66% 4% 3.67% 2.9% 3.25% 3.01% 2.89%
CAPEX / EBITDA (%) - -90.11% 692.97% 119.79% 90.06% 96.04% 54.34% 43.07%
CAPEX / FCF (%) - -62.13% -318.47% 51.03% 86.52% 154.97% 88.21% 64.75%

Items per share

        
Cash flow per share 1 - -0.2884 0.3204 1.471 1.033 1.416 1.299 1.765
Change - - 211.13% 359.03% -29.78% 37.13% -8.3% 35.87%
Dividend per Share 1 - - - - - - - 0.0211
Change - - - - - - - -
Book Value Per Share 1 - 1.528 1.362 2.284 2.278 2.693 3.168 3.99
Change - - -10.89% 67.71% -0.25% 18.22% 17.61% 25.98%
EPS 1 -7.23 -1.08 -0.05 0.75 0.08 0.1682 0.4535 0.8221
Change - 85.06% 95.37% 1,600% -89.33% 110.2% 169.71% 81.26%
Nbr of stocks (in thousands) - 1,751,442 1,770,298 1,787,787 1,798,859 1,826,648 1,826,648 1,826,648
Announcement Date 2/12/21 3/2/22 2/28/23 2/27/24 2/25/25 - - -
1USD
Estimates
2025 *2026 *
P/E ratio 126x 46.6x
PBR 7.85x 6.67x
EV / Sales 0.95x 0.8x
Yield - -
More valuation ratios * Estimated data

EPS & Dividend

Y-o-Y evolution of P/E

Year-on-year evolution of the Yield

Trader
Investor
Global
Quality
ESG MSCI
-
More Ratings
Sell
Consensus
Buy
Mean consensus
BUY
Number of Analysts
16
Last Close Price
21.13USD
Average target price
33.35USD
Spread / Average Target
+57.83%
Consensus

Quarterly revenue - Rate of surprise

  1. Stock Market
  2. Equities
  3. CPNG Stock
  4. Financials Coupang, Inc.