Projected Income Statement: Trend Micro Incorporated

Forecast Balance Sheet: Trend Micro Incorporated

Forecast Balance Sheet - Trend Micro Incorporated
Fiscal Period: December 2021 2022 2023 2024 2025 2026 2027 2028
Net Debt 1 -256,801 -242,849 -299,026 -210,895 -231,030 -214,015 -215,544 -218,155
Change - 5.43% -23.13% 29.47% -9.55% 7.36% -0.71% -1.21%
Announcement Date 2/17/22 A 2/16/23 A 2/15/24 A 2/18/25 A 2/18/26 A - - -
1JPY in Million
Estimates

Cash Flow Forecast: Trend Micro Incorporated

Fiscal Period: December 2021 2022 2023 2024 2025 2026 2027 2028
CAPEX 1 18,787 20,979 26,361 24,940 22,857 26,000 25,500 25,500
Change - 11.67% 25.65% -5.39% -8.35% 13.75% -1.92% 0%
Free Cash Flow (FCF) 1 57,842 -10,813 30,866 21,841 41,779 27,514 38,404 67,840
Change - -118.69% 385.45% -29.24% 91.29% -34.14% 39.58% 76.65%
Announcement Date 2/17/22 A 2/16/23 A 2/15/24 A 2/18/25 A 2/18/26 A - - -
1JPY in Million
Estimates

Forecast Financial Ratios: Trend Micro Incorporated

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

Profitability

        
EBITDA Margin (%) 33.9% 25.26% 24.5% 28.25% 30.5% 23.53% 24.72% 25.81%
EBIT Margin (%) 22.93% 14% 13.11% 17.64% 20.93% 15.46% 17.24% 18.95%
EBT Margin (%) 27.51% 18.72% 12.86% 20.39% 18.96% 16.4% 17.05% 18.45%
Net margin (%) 20.16% 13.33% 4.31% 12.6% 12.51% 10.6% 11.64% 12.59%
FCF margin (%) 30.39% -4.83% 12.41% 8.01% 15.14% 9.19% 12.13% 19.99%
FCF / Net Income (%) 150.76% -36.23% 287.63% 63.57% 121.02% 86.72% 104.18% 158.74%

Profitability

        
ROA 11.16% 7.67% 7.51% 11.8% 13.12% 8.69% 9.04% 9.24%
ROE 18.9% 13.4% 4.9% 20.9% 46.24% 26.64% 28.1% 33%

Financial Health

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

Capital Intensity

        
CAPEX / Current Assets (%) 9.87% 9.37% 10.6% 9.15% 8.28% 8.68% 8.05% 7.52%
CAPEX / EBITDA (%) 29.11% 37.11% 43.27% 32.38% 27.16% 36.91% 32.57% 29.11%
CAPEX / FCF (%) 32.48% -194.02% 85.4% 114.19% 54.71% 94.5% 66.4% 37.59%

Items per share

        
Cash flow per share 1 411.8 383.8 272.7 353 463 1,417 790 1,010
Change - -6.79% -28.95% 29.45% 31.17% 206.01% -44.24% 27.88%
Dividend per Share 1 195 151 738 184 185 176.5 209.1 243.2
Change - -22.56% 388.74% -75.07% 0.54% -4.58% 18.46% 16.3%
Book Value Per Share 1 1,569 1,630 1,563 890.8 975.8 1,010 999.9 999.9
Change - 3.9% -4.11% -42.99% 9.54% 3.47% -0.97% 0%
EPS 1 275.2 213.6 78.45 259 262.4 248.2 291.7 343.7
Change - -22.39% -63.27% 230.21% 1.3% -5.43% 17.52% 17.85%
Nbr of stocks (in thousands) 139,615 139,109 135,473 131,188 130,558 129,792 129,792 129,792
Announcement Date 2/17/22 A 2/16/23 A 2/15/24 A 2/18/25 A 2/18/26 A - - -
1JPY
Estimates
2026 *2027 *
P/E 28.5x 24.2x
PBR 7x 7.07x
EV / Sales 2.35x 2.22x
Yield 2.5% 2.96%

EPS & Dividend

EPS & Dividend - Trend Micro Incorporated


Y-o-Y evolution of P/E

Valuation ratios - P/E - Trend Micro Incorporated
 

Year-on-year evolution of the Yield

Valuation ratios - Yield - Trend Micro Incorporated
Trader
Investor
Global
Quality
ESG MSCI
A
MarketScreener Ratings - Trend Micro Incorporated
Sell
Consensus
Buy
Mean consensus
HOLD
Number of Analysts
9
Last Close Price
7,070.00JPY
Average target price
6,400.00JPY
Spread / Average Target
-9.48%

Quarterly revenue - Rate of surprise

Rate of surprise - Net sales - Quarterly - Trend Micro Incorporated
  1. Stock Market
  2. Stocks
  3. 4704 Stock
  4. Financials Trend Micro Incorporated