Are you a stock picker who wonders whether you’re beating the market?

Or perhaps you’re a passive investor keen to see how the returns from your DIY ETF portfolio compares to Vanguard’s *LifeStrategy* fund?

Whatever the motivation, you’ll need to track and compare your performance versus active and index funds to know for sure.

And that means comparing your returns calculated using the same methodology that they use.

If you think you’re a great investor but really you’re lagging the market by 3% a year, it will have a disastrous impact on your wealth compared to if you’d used index funds.

That’s not to mention the many hours wasted in fruitless research and so on (unless you happen to enjoy it.)

### Many unhappy returns

Now I’ve warned before that there are good reasons not to closely track your returns.

For starters, if stock picking is your hobby, then finding out you’re in the ‘D’ League – less Neil Woodford, more Woody Woodpecker – will be thoroughly depressing.

True, you might end up richer if you then give up on active investing and turn passive – although that partly depends on what hobby you replace active investing with. (Sailing boats don’t come cheap…)

But if you’ve wrapped your self-worth up in your ability to beat the market, be prepared to take an emotional beating when you discover the dumb money has actually beaten you…

More subtly, passive and active investors alike can be provoked into overtrading or excessively fiddling with their portfolios by paying them too much attention.

You might even scared out of shares altogether, should you begin to more closely follow their ups and downs.

You could even get sick with stress.

Behavioural scientists have shown we hate losses much more than we love gains.

Yet as Nassim Taleb explained in *Fooled by Randomness*, on any given day it’s a coin toss as to whether the market is up or down.

This means looking at your performance every day is a guaranteed downer.

You’ll be twice as miserable as you are happy!

### It all adds up

With willpower, you can accurately track your returns and avoid looking at your numbers every day – or even every month.

You can make up the rules.

Just don’t kid yourself by also making up your returns.

I have met many people who don’t take account of all the new money they add to their portfolio – yet they talk confidently about how well they’ve done through their active investing decisions in growing their wealth.

Only when you grill them do they admit to “top-ups” and the like.

This is all nonsense from the perspective of comparing performance.

Hint: If your portfolio starts the year at £10,000, you add £2,000, and at the end of the year you have £12,000, you did not earn 20%!

Your return was diddlysquat.

### You fooled you

You may decide not to obsess about returns, or even to ignore them altogether.

Good for you!

But if you don’t know your returns, don’t presume you do when somebody asks.

That includes you, when you ask yourself whether you’d be better off with index funds instead of active investing.

If you haven’t properly tracked your returns – taking into account all the new money you add, as well as all the capital gains and dividends – then don’t pretend you’re the next hot hedge fund manager.

You just don’t know.

### Unitize your portfolio to track your returns

Still want to know how you’re doing?

I believe the best way to track your returns is to **unitize your portfolio**.

Sure you can use online portfolio tools or work out various numbers on-demand, but I think it’s better to take charge for yourself so you understand not just the numbers, but what is driving those numbers.

Unitization is the method used by fund managers who must account for money that flows in and out of their open-ended funds.

As it’s the industry standard method of measuring returns, unitization means you can compare your performance with any existing fund.

You can also compare a unitized portfolio’s performance against a benchmark such as an index.

And unitization encourages you to keep decent records – also important if you’re trying not to kid yourself.

As physicist Richard Feynman warned: *“The first principle is that you must not fool yourself, and you are the easiest person to fool.”*

### Why open-ended funds are called unit trusts

So what is unitization?

You are probably already familiar with unit pricing when it comes to funds.

If not, here’s a quick refresher.

When you invest your money into an open-ended fund, you buy a certain amount of units in that fund with your money.

For instance, let’s say I have £18,420.58 in Legal & General’s European Index Trust.

The L&G website tells me how it calculates this:

Number of units I own: 6,564.712

Unit price Buy/Sell: 280.6p/280.6p

Value: £18,420.58 (i.e. 280.6 pence x 6,564.712 units)

All investors in the L&G fund would see exactly the same unit price. However they will own different numbers of units, depending on how much they have invested.

Whenever investors put additional money into the European Index Trust, L&G creates new units at the prevailing unit price.

The new money buys the right number of units at that price for the money invested.

For example, if the unit price were 280.6p, then investing £5,000 would buy you 1,781.9 additional units.

The new cash you’ve invested now comprises part of the assets of the unit trust, which offsets the creation of those new units.

The fund’s total Assets under Management have increased, but the returns haven’t changed just because new money has been added – and this is confirmed by the unchanged unit pricing.

Finally, the fund manager deploys your extra money to buy more holdings in order to keep the fund doing what it says on the tin.

In the case of this example, he or she buys more shares to match the European Index.

### Unit prices and new money

The crucial point is that adding new money does not change the price of a unit.

Only gains and losses on investments, dividends and interest, and costs that are charged against the portfolio’s assets will change the price of a unit.

For example, if the companies owned by the European Index fund rose 10% in value, then the unit price would be expected to increase by 10%, too.

So here the new unit cost would be:

280.6*1.1 = 308.66p.

Measuring changes in the value of units like this – as opposed to measuring the total monetary size of the fund – enables the manager to maintain a consistent record of performance.

This record is not distorted by money coming in and going out.

Also, when an investor wants to cash out from the fund, there’s no confusion about what percentage of the assets they own or anything like that.

They’ll own a certain number of units. To cash out, they sell them back to the fund manager at the prevailing unit price.

For instance, let’s say you own 600 units.

