sign in · new user? sign up
 · feedback
 

Customizable Spreadsheet Template: Capitalization Table

Available Versions

These are not rigid spreadsheet templates. You can customize them in dozens of ways to get the features you want while reducing unneeded complexity.

VersionDescription Download
Price
LightThe Light version has the same features as the Standard version, only it is smaller. It lets you try the customization process and download a customized working template for free. Free
StandardTracks common and preferred stock, convertible notes, options and warrants, for each type and series of security through multiple investment rounds. Also payouts and measures of return on investment. $169 $99
AdvancedIncludes all the features in the Standard version, plus more measures of return on investment, inclusion of founder's non-cash contributions, several investment scenarios and several valuation scenarios. Also bigger models with more series of each type of security and more investment rounds. $229 $149
Advanced Extra-LargeIncludes all the features of the Advanced version, plus a larger model with more of everything. $289 $199
* Customization and preview is always free. If applicable, you'll be asked to buy before downloading a working spreadsheet.
  We offer a money-back guarantee.

Customizable Feature Comparison

Feature Standard & Light
Version
Advanced & Extra-Large
Version
Comments
Investment rounds Check Check Investment rounds with specified dates.
Phase in investment rounds Check Check Each round has a sequence of events: splits, dividends, sale of new securities, conversion of notes and preferred shares and exercise of warrants and options.
Types of Securities
Convertible notes Check Check Initial value, interest rate, conversion price discount, liquidation preference (senior to all other securities), default conversion conditions, settable conversion decisions
Preferred stock Check Check Initial shares, price premium over common stock, dividend rate, liquidation preference, default conversion conditions, settable conversion decisions
Common stock Check Check Shares, share price, dividends, stock splits
Warrants and Options Check Check Initial price, exercise price, default exercise conditions, settable exercise decisions
Series of each type of security Check Check Many series of each type of security, each with its own terms
Conversion and exercise of securities Check Check You decide which securities to convert or exercise. The model used five criteria to make default decisions for conversion and exercise that you can override.
Detail for default conversion and exercise decisions Check Includes a detailed analysis of which securities meet which of five default conversion and exercise conditions.
Investment, Valuation, Share Units
Valuation of the firm Check Check A specified value of the firm at the start of each investment round, adjusted during each round for sale of securities and payments for exercise of warrants and options
Investment and share units Check Check Tracks value and share units of each type and series of security for each phase of each investment round.
Investment and share units by original investment vehicle Check Check Tracks value (and share units where relevant) based on original type and series of securities before conversion and exercise
Payout Check Check Tracks payout at exit to each series and type of security, including contingent liquidation preferences
Payout by original investment vehicle Check Check Tracks payout at exit by original series and type of security, including contingent liquidation preferences
Measure of Return on Investment
Return multiple Check Check Return multiple for each series of each type of security
Internal rate of return Check IRR of cash flow to each series of each type of security
Net present value Check NPV of cash flow to each series of each type of security
Founder’s non-cash contribution Check Includes optional value of non-cash contribution of founders in returns metrics
Scenarios
Firm valuation scenarios Check Settable number of scenarios for valuation of the firm at the start of each investment round.
Investment scenarios Check Settable number of investment scenarios, each with its own dates for each investment round, and sales of new securities of each type and series

Version Size Limits

Feature Standard Advanced Advanced, Extra-Large
Investment rounds 6 12 18
Series of each type of security 2 6 12
Investment Scenarios 1 5 20
Valuation Scenarios 1 5 20
 

Copyright © 2010 by ModelSheet Software LLC | All Rights Reserved | Corporate Home | Privacy

Microsoft, Excel and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.