Join Early Retirement Today
Reply
 
Thread Tools Display Modes
Old 12-02-2015, 10:01 AM   #521
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
NW-Bound's Avatar
 
Join Date: Jul 2008
Posts: 35,712
I am flat YTD. That's not too good compared to the S&P which is up 4%, but then I have other sectors that are beaten down, such as emerging markets that are down bad. Even total international stocks are down because of the strong dollar.

Should I bother to nitpick how other people compute their returns? No. We do not have a contest here.

And then, let alone a fraction of a percent, even 1% or 2% can be wiped out in this volatile market. Many of my stock holdings move more than 5% each day.

To borrow from a Bob Dylan song:

And don’t speak too soon
For the wheel’s still in spin
And there’s no tellin’ who that it’s namin’
For the loser now will be later to win
For the times they are a-changin’
__________________
"Old age is the most unexpected of all things that happen to a man" -- Leon Trotsky (1879-1940)

"Those Who Can Make You Believe Absurdities Can Make You Commit Atrocities" - Voltaire (1694-1778)
NW-Bound 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 12-02-2015, 10:08 AM   #522
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,007
Quote:
Originally Posted by Texas Proud View Post
Just throwing this out since someone mentioned bond fund distributions and not putting growth in daily....

You should not put in interest daily... a bond fund keeps an income account separate from the principal account... at the end of the month they calculate how much of that income account is yours and sends it to you as a dividend.... you have the option of having them invest that dividend back into the principal account...

The price changes you see posted are the gains or losses that the bonds themselves experience, not any accrual of interest received...
That's right. Although there are some exceptions. DODIX is one. The NAV is a sawtooth that drops every three months - a good clue that a bond fund is using the equity MF method.
__________________
Retired since summer 1999.
audreyh1 is offline   Reply With Quote
Old 12-02-2015, 10:19 AM   #523
Moderator
braumeister's Avatar
 
Join Date: Feb 2010
Location: Flyover country
Posts: 25,199
Tax-advantaged accounts, which are ⅔ of our total portfolio, have had no inputs or withdrawals. Comparing present balance with start of the year, up right about 2%.

Too much action this year (buying/selling house, etc.) to include the taxable accounts. Simple is good.
braumeister is offline   Reply With Quote
Old 12-02-2015, 10:28 AM   #524
Thinks s/he gets paid by the post
 
Join Date: Aug 2005
Location: Crownsville
Posts: 3,711
Here's how I calculate my rate of return...

First, I run two calculations:
A: (current balance - YTD contributions) / balance at beginning of year
B: current balance / (balance at beginning of year + YTD contributions)

Then I take the average of the two.

For instance, if I had $1M on 12/31/14, invested $20K so far this year, and yesterday's balance was $1.2M, I'd get the following:

($1.2M - $20K)/$1M = 1.18
$1.2M /($1M + $20K) = 1.17647...

(1.18 + 1.17647)/2 = 2.35647
2.35647/2=1.178235

Drop the 1, and you get 17.8235%

I do it this way, because I'm constantly adding money throughout the year, so part of those additional investments, depending on when I put them in, earn money (or lose money) as well. Rather than try to keep track of when I put in every little bit of additional investment, I figure this approach, helps give a reasonable average. One way assumes all the additional money went in at the beginning of the year, and the other way assumes it all went in at the end.

Anyway, using that approach, as of yesterday, I think I'm up about 4.3%. I ran the numbers this morning, but forgot the exact percent. However, the dollar amount came out to a new peak for me. So, WHEEEEEE!!!!
Andre1969 is offline   Reply With Quote
Old 12-02-2015, 10:43 AM   #525
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,007
As of Nov 30, my retirement fund is only up 0.83% YTD after th initial withdrawal (no additions).

That's not enough to recover from my start of this year income withdrawal, so unless the market has a really nice Santa Clause rally that gives me another 2.8% gain on my portfolio, we'll be withdrawing money from a lower portfolio next Jan - a slight cut.
__________________
Retired since summer 1999.
audreyh1 is offline   Reply With Quote
Old 12-02-2015, 10:43 AM   #526
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
athena53's Avatar
 