At 280.6p per unit, you’d cash out with:

£2.806 x 600 = £1,683.60

By **unitizing your portfolio**, you can use the same principle to measure your own returns – whether you’re saving and investing extra cash or you’re withdrawing money from the portfolio.

### Interlude: A pep talk

So far, so boring.

Well, we are talking about accountancy here!

I’ll level with you. Things aren’t going to get any more exciting.

However the good news is that unitizing your portfolio is a very easy process.

Read on to discover how to do it.

### How to unitize your portfolio

For something that has the letter ‘z’ in it, unitization is very simple to do.

Admittedly, trying to retrospectively see your unitized performance over previous non-unitized years is a nightmare.

It’s such a nightmare, in fact, that I didn’t bother trying when I started to track my returns properly a few years ago, and I wouldn’t suggest you do, either.

If instead you take a leaf out of the Khmer Rouge’s generally best-avoided playbook and declare today to be “Year Zero” for your portfolio then it’s straightforward to get started.

**1. First decide on an arbitrary unit value**

The first thing you need to do is to decide what one unit in ‘your fund’ is worth.

It’s a totally arbitrary decision, as it will just be used as the base for future return calculations.

Many people choose £1.

I chose £100 for egomaniacal reasons.

**2. Calculate how many units you currently have**

As it’s Year Zero for unitizing your returns, you need to work out how many units you currently have.

This is based on the total value of **everything in the portfolio** you’re tracking, together with the unit value you just came up with.

You simply divide the former by the latter.

Let’s say your portfolio is £50,000 and your unit value is £100.

This means you have 500 units to begin with, like so:

£50,000/£100 = 500 units

Make a note of this number, together with your arbitrary unit value.

I track all this on a Web-enabled spreadsheet that constantly tells me what my portfolio is worth right now, what one unit is worth, and how many units I have.

From this it also works out and tells me my returns over various periods.

But if you want you can just write these numbers in a notebook. It’s only when you add new money that further calculation is mandatory.

**3. If you don’t add new money you can now easily track your returns**

Let’s say you never did add or remove another penny from your portfolio.

You know how many units you have, and you know the starting unit value.

You can now easily work out your unitized returns.

For example, let’s say your portfolio increases to £60,000.

The unit value is now:

£60,000/500 = £120

Your return to-date is the change in unit value.

£120-£100/£100 = 20%

However you hardly needed to unitize to see that…

**4. Adjust your total units as you add new money**

The whole point of unitizing is to properly take into account money added or removed from the portfolio.

Every time you add new money, you need to calculate and take note of the value of one unit.

For instance, let’s say that when your portfolio hits £60,000 you decide this investing lark is a piece of cake, and so decide to add in another £6,000.

The unit value before the additional cash is added, as above, is £120.

Now we need to calculate how many units our new money buys:

New money added / unit cost = number of new units

£6,000/ £120 = 50 new units

This means your £66,000 portfolio now comprises 550 units.

Again, you note it down ready for next time.

**5. Keeping ‘buying’ new units as you add money**

This process is simply repeated over your investing lifetime.

Let’s say the value of your portfolio increases to £69,850, and you decide to add a full ISA contribute of £15,240.

First:

Unit value = Portfolio value / number of units

Unit value = £69,850/550

Unit value = £127

Number of new units that £15,240 buys:

New money added/ unit cost = number of new units

£15,240/£127 = 120 new units

With the new ISA money your portfolio is now worth £85,090, and is comprised of 670 units (that is, 550+120).

As always you note down the total unit number for next time.

**6. What happens when you remove some money?**

When money is removed entirely from the portfolio, the principle is exactly the same as when money as added – the number of units changes as consequence, but not the unit value.

You are effectively ‘selling’ units in your own fund to free up the cash. Obviously this procedure doesn’t change the returns you have achieved on the mix of assets you happen to hold.

For example, let’s say your portfolio continues to motor on and breaks through six figures to hit £100,165.

At this point you get collywobbles (I told you there was a downside to tracking your returns) and you decide to spend £10k of it while you’ve still got your teeth.

You know from your records that your portfolio currently consists of 670 units.

This means the unit value currently is:

£100,165/670= £149.50

You decide to remove £10,016.50 from the portfolio to keep the sums simple:

£10,016.50/£149.50 = 67 units

After the withdrawal you have £90,148.50 in your portfolio represented by 603 units (670-67).

**7. Work out your unitized return at any point**

At any moment in time you can see exactly what your return is by looking at your unit value.

For instance, let’s say that after all of the above, your portfolio ends the year with a value of £90,450.

Your unit value is:

£90,450/603= £150

So your unitized return since you unitized your portfolio is:

£150-£100/£100 = 50%

This is the return that you can compare with trackers and other funds and benchmarks that report their returns over the same period.

Let’s say at the end of next year a unit was worth £160.

You started the period with a unit value of £150. So your return over the year is:

£160-150/150= 6.7%

You see how easy it is to calculate and note down your annual return figures every year, for instance?

### Actually it all seems a lot of work

It’s really not, once you’ve set it up properly.

My spreadsheet tells me my current portfolio and unit value at any time.

A sheet also tracks money added and subtracted over the year, and calculates the number of units added or subtracted when I do so, which gets added to the ongoing tally.

At the end of the year I simply record all the relevant values for my records.

Then, on the first trading day of the New Year, I hard-update the spreadsheet with my starting unit value and the total number of units.

This makes it easy to see and record my discrete total return figures every year.

