# IPO Pricing Model Build an IPO pricing model that triangulates DCF, peer comps, and precedent transactions to establish a defensible offer price. Includes post-money cap table, IPO discount logic, and use-of-proceeds planning. - Canonical: https://finamodel.com/templates/ipo-pricing-model - Excel download: https://finamodel.com/templates/ipo-pricing.xlsx - Category: Corporate Finance - Model type: Valuation - Difficulty: Advanced - Audiences: Bankers & advisors, Investors & analysts, Finance directors, IPO advisors, Pre-IPO shareholders, Investment bankers - Tags: ipo-pricing, cap-table, valuation, waterfall, lockup ## Overview This valuation and waterfall model computes IPO pricing, dilution, and equity distribution by building pre-IPO cap table with preferred shares, options, and common equity; modelling IPO pricing scenarios; calculating post-IPO ownership; and forecasting per-share returns for founders, employees, and early investors. The workbook starts with pre-IPO cap table (Series A–C preferred, option pool, common equity), applies price per share across a range of IPO scenarios (conservative, base, bull case valuations). Each scenario produces post-IPO shares outstanding, ownership percentage by class, and per-share proceeds. Dilution bridges show cumulative dilution from founding through IPO (e.g., founder 25% → 18% through Series rounds → 15% post-IPO due to option pool refreshes). Proceeds allocation: company treasury injection (balance sheet strengthening), debt paydown, direct placement (existing shareholder secondary sales). Lockup expiration and secondary overhang are disclosed. Used by companies planning IPOs, underwriters preparing IPO roadshows, venture firms modelling exit returns, and employee stock option plan (ESOP) administrators valuing liquidity events. The model reveals founder dilution impact (multi-round financings typically dilute founders 30–50% by IPO) and option pool refresh risk (new ESOP pool created at IPO often triggers immediate dilution). Per-share returns to early investors can be modelled: Series A at £0.50/share → IPO at £15/share = 30× multiple. Benchmarks: tech IPOs typically 10–15% secondary overhang post-lockup expiration; traditional companies 5–10%. ## What's included - Multi-method valuation with DCF, comps, and precedent transactions - IPO discount and offer price sensitivity analysis - Post-money cap table and dilution waterfall - Greenshoe over-allotment option modelling - Transaction cost schedule and use-of-proceeds breakdown - Pre-IPO cap table with preferred shares, options, and common equity - IPO pricing scenarios and resulting valuations - Post-IPO cap table and ownership dilution by class - Proceeds allocation (company treasury, debt paydown, direct placement) - Lockup expiration and secondary sale overhang - Per-share returns for founders, employees, and early investors ## IPO Pricing Model: How the Template Values a Deal This IPO pricing model template walks through the institutional workflow for setting a public offer price. It combines a 10-year DCF with an 8-peer trading-comps cross-check, runs a demand-driven bookbuild, allocates net proceeds including debt repayment, and tracks lock-up expiry. Ideal for analysts and corporate teams evaluating deal structures. ### Documented Operating Drivers of the IPO Pricing Model The model is built for ECM analysts, buy-side allocators, corporate finance teams and LPs, with 13 interdependent sheets. Inputs flow from an Assumptions tab that houses a scenario switch plus revenue, cost, WACC and IPO drivers. - The Income Statement produces a 10-year P&L, while Working Capital converts DSO, DIO and DPO into changes in net working capital. A Debt Schedule tracks beginning balance, IPO paydown, mandatory amortisation and interest at the pre-IPO cost of debt. - A Lock-Up sheet splits shares across four holder classes and releases them at 180 days. ### Calculation Flow From Assumptions to Offer Price Fair value is the average of the DCF and comps outputs. Comps average three implied prices from EV/Revenue, EV/EBITDA and P/E methods across eight peers. - The DCF discounts a 10-year unlevered free cash flow stream, defined as NOPAT plus D&A minus CapEx, change in net working capital and stock-based compensation, using a mid-year convention and a blended terminal value from Gordon Growth and exit multiple. The range mid equals fair value multiplied by one minus the effective IPO discount, with the low and high set by multipliers. - The final offer snaps to low, mid or high based on the demand multiple relative to named thresholds. ### Pull-Through of Proceeds to Capital Structure and Returns The Use-of-Proceeds block splits net proceeds across debt repayment, working capital, R&D, M&A and general corporate purposes. Debt repayment is a direct percentage of pre-IPO net debt, which avoids a circular reference while still feeding the debt schedule's year-one paydown. - Remaining categories must total 100% and are validated by a check. The debt schedule then computes interest on the average balance, which flows into the income statement's interest expense line. - Returns analysis reports day-one return as the difference between blended fair value and offer price, plus one-year and three-year IRRs for IPO buyers and cornerstone investors. ### Practical Use and Output Interpretation Outputs include the final offer price, pricing outcome (top, mid or bottom of range), net and primary proceeds, market capitalisation, implied multiples, dilution and free float at IPO. The lock-up sheet shows shares released at 180 days, post-lock-up free float and overhang as a percentage of market capitalisation. - Thirteen validation checks cover margins, offer price, proceeds, terminal value proportion, day-one return range, free float, use-of-proceeds totals, underwriting spread shares, lock-up percentages, debt paydown and DCF price. All thresholds are named ranges, and the model is fully structural, recalculating from upstream assumptions. - The public download is a values-only preview. ## Built for listing decisions Use this model when you need to determine the right offer price, understand dilution, and present a credible equity story to underwriters and investors. ## Structured around real IPO mechanics A useful IPO model needs more than a single valuation output. It should show how the cap table changes, how proceeds flow, and how the IPO discount affects investor returns. ## Cleaner starting point for book building Start from a proper IPO framework instead of adapting a generic valuation template that does not account for listing-specific dynamics. ## Built for listing decisions Use this model when you need to determine the right offer price, understand dilution, and present a credible equity story to underwriters and investors. ## Structured around real IPO mechanics A useful IPO model needs more than a single valuation output. It should show how the cap table changes, how proceeds flow, and how the IPO discount affects investor returns. ## Cleaner starting point for book building Start from a proper IPO framework instead of adapting a generic valuation template that does not account for listing-specific dynamics. ## Features - **Valuation bridge and multiples:** Compare IPO valuation to recent funding round, industry comps, and revenue multiples to assess fairness and pricing power. - **Dilution and overhang analysis:** Calculate option pool dilution, secondary share overhang, and post-lockup expiration dilution to model future value pressure. - **Waterfall and proceeds allocation:** Model proceeds allocation among company, underwriters, shareholders, and secondary sellers to show cash impact and use of funds. ## Use cases - **IPO pricing and underwriter guidance:** Build pricing models under different scenarios (conservative, base, bull case) to inform banker roadshow and valuation guidance. - **Employee communication and retention planning:** Model post-IPO value per share and RSU value to communicate upside, plan retention bonuses, and assess golden-handcuff needs. - **M&A comparison and strategic decision:** Compare IPO proceeds and per-share value to strategic acquisition offers to support board-level decision-making. ## Frequently asked questions ### What is an IPO pricing model? It is a financial model used to determine the offer price for a company going public, typically by combining intrinsic valuation, peer multiples, and an IPO discount assumption. ### What should an IPO pricing model include? A strong IPO pricing model should include multi-method valuation, cap table dilution, greenshoe mechanics, transaction costs, and use-of-proceeds analysis. ### Who uses IPO pricing models? They are commonly used by investment banks, CFOs, private equity sponsors, and corporate finance teams preparing for a public listing. ### How does the IPO discount work? The IPO discount is a reduction applied to the estimated fair value, typically 15 to 25 percent, to encourage first-day demand and a positive trading debut. ### Can I customise the peer group for valuation? Yes. The model is designed so you can input comparable public companies and adjust the multiples used to frame the valuation range. ## Related templates - [Cap Table Management Model](https://finamodel.com/templates/cap-table-model) - [Equity Portfolio Analysis](https://finamodel.com/templates/equity-portfolio-model) - [Exit Waterfall Model](https://finamodel.com/templates/exit-waterfall-model)