Join Early Retirement Today
Thread Tools Search this Thread Display Modes
Time-Weighted Return
Old 02-20-2013, 11:33 AM   #1
Recycles dryer sheets
Join Date: Nov 2011
Posts: 74
Time-Weighted Return

I'm curious whether folks here calculate a time-weighted return for their total portfolio. As differentiated from money (dollar) -weighted return -- e.g. XIRR formula in MS Excel -- the time-weighted return calculation sanitizes for the timing of external money flows -- cash deposits and withdrawals. It is a more involved and time-consuming calculation, but has the benefit of allowing for direct performance comparison with benchmark returns.

If you calculate time-weighted return for your portfolio:
- what do you use it for? why do you bother?
- how often do you calculate it?
- what method do you use (true time-weighted, modified dietz, simple dietz, etc.)?
- do you use MS Excel to do this or some other program / web site?

523HRR is offline   Reply With Quote
Join the #1 Early Retirement and Financial Independence Forum Today - It's Totally Free!

Are you planning to be financially independent as early as possible so you can live life on your own terms? Discuss successful investing strategies, asset allocation models, tax strategies and other related topics in our online forum community. Our members range from young folks just starting their journey to financial independence, military retirees and even multimillionaires. No matter where you fit in you'll find that is a great community to join. Best of all it's totally FREE!

You are currently viewing our boards as a guest so you have limited access to our community. Please take the time to register and you will gain a lot of great new features including; the ability to participate in discussions, network with our members, see fewer ads, upload photographs, create a retirement blog, send private messages and so much, much more!

Old 02-20-2013, 01:03 PM   #2
Recycles dryer sheets
Join Date: May 2012
Posts: 84
Too much work since money is spread among firms and banks. We have a specific target of assets each year based on our contributions and very modest expected returns.

hlfo718 is offline   Reply With Quote
Old 02-20-2013, 03:02 PM   #3
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
pb4uski's Avatar
Join Date: Nov 2010
Location: Vermont & Sarasota, FL
Posts: 13,198
I use XIRR when assessing return. IMO XIRR takes both cash flow and time into account since it is the interest rate that equates the beginning value and cash flow to the ending value.
If something cannot endure laughter.... it cannot endure.
Patience is the art of concealing your impatience.
pb4uski is online now   Reply With Quote
Old 02-20-2013, 06:07 PM   #4
Recycles dryer sheets
Join Date: Dec 2011
Posts: 388
Quicken does it for me.
Khufu is offline   Reply With Quote
Old 02-20-2013, 06:26 PM   #5
Thinks s/he gets paid by the post
Join Date: Mar 2009
Posts: 1,160
Since almost all of my portfolio is in mutual funds and cash I simply take the weighted avg return of my holdings. For my purposes that's close enough. I compare that to my VG and Fido reports which confirm my numbers within a tenth of a %. One year end calculation that takes less than 10 minutes.
"What's the worst thing that could happen - I keep my job."
foxfirev5 is offline   Reply With Quote
Old 02-21-2013, 10:54 AM   #6
Thinks s/he gets paid by the post
Join Date: Jul 2005
Posts: 3,805
No matter how you do it, and XIRR seems fine, you need to have the same cash flows in and out of your benchmark in order to fairly compare them. Still possible with a spreadsheet and historical fund prices, but a bit more work.
Animorph is offline   Reply With Quote
Old 02-22-2013, 03:11 PM   #7
Recycles dryer sheets
FinancialDave's Avatar
Join Date: Nov 2012
Location: Olympia
Posts: 103
I recently tried most all of the formulas including XIRR (with many different time periods) for my 2012 return in my 401k. Fidelity puts out a Personal Rate of Return number that they say accounts for cash flows, but even when I downloaded all my transactions from the website, the closest I got to the 26.6% reported by Fidelity was a 33% number from the XIRR analysis. After a couple of phone calls to Fidelity and their explanation, I had to conclude that none of them really knew how the calculation was performed.

In the end I just put all my investments into a Morningstar Portfolio and track the parameters that way.

FinancialDave is offline   Reply With Quote
Old 02-23-2013, 11:52 AM   #8
Recycles dryer sheets
Join Date: Nov 2011
Posts: 74

Thanks. I too have spoken with the rep at Fidelity about their reporting of returns and he ended up agreeing that they don't really provide a true total rate of return at the account level. Disappointing.

However, I have found for my Schwab accounts, they provide some very useful portfolio performance reporting....providing capability to select either time-weighted return or personal (dollar-weighted) return. You can select an individual account or aggregate multiple accounts and also choose a particular time period for calculation. This makes it very useful for comparing performance against benchmark returns. Their calculations tie in nicely to my own calculation is MS Excel.

523HRR is offline   Reply With Quote

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


All times are GMT -6. The time now is 07:26 PM.
Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2016, vBulletin Solutions, Inc.