Stock valuation via discounted dividend model: Use constant growth model or non-constant growth model to estimate the intrinsic stock value. Use CAPM to determine the required return for the McDonalds stock via yahoo finance.

(Hint: Annualize the required return on the stock, aggregate the quarterly dividends into annual ones, and perform the analysis on annual basis. You may try to begin with assuming the 60-month average of SHY as the riskfree rate, and the 60-month average of SPY as the expected market return; alternatively, you may consider other inputs for CAPM.

Oct 01, 2019 3,436.50 4,050.00 3,409.50 3,900.50 3,900.16 5,784 Sep 01, 2019 3,225.00 3,771.00 3,225.00 3,382.50 3,382.21 528 Aug 30, 2019 0.29 Dividend Aug 01, 2019 2,356.50 3,323.50 2,356.50 3,225.00 3,224.43 3,364 Jul 01, 2019 2,186.00 2,357.00 2,186.00 2,323.00 2,322.59 760 Jun 01, 2019 2,236.50 2,267.00 2,186.00 2,186.00 2,185.61 212 May 31, 2019 0.29 Dividend May 01, 2019 2,078.00 2,261.00 2,078.00 2,212.00 2,211.32 5,660 Apr 01, 2019 1,890.00 2,084.00 1,890.00 2,078.00 2,077.36 Mar 01, 2019 1,799.50 1,890.00 1,799.50 1,890.00 1,889.42 32 Feb 28, 2019 0.29 Dividend Feb 01, 2019 1,750.00 1,799.50 1,659.00 1,799.50 1,798.66 17,460 Jan 01, 2019 1,745.70 1,750.00 1,697.50 1,750.00 1,749.18 8,648 Dec 01, 2018 1,673.85 1.745.70 1,673.85 1.745.70 1.744.88 12 Nov 30, 2018 0.29 Dividend Nov 01, 2018 1,508.00 1,673.85 1,508.00 1,673.85 1,672.78 6,224 Oct 01, 2018 1,596.00 1,596.00 1,508.00 1,508.00 1,507.03 468 Oct 01, 2019 3,436.50 4,050.00 3,409.50 3,900.50 3,900.16 5,784 Sep 01, 2019 3,225.00 3,771.00 3,225.00 3,382.50 3,382.21 528 Aug 30, 2019 0.29 Dividend Aug 01, 2019 2,356.50 3,323.50 2,356.50 3,225.00 3,224.43 3,364 Jul 01, 2019 2,186.00 2,357.00 2,186.00 2,323.00 2,322.59 760 Jun 01, 2019 2,236.50 2,267.00 2,186.00 2,186.00 2,185.61 212 May 31, 2019 0.29 Dividend May 01, 2019 2,078.00 2,261.00 2,078.00 2,212.00 2,211.32 5,660 Apr 01, 2019 1,890.00 2,084.00 1,890.00 2,078.00 2,077.36 Mar 01, 2019 1,799.50 1,890.00 1,799.50 1,890.00 1,889.42 32 Feb 28, 2019 0.29 Dividend Feb 01, 2019 1,750.00 1,799.50 1,659.00 1,799.50 1,798.66 17,460 Jan 01, 2019 1,745.70 1,750.00 1,697.50 1,750.00 1,749.18 8,648 Dec 01, 2018 1,673.85 1.745.70 1,673.85 1.745.70 1.744.88 12 Nov 30, 2018 0.29 Dividend Nov 01, 2018 1,508.00 1,673.85 1,508.00 1,673.85 1,672.78 6,224 Oct 01, 2018 1,596.00 1,596.00 1,508.00 1,508.00 1,507.03 468