Join Early Retirement Today
Reply
 
Thread Tools Display Modes
How to track your portfolio gains&losses correctly?
Old 10-18-2009, 02:16 PM   #1
Recycles dryer sheets
 
Join Date: Sep 2009
Posts: 353
How to track your portfolio gains&losses correctly?

People often talk about how many % their portfolio is making vs some benchmark, like S&P500. I wonder how you track it and more specifically, how do you account for
- additions
- withdrawals
- taxes
- dividends / distributions

For example, say you started Jan 1'2008 with $10,000 in your portfolio and you ended it with $12,000. During this time, you had:
- added $100 per month
- withdrew $1000 for some purchases
- paid $500 in portfolio-related taxes out of you liquid savings
- got $15 dividend 4 times a year
How much did your investment skills really give you for proper comparison with a benchmark?

I suppose one way would be to do as follows. Create a fake portfolio with your benchmark, and keep track of both portfolios:
- for every check you get from your job (if tracking your NW) or more generally, for every addition to your portfolio you are tracking, imagine you invested it in your benchmark (e.g. S&P500) with the closing price on the same date
- for every withdrawal, including taxes for the portfolio you are tracking, imagine you sold the benchmark at the closing price on the date before
- make sure your benchmark's dividends are reinvested and are paid on that number of shares you would have held at that ex-dividend date
- all dividends / distributions from your real portfolio have to stay "inside" it or you have to adjust for them as "withdrawals" otherwise.

I started doing something similar with my investment portfolio but quickly this became unmanageable for me even though I am not trading that often. In part, this was hard because figuring out taxes is somewhat of a pain. Also a simple S&P500 benchmark is not a good one since I have a high percentage of non large-cap non-US investments and tracking multiple indecies is harder with above approach. I suppose it's all doable in the end but quite time consuming.

What do you do?
smjsl 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 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!

Old 10-18-2009, 04:07 PM   #2
Thinks s/he gets paid by the post
 
Join Date: Jul 2005
Location: Los Angeles area
Posts: 1,708
I keep all transactions, dividends, tax info etc. (since 1993) in an Excel file. Pretty easy to calculate IRRs, match shares sold to those bought, whatever is needed. Every once in a while I need to add a new column or page, like for calculating my 72t withdrawals a few years ago.

I use the SP500 as my benchmark, since I almost exclusively invest in large US companies.
__________________
learn, work, save, invest, fire
CyclingInvestor is offline   Reply With Quote
Old 10-18-2009, 04:17 PM   #3
Moderator Emeritus
 
Join Date: May 2007
Posts: 12,894
I use Quicken and double check with Excel. Both use the XIRR method to calculate returns.
FIREd is offline   Reply With Quote
Old 10-18-2009, 05:01 PM   #4
Administrator
Alan's Avatar
 
Join Date: Jul 2005
Location: N. Yorkshire
Posts: 34,050
Quote:
Originally Posted by CyclingInvestor View Post
I keep all transactions, dividends, tax info etc. (since 1993) in an Excel file. Pretty easy to calculate IRRs, match shares sold to those bought, whatever is needed. Every once in a while I need to add a new column or page, like for calculating my 72t withdrawals a few years ago.

I use the SP500 as my benchmark, since I almost exclusively invest in large US companies.
This is what I do to track ins/outs and to calculate IRR.

I don't compare against a benchmark as such. I compare against what the VG portfolio analysis says I can historically expect for my particular mix.
Attached Images
File Type: jpg portfolio analysis.JPG (100.5 KB, 32 views)
__________________
Retired in Jan, 2010 at 55, moved to England in May 2016
Enough private pension and SS income to cover all needs
Alan is offline   Reply With Quote
Old 10-18-2009, 05:26 PM   #5
Recycles dryer sheets
 
Join Date: Sep 2009
Posts: 353
Thank you for the replies and pointing me to the XIRR function. 2 follow up questions:

