IPO Model

1 minutes read
Last updated: June 7, 2023

The Macabacus IPO model implements all concepts related to IPO modeling, including IPO and fully distributed valuation, gross/net proceeds, filing range, primary/secondary shares, underwriters’ discount (gross spread), overallotment option (greenshoe), and more.

Excel Template Preview

To access this free IPO Model template, <a href=”#template-access”>see the instructions</a> below the preview.

Unlock Access to Exclusive Templates

Gain instant access to our library of professionally designed templates.

  1. Start your free 30-day trial of Macabacus.
  2. In Excel, navigate to the Macabacus tab > New > Sample Models.
  3. Browse and select your desired template from our extensive library.

Start Free Trial to Access Template

Discover more topics

Build an operating model
In this tutorial, we will walk through how to build a general industry business operating model.
Read more
Build an M&A model
In this section, we demonstrate how to model a merger of two public companies in Excel.
Read more
Build an LBO model
In this tutorial, we will walk you through building an LBO model in Excel.
Read more
Asset and Stock Deals
The first step in purchase price allocation, or PPA, is to determine the purchase price.
Read more