(A) ULTA + SBH (B)

Share Issuance for Full Acquisition (Model SI‑ACQ‑FULL)

@SimSim 52 days ago

This model simulates the gain/loss when company A issues new shares to fully acquire another company B. This is also called a full stock swap, and the Swap Ratio is the number of new shares issued in company A divided by the current number of shares in company B.

Whether this results in a gain or loss to the shareholders of the two companies, depends on how many new shares of company A that are issued to pay for company B, compared to the intrinsic values of the two companies, as well as the earnings synergies that arise from the merger. This is only a "zero-sum game" when the synergies equal the fees.

You should NOT adjust the intrinsic value for tax on dividends and capital gains, because that would distort the calculations. You also cannot specify the dividend tax in this model, because it cancels out in the formulas.

Docs Related Models

Keywords: DEMO SBH ULTA

  • (A) ULTA Earnings = Net Profit Margin (2014-2023) x Sales (2023)
  • (B) SBH Earnings = Net Profit Margin (2011-2023) x Sales (2022-2023)
  • Both companies:
    • Zero Real Growth
    • Discount Rate = normal dist 10% mean, 1% std.dev.

2024-10-30T11:45:45.489498 image/svg+xml Matplotlib v3.9.2, https://matplotlib.org/ 5b 10b 15b 20b Intrinsic Value A Cur. M-Cap A = USD 18.9b 1b 2b 3b 4b Intrinsic Value B Cur. M-Cap B = USD 1.21b 80m 100m 120m Synergy
  • This plot shows the probability distributions for the simulations.
  • The two left sub-plots show the Intrinsic Values of the companies A and B to their current shareholders before the stock swap. Their current Market-Caps are shown as dashed blue lines, so you can easily see how they compare to the Intrinsic Values.
  • The right sub-plot shows the earnings synergies that arise from the merger of the two companies.
2024-10-30T11:45:32.778636 image/svg+xml Matplotlib v3.9.2, https://matplotlib.org/ 0% 20% 40% 60% 80% 100% 120% Return on Intrinsic Value (ROIV) for Company A SimSim.Run - Oct 30-2024 (UTC) (A) ULTA + SBH (B) Share Issuance for Full Acquisition (Model SI-ACQ-FULL) Prob Loss: <0.1% Normal Mean 19.9% / Std 13% Kernel Density Estimate (KDE)
  • This histogram shows the Return on Intrinsic Value (ROIV) for the current shareholders of company A, when company A issues 3.3m new shares to fully acquire company B. This corresponds to 6.08% of total shares in company A, and a Swap Ratio of 0.03.
  • >99.9% of 500k simulation trials had valid results. Outliers >10.0 IQR are removed.
  • ROIV is invalid when the intrinsic value is zero or negative. ROIS also works in those cases.
  • The red box at the bottom shows the probability of loss for the current shareholders of company A.
2024-10-30T11:45:34.194947 image/svg+xml Matplotlib v3.9.2, https://matplotlib.org/ -100% -80% -60% -40% -20% 0% 20% Return on Intrinsic Value (ROIV) for Company B SimSim.Run - Oct 30-2024 (UTC) (A) ULTA + SBH (B) Share Issuance for Full Acquisition (Model SI-ACQ-FULL) Prob Loss: >99.9% Normal Mean -66.8% / Std 10% Kernel Density Estimate (KDE)
  • This histogram shows the Return on Intrinsic Value (ROIV) for the current shareholders of company B, when company A issues 3.3m new shares to fully acquire company B. This corresponds to 6.08% of total shares in company A, and a Swap Ratio of 0.03.
  • 100% of 500k simulation trials had valid results. Outliers >10.0 IQR are removed.
  • ROIV is invalid when the intrinsic value is zero or negative. ROIS also works in those cases.
  • The red box at the bottom shows the probability of loss for the current shareholders of company B.
2024-10-30T11:45:35.576937 image/svg+xml Matplotlib v3.9.2, https://matplotlib.org/ 0% 50% 100% 150% 200% 250% 300% 350% Return on Issuance (ROIS) for Company A SimSim.Run - Oct 30-2024 (UTC) (A) ULTA + SBH (B) Share Issuance for Full Acquisition (Model SI-ACQ-FULL) Prob Loss: <0.1% Normal Mean 123% / Std 35% Kernel Density Estimate (KDE)
  • This histogram shows the Return on Issuance (ROIS) for the current shareholders of company A, when company A issues 3.3m new shares to fully acquire company B. This corresponds to 6.08% of total shares in company A, and a Swap Ratio of 0.03.
  • 100% of 500k simulation trials had valid results. Outliers >10.0 IQR are removed.
  • The red box at the bottom shows the probability of loss for the current shareholders of company A.
