Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Go to the Quiz 5 Spreadsheet. Go to the WMT 60 tab. It contains the results of the 60-month regression analysis to estimate the Beta

image text in transcribed
image text in transcribed
Go to the Quiz 5 Spreadsheet. Go to the WMT 60 tab. It contains the results of the 60-month regression analysis to estimate the Beta of Walmart. Assume the long-run equilibrium risk free rate is 3.80% and that the long run equilibrium market risk premium is 7.80%. Compute the estimated average cost of equity for Walmart using this information. Round to the nearest basis point(e.g. 24.6789% would be stated at 24.68 below). 1 SUMMARY OUTPUT Regression Statistics 4 Multiple R 0.339922871 5 R Square 0.115547558 6 Adjusted R Square 7 Standard Error 0.051382756 8 Observations 60 10 ANOVA df Sign Significance F 0.007877471 12 Regression 13 Residual 14 Total 1 58 59 0.020005484 0.153130883 0.173136367 MS 0.020005484 7.577296487 0.002640188 17 Intercept 18 X Variable 1 Coefficients 0.006991442 -1.078139532 Standard Error Star P-value 0.006784495 1.030502829 0.307052242 0.391667765 -2.752688956 0.007877471 Lower 95% Upper 95% -0.006589201 0.020572085 -1.86214774 -0.294131324

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Venture Capital Valuation

Authors: Lorenzo Carver

1st Edition

0470908289, 978-0470908280

More Books

Students also viewed these Finance questions

Question

4. Explain communication research as a social science.

Answered: 1 week ago