IPO Financial Model Template
Planning an initial public offering demands a financial model that investors, bankers and auditors can trust. This IPO Financial Model Template in Excel gives you a fully integrated, 35-tab framework that links operating forecasts, a three-statement financial model, IPO mechanics and valuation in one workbook. Built with three years of annual historicals and a five-year monthly forecast with annual roll-ups, it shows exactly how your company performs before, during and after listing, and what the offering is worth.
Further Reading
Interactive Dashboard & Webapp: This financial model still lives in a 30-tab Excel file, you already know the problem: the numbers are right, but nobody outside of finance can actually use them. This interactive dashboards and webapp solves this by turning a static, formula-heavy workbook into a living tool that anyone can use.
5-Year financial model for an Initial Public Offering (IPO)
At the core of the template is a professional IPO valuation model combining a discounted cash flow (DCF), trading comparables and precedent transactions into a single football-field summary. The model calculates primary and secondary proceeds, greenshoe exercise, underwriting fees, IPO share count, cap table, dilution, use of proceeds and a pro forma balance sheet. An LTM and NTM column sits around the IPO date, so valuation multiples are always measured on the right twelve-month window, automatically.
Every date in the workbook is driven by one start date, so re-timing your forecast or IPO date updates all 35 tabs instantly. Scenario switches (Base, Upside, Downside), offer-price cases, sensitivity grids and 35 built-in integrity checks make this IPO financial model in Excel ideal for founders, CFOs, private equity and venture capital investors, investment bankers and corporate finance advisers preparing an IPO, listing readiness review or pre-IPO funding round.
What’s Inside: Tab-by-Tab Overview
01. Cover Index
The Cover Index is your IPO model’s control centre. It sets out the model purpose, company details and IPO date, then puts every scenario switch and price case in one place. Key IPO outputs, a live model check status and clickable navigation to all 35 tabs make reviewing the financial model fast and intuitive.
- Scenario, offer price, greenshoe, mid-year and convertible switches with drop-downs
- Headline outputs: proceeds, market cap, enterprise value, fair value and IPO discount
- PASS / REVIEW model integrity status
- Hyperlinked navigation and formatting conventions legend
02. Key Assumptions
Key Assumptions is the single input sheet driving the whole IPO financial model. Change the start date or IPO date and every tab re-dates automatically. Annual inputs cover operating, cost, capex, working capital, tax, debt, equity incentive and valuation assumptions, with Base, Upside and Downside scenario drivers side by side.
- One start date drives every date, year header and month label
- Scenario drivers for volume, pricing, customers, COGS, headcount, capex and DSO
- Debt instrument, tax, SBC, WACC and terminal growth inputs
- Colour-coded inputs on pale yellow for easy editing
IPO Model Three-Statement Engine
03. Historical Financials
The Historical Financials tab holds three years of annual income statement, balance sheet and cash flow data, the foundation every IPO investor scrutinises. Subtotals, margins and historical KPIs are formula-driven, and built-in checks confirm the balance sheet balances and cash ties out before the forecast begins.
- 3-year P&L, balance sheet and cash flow
- Revenue split across products, services, subscriptions and licensing
- Historical KPIs: growth, margins, capex intensity, working capital and free cash flow
- Balance sheet and cash tie-out checks
04. Operating Model
The Operating Model translates business drivers into financial performance. It tracks customer acquisition and churn, volumes, pricing, revenue quality and unit economics month by month. Investors evaluating an IPO look closely at these KPIs, and this tab presents them clearly on monthly, annual, LTM and NTM bases.
- Customer roll-forward with retention and churn rates
- CAC, lifetime value, LTV/CAC and payback period
- Volume, capacity utilisation and price/mix walk
- Recurring revenue, net and gross revenue retention
05. Revenue Build
The Revenue Build creates a detailed, driver-based revenue forecast. Product revenue is built from units multiplied by average selling price with seasonality, while subscriptions run from a full ARR roll-forward. Revenue is analysed by service line, segment, geography and customer type, with deferred revenue, contract assets and RPO tracked.
- Units x ASP for three product lines with monthly seasonality
- ARR bridge: new, expansion, contraction, churn and FX
- Revenue recognition, deferred revenue, contract assets and RPO
- Segment, geographic and customer-type revenue mix
06. Cost Build
The Cost Build forecasts every cost line behind gross profit and EBITDA. Inventory and COGS, direct operating costs and a function-by-function headcount and payroll model feed R&D, sales and marketing, and G&A. Public company costs switch on automatically from the IPO month, giving a realistic post-listing cost base.
- Inventory roll-forward and COGS breakdown
- Headcount by function with salary inflation and on-costs
- Capitalised R&D, commissions, marketing and G&A build
- Public company costs triggered at IPO
07. P&L
The P&L presents a full income statement from revenue to earnings per share. EBITDA is shown before and after stock-based compensation, a key IPO disclosure. IPO transaction costs not deducted from equity are expensed in the IPO month, and basic and diluted EPS flow directly from the share schedules.
- Revenue to net income with margins and growth rates
- EBITDA pre- and post-SBC
- Interest, lease interest, associates and IPO costs
- Basic and diluted EPS and weighted average shares
08. Balance Sheet
The Balance Sheet links every balance to its supporting schedule, so the IPO model is fully integrated and auditable. A balance check runs in every month and year. Liquidity and leverage ratios, including net debt to EBITDA and current ratio, show how the IPO transforms the company’s capital structure.
- Fully linked assets, liabilities and equity
- Monthly balance check that must read OK
- Preference capital, APIC, treasury shares and NCI
- Liquidity, leverage and equity ratios
09. Cash Flow
The Cash Flow statement uses the indirect method to reconcile profit to cash across operating, investing and financing activities. IPO primary proceeds, transaction costs, debt repayments and option exercise proceeds land in the IPO month. Free cash flow, cash conversion, burn rate and cash runway metrics are included.
- Indirect cash flow tied to balance sheet movements
- IPO proceeds and equity transaction costs in financing
- Minimum cash and funding shortfall tracking
- Free cash flow, conversion ratio and runway
10. Working Capital
The Working Capital schedule forecasts receivables, inventory, payables, accruals, deferred revenue and contract assets using days-based assumptions. Each balance has a full roll-forward, and net operating working capital reconciles to the cash flow statement, giving investors confidence in cash generation forecasts.
- AR, inventory and AP roll-forwards with DSO, DIO and DPO
- Deferred revenue and contract asset schedules
- Net operating working capital and working capital days
- Reconciliation check to the cash flow
11. Capex & Depreciation
The Capex & Depreciation tab builds maintenance, growth, technology and infrastructure capex as a percentage of revenue. It tracks gross PP&E, accumulated depreciation, intangible assets, capitalised development and amortisation, plus IFRS 16 right-of-use assets and lease liabilities, all feeding the three financial statements.
- Capex build by category, including capitalised development
- Existing and new asset depreciation
- Intangibles and amortisation schedules
- Right-of-use assets and lease liability workings
IPO Share Count & Proceeds
12. Debt Schedule
The Debt Schedule models eight instruments, from revolving credit facility and term loans to notes, convertibles and shareholder loans. A revolver cash sweep protects minimum cash, IPO proceeds repay selected debt, and convertibles convert to equity at listing. Interest, covenants and debt reconciliation are calculated without circular references.
- RCF, Term Loan A and B, notes, convertibles, shareholder loans
- IPO debt repayment and convertible conversion
- Interest, commitment fees and fee amortisation
- Leverage, interest coverage and covenant compliance tests
13. Tax Schedule
The Tax Schedule calculates taxable profit, tax loss carryforwards, current tax, deferred tax and cash taxes each month. It handles non-deductible stock-based compensation, IPO costs, accelerated tax depreciation and R&D credits, producing a realistic effective tax rate and cash tax profile for IPO investors.
- Taxable profit with permanent and timing differences
- NOL utilisation with cap and expiry
- Deferred tax assets and liabilities
- Quarterly cash tax payments and cash tax rate
14. Share Capital
The Share Capital tab tracks ordinary and preference shares, share premium, retained earnings and reserves through the IPO. Primary issuance, preference conversion, convertible conversion, option exercises and RSU vesting all hit in the IPO month, and an IPO equity bridge reconciles pre-IPO to post-IPO share capital.
- Ordinary and preference share roll-forwards
- Share premium net of equity transaction costs
- Retained earnings, dividends, treasury shares and NCI
- IPO equity bridge in shares
15. Stock-Based Compensation
The Stock-Based Compensation schedule models share options, RSUs and PSUs, including grants, exercises, vesting, forfeitures and expiry. SBC expense is recognised from unrecognised compensation pools, and a treasury stock method dilution analysis produces the fully diluted share count that drives IPO valuation per share.
- Option, RSU and PSU roll-forwards
- SBC expense and unrecognised compensation cost
- Treasury stock method dilution
- Fully diluted share count every month
16. IPO Assumptions
IPO Assumptions holds every offering input: timing, offering structure, price range, capital structure and IPO costs. Offering size is set as a percentage of post-IPO shares, and the model solves for primary and secondary shares automatically. Low, midpoint and high offer prices are selectable from the Cover.
- IPO, pricing, settlement and greenshoe dates
- Primary/secondary split and offering size
- Low, mid and high offer price range
- Underwriting, legal, audit and listing cost inputs
17. IPO Share Count
The IPO Share Count tab builds the post-IPO share count step by step, from pre-IPO ordinary shares through preference conversion, convertible conversion, equity incentives, primary issuance and greenshoe. A reconciliation check confirms the share count agrees with the cap table and share capital schedule.
- Pre-IPO shares by holder group
- Preference and convertible conversion shares
- Primary, secondary and greenshoe shares
- Basic and fully diluted post-IPO share count
18. IPO Proceeds
IPO Proceeds calculates gross and net proceeds for the primary offering, secondary offering and greenshoe. Offering costs are itemised, and transaction costs are allocated between equity and the P&L in line with IAS 32 principles, so the accounting treatment of your IPO is transparent and fully reconciled.
- Primary, secondary and greenshoe gross proceeds
- Underwriting discounts and offering costs
- Net proceeds to company and selling shareholders
- Equity versus P&L cost allocation
19. IPO Cap Table
The IPO Cap Table shows ownership before and after the offering for founders, management, employees, venture capital, private equity, strategic and public investors. Secondary sales are allocated pro rata using holder sell weights, and float analysis tests compliance with minimum public shareholding requirements.
- Pre-IPO and post-IPO ownership by holder
- Secondary shares sold by each investor group
- Public float, insider and institutional ownership
- Pre-money and post-money equity value
20. Dilution Analysis
Dilution Analysis quantifies exactly how the IPO dilutes existing shareholders. It moves from basic to fully diluted shares using the treasury stock method, then measures dilution from primary issuance, preference conversion and equity incentives, with before-and-after ownership for founders, management and investors.
- Basic to fully diluted share bridge
- Treasury stock method for options
- Ownership dilution by source
- Founder, management and investor dilution percentages
21. Use of Proceeds
Use of Proceeds shows how IPO cash will be deployed across debt reduction, growth investment, working capital, corporate purposes and reserves. Debt repayment percentages flow into the debt schedule, and an allocation check ensures net proceeds are fully allocated without over-committing capital.
- Sources: net primary proceeds and existing cash
- Debt reduction by instrument
- Growth, working capital and corporate allocations
- Allocation check and percentage breakdown
22. Pro Forma Balance Sheet
The Pro Forma Balance Sheet takes the pre-IPO balance sheet and applies every IPO adjustment: proceeds, underwriting and expenses, debt repayment, preference and convertible conversion, and option exercises. The result is a balanced post-IPO balance sheet, a core requirement for prospectus and investor presentations.
- Pre-IPO balance sheet at the LTM date
- Itemised IPO adjustments
- Pro forma assets, liabilities and equity
- Pro forma balance check and net debt
IPO Model Underwriting & Valuation
23. IPO Valuation
The IPO Valuation tab calculates equity value, market capitalisation and enterprise value at the selected offer price. It presents LTM and NTM revenue, EBITDA, EBIT, net income and free cash flow, then derives valuation multiples, price range sensitivities and an IPO discount analysis versus peer and DCF valuations.
- Pre-money, post-money and enterprise value
- LTM and NTM financial metrics
- EV/Revenue, EV/EBITDA, P/E, P/B and FCF yield
- Discount to peer and DCF valuation
24. Underwriting Fees
The Underwriting Fees schedule is the master record of IPO costs. It covers the syndicate structure, gross spread on primary, secondary and greenshoe shares, professional adviser fees, regulatory and listing fees, and transaction expenses, with fees per share and an accounting reconciliation.
- Primary, secondary and greenshoe underwriting discounts
- Legal, accounting, tax and adviser fees
- Listing, registration and transfer agent costs
- Total fees as % of gross proceeds and per share
25. Trading Comparables
Trading Comparables benchmarks your company against a peer group of listed companies. It captures market data, LTM and NTM financials and capital structure, calculates trading multiples, and summarises them statistically to derive an implied enterprise value, equity value and share price for the IPO.
- Peer market cap and enterprise value
- LTM and NTM operating metrics
- EV/Revenue, EV/EBITDA, EV/EBIT and P/E multiples
- Min, median, mean, max and quartile statistics
26. Precedent Transactions
Precedent Transactions values the business against comparable M&A deals. Deal value, consideration mix, target financials, transaction multiples and characteristics such as control premium and synergies are recorded, then median multiples produce an implied valuation that captures what acquirers have historically paid.
- Transaction value and consideration structure
- Target revenue, EBITDA and EBIT metrics
- EV/Revenue and EV/EBITDA deal multiples
- Implied enterprise value, equity value and share price
27. DCF
The DCF tab values the business on unlevered free cash flow discounted at WACC from the IPO date. Beta is unlevered and relevered, cash flows are pro-rated after the valuation date with an optional mid-year convention, and terminal value uses perpetual growth. Sensitivity grids flex WACC and growth.
- Unlevered free cash flow build
- WACC with relevered beta and size premium
- Terminal value and equity value bridge
- WACC x terminal growth sensitivity grids
28. IPO Valuation Summary
The IPO Valuation Summary brings DCF, trading comparables and precedent transactions together in a football-field view. It calculates a weighted fair value per share, compares it with the IPO offer price and shows the IPO discount, implied upside, valuation ranges and multiples at the offer price.
- DCF, comps and precedents side by side
- Valuation ranges for each method
- Weighted fair value per share
- IPO discount and implied upside
29. IPO Price Sensitivity
IPO Price Sensitivity shows how low, midpoint and high offer prices change market capitalisation, enterprise value, multiples, proceeds and investor upside. Two-way grids flex offer price, NTM revenue and EBITDA multiples, helping you set a price range that balances company proceeds with investor demand.
- Low, mid and high price comparison
- Market cap, EV and multiples at each price
- Gross and net primary proceeds sensitivity
- Two-way price and multiple sensitivity grids
30. Investor Returns
Investor Returns models the outcome for an investor buying at the IPO offer price and exiting at the end of the forecast. Exit share prices across bear, downside, base, upside and bull cases produce total returns, annualised returns, CAGR, dividends and ownership value creation.
- IPO investment and transaction costs
- Exit valuation at scenario EV/EBITDA multiples
- Total, annualised and scenario returns
- Holding period and ownership dilution analysis
31. EPS & Share Metrics
EPS & Share Metrics calculates basic and diluted earnings per share with a full EPS reconciliation showing the dilutive effect of options, RSUs and convertibles. Per-share metrics, market valuation ratios and shareholder returns, including dividend yield and total shareholder return, are tracked monthly and annually.
- Weighted average basic and diluted shares
- Basic and diluted EPS reconciliation
- Revenue, EBITDA, FCF and book value per share
- P/E, EV/EBITDA, dividend yield and TSR
32. Scenario Analysis
Scenario Analysis displays Base, Upside and Downside cases side by side. Revenue, EBITDA, net income, free cash flow, cash and net debt are flexed by scenario, then translated into enterprise value, share price, IPO price and investor returns, with probability-weighted outputs for a balanced view.
- Base, Upside and Downside drivers compared
- Financial outputs by scenario for five years
- Valuation and IPO outcomes by scenario
- Probability-weighted revenue, EBITDA and share price
33. Sensitivity Analysis
Sensitivity Analysis stress-tests the IPO model across revenue, margins, cash flow, valuation, IPO pricing and debt. One-way tables show low and high outcomes for each driver, while two-way grids flex EBITDA, free cash flow, multiples, proceeds and interest rates to reveal the key value drivers.
- Revenue, margin and cash flow sensitivities
- Multiple-based share price sensitivities
- Net proceeds and market cap sensitivity grids
- Interest rate, leverage and coverage stress tests
34. KPI Dashboard
The KPI Dashboard presents every headline metric on one page using the shared monthly calendar. Revenue, profitability, customer, commercial, operational, cash flow and capital structure KPIs sit alongside point-in-time IPO, valuation and investor KPIs, ideal for board packs and investor updates.
- Revenue, ARR and recurring revenue KPIs
- Margins, free cash flow and cash conversion
- Customer, unit economics and headcount KPIs
- IPO, valuation and investor return KPIs
35. Checks
The Checks tab gives assurance that the IPO financial model is working correctly. Balance sheet, cash flow, debt, working capital, share count, IPO proceeds, cap table and input integrity checks roll up to a single PASS or REVIEW flag shown on the Cover, with business flags shown separately.
- Monthly balance sheet and cash tie-out checks
- Debt, working capital and share count reconciliations
- IPO proceeds, fees, pro forma and allocation checks
- Overall PASS/REVIEW status linked to the Cover
Why Buy This Model
Building an IPO financial model from scratch can take weeks of specialist time, and a single broken link can undermine investor confidence. This template gives you a complete, integrated and fully checked IPO model ready to adapt to your business. Every forecast line flows through the three statements, every IPO entry is reconciled, and 35 integrity checks confirm the model balances in every month. With one-click re-dating, scenario and price switches, DCF, comps and precedent valuation, cap table, dilution and pro forma balance sheet all in one workbook, you can focus on your equity story instead of spreadsheet mechanics. It’s built in Excel with transparent formulas, colour-coded inputs and no macros, so you, your advisers and your auditors can follow every number.
IPO Listing Model Frequently Asked Questions
What type of company is this IPO model suitable for?
The model suits growth companies preparing for an IPO, particularly those with a mix of product, services and subscription revenue. Revenue lines can be renamed and drivers adjusted, so it adapts well to technology, SaaS, hardware, industrial and consumer businesses. Lines you don’t need can simply be set to zero.
Do I need advanced Excel skills to use it?
No. Inputs are clearly marked in blue on a yellow background, and most are on 02. Key Assumptions and 16. IPO Assumptions. The Cover has drop-down switches and hyperlinked navigation. A working knowledge of financial statements helps, but you don’t need to edit any formulas.
Can I change the start date and IPO date?
Yes. Change the Model Start Date on 02. Key Assumptions and every date, year header and month label across all 35 tabs updates automatically. Change the IPO date and the LTM and NTM columns, IPO-month entries and valuation date all move with it.
How many years does the model cover?
It includes three years of annual historical financials and a five-year forecast built monthly, with an annual total column after each year. LTM and NTM columns around the IPO date give the twelve-month windows investors and bankers use for valuation.
Does the model include a full three-statement financial model?
Yes. The P&L, balance sheet and cash flow statement are fully integrated, supported by schedules for revenue, costs, working capital, capex, debt, tax, share capital and stock-based compensation. A balance check runs in every month and year.
Which valuation methods are included?
Three: a discounted cash flow (DCF) valued from the IPO date, trading comparables and precedent transactions. The IPO Valuation Summary combines them into a weighted fair value per share and shows the IPO discount or premium at your chosen offer price.
Does it calculate IPO proceeds, fees and dilution?
Yes. It calculates primary, secondary and greenshoe proceeds, itemised underwriting and adviser fees, the split of costs between equity and the P&L, the post-IPO share count, cap table, dilution by holder, use of proceeds and a pro forma balance sheet.
Can I model different scenarios?
Yes. Switch between Base, Upside and Downside on the Cover to re-run the whole model. The Scenario Analysis tab also shows all three side by side with probability-weighted outputs, and the Sensitivity Analysis tab stress-tests key drivers.
Is the model’s data real?
No. The template comes pre-filled with illustrative company, peer and transaction data so you can see how every calculation works. Replace the blue input cells with your own historicals, assumptions and sourced market data before using it for real decisions or investor materials.
Does the model contain macros or circular references?
No. It uses standard Excel formulas only, with no macros or VBA. Interest is calculated on opening balances, so there are no circular references and the model recalculates quickly and reliably.
Will it work in Google Sheets or older versions of Excel?
It’s designed for Microsoft Excel and uses widely supported functions, so it works in Excel 2010 and later, including Excel for Mac and Microsoft 365. It can be opened in Google Sheets, though some formatting may display differently.
How do I know the model is working correctly?
The Checks tab runs balance sheet, cash, debt, working capital, share count and IPO reconciliations every period and rolls them up to a single PASS or REVIEW flag on the Cover. If any input breaks the logic, the flag tells you straight away.
Can I use this model for a pre-IPO funding round or listing readiness review?
Yes. The integrated forecast, valuation and cap table make it useful for pre-IPO fundraising, board planning, listing readiness assessments and discussions with banks, auditors and investors, not just the IPO itself.
Value Your initial public offering (IPO) With A DCF
A full discounted cash flow build over the FY2026–FY2031 forecast horizon: unlevered free
cash flow (post-tax EBIT plus D&A, less capex and the change in net working capital),
discounted at the WACC using mid-year convention, with a Gordon growth terminal value
appended at the end of the explicit forecast period. The tab concludes with implied
enterprise value, equity value, and value per share.investment support.
Further Reading
Merger & Acquisitions Model: Download a professional M&A financial model. Dynamic valuation, accretion/dilution analysis, synergies, and debt schedules.
- LBO Model: Ready to master corporate finance? Download our proven, step-by-step LBO financial model template to analyze leveraged buyouts, project debt paydown, and forecast returns like a seasoned private equity professional.
