| Earnings Annual | | Estimated G | Stock: | MCD |
| 2014 (TTM) | 4.75 |
| 2015 (12-month forward) | 5.2 | 9.47% |
| 2016 (2-year forward) | 5.73 | 10.19% |
| | 2-year Annualized G | 9.83% |
| | Discount/Premium Factor | 0 |
| | Discounted G | 0.00% |
| Annualized S&P for 20 years | Market Rate | 11.00% |
| Using 2% (not 3 month rate) | Risk Free Rate | 2.00% |
| | Beta | 0.5 |
| | Discount Rate CAPM | 6.50% |
| 2014 | 5.2 | 4.88 |
| 2015 | 5.73 | 5.05 |
| 2016 | 5.73 | 77.72 |
| Current Price | Valuation | 87.66 |
| 95.32 |
| | Estimated Forward PE | 16.86 |
| | Current PE | 20.0673684211 |
| Earnings Annual | | Estimated G |
| 2013 (TTM) | 4.75 |
| 2014 (12-month forward) | 5.2 | 9.47% |
| 2015 (2-year forward) | 5.73 | 10.19% |
| | Constant Annualized G | 9.83% |
| Using Goal Seek | G Need For Current Price | 0.55% |
| Annualized S&P for 20 years | Market Rate | 11.00% |
| Using 2% (not 3 month rate) | Risk Free Rate | 2.00% |
| | Beta | 0.5 |
| | Discount Rate CAPM | 6.50% |
| 2014 | 5.2 | 4.88 |
| 2015 | 5.73 | 5.05 |
| 2016 | 5.76 | 85.39 |
| Current Price | Valuation | 95.32 |
| 95.32 |
Coger01
2_dcf_valuation_mcd-updated_2.xlsx
