Pick a company that pays dividends, then calculate the ...
Pick a company that pays dividends, then calculate the expected growth rate of your company using the CAPM.
Once this task is complete, calculate the expected growth rate using the Constant Growth (or Gordon Growth) Model.
You may need additional information to complete this exercise. You can find a stock's beta and growth rate at . Once there, enter the ticker for the company in question. Then, click on "Key Statistics" about halfway down the left hand side of the page. You can find the beta here.
Alternatively, you can go to . Click on "Stocks" at the top left of the page. Enter the ticker symbol for the company in question. Click on "Ratios" about halfway down the left hand side of the page.
Dow Chemical Co. (DOW)
Beta = 0.8
Assuming that:
Rf = 4%
Rm = 12%
In 2001 Dow Chemical paid a dividend of $1.29 per share, and in 2007 they paid $1.63 per share, while the forecast for 2008 is 1.68 but since there is still some time left in 2008, we cannot base our calculations on the forecasted figures.
Solution
Using CAPM:
Rf = 4%
Rm = 12%
Beta = 0.8
Since:
[pic]
Where RE is the Rate of Return on Stock
[pic]
= 10.4%
Growth rate (g) = 3.98% (Please see the attached excel sheet for the calculations)
[pic]
= [pic]
= $26.17
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- stock trak assignment 1
- solution to exercise set 1 columbia business school
- cfm excel templates
- using spreadsheet to determine value using residual income
- financial statement analysis the basic spreadsheets
- 1 calculate the after tax cost of a 25 million debt
- instruction for case 5 faculty pages
- thomson one business school edition
- fm10 chapter 10
- pick a company that pays dividends then calculate the