# SPAC Model Build a SPAC model for the full lifecycle from IPO to de-SPAC. Handle sponsor promote mechanics, PIPE funding, redemption sensitivities, and pro-forma ownership waterfalls with institutional precision. - Canonical: https://finamodel.com/templates/spac-model - Excel download: https://finamodel.com/templates/spac.xlsx - Category: Capital Markets - Model type: Sector planning - Difficulty: Advanced - Audiences: Investors & analysts, Bankers & advisors, SPAC sponsors, Target company advisors, Public equity investors, M&A professionals - Tags: merger, sponsor, redemption, cap-table ## Overview Model SPAC merger economics to see true sponsor ownership, dilution from redemptions, and pro forma capital structure without optimistic redemption assumptions. The model calculates trust account cash (IPO shares × $10, earning 4-5% T-bill yield, taxed at 21%), applies realistic redemption rates (60-90% post-2022), and sizes PIPE funding and sponsor cash to fund target acquisitions. Sources & Uses shows exactly how much cash lands on the target's balance sheet - a non-tautological capital adequacy check. Share structure bridges IPO → de-SPAC → diluted (accounting for sponsor promote, PIPE shares, target rollover equity, warrants, and earnouts). Goodwill is computed from the target's tangible net assets (AR, PP&E, AP explicitly), not a disconnected plug. Returns analysis is granular: sponsor return (return on warrant + founder share investment), public return (dilution-adjusted - public owns a declining % as sponsor/PIPE/rollover dilute), and PIPE return (entry price basis). Pro forma balance sheet must balance; Checks sheet validates funding adequacy and covenant compliance. Critical for deal teams evaluating de-SPAC targets, showing the economic reality (high redemption rates, sponsor dilution) vs marketing narratives. Includes sensitivity on redemption rate, exit multiple, and holding period. ## What's included - IPO unit and warrant allocation logic - Trust account interest and monthly operating expense tracking - Sponsor promote and private placement warrant schedules - De-SPAC transaction bridge and redemption sensitivity analysis - PIPE financing and pro-forma capitalisation waterfall - SPAC trust account size and sponsor commitment - Sponsor share economics (promote, earn-out vesting) - Redemption assumptions and PIPE funding mechanics - Pro forma capitalization and share count - Ownership waterfall by shareholder type - Dilution analysis and cash available for target ## SPAC Model: How the Full Lifecycle Works from IPO to de-SPAC This SPAC model template is a transaction tool for evaluating a de-SPAC business combination. It helps deal teams answer three key questions: capital adequacy, post-combination cap table, and investor returns. The model runs from IPO trust funding through redemption, PIPE, and sponsor economics to an exit-year-driven returns analysis, all underpinned by a 7-year forecast and balancing pro forma balance sheet. ### How Scenarios and Operating Drivers Shape the Analysis The model is scenario-driven. A scenarios sheet lets you switch between low, base, and high redemption cases using a CHOOSE function that flexes five drivers: redemption rate, PIPE shares, PIPE price, sponsor forfeiture percentage, and exit multiple. - Each scenario also carries a probability weight, so you can see how different deal outcomes affect the result. These drivers feed every downstream calculation, from trust cash to sponsor share count, without nested IF formulas. - The 7-year forecast includes a simple P&L, a PP&E roll, and working capital based on AR, inventory, and AP days. This operating detail feeds the exit EBITDA used in returns, while debt amortises separately. Together, these drivers let you test how redemption pressure, PIPE pricing, and sponsor forfeiture interact under a chosen scenario. ### Calculation Flow: From Trust to Cap Table The calculation flow starts with trust mechanics. IPO proceeds earn interest net of tax, which raises the redemption price. - Redemptions reduce trust cash, and a deferred underwriting waiver can further adjust it. The resulting trust cash available, plus PIPE proceeds and sponsor at-risk capital, forms total sources. - Uses include target cash consideration—enterprise value less net debt and rollover value—and transaction costs. The residual is cash to the balance sheet. - Meanwhile, the share structure builds from non-redeeming shares, sponsor founder shares adjusted for forfeiture, PIPE shares, and rollover shares. Warrants are treated with the treasury stock method and earnout shares are added only if the exit price clears specified triggers. This produces pro forma basic and diluted share counts, which then feed exit price per share and returns. ### Outputs: Returns, Balance Sheet, and Sensitivity Views The model outputs three main views. First, returns analysis: sponsor MOIC and IRR (driven by an exit year from 1 to 7 and an exit multiple), public shareholder return, and PIPE return. - Exit EBITDA and net debt are pulled from the forecast and debt schedule by the chosen exit year. Second, the pro forma balance sheet balances by construction because public equity is booked at trust cash available, sponsor equity at at-risk capital, PIPE at proceeds, rollover at value, and retained earnings at negative transaction costs—goodwill is calculated, not plugged. - Third, two sensitivity grids show public return against redemption and exit multiple, and cash to balance sheet against redemption and PIPE size. Conditional formatting highlights outputs, giving a quick read on how key variables influence outcomes. ### Practical Use: Evaluating a SPAC Deal For a deal team, this model serves as a transaction evaluation tool. The trio of capital adequacy, cap table, and returns questions guides the analysis: you can see if enough cash lands on the target's balance sheet after redemptions and costs, what ownership looks like across public, sponsor, PIPE, and rollover holders, and what sponsor, public, and PIPE investors earn at exit. - The model includes 20 tie-out checks on a dedicated sheet to validate balance sheet integrity, ownership sums, and scenario consistency. The public download is a values-only preview; the underlying template captures the full calculation logic. - The design is intentionally a transaction model, not an operating model—the 7-year forecast exists to feed the exit-year-driven returns analysis. Use it to structure and stress-test a de-SPAC deal. ## Built for blank cheque company analysis Use this model when sponsor promote dilution, trust redemption risk, and PIPE financing terms are central to the transaction economics. ## Covers the full SPAC lifecycle A proper SPAC model tracks the progression from IPO proceeds through trust account management to de-SPAC closing and pro-forma ownership outcomes. ## Useful for sponsors, investors, and targets Evaluate potential acquisitions, assess PIPE investment cases, or help management teams understand the technical impact of a SPAC merger on ownership. ## Built for blank cheque company analysis Use this model when sponsor promote dilution, trust redemption risk, and PIPE financing terms are central to the transaction economics. ## Covers the full SPAC lifecycle A proper SPAC model tracks the progression from IPO proceeds through trust account management to de-SPAC closing and pro-forma ownership outcomes. ## Useful for sponsors, investors, and targets Evaluate potential acquisitions, assess PIPE investment cases, or help management teams understand the technical impact of a SPAC merger on ownership. ## Features - **Redemption sensitivity:** Model redemptions from 10% to 90% of public shareholders and show pro forma cash remaining for target operations and debt service. - **Sponsor alignment and dilution:** Track sponsor promotes, PIPE discounts, and public shareholder dilution to see incentive alignment and true capital available. - **Capitalization structure:** Build full cap table showing SPAC equity, sponsor equity, PIPE commitments, and debt post-close. ## Use cases - **SPAC target evaluation:** Analyze SPAC offer against alternative financing (IPO, traditional M&A) by modeling cash proceeds, ownership, and cost of capital. - **SPAC investor due diligence:** Evaluate SPAC IPO investment by modeling redemption scenarios, sponsor alignment, and pro forma target valuation. - **Sponsor return analysis:** Model sponsor returns under different exit scenarios and redemption levels to validate deal thesis. ## Frequently asked questions ### What is a SPAC financial model? It is a model that covers the economics of a special purpose acquisition company, from IPO proceeds and trust management through to de-SPAC transaction mechanics and pro-forma ownership. ### Who uses SPAC models? SPAC sponsors, investment bankers, PIPE investors, and target company CFOs use them for deal structuring and due diligence. ### What should a SPAC model include? It should include IPO unit economics, trust account tracking, sponsor promote and warrant schedules, redemption sensitivity, and pro-forma capitalisation after closing. ### How does it handle shareholder redemptions? The model includes a redemption sensitivity toggle showing how different levels of trust cash-out affect pro-forma cash, ownership dilution, and minimum cash closing conditions. ### Does it model warrant dilution? Yes. The model includes a detailed warrant schedule for both public and private placement warrants, calculating dilutive impact at various share price levels. ## Related templates - [IPO Pricing and Waterfall Model](https://finamodel.com/templates/ipo-pricing-model) - [M&A Modeling & Valuation](https://finamodel.com/templates/ma-model) - [Leveraged Buyout Model](https://finamodel.com/templates/lbo-model)