### When should I calculate my returns? And what else?

Up to you. I take regular snapshots, and as discussed above I work out the annual figures as I go.

I also work out things like my Total Expense Ratio (TER) – based on another sheet tracking all my trading costs – and my total portfolio turnover.

If you take monthly snapshots then you can track your volatility, and start to look into other more esoteric ratios if you want to, such as the Sharpe Ratio or the Information Ratio.

I don’t bother. (Despite having written over 3,000 words on it here, I’m neither an expert nor an enthusiast for data crunching!)

### What about Net Present Value or Internal Rate of Return or CAGR etc?

There are many different ways of calculating returns. They all have value in different circumstances. And they usually deliver different numbers.

The advantage of unitization is it gives you the appropriate numbers to compare with any fund or index out there. That’s most important when tracking your own performance.

### What if I have multiple dealing accounts, SIPPs, and so on?

If I were you I would track all the different holdings on one spreadsheet.

I’d then unitize the returns on this entire portfolio, and also track expenses, portfolio turnover, and other interesting figures across the entire piece.

This is exactly how I measure my own total returns across half a dozen different platforms and brokers.

There’s not a lot of point in tracking the returns in a SIPP separately from returns in an ISA, in my view.

Ultimately it’s all your net worth. They’re just different baskets.

However if you did want to track how particular accounts are doing – perhaps because you employ different investing strategies in one versus another – then you could create separate spreadsheets to follow them.

You’d also have to track separate money flows in and out of each them, and generate unitized return figures for each ‘pot’ of cash.

Remember, you’d still want to unitize the entire portfolio to properly track your overall returns (rather than, say, averaging the returns on the different accounts, as this would not account for the different amount of money in each – though you could create a weighted average I suppose).

### What about dividends, spin-offs, dealing fees, stamp duty, rights issues and so on?

None of this matters, so long as all the incoming money (from sources such as dividends and spin-offs) and expenses (such as dealing fees and stamp duty) are retained or paid from within the portfolio.

The number of units you own doesn’t change because you were paid a dividend – no more than if one of your shares went up by 20p.

But your units do now represent more assets, in the form of that extra dividend cash. That increases the value of each of your units.

Similarly, dealing fees and stamp duty are no different to seeing the price of one of your holdings go down, in terms of their impact on unit value.

Expenses subtract from your total assets, and therefore they reduce the value of a unit.

**The golden rule:** It’s only when external money is added or when you take money out of your portfolio that you need to adjust the number of units you own. Such additions or withdrawals are as if an investor was buying or selling units in your fund.

Of course none of this is to say that dealing fees and dividends don’t matter from an investing and return standpoint. They matter a great deal.

The point is simply that unitization is capturing their impact on returns, so you don’t need to adjust for them. They are not ‘extra’ money added or subtracted.

### XIRR, time-, and money-weighted returns

From previous discussions elsewhere, I know some people prefer to plug numbers into Excel than to unitize and track their portfolios.

As I understand it – because they have told me so – such people usually get very similar results by using Excel’s XIRR function.

I won’t go into the details of using XIRR here because, frankly, I’ve never done it.

There are various tutorials on the Web.

However you should note that while the results you get from unitization and XIRR may often appear very similar, they will sometimes diverge markedly.

That’s because they are calculating different kinds of return.

- Unitization gives what is known as a
**time-weighted return**– all time periods are weighted equally, irrespective of how much money is invested when. Unitization tells you the underlying investment performance, and strips out the impact of money flowing in and out.

- XIRR gives what is known as a
**money-weighted return**– this means that time periods in which more money is invested have more of an impact on the overall return than equivalent time periods in which less money is invested.

XIRR calculates the Annualized Internal Rate of Return on a portfolio. The gist is that you supply the XIRR function with a column in your spreadsheet that lists these cash additions and withdrawals. The function then uses an iterative process to hone in on your returns.

It makes sense for the fund industry to use unitization because a fund manager typically has no control over when money is added or removed from their fund – it comes from the fund’s customers – and also because it’s the choice and performance of the underlying assets that matters when evaluating how skillful a manager is. (The same reason I unitize my returns).

However some would argue that a money-weighted return like XIRR is at least as illuminating from the perspective of a private investor, since you are in control of money flows and what matters is your personal rate of return.

Many private investors do derail their results with poor market timing. By calculating and comparing both the unitized return and a money-weighted return you can spot the impact of poor (or perhaps good) market decisions timing on your portfolio.

The *Henry Wirth* Investing blog explains:

- If your Money Weighted Return Rate is greater than your Time Weighted Return Rate, then your market timing is adding value to your portfolio.

- If your Time Weighted Return Rate is greater than your Money Weighted Return Rate, then your market timing is subtracting value from your portfolio.

You should also read the excellent comments from John Hill that follow today’s post.

### Do it for yourself

Personally I think if you’re going to keep track of the money flows in and out of your account, you might as well go the whole hog and unitize your portfolio.

Once you’ve setup a spreadsheet to do the sums it’s very easy to stay on top of things, and you have the satisfaction of knowing your returns are directly comparable with those reported by fund managers.

That’s not to say there’s a right or wrong way to measure returns.

It all depends on context, and on knowing what you’re measuring and why.

Also remember that in itself a return figure tells you nothing about the volatility or risk you took to get those returns, nor about the maximum troughs (aka drawdown, or losses at the portfolio level) that you endured along the way.

But if you unitize your portfolio and keep records of, say, the daily unit price, then you can go ahead and calculate and track that sort of thing for yourself.