(1) To make sure I understand how to use XIRR, given my original example, is the following the correct set of values for XIRR inputs (I understand I need dates for this sequence too and the final numbers would be sorted chronologically):
-$10,000 (initial investment)
-$100 (additional money: listed 12 times for 12 months)
+$1000 (withdrawal should be positive money)
+$500 (taxes paid - should be treated as withdrawal at the date of tax payment)
+$15 (listed 4 times for the 4 quarterly non-reinvested dividends, but if they were reinvested they would not appear on the list)
+$12000 (final or current amount, which MUST NOT include non-reinvested dividends and other withdrawals listed above)

(2) I am still unclear on how you then compare with a benchmark (for those that do)? Do you manually compute the fake portfolio based on dollar numbers and dates of your real portfolio? For example, would not you need to calculate how many shares of your benchmark you are buying and selling each time and how many dividends you would get as a result, even if they are reinvested...?
smjsl is offline   Reply With Quote
Old 10-18-2009, 05:41 PM   #6
Administrator
Alan's Avatar
 
Join Date: Jul 2005
Location: N. Yorkshire
Posts: 34,050
Quote:
Originally Posted by smjsl View Post
Thank you for the replies and pointing me to the XIRR function. 2 follow up questions:

(1) To make sure I understand how to use XIRR, given my original example, is the following the correct set of values for XIRR inputs (I understand I need dates for this sequence too and the final numbers would be sorted chronologically):
-$10,000 (initial investment)
-$100 (additional money: listed 12 times for 12 months)
+$1000 (withdrawal should be positive money)
+$500 (taxes paid - should be treated as withdrawal at the date of tax payment)
+$15 (listed 4 times for the 4 quarterly non-reinvested dividends, but if they were reinvested they would not appear on the list)
+$12000 (final or current amount, which MUST NOT include non-reinvested dividends and other withdrawals listed above)

(2) I am still unclear on how you then compare with a benchmark (for those that do)? Do you manually compute the fake portfolio based on dollar numbers and dates of your real portfolio? For example, would not you need to calculate how many shares of your benchmark you are buying and selling each time and how many dividends you would get as a result, even if they are reinvested...?
For (1) - yes, that is the way to use the XIRR function.

for (2) - I personally don't feel I need that level of accuracy - way too much effort for me.
__________________
Retired in Jan, 2010 at 55, moved to England in May 2016
Enough private pension and SS income to cover all needs
Alan is offline   Reply With Quote
Old 10-18-2009, 05:59 PM   #7
Moderator Emeritus
 
Join Date: May 2007
Posts: 12,894
I mostly invest in index funds, so I know that each one of my funds tracks its respective index fairly well. As far as my overall portfolio goes, the only benchmark I care about is my long term target return of 8% per year.
FIREd is offline   Reply With Quote
Old 10-18-2009, 05:59 PM   #8
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
 
Join Date: Jul 2006
Posts: 11,401
My statements include the appropriate benchmarks, which makes that relatively easy.
Meadbh is offline   Reply With Quote
Old 10-18-2009, 10:22 PM   #9
Thinks s/he gets paid by the post
 
Join Date: Jul 2005
Location: Los Angeles area
Posts: 1,708
Quote:
Originally Posted by smjsl View Post
(2) I am still unclear on how you then compare with a benchmark (for those that do)? Do you manually compute the fake portfolio based on dollar numbers and dates of your real portfolio? For example, would not you need to calculate how many shares of your benchmark you are buying and selling each time and how many dividends you would get as a result, even if they are reinvested...?
Much simpler. I actually use SPY as my benchmark. Each quarter I use Yahoo's historical data to provide me with the change in SPY's price, plus the dividend. For example, SPY closed at 91.95 on June 30 2009, 105.59 on Sept 30 2009, and paid a dividend of $0.508 on Sept 18 2009 when it closed at 106.72, so I consider my benchmark's return to be (105.59-91.95)/91.95 + 0.508/106.72 = 15.3%. Since I already have my own IRR, it is easy to compare.
__________________
learn, work, save, invest, fire
CyclingInvestor is offline   Reply With Quote
Old 10-18-2009, 10:34 PM   #10
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
audreyh1's Avatar
 
Join Date: Jan 2006
Location: Rio Grande Valley
Posts: 38,002
I actually own shares in my benchmark. I use a balanced fund as a benchmark. When I was building my portfolio, I was adding to the benchmark at the same times. That makes it easy to track.

