

Figuring NET portfolio gain
03162019, 05:12 AM

#1

Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Mar 2011
Posts: 5,399

Figuring NET portfolio gain
Just as when trying to play golf, whenever I play with numbers, it often doesn't end well.
I've been playing with numbers again. Hoping some of you can help me interpret what I'm seeing.
Like most of you, I track my annual portfolio return. I use my own spreadsheet and compare it with M* and they closely corroborate.
But as a 'never touch the principle' guy, what I'm really interested in is my 'net' return, which is my return that includes my gains/losses as well as my withdrawals. In short, I'm trying to gauge the portfolio's progress despite my withdrawals.
What I've done is go back to my January 1 start balances for each year since 2006. I figure that each Jan 1 balance will include all my gains/losses and withdrawals from the previous year.
What I found is that since my start (2006), my average annual gain is ~3.5% which would include gains and withdrawals. I also found that I doubled my portfolio in 11 years, which included the 2008 debacle.
I've had only two negative years 2008 and 2018 but since my overall gain is 3.5%, I believe this tells me that despite my withdrawals and occasional market loses, I'm still in good shape considering everything.
Am I missing something or does this make sense? Can I assume that as long as my 2006 to present stays positive that I'm moving in the right direction? Should I be looking at a shorter time frame than starting at 2006?
Note that 2018 really skewed the numbers; not only was it a bad year but we also withdrew a heck of a lot more than usual for a renovation project. If I take out '18 my net return since '06 is more like 7%...but I know you can't do that.
I've demonstrated here time and again that I have a true blind spot when it comes to math (pls be kind) so any insight appreciated.
__________________
__________________
Living well is the best revenge!
Retired @ 52 in 2005




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 EarlyRetirement.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!

03162019, 05:42 AM

#2

Thinks s/he gets paid by the post
Join Date: Dec 2015
Location: Michigan
Posts: 2,505

You are not really determining your net investment return. For that, you would have to add back your withdrawals. What you are showing is that your withdrawal rate is lower than your investment return, and that the difference between the two is 3.5%.
__________________
__________________
"The mountains are calling, and I must go." John Muir



03162019, 05:58 AM

#3

Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Jun 2007
Posts: 7,386

Quote:
Originally Posted by DrRoy
You are not really determining your net investment return. For that, you would have to add back your withdrawals. What you are showing is that your withdrawal rate is lower than your investment return, and that the difference between the two is 3.5%.

He never said he was considering his investment return. In fact he very specifically said he was looking to measure his portfolio return including withdrawals.
One think I see off about the numbers, the "rule of 78s" says that with a 3.5% return, it would take 22 years to double your money, instead you said it took you 11, so something is off. I don't know how you came up with that 3.5%.
One thing you could do is look at the graph or numbers produced by Firecalc, and see where your situation fits in that. I suspect it would be in the range of very successful scenarios.



03162019, 06:06 AM

#4

Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Mar 2011
Posts: 5,399

Quote:
Originally Posted by RunningBum
He never said he was considering his investment return. In fact he very specifically said he was looking to measure his portfolio return including withdrawals.
One think I see off about the numbers, the "rule of 78s" says that with a 3.5% return, it would take 22 years to double your money, instead you said it took you 11, so something is off. I don't know how you came up with that 3.5%.
One thing you could do is look at the graph or numbers produced by Firecalc, and see where your situation fits in that. I suspect it would be in the range of very successful scenarios.

I think it's the "Rule of 72" but regardless.
I doubled my total with a return of about 6.6% from 2006 to 2017. As noted, if I ignore 2018 my 3.5% goes to about 7.0%. 2018 was down 15% from both heavier than normal withdrawals and market action.
__________________
Living well is the best revenge!
Retired @ 52 in 2005



03162019, 06:31 AM

#5

Thinks s/he gets paid by the post
Join Date: Dec 2008
Posts: 4,775

Quote:
Originally Posted by marko
What I've done is go back to my January 1 start balances for each year since 2006. I figure that each Jan 1 balance will include all my gains/losses and withdrawals from the previous year.
What I found is that since my start (2006), my average annual gain is ~3.5% which would include gains and withdrawals. I also found that I doubled my portfolio in 11 years, which included the 2008 debacle.
I've had only two negative years 2008 and 2018 but since my overall gain is 3.5%, I believe this tells me that despite my withdrawals and occasional market loses, I'm still in good shape considering everything.

I track monthly increase, then sum for EOY end of year. It sounds like we have similar method.



03162019, 06:37 AM

#6

Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Mar 2011
Posts: 5,399

Here is my start of year from 2006 to Jan 2019
chart.png
__________________
Living well is the best revenge!
Retired @ 52 in 2005



03162019, 07:46 AM

#7

Thinks s/he gets paid by the post
Join Date: Jun 2016
Posts: 2,437

Are you a Fidelity customer? They calculate this for you under the “performance” tab.



03162019, 07:53 AM

#8

Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Mar 2011
Posts: 5,399

