|
02-20-2013, 11:33 AM
|
#1
|
Recycles dryer sheets
Join Date: Nov 2011
Posts: 185
|
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?
|
|
|
|
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 Early-Retirement.org 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!
|
02-20-2013, 01:03 PM
|
#2
|
Recycles dryer sheets
Join Date: May 2012
Posts: 90
|
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.
|
|
|
02-20-2013, 03:02 PM
|
#3
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Nov 2010
Location: Sarasota, FL & Vermont
Posts: 36,373
|
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.
Slow and steady wins the race.
Retired Jan 2012 at age 56
|
|
|
02-20-2013, 06:07 PM
|
#4
|
Recycles dryer sheets
Join Date: Dec 2011
Posts: 388
|
Quicken does it for me.
|
|
|
02-20-2013, 06:26 PM
|
#5
|
Thinks s/he gets paid by the post
Join Date: Mar 2009
Posts: 2,985
|
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.
__________________
Took SS at 62 and hope I live long enough to regret the decision.
|
|
|
02-21-2013, 10:54 AM
|
#6
|
Thinks s/he gets paid by the post
Join Date: Jul 2005
Posts: 4,366
|
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.
|
|
|
02-22-2013, 03:11 PM
|
#7
|
Recycles dryer sheets
Join Date: Nov 2012
Location: Olympia
Posts: 150
|
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.
Dave
|
|
|
02-23-2013, 11:52 AM
|
#8
|
Recycles dryer sheets
Join Date: Nov 2011
Posts: 185
|
FinancialDave....
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.
|
|
|
|
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
|
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
» Recent Threads
|
|
|
|
|
|
|
|
|
|
|
|
|
» Quick Links
|
|
|