Download pre post ipo global offering stats shareholding cap table spreadsheet template sample xls
Andy Lau has substantial experience representing pe/vc funds, investment banks and startup and growth companies in pe/vc investments, M&A, IPO and capital markets transactions. For a preliminary consultation, please email him at andy@askventure.com.
This is a spreadsheet used by a major investment bank and law firms showing the IPO offering stats of a company contemplating IPO in a real-live IPO deal (with sensitive and confidential information removed).
It is divided into three parts:
1. Offering stats at IPO (market cap, forecast earning, pe ratio, offer price, IPO proceeds, capitalization issue, etc.)
2. Pre-IPO structure (founders, pre-ipo investors, venture capitalists, etc.)
3. Post-IPO structure (public and non-public float, etc.)
I have added annotations for educational purposes.
It is a template that you can plug in your own variables.
Excel format (.xls)
If you have any questions or commnets, or if you would like this spreadsheet in excel .xls format, please feel free to contact Andy Lau at andy@askventure.com.
Related posts:
- Download Sample Share Cap Table Template of a Venture Capital Term Sheet
- Download Sample Venture Capital Term Sheet / Letter of Intent Free
- Sample liquidation preference clause in a typical venture capital term sheet
- Listing by introduction vs IPO global offering on the Hong Kong Stock Exchange (HKSE)
Loading ...
well written blog. Im glad that I could find more info on this. thanks
Amiable fill someone in on and this post helped me alot in my college assignement. Thank you for your information.