ko Expected Price Worksheet

ko Expected Price Worksheet - (in millions) 2333.794...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Current Price= $65.16 Valuation Data 2010 2009 2008 2007 2006 2005 ### Tangible Bk. Val. 1.79 5.2 3.45 8.53 5.08 5.29 ### 5.7 3.46 2.94 3 2.56 2.43 ### Earnings 5.06 2.93 2.49 2.57 2.16 2.04 ### Dividends 1.76 1.64 1.52 1.36 1.24 1.12 ### Payout Ratio 35% 56% 61% 53% 57% 55% ### Prices - High 65.88 59.45 65.59 64.32 49.35 45.26 ### 49.47 37.44 40.29 45.56 39.36 40.31 ### P/E Ratio - High 13 20 26 25 23 22 ### - Low 10 13 16 18 18 20 ### Financial Data (From Income Statement) 2011 2010 2009 2008 2007 2006 Net Inc. 11,809 6,824 5,807 5,981 5,080 4,872 Depr. 1,443 1,236 1,066 1,012 938 932 Int. Exp. 733 355 438 456 220 240 Eff. Tax Rate 23% 22% 24% 23% 27% Pretax Inc. 14,243 8,946 7,439 7,873 6,578 6,690 Oper. Inc. 10,780 9,780 9,862 8,532 7,246 7,017 Revs. 35,119 30,990 31,944 28,857 24,088 23,104 # Of shares outstanding
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: (in millions) 2333.794 2329.010 2332.129 2327.237 2351.852 2388.235 Sales Per Share 15.048 13.306 13.697 12.400 10.242 9.674 Avg Annual P/E Ratio 18.6667 11.500 16.500 21.000 21.500 20.500 21.000 Avg Annual P/S Ratio 4.7973 3.867 6.275 4.492 4.317 5.144 4.689 Avg Annual P/CF Ratio 15.8853 10.209 13.973 17.786 18.418 17.297 17.630 Estimated Financial Growth 4.00% Expected Upside from current stock price Exprcted Prices P/E Ratio $98.23 50.8% P/S Ratio $66.39 1.9% P/CF Ratio $94.17 44.5% Coca-Cola Co Cash Flow Low...
View Full Document

Ask a homework question - tutors are online