Welcome to City-Data.com Forum!
U.S. CitiesCity-Data Forum Index
Go Back   City-Data Forum > General Forums > Economics > Investing
 [Register]
Please register to participate in our discussions with 2 million other members - it's free and quick! Some forums can only be seen by registered members. After you create your account, you'll be able to customize options and access all our 15,000 new posts/day with fewer ads.
View detailed profile (Advanced) or search
site with Google Custom Search

Search Forums  (Advanced)
Reply Start New Thread
 
Old 11-02-2018, 09:14 PM
 
7,682 posts, read 8,767,923 times
Reputation: 4547

Advertisements

Suppose the following are the transactions of an investment:

Jan. 1: bought 10 shares @ $5 ........ cost=$50
Feb. 1: bought 20 shares @ $6 ........ cost=$120
Mar. 1: sold 12 shares @ $8 ....... (-$96)
This leaves 18 shares remaining

Suppose at this point, today, the price is $7. So the current value = $7 x 18 =$126

The gain would be $126+96-(50+120)=$52.
Or alternatively, $126-(50+120-96)=$52

What is the overall ROI at this time?

I understand ROI = (Gain - Cost)/Cost.

What is the cost now? Is it $50+120=$170, or is it $50+120-96=$74?

Apologize if this is a dumb question.

Last edited by snowmountains; 11-02-2018 at 10:02 PM..
Reply With Quote Quick reply to this message

 
Old 11-03-2018, 01:40 AM
 
107,084 posts, read 109,405,951 times
Reputation: 80470
there are different methods for calculating what was sold , fifo , lifo ,average , etc .which did you use
Reply With Quote Quick reply to this message
 
Old 11-03-2018, 01:52 AM
 
7,682 posts, read 8,767,923 times
Reputation: 4547
I thought it shouldn't matter? I'm only interested in the overall ROI, when I have sold all shares (suppose I sold the remaining 18 shares "today" when it's $7/share)
Reply With Quote Quick reply to this message
 
Old 11-03-2018, 02:00 AM
 
107,084 posts, read 109,405,951 times
Reputation: 80470
it does matter because cost on the sold shares and gains are different based on the method you sold with and that changes the cost basis on the remaining shares .

you need the exact sequence .

don't forget up 100% year one and down 50% year two is actually a zero return . but if we merely use averaging then it is a 25% average yearly return because up 100% and down 50% = plus 50% over 2 years or an average return of 25% and we can see that is clearly wrong . so you need to see exact cost basis's in order
Reply With Quote Quick reply to this message
 
Old 11-03-2018, 02:18 AM
 
7,682 posts, read 8,767,923 times
Reputation: 4547
So is there something called "overall ROI" of an investment? When folks say "My 401k had a ROI of 8% last year", how was that 12% calculated?
Reply With Quote Quick reply to this message
 
Old 11-03-2018, 02:42 AM
 
107,084 posts, read 109,405,951 times
Reputation: 80470
https://finance.zacks.com/calculate-...unds-4681.html


https://www.free-online-calculator-u...alculator.html

it can get tricky with sales because you don't want to count the same money 2x . if you have 100k in stock and sell 1/2 , make a profit and buy something else for 50K you don't want to count that as 150k so you need to work in the sales based on the cost method in to the 100k.

it is far easier when no sales happen .
Reply With Quote Quick reply to this message
 
Old 11-03-2018, 04:27 PM
 
Location: Wisconsin
25,581 posts, read 56,585,510 times
Reputation: 23406
Quote:
Originally Posted by snowmountains View Post
So is there something called "overall ROI" of an investment? When folks say "My 401k had a ROI of 8% last year", how was that 12% calculated?
What I do is divide the original value of portfolio at beginning of year into the gain for the year to arrive at an the ROI. That's good enough for me.

Example:

$30,000 - Jan. 1 Portfolio Value
$33,500 - Dec. 31 Portfolio Value
$x3,500 - Gain

$30,000/$3,500 - 11.66% ROI
Reply With Quote Quick reply to this message
 
Old 11-03-2018, 04:28 PM
 
Location: Wisconsin
25,581 posts, read 56,585,510 times
Reputation: 23406
Quote:
Originally Posted by snowmountains View Post
So is there something called "overall ROI" of an investment? When folks say "My 401k had a ROI of 8% last year", how was that 12% calculated?
What I do is divide the original value of portfolio at beginning of year into the gain for the year to arrive at an the ROI. That's good enough for me.

Example:

$10,000 - Jan. 1 Portfolio Value
$11,500 - Dec. 31 Portfolio Value
$x1,500 - Gain

$10,000/$1,500 - 15.0% ROI
Reply With Quote Quick reply to this message
 
Old 11-03-2018, 06:57 PM
 
7,682 posts, read 8,767,923 times
Reputation: 4547
Quote:
Originally Posted by Ariadne22 View Post
What I do is divide the original value of portfolio at beginning of year into the gain for the year to arrive at an the ROI. That's good enough for me.

Example:

$10,000 - Jan. 1 Portfolio Value
$11,500 - Dec. 31 Portfolio Value
$x1,500 - Gain

$10,000/$1,500 - 15.0% ROI

If there were no sales, it's simple. What if you had some partial sales during the years? Will you still divide the gain by the original $10,000, or deduct the sales proceeds from the $10,000?
Reply With Quote Quick reply to this message
 
Old 11-03-2018, 08:46 PM
 
Location: Wisconsin
25,581 posts, read 56,585,510 times
Reputation: 23406
I would add gross proceeds from whatever I sold during the year (assuming you didn't reinvest into something else) back into the 12/31 value and then do the calculation. This will not be 100% accurate because if you bought at 5 and sold at 8 within 3 three months, the ROI on that transaction would be much higher on an annualized basis - i.e. 240% assuming you were able to repeat that result every three months. Ridiculous one-off number.

Now, if you're a trader, then it's quite possible you would be seeing these gains. People make a living trading on sharp price swings and reap handsome profits over very short periods of times - so that's a whole 'nother kettle of fish - and their annualized ROIs would be astronomical. But, trading is very different from investing. I doubt annualized ROIs matter much for traders except for their long-term holdings.

Last edited by Ariadne22; 11-03-2018 at 08:55 PM..
Reply With Quote Quick reply to this message
Please register to post and access all features of our very popular forum. It is free and quick. Over $68,000 in prizes has already been given out to active posters on our forum. Additional giveaways are planned.

Detailed information about all U.S. cities, counties, and zip codes on our site: City-data.com.


Reply
Please update this thread with any new information or opinions. This open thread is still read by thousands of people, so we encourage all additional points of view.

Quick Reply
Message:


Over $104,000 in prizes was already given out to active posters on our forum and additional giveaways are planned!

Go Back   City-Data Forum > General Forums > Economics > Investing
Similar Threads

All times are GMT -6. The time now is 10:35 AM.

© 2005-2024, Advameg, Inc. · Please obey Forum Rules · Terms of Use and Privacy Policy · Bug Bounty

City-Data.com - Contact Us - Archive 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37 - Top