Valuing Coca Cola Stock
Valuing Coca Cola Stock
Executive Summary
The problem set forth in the Coca-Cola case was aimed at making an investment decision regarding the company’s stock. By utilizing the Capital Asset Pricing Model, (CAPM), we were able to establish an appropriate rate. The Constant Growth Dividend Model and the P/E Multiple Model allowed us to determine a fair price and compare it to the stock’s current price.
Company Overview
According to the case study Coca Cola international groups (Latin America, Middle East, Far East, Africa and Greater European Groups) are expected to continue a steady rate of growth in the year 1998. Therefore, the investment in this group will still be a positive of around 15% in the next three to five years, due to the rapid increase in new markets such as China India and the Middle East. Domestically Coca Cola is projected to stay at a high level of sales. A slight increase can be expected in the upcoming business periods due to Coke’s new Barq’s and PowerAde line.
Methodology/ Sensitivity Analysis
When using the CAPM model we chose to implement the adjusted beta. We felt the adjusted beta would be the appropriate choice. This is due to the fact that we want to know the future financial status of Coke. The raw beta is derived from the history of the stock, not the future cash flows. The Raw beta is based on the last 24 months. A stock’s price history is typically of little concern when investing in a company. Prices are based on expected cash flows, which adjusted beta is also based on. To further my point, Coca Cola has been around for many decades. The last 24 months is no true indication of what the future value of Coca Cola will be.
We chose a 10 year bond as the risk free rate. The purpose of this rate is because; we wanted a model with a higher required return (compared to a 5 year bond). With a higher required return we can make sure this is a good investment.
The case study stated Coke was trading at 58 dollars per
Executive Summary
The problem set forth in the Coca-Cola case was aimed at making an investment decision regarding the company’s stock. By utilizing the Capital Asset Pricing Model, (CAPM), we were able to establish an appropriate rate. The Constant Growth Dividend Model and the P/E Multiple Model allowed us to determine a fair price and compare it to the stock’s current price.
Company Overview
According to the case study Coca Cola international groups (Latin America, Middle East, Far East, Africa and Greater European Groups) are expected to continue a steady rate of growth in the year 1998. Therefore, the investment in this group will still be a positive of around 15% in the next three to five years, due to the rapid increase in new markets such as China India and the Middle East. Domestically Coca Cola is projected to stay at a high level of sales. A slight increase can be expected in the upcoming business periods due to Coke’s new Barq’s and PowerAde line.
Methodology/ Sensitivity Analysis
When using the CAPM model we chose to implement the adjusted beta. We felt the adjusted beta would be the appropriate choice. This is due to the fact that we want to know the future financial status of Coke. The raw beta is derived from the history of the stock, not the future cash flows. The Raw beta is based on the last 24 months. A stock’s price history is typically of little concern when investing in a company. Prices are based on expected cash flows, which adjusted beta is also based on. To further my point, Coca Cola has been around for many decades. The last 24 months is no true indication of what the future value of Coca Cola will be.
We chose a 10 year bond as the risk free rate. The purpose of this rate is because; we wanted a model with a higher required return (compared to a 5 year bond). With a higher required return we can make sure this is a good investment.
The case study stated Coke was trading at 58 dollars per