Do it for Nike and McDonald just do the excel work and take screenshots for the 3 different methods

Image transcription text

1. Security Valuation — Follow the in-class instructions for security valuation. Make sure that H a. Use an excel template on Canvas. 1). Analyze your two main stocks. c. Find the intrinsic value of your stocks in 2023 using three different models below. 1 Dividend discount model (DDM) 2. FEB valuation 3. Free cash flow valuation (FCF} 4. Which valuation methodology is the most suitable? Provide your reasoning on the estimated intrinsic value for

Transcribed Image Text:

1. Security Valuation - Follow the in-class instructions for security valuation. Make sure that you a. Use an excel template on Canvas. b. Analyze your two main stocks. c. Find the intrinsic value of your stocks in 2023 using three different models below. 1. Dividend discount model (DDM) 2. P/E valuation 3. Free cash flow valuation (FCF) 4. Which valuation methodology is the most suitable? Provide your reasoning on the estimated intrinsic value for 1. Security Valuation - Follow the in-class instructions for security valuation. Make sure that you a. Use an excel template on Canvas. b. Analyze your two main stocks. c. Find the intrinsic value of your stocks in 2023 using three different models below. 1. Dividend discount model (DDM) 2. P/E valuation 3. Free cash flow valuation (FCF) 4. Which valuation methodology is the most suitable? Provide your reasoning on the estimated intrinsic value for