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

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

1 Expert Approved Answer

Step: 1 Unlock

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... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...

The customer service manager of a discount store monitors customer complaints. Each day a random sample of 100 customer transactions is selected. These transactions are monitored, and the number of...

Wallace and Brace CPA assign a partner to screen and recommend (or decline) potential clients prior to acceptance. Discuss at least 4 specific issues which should have been considered prior to...

Computing Beta in Excel containing daily prices/returns for Microsoft stock (MFST), the S&P 500 Index (^SPX), gold (^GC), and the risk-free rate, represented by the U.S. government 10-year bond...

I need your help with this: Can you please quote from the attached chapters / resource if possible? Corporations often use different costs of capital for different operating divisions. Using an...

Hello. I need to write a three page review for the two articles attached. Each review should include a brief summary that include the major points of the article, as well as a summary of my own...

SEE "DOCUMENT 1" FOR CRITERIA 2 "DOCUMENT 2" FOR CRITERIA 4 You are to write a 3 to 4 page paper following APA rules for the title page, citations and appropriate references within the body of the...

SEE "DOCUMENT 1" FOR CRITERIA 2 "DOCUMENT 2" FOR CRITERIA 4. You are to write a 2 to 4 page paper following APA rules for the title page, citations and appropriate references within the body of the...

In this assignment you are asked to write a Python program to define a class to model some characteristics of a university Department. Specifically, the class will track students requesting to major...

Matrix Inc performs following job and it wants you to compute Actual Costing and Nominal Costing Based on following info:

Question 18 2 Points As a result of continuously measuring and evaluating their performance, Dana Pastries identified five areas that require improvement. Accordingly, they launched a new initiative...

Debate the following statement: 'Big Data' and the buzz of the so-called 'green marketing' and 'sustainable marketing' are being used nowadays by marketing professionals to increase the grip and the...

Required neat and clear handwritten solution with all steps. Knowing that a = 0.14 m, b = 0.54 m, c= 0.35 m and F = 3.6 kN, determine the magnitude of the force at point B. A B F KN C D bm am bm EO cm

Write a MATLAB script to visualize a 3 D plot of a parametric surface representing a spherical spiral. The parametric equations for a spherical spiral are given by: x ( ? , \ theta ) = Rsin ( ? ) cos...

You are an employee of University Consultants, Limited, and have been given the following assignment. You are to present an investment analysis of a small retail income-producing property for sale to...

Create an appropriate display of the navel data collected in Exercise 25 of Section 3.1. Discuss any special properties of this distribution. Exercise 25 The navel ratio is defined to be a persons...

For each of the following, write out and graph the probability distribution of*. That is, list all the possible values of x and also list the corresponding probabilities. Then graph the distribution....

The manager of a chain of discount department stores wishes to estimate the total number of erroneous discounts allowed by sales clerks during the last month. A random sample of 200 of the chain's...

In the quadratic regression model, what are y, (0 + 1x + 2x2), and ?

Imagine you wish to estimate the betas for 2 investments, A and B. You have gathered the following return data for the market and for each of the investments over the past 10 years, 20052014. a. On a...

Assume the betas for securities A, B, and C are as shown here. Security Beta A .............................1.4 B .............................0.8 C .......................... -0.9 a....

Stock A has a beta of 0.8, stock B has a beta of 1.4, and stock C has a beta of -0.3. a. Rank these stocks from the most risky to the least risky. b. If the return on the market portfolio increases...