Join Date: May 2014
Posts: 7,326
Morgan-Stanley account: up 0.3%. Fidelity: up 1.5%, overall 0.5%. Method: XIRR, then adjusted to YTD by raising it to (11/12) power. I've got a decent amount of bond funds, which dragged yields down, but the big culprit was a high-yield Chesapeake Energy bond I bought at par for about $25K, now worth $11,750. Ouch. Morgan-Stanley return would have been 0.6% without that drop. I'm still hanging onto it.
athena53 is offline   Reply With Quote
Old 12-02-2015, 11:54 AM   #527
Recycles dryer sheets
 
Join Date: Oct 2015
Posts: 124
Up 3.2% YTD (excluding any additions - no withdrawals (not yet retired)). Not sure which formula is being used to calculate this number.
eastnortheast is offline   Reply With Quote
Old 12-02-2015, 12:14 PM   #528
Thinks s/he gets paid by the post
Cobra9777's Avatar
 
Join Date: Jul 2012
Location: Texas
Posts: 3,024
Up 2.3% YTD as of yesterday's close. This is slightly below a 60/40 benchmark of VTI/BND, which was up 2.5%.

The lag is driven by international emerging markets, a high-dividend ETF that is overweight energy/utilities, and high-yield corporate bonds. Our real estate holdings continue to do quite well, which partially offsets these effects and keeps performance close to the benchmark.

FWIW, I do 2 return calculations and reconcile the two:

1. YTD change in total portfolio balance divided by beginning-of-year balance. The current balance is adjusted for ins/outs during the year, including the related performance impact.
2. Look up YTD total return for each holding in M*. Mix weight on beginning-of-year balances. Adjust for any portfolio changes during the year.

For today, the first method resulted in 2.34%. The second was 2.33%. For analytical purposes, I find the second method to be far more useful. I can quickly see subsets of the total, such as asset classes and individual holdings. This enables analysis of what's working and what's not, including what-if type changes. I only do the first method at the total portfolio level, and mainly just as a reconciliation or reality check before I run with the M* numbers. Since it's at the total portfolio level, there's little-to-no analytical value.
__________________
Retired at 52 in July 2013. On to better things...
AA: 85/15 WR: 2.7% SI: 2 pensions, SS later
Cobra9777 is offline   Reply With Quote
Old 12-02-2015, 12:49 PM   #529
Thinks s/he gets paid by the post
 
Join Date: Nov 2013
Location: Bay Area
Posts: 2,745
Quote:
Originally Posted by steelyman View Post
I'll be lagging many of you when all is said and done and 2015 is in the books, but that's OK.

I think threads like this are very good in providing a survey of sorts where people provide an honest effort at accurately reporting investment performance numbers in a way that is comparable over a reasonable length of time. Here's hoping to see another of these threads in the New Year!
My main reason for creating this thread was to share info on what investment is working YTD, beyond the result. I didn't expect protracted discussions on how to report the result. But that's good, too. I enjoy reading the posts about what to include in the result.

I will open a 2016 YTD perf. thread in sometime Jan.
robnplunder is offline   Reply With Quote
Old 12-02-2015, 02:13 PM   #530
Full time employment: Posting here.
 
Join Date: Jan 2008
Posts: 757
As I'm sure most folks have access to MS Excel or OpenOffice, it would be quite easy to standardize this calculation. Below is a portfolio starting the year at $500K and withdrawing $3000 on the first of each month. There are also deposits to the portfolio on Feb 2 and Aug 2 of $12K and $20K respectively. You can see that in this example on Dec 2 the portfolio was worth $512,260. This is entered as a negative number in the spreadsheet. I would set the last date cell to =TODAY() so it automatically shows the current date and you don't have to keep changing it.

To get the rate of return, the cell is set to =XIRR(B4:B20;A4:A20) in this case. Your cell columns would be wherever you have it in the spreadsheet.

This is so easy and I hope it makes sense.
Attached Images
File Type: png Screen Shot 2015-12-02 at 1.02.12 PM.png (21.0 KB, 157 views)
__________________
Retired July 2013 at age 49.

Lazy Portfolio Investor:
AA: 55% Stocks
35% Bonds
10% Cash
NanoSour is offline   Reply With Quote
Old 12-02-2015, 02:51 PM   #531
Thinks s/he gets paid by the post
 
Join Date: Nov 2006
Posts: 2,288
For comparison:

The ROR for the above situation is 3.31%
If you use Quicken's formula the ROR is 0.48%.

The actual return is almost 7 times higher. Quite a difference. You might as well not even calculate the return if you arent going to do it right.
utrecht is offline   Reply With Quote
Old 12-02-2015, 03:19 PM   #532
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
pb4uski's Avatar
 