Indeed, once you’ve unitized your portfolio, you can go crazy if you want to and use it as the basis for calculating all kinds of extra stuff – such as the Sharp Ratio that might help you understand if your returns are down to skill or risk taking.

And time of investment for every lot of units also matters, so in no way this average is correct.

I think I know how it could be done… I hope the formatting will be ok. If anyone can see a fault in this, please let me know.

Imagine such a series of cash flows:

date, number of units flow, unit price, cash flow

2009-01-01 -500 1 -£500

2010-01-01 200 1.2 £240

2011-01-01 -300 0.9 -£270

2012-01-01 600 1.5 £900

To calculate XIRR on this would be incorrect because there is a withdrawal before a subsequent investment and XIRR can give multiple results in such cases. We can, however, take advantage of the knowledge XIRR doesn’t have, that is prices paid and returns achieved in between of cash flows reflected in unit prices. This series of flows can be hence rearranged to always get a single result. To do that we need to keep the same time of investment for every lot of units ever held. We move every closed deal to the end of the table. For the above table the amended table would be:

2009-01-01 -£300

2011-01-01 -£470

2012-01-01 £900

I only moved the 200 units bought for £200 and sold for £240, held for a year, to the end of the table. Now we can use XIRR to calculate the IRR for the amended table and we get 8.95%. Does it make sense?

@paul claireaux, “That would certainly be news to me.”

I have found it news to many people, including many who should really know better. Look at the example I posted here – 4 cash flows, resulting in 3 different IRRs. I have seen many problems with the misuse of IRR, including use outside of investing.

@Paul W. “Wouldn’t there be single IRR also when there are multiple investments followed by multiple withdrawals i.e. only one change of sign?” No, you can still get multiple IRRs, although in this case you would tend to see one reasonably sensible solution and other silly looking ones, i.e. large and negative. e.g. -3000, -2000, 5000, 1000 annual cash flows have a “reasonable” looking IRR of about 11% and silly ones around -119% and -259%.

“But that would be unit-weighted average regardless of unit prices paid.” I think that is fair, but weight by capital invested if you prefer. I have a bit of an issue with that though in that capital invested further back in time is usually worth more than it is today – there might be an argument for uplifting by at least the risk free rate, or inflation as it is easier to look up. There is no right answer.

To HRP.

I must say that I feel that your comments are confusing what was otherwise a useful article.

The Investor has outlined us a useful way to determine a unit price on our portfolios over time. And from this we can work out what the average annualised return on that portfolio has been so as to compare it to a Unit Trust or OEIC.

We have then explored how, where we put money in OR take money out of our portfolio over time – our effective return (IRR) is often a very different number. And I’ve explained this in plain English in my blog. if you believe that to contain flaws – please show where they exist.

This marked difference between the average annual growth on a fund price and our personal effective return is due to the well known effects of pound cost averaging (and reverse pound cost averaging on withdrawals)

Now, you claim that there are multiple IRRs for a given set of input and output values.

Perhaps you’re simply stating that each payment in (or withdrawal) from a portfolio will have a different rate of return?

Well yes of course – but that’s different to stating that there are multiple IRRs on a series of transactions. There is only one.

If you still claim otherwise I’d suggest you try to prove it – with a simple example.

I will try to make this as simple as possible. If you have multiple input and multiple output cashflows, there can be more than one IRR. The example I posted is about as simple as I can think of:

Cashflow -1000, +3600, -4310, +1716. IRRs for these flows are 10%, 20% and 30%. Easily proved:

-1000 + 3600/(1+10%) – 4310/(1+10%)^2 + 1716/(1+10%)^3 = 0

-1000 + 3600/(1+20%) – 4310/(1+20%)^2 + 1716/(1+20%)^3 = 0

-1000 + 3600/(1+30%) – 4310/(1+30%)^2 + 1716/(1+30%)^3 = 0

If you are having problems with the concept of a function resulting in one of many values, consider the square root of 4, answer 2, but -2 is also valid.

To HRP

Thanks for that lesson in square roots!

As it happens I quite like maths riddles but prefer slightly trickier ones than that. So let me offer you a riddle in return.

What’s the square root of minus 4?

(answers on postcard)

Now to your example.

I have to say you’ve picked a ‘curious’ example to make your point.

Your portfolio starts with an injection of £1,000 followed by a withdrawal of £3,600 the following year. In other words you would be in ‘debt’ !!

So, yes of course, if you allow your portfolio to go into debt AND you assume the same IRR on the debt as on your growth! – there are multiple ‘theoretical ‘IRRs’

But seriously – is this curious example useful to readers of this educational blog?

Let’s make the example a REAL one.

Try setting your initial investment to £10,000 (to keep the balance positive)

Then in subsequent years:

1. Withdraw £3,600

2. Add £4,310

3. Withdraw £1,716 and finally

4. Withdraw £13,177 (which is your final value in the fund)

Now tell us all how many IRRs apply to this series?

My excel software only gives one answer but I’m open to challenge (;-)

Thanks

Paul

@paul claireaux

“Your portfolio starts with an injection of £1,000 followed by a withdrawal of £3,600 the following year. In other words you would be in ‘debt’ !!” This claim is unfounded as you have no knowledge of the performance of the investment. For example, if the investment had 10 bagged to £10,000 a withdraw of £3,600 would leave a remaining portfolio value of £6,400.

