Download pre post ipo global offering stats shareholding cap table spreadsheet template sample xls
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
- Pre-money, Post-money Valuation and Calculation in a Venture Capital Investment
- Sample liquidation preference clause in a typical venture capital term sheet
- Download Sample Venture Capital Term Sheet / Letter of Intent Free
Amiable fill someone in on and this post helped me alot in my college assignement. Thank you for your information.