Quote:
Originally Posted by COcheesehead
Are you a Fidelity customer? They calculate this for you under the “performance” tab.

I'm with TRowe. They have a "Personal Rate of Return " but it is so convoluted in the calculations that I think even our "mathjak" would be buffaloed.
__________________
Living well is the best revenge!
Retired @ 52 in 2005



03162019, 08:01 AM

#9

Thinks s/he gets paid by the post
Join Date: Jun 2016
Posts: 2,437

Quote:
Originally Posted by marko
I'm with TRowe. They have a "Personal Rate of Return " but it is so convoluted in the calculations that I think even our "mathjak" would be buffaloed.

LOL



03162019, 08:15 AM

#10

Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Jan 2006
Location: Rio Grande Valley
Posts: 21,535

I do track my net worth over the years. So this number includes any funds spent as well as the value of my assets.
And I track it against inflation. I usually update my spreadsheet about 4 times a year.
But I haven't annualized the return. I guess I don't really care about the annual gain, just about whether I'm staying ahead of inflation over the long run.
It's just a benchmark. I don't care about dipping into "principal". But I know that if my net worth is keeping up with inflation, then I am way ahead of the game IMO.
__________________
Retired since summer 1999.



03162019, 08:31 AM

#11

Recycles dryer sheets
Join Date: Oct 2016
Posts: 97

I have been driving myself Crazy flipping numbers around and obsessing over them. (!)
My new strategy is this:
> I have a Plan.
> On any given spot check, if I have an equal or greater Net Worth than I had planned upon at that given point in time  I am "Happy".
> If my Net Worth is any less than planned at any given point  I am "Sad", and will investigate what has caused the discrepancy.
Now, if I can just follow my own advice and QUIT playing with numbers, scenarios, possibilities and Coulda'Shoulda'Woulda'... I think I'll be Okay.



03162019, 09:18 AM

#12

Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Mar 2011
Posts: 5,399

Quote:
Originally Posted by audreyh1
I do track my net worth over the years. So this number includes any funds spent as well as the value of my assets.
And I track it against inflation. I usually update my spreadsheet about 4 times a year.
But I haven't annualized the return. I guess I don't really care about the annual gain, just about whether I'm staying ahead of inflation over the long run.
It's just a benchmark. I don't care about dipping into "principal". But I know that if my net worth is keeping up with inflation, then I am way ahead of the game IMO.

Yes. Having doubled my number over the years I'm less worried about dipping into the original principle (ooops... principal).
Like you, I'm more interested in staying ahead of inflation and keeping track of my progress.
__________________
Living well is the best revenge!
Retired @ 52 in 2005



03162019, 10:15 AM

#13

Recycles dryer sheets
Join Date: Aug 2013
Posts: 310

Quote:
Yes. Having doubled my number over the years I'm less worried about dipping into the original principle (ooops...principal).

Looks like your only 'problem' is not spending enough. Time to blow that dough!



03162019, 10:27 AM

#14

Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Jan 2006
Location: Rio Grande Valley
Posts: 21,535

Quote:
Originally Posted by marko
Yes. Having doubled my number over the years I'm less worried about dipping into the original principle (ooops...principal).
Like you, I'm more interested in staying ahead of inflation and keeping track of my progress.

It might look like it has doubled. But if you adjust for inflation you will find a lower answer, but the "real" answer.
I use this cumulative inflation calculator: https://inflationdata.com/inflation/...alculator.aspx
For example, for inflation from 2000 to the present, you put in Dec 1999, then Feb 2019 which is the most recent CPI, and $1. You get 50.19% which is a big cut into any gain since then as spending power has been reduced by 33% since Dec 1999.
__________________
Retired since summer 1999.



03162019, 10:51 AM

#15

Recycles dryer sheets
Join Date: May 2013
Posts: 407

I’ve given up on any fancy methods to track return. I simply look at my year end net worth (which takes into account growth of investments and withdrawals) figure out the year over year nominal return and year over year real return (inflationadjusted), smile and then forget about it. Making the spreadsheets too complicated and overthinking it is too easy so I try to avoid that.
__________________
Saved 8 figures by my mid40's as a professional bubblespotter. Beware...the Fed creates bubble after bubble after bubble.



03162019, 12:02 PM

#16

Recycles dryer sheets
Join Date: Oct 2015
Posts: 115

There is no single true measurement, but I agree that any palliative is better than not measuring performance at all.
Many many moons ago I found this method somewhere on the net, presented together with its reasoning, which I thought was sound enough for my purposes.
It uses 4 values:
Bstart (starting balance) for the year
Bend (ending balance)
N (net annual additions to the p/folio = additions minus withdrawals)
Y (the elapsed time in years if measured over more than a single year, otherwise Y = 1).
and the return rate is
r = [ ( Bend  N / 2 ) / ( Bstart + N / 2 ) ] ^(1/Y)  1
The logic applied is that
(Bstart + N/2)* grew to (Bend  N/2) for the measured period.
This is what I have used, and it gives me a comparable annual metric.
__________________
All hat, no cattle. Retired July 2018. Posting here purely for amusement.



