English(U.S.)

Description
Attached Excel file contains data (balance sheet, income statement, consolidated statement of cash flow) necessary for calculations.

There is a sample project attached (Tiffany & Co Company).

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.