“Now tell us all how many IRRs apply to this series?”. 2 real valued IRRs. +10.00% and -187.73%. Assuming that the portfolio is not geared, it is safe to discard the second IRR as the portfolio is effectively capped at a 100% loss.

I had a look at your blog link by the way and it seems fine to me. No mention of internal rate of return though.

@Paul W

I have given this a bit of thought and I think a reasonable way to come up with a sensible portfolio return value is to divide the total current value of units sold by the cash invested. For example, taking Paul Claireaux’s 5 cashflows and adding (inventing) some unit prices gives this (rounded to 2dp, hopefully formatting will not look too horrible):

cash received unit price units bought total units FV units sold cash invested

-10000 100.00 100.00 100.00 10000

3600 110.00 -32.73 67.27 4251.52

-4310 90.00 47.89 115.16 4310

1716 125.00 -13.73 101.43 1783.37

13177 129.91 -101.43 0.00 13177.00

Total cash invested is £14,130

Total value of units sold (at current unit price) is £19,211.89

Return is £19,211.89 / £14,130 – 1 = 34.26%.

Annualised return over 4 years is (1 + 34.26%)^(1/4) – 1 = 7.64%

The 7.64% compares with 6.76% annualised unit price change and 10.00% for the internal rate of return. Had all cash been invested up front and units held until the end, all 3 rates of return would be the same.

The value I have suggested is a form of something called the Modified Internal Rate of Return (MIRR). It is superior to IRR in a number of ways, including being guaranteed to have only a single value, and I think may be a good metric to use to track portfolio return and compare with an alternative investment. I have not used it for this so could be wrong, but have used MIRR as a forecasting tool in project planning where it is recognised as being superior to IRR. You could compare the MIRR of your portfolio with that of a benchmark of similar risk, e.g. a tracker with the same timed investments and withdrawals.

@The Investor

Sorry if I have added confusion to your article, which I think is good by the way. Please feel free to delete my comments as I will not in the least be affronted. I have found thinking about the issues for calculating a rate of return for a portfolio with multiple inputs and outputs useful in any case. Some form of MIRR seems sensible to me and I am not sure why I did not suggest it in the first place!

To HRP

Aha and now we agree – the only sensible answer is 10% p.a.

As to my own blog – I don’t publish articles on IRRs for reasons well proven by this discussion. My site is about helping non experts get to grips with some basics and know where to find useful help.

I would say the excellent Monevator site is for more advanced DIY investors.

And yes, I have explained the potential upside and downside to your returns from pound cost averaging in plain English.

Now what about that riddle?

Any idea about the square root of minus 4?

Paul

@ paul claireaux

“Aha and now we agree – the only sensible answer is 10% p.a.”

On your example, I agree, but I do not agree (and have demonstrated with a simple example) that in general there is only one answer.

Whether 10% is “sensible” is not clear either. I would say that this may have flattered the return achieved because it over values the interim cash withdrawals, which is another potential problem with IRR.

“Now what about that riddle?

Any idea about the square root of minus 4?”

+/- 2 times the square root of minus 1, as I am sure you are aware.

To HRP.

Glad to be on the same page at last and yes, I accept that some random theoretical alternatives can be thrown up with IRR but do they mean anything to ordinary investors?

And yes, I agree that the IRR (with monies flowing in and out) can be very different to the average annual return on units over time and that’s precisely the lesson I offer in that article.

I’ll post the second in that series (also appeared in Investor’s Chronicle) anon.

That’s where we’re in the drawdown phase with our money – taking it all out over time – where of course the unit price path effect is the opposite to our wealth building phase.

Signing off for now – it’s been fun – and I can see you understand your numbers.

Paul

For those not aware (the square root of minus one is a complex number – otherwise known as an imaginary number known by the letter ‘i’ and it points at 90 degrees up from the normal number line . . . but that’s another story)

IRR of 10% in Paul’s example overvalues the withdrawals as if they were still invested at the same rate. This is the problem with all interim withdrawals. Each of them could be reinvested at a different rate than what’s assumed by IRR.

This is probably why it’s better long term that I’m just tracking each individual sum I invest from the time it is invested (with its own level of return that is accurate to the single sum invested). If you’ve unitised your portfolio you need only know what the current unit price is, and that automatically feeds into working out the current value of every individual investment.

Admittedly, if you invest small amounts each week or month that could get rather fiddly, but at least you have the granular data for any more complex calculations you care to do.

That said, generalising your regular investments over the course of a year down to a single lump sum would probably give good enough accuracy to be acceptable – yes, that skews in favour of sums invested later in the year but if we’re talking 20-30 year time frame minimum, I think it’s inconsequential.

To Paul W

I agree that all your investment inputs will normally enjoy a different return to their respective maturities.

And that’s where the IRR can be useful.

It shows your effective smoothed return on all your investments and if that’s no more than say 2% or 3% p.a. over the long term – it begs the question of whether all this risk and hard work is worth it – and whether you might be better leaving it on deposit with the bank or in some cautiously managed fund.

@paul

I am saying that a wthdrawal of £3600 in our example is discounted at the same rate by XIRR function. In other words: XIRR assumes that the subsequent investment of £4310 contains only £350 of “new” money. It gives the same result as if there was no withdrawal and only another investment of £350 which is £4310 – 1.1x£3600. It is a problem because in real life you would for example keep the £3600 in your savings account and have a different return over that year.

Hey Paul W.

I’ll have to make this my final word as my writing is getting behind now.

The XIRR function doesn’t assume anything.

