Equity Capital Markets & IPO Syndicate
IPO Underpricing, Gross Spread & Greenshoe Formula
Calculate IPO First-Day Underpricing Pop, Jay Ritter’s Money Left on the Table, Net Issuer Proceeds after Underwriter Gross Spread, and 15% Greenshoe Over-Allotment exercise vs stabilization.
Understand how the 15% Greenshoe short position stabilizes broken IPOs risk-free!
Named after Green Shoe Manufacturing Company (1963), the SEC-permitted 15% Over-Allotment ("Greenshoe") Option lets IPO bookrunners allocate 115% of Base_IPO_Shares S_base to institutional investors at Offer_Price P_offer — creating a 15% syndicate short position backed by a 30-day call option to buy up to 0.15 * S_base additional shares from the issuer at P_offer (less Gross_Spread u_fee)! Look at the two-state aftermarket payoff at First_Day_Close P_close: (1) Hot IPO (P_close >= P_offer): covering in the open market would lose money, so underwriters EXERCISE the 15% Greenshoe call, raising Total Issued Shares to S_base * (1 + g_max) and Net Issuer Proceeds to S_base * (1 + g_max) * P_offer * (1 - u_fee); (2) Broken IPO (P_close < P_offer): underwriters let the call option lapse and BUY BACK 0.15 * S_base shares in the open market to support the stock price, leaving issuer proceeds at S_base * P_offer * (1 - u_fee)!
Verify on Base_IPO_Shares S_base = 10.00M (B2), IPO_Offer_Price P_offer = $20.00 (B3), First_Day_Close P_close = $26.00 (B4), Gross_Underwriting_Spread u_fee = 0.07 (7.00%, B5), and Greenshoe_Ratio g_max = 0.15 (15.0%, B6): First-Day Pop is (26 - 20) / 20 = +0.3000 (+30.00%); Greenshoe is exercised (11.50M total shares); Jay Ritter’s "Money Left on the Table" MAX(0, P_close - P_offer) * Total_Shares is 6.00 * 11.50 = $69.00M; and Net Issuer Cash Proceeds equal 11.50 * 20.00 * (1 - 0.07) = $213.90M ($16.10M gross spread)! Test a broken debut P_close = $18.00 in cell B4: Greenshoe is unexercised ("Stabilization Buyback (Shoe Unexercised)") and Net Issuer Proceeds hold at 10.00 * 20.00 * 0.93 = $186.00M!
| IPO Syndicate Metric (10M Base @ $20, Close $26, 7% Spread, 15% Shoe) | Formula | Verified Output |
|---|---|---|
| First-Day IPO Return (Pop / Drop) | (P_close - P_offer) / P_offer | +0.3000 (+30.00%) |
| Money Left on the Table ($M) | MAX(0, P_close - P_offer) * Total_Issued_Shares | $69.00M (on 11.50M sh) |
| Net Issuer Cash Proceeds ($M) | Total_Issued_Shares * P_offer * (1 - u_fee) | $213.90M ($186.00M if P_close < $20) |
| Syndicate Greenshoe Action | P_close >= P_offer ? Exercise : Open-Mkt Cover | Greenshoe Exercised (+15% Shares) |
State-Contingent Net Issuer IPO Proceeds Formula
Validate S_base > 0, P_offer > 0, P_close > 0, 0 <= u_fee < 1, and 0 <= g_max <= 0.15 (SEC Rule 15% over-allotment cap)!
=LET(sh_bs, B2, px_of, B3, px_cl, B4, fe_uw, B5, gs_mx, B6, IF(OR(sh_bs <= 0, px_of <= 0, px_cl <= 0, fe_uw < 0, fe_uw >= 1, gs_mx < 0, gs_mx > 0.15), "Invalid IPO Syndicate Input", LET(sh_tt, sh_bs * (1 + IF(px_cl >= px_of, gs_mx, 0)), ROUND(sh_tt * px_of * (1 - fe_uw), 2))))Ritter Money Left on the Table & Stabilization Regime Formula
Money Left on the Table equals zero (never negative) when an IPO closes at or below its offer price!
=IF(ISTEXT(E4), E4, ROUND(MAX(0, B4 - B3) * B2 * (1 + IF(B4 >= B3, B6, 0)), 2))Try the example
Use the original values or change them to test your understanding.