03172019, 04:49 AM

#17

Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Mar 2011
Posts: 5,399

Quote:
Originally Posted by joylesshusband
Many many moons ago I found this method somewhere on the net, presented together with its reasoning, which I thought was sound enough for my purposes.
It uses 4 values:
Bstart (starting balance) for the year
Bend (ending balance)
N (net annual additions to the p/folio = additions minus withdrawals)
Y (the elapsed time in years if measured over more than a single year, otherwise Y = 1).
and the return rate is
r = [ ( Bend  N / 2 ) / ( Bstart + N / 2 ) ] ^(1/Y)  1
The logic applied is that
(Bstart + N/2)* grew to (Bend  N/2) for the measured period.
This is what I have used, and it gives me a comparable annual metric.

No emoji for 'eyes glazing over' (but that's just me)
This looks similar to how TRowe does it but they include the timing of one's sales/additions/withdrawals (at what date during the year you did so) which tends to produce an entirely different number and, IMO while perhaps more accurate, not very useful.
Having said that, as a noted mathophobe, I'll have to stay with less complicated calculations and be happy with my lifetime 'close enough' approach.
TR's 'since incept/2006' number (and perhaps yours) gives me 5.5% while my Excel run gives me 3.5% which either way is a positive number and somewhat ahead of inflation which is what I'm really looking to know.
__________________
Living well is the best revenge!
Retired @ 52 in 2005



03182019, 01:15 PM

#18

Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Mar 2011
Posts: 5,399

Update:
Oops, I did it again!
I just realized that I was dividing my gain by my most recent, larger number rather than my starting number.
That sends my gain since incept (2006) from 3.5% to 5.2%
Numbers are hard. But thanks all for the help with this question.
__________________
Living well is the best revenge!
Retired @ 52 in 2005



03182019, 02:27 PM

#19

Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Nov 2010
Location: Vermont & Sarasota, FL
Posts: 21,142

The forumla below replicates the moneychimp calculator:
=AVERAGE(RATE(Period in years,Additions+Dividends+Withdrawals,Starting balance,Ending balance,1),RATE(Period in years,Additions+Dividends+Withdrawals & Withdrawals,Starting balance,Ending balance,0))
Or you can just use the moneychimp calculator
Investment Return Calculator: Measure your Portfolio's Performance
The above presume that additions, dividends and withdrawals all happen ratably throughout the year.... if they are lumpy then you may want to us XIRR.
__________________
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...60/35/5 AA



03192019, 11:11 AM

#20

Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Oct 2010
Posts: 5,089

Quote:
Originally Posted by marko
I've demonstrated here time and again that I have a true blind spot when it comes to math (pls be kind) so any insight appreciated.

You may have that blind spot, but you seem to have patience (going back through all those statements), so I'll give you the precise way to get your rate of return.
I'm guessing that you're basing this off of one investment account, and you consider the money "spent" when it leaves that one investment account.
What you'd do is make a pair of columns in a spreadsheet with a date column and a dollar value column. The first entry is a beginning balance, and is positive. The next set of entries are any withdrawals you have, one per date. These are negative values. You get to ignore all transactions that don't "break the barrier" into or out of of the account! So interest, dividends, rebalancing, selling or buying things...those all can be ignored, lucky you! Just if you pull money out, or put money in does it need an entry. So if you happen to add to the account, that would go in as a positive value. Finally, the last entry is minus the ending balance. Then, in an empty cell you type (no quotes) "=xirr(" then draw a box around the numbers, they type "," and draw a box around the dates, then type ", .1)" and hit enter. If you think you lost money, you might need to type ",.1)", because rate of return needs that "guess" as a starting point for it's calculation.
I just did a quick test. I typed 12/31/2018 into a cell and 100000 into the cell to the right of the date. Then put dates in for each monthend, and put 1000 in each cell. So the test presumes a $1000 withdrawal on the end of each month. So after you have 12 additional cells with 1000 along with the associated monthend dates to the left, add one more cell for your ending balance. Say your ending balance after your last withdrawal was $90K, so you'd add a 14th value of 90000. Then you write the XIRR formula as described above and it says your rate of return was 2.11%.
The cool thing about the XIRR formula is that you can have transactions on any date (not just aligned with monthend). And your duration doesn't need to be exactly one year either; if you put in the beginning balance on June 30 and the ending balance on December 31 and the transactions between, it will tell you what your annualized rate is, which is kind of the comparison number that everyone uses. So for instance if your starting balance on June 30 was 95000 and ending balance on 12/31 was 90000 and you pulled out 6 $1000 withdrawals, XIRR would give 2.16% (comparable to 2.11%, even though the span of time was not the same, the two can be compared since they are annualized).
__________________





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


Thread Tools 
Search this Thread 


Display Modes 
Linear Mode

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


