2015 YTD investment performance thread

[utrecht]

Quote:

Originally Posted by simple girl OK, I'm finally getting back to this. I want to get an overall ballpark estimate of our YTD growth - don't have time to track monthly investments from 401k and enter it into an IRR spreadsheet. So, I tried to use the formula above: ($start-$now-$addedSinceStart)/$start When I put my numbers in, I am getting a negative return, which doesn't make sense to me since the account has grown more than what we have invested (total invested this year so far is $37,951 and the overall balance has grown by $64,703, so our net growth for the year is $14,752). So the return should be a positive number. Shouldn't the formula be: ($now - $start - $addedSinceStart)/$start

($Now-$start-$addedsincestart)/$start is more correct than the first formula but its still not correct. If you have a large balance and small contributions it will be close-ish....but the larger your contributions are compared to your initial balance, the farther away from correct this formula will be.

[simple girl]

Quote:

Originally Posted by utrecht ($Now-$start-$addedsincestart)/$start is more correct than the first formula but its still not correct. If you have a large balance and small contributions it will be close-ish....but the larger your contributions are compared to your initial balance, the farther away from correct this formula will be.

We have a large balance (to me, it's large, maybe not to the multimillionaires here, lol) - so, I'll call it close enough! Thanks so much.

So, looks like our YTD is ~ 2.31%.

[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%

[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!

[simple girl]

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%

I have no clue...is that more accurate?

Will let others give their two cents.

[utrecht]

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%

This may or may not be more correct depending on how large the initial balance is compared to the size of the contributions and when the contributions were made.

If we are talking about something like a $300,000 balance and contributions of $500 per month added monthly and not all at once towards the end of the year, then this formula probably is more correct. Either way, if you are doing it this way, I wouldnt say you have a return of 2.31%. Its no where near accurate enough. I would just call it 2.3% and even that is probably overdoing the accuracy level.

[audreyh1]

Quicken calculates ROI as ($now+$removed)/($start+$added)

I think that's a pretty good way to do it, and close enough for back-of-the-envelope anyway. How precise does one have to be?

[NW-Bound]

Quote:

Originally Posted by audreyh1 Quicken calculates ROI as ($now+$removed)/($start+$added) I think that's a pretty good way to do it, and close enough for back-of-the-envelope anyway. How precise does one have to be?

That's plenty good. Nowadays, there's no "added" for me and "removed" is only a few percent, so the above is all I need. No stinkin' IRR needed.

[utrecht]

Lets say I started with $500,000 and withdrew $50,000 on Jan 1st.
At the end of the year, I have $500,000 but I added $25,000 on July 1st after selling a house.

My actual return according to XIRR is +5.42%

Can you post the return according to Quicken? The formula you posted doesnt make sense to me. It cant be correct. $550,000/$525,000? I get 1.047. Is that a 4.7% return? If so, its not all that close to correct.

[NW-Bound]

That's a 10% WR right at the beginning of the period!

Yes, you need IRR method in this case.

[simple girl]

$Now-$start-$addedsincestart)/$start = 2.3%

($now - $start - $added)/ ($start - $added) = 1.3%


($now+$removed)/($start+$added) = 2.2%


Well, at least it is positive no matter what calculation I use.


OK, back to work prep...not retired fully yet folks.

[NW-Bound]

That middle formula that gave you 1.3% does not make sense. The other 2 agree as well as one could expect.

[audreyh1]

Quote:

Originally Posted by utrecht Lets say I started with $500,000 and withdrew $50,000 on Jan 1st. At the end of the year, I have $500,000 but I added $25,000 on July 1st after selling a house. My actual return according to XIRR is +5.42% Can you post the return according to Quicken? The formula you posted doesnt make sense to me. It cant be correct. $550,000/$525,000? I get 1.047. Is that a 4.7% return? If so, its not all that close to correct.

That looks right - 4.76% or 4.8% return if rounded.

I can't actually enter that in Quicken - Quicken does the computation based funds and accounts in the software - you don't enter anything other than select the funds or the accounts and the start and end dates.

That formula acts as if additions were made at the beginning of the year. But IMO - it's still close enough if you don't want to go through the process of entering a series of values and dates throughout a given period of time.

[Mulligan]

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!

Thanks to my small amount of mutual funds recovering, I am up about 9%. But this in itself almost will necessitate my returns will be low next year due to the fact most of my money is in preferred stocks. People have overpaid on some and they are too far over par and that will reverse course. But that is fine with me as I reinvest all my income and my effective yield will go up through buying at lower prices.


Sent from my iPad using Tapatalk

[audreyh1]

Quote:

Originally Posted by NW-Bound That's plenty good. Nowadays, there's no "added" for me and "removed" is only a few percent, so the above is all I need. No stinkin' IRR needed.

If I'm doing the ROI computation on a given fund, added would be any rebalancing into that fund during the year, and removed would be any distributions on reinvested in the fund.

And that is as close as I try to get - the Quicken reports. I'm sometimes comparing performance across asset classes or specific funds, so using the same method and seeing relative performance.

But I also use it for my portfolio ROI year-to-date computation, and like you I don't have any additions during the year.

[utrecht]

Quote:

Originally Posted by audreyh1 Right - 4.7% or 4.8% return if rounded. I can't actually enter that in Quicken - Quicken does the computation based funds and accounts in the software - you don't enter anything other than select the funds or the accounts and the start and end dates. That formula acts as if additions were made at the beginning of the year. But IMO - it's still close enough if you don't want to go through the process of entering a series of values and dates throughout a given period of time.

I dont see how 5.4% and 4.8% are close enough, especially among a group of people who nit pick tiny percentage points in expense ratios and other things. Lots of people withdraw at the beginning of the year like my example shows but very few people make a large contribution on the first day of the year. Most people contribute periodically during the year or a one time lump sum from the sale of a house or an inheritance but that will rarely coincide with the first day of the year.

People can figure their return however they like, but when they post returns in a thread with a bunch of other people I assume its to compare to see what other people have accomplished and if some peoples return is just a wild approximation that could easily be 15% or more off, it doesnt mean much.

[audreyh1]

The only way to do that is to require everyone to use the exact same formula.

What I see here is people using their own methods, or what their brokerage reports, and some include the start of year withdrawal in their calculations, and others don't. People generally state how they arrived at their calculation. And there is a wide variation and wide results.

[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...

[utrecht]

Quote:

Originally Posted by audreyh1 The only way to do that is to require everyone to use the exact same formula. What I see here is people using their own methods, or what their brokerage reports, and some include the start of year withdrawal in their calculations, and others don't. People generally state how they arrived at their calculation. And there is a wide variation and wide results.

Like I said, people can post whatever results they want, but they should at least know if their results are accurate or not. Otherwise they could be WAY off when they make certain projections for their future portfolio.

If I get 4.8% every year for 20 years but thought I was getting 5.4% every year and planned for 5.4%, the final result is going to be drastically different.

[Hermit]

Quicken says IRR = 1.76% for year. No additions. One withdrawal of about 1.6% a couple of weeks ago.

This reminds me - I need to re-balance after that annual withdrawal.