Reference no: EM131355735
1. Download all the appropriate annual financial statements for Coca Cola (KO), Pepsi (PEP), and Dr. Pepper-Snapple (DPS) for fiscal years ending December in 2012, 2013, 2014, and 2015. My favorite source for these financial statements is www.finance.google.com but you can use any reliable source you want as long as you tell me where you get these financial statements.
2. Use the financial statements in Step 1 to calculate any 4 financial ratio you would find relevant.
3. Using the financial ratios you calculated in Step 2, try to understand why the rates of the three companies are very different. I want you to think about a story based on the financial ratios in Step 2 that would explain why, for example, Dr. Pepper-Snapple maybe in much better/worse shape than Coca Cola and Pepsi.
4. For each of the three companies find out the annual dividend payments made during the fiscal years ending on December, 2012, 2013, 2014, and 2015. You can find the cash dividend payments in the Statement of Cash Flows.
5. For each year (2012, 2013, 2014, and 2015) calculate the internal and sustainable growth rates for each company. Also, calculate the average (over three years) internal and sustainable growth rates for each company.
6. For each of the three companies and their industry find out the expected (by analysts) growth rate of earnings for the next 5 years. For this purpose my favorite source is www.finance.yahoo.com, you can use the area called Analyst Estimates to get these numbers.
7. For each company, assume that dividends will grow at their expected growth rate for the next 5 years, and then at their average internal growth rate forever, calculate the value of the stock using the dividend growth model. Assume that the required rate of return is 15% for all three companies.
8. Find out the closing price of each stock at the end of December 2015. Under the same set of assumptions about the dividend growth in Step 7, find out the required rate of return implied by the closing price of each company.
9. Assume again that the required rate of return is 15% for each company. Assume that the dividends will grow at the expected growth rate for the next 5 years and at a constant rate thereafter. Find out the dividend growth rate after 5 years that is implied by the closing stock price of each company.
10. Your final report should be in a SINGLE WORD file that contains at least:
a. all the financial statements you downloaded as readable tables.
b. all the financial ratios you calculated as an easily understandable table.
c. a justification for each ratio you calculated and reasons why the set of ratios you used is sufficient and important for the purpose at hand.
d. a consistent story that compares Dr. Pepper-Snapple with Coca Cola and Pepsi based on the financial ratios you calculated. You have to make sure that any claim you make is based on data! Simple assertions do not carry any value even when they are correct.
e. a critical comparison of the stock valuation you obtained in Step 7 to the closing prices at the end of December 2015. Make sure to tell me whether each stock is over or undervalued. Your conclusions should be supported by the evidence provided by at the least: the financial statements and ratios, reverse-engineering conclusions in steps 8 and 9. Feel free to use any other source of information as justification for your analysis as long as you properly cite such sources.
|
Provide a general explanation of data trees
: Provide a general explanation of data trees. Then, select two specific types of data trees and compare them. For this Discussion, you should provide at least one type of data tree that has not yet been posted by a colleague.
|
|
What is its payback period
: If it costs $20 000 to purchase, what is its payback period? Assume that the savings are earned throughout the year, not just at year-end.
|
|
Why do you believe this approach inadequate
: HRMN 302 6380: In this week's video Professor Koschmann moves beyond conventional views of organizational communication. Reflect for a moment on the video ideas. What does Professor Koschmann mean by the "flat earth" approach? Why do you believe t..
|
|
Explain computer literacy-explain computer algorithms
: 1. Explain computer literacy. 2. Explain computer algorithms and its significance. 3. Explain some of the technologies that have contributed to the exponential growth of the Internet and the World Wide Web (WWW)
|
|
Find the cash dividend payments
: For each of the three companies find out the annual dividend payments made during the fiscal years ending on December, 2012, 2013, 2014, and 2015. You can find the cash dividend payments in the Statement of Cash Flows
|
|
Different types of problem insurance claims
: Identify the different types of problem insurance claims. Tell why you think a particular claim can be a "headache".Discuss follow-up techniques for tracking unpaid insurance claims.
|
|
Which of katzs management skills are evident in the video
: MGT-240: Which of Mintzberg's managerial roles do Ledogar and Vik display in the video? Which of Katz's management skills are evident in this video? In what way is One Smooth Stone an open system? Explain your answer.
|
|
Which lamina cracks first thus defining fpf
: Using the notation of carpet plots, this laminate has α = 0.5, β = 0.5, γ = 0. Using the methodology presented in this chapter, compute the laminate FPF strength Fxt. Which lamina cracks first, thus defining FPF?
|
|
Computer forensics and traditional forensics
: 1. The difference between computer forensics and traditional forensics 2. Discuss the issues you deem important in computer forensics.
|