Attached Word Document about McDonalds already contains some parts. Please add following calculations to McDonalds word document, analyze and present calculations and numbers for:
- Required Rate of return calculations
- Growth Rate implied by PRAT Model ***)
- Dividend Discount Model: Dividend growth rate forecast, Intrinsic Stock Value using Dividend Discount Model, Dividend growth rate implied by Gordon growth model
- Intrinsic Stock Value using FCFE, FCFE Growth rate implied by Gordon Growth Model
- Residual Income Valuation Approach ***)
- Relative Valuation Ratios
- Price to Earnings Ratio
- Price to Book Value Ratio
- Price to Sales Ratio
- COCNCLUSIONS: based on calculations and fundamental analysis and based on market price per share for McDonald (market price per share for any date between May 1st- May 3rd_), analyze whether company is overvalued, undervalued or fairly valued.