Finance Journey

Introduction: I've linked my Excel [ SOURCE ], the switch in cell B1 is adjustable so e.g. 2 is for Coca Cola FEMSA, it will show you the pricing of Coca Cola FEMSA under Revenue, EBIT and PE ratio for median and 75th percentile.  Not really sure if linking works, so here's the link: https://www.dropbox.com/scl/fi/n8e5yc5kcrkpj67gt6dgp/Bottling-COMPS.xlsx?dl=0&rlkey=o3khqi16u1ewougjw351f8o8y Bottling is a separate arm of the soft drink industry. Companies usually outsource this to focus on what they do best in, producing the syrup. The bottling industry gets the syrup from e.g. KO and bottles it before selling it to consumers e.g. Supermarkets. I'll be zooming in to 1 company that particularly stands out Thai Beverage(Y92.SI).  Comparable Companies: The main criteria I had when selecting comparable companies was Market Cap and Revenue Size. My comparable companies are Arca Continental (AC.MX), Coca Cola FEMSA (KOF), Coca-Cola Consolidated (COKE), National Beverage Corp....

Introduction: I did a DCF during Bob Chapek's reign and now during Bob Iger's reign, I think DIS is a lemon not because of how badly the company is ran but rather the industry that DIS is in. In this new DCF, I gave my opinion on certain arms of the business and even made assumptions that DIS will pivot fast enough into greener pastures. But even that didn't save the value of this company. Not to mention, this company utterly sucks at reporting their financials so a fair bit of simplifying assumptions had to be made. But I'll tear apart why my old DCF was wrong in the end. REVENUE: DMED (%REV) The emphasis on DMED will eventually fade away, linear network seems to be phasing out in popularity as it’s mainly being held up by Gen X and Baby Boomers ( SOURCE ), The average life expectancy is 72 years ( SOURCE ). So DIS will pivot away from Linear Network, as evident by management's heavy emphasis on DIS+ especially during conference calls. “About 50% of this demographi...

Introduction: Google was the first company I've ever valued, back then when I valued this company I remember being excited that I had finally created my first financial model without any components of my excel blowing up. Every single number wasn't a "Hmm 5% looks good." And I thought that my DCF was airtight. I posted it onto Reddit and the comments thrown me back down to reality. " These numbers make absolutely no sense" and " I suggest you look more into dcf analysis". My reaction: 😔😔. But, I marched on and 6 months and 7 DCF later, I revisited my GOOG DCF. My first reaction was "It looks like what a toddler does with a calculator pressing random numbers." So to retackle and improve my DCF again was definitely a fruitful lesson. Perhaps I may revisit this 1 year from now! REVENUE: Cloud %Rev, Cloud is an area gaining massive traction due to how much convenience it adds, And the switching cost of cloud is massive, having to port over ...