it simply takes the cash-flows you provide to work out what ‘equivalent’ (compound and smooth) rate of return would give the same answer as your outcome.

Best wishes.

@Paul W, I understand exactly what you mean and I agree with you. The problem with IRR is that it assumes the return on cash is the same as the IRR, which is likely to be nonsense. My previous MIRR comment suffers from the same problem, so best ignore it was illegible and I have thought of a better way anyway!

A very simple calculation that can be done is to divide the total outflow of cash by the total inflow, e.g. for flows -10000, 3600, -4310, 1716, 13177 the return is

(3600 + 1716 + 13177)/(10000 + 4310) = 1.2923

That is a rate of 29.23% over 4 years, or 6.62% annual equivalent rate. That problem with this calculation is that it is the opposite of IRR – it understates the return/cost of cash (assumes it is zero). What is a good rate to use for the return on cash? It dawned on me that a good rate to use would be either RPI or CPI inflation. The return on cash roughly tracks inflation and RPI/CPI numbers are readily available from the ONS.

So to calculate the rate of return using CPI adjusted cash, do this:

1) Look up the CPI figures at the time cash flows (assume these are 100, 105, 109, 112, 113)

2) Discount the invested cash to the date of first investment using the CPI. So 10000 stays as it is and the 4310 becomes 4310*100/109 = 3954.13.

3) Forward value cash withdrawn to the point of the final withdrawal (or valuation date). 3600 becomes 3600*113/105 = 3874.29, 1716 becomes 1716*113/112 = 1731.32 and the final 13177 stays as it is.

4) Calculate the return as before (total output)/(total input)

(3874.29 + 1731.32 + 13177)/(10000 + 3954.13) = 1.3460

That is 34.6%, equivalent to 7.71% per year.

To compare with unitisation and IRR, simply adjust the calculated return by inflation or adjust the unit growth rate and IRR by inflation. e.g. IRR is 10% and the CPI went from 100 to 113, so IRR adjusted for inflation is

(1+10%)*(100/113)^(1/4) – 1 = 6.69%

This is a very simple calculation to do. It just requires looking up CPI/RPI for each cashflow. If that is too much hassle, just do it once per year as Moongrazer suggested. If net cash was invested over the year, discount the total amount for the year and treat is as input, if net cash was withdrawn, forward value it and treat as output.

@HRP

I am afraid you don’t get correct annualized return because the cash flows’ dates were ignored in your calculations. They have to be taken into account even if you assume no inflation.

@Paul W

I appreciate what you are saying, but it really depends on what interpretation is put on “money weighted return”. My proposed definition results in a convenient sleight of hand which means that the dates are actually immaterial. My definition is the weighted average growth, where the weights are the initial investment amounts. Would you agree that that would be a fair “money weighted return”? If not, ignore the rest of this comment!

Possibly the easiest way to explain why the dates are immaterial is by continuing the example. The approach is to consider the investment as a set of matching buy/sell trades and then calculate the weighted average growth on those pairs of trades.

If you assume unit prices of 100, 110, 90, 125, 129.91. The actual prices do not matter, but the last must equal the final cash flow divided by the remaining number of units in order to sell off all units at the end. You can then consider the investment to consist of a series of 4 disposals. The first 3 disposals covering the initial £10,000 and the last covering the later £4,310:

Disposal 1) 32.73 units bought for 3272.73, sold for 3600, growth 3600/3272.73 = 1.1

Disposal 2) 13.73 units bought for 1372.80, sold for 1716, growth 1372.80/1716 = 1.25

Disposal 3) 53.54 units bought for 5354.47, sold for 6955.87, growth 6955.87/5354.47 = 1.30

Disposal 4) 47.89 units bought for 4310, sold for 6221.13, growth 6221.13/4310 = 1.44

To get the weighted average growth, for each trade multiply the growth by the amount invested, add them all up and divide by the total amount invested. But multiplying the growth by amount invested gives the final trade amount, the output cash flow for the trade. In effect then the weighted average growth is the sum of the output cash flows divided by the sum of the input cash flows, which is what I suggested in the first place.

Guys, really, take it offline – you undermine the value of this BLOG with your nitty gritty theoretical debates.

Book a skype together and discuss if you really think they’re worth any more chat.

@paul

Firstly you didn’t see a problem where I pointed it out for you, then you made your final comment. Now you come back patronizing people who wanted a deeper understanding than yours and developed a discussion where it started. There are plenty of entries and comments on these blog, just stop reading these. You are winding people up by saying they undermine this blog with their comments, how ridiculous is that. And you have your own blog to worry about.

@paul claireaux

Is this your blog?

If The Investor thinks I am “undermining the value” of his blog no doubt he will say so, delete my comments and ask me to desist, which I will do happily. I do not see it as any business of yours to determine the suitability of mine or anyone else’s comments.

@The Investor, please let me know whether you think my comments are of any value and whether you would like me to continue posting. I have found thinking about this a useful exercise and will happily take it elsewhere if you prefer (I might do that anyway). My comments have certainly strayed away from unitization towards ways to calculate money weighted return, which I do appreciate was not the focus of your article.

To Paul W

Our debate was quickly resolved and resulted in a plain English explanation of IRR for this community.

The debate now between yourself and HRP is something else and looks like it could run for months with no conclusion!

As a blogger myself I understand the pain of seeing one’s carefully crafted work ignored by side discussions that go nowwhere.

Well I can’t say I’ve really understood many of the last few comments but suffice to say, based on the original article, I have now successfully unitized my portfolio and it was swimmingly simple – thanks TI!