Join Date: Nov 2010
Location: Sarasota, FL & Vermont
Posts: 36,264
Quote:
Originally Posted by pb4uski View Post
How about ($now - $start - $added)/ ($start - $added)?

For example, if $start =100, $added =20 and $now = 130 then the gain of 10 divided by the average invested balance of 110 is 9%
Sorry folks... I mistyped the formula... it should have been:

($now - $start - $added)/ ($start + 1/2 $added)
= (130 - 100 - 20)/ (100 + 1/2 * 20)
= 10/110
= 9%

Works ok for a full year but is a bit off early in the year. XIRR is better.
__________________
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
pb4uski is offline   Reply With Quote
Old 12-02-2015, 03:21 PM   #533
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
Mulligan's Avatar
 
Join Date: May 2009
Posts: 9,343
Quote:
Originally Posted by robnplunder View Post
My main reason for creating this thread was to share info on what investment is working YTD, beyond the result. I didn't expect protracted discussions on how to report the result. But that's good, too. I enjoy reading the posts about what to include in the result.

I will open a 2016 YTD perf. thread in sometime Jan.

I didnt really explain why my results were so good comparatively speaking but since you want to know, I will.... Disclaimer: past performance does not predict future performance. . Last year I found my stomach waning for potential market losses in mutual funds and sick and tired of earning nothing on IBonds and CDs. Studied preferred stocks and bounced around a few ideas with fellow posters here and developed my plan. Got my 6.5% average yield all wrapped up for the year except for a some late December dividends needing to be kicked out. Made some seriously easy money trading CHSCL and CHSCM cap gains plus dividends, plus a few others. All issues but one now (thanks to today) are higher than purchased. That is really immaterial as I invest for the income not stock appreciation. Safe was well rewarded this year. Next year who knows, but as I mentioned earlier the companies are 100% safe so price dips are actually begrudgingly appreciated since I reinvest all divis plus leftover income money each month.


Sent from my iPad using Tapatalk
Mulligan is offline   Reply With Quote
Old 12-02-2015, 03:23 PM   #534
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
pb4uski's Avatar
 
Join Date: Nov 2010
Location: Sarasota, FL & Vermont
Posts: 36,264
Quote:
Originally Posted by Andre1969 View Post
.....For instance, if I had $1M on 12/31/14, invested $20K so far this year, and yesterday's balance was $1.2M, I'd get the following:

($1.2M - $20K)/$1M = 1.18
$1.2M /($1M + $20K) = 1.17647...

(1.18 + 1.17647)/2 = 2.35647
2.35647/2=1.178235

Drop the 1, and you get 17.8235%
.....
or (1200-1000-20)/(1000+1/2*20)= 180/1010 = 17.82%
__________________
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
pb4uski is offline   Reply With Quote
Old 12-02-2015, 03:29 PM   #535
Thinks s/he gets paid by the post
 
Join Date: Jul 2013
Posts: 1,046
Quote:
Originally Posted by Andre1969 View Post
Here's how I calculate my rate of return...

First, I run two calculations:
A: (current balance - YTD contributions) / balance at beginning of year
B: current balance / (balance at beginning of year + YTD contributions)

Then I take the average of the two.

For instance, if I had $1M on 12/31/14, invested $20K so far this year, and yesterday's balance was $1.2M, I'd get the following:

($1.2M - $20K)/$1M = 1.18
$1.2M /($1M + $20K) = 1.17647...

(1.18 + 1.17647)/2 = 2.35647
2.35647/2=1.178235

Drop the 1, and you get 17.8235%

I do it this way, because I'm constantly adding money throughout the year, so part of those additional investments, depending on when I put them in, earn money (or lose money) as well. Rather than try to keep track of when I put in every little bit of additional investment, I figure this approach, helps give a reasonable average....
I'm kind of in the same situation and have been trying to figure out how do I determine what my contributions were vs. the total return. I have several accounts that I contribute to and during the year I've changed the amounts. Some are pretax and some post tax. pretax are easy I can see those on my pay stub but post-tax I guess I'd have to manually go into each account and figure out. I was hoping Personal Capital or Mint would have a slick way to figure those out but I don't see it.
dvalley is offline   Reply With Quote
Old 12-02-2015, 03:46 PM   #536
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
NW-Bound's Avatar
 
