Extra Credit
Estimate the cost of capital for Dr Pepper Snapple Group Inc.(NYSE:DPS) using two different methods. Follow all instructions given. Any time you see an X or instructions in bold, you should replace them with the answer. Instructions for how to embed an Excel Spreadsheet into a Word Document are at the end of the document. Show all of your work.


1) Dividend Growth Model
a) What is the current annualdividend (D0)? On the Yahoo finance page follow the link for “Historical Prices” and then “Dividends Only.” This table can be exported into Excel to help you do calculations by clicking on “Download to Spreadsheet.”
Embed Excel Spreadsheet showing dividends for the last few years.
Current annual dividend = X
b) Determine the annual dividend for the past several years. Is there an approximate pattern to the dividends? Are the dividends constant, growing, or uneven?
c) If the dividends grow over time, find dividend growth (g).
g = X
d) Find the current stock price (P0).
P0 = X
e) Using the information above calculate the cost of equity using the constant dividend model or the dividend growth model or state that neither one can be used.
Cost of Equity = X

2) Capital Asset Pricing Model
a) Several sources list ß including Reuters, Google Finance, and Yahoo Finance. Find ß from 3 different sources. State which source you used. Why are the betas different from different sources?
Source 1 = X, ß = X
Source 2 = X, ß = X
Source 3 = X, ß = X
Reason why betas are different.
b) Estimate ß yourself.
i) From the Yahoo finance webpage, download the historical stock price of your company and use them to calculate returns.
Embed an Excel Spreadsheet showing the stock price and returns with only few lines showing.
ii) From the Yahoo finance webpage, download the historical price of the S&P 500 index to use as an approximation of market performance. Use the prices to find returns.
Embed an Excel Spreadsheet showing the stock price and returns with only few lines showing.
iii) Run a regression in which returns of the company are the dependent variable and S&P 500 index returns are the independent variable. Note: Your estimate of ß should be very similar to the ßs that you provided above. If it is very different, you are doing something wrong.
Show regression results.
ß = X
iv) Find Rf. What is the risk-free rate based on?
Rf= X
State the source of Rf
v) You can assume that Market Risk Premium is 6.1%. Using the information above, calculate the cost of equity using the CAPM.
Cost of Equity =
3) Based on your different estimates, what do you think that the cost of equity is?
Cost of Equity =

Do you lack time and skills to write this paper, We have expert writers in this subject who can handle all your questions in the shortest time. We promise and deliver quality ONLY. Our clients are always satisfied and come back for more of our custom essays.

We take plagiarism seriously. For this reason all essays are written from scratch and delivered to one client only. Another client ordering the same paper would get a totally different writer and paper altogether. Once done, our quality department checks the papers for plagiarism and grammar mistake using one of the premium plagiarism checkers on the internet. This eliminates any chances of plagiarism to 0. Once done, you have up to a month for unlimited revision and even more in case of a dissertation.

For this reason, you have no need to worry about the Quality and the originality of the papers we prepare.

ORDER today and enjoy yourself as we handle everything for you.

Order NOW