I’ve come late to this party but here’s my opinion:

@ HRP and Paul W – thank you for your contributions. Though complex and difficult for me to understand that’s due to my own limitations not yours. You’re trying to help people and I appreciate you taking the time.

@ Paul C – please do not presume that you know what’s best for other people.

Thanks for that advice Accumulator.

I think weenie sums the debate up nicely above.

A pretty amazing thread on IRR that sheds more light on HRP’s and Paul W’s discussion:

http://www.bogleheads.org/forum/viewtopic.php?f=10&t=115030

Intense but illuminating.

A bit late on this one. Not sure if anyone still looking. Couple of things:

* Would SIPP tax relief count as newly added cash? Or part of the growth? Since it can appear many weeks or months after initial contributions, it’s quite difficult to track

* I presume it makes sense to include all assets & debts (mortgage, credit card) in the unitization calculation, since it’s one’s net worth which is the bottom line?

@algernond

Re: SIPP tax relief – yes, it would count as newly added cash, as you would presumably use it to purchase more funds within your portfolio. It isn’t growth in its own right as it is simply more of your money coming into the portfolio rather than anything your existing investments have returned.

Yes, it’s new cash but waiting for it is a problem with many SIPPs. That’s one reason why using a simple insured PPP can be a better idea for many savers who don’t want or need the massive fund choice of SIPPs

You get your tax relief invested on day 1.

@Algernond

I also treat the SIPP tax relief as funds inflow, although I don’t unitise my portfolio as discussed on this thread.

However I only treat the basic rate tax relief as funds inflow.

So, for example:

I invest £8,000 into my SIPP and buy £8,000 of funds.

A couple of months later my broker reclaims the basic rate tax of £2,000 and I buy more £2,000 funds.

At the end of the tax year HMRC give me back my £2,000 higher rate tax. I bank this and do not treat it as part of my current SIPP (even though it essentially lowers the costs of my units for unitisation purposes).

Of course, if I invest that £2,000 back directly into my SIPP I would treat it as new funds.

Assuming my funds remain at their purchase price my portfolio looks like:

£10,000 of funds for £8,000 cash in.

£2,000 increase in my cash asset held outwith my SIPP.

I’m happy to see things like this without anything more complex. But others may differ. If this thread has taught me anything it’s that everyone measures their personal performance differently!

I keep track on my net worth using individual pots – essentially house, cash, SIPP, ISA, other funds/shares. I don’t unitise at all, but if I did I think I would only do so within the SIPP, ISA, funds/shares (as three calculations, not one big one).

Again care needs to be taken. For example I’m 100% invested in equity in my SIPP, but also have cash elsewhere. So my asset allocation is 100% equities in my SIPP but much less within the net worth as a whole. Many finance blogs, etc, tacitly assume you have your whole net worth (ex house) within SIPPs, ISAs etc, and advice on asset allocation within this. I step back and view my net worth more holistically.

Hope this ramble helps!

@algernond — Personally I track what I consider my investment portfolio via a unitized process, but I do have cash outside of this (earmarked for a house deposit some day) plus 1-2 other small assets that I don’t include.

As discussed above, my primary goal with unitization is to see how I am doing versus the market and other active investors.

It doesn’t make a lot of sense for me to distort this with a big house deposit — or a mortgage or whatever, were I too have one — given that allocation to those assets would be driven by different parameters/goals.

(Currently my portfolio is by far the largest portion of my assets, as it happens, but that’s by the by. Also, if I decided to hold a big slug of cash for strategic investment reasons (which I could well be doing was cash readily yielding say 4-5% right now) then that would stay in the unitized portfolio. It’s the intention/purpose/thinking of the money that drives what I consider my investment portfolio, not the asset class, if that makes sense 🙂 ).

As others have said, if you’re more trying to see how your net worth is increasing generally over the years, it may well be more appropriate to use another return measure.

I find this interesting – I have thought about unitising my portfolio, but never really got round to it. I decided a while back to use a very simplistic approach to things so I could track my performance against my Financial Advisers.

I take a snapshot of the value of the portfolio on the 1st day of the tax year (be it ISA / Pension etc.).

At the end of the tax year, i take a snapshot of the value again.

I then add the amount i invested over the year to the original value to give me my base cost – any value above that is my return.

I apply this to both the ones I manage and the ones my FA runs, and it means we are on the same page simply. So far its not done too badly (he has beaten me this year for the first time!).

@Accumulator thank you for your comments. The Bogleheads link was interesting. I have a fair amount of experience of people getting strange results with the Excel XIRR function. It can be dangerous because management decisions can be turned on an XIRR result. For example, one course of action might imply a higher XIRR than another, which can push a decision in the wrong direction if the calculated IRRs are wrong or misleading.

The final suggestion I made for calculating a money weighted return is actually very straightforward and does not rely on Excel XIRR. all it requires is adding up inflation adjusted investment values, adding up the inflation adjusted withdrawals and dividing withdrawals by investments. I don’t believe it is any more difficult to understand or implement than unitisation and could be done with the addition of a few extra columns in a spreadsheet.

As an example, consider an active investor putting money into US equities since the end of 2008. Using the Vanguard provided returns here https://www.vanguard.co.uk/documents/adv/literature/tactical-asset-allocation-equity-and-bond.pdf it is possible to work out the £ increase in unit values of US equities from the end of 2008 to the end of 2014. This works out as 2.35 times, or 135% (15% AER). If the investor made these investments:

