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  |