Financials Macromill, Inc.

Equities

3978

JP3863030007

Advertising & Marketing

Market Closed - Japan Exchange 02:00:00 2024-04-26 am EDT 5-day change 1st Jan Change
727 JPY +1.11% Intraday chart for Macromill, Inc. +1.25% -7.51%

Valuation

Fiscal Period: June 2019 2020 2021 2022 2023 2024 2025 2026
Capitalization 1 51,715 29,751 33,981 35,488 32,122 27,801 - -
Enterprise Value (EV) 1 77,227 53,612 54,239 54,816 56,180 49,910 47,530 43,819
P/E ratio 11 x -13.9 x 12.2 x 11.3 x 4.38 x 11.1 x 8.35 x 7.41 x
Yield 0.7% 1.49% 1.53% 1.9% 2.5% 3.44% 3.71% 4.06%
Capitalization / Revenue 1.17 x 0.72 x 0.79 x 0.71 x 0.79 x 0.63 x 0.59 x 0.55 x
EV / Revenue 1.74 x 1.3 x 1.26 x 1.1 x 1.38 x 1.14 x 1 x 0.86 x
EV / EBITDA 8.42 x 6.2 x 6.25 x 6.3 x 8.14 x 7.24 x 5.57 x 4.95 x
EV / FCF 20.2 x 9.53 x 11.1 x 14.2 x -24.2 x 8.51 x 7.5 x -
FCF Yield 4.96% 10.5% 9.02% 7.03% -4.14% 11.7% 13.3% -
Price to Book 1.74 x 1.08 x 1.15 x 1.12 x 0.85 x 0.71 x 0.67 x 0.63 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 727.0 727.0 727.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 43,962 47,516 50,675
EBITDA 1 9,167 8,651 8,680 8,697 6,898 6,897 8,533 8,861
EBIT 1 7,751 396 5,362 5,814 4,960 5,056 5,980 6,663
Operating Margin 17.5% 0.96% 12.42% 11.67% 12.21% 11.5% 12.58% 13.15%
Earnings before Tax (EBT) 1 7,285 8 4,887 5,605 3,728 5,135 6,065 7,000
Net income 1 4,702 -2,131 2,822 3,147 7,575 2,495 3,328 3,753
Net margin 10.62% -5.16% 6.54% 6.32% 18.65% 5.68% 7% 7.41%
EPS 2 117.9 -52.94 70.08 79.71 191.9 65.25 87.03 98.16
Free Cash Flow 1 3,828 5,628 4,890 3,856 -2,325 5,863 6,336 -
FCF margin 8.65% 13.64% 11.33% 7.74% -5.72% 13.34% 13.33% -
FCF Conversion (EBITDA) 41.76% 65.06% 56.34% 44.34% - 85% 74.26% -
FCF Conversion (Net income) 81.41% - 173.28% 122.53% - 234.98% 190.41% -
Dividend per Share 2 9.000 11.00 13.00 17.00 21.00 25.00 27.00 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 Q1 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 10,890 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,215 9,690
EBITDA - - - - - - - - - - - - - - - - -
EBIT 1 3,608 2,846 1,131 2,581 3,712 2,405 -303 815 2,082 2,897 2,330 100 326 2,051 2,377 2,282 441
Operating Margin 16.58% 13.53% 10.39% 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.68% 4.55%
Earnings before Tax (EBT) 1 3,480 2,569 1,056 - 3,583 2,341 - 747 - 2,738 2,213 - 284 2,103 2,387 2,332 481
Net income 1 2,078 1,333 518 - 1,946 1,451 - 204 - 1,219 1,435 - -113 1,001 888 1,265 147
Net margin 9.55% 6.34% 4.76% - 7.97% 10.73% - 1.64% - 4.33% 9.39% - -1.18% 8.02% 4.02% 10.36% 1.52%
EPS 51.69 33.07 13.14 - 49.33 36.77 - 5.180 - 30.81 36.27 - -2.980 - 23.26 - -
Dividend per Share - - - - - - - - - - - - - - 12.00 - -
Announcement Date 2/12/20 2/10/21 11/11/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 - -
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.312 x 1.808 x
Free Cash Flow 1 3,828 5,628 4,890 3,856 -2,325 5,863 6,336 -
ROE (net income / shareholders' equity) 17.1% -7.4% 9.9% 10.3% 21.8% 6.12% 8.29% 8.85%
ROA (Net income/ Total Assets) 6.04% -2.74% 6.06% 6.69% 4.19% 5.7% 5.05% 7.2%
Assets 1 77,822 77,774 46,540 47,072 180,626 43,774 65,893 52,126
Book Value Per Share 2 743.0 684.0 739.0 801.0 986.0 1,017 1,091 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.55% 4.21% 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
727 JPY
Average target price
775 JPY
Spread / Average Target
+6.60%
Consensus
  1. Stock Market
  2. Equities
  3. 3978 Stock
  4. Financials Macromill, Inc.