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.
4.4 / 5 (16 votes)
Write a review
- Very good
- Great template
People using this Best Practice also downloaded
Subscription E-Commerce Fundraising Financial ModelCombining an e-commerce product sales model & a subscription model to make one subscription e-commerce fundraising model2,312add_shopping_cart$369.00by Alexander Jarvis
Enterprise SaaS and SME/Consumer Fundraising Excel ModelFor large, complex SaaS companies with enterprise, consumer and SME customers looking to fundraise.4,621add_shopping_cart$1,454.00by Alexander Jarvis
Ecommerce Financial Fundraising Excel TemplateThis is the best excel model template you will find on fundraising for your ecommerce startup3,500add_shopping_cart
Due Diligence Template Request List for Startup Fundraising from investorsDue diligence request list template for raising funds from investors for your startup2,632add_shopping_cart
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.1,592add_shopping_cart$409.00by Alexander Jarvis
Pitch Deck Template: The End of Ugly Decks for Startup FoundersThis is a pitch deck made specifically for fundraising that you both need and want.1,746add_shopping_cart$39.00by Alexander Jarvis
SaaS Financial Fundraising Excel Model TemplateThe ultimate SaaS fundraising excel model template. Incredible power, simply done.1,545add_shopping_cart
Professional Cap Table Excel TemplateLawyer level quality Excel Cap table template for investors or startup founders967add_shopping_cart$389.00by Alexander Jarvis
Fundraising Excel Model: App & Social with ViralityFor early-growing startups, this financial model is for app social fundraising.442add_shopping_cart$362.00by Alexander Jarvis
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.762add_shopping_cart
Sources and Use & Runway Excel CalculatorHelping you work out your runway and how much investment you need to raise.320add_shopping_cart
Debt Capacity Calculator Excel ModelLearn how to compute Debt Capacity761add_shopping_cart
Discussion feed for Ultimate Startup Cap Table And Return Analysis Excel Template
The user community and author are here to help. Go ahead!