Financials Macromill, Inc.

Equities

3978

JP3863030007

Advertising & Marketing

Market Closed - Japan Exchange 02:00:00 2024-05-28 am EDT 5-day change 1st Jan Change
892 JPY -0.34% Intraday chart for Macromill, Inc. +12.20% +13.49%

Valuation

Fiscal Period: June 2019 2020 2021 2022 2023 2024 2025 2026
Capitalization 1 51,715 29,751 33,981 35,488 32,122 34,111 - -
Enterprise Value (EV) 1 77,227 53,612 54,239 54,816 56,180 56,220 53,840 50,129
P/E ratio 11 x -13.9 x 12.2 x 11.3 x 4.38 x 14.6 x 10.3 x 9.09 x
Yield 0.7% 1.49% 1.53% 1.9% 2.5% 2.8% 3.08% 3.31%
Capitalization / Revenue 1.17 x 0.72 x 0.79 x 0.71 x 0.79 x 0.78 x 0.72 x 0.67 x
EV / Revenue 1.74 x 1.3 x 1.26 x 1.1 x 1.38 x 1.28 x 1.14 x 0.99 x
EV / EBITDA 8.42 x 6.2 x 6.25 x 6.3 x 8.14 x 8.15 x 6.64 x 5.66 x
EV / FCF 20,174,368 x 9,525,857 x 11,091,744 x 14,215,693 x -24,163,318 x - - -
FCF Yield 0% 0% 0% 0% -0% - - -
Price to Book 1.74 x 1.08 x 1.15 x 1.12 x 0.85 x 0.88 x 0.82 x 0.77 x
Nbr of stocks (in thousands) 39,997 40,312 39,883 39,563 38,195 38,241 - -
Reference price 2 1,293 738.0 852.0 897.0 841.0 892.0 892.0 892.0
Announcement Date 8/7/19 8/31/20 8/12/21 8/9/22 8/14/23 - - -
1JPY in Million2JPY
Estimates

Income Statement Evolution (Annual data)

Fiscal Period: June 2019 2020 2021 2022 2023 2024 2025 2026
Net sales 1 44,279 41,270 43,175 49,810 40,616 44,005 47,129 50,675
EBITDA 1 9,167 8,651 8,680 8,697 6,898 6,897 8,113 8,861
EBIT 1 7,751 396 5,362 5,814 4,960 5,056 6,100 6,663
Operating Margin 17.5% 0.96% 12.42% 11.67% 12.21% 11.49% 12.94% 13.15%
Earnings before Tax (EBT) 1 7,285 8 4,887 5,605 3,728 5,285 6,395 7,000
Net income 1 4,702 -2,131 2,822 3,147 7,575 2,488 3,481 3,753
Net margin 10.62% -5.16% 6.54% 6.32% 18.65% 5.65% 7.39% 7.41%
EPS 2 117.9 -52.94 70.08 79.71 191.9 61.27 87.00 98.16
Free Cash Flow 3,828 5,628 4,890 3,856 -2,325 - - -
FCF margin 8.65% 13.64% 11.33% 7.74% -5.72% - - -
FCF Conversion (EBITDA) 41.76% 65.06% 56.34% 44.34% - - - -
FCF Conversion (Net income) 81.41% - 173.28% 122.53% - - - -
Dividend per Share 2 9.000 11.00 13.00 17.00 21.00 25.00 27.50 29.50
Announcement Date 8/7/19 8/31/20 8/12/21 8/9/22 8/14/23 - - -
1JPY in Million2JPY
Estimates

Income Statement Evolution (Quarterly data)

Fiscal Period: June 2020 S1 2021 S1 2022 Q2 2022 S1 2022 Q3 2022 Q4 2023 Q1 2023 Q2 2023 S1 2023 Q3 2023 Q4 2024 Q1 2024 Q2 2024 S1 2024 Q3 2024 Q4
Net sales 1 21,767 21,037 13,540 24,430 13,521 11,859 12,435 15,738 28,173 15,284 8,910 9,607 12,488 22,095 12,167 9,690
EBITDA - - - - - - - - - - - - - - - -
EBIT 1 3,608 2,846 2,581 3,712 2,405 -303 815 2,082 2,897 2,330 100 326 2,051 2,377 2,289 441
Operating Margin 16.58% 13.53% 19.06% 15.19% 17.79% -2.56% 6.55% 13.23% 10.28% 15.24% 1.12% 3.39% 16.42% 10.76% 18.81% 4.55%
Earnings before Tax (EBT) 1 3,480 2,569 - 3,583 2,341 - 747 - 2,738 2,213 - 284 2,103 2,387 2,409 481
Net income 1 2,078 1,333 - 1,946 1,451 - 204 - 1,219 1,435 - -113 1,001 888 1,561 147
Net margin 9.55% 6.34% - 7.97% 10.73% - 1.64% - 4.33% 9.39% - -1.18% 8.02% 4.02% 12.83% 1.52%
EPS 51.69 33.07 - 49.33 36.77 - 5.180 - 30.81 36.27 - -2.980 - 23.26 40.85 -
Dividend per Share - - - - - - - - - - - - - 12.00 - -
Announcement Date 2/12/20 2/10/21 2/9/22 2/9/22 5/12/22 8/9/22 11/10/22 2/14/23 2/14/23 5/15/23 8/14/23 11/14/23 2/14/24 2/14/24 5/15/24 -
1JPY in Million
Estimates

Balance Sheet Analysis

Fiscal Period: June 2019 2020 2021 2022 2023 2024 2025 2026
Net Debt 1 25,512 23,861 20,258 19,328 24,058 22,109 19,729 16,018
Net Cash position 1 - - - - - - - -
Leverage (Debt/EBITDA) 2.783 x 2.758 x 2.334 x 2.222 x 3.488 x 3.205 x 2.432 x 1.808 x
Free Cash Flow 3,828 5,628 4,890 3,856 -2,325 - - -
ROE (net income / shareholders' equity) 17.1% -7.4% 9.9% 10.3% 21.8% 6.12% 8.34% 8.85%
ROA (Net income/ Total Assets) 6.04% -2.74% 6.06% 6.69% 4.19% 5.7% 6.7% 7.2%
Assets 1 77,822 77,774 46,540 47,072 180,626 43,657 51,954 52,126
Book Value Per Share 2 743.0 684.0 739.0 801.0 986.0 1,017 1,083 1,155
Cash Flow per Share 2 153.0 16.20 - 152.0 268.0 118.0 141.0 154.0
Capex 1 2,087 1,922 1,141 1,227 1,527 2,000 2,000 2,000
Capex / Sales 4.71% 4.66% 2.64% 2.46% 3.76% 4.54% 4.24% 3.95%
Announcement Date 8/7/19 8/31/20 8/12/21 8/9/22 8/14/23 - - -
1JPY in Million2JPY
Estimates

EPS & Dividend

Year-on-year evolution of the PER

Year-on-year evolution of the Yield

Change in Enterprise Value/EBITDA

Trading Rating
Investor Rating
ESG Refinitiv
More Ratings
Sell
Consensus
Buy
Mean consensus
HOLD
Number of Analysts
2
Last Close Price
892 JPY
Average target price
775 JPY
Spread / Average Target
-13.12%
Consensus
  1. Stock Market
  2. Equities
  3. 3978 Stock
  4. Financials Macromill, Inc.