11-12
Chapter 11
Risk-Adjusted Expected Rates of Return and the Dividends Valuation Approach
Dividends Valuation for Coca-Cola
Dividends-Based Valuation Year +1 Year +2 Year +3 Year +4 Year +5 Year +6
Dividends Paid to Common Shareholders $ 5,506.7 $5,681.5 $5,852.5 $6,029.4 $6,212.4
Less: Common Stock Issues 53.0 (556.4) (559.2) (553.1) (547.3)
Plus: Common Stock Repurchases 885.7 1,865.8 1,979.1 2,095.7 2,214.4
Dividends to Common Equity 6,445.4 $6,990.9 $7,272.4 $7,572.0 $7,879.6 $7,678.6
Present Value Factors 0.930 0.865 0.805 0.749 0.697
Present Value Net Dividends $ 5,995.7 $6,049.5 $5,854.0 $5,669.9 $5,488.6
Sum of Present Value Net Dividends $ 29,057.8
Present Value of Continuing Value $ 118,858.4
Total $ 147,916.2
Adjust to Midyear Discounting 1.0375
Total Present Value Dividends $ 153,463.0
Shares Outstanding 4,324.0
Estimated Value per Share $ 35.49
Current Share Price $ 42.96
Percent Difference (17%)