
What Are IPO Models? Purpose, Uses, and Advantages
IPO Financial Model: What It Is and How to Build One (With a Worked Example) An IPO financial model is an Excel model that estimates how much money a company raises when it lists its shares, how much existing owners are diluted, and what valuation the offer price implies. It takes the offer price, new and existing shares sold, and issue costs as inputs, and outputs net proceeds, post-IPO ownership and valuation multiples. Note: "IPO model" is also the name of the input-process-output framework used in systems analysis and operations. This guide covers the initial public offering model used in finance.
Key takeaways
- An IPO model answers three questions: how much the company raises, who owns what afterwards, and whether the price is reasonable against listed peers.
- The core inputs are the price band, the fresh issue, the offer for sale (OFS), issue expenses and the company's earnings.
- Money from a fresh issue goes to the company; money from an OFS goes to the selling shareholders.
- In India, IPOs are governed by the SEBI (Issue of Capital and Disclosure Requirements) Regulations, 2018, which set rules on price bands, anchor investors, the greenshoe option and lock-in periods.
What Is an IPO Financial Model?
An IPO financial model is a focused transaction model built around a company's first sale of shares to the public. It does not replace a full three-statement or DCF valuation. Instead, it takes a valuation range as given and works out what a particular deal structure means for the company and its shareholders.
Several groups build or use IPO models:
- Book running lead managers (investment banks) use them to set the price band and size the offer.
- The company's CFO and board use them to decide how much to raise and how much dilution to accept.
- Pre-IPO investors and promoters use them to see what they receive from selling shares in the OFS.
- Equity research analysts and institutional investors use them to judge whether the offer price is attractive. If you are new to this side of finance, our guide to what equity research involves is a good starting point.
Why Companies Go Public: Equity Financing and the IPO
Companies raise money in two broad ways: debt (borrowing that must be repaid with interest) and equity (selling a share of ownership). An initial public offering is the first time a company sells its shares to the general public and lists them on a stock exchange such as the NSE or BSE. Most companies reach this point only after several years of private funding from founders, angel investors, venture capital or private equity.
Advantages and disadvantages of an IPO
| Advantages | Disadvantages |
|---|---|
| Raises capital without adding debt or interest costs | Ongoing disclosure and compliance obligations after listing |
| Gives early investors and promoters a route to sell part of their stake | Significant one-time costs: banker fees, legal, audit, marketing and listing expenses |
| Listed shares can be used to pay for acquisitions or employee stock options | Share price becomes exposed to market sentiment, which can be volatile |
| Higher visibility with customers, lenders and future hires | Existing shareholders are diluted when new shares are issued |
For investors, the main risk is limited information. A newly listed company has no trading history, so its price has never been tested by the market. That is why a disciplined model, rather than headlines about oversubscription, is the better basis for a view on value.
How an IPO Works in India
A mainboard IPO in India typically follows these stages:
- Appoint advisers. The company hires book running lead managers (BRLMs), legal counsel and auditors.
- File the DRHP. The draft red herring prospectus, describing the business, risks, financials and the offer structure, is filed with SEBI for observations.
- File the RHP and announce the price band. After SEBI's observations are addressed, the red herring prospectus is filed and the price band is announced.
- Anchor allocation. Anchor investors (large qualified institutional buyers) are allotted shares one working day before the issue opens.
- Bidding. Qualified institutional buyers, non-institutional investors and retail investors bid within the price band during the subscription window.
- Pricing, allotment and listing. The final offer price is fixed, shares are allotted and the stock lists. SEBI's T+3 timeline requires listing within three working days of the issue closing.
Most Indian mainboard IPOs use the book building method, where investors bid within a price band and the final price reflects demand. In a fixed price issue, the price is set before the offer opens. You can read how book building works on BSE's public issue guide.
Separately, an IPO can include a fresh issue (new shares created by the company, so the money goes to the company), an offer for sale (existing shareholders sell their shares, so the money goes to them), or both. Keep these two ideas apart: book building and fixed price describe how the price is set, while fresh issue and OFS describe where the money goes.
Key Inputs of an IPO Model
| Input | What it means | Where to find it |
|---|---|---|
| Price band | The floor and cap price at which investors can bid | Price band announcement / RHP |
| Pre-IPO shares outstanding | Shares held by promoters, investors and employees before the offer | Capital structure section of the DRHP/RHP |
| Fresh issue | New shares (or a rupee amount) the company will issue | "The Offer" section of the DRHP/RHP |
| Offer for sale | Existing shares sold by named shareholders | "The Offer" section of the DRHP/RHP |
| Issue expenses | BRLM fees, legal, audit, listing and marketing costs | "Objects of the Offer" section |
| Earnings and other metrics | Revenue, EBITDA and profit after tax (PAT) | Restated financial statements |
| Peer multiples | P/E, EV/EBITDA or EV/Sales of comparable listed companies | "Basis for Offer Price" section and market data |
How to Build an IPO Model in Excel: Step by Step
Step 1: Set up the assumptions
Create a clearly labelled input block with the price band, pre-IPO shares, fresh issue size, OFS size, issue expenses as a percentage of the fresh issue, and the earnings figure you will value against. Colour inputs differently from formulas so the model is easy to audit.
Step 2: Choose the offer price and compare it with peers
Model both ends of the price band. IPOs are usually priced at a discount to comparable listed companies, because new investors take on the risk of an untested stock. The model should show that discount explicitly.
Step 3: Split primary and secondary shares, and note the greenshoe
Separate the fresh issue (primary shares) from the OFS (secondary shares). If the offer includes a greenshoe option, record the number of over-allotted shares separately, because they only become new shares if the option is exercised.
Step 4: Calculate proceeds
Gross fresh-issue proceeds equal new shares multiplied by the offer price. Subtract issue expenses to get net proceeds to the company. OFS proceeds are calculated the same way but belong to the selling shareholders, not the company.
Step 5: Build the post-IPO shareholding table
Add the new shares to the pre-IPO count to get post-IPO shares. Then show each group's ownership before and after the offer: promoters, pre-IPO investors, anchors and the public.
Step 6: Calculate valuation multiples and run sensitivities
Multiply post-IPO shares by the offer price to get market capitalisation, then divide by earnings to get the P/E (or use enterprise value for EV/EBITDA). Finally, flex the offer price and the issue size to see how the outputs move. Our guide to sensitivity analysis in financial models explains how to set up data tables for this.
Core formulas
| Output | Formula |
|---|---|
| Gross fresh-issue proceeds | New shares × offer price |
| Net proceeds to company | Gross fresh-issue proceeds × (1 − issue expense %) |
| OFS proceeds (to sellers) | OFS shares × offer price |
| Pre-money valuation | Pre-IPO shares × offer price |
| Post-IPO market capitalisation | (Pre-IPO shares + new shares) × offer price |
| Dilution | New shares ÷ post-IPO shares |
| P/E at offer price | Post-IPO market capitalisation ÷ PAT |
| Discount to peers | 1 − (IPO P/E ÷ peer median P/E) |
IPO Model Example: A Worked Calculation
The figures below are illustrative, not taken from a real company. Assume a company with 8 crore shares outstanding plans an IPO with a price band of ₹235–₹250. It will issue 2 crore new shares, and existing investors will sell 1 crore shares through an OFS. Issue expenses are assumed at 3% of the fresh issue, last year's PAT is ₹125 crore, and listed peers trade at a median P/E of 23x.
| Item | At ₹235 (floor) | At ₹250 (cap) |
|---|---|---|
| Pre-IPO shares | 8 crore | 8 crore |
| New shares (fresh issue) | 2 crore | 2 crore |
| OFS shares | 1 crore | 1 crore |
| Gross fresh-issue proceeds | ₹470 crore | ₹500 crore |
| Issue expenses (3%) | ₹14.1 crore | ₹15 crore |
| Net proceeds to company | ₹455.9 crore | ₹485 crore |
| OFS proceeds (to selling shareholders) | ₹235 crore | ₹250 crore |
| Pre-money valuation | ₹1,880 crore | ₹2,000 crore |
| Post-IPO shares | 10 crore | 10 crore |
| Post-IPO market capitalisation | ₹2,350 crore | ₹2,500 crore |
| Dilution of existing shareholders | 20% | 20% |
| P/E at offer price (PAT ₹125 crore) | 18.8x | 20.0x |
| Discount to peer median P/E of 23x | 18.3% | 13.0% |
How to read this: at the top of the band, the company raises ₹485 crore after costs, existing holders are diluted by 20%, and the IPO is priced at 20x earnings, a 13% discount to peers. After the offer, pre-IPO shareholders own 7 crore of the 10 crore shares (70%), and the public owns the 3 crore shares sold in the offer (30%).
A modelling note: Indian offer documents usually state the fresh issue as a rupee amount, not a share count. In that case the number of new shares depends on the final price, so dilution changes slightly across the band. We fixed the share count here to keep the arithmetic easy to follow.
Greenshoe Option and Lock-In Periods
What a greenshoe option does
A greenshoe, or over-allotment option, lets the stabilising agent allot up to 15% more shares than the base offer, using shares borrowed from promoters or existing shareholders. If the share price falls below the offer price after listing, the agent buys shares in the market during the stabilisation period (up to 30 days from listing) to support the price, and returns them to the lenders. If the price holds up, the company issues new shares to replace the borrowed ones. In our example, a full greenshoe on the 3 crore share offer would be 45 lakh shares, worth ₹112.5 crore at ₹250.
Lock-in periods for Indian mainboard IPOs
Lock-in rules stop certain shareholders from selling immediately after listing. Under the SEBI ICDR Regulations, 2018 , the main lock-ins are:
| Shareholder | Lock-in from allotment |
|---|---|
| Promoters' minimum contribution (20% of post-issue capital) | 18 months; 3 years if more than half the fresh issue proceeds fund capital expenditure |
| Promoter holding above the minimum contribution | 6 months; 1 year in the capital expenditure case |
| Pre-IPO shareholders other than promoters | 6 months (with conditional exemptions, for example certain employee stock option holders and qualifying VC/AIF investors) |
| Anchor investors | 30 days on 50% of their allotment; 90 days on the remaining 50% |
| Retail and other public investors | No lock-in |
In the US, lock-ups are contractual agreements with the underwriters rather than regulatory rules, and they commonly run for about 180 days. Whatever the market, it helps to note lock-in expiry dates in your model, because a large block of shares becoming free to sell can affect trading.
IPO Valuation: Why Private and Public Prices Differ
A company's last private funding round is not a reliable guide to its listing value. Private rounds often come with special rights for investors, such as liquidation preferences (which pay certain investors first in a sale) and ratchets (anti-dilution protection if a later round or IPO is priced lower). These rights make a private share worth more to its holder than an ordinary listed share, so the headline private valuation can overstate what public investors will pay. Private companies also face less public scrutiny of their financial statements than listed companies do.
That is why an IPO model values the company on the same basis as listed peers, using the restated financials in the offer document. For a refresher on the methods behind peer multiples and intrinsic value.
Want to understand IPO financial modeling practically? Join our free masterclass and learn the fundamentals, key concepts, and practical applications.
Limitations of an IPO Model
- It does not predict demand. Subscription levels and the listing-day price depend on market sentiment, which no spreadsheet captures.
- It relies on peer selection. Choosing different comparable companies can change the implied valuation significantly.
- It is only as good as its earnings input. Using one year's PAT for a fast-growing or loss-making company can mislead; forward estimates or other metrics such as EV/Sales may be more suitable.
- Timing matters. Companies can postpone an IPO when market conditions turn weak, even if the model shows a sound valuation.
Skills You Need to Build IPO Models
Building an IPO model draws on Excel skills, an understanding of financial statements, valuation using peer multiples and DCF, and the ability to read an offer document. These are the same skills used in investment banking, equity research and corporate finance roles.
FAQs
What is an IPO financial model?
An IPO financial model is an Excel model that estimates the money a company raises in its initial public offering, the dilution to existing shareholders and the valuation implied by the offer price. Its main inputs are the price band, fresh issue, offer for sale, issue expenses and earnings.
How do you build an IPO model in Excel?
Set up an assumptions block, model both ends of the price band, separate fresh-issue shares from offer-for-sale shares, calculate gross and net proceeds, build a post-IPO shareholding table, then calculate market capitalisation, P/E and the discount to listed peers. Finish with a sensitivity table on price and issue size.
What is the difference between a fresh issue and an offer for sale?
In a fresh issue, the company creates and sells new shares, so the money goes to the company and existing shareholders are diluted. In an offer for sale, existing shareholders sell shares they already own, so the money goes to them and the total number of shares does not change.
How do you calculate dilution in an IPO?
Divide the number of new shares issued by the total shares outstanding after the IPO. For example, if a company with 8 crore shares issues 2 crore new shares, dilution is 2 ÷ 10 = 20%.
What is a greenshoe option in an IPO?
A greenshoe, or over-allotment option, allows the stabilising agent to allot up to 15% more shares than the base offer. If the price falls below the offer price after listing, the agent buys shares in the market to support it; if the price holds, the company issues the extra shares.
What is the lock-in period after an IPO in India?
Under SEBI's ICDR Regulations, promoters' minimum contribution is locked in for 18 months (3 years if most of the fresh issue funds capital expenditure), other pre-IPO shareholders for 6 months, and anchor investors for 30 days on half their shares and 90 days on the rest. Retail investors have no lock-in.
Is an IPO financial model the same as the input-process-output (IPO) model?
No. The input-process-output model is a general framework for describing how a system turns inputs into outputs. An IPO financial model is a finance tool for analysing an initial public offering. They share an abbreviation but are unrelated.
Conclusion
An IPO financial model turns an offer document into a few clear answers: how much the company raises, how ownership changes, and whether the price looks reasonable against listed peers. Once you can separate fresh issue from OFS, calculate dilution and compare multiples across the price band, you can read any IPO with far more confidence than headline subscription numbers allow.

Seasoned valuation specialist with 10+ years across PwC, TresVista, and Moody's Analytics. Focuses on building institutional-grade models completely from a blank sheet.

Chartered Financial Analyst (CFA) and FMVA certified expert. Leads transaction mandates at Wodehouse Capital Advisors, with prior research tenure at SG Analytics.

Over a decade of hands-on transaction advisory experience with Cube Highways, EY, and Macquarie. Expert in complex multi-currency cash flow forecasting and project feasibility.
Get Course Brochure
Detailed curriculum, placement report & fee structure.
100% Privacy Protected. No Spam Guarantee.



