Understanding Portfolio Return

 Posts: 16
 Joined: Thu Jun 22, 2017 11:49 am
Understanding Portfolio Return
Hi.
I read this wiki page about the various returns but have some more questions. I understand the investor (aka moneyweighted) return well. My question is on the portfolio (aka timeweighted) return.
I started writing out an example to illustrate my question but then realized it would be easier to reference a spreadsheet. Please see here. The spreadsheet shows a simple exercise with a hypothetical portfolio consisting of two asset classes.
To ensure that I understand this, am I calculating the portfolio return correctly? In my spreadsheet, I calculate this per day: (today's balance  yesterday's balance  inflows + outflows) / yesterday's balance. Then, I sum all of the percentages to achieve the YTD portfolio return.
Thanks.
I read this wiki page about the various returns but have some more questions. I understand the investor (aka moneyweighted) return well. My question is on the portfolio (aka timeweighted) return.
I started writing out an example to illustrate my question but then realized it would be easier to reference a spreadsheet. Please see here. The spreadsheet shows a simple exercise with a hypothetical portfolio consisting of two asset classes.
To ensure that I understand this, am I calculating the portfolio return correctly? In my spreadsheet, I calculate this per day: (today's balance  yesterday's balance  inflows + outflows) / yesterday's balance. Then, I sum all of the percentages to achieve the YTD portfolio return.
Thanks.

 Posts: 2684
 Joined: Sun Jan 08, 2017 12:25 pm
Re: Understanding Portfolio Return
you mean XIRR?

 Posts: 3288
 Joined: Sat Aug 11, 2012 8:44 am
Re: Understanding Portfolio Return
To calculate a daily return, I would attribute half of the cash flows to yesterday and half to today:football236 wrote: ↑Wed Nov 21, 2018 10:42 amHi.
I read this wiki page about the various returns but have some more questions. I understand the investor (aka moneyweighted) return well. My question is on the portfolio (aka timeweighted) return.
I started writing out an example to illustrate my question but then realized it would be easier to reference a spreadsheet. Please see here. The spreadsheet shows a simple exercise with a hypothetical portfolio consisting of two asset classes.
To ensure that I understand this, am I calculating the portfolio return correctly? In my spreadsheet, I calculate this per day: (today's balance  yesterday's balance  inflows + outflows) / yesterday's balance. Then, I sum all of the percentages to achieve the YTD portfolio return.
Thanks.
(today's balance  (inflows  outflows) / 2) / (yesterday's balance + (inflows  outflows) / 2)  1
But, why stop at daily returns? Why not calculate hourly returns, or returns for every minute, second, or fraction of a second?
Generally, a monthly return is sufficient. That's what mutual funds and ETFs report. That's also what the spreadsheet in the linked wiki page does using a single monthly calculation with half the cash flows attributed to the beginning, and half to the end of the month.
Bogleheads investment philosophy  singleETF balanced portfolio  VBAL

 Posts: 16
 Joined: Thu Jun 22, 2017 11:49 am
Re: Understanding Portfolio Return
Thanks for replying, PFInterest and longinvest.
PFInterest, I'm referring to the portfolio return (aka timeweighted return or comparable return) mentioned on the wiki page I linked to earlier.
Yes, good point about flows, longinvest.
Also, agreed about the time period, longinvest. I put daily dates in just for illustrative purposes (I would never track my investments on a daily basis) but updated the spreadsheet to show monthend dates per your suggestion.
Now, I updated the spreadsheet with the previous state in the "Previous State 1" tab and a new scenario in the "Current State" tab. The portfolio balance rises on 1/31/18 and returns to the starting (12/31/17) balance on 2/28/18. Yet, the calculation still shows a positive YTD portfolio return of 0.99%. Assuming the calculation is correct, how can we explain that?
Mathematically, I understand why the YTD portfolio is not zero. There is a gain of $110 one month and a loss of $110 the next, but the loss comes off a larger portfolio balance and thus smaller negative percentage.
However, intuitively, it doesn't make sense to me that there's a positive YTD portfolio return even though the balance returned to the original balance.
PFInterest, I'm referring to the portfolio return (aka timeweighted return or comparable return) mentioned on the wiki page I linked to earlier.
Yes, good point about flows, longinvest.
Also, agreed about the time period, longinvest. I put daily dates in just for illustrative purposes (I would never track my investments on a daily basis) but updated the spreadsheet to show monthend dates per your suggestion.
Now, I updated the spreadsheet with the previous state in the "Previous State 1" tab and a new scenario in the "Current State" tab. The portfolio balance rises on 1/31/18 and returns to the starting (12/31/17) balance on 2/28/18. Yet, the calculation still shows a positive YTD portfolio return of 0.99%. Assuming the calculation is correct, how can we explain that?
Mathematically, I understand why the YTD portfolio is not zero. There is a gain of $110 one month and a loss of $110 the next, but the loss comes off a larger portfolio balance and thus smaller negative percentage.
However, intuitively, it doesn't make sense to me that there's a positive YTD portfolio return even though the balance returned to the original balance.

 Posts: 3288
 Joined: Sat Aug 11, 2012 8:44 am