You could do the same with an index ETF.

I use Quicken to do most of my tracking and performance reporting.

Audrey
audreyh1 is online now   Reply With Quote
Old 10-19-2009, 12:46 AM   #11
Recycles dryer sheets
 
Join Date: Sep 2009
Posts: 353
I am sorry I am not being clear here (or maybe it's late ;-) )... I am trying to understand how to account for inflows/outflow into/out of the portfolio.

Meadbh, CyclingInvestor, please correct me if I am wrong but I don't think your methods are correct if you consider additions / withdrawal / etc.

Meadbh, I assume you mean that your brokerage sends you your benchmark changes in your statements. But if you deposited $1000 in the middle of the month, I asume they will not adjust their benchmark computation "portfolio" for that (see below).

CyclingInvestor, same thing. In your example, if you deposited $1000 on Sept 15, you'd have to make the adjustment for buying SPY at the same time when you compare to how your porfolio changed during same June 30 - today period. Also, you'd get more dividends then in your S&P500 portfolio than if you deposited $1000 on Sept 20.

Same applies to withdrawing a $1000 from your portfolio (including taxes).

So again, if you are trying to see if you are doing any better than SPY and by how much, I think you have to pretend you are really doing everything with SPY in terms of any incoming/outgoing funds into/from your portfolio. Otherwise, it's not apples-to-apples... Maybe there is a simple way, but I don't see it quite yet.

Audreyh1, your message actually was in part what inspired this thread ;-) You mentioned elsewhere that you are doing better than the benchmarks, which means you have funds outside of your benchmarks in your portfoio... but again owning a benchmark does not seem to account for above unless you distribute and withdraw all funds in exact same proportions. So, if your portfolio has 60% of funds in your benchmark and 40% outside of benchmark, any new $1000 has to go 60% into benchmark and 40% to other funds, and vice versa, any $1000 withdrawal has to come out as $600 out of your benchmark and $400 out of other part of the portfolio. Otherwise, I don't think you can base your comparison based on benchmarks changed vs overall portfolio.

Example:

T1 prices: myFund $10, myBenchmark $10.
Say you start with $1000 as 100 shares in myFund. (Or you could have had 100 shares of myBenchmark for comparison)

T2 prices: myFund $50, myBenchmark $5.
Say you added $500 to myFund with 10 shares $50 each; so now you have 110 shares of myFund. (Or you could have added 100 shares of myBenchmark and now had 200 shares of it.)

T3 prices (today): myFund $10, myBenchmark $10.
Now, your total is: 110*$10=$1100 (10% over initial amount and $400 less than overall $1500 invested). In any case however, what do you compare this myFund performance with? If you compare this with benchmark increase without accounting for T2 transaction, you would see 0% increase in myBenchmark, but if you actually invested in benchmark, you would have had $2000 now, or 33% increase over $1500 invested!

Final thought: perhaps for those of you already retired, your portfolio size is so large and your withdrawals (including taxes) and additions to it are so small that they do not make much difference... but for me, where both withdrawals and additions are large relative to the size of the portfolio, it makes a big difference...
smjsl is offline   Reply With Quote
Old 10-19-2009, 05:38 AM   #12
Confused about dryer sheets
 
Join Date: Oct 2006
Posts: 7
The question is: Does it really matter? Of course we all want to see it go up. But comparing it to a benchmark, WHY? It only matters that it is making more than I am spending, or/and that I am happy with the results. If neither of those are happening, then I need to worry about what it is doing and decide what to do about it.

I do track it, but rather simply in XL spreadsheet, start with jan 1 balance add and substract additions and withdrawls, then just compute % on current balance. Sure it may be off, but it is the BALANCE that I really keep track of, not the %.
Brand New Day is offline   Reply With Quote
Old 10-19-2009, 08:03 AM   #13
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
audreyh1's Avatar
 
