This template performs cap table math. The ideas are lifted from Brad Feld's and Jason Mendelson's book, [http://www.amazon.com/Venture-Deals-Smarter-Lawyer-Capitalist/dp/1118443616/ref=la_B0043MYSL8_1_1?ie=UTF8&qid=1370195339&sr=1-1|Venture Deals: Be Smarter Than Your Lawyer and Venture Capitalist] (chapter 7).

Investment = 5000000

Pre-Money Valuation = 10000000

Post-Money Valuation = 15000000

Investor Ownership Percentage = 33.333333333333329

Founders Shares = 2000000

Venture Shares = 1000000

Employee Pool Percentage = 20

Employee Pool = 400000

Total Shares = 3400000

Founders Ownership Percentage = 46.666666666700003

Price Per Share = 5

Investment

Pre-Money Valuation

Post-Money Valuation

Investor Ownership Percentage

Founders Shares

Venture Shares

Employee Pool Percentage

Employee Pool

Total Shares

Founders Ownership Percentage

Price Per Share

-------------