Question
B. Using data from Yahoo), estimate the Beta for Microsoft using Excel or another spreadsheet program. 1. Download 37 monthly closing prices for MSFT and
B. Using data from Yahoo), estimate the Beta for Microsoft using Excel or another spreadsheet program.
1. Download 37 monthly closing prices for MSFT and the S&P 500 Stock Index (SPY).
2. Calculate monthly returns for Microsoft and the market (S&P 500)
3. Regress company returns against market returns. The slope coefficient is beta. Copy down the R2.
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
Principles Of Finance With Excel
Authors: Simon Benninga
2nd Edition
0199755477, 9780199755479
