In an initial public offering (IPO), a company lists its shares on a stock exchange. The offer can include new shares sold by the company (primary), which raise money and dilute existing holders, and existing shares sold by shareholders (secondary), which bring cash to them but not to the company. This calculator gives the market value, the net proceeds, the dilution, the share of the company offered, the fees and the effect of the greenshoe option.
How the calculation works
- Shares after the IPO = shares before + new shares
- Market value = shares after the IPO × offer price
- Net proceeds to the company = new shares × price × (1 − spread) − other expenses
- Dilution = new shares ÷ shares after the IPO
- Share offered = (new + existing shares sold) ÷ shares after the IPO
- Greenshoe shares = shares in the base deal × over-allotment percentage
Example
A company has 80 million shares. It sells 20 million new shares and holders sell 5 million existing shares at $18. After the IPO there are 100 million shares, a market value of $1,800 million and a pre-money value of $1,440 million. With a 6.5 % spread and $4 million of other costs, the company nets $332.6 million, and the sellers net $84.15 million. Existing holders are diluted by 20.0 % and 25.0 % of the company is offered to the public. The banks earn $29.25 million. If the 15 % greenshoe is used in full, the company nets $395.7 million.
Why it matters
The offer price sets the valuation, and the number of new shares sets how much of the company the founders and early investors give up for the cash. Comparing primary and secondary shares shows whether the IPO funds growth or mainly lets holders sell.
Good to know
The greenshoe lets banks sell up to about 15 % more shares to stabilize the price after the listing, and the extra shares are usually new. Lock-up agreements often stop insiders from selling for 90 to 180 days. The calculator keeps one price and ignores the first-day pop, the legal costs spread over years and taxes.
In practice
Test several prices and several mixes of primary and secondary shares. A larger secondary part means less money for the company at the same market value. Read the prospectus for the real numbers. This tool is for education and is not investment advice.