finance f303 (coca-cola)(ko)

see the file 

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