2024-10-30T11:45:36.977844 image/svg+xml Matplotlib v3.9.2, https://matplotlib.org/ -350% -300% -250% -200% -150% -100% -50% 0% Return on Issuance (ROIS) for Company B SimSim.Run - Oct 30-2024 (UTC) (A) ULTA + SBH (B) Share Issuance for Full Acquisition (Model SI-ACQ-FULL) Prob Loss: >99.9% Normal Mean -117% / Std 35% Kernel Density Estimate (KDE)
  • This histogram shows the Return on Issuance (ROIS) for the current shareholders of company B, when company A issues 3.3m new shares to fully acquire company B. This corresponds to 6.08% of total shares in company A, and a Swap Ratio of 0.03.
  • 100% of 500k simulation trials had valid results. Outliers >10.0 IQR are removed.
  • The red box at the bottom shows the probability of loss for the current shareholders of company B.
2024-10-30T11:45:38.483648 image/svg+xml Matplotlib v3.9.2, https://matplotlib.org/ 0.02 0.025 0.03 0.035 0.04 Swap Ratio (A/B) 0% 20% 40% 60% 80% 100% 120% Return on Intrinsic Value (ROIV) for Company A SimSim.Run - Oct 30-2024 (UTC) (A) ULTA + SBH (B) Share Issuance for Full Acquisition (Model SI-ACQ-FULL) Prob Loss: <0.1%
  • This 2D histogram shows how different Swap Ratios would impact the Return on Intrinsic Value (ROIV) for the current shareholders of company A, when issuing new shares to fully acquire company B.
  • >99.9% of 500k simulation trials had valid results. Outliers >10.0 IQR are removed.
  • ROIV is invalid when the intrinsic value is zero or negative. ROIS also works in those cases.
  • The x-axis shows a range of Swap Ratios around 0.03, which is marked as a dashed blue line.
  • The y-axis shows the Return on Intrinsic Value (ROIV) for the current shareholders of company A.
  • The red box at the bottom shows the probability of loss for the current shareholders of company A, when the Swap Ratio is 0.03.
2024-10-30T11:45:40.279705 image/svg+xml Matplotlib v3.9.2, https://matplotlib.org/ 0.02 0.025 0.03 0.035 0.04 Swap Ratio (A/B) -80% -60% -40% -20% 0% 20% Return on Intrinsic Value (ROIV) for Company B SimSim.Run - Oct 30-2024 (UTC) (A) ULTA + SBH (B) Share Issuance for Full Acquisition (Model SI-ACQ-FULL) Prob Loss: >99.9%
  • This 2D histogram shows how different Swap Ratios would impact the Return on Intrinsic Value (ROIV) for the current shareholders of company B, when swapping all their shares for newly issued shares in company A.
  • 100% of 500k simulation trials had valid results. Outliers >10.0 IQR are removed.
  • ROIV is invalid when the intrinsic value is zero or negative. ROIS also works in those cases.
  • The x-axis shows a range of Swap Ratios around 0.03, which is marked as a dashed blue line.
  • The y-axis shows the Return on Intrinsic Value (ROIV) for the current shareholders of company B.
  • The red box at the bottom shows the probability of loss for the current shareholders of company B, when the Swap Ratio is 0.03.
2024-10-30T11:45:41.993520 image/svg+xml Matplotlib v3.9.2, https://matplotlib.org/ 0.02 0.025 0.03 0.035 0.04 Swap Ratio (A/B) 0% 100% 200% 300% 400% 500% Return on Issuance (ROIS) for Company A SimSim.Run - Oct 30-2024 (UTC) (A) ULTA + SBH (B) Share Issuance for Full Acquisition (Model SI-ACQ-FULL) Prob Loss: <0.1%
  • This 2D histogram shows how different Swap Ratios would impact the Return on Issuance (ROIS) for the current shareholders of company A, when issuing new shares to fully acquire company B.
  • 100% of 500k simulation trials had valid results. Outliers >10.0 IQR are removed.
  • The x-axis shows a range of Swap Ratios around 0.03, which is marked as a dashed blue line.
  • The y-axis shows the Return on Issuance (ROIS) for the current shareholders of company A.
  • The red box at the bottom shows the probability of loss for the current shareholders of company A, when the Swap Ratio is 0.03.
2024-10-30T11:45:43.692464 image/svg+xml Matplotlib v3.9.2, https://matplotlib.org/ 0.02 0.025 0.03 0.035 0.04 Swap Ratio (A/B) -500% -400% -300% -200% -100% 0% Return on Issuance (ROIS) for Company B SimSim.Run - Oct 30-2024 (UTC) (A) ULTA + SBH (B) Share Issuance for Full Acquisition (Model SI-ACQ-FULL) Prob Loss: >99.9%
  • This 2D histogram shows how different Swap Ratios would impact the Return on Issuance (ROIS) for the current shareholders of company B, when swapping all their shares for newly issued shares in company A.
  • 100% of 500k simulation trials had valid results. Outliers >10.0 IQR are removed.
  • The x-axis shows a range of Swap Ratios around 0.03, which is marked as a dashed blue line.
  • The y-axis shows the Return on Issuance (ROIS) for the current shareholders of company B.
  • The red box at the bottom shows the probability of loss for the current shareholders of company B, when the Swap Ratio is 0.03.