2008 10000

2010 10000

And these withdrawals:

2013 20000

2014 16774

Then the return without inflation adjustment is (20000 + 16774) / (10000 + 10000) = 1.8387, or about 84% (10.7% AER).

To correct the cash flows for a reasonable return on cash, using the CPI index figures:

2008 109.5

2009 112.6

2010 116.8

2011 121.7

2012 125.0

2013 127.5

2014 128.2

Calculate the 2008 value of cash invested:

2008 10000

2010 9375

And the 2014 value of cash withdrawn:

2013 20110

2014 16774

The return is then (20110 + 16774) / (10000 + 9375) = 1.9037 times, about 90% (11.3% AER)

A descriptive explanation of the above might help to understand why the calculated return value is reasonable. Imagine the investor starting off with £19,375 at the end of 2008. £10,000 is invested in US equities and £9,375 left on deposit. By the end of 2010, the £9,375 has grown to £10,000 and this is fully invested in US equities. The investor sells £20,000 of equities at the end of 2013, after a 28% increase over the year, and puts the cash on deposit. By the end of 2014, the deposit has grown to £20,110 and the remaining US investment is worth £16,774. Total portfolio value at the end of 2014 is £36,884 compared with £19,375 at the end of 2008. Divide one by the other to get the return.

The Excel XIRR figure comes out as 2.25 times, 14.5% AER. This is misleading – there is no way that the investor made a return of 125% on the 20000 invested. The IRR figure is so high because it discounts the return on cash and the return on the investments by the same amount, which is ludicrous in this example as the return on cash (CPI inflation) was much lower than the return on US equities.

I might now go and unitise my SIPP and calculate the money weighted return. It might show up whether my activity has added any value!

I should point out that most of my investments are in fixed income and that IRR is an extremely useful and important metric. For example, the yield to maturity of a bond is the IRR and I use IRR all the time in evaluating bond investments. So I am not against IRR, or even Excel’s XIRR function. I just consider IRR to be unsuitable as a portfolio return metric, amongst other things.

Hopefully this article is not long forgotten, and someone is still checking the comments. Understanding the logic above (which has been very well explained, thanks Investor), you always need to calculate the current total before you then start any calculations for adding/sub-ing.

I’d be very interested to find out what level of accuracy people use for finding out the current total? On the exact moment just before purchased? Day before purchased? Week? Month?

I’m trying to get that balance of unitizing effectively (with reg. monthly updates on a mix of dates) without constantly checking 3 different accounts, and keeping manual input in Excel to a minimum. E.G. updating only once a month would be perfect, but market volatility will cause errors to creep in.

Appericate any thoughts, or corrections where my understanding is wrong.

@IC – for my own simplification purposes, my current total is calculated on the last working day of the month. This obviously means it’s far less accurate than if I say used the exact moment I made my purchases but I’m using the unitization as merely a “guidance” of how my overall portfolio is doing.

Updating consistently just once a month is enough for me.

@weenie – thanks for the info.

Just want to quietly say, credit due, I’m loving your advice and opinion. This article is icing. Suffice to say I’ve finally escaped the niggling torpor of my long held list of 20 active funds and their eye-poking charges, and switched to a Monevator-balanced list of 7 passive. It’s taken 2 years of thinking about it (i’m kidding, it’s probably 3) but finally in progress, I feel sure sense of relief. I say in progress because Best Invest have made a hash of the switch, but I was half expecting that. Anyway, thanks for the help. Unitization ahoy, can’t wait for the weekend 😉

Hi guys

Great article. I have a question if i may…..

when you value your original portfolio do you include cash not invested ie just sitting in isa account???

At last I’ve got round to unitising my portfolio following your guide here. I‘ve gone back over 9 years of records for my isa and sipp and can see how my highish yield portfolio has performed.

Only now it has struck me that comparing it to the FTSE100 is not a good like for like, as any dividends have always been reinvested. While historical prices are easy enough to download for the FTSE100, I think I need a to compare against a total return FTSE100 index. However I haven’t found a website with daily downloadable data. Can anyone suggest where this data is available……freely?

I’ve just found this article and tracking my portfolio has always been a huge error filled mess. I track all things financial in google sheets, does anybody have an example spreadsheet/template that could assist me with this? I’ve tried to make one myself but im awful at excel.

“However if you did want to track how particular accounts are doing … then you could create separate spreadsheets to follow them.

…

Remember, you’d still want to unitize the entire portfolio to properly track your overall returns…”

Any thoughts on how best to do this? I’ve unitised three separate accounts, with total value and unit value at the end of every calendar month for each, but I’m not sure how to combine them into a single total unit value for each month.

My first thought is it’s something like this, but I’m not sure if this would be correct:

(

(Fund1Total£ * Fund1UnitValue)

+ (Fund2Total£ * Fund2UnitValue)

+ (Fund3Total£ * Fund3UnitValue)

) /

(Fund1Total£ + Fund2Total£ + Fund3Total£)

After trying some examples out in spreadsheets, I think that maybe using “total number of units” instead of “total £” in the above equation makes more sense. So:

(

(Fund1NumUnits * Fund1UnitValue)

+ (Fund2NumUnits * Fund2UnitValue)

+ (Fund3NumUnits * Fund3UnitValue)

) /

(Fund1NumUnits + Fund2NumUnits + Fund3NumUnits)

But I’m not sure how to verify whether this is accurate or not. Any thoughts appreciated!