Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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 

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... 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

Business Statistics In Practice

Authors: Bruce Bowerman, Richard O'Connell

6th Edition

0073401838, 978-0073401836

More Books

Students also viewed these Finance questions