What Are IPO Models? Purpose, Uses, and Advantages
Financial Modeling

What Are IPO Models? Purpose, Uses, and Advantages

Written by
Varun Chopra
Published2026-11-10
Updated2026-11-21

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

AdvantagesDisadvantages
Raises capital without adding debt or interest costsOngoing disclosure and compliance obligations after listing
Gives early investors and promoters a route to sell part of their stakeSignificant one-time costs: banker fees, legal, audit, marketing and listing expenses
Listed shares can be used to pay for acquisitions or employee stock optionsShare price becomes exposed to market sentiment, which can be volatile
Higher visibility with customers, lenders and future hiresExisting 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.

IIM SKILLS

Attend a Free 1-Hour Financial Modelling Master Class

Learn key financial modelling concepts, tools and career opportunities.

Faculty

How an IPO Works in India

A mainboard IPO in India typically follows these stages:

  1. Appoint advisers. The company hires book running lead managers (BRLMs), legal counsel and auditors.
  2. File the DRHP. The draft red herring prospectus, describing the business, risks, financials and the offer structure, is filed with SEBI for observations.
  3. 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.
  4. Anchor allocation. Anchor investors (large qualified institutional buyers) are allotted shares one working day before the issue opens.
  5. Bidding. Qualified institutional buyers, non-institutional investors and retail investors bid within the price band during the subscription window.
  6. 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

InputWhat it meansWhere to find it
Price bandThe floor and cap price at which investors can bidPrice band announcement / RHP
Pre-IPO shares outstandingShares held by promoters, investors and employees before the offerCapital structure section of the DRHP/RHP
Fresh issueNew shares (or a rupee amount) the company will issue"The Offer" section of the DRHP/RHP
Offer for saleExisting shares sold by named shareholders"The Offer" section of the DRHP/RHP
Issue expensesBRLM fees, legal, audit, listing and marketing costs"Objects of the Offer" section
Earnings and other metricsRevenue, EBITDA and profit after tax (PAT)Restated financial statements
Peer multiplesP/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

OutputFormula
Gross fresh-issue proceedsNew shares × offer price
Net proceeds to companyGross fresh-issue proceeds × (1 − issue expense %)
OFS proceeds (to sellers)OFS shares × offer price
Pre-money valuationPre-IPO shares × offer price
Post-IPO market capitalisation(Pre-IPO shares + new shares) × offer price
DilutionNew shares ÷ post-IPO shares
P/E at offer pricePost-IPO market capitalisation ÷ PAT
Discount to peers1 − (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.

ItemAt ₹235 (floor)At ₹250 (cap)
Pre-IPO shares8 crore8 crore
New shares (fresh issue)2 crore2 crore
OFS shares1 crore1 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 shares10 crore10 crore
Post-IPO market capitalisation₹2,350 crore₹2,500 crore
Dilution of existing shareholders20%20%
P/E at offer price (PAT ₹125 crore)18.8x20.0x
Discount to peer median P/E of 23x18.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.

IIM SKILLS

Not Sure Which Course Is Right for You?

Get Expert Guidance to Choose the Right Course for Your Career Goals.

Faculty

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:

ShareholderLock-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 contribution6 months; 1 year in the capital expenditure case
Pre-IPO shareholders other than promoters6 months (with conditional exemptions, for example certain employee stock option holders and qualifying VC/AIF investors)
Anchor investors30 days on 50% of their allotment; 90 days on the remaining 50%
Retail and other public investorsNo 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.

IIM SKILLS

Download IIM SKILLS Financial Modelling Brochure

Get complete course information offered by IIM SKILLS

Faculty

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.

Varun Chopra
Written by

Varun Chopra

Founder, The Algebra Group · Ex-PwC, TresVista & Moody's

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

Raj Arora, CFA
Reviewed by

Raj Arora, CFA

M&A Professional, Wodehouse Capital Advisors · FMVA

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

Tushar Bharadwaj
Reviewed by

Tushar Bharadwaj

Senior M&A & Infrastructure Investments Specialist, Cube Highways

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.

Free Download

Get Course Brochure

Detailed curriculum, placement report & fee structure.

Phone

100% Privacy Protected. No Spam Guarantee.

phone
Call
WhatsApp
We are here to help you.
phone
Call
WhatsApp
We are here to help you.