Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Data as given in the problem are shown below: Goodman Industries Year Stock Price Dividend 2020 $30.32 $2.23 2019 $23.53 $2.65 2018 $28.61 $2.73 2017
Data as given in the problem are shown below: Goodman Industries Year Stock Price Dividend 2020 $30.32 $2.23 2019 $23.53 $2.65 2018 $28.61 $2.73 2017 $15.21 $2.57 2016 $12.63 $2.23 2015 $13.21 $2.25 Landry Incorporated Stock Price $85.12 $79.32 $74.32 $87.12 $95.12 $84.25 Market Index Dividend Includes Divs. $3.52 18,475.97 $3.65 12,174.55 $3.45 12,019.97 $3.47 10,743.05 $3.55 9,455.42 $3.25 8,163.96 RATES OF RETURN GOODMAN 2020 38.33% (=(EG24+EH24-EG25)/EG25) 2019 -8.49% 2018 106.05% 2017 40.78% 2016 12.49% LANDRY 11.75% (=(EJ24+EK24-EJ25)/EJ25) 11.64% -10.73% -4.76% 17.12% MARKET 51.76% (=(EM24-EM25)/EM25) 1.29% 11.89% 13.62% 15.82% AVERAGE 37.83% (=AVERAGE(EG33:EG37)] 5.00% (=AVERAGE(EJ33:EJ37)] 18.87% (=AVERAGE(EM33:EM37)] Construct a scatter diagram graph that shows Goodman's and Landryreturns on the vertical axis and the Market Index's returns on the horizontal axis. Data as given in the problem are shown below: Goodman Industries Year Stock Price Dividend 2020 $30.32 $2.23 2019 $23.53 $2.65 2018 $28.61 $2.73 2017 $15.21 $2.57 2016 $12.63 $2.23 2015 $13.21 $2.25 Landry Incorporated Stock Price $85.12 $79.32 $74.32 $87.12 $95.12 $84.25 Market Index Dividend Includes Divs. $3.52 18,475.97 $3.65 12,174.55 $3.45 12,019.97 $3.47 10,743.05 $3.55 9,455.42 $3.25 8,163.96 RATES OF RETURN GOODMAN 2020 38.33% (=(EG24+EH24-EG25)/EG25) 2019 -8.49% 2018 106.05% 2017 40.78% 2016 12.49% LANDRY 11.75% (=(EJ24+EK24-EJ25)/EJ25) 11.64% -10.73% -4.76% 17.12% MARKET 51.76% (=(EM24-EM25)/EM25) 1.29% 11.89% 13.62% 15.82% AVERAGE 37.83% (=AVERAGE(EG33:EG37)] 5.00% (=AVERAGE(EJ33:EJ37)] 18.87% (=AVERAGE(EM33:EM37)] Construct a scatter diagram graph that shows Goodman's and Landryreturns on the vertical axis and the Market Index's returns on the horizontal axis
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started