Last version published: 03/04/2018 12:45
Publication number: ELQ-88272-5
View all versions & Certificate
Ultimate Startup Cap Table and Return Analysis Excel Template
Sample cap table excel template with exclusive waterfall return analysis.
Acquire business license for $9.00
Add to cart
Add to bookmarks
This cap table will enable you to:
Understand the ownership structure of your organization and how it evolves with multiple financing rounds, as well as allowing you to play with all the assumptions to support how you structure your next financing round.
The following spreadsheet has most of what you would come across with investors. It covers the following:
• Initial founder table
• Angel investment (Both as convertible debt which converts at Seed stage and straight priced round)
• Seed investment (Assuming 1x strategy preferred liquidation preference)
• Series A, B and C (Again structured as the Seed investment)
Additionally to the cap table, there is a waterfall return analysis where you can calculate exactly how much people can earn, and at the different exit valuation scenarios. I haven’t seen anyone do this before, so I find that quite cool.
Though my template doesn’t do some things.
As you may know, sometimes things get complicated so my table cannot address every possible scenario. Assuming that you are dealing with reputable investors, you won't really have to change this (For example, account for multiple liquidation preferences and participating in preferred shares)
I do not assume that you aim to:
• Get funded with warrants
• Assume there is a vesting schedule on shares
(Though there is a switch to remove unissued shares from the ESOP pool)
• Have debt and interest that converts to shares
• Have multiple liquidation preferences
• Participating preferred shares
• Different terms for investors at each stage of funding
I am aware that some things could be added to the model, such as calculating effective calculations (Adjusted for ESOP issuance etc.) which are only FYI. Maybe that will be incorporated in the future.
- Very good
- Great template
People using this tool also downloaded
Enterprise SaaS and SME/Consumer Fundraising Excel ModelFor large, complex SaaS companies with enterprise, consumer and SME customers looking to fundraise.724 remove_red_eye$400.00by Alexander Jarvis
Ecommerce Financial Fundraising Excel templateThis is the best excel model template you will find on fundraising for your ecommerce startup714 remove_red_eye$189.00by Alexander Jarvis
Due Diligence Template Request List for Startup Fundraising from investorsDue diligence request list template for raising funds from investors for your startup326 remove_red_eye
SaaS Financial Fundraising Excel Model TemplateThe ultimate SaaS fundraising excel model template. Incredible power, simply done.870 remove_red_eye
Simple LBO Template Excel Model (Leveraged Buyout)This LBO excel model will help you to view the possible opportunity when potentially acquiring a company with debt.236 remove_red_eye
ESOP Plan Excel Template and Step by Step Guide to Retain and Attract Top StaffESOP plan done in excel to help your business recruit and keep the best employees.267 remove_red_eye$149.00by Alexander Jarvis
The ESOP (Employee Share Ownership Plan) dilution Excel modelHow startup dilution works for founders with ESOPs and investment.230 remove_red_eye
Professional Cap Table TemplateLawyer level quality Excel Cap table template for investors or startup founders263 remove_red_eye$179.00by Alexander Jarvis
Subscription E-Commerce Fundraising Financial ModelCombining an e-commerce product sales model & a subscription model to make one subscription e-commerce fundraising model128 remove_red_eye
VWAP Template Calculator Excel Model (Volume Weighted Average Price)Simple, ready-to-use VWAP template calculator.844 remove_red_eye
Debt Capacity Calculator Excel ModelLearn how to compute Debt Capacity193 remove_red_eye
Board Deck Template for Seed Stage StartupsBoard Deck Template and some advice for those all important board meetings!151 remove_red_eye
Discussion feed for Ultimate Startup Cap Table And Return Analysis Excel Template
The user community and author are here to help. Go ahead!