Portfolio Modeling Tool
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

ABCDEFGHIJKLMNOPQRSTUVWX
1
Portfolio Modeling Tool
2
3
4
Investment PortfolioNotes: This Portfolio Modeling Tool is designed to help you understand how an early stage investment portfolio might perform. 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) Total Investment in each company and 2) Type of Exit for each company. Based on your inputs, your return for each company is calculated along with the return for your entire portfolio. 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:

Company Name and Total Investment: We created a portfolio of 15 companies (i.e. Investment 1, Investment 2, etc.). For each company, we put in an amount of investment that ranges from \$15,000 to \$50,000. Feel free to put in your own company names and investment amounts for each company.

Type of Exit: In a typical early stage investment portfolio, you will have a mix of wins and losses. In this column, you should select the expected exit for each company. Since this Google Sheet is designed to model simple portfolios, you will want to experiment with a variety of exit scenarios throughout the portfolio.

Exit Multiple: For each type of exit, we have indicated what we believe to be a reasonable exit multiple. If your experience as an investor is different or you want to model other types of exit scenarios, you can change these exit multiples as you like.

As you model different portfolio scenarios, pay attention to the Distributed to Paid-in (DPI) Capital Ratio. This number will give you a sense for how your portfolio has performed. Any DPI Capital Ratio over 2 means you've more than doubled your money. And, top ranking early stage investors are able to achieve a DPI Capital Ratio above 3.

5
6
Type of ExitExit Multiple
7
Total Amount Invested\$500,000Loss0
8
Amount of Capital Returned\$1,335,000Breakeven1
9
Distributed to Paid-In (DPI) Capital Ratio
2.67Base Hit4
10
Home Run10
11
Grand Slam25
12
13
Individual Investments: Exit Types and Returns
14
15
Company NameTotal InvestmentPercentage of PortfolioType of ExitTotal Amount Returned
16
Investment 1\$25,0005%Loss\$0
17
Investment 2\$50,00010%Base Hit\$200,000
18
Investment 3\$25,0005%Loss\$0
19
Investment 4\$15,0003%Base Hit\$60,000
20
Investment 5\$50,00010%Home Run\$500,000
21
Investment 6\$25,0005%Loss\$0
22
Investment 7\$15,0003%Loss\$0
23
Investment 8\$50,00010%Breakeven\$50,000
24
Investment 9\$25,0005%Base Hit\$100,000
25
Investment 10\$25,0005%Breakeven\$25,000
26
Investment 11\$25,0005%Loss\$0
27
Investment 12\$50,00010%Base Hit\$200,000
28
Investment 13\$50,00010%Base Hit\$200,000
29
Investment 14\$20,0004%Loss\$0
30
Investment 15\$50,00010%Loss\$0
31
32
Totals\$500,000100%\$1,335,000
33
34
35
36
If you like this Portfolio Modeling Tool, please share the following link: http://bit.ly/Seraf_Portfolio_Modeling_Tool
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