Ulta Beauty / High Earnings Growth 5Y
Share Issuance to Fund Investment (Model SI‑INV)
@SimSim September 11, 2024
This model simulates the gain/loss to current and new shareholders, when a company makes a new share issuance to fund an investment. The issuance amount equals the investment amount plus fees. But the fees are not actually needed in the valuation formulas so they have been omitted.
Whether the share issuance results in a gain or loss to the current and new shareholders, depends on whether the shares are mispriced, as well as the return on the investment. This is only a "zero-sum game" when the issuance amount equals the return on the investment.
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.
If you have great ideas for improving this model then please contact us.