1. Capitalisation table and waterfall table
In a spreadsheet, draw out and complete the template for a capitalisation table to take into account the rounds of transactions listed below:
a. Round one: Mr Murphy established a company and issued 1,000 ordinary shares to himself in return for an investment of €10,000. Mr. Murphy’s shares are to be subject to vesting over 4 years, whereby if he stays for 1 year only, he gets to keep 25% of his shareholding, 50% if 2 years, etc. If he leaves, the unvested shares are to be transferred to his replacement. In addition to the 1,000 shares, he created an employee share option pool with options over 2,500 ordinary shares.
b. Round Two: Nettle Investor invested €200,000 in Redeemable Preference Shares and €5,000 in ordinary shares at a price per share of €25. In addition, Mr Murphy was allocated share options over 5,000 ordinary shares at a strike price of €251 which are not subject to vesting
c. Round Three: Weed Investor invested €500,000 in Participating Preference Shares at a pre-money valuation of €5m. Weed also negotiated that its valuation would be reduced to the pre-money valuation of the next round, if the pre-money valuation of round four is less than round three. The reduction in valuation would be effected by giving Weed free shares at the time of round four.
d. Round Four: Foxglove Investor invested €2m in Convertible Preference Shares at a price of €1,000 per share. At the same time, Nettle converted (no new money
invested) its Redeemable Preference Shares into ordinary shares at a price of €1,000. per share.
e. Round Five: Mr. Murphy left the business three years after round one took place. He was replaced by Mr. Schmidt.
…./Over
1 This means that he will have to pay €25 per share in the future if he decides to convert the share option into
an actual share
Ordinary Shares (assuming conversion of convertible preference shares & options) |
New shares issued / created in each round |
| 1 | 2 | 3 | 4 | 5 | | |
Round | Round 1 | Round 2 | Round 3 | Round 4 | Round 5 | Total Shares | % Owned |
Mr Murphy | 1,000 | 0 | | | 0 | 1,000 | 100.0% |
[Investor 1] | | 0 | | 0 | | 0 | 0.0% |
[Investor 2] | | | 0 | | | 0 | 0.0% |
[Investor 3] | | | | 0 | | 0 | 0.0% |
[Investor x] | | | | | 0 | 0 | 0.0% |
Employee options | 0 | | | | | 0 | 0.0% |
Total this round | 1,000 | 0 | 0 | 0 | 0 | 1,000 | 100.0% |
Cum. Total | 1,000 | 1,000 | 1,000 | 1,000 | 1,000 | | |
| | | | | | | |
Total invested | | | | | | | |
Valuations | | | | | | | |
Outside capital invested in this round | | | | | | | |
% of company purchased in round | | | | | | | |
Post-money valuations | | | | | | | |
Pre money valuations | | | | | | | |
Apparent price per share | | | | | | | |
Price per share in reality | | | | | | | |
Valuation of Murphy's shareholding post the round | | | | | | | |
Also build a waterfall table that shows how the proceeds of the exit will be distributed if the company is sold for three different values – namely €5m, €10m and €30m