Re: Understanding Portfolio Return
I looked at your spreadsheet. I see the problem. The cumulative 2month return is incorrectly calculated. Here's how to do that.football236 wrote: ↑Sat Nov 24, 2018 9:42 amThanks for replying, PFInterest and longinvest.
PFInterest, I'm referring to the portfolio return (aka timeweighted return or comparable return) mentioned on the wiki page I linked to earlier.
Yes, good point about flows, longinvest.
Also, agreed about the time period, longinvest. I put daily dates in just for illustrative purposes (I would never track my investments on a daily basis) but updated the spreadsheet to show monthend dates per your suggestion.
Now, I updated the spreadsheet with the previous state in the "Previous State 1" tab and a new scenario in the "Current State" tab. The portfolio balance rises on 1/31/18 and returns to the starting (12/31/17) balance on 2/28/18. Yet, the calculation still shows a positive YTD portfolio return of 0.99%. Assuming the calculation is correct, how can we explain that?
Mathematically, I understand why the YTD portfolio is not zero. There is a gain of $110 one month and a loss of $110 the next, but the loss comes off a larger portfolio balance and thus smaller negative percentage.
However, intuitively, it doesn't make sense to me that there's a positive YTD portfolio return even though the balance returned to the original balance.
If a monthly return sequence is +10.48%, 9.48%, the cumulative twomonths return is:
(1 + 10.48%) X (1  9.48%)  1 = 0%
Bogleheads investment philosophy  singleETF balanced portfolio  VBAL
 patrick013
 Posts: 2517
 Joined: Mon Jul 13, 2015 7:49 pm
Re: Understanding Portfolio Return
Here's a spreadsheet I'm kinda familiar with. It just accounts for
the number of shares, contributions and withdrawals, then calc's
an IRR for the ending balance which could be months or years of
transactions. You would need a separate sheet for each asset class.
Might help might not.
the number of shares, contributions and withdrawals, then calc's
an IRR for the ending balance which could be months or years of
transactions. You would need a separate sheet for each asset class.
Might help might not.
age in bonds, buyandhold, 10 year business cycle

 Posts: 16
 Joined: Thu Jun 22, 2017 11:49 am
Re: Understanding Portfolio Return
Ah, good catch, longinvest. That makes sense. I corrected my spreadsheet now, and the portfolio return is 0%.
By the way, I just wanted to say thank you for building and maintaining the spreadsheet on the wiki page. I created this one not to use for tracking performance but instead just to understand how portfolio return is calculated, which I do now.
Thanks, patrick013, but that calculates IRR (aka investor return or moneyweighted return), which I find to be less useful. I need the portfolio return to compare against standard indices.
By the way, I just wanted to say thank you for building and maintaining the spreadsheet on the wiki page. I created this one not to use for tracking performance but instead just to understand how portfolio return is calculated, which I do now.
Thanks, patrick013, but that calculates IRR (aka investor return or moneyweighted return), which I find to be less useful. I need the portfolio return to compare against standard indices.
 patrick013
 Posts: 2517
 Joined: Mon Jul 13, 2015 7:49 pm
Re: Understanding Portfolio Return
Right, it extends the investor return a bit. For portfolio return I'd befootball236 wrote: ↑Sat Nov 24, 2018 3:02 pmThanks, patrick013, but that calculates IRR (aka investor return or moneyweighted return), which I find to be less useful. I need the portfolio return to compare against standard indices.
happy with the published annual return(s) for that. The wiki injects
contributions and withdrawals in random places so the timing of
returns compared to the published figures is going to be different.
That may be exactly what you want to show returns without DCA
or withdrawals.
age in bonds, buyandhold, 10 year business cycle

 Posts: 16
 Joined: Thu Jun 22, 2017 11:49 am
Re: Understanding Portfolio Return
patrick013 wrote: ↑Sat Nov 24, 2018 3:30 pmRight, it extends the investor return a bit. For portfolio return I'd befootball236 wrote: ↑Sat Nov 24, 2018 3:02 pmThanks, patrick013, but that calculates IRR (aka investor return or moneyweighted return), which I find to be less useful. I need the portfolio return to compare against standard indices.
happy with the published annual return(s) for that. The wiki injects
contributions and withdrawals in random places so the timing of
returns compared to the published figures is going to be different.
That may be exactly what you want to show returns without DCA
or withdrawals.
But that's my reason for digging into this. Published returns are not sufficient for two reasons, right?
 We need the return across our entire portfolio, not just for the individual funds/ETFs we hold.
 For those of us that are in the accumulation phase of life, we're buying in at various times of the year. This will cause our portfolio return to diverge from the published returns of the funds we hold.