Above is a screenshot of a
basic template for a single investment round. Let’s break it down step by step.
Pre-Money Valuation: Enter the company’s existing value at the time of investment.
New Capital Raised: Calculate the total amount of investment raised from all investors in this round.
Post-Money Valuation: Sum up the initial company valuation with the total amount of investment raised.
Number of Shares: In the row corresponding to the initial company valuation, indicate the number of shares issued at the company’s inception and distributed among founders and team members. In the row corresponding to the amount of capital raised, calculate the number of new shares that need to be issued to investors in exchange for their capital.
Share Price: Calculate the price per share based on the initial company valuation and the number of shares.
Shareholders List: List all shareholders, including founders, investors, and employees with shares.
Share Classes: If relevant, use additional columns to categorize shares into classes: common shares, preferred shares, and options.
Founder Shares: Input the distribution of initially issued shares among founders.
Investments by Each Investor: Specify how much capital each investor has invested in the company.
Number of Investor Shares: Based on the invested capital and the share price, calculate the number of shares held by each investor.
Ownership Percentage: Calculate the ownership percentage of each shareholder based on their share count and the total number of company shares after the investment round.