To provide you with an optimised experience, we use technologies such as cookies to store and/or access device information. If you consent to these technologies, we may process data such as browsing behaviour or unique IDs on this website. If you do not give or withdraw your consent, certain features and functions may be impaired.
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service expressly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
The technical storage or access is necessary for the legitimate purpose of storing preferences not requested by the subscriber or user.
Technical storage or access for statistical purposes only.
Technical storage or access used solely for anonymous statistical purposes. Without a subpoena, the voluntary consent of your Internet service provider or additional records from third parties, the information stored or accessed for this purpose alone cannot generally be used to identify you.
The technical storage or access is necessary to create user profiles, to send advertising or to track the user on a website or across several websites for similar marketing purposes.
I don’t quite understand yet.
For example, when I look at the performance of an ETF – say, on a chart on just etf – is the simple return calculated there?
If I buy this ETF at a certain point in time and then continue to buy it regularly, what is the best way to calculate my personal return?
Could you perhaps explain that again in simple terms? Thanks a lot!
Hello Maja,
The justETF chart: Shows only the fund’s simple price performance. It shows neither MWR nor TWR, as your personal contributions do not appear there at all.
Your individual return: Once you start making regular additional contributions, a simple percentage calculation is no longer useful. Instead, you use the MWR (money-weighted return). This takes precise account of exactly when and how much you have paid in.
What’s the best way to work this out?
Manually, it’s a formula nightmare. The easiest way to do this is using free trackers such as portfolio performance. Simply enter your purchases (or import them via PDF) and the tool will automatically calculate your personal return!
An error has also crept into the presentation of the time-weighted return TWR.
The two-month yield r2 is obtained by multiplying the interest factor of the first month a by that of the second month b and then subtracting 1:
a = 1050/1000 = 1,05
b = 3150/3050 = 1,032787
r2 = ab - 1 = 8.4426%
Thanks for the tip, Christian! The formulas have now been corrected 🙂
Hello Eric, that looks good now!
Only in the case of the simple return does the text not really fit the calculation. The latter is correct in principle, except that the minus one is missing.
r2 = 3150/(1000 + 2000) - 1 = 5%
In the description, however, it should somehow read like this:
The sum of all incoming payments minus the sum of all outgoing payments equals the cash flow total.
With this and the final value, the simple return for two months is then calculated as:
r2 = (terminal value - cash flow total) / cash flow total
Or remodelled:
r2 = terminal value/cash flow total - 1
The simple return per month r is then calculated as follows:
r = root(1 + r2) - 1 = root(1.05) - 1 = 2.47%
And of course the incoming and outgoing payments are included in the cash flow total in the simple return (only the timing is not).
Best regards, Christian
The calculation of the money-weighted return MWR is unfortunately presented incorrectly.
The equation to be solved is:
1000 + 2000/(1+r) = 3150/(1+r)^2
Or in the variant obtained by multiplying by (1+r)^2:
1000 (1+r)^2 + 2000 (1+r) = 3150
Both lead to the solution:
r = 3.7155%
In Excel or Calc, the same value r is obtained using the function for the internal rate of return IKV:
r = IKV({1000;2000;-3150})
And r is not the return for the two-month period, but the return for one period, i.e. for one month.
The return r2 for the two-month period is calculated as follows:
r2 = (1+r)^2 - 1 = 7.569%