Join Date: Jan 2006
Location: Rio Grande Valley
Posts: 38,002
Quote:
Originally Posted by smjsl View Post
Audreyh1, your message actually was in part what inspired this thread ;-) You mentioned elsewhere that you are doing better than the benchmarks, which means you have funds outside of your benchmarks in your portfoio... but again owning a benchmark does not seem to account for above unless you distribute and withdraw all funds in exact same proportions. So, if your portfolio has 60% of funds in your benchmark and 40% outside of benchmark, any new $1000 has to go 60% into benchmark and 40% to other funds, and vice versa, any $1000 withdrawal has to come out as $600 out of your benchmark and $400 out of other part of the portfolio. Otherwise, I don't think you can base your comparison based on benchmarks changed vs overall portfolio.
I was simply doing some spreadsheet "tests" to see if I could guess my portfolio performance from the S&P500. It turns out I really can't. Not surprising - my equity funds altogether are much more widely diversified than the S&P500. I was really amazed at the initial outperformance.

So - I don't use the S&P500 as my benchmark. I was just posting some info I had recently calculated out of curiosity on the S&P500 thread.

I had the spreadsheets for my calculations on the two different dates that I rebalanced my portfolio plus the current values. I simply took the total equity dollar amount on each of those dates, calculated the growth %, and compared against the S&P500 closing value on those dates. So it didn't take into account and S&P500 dividends paid out during those times, but since the yield is fairly low and time periods were not that long it probably doesn't make a huge difference.

Other than the rebalancing on those dates, I had not made any additions or withdrawals, so that made my calculations easy.

Audrey
audreyh1 is online now   Reply With Quote
Old 10-19-2009, 08:12 AM   #14
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
audreyh1's Avatar
 
Join Date: Jan 2006
Location: Rio Grande Valley
Posts: 38,002
I generally use the Quicken ROI calculation to calculate performance numbers for my portfolio. This does a reasonable job of handling withdrawals and additions IMO.

Audrey
audreyh1 is online now   Reply With Quote
Old 10-19-2009, 09:06 AM   #15
Thinks s/he gets paid by the post
walkinwood's Avatar
 
Join Date: Jul 2006
Location: Denver
Posts: 3,504
smjsl,

Why not compare your individual fund performance to their benchmarks. I think that achieves the same thing that you're trying to do with a lot less complexity.

The only way I can think off to accomplish what you're doing is to create a second portfolio as you have already tried. To me, it doesn't seem worth the effort.
walkinwood is offline   Reply With Quote
Old 10-19-2009, 10:10 AM   #16
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
 
Join Date: Jul 2006
Posts: 11,401
Quote:
Originally Posted by smjsl View Post
Meadbh, I assume you mean that your brokerage sends you your benchmark changes in your statements. But if you deposited $1000 in the middle of the month, I asume they will not adjust their benchmark computation "portfolio" for that (see below).
I get quarterly written statements. Online access does not show benchmarks. As far as I know, returns are calculated based on weighted asset allocation over time. As for checking on this every month, that's too much noise.
Meadbh is offline   Reply With Quote
Old 10-19-2009, 04:14 PM   #17
Recycles dryer sheets
 
Join Date: Sep 2009
Posts: 353
Thanks for responses.

@Brand New Date, @walkinwood: the point of the exercise is to see whether I should stick everything into benchmark as soon as I get it without price considerations or try doing something outside of it by doing stock/fund picks and/or timing of purchases. It would be nice to prove to yourself that any "active" management you do (including both investment selection and timings of those selections) is better than the benchmark.

And since I see different posts talking about how people did compared to S&P500 or some other benchmark, I wanted to know how the comparison can be done... Of course, if you don't have any additions / withdrawals, it's easier - also probably means it does not include tax effects or that the person concluded that tax effects would be the same.. speaking of which, Audreyh1, even though you did not have withdrawals during the time periods you looked at, presumably you would still have to pay taxes for that period. Your rebalancing act may have triggered some taxes that would be smaller or greater than if you had everything in S&P500... then again, perhaps it's all in a tax-sheltered account.
smjsl is offline   Reply With Quote
Old 10-19-2009, 05:02 PM   #18
Moderator Emeritus
 
Join Date: May 2007
Posts: 12,894
If I understand how the XIRR calculation works, I don't think you have to get very crafty to compare your results to a benchmark. The calculation returns an annual rate of return that can be interpreted as follows:

