How Navexa Calculates Your Portfolio Returns
The formula underpinning our portfolio tracker
Behind all the analytics tools and features Navexa’s portfolio tracker offers you, there’s one governing idea:
That you can log in and see at a glance how your investment portfolio performance is tracking.
This goes for individual holdings and your portfolio as a whole.
But, as you may know, there is a wide variety of mathematical equations and methods for determining portfolio performance.
This is why we sometimes have users contacting us to query why the performance and returns they see in their account don’t match with other sources, like their investment broker, for example.
So, allow us to explain the method we use to calculate your portfolio returns — and why.
Calculating Portfolio Performance
Navexa calculates portfolio performance using an equation based on the Modified Dietz Method.
The Modified Dietz Method provides a dollar-weighed analysis of your return.
If you’re interested in the maths behind the method, here is the equation:
ROR = (EMV-BMV-C) / (BMV + W*C)
ROR means rate of return.
EMV means ending market value.
BMV means beginning market value.
W means weight of each cash flow.
C means cash flow.
Navexa uses a version of this equation to calculate portfolio returns.
Our calculation accounts not only for the performance of assets in your portfolio, but for the size and frequency of cash flows in and out of it, too.
The theory behind this is to give you a clearer and more complete picture of how your money is performing in the market.
A Note On Annualization
Navexa also annualizes your calculated returns using the simple ‘rate of return’ methodology.
That means we weight the amount of time you’ve held an investment for by the amount you’ve invested.
01/01/2018 Buy 1,000 Shares at $2.00 = $2000
31/12/2018 Buy 1,000 Shares at $2.20 = $2200
31/12/2019 Sell 2,000 Shares at $2.30 = $4600
Capital Gain = $4,600 – $2,200 – $2,000 = $400
Total Capital Invested = $2,000 + $2,200 = $4,200
We then calculate the Average Years Invested (AYI) by weighting the time vs the amount.
AYI = (730 days * 2,000/4,200) + (365 days * 2,200/4,200) = 538.19/365 = 1.47 years
Then, to calculate the simple annualised return:
Total Return = Gain / Total Capital / AYI = 400/4,200 / 1.47 = 6.47%
Why Do We Calculate Your
Returns Using This Method?
The simple answer to this is because the Modified Dietz Method is generally considered the most accurate way to calculate portfolio performance.
This goes for fund managers, mutual funds and investment companies looking to give their clients the clearest possible picture of how their money is performing in the market.
The financial industry seeks transparency around portfolio performance calculation and reporting.
Thus, the Modified Dietz Method has become recognized as a big step in improving portfolio performance reporting.
Not only does the financial industry like this method, but watchdogs and regulators prefer it, too.
The Investment Performance Council recommends the Modified Dietz Method in its Global Investment Performance Standards.
The way we see it here at Navexa, if it’s good enough for the international industry standards, it’s good enough for our users.
We hope this has helped you to understand how our portfolio tracker calculates your returns!