Venture Fund Economics
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
ABCDEFGHIJKLMNOPQRSTUVWXY
1
Venture Fund Economics Modeling Tool
2
3
4
Fund Size, Fees and ResultsNotes: This Venture Fund Economics Modeling Tool is designed to help you understand compensation for a venture fund's General Partners. The overall structure of the worksheet is quite simple. If you are interested in editing or enhancing this Google Sheet, please select "Make a Copy" under the "File" menu.

There are two main areas where you supply information into this worksheet: 1) Fund Size, Fees and Results and 2) Payments to Partners and Fund Operations. Based on your inputs, Total Compensation for the different partners is calculated. Please note that you can add data into any cell that is filled in yellow. All grey cells should not be changed as they contain formulas.

Sections for User Input:

Fund Size, Fees and Results: There are 4 variables to supply in this section. First, you need to enter the Fund Size. This represents the total amount of capital committed to the fund by the Limited Partners and the General Partners.. Next, the Management Fee is the annual fee paid out to run the fund. This fee is paid as a percentage of the total fund size. In this spreadsheet the full management fee is paid out in the first 5 years. For the second 5 years of the fund, 1/2 of the management fee is paid out. So, for example, for a $50M fund with a 2% management fee, a management fee of $1M will be paid in each of the first five years. During the next 5 year period, $500K will be paid. Next, Carry is the percentage of the fund's profits that are paid out to the General Partners. And finally, the Distributed to Paid-In (DPI) Capital Ratio is the total amount of capital returned to investors divided by the total amount of capital invested in the fund.

Payments to Partners and Fund Operations: There are two variables you need to provide in this section. The first is the Management Fee Allocation. For the General Partners, Venture Partners and Fund Operations, you should allocate a percentage of the annual management fee. Think of this allocation as you would allocate expenses in a business. The Carry Percentage Allocation is where most of the compensation for a venture fund will come from for the General Partners. In most cases a fund will allocate the majority of the payout to the GPs and reserve a smaller amount for any venture partners and some of the fund's staff.




5
6
7
Fund Size$50,000,000
Total Capital Invested
$42,500,000
8
Management Fee2%
Management Fee Payout
$7,500,000
9
Carry20%Carry Payout$15,000,000
10
Distributed to Paid-In (DPI) Capital Ratio
2.50
Multiple on Capital Invested
2.94
11
12
13
Payments to Partners and Fund Operations
14
15
Managment Fee AllocationManagement FeeCarry Percentage AllocationCarryTotal Compensation
16
General Partner 120%$1,500,00045%$6,750,000$8,250,000
17
General Partner 220%$1,500,00045%$6,750,000$8,250,000
18
Venture Partner10%$750,0008%$1,200,000$1,950,000
19
Fund Operations Team & Expenses50%$3,750,0002%$300,000$4,050,000
20
21
Totals100%$7,500,000100%$15,000,000$22,500,000
22
23
24
25
If you like this Venture Fund Economics Tool, please share the following link: http://bit.ly/Venture_Fund_Economics
26
27
Yellow Cells are user input cells
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...