Let's say you started investing in 2000. During the years you made contributions and withdrawals to your accounts. Excel says your XIRR over this period is 8% a year. What it means is that if, instead of investing your money in stocks and bonds and whatever, you invested it in a savings accounts paying a fixed 8% a year in interests, you would have exactly the same amount of money today. So by calculating the XIRR, you already benchmark your returns so to speak. The only thing you have to figure out is whether or not that benchmark beats the annualized return for the S&P over that period of time (S&P today-S&P in 2000+dividends). You do not have to take cash flow in and out of the S&P into account in order to make that comparison. You should be able to compare your XIRR to any published S&P annualized return.
FIREd is offline   Reply With Quote
Old 10-19-2009, 05:09 PM   #19
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
audreyh1's Avatar
 
Join Date: Jan 2006
Location: Rio Grande Valley
Posts: 38,002
Quote:
Originally Posted by smjsl View Post
Audreyh1, even though you did not have withdrawals during the time periods you looked at, presumably you would still have to pay taxes for that period. Your rebalancing act may have triggered some taxes that would be smaller or greater than if you had everything in S&P500... then again, perhaps it's all in a tax-sheltered account.
No, as it happens, during those time periods it didn't trigger taxes even though it was all in a taxable account. I happened to have enough losses to counteract gains.

Audrey
audreyh1 is online now   Reply With Quote
Old 10-19-2009, 05:28 PM   #20
Recycles dryer sheets
 
Join Date: Sep 2009
Posts: 353
Quote:
Originally Posted by FIREdreamer View Post
If I understand how the XIRR calculation works, I don't think you have to get very crafty to compare your results to a benchmark. The calculation returns an annual rate of return that can be interpreted as follows:

Let's say you started investing in 2000. During the years you made contributions and withdrawals to your accounts. Excel says your XIRR over this period is 8% a year. What it means is that if, instead of investing your money in stocks and bonds and whatever, you invested it in a savings accounts paying a fixed 8% a year in interests, you would have exactly the same amount of money today. So by calculating the XIRR, you already benchmark your returns so to speak. The only thing you have to figure out is whether or not that benchmark beats the annualized return for the S&P over that period of time (S&P today-S&P in 2000+dividends). You do not have to take cash flow in and out of the S&P into account in order to make that comparison. You should be able to compare your XIRR to any published S&P annualized return.
Not quite FIREdreamer. You are comparing your real 8% return from XIRR to "overall" return of S&P500 instead of what your particular return in S&P500 would have been. If you take a look at my example with T1, T2, T3 timestamps in earlier post, the benchmark's return is 0% overall but if you invested in it INSTEAD OF investing in your own fund, you would get a 33% return over invested amount (exact XIRR for it would be different of course depending on the relative T1/T2/T3 timings).

Put it another way, look at the past year - if you got 8% overall return during the year but you happened to invest a lot of money from incoming new funds in March, you really underperformed S&P500 benchmark (i.e. you would be much better off investing in SPY instead of doing your own thing); but if you invested most of your money a year ago, your results would be much closer to S&P500. The 8% XIRR return takes into account your actions and timing over the period and to compare it with S&P500 you have to really match it with what you would get from S&P500 using the same additional and withdrawn funds at the same times... (Note: I am talking about additional funds to your overall portfolio and withdrawals from your portfolio like taxes... funds that you sell but stay within your portfolio do not affect the benchmark portfolio since that is just your own market timing.)
smjsl is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Am I reading this correctly? LRAO FIRE and Money 1 04-16-2009 08:41 AM
Stock Market Losses vs. Home Equity Losses stephenandrew FIRE and Money 17 03-03-2009 06:21 PM
cap gains & losses BOBOT FIRE and Money 2 12-16-2008 09:50 AM
2008 cap gains taxes: zero in 10% & 15% income-tax brackets Nords FIRE and Money 37 08-02-2006 04:41 PM
Capital Gains and Losses - Line 18 FirstYearWithALoss FIRE and Money 4 03-18-2004 06:37 AM

» Quick Links

 
All times are GMT -6. The time now is 05:46 AM.
 
Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2024, vBulletin Solutions, Inc.