Question

In: Finance

Valuing a Stock with Three-Stage Dividend Discount Model Mocha-Cola In the morning of Tuesday, January 3rd...

Valuing a Stock with Three-Stage Dividend Discount Model Mocha-Cola In the morning of Tuesday, January 3rd 2004, Robert Smart, a security analyst at Armani Investment was reviewing the 2003 financial statements of Mocha-Cola as requested by one of their most important clients, Mr. Jin Qian. Mr. Jin Qian has accumulated a significant amount of wealth through Armani’s recommendations in the past and now he was interested in investing a sizeable amount of his wealth into Mocha-Cola stocks. Mocha-Cola, the world famous soft drink company, was able to increase its market value consistently over the last several decades. While Mocha-Cola’s growth in the domestic soft drink market has leveled off in the past few years due to aggressive marketing campaigns of its competitors (especially by TipsyCola), the analysts expect that the firm will continue to expand thanks to the introduction of new products and increased demand for Mocha-Cola products by international markets. The initial analyses carried by Robert Smart revealed that Mocha-Cola reported earnings per share of $3.00 in 2003, and paid dividends per share of $0.75. Mr. Smart asked his assistant, Paul Brook, to gather further information on Mocha-Cola as reported by other analysts. Paul’s summary of analyst reports indicated that Mocha-Cola’s earnings would grow at their extraordinary level of 20% at least for the next five years (from 2004 to 2008). While Mr. Smart concurs with this expectation, he thinks that it should decline linearly each year after the high growth period to a stable growth rate of 5% in 2013 due to severe competition in the soft-drink industry. Paul Brook also noted that according to analysts’ reports payout ratio was expected to remain unchanged from 2004 to 2008, after which it would increase each year equally to reach its steady state value of 80% in 2013. By the end of the day, Mr. Smart was already tired and overwhelmed with the amount of information accumulated. He asked Paul to calculate the stock price of MochaCola by using three-stage dividend discount model and assuming a 15% required rate of return. The results were expected to be ready for presentation by 10:00 a.m. on Wednesday. While Paul was very proficient in terms of putting necessary inputs together as he did in this task, he had never actually run the three-stage dividend discount model on his own. He took another sip from his coffee and got ready to prepare a full, fresh pot that he was going to need for the rest of the night.

Please show excel formulas !

Solutions

Expert Solution

I will show you two snpashots: one with the figures and answers and the other one in formula mode so that you can create the excel model yourself at your end.

Basic concepts used:

1. DPS = EPS x Dividend payout ratio

2. Terminal value of dividend at the end of year 9 = DPS of year 10 / (Ke - g)

The final answer is $ 40.32 as highlighted in yellow colored cell.

Snapshot 1

Snapshot 2


Related Solutions

What are the strengths and weaknesses of the dividend discount model as a method of valuing...
What are the strengths and weaknesses of the dividend discount model as a method of valuing a firm?
So called “H-Model” in stock valuation is a variant of the following model. 3-stage dividend discount...
So called “H-Model” in stock valuation is a variant of the following model. 3-stage dividend discount model (DDM) 2-stage DDM the Gordon model
Find the intrinsic value of a share of stock XYZ using the two-stage dividend discount model....
Find the intrinsic value of a share of stock XYZ using the two-stage dividend discount model. The data for the valuation model has been obtained from the Value Line Research Center. Because the report contains data from the end of 2014, we will use the end of 2014 (after the 2014 dividend has been paid) as t = 0. (Need guide starting from part d, thank you so much) a) (5 pts) The XYZ's beta from Value Line is 1.35....
. Dividend discount model: Consider the following three stocks: a. Stock A is expected to provide...
. Dividend discount model: Consider the following three stocks: a. Stock A is expected to provide a dividend of $15 a share forever. b. Stock B is expected to pay a dividend of $9 next year. Thereafter, dividend growth is expected to be 4% a year forever. c. Stock C is expected to pay a dividend of $9 next year. Thereafter, dividend growth is expected to be 30% a year for three years (i.e., years 2 through 4) and zero...
What are the limitations of the dividend discount model? A stock currently pays a dividend of...
What are the limitations of the dividend discount model? A stock currently pays a dividend of $4 for the year. Expected dividend growth is 20% for the next three years and then growth is expected to revert to 4% thereafter for an indefinite amount of time. The appropriate required rate of return is 10%. What is this stock’s intrinsic value? What is the rate of return on an investment that costs $500 and is sold after 1 year for $560?
What are the limitations of the dividend discount model? A stock currently pays a dividend of...
What are the limitations of the dividend discount model? A stock currently pays a dividend of $4 for the year. Expected dividend growth is 20% for the next three years and then growth is expected to revert to 4% thereafter for an indefinite amount of time. The appropriate required rate of return is 10%. What is this stock’s intrinsic value? What is the rate of return on an investment that costs $500 and is sold after 1 year for $560?
Using a dividend discount model, what is the price for this stock? Stock covariance with the...
Using a dividend discount model, what is the price for this stock? Stock covariance with the market= 0.5 Market variance = 0.25 Stock covariance with a second risk factor= 0.6 Variance of the second factor= 0.3 Market Premium:3% Second factor risk premium=1% Risk free rate =2 % Current earnings per share= $5, The ROE is expected to shrink (decrease) at the rate 10% for first 5 years The ROE is expected to grow at the rate 8% forever after the...
Enumerate the steps of using dividend discount model to value stock?
Enumerate the steps of using dividend discount model to value stock?
In year 2008, Janet’s firm is using a two-stage dividend discount model (DDM) to find the...
In year 2008, Janet’s firm is using a two-stage dividend discount model (DDM) to find the intrinsic value of SmileWhite Co. The risk-free interest rate is 4.5% and expected return of market is 14.5% and beta of the SmileWhite Co. is 1.15. In 2008, dividend per share is $1.72 for the company. Dividends are expected to grow at a rate of 12% per year for the next three years until 2011. After 2011 dividend growth rate will be at constant...
Explain the advantages of using a two-stage dividend discount model (DDM) to value a share rather...
Explain the advantages of using a two-stage dividend discount model (DDM) to value a share rather than a constant-growth dividend model. Using a simple numerical example, describe one weakness in all DDMs
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT