16 May Finance F303 (Coca-Cola)(Ko)
Assignment 2 –
Coca-Cola (KO) is the world’s largest producer of soft-drink concentrates, syrups, and juices. Its soft-drink brands include Coke, Diet Coke, Cherry Coke, Sprite, Tab, Nestea, and Barq’s. The firm sells about 59% of its concentrates and syrups to company-owned and independent bottlers in the United States and abroad, who distribute them to end users. Coca-Cola also makes fruit juices sold under names like Minute Maid.
Follow the Two-Stage DDM method presented in class (including the Two-Stage DDM spreadsheet). If you need a further review, remember that you studied the Two-Stage DDM in your F371 text. Answer the following question. You MUST show all of your calculation in the questions below is order to receive credit for any numerical answers. All five questions are worth 20 points each (5 x 20 = 100 points).
Two-Stage Dividend Discount Model
Q1. The First Step in using the Two-Stage DDM is to estimate an annual expected first-stage growth rate in dividends during stage 1, g1, AND the number of years, n, that you expect the g1 level of growth to persist. Two (2) popular methods for estimating g1 that were discussed in class are:
A. (Method 1): Form an estimate for g1, the growth rate in dividends based on the average annual historical growth in dividends over the past five (5) years. The assumption in this method is that the historical average growth rate in dividends over the past five years is a good estimate for g1 over the number of years of that you have assumed for stage 1.
B. (Method 2): Use the formula provide in the AAII article “Methods for Valuing a Stock” for estimating the sustainable growth rate in EACH of the past five years then take a simple average of these five annual sustainable growth estimates in order to arrive at a second estimate for g1. The assumption in this method is essentially that the historical average sustainable growth rate, which is essentially the expected sustainable growth rate in net income for a given level of ROE and a given retention ratio, is a good estimate for g1 (the growth rate in dividends). The sustainable growth rate formula assumes the capital structure remains constant and no new common stock is issued.
Sustainable growth rate = ROE x retention ratio
Write a short paragraph (just three sentences) that COMPARES and CONTRASTS your two estimates for g1. Are the similar? Are they extremely different? Give your thoughts on why there are similarities or differences.
You can also provide a subjective adjustment to the average value estimates of g1 above based on any other information you feel is relevant (new products, increased competition, DuPont analysis, etc.).
C. SELECT the one (1) single estimate from Q1A and Q1B above that YOU believe is the most appropriate value of g1 for valuing KO using the Two-Stage DDM. Further, LIST the number of years, n, you expect g1 to persist. Provide a short paragraph ( just three sentences) that EXPLAINS your reasoning for selecting these values of g1 AND n.
*IMPORTANT: A Key Learning Point here is that any estimate of the future growth in dividends will generally NEVER equal the actual growth that results after time passes. All financial valuation estimates are subject to forecast error, which is also referred to as estimation risk.
Q4. Using KO’s current annual dividend (most recent quarterly dividend x 4) as D(0) in the Two-Stage DDM, LIST your value (price per share) estimate for KO using the Two-Stage DDM (provide a screen shot of your Two-Stage DDM spreadsheet).
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
About Writedemy
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.