Question
Use the data to compute daily returns for Microsoft, the S&P index, and gold. Compute returns from the previous trading day's price to the
Use the data to compute daily returns for Microsoft, the S&P index, and gold. Compute returns from the previous trading day's price to the current day's (You will lose one observation). The risk-free rate (^TNX) is already in daily percentage terms. Use the given risk-free rate (^TNX) to compute excess returns for MSFT and ^GC and the market risk premium for ^SPX. Use the "=slope" and "-intercept" formulas in excel to compute the beta and alpha of MSFT and ^GC. Interpret alpha and beta for each asset. Do these beta make sense to you? Why or why not?
Step by Step Solution
3.52 Rating (165 Votes )
There are 3 Steps involved in it
Step: 1
To compute the daily returns for Microsoft MSFT the SP index SPX and gold GC you will need historical price data for each asset Lets assume you have t...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 StartedRecommended Textbook for
Business Statistics In Practice
Authors: Bruce Bowerman, Richard O'Connell
6th Edition
0073401838, 978-0073401836
Students also viewed these Finance questions
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
View Answer in SolutionInn App