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

View only
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
IMPORTANT NOTE: You cannot edit this spreadsheet.
3
Please make a copy by following these steps:
4
5
Google Sheets copy:
6
1
Log into your Google account (if you don't have a Google account it only takes a minute to create one)
7
2
Create a copy of the spreadsheet by clicking on File > Make a copy...
8
3
Edit your copy of the spreadsheet.
9
MS Excel copy:
10
1
Download as an Excel file by clicking on File > Download as > Microsoft Excel
11
2
Edit the downloaded copy of the spreadsheet.
12
13
14
Portfolio Performance Spreadsheet
15
16
This spreadsheet will help you measure your portfolio's overall growth as well as its rate of return using the Unit Valuation System and Internal Rate of Return
17
18
Instructions:
19
Included in the headings of each table (hover over a heading to see the related notes)
20
21
Unit Valuation System (UVS):
22
Used by open ended investment funds and investment clubs to track each investor's share of the fund.
23
Measures the underlying performance of an investment and completely excludes the impact of cash inflows and outflows.
24
25
Internal Rate of Return (IRR):
26
Calculates the annualised rate of return generated by a portfolio, taking into account cash inflows and outflows.
27
This takes account of that fact that your returns will differ from the returns of your underlying investments due to the timing of your cash inflows and outflows.
28
Can be compared to UVS returns to see the positive or negative impact of cash inflows and outflows on the returns of your underlying investments.
29
IRR is the preferred performance metric because it takes account the timing of cash inflows and outflows which can have a material impact on returns.
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...