We'd like to remind Forumites to please avoid political debate on the Forum... Read More »
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!
How is the five year performance calculated?
Options

w00519773
Posts: 222 Forumite

I am analysing a few funds like this one: https://markets.ft.com/data/funds/tearsheet/summary?s=GB00BYVGKV59:GBX.
I am using this formula to calculate percentage increases: https://www.skillsyouneed.com/num/percent-change.html i.e. ((New Number - Original Number) / Original Number) × 100. The text in my first hyperlink says that £1,000 invested five years ago is now worth approximately £2,200. Therefore a 120% increase:
((2200-1000)/1000)*100=120
Yet the performance currently says 17.33% over five years: https://markets.ft.com/data/funds/tearsheet/performance?s=GB00BYVGKV59:GBX.
Is this saying the performance averages at 17.33% over five years i.e. 86.65% overall (5*17.33)? 86.65 is closer to 120%. I guess the difference could be due to when the snapshot was taken and also fees?
Have I understood this correctly?
I am using this formula to calculate percentage increases: https://www.skillsyouneed.com/num/percent-change.html i.e. ((New Number - Original Number) / Original Number) × 100. The text in my first hyperlink says that £1,000 invested five years ago is now worth approximately £2,200. Therefore a 120% increase:
((2200-1000)/1000)*100=120
Yet the performance currently says 17.33% over five years: https://markets.ft.com/data/funds/tearsheet/performance?s=GB00BYVGKV59:GBX.
Is this saying the performance averages at 17.33% over five years i.e. 86.65% overall (5*17.33)? 86.65 is closer to 120%. I guess the difference could be due to when the snapshot was taken and also fees?
Have I understood this correctly?
0
Comments
-
I think compounding of returns will play a part. So if you say that each year the increase was 17.33%, the calculation would be 1000 x 1.1733^5 = 2223.54. Nearer to the stated return but not exactly!1
-
Performance figures are always quoted after fees are deducted.1
-
I used the Trustnet chart tool for the fund mentioned this gives:-
https://www2.trustnet.com/Tools/Charting.aspx?typeCode=FG1XC,N-
I find that over 5 years the
(a) Cumulative Performance= 122.4%
(b) Annualized Performance= 17.3%
Looking at the Discrete Performance (each 12 month period), of the fund it has swung from -29.4% to +50.4%.
Remember that this is the accumulative version of the fund. So the retained dividend, is being reflected in this funds price.
Perhaps the Trustnet chart tool might be useful in analyzing your funds.1 -
1. Cumulative Performance 122.4%
5 year Ave CP= 24.48%
2. The 5 year Discrete Performance= -29.4, 44.5, 50.5, 9.7,32.
Sum of DP= 107%
5 year Ave DP= 107/5= 21.4%
3. They have a larger data base of fund % changes, divided by the larger number of readings used,. That is how I think they get down to the figure of Annualized Performance= 17.3%
1 -
Eyeful said:1. Cumulative Performance 122.4%
5 year Ave CP= 24.48%
2. The 5 year Discrete Performance= -29.4, 44.5, 50.5, 9.7,32.
Sum of DP= 107%
5 year Ave DP= 107/5= 21.4%
3. They have a larger data base of fund % changes, divided by the larger number of readings used,. That is how I think they get down to the figure of Annualized Performance= 17.3%
((1-0.294)(1+0.445)(1+0.505)(1+0.97)(1+0.32))^(1/5)=1.17327=17.3% return, the same as the overall figure.
The individual year returns are cumulative. Taking an arithmetic average does not mean anything.1 -
You don't need any of the discrete figures - just the start and end amounts
(End value/Initial value)^(1/years)-1
(2200/1000)^(1/5)-1 = 17.1%
Not sure about the discrepancy from 17.3% - probably because 2200 isn't exactly 22001 -
Thanks Linton & Prism.
Perhaps this may be of use & interest to w00519773
https://dqydj.com/cagr-calculator/
0
Confirm your email address to Create Threads and Reply

Categories
- All Categories
- 351K Banking & Borrowing
- 253.1K Reduce Debt & Boost Income
- 453.6K Spending & Discounts
- 244.1K Work, Benefits & Business
- 599K Mortgages, Homes & Bills
- 177K Life & Family
- 257.4K Travel & Transport
- 1.5M Hobbies & Leisure
- 16.1K Discuss & Feedback
- 37.6K Read-Only Boards