|
|
12-02-2015, 10:01 AM
|
#521
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
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)
|
|
|
|
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!
|
12-02-2015, 10:08 AM
|
#522
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Jan 2006
Location: Rio Grande Valley
Posts: 38,007
|
Quote:
Originally Posted by Texas Proud
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.
|
|
|
12-02-2015, 10:19 AM
|
#523
|
Moderator
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.
|
|
|
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!!!!
|
|
|
12-02-2015, 10:43 AM
|
#525
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
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.
|
|
|
12-02-2015, 10:43 AM
|
#526
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
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.
|
|
|
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.
|
|
|
12-02-2015, 12:14 PM
|
#528
|
Thinks s/he gets paid by the post
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
|
|
|
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
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.
|
|
|
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.
__________________
Retired July 2013 at age 49.
Lazy Portfolio Investor:
AA: 55% Stocks
35% Bonds
10% Cash
|
|
|
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.
|
|
|
12-02-2015, 03:19 PM
|
#532
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Nov 2010
Location: Sarasota, FL & Vermont
Posts: 36,264
|
Quote:
Originally Posted by pb4uski
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
|
|
|
12-02-2015, 03:21 PM
|
#533
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: May 2009
Posts: 9,343
|
Quote:
Originally Posted by robnplunder
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
|
|
|
12-02-2015, 03:23 PM
|
#534
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Nov 2010
Location: Sarasota, FL & Vermont
Posts: 36,264
|
Quote:
Originally Posted by Andre1969
.....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
|
|
|
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
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.
|
|
|
12-02-2015, 03:46 PM
|
#536
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Jul 2008
Posts: 35,712
|
Quote:
Originally Posted by utrecht
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)
|
|
|
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
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.
|
|
|
12-02-2015, 04:29 PM
|
#538
|
Recycles dryer sheets
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).
|
|
|
12-02-2015, 04:42 PM
|
#539
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Nov 2010
Location: Sarasota, FL & Vermont
Posts: 36,264
|
Quote:
Originally Posted by utrecht
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
|
|
|
12-02-2015, 05:39 PM
|
#540
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Jul 2008
Posts: 35,712
|
Quote:
Originally Posted by utrecht
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)
|
|
|
|
|
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
|
|
Thread Tools |
|
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
|
|
|