ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACAD
1
Please copy this template for your own use
2
Q3 update - Oct 2020Asset classFundValue last quarter (£)Value this quarter (£)Asset allocation (%)Quarterly gain (%)Fund gain/loss since purchase (£)Fund gain/loss since purchase (%)Asset class annualised return (%)Current portfolio value (£)Rebalance required (Y/N)New contributions (£)Portfolio value after new contribs (£)Target asset allocationNew money: regular contrib (£)New money: rebalanced contrib (£)Unit price (£)Units to buy
Value post-purchase
(use for next update)		Fund ISIN code
3
4
Emerging MarketsiShares Emerging Markets Equity Index Fund D5,283.005,486.839.63%3.86%1,871.2941.1810.74%56,960.15Fine97657,936.150.0987.84-272.581.72550.921739135,574.67GB00B84DY642
5
Global PropertyiShares Global Property Securities Equity Index Fund D2,893.002,860.145.02%-1.14%594.4018.4818.24%56,960.15Fine97657,936.150.0548.836.671.93125.271879852,908.94GB00B5BFJG71
6
Dev World ex-UKVanguard FTSE Developed World ex-UK Equity Index Fund21,972.0023,074.3840.51%5.02%9,399.8160.8710.34%56,960.15Fine97657,936.150.37361.12-1,638.00414.10190.872055887723,435.50GB00B59G4Q73
7
UK equitiesVanguard FTSE U.K. All-Share Index Trust2,827.002,764.894.85%-2.20%371.189.1513.53%56,960.15Fine97657,936.150.0548.8131.92177.38240.27511184882,813.69GB00B3X7QG63
8
Global Small CapVanguard Global Small-Cap Index Fund3,807.004,030.777.08%5.88%1,371.3245.6811.94%56,960.15Fine97657,936.150.0658.56-554.60301.81190.19402813474,089.33IE00B3X1NT05
9
Bonds - UK Gov Vanguard U.K. Government Bond Index Fund15,526.0015,176.0526.64%-2.25%3,437.0820.562.77%56,960.15Fine97657,936.150.31302.562,784.16189.85681.5936221415,478.61IE00B1S75374
10
Bonds - Global Inflation-LinkedRoyal London Short Duration Global Index Linked (GBP hedged)3,504.003,567.096.26%1.80%186.385.016.07%56,960.15Fine97657,936.150.0768.32488.441.09162.621448213,635.41GB00BD050F05
11
Gain/loss from historic holdings4,005.95
12
Portfolio total55,812.0056,960.15100.00%2.06%21,237.4111.13%100.00%97697657,936.15
13
Total cash contribs to date (£)35,682.78
14
Portfolio gain/loss (%)59.63%Value post-purchase from last updateInput latest market value for each fundMarket value - Total inflowsMarket value - Total inflows / Total Inflows x 100. Not annualised figure.Annualised return drawn from Cashflows tabUpdate underlying formula when desired asset allocations changeUse this column when no rebalance requiredUse this column when annually rebalancing. Rebalance to desired asset allocations. Input manuallyChange underlying formula to R instead of Q to rebalance assets to target asset allocations. Formula uses column Q when not rebalancing. Change underlying formula to R instead of Q to rebalance assets to target asset allocations. Formula uses column Q when not rebalancing.
15
Automatically input numbers from last update with formula ='Q2 Jul 2020'!W9 Where name of last quarter's spreadsheet tab appears in quote marks e.g. 'Q2 Jul 2020' and W9 refers to cell containing the relevant value. Historic holdings - Add in your fund's gains or losses when it's sold off in entirety. Historic holdings figure is aggregate of all funds that are no longer in portfolio. Remember to add sold funds gain / loss to historic holdings every time a fund is sold off entirely.Asset allocation >20% = rebalance when allocation moves 5%+ either side.
Asset allocation <20% = rebalance when allocation moves 25% in proportion to allocation.
https://monevator.com/threshold-rebalancing
16
Lower bound rebalance = Multiply asset allocation percentage by 0.75 e.g. 0.1 x 0.75 = 0.075
Upper bound rebalance = Multiply asset allocation percentage by 1.25 e.g. 0.1 x 1.25 = 0.125
17
Portfolio weighted OCF
18
19
FundAsset allocation (%)OCF (%)Weighted OCF (%)
20
VG UK0.050.060.003
21
VG Dev World0.370.140.0518
22
iSh Emerging0.090.180.0162
23
VG Small cap0.060.290.0174
24
iSh Property0.050.170.0085
25
VG Gilts0.310.120.0372
26
RLAM Glb Linker
0.070.270.0189
27
28
Total100.00%0.153
29
30
31
Portfolio costs in £ (annual)
32
33
Cost category
Cost (£)
34
Fund OCFs 87.15
35
Platform fee (Cavendish @ 0.25%)
142.40
36
Trading fee0.00
37
38
Total229.55
39
40
41
Portfolio fixed income duration (ideal)
42
43
FundAsset allocation% of fixed incomeDuration (years)Weighted Duration (years)
44
VG Gilts0.250.6613.99.14
45
RLAM Glb Linker
0.130.345.31.81
46
Cash0000.00
47
48
Total 38.00%100.00%10.96
49
50
Time horizon / duration 2020 = 11 years
51
52
53
Portfolio fixed income duration (actual)
54
55
FundAsset allocation% of fixed incomeDuration (years)Weighted Duration (years)
56
VG Gilts0.310.8213.911.34
57
RLAM Glb Linker
0.070.185.30.98
58
Cash0000.00
59
60
Total 38.00%100.00%12.32
61
62
Time horizon / duration 2020 = 11 years
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