racemize Posted May 1, 2019 Share Posted May 1, 2019 Hi All, I'm working on an essay for calculating how it takes for price and value to converge, so far I've done it for the S&P back to 1871 and Berkshire since Buffett. I thought another good one would be Coca Cola, but I am having trouble finding the data. I need annual price, annual earnings, and annual dividends, ideally back to the early 20th century. Does anyone have it or know where to get it? Warmly, Joel Link to comment Share on other sites More sharing options...
Dynamic Posted May 2, 2019 Share Posted May 2, 2019 Sorry, I don't know how to go back that far with free resources, but this does sound like a good idea. It can show how a single long-term holding could provide the majority of a portfolio's returns over the long term if you can bear to let it run and not sell your compounding winner. It might also be worth obtaining the numbers for one or two defunct companies to show things such as: • how value can still be realised even as a company winds down but distributes capital via dividends or special dividends and spin-offs. • how value can be lost almost entirely if you're very wrong about the company's prospects. It doesn't have to be a fraud like Enron, but perhaps a great company like Nokia or RIM/Blackberry or local monopoly newspapers whose lofty expectations based on great performance and competitive strength turned to dust as disruptive change came to their industry. You could also show how if you realise it's unravelling after you've lost 60%, you could still be better off selling and baking in your losses then before it drops by 95% of your original stake. You don't have to make it back the way you lost it. The lessons from firms like KO could be great too. For example recognising that even the New Coke debacle was a temporary setback and the price was likely to recover, and looking at the failure of rivals like Virgin Cola and other well funded entrants to unseat the Coke/Pepsi brands for such a modest-priced and widely distributed product. Link to comment Share on other sites More sharing options...
Cigarbutt Posted May 3, 2019 Share Posted May 3, 2019 You may not be familiar with the Comgest people but they occasionally produce interesting white papers and tend to mean that long-term is longer than 3 months. The 2014 Long-term Growth Conundrum paper may contain the info that you're looking for (page 10): http://www.comgest.com/export/sites/default/data/en_data/media/images/WP6_2014-09_LT_Growth_Connundrum_EV_EN.pdf The numbers appear right and I assume that the share prices listed correspond to the share prices at year-end. You start in 1919 with 1 share and end up (if you're still alive) with 279803 shares (at the end of 2013). I would call it sizzling compounding. Let's drink to that! Today's trailing PE is 31. Link to comment Share on other sites More sharing options...
rukawa Posted May 16, 2019 Share Posted May 16, 2019 Hi All, I'm working on an essay for calculating how it takes for price and value to converge, so far I've done it for the S&P back to 1871 and Berkshire since Buffett. I thought another good one would be Coca Cola, but I am having trouble finding the data. I need annual price, annual earnings, and annual dividends, ideally back to the early 20th century. Does anyone have it or know where to get it? Warmly, Joel Its really funny because they used to have this on their freaking website!!!!!! Exactly what you wanted. And now I look at their website and its total garbage. Microsoft used to have an excel spreadsheet with their financials going back to their IPO. All these god-awful site redesigns have made these pages much less informative. Link to comment Share on other sites More sharing options...
StubbleJumper Posted May 16, 2019 Share Posted May 16, 2019 Hi All, I'm working on an essay for calculating how it takes for price and value to converge, so far I've done it for the S&P back to 1871 and Berkshire since Buffett. I thought another good one would be Coca Cola, but I am having trouble finding the data. I need annual price, annual earnings, and annual dividends, ideally back to the early 20th century. Does anyone have it or know where to get it? Warmly, Joel Its really funny because they used to have this on their freaking website!!!!!! Exactly what you wanted. And now I look at their website and its total garbage. Microsoft used to have an excel spreadsheet with their financials going back to their IPO. All these god-awful site redesigns have made these pages much less informative. If it previously existed on their website, it might be recoverable by using the Wayback Machine: https://archive.org/web/ SJ Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now