In: Finance
CAP TABLES ASSIGNMENT:
Exhibits 2 and 3 are sensitivity analysis (i. higher initial investment, ii. longer time to exit)
“X” means some calculation or a number needs to be filled in that cell. Absence of “X” means no calculation/number is expected. Submit the above exhibits the way they are presented here showing all the calculations in appropriate column(s)
VC Method |
CALCULATIONS (higher initial investment) |
Deal Information |
Exit value |
$40,000,000 |
|
Time to exit |
4 |
|
Discount rate |
60.00% |
|
Investment amount |
$4,200,000 |
|
Number of existing shares |
1,000,000 |
|
Post-Money |
X |
X |
Pre-Money |
X |
X |
Ownership % of VC |
X |
X |
Ownership % of founders |
X |
X |
Number of new shares |
X |
X |
Price per share |
X |
X |
Final wealth of VC |
X |
X |
Final wealth of founders |
X |
X |
PV of VC’s wealth |
X |
|
PV of founders’ wealth |
X |
X |
VC Method |
CALCULATIONS (longer time to exit) |
Deal Information |
Exit value |
$40,000,000 |
|
Time to exit |
4.5 |
|
Discount rate |
60.00% |
|
Investment amount |
$4,000,000 |
|
Number of existing shares |
1,000,000 |
|
Post-Money |
X |
X |
Pre-Money |
X |
X |
Ownership % of VC |
X |
X |
Ownership % of founders |
X |
X |
Number of new shares |
X |
X |
Price per share |
X |
X |
Final wealth of VC |
X |
X |
Final wealth of founders |
X |
X |
PV of VC’s wealth |
X |
|
PV of founders’ wealth |
x |
X |