Join Date: Jul 2008
Posts: 35,712
Quote:
Originally Posted by utrecht View Post
For comparison:

The ROR for the above situation is 3.31%
If you use Quicken's formula the ROR is 0.48%.

The actual return is almost 7 times higher. Quite a difference. You might as well not even calculate the return if you arent going to do it right.
Start = $500,000
End = $512,680
Withdrawal = $36,000
Deposit = $33,427

Using the simple formula ($now+$removed)/($start+$added), I get 2.86%. It is off, but not as bad as you show.
__________________
"Old age is the most unexpected of all things that happen to a man" -- Leon Trotsky (1879-1940)

"Those Who Can Make You Believe Absurdities Can Make You Commit Atrocities" - Voltaire (1694-1778)
NW-Bound is offline   Reply With Quote
Old 12-02-2015, 04:14 PM   #537
Thinks s/he gets paid by the post
 
Join Date: Nov 2006
Posts: 2,288
Quote:
Originally Posted by NW-Bound View Post
Start = $500,000
End = $512,680
Withdrawal = $36,000
Deposit = $33,427

Using the simple formula ($now+$removed)/($start+$added), I get 2.86%. It is off, but not as bad as you show.
My bad. It is still off about as much as the other example. About 13%....but this time the actual result is higher. Last time it was about 13% lower. That's a pretty big variance between reality and the estimate.

Anyone with Excel can do the calculations the correct way in less than 10 mins. Im not sure why they wouldnt want to.
utrecht is offline   Reply With Quote
Old 12-02-2015, 04:29 PM   #538
Recycles dryer sheets
Sittinginthesun's Avatar
 
Join Date: Feb 2015
Posts: 177
5.6% to Dec 1st including dividends but not including $225k of new contributions (about $144k into investment accounts and the rest into "high" interest savings).
Sittinginthesun is offline   Reply With Quote
Old 12-02-2015, 04:42 PM   #539
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
pb4uski's Avatar
 
Join Date: Nov 2010
Location: Sarasota, FL & Vermont
Posts: 36,264
Quote:
Originally Posted by utrecht View Post
My bad. It is still off about as much as the other example. About 13%....but this time the actual result is higher. Last time it was about 13% lower. That's a pretty big variance between reality and the estimate.

Anyone with Excel can do the calculations the correct way in less than 10 mins. Im not sure why they wouldnt want to.
A reasonable approximation is the formula I provided earlier of the "gain" divided by the average invested balance. In this case, $15,253 gain divided by $498,714 average invested balance for a return of 3.05%... pretty close to the 3.31% but a much simpler calculation.
__________________
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
pb4uski is offline   Reply With Quote
Old 12-02-2015, 05:39 PM   #540
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
NW-Bound's Avatar
 
Join Date: Jul 2008
Posts: 35,712
Quote:
Originally Posted by utrecht View Post
My bad. It is still off about as much as the other example. About 13%....but this time the actual result is higher. Last time it was about 13% lower. That's a pretty big variance between reality and the estimate.

Anyone with Excel can do the calculations the correct way in less than 10 mins. Im not sure why they wouldnt want to.
Because they are lazy? Like me?

It is true that to compare investing prowess, we need to use a more exact method. But is it really that important? In the end, we all want to have more money, but how we draw our money makes a difference too, not just how we invest.

Some people like to draw all the money they need at the beginning of year and put it in some place safe, instead of drawing what they need throughout the year. In a bull market, that works against them, compared to leaving the money in the market. Conversely, if the market drops through the year, having that money out in cash reduces the loss.

Or everybody talks about rebalancing, but some rebalance religiously on Jan 2nd, some by using a threshold. Sometimes one method works better, the other times the other one does.

So, the comparison here is just as a lark. Someone who is heavy in REITs would do well earlier this year, and not so well now. It's so fluid, so why split hair?
__________________
"Old age is the most unexpected of all things that happen to a man" -- Leon Trotsky (1879-1940)

"Those Who Can Make You Believe Absurdities Can Make You Commit Atrocities" - Voltaire (1694-1778)
NW-Bound 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
YTD Performance Poll 4merKPer FIRE and Money 98 08-09-2011 11:09 AM
YTD 2006 investment Sam FIRE and Money 84 12-04-2006 12:39 PM
What's Your YTD Return? Tommy_Dolitte Young Dreamers 53 12-02-2004 06:10 AM

» Quick Links

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