Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Download data from Yahoo Finance, https://finance.yahoo.com/quote/MSFT/?p=MSFT, to estimate Microsoft's beta based on monthly data between 12/30/2015 and 1/5/2021. You should have 61 months of data

image text in transcribed

Download data from Yahoo Finance, https://finance.yahoo.com/quote/MSFT/?p=MSFT, to estimate Microsoft's beta based on monthly data between 12/30/2015 and 1/5/2021. You should have 61 months of data to compute 60 monthly returns. Do the same to get S\&P 500 index data: o.com/quote/\%5EGSPC?p=\%5EGSPC. Note that you may have to copy/paste the data as we did in my video demo. What's the regression beta. 0.8250.8600.9331.000 QUESTION 11 Download data from Yahoo Finance, https://finance.yahoo.com/quote/MSFT/?p=MSFT, to estimate Microsoft's beta based on monthly data between 12/30/2015 and 1/5/2021. You should have 61 months of data to compute 60 monthly returns. Do the same to get S\&P 500 index data: https://finance.yaho o.com/quote/\%5EGSPC?p=\%5EGSPC. Note that you may have to copy/paste the data as we did in my video demo. How much is the firm's adjusted beta? Lower than the raw beta The same as the raw beta Higher than the raw beta More information is needed QUESTION 12 Download data from Yahoo Finance, https://finance.yahoo.com/quote/MSFT/?p=MSFT, to estimate Microsoft's beta based on monthly data between 12/30/2015 and 1/5/2021. You should have 61 months of data to compute 60 monthly returns. Do the same to get S\&P 500 index data: https://finance.yaho o.com/quote/\%5EGSPC? p=%5EGSPC. Note that you may have to copy/paste the data as we did in my video demo. If the risk-free rate is 1.50%, how much is the firm's alpha? Between 0% and 10% Between 10\% and 20\% Between 20\% and 25\% Between 25% and 30%

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

The Company Valuation Playbook Invest With Confidence

Authors: Charles Sunnucks

1st Edition

1838470816, 978-1838470814

More Books

Students also viewed these Finance questions

Question

What did Rogers mean by unconditional positive regard?

Answered: 1 week ago