PepsiCo Multiples Valuation

This time around I decided to change industries completely from big-tech to food and beverages. I was eating a bag of Cheetos while thinking of which company I should do my next valuation for and then it came to me. Let's do PepsiCo.

For the comparable companies, I decided to use Coca-Cola, Dr-Pepper, Monster Energy, Nestle, and National Beverage Corp. ( mainly known for manufacturing La Croix). It's obvious that Pepsi's biggest competitor in the soft drink market is Coca--Cola, so it makes sense that Coke would be my first choice. Dr-Pepper is also a rather prominent soft drink brand in the world, so I chose it as another competitor to compare Pepsi with. Monster Energy, even though it is known for making energy drinks, is still big in the beverages industry, thus a perfect choice to chose as a competitor to compare Pepsi with. On the other hand, Nestle is a much more balanced competitor with Pepsi, as it competes with Pepsi in terms of both food and beverages. Whether it be competition in the breakfast game, water, among other things. Despite being a rather obscure company, National Beverage Corp has a game changer with La Croix that serves as a strong competitor to Pepsi's beverage offering.

Multiples Valuation

As we can see with this analysis, PepsiCo's stock is currently undervalued, as the fair value of the company is $161, which is decently higher than the current stock price of $142.35. The process for doing this analysis is straightforward. I used Yahoo finance and annual reports of all the relevant firms to copy the values onto Excel.

For my next blog, I will do one last multiples valuation.

Comments

Apple Multiples Valuation

Unlike a traditional DCF model, doing a multiples analysis with comparable companies is a lot easier and quicker to do. The four companies I used to compare with Apple are: Microsoft, Amazon, Netflix, and Google. I used Microsoft because Apple and Microsoft are competitors in the field of hardware, mainly computers. Amazon and Apple are comparable because they're both tech giants in their respective fields and even have services in common such as Amazon Prime/Apple TV and Siri/Echo. Similarly, Netflix and Apple compete with each other in regards to their streaming services. Google and Apple both produce hardware like home-pods, phones and computers, despite Apple being considerably larger. The multiples that I used for the valuation are: EV/Sales, EV/EBITDA, EV/EBIT, and P/E. EV is the Enterprise Value of a company, which can be calculated by subtracting cash and cash equivalents and adding total debt to the Market cap. EV is the true value of a company while taking into account

DCF Valuation - Netflix

Time to put everything together with this blog post looking at DCF for Netflix. In the case of WACC, I got a percentage of 12%. I still have difficulties calculating it, so I know I need to improve on that front. Conclusion: Netflix stock is overvalued at 12%. I think in order to make my analysis more effective I can include a What-If analysis that includes a variety of WACC and perpetual growth rate percentages.

3-Statement Model - Netflix

To be honest, this was a lot more time consuming than I thought it would be. But, I'm glad I got it done. First thing to note with this 3S model is that it was designed specifically to integrate with a DCF Valuation, which will be shown in the next blog post.

Markets Reverie

Search This Blog