Projected Income Statement: Shopify Inc.

Forecast Balance Sheet: Shopify Inc.

Fiscal Period: December 2020 2021 2022 2023 2024 2025 2026 2027
Net Debt 1 -5,630 -6,857 -4,140 -4,092 -4,561 -6,479 -9,115 -12,803
Change - -21.79% 39.62% 1.16% -11.46% -42.05% -40.69% -40.46%
Announcement Date 2/17/21 2/16/22 2/15/23 2/13/24 2/11/25 - - -
1USD in Million
Estimates

Cash Flow Forecast: Shopify Inc.

Fiscal Period: December 2020 2021 2022 2023 2024 2025 2026 2027
CAPEX 1 41.73 50.79 50.02 39 19 23.46 27.61 40.64
Change - 21.7% -1.52% -22.03% -51.28% 23.47% 17.68% 47.21%
Free Cash Flow (FCF) 1 383.2 453.6 -186.5 905 1,597 1,967 2,592 3,289
Change - 18.37% -141.1% 585.34% 76.46% 23.17% 31.79% 26.87%
Announcement Date 2/17/21 2/16/22 2/15/23 2/13/24 2/11/25 - - -
1USD in Million
Estimates

Forecast Financial Ratios: Shopify Inc.

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

Profitability

        
EBITDA Margin (%) 16.59% 16.53% 0.77% 11.53% 17.15% 17.02% 18.55% 20.4%
EBIT Margin (%) 14.93% 15.57% 0.11% 11.08% 16.75% 16.64% 17.86% 19.44%
EBT Margin (%) 8.2% 68.1% -64.7% 2.62% 25.09% 10.9% 15.94% 16.33%
Net margin (%) 10.91% 63.2% -61.79% 1.87% 22.74% 9.04% 14.03% 14.82%
FCF margin (%) 13.08% 9.84% -3.33% 12.82% 17.98% 17.16% 18.35% 19.18%
FCF / Net Income (%) 119.94% 15.56% 5.39% 685.61% 79.1% 189.91% 130.82% 129.4%

Profitability

        
ROA 8.73% 27.62% 0.39% 8.59% 12.96% 10.89% 14.31% 14.94%
ROE 10.43% 9.29% 0.49% 10.94% 15.86% 14.99% 16.62% 18.18%

Financial Health

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

Capital Intensity

        
CAPEX / Current Assets (%) 1.42% 1.1% 0.89% 0.55% 0.21% 0.2% 0.2% 0.24%
CAPEX / EBITDA (%) 8.58% 6.66% 116.65% 4.79% 1.25% 1.2% 1.05% 1.16%
CAPEX / FCF (%) 10.89% 11.2% -26.82% 4.31% 1.19% 1.19% 1.07% 1.24%

Items per share

        
Cash flow per share 1 0.3442 0.396 -0.1078 0.7287 1.242 1.592 1.984 2.829
Change - 15.06% -127.22% 775.97% 70.39% 28.19% 24.67% 42.57%
Dividend per Share 1 - - - - - - - -
Change - - - - - - - -
Book Value Per Share 1 5.353 9.77 6.461 7.047 9.511 9.915 11.96 14.45
Change - 82.51% -33.87% 9.06% 34.97% 4.24% 20.66% 20.78%
EPS 1 0.259 2.29 -2.73 0.1 1.55 0.7998 1.526 1.947
Change - 784.17% -219.21% 103.66% 1,450% -48.4% 90.74% 27.62%
Nbr of stocks (in thousands) 1,226,711 1,256,003 1,272,089 1,286,099 1,292,100 1,301,843 1,301,843 1,301,843
Announcement Date 2/17/21 2/16/22 2/15/23 2/13/24 2/11/25 - - -
1USD
Estimates
2025 *2026 *
P/E ratio 200x 105x
PBR 16.1x 13.4x
EV / Sales 17.6x 14.1x
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
AA
More Ratings
Sell
Consensus
Buy
Mean consensus
OUTPERFORM
Number of Analysts
52
Last Close Price
159.85USD
Average target price
175.43USD
Spread / Average Target
+9.75%
Consensus

Quarterly revenue - Rate of surprise

  1. Stock Market
  2. Equities
  3. SHOP Stock
  4. Financials Shopify Inc.