Use the data to compute daily returns for Microsoft, the S&P index, and gold. Compute returns...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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? 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?
Expert Answer:
Answer rating: 100% (QA)
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 the full answer
Related Book For
Business Statistics In Practice
ISBN: 9780073401836
6th Edition
Authors: Bruce Bowerman, Richard O'Connell
Posted Date:
Students also viewed these 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...
-
Two different compounds have the formulation CoBr(SO4) 5NH3. Compound A is dark violet, and compound B is red-violet. When compound A is treated with AgNO3 (aq), no reaction occurs, whereas compound...
-
Danny's Hamburgers, Inc., issued 9%, 10-year bonds payable at 85 on December 31, 2010. At December 31, 2012, Danny reported the bonds payable as follows: Danny uses the straight-line amortization...
-
Let B n = {a k | k is a multiple of n}. Show that for each n 1, the language B n is regular.
-
Explain why organizations using the just-in-time inventory concept must have zero defects in their inventory.
-
Design a relational database for a video rental store. The store, which rents only DVDs and has no sales other than DVD rentals, has approximately 5,000 customers and approximately 1200 DVD titles....
-
What familiarity and prior knowledge do you have about the term Electromagnetic radiation? What does the term Electromagnetic radiation mean in everyday language to everyday people? Use examples to...
-
On June 1, Year 1, Tsanumis Corporation (a U.S.-based manufacturing firm) received an order to sell goods to a foreign customer at a price of 1 million euros. The goods will be shipped and payment...
-
Question 25 of 40 Jai asks four experts to independently estimate how long a task will take. She then shares the estimates with the group and asks everyone to re-estimate. What estimating technique...
-
Invest cash in different installments over seven years. Renovation costs in current dollars$14,500,000 Renovation cost inflation rate3.5% Year Cash Flows 0 $15,000,000 1 $ 5,000,000 2 $ 5,000,000 3 $...
-
Ch. 21 - Final Exam > Pg. 4- Course Final Exam 8.8 GET $25 X F Richard and Katherine are man and wife. They own a house in tenancy by the entirety in the Florida Keys and live there all year. One day...
-
You are the accountant for a newly formed company called Creative Architects Corporation. The following business transactions occurred during the month of May 2018: 1. Received $80,000 from...
-
Calculate It is generally agreed that sales revenue should only be 'realized' and so 'recognized' in the trading, profit and loss account when: a) The sale transaction is for a specific quantity of...
-
Brendan Jones, CFP, is a financial planning and investment manager in the Washington, D.C. area.Jones has two new clients, Jeffrey and Mary Lewinsky, a married couple who live relatively close to the...
-
Toolbox with a wrench he could borrow. He found one and started to walk towards the door with the wrench. Melissa was sleeping upstairs when she heard noises coming from downstairs. Melissa suffered...
-
For the following exercises, write the polynomial function that models the given situation. Consider the same rectangle of the preceding problem. Squares of 2x by 2x units are cut out of each corner....
-
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 ?
-
According to Figure 1.2, intraEuropean Union trade accounts for a huge proportion of EU trade. What factor or factors might account for this fact? Asiab exports: $19.9 billion to U.S. & Canada ($4.9)...
-
According to Figure 1.2, the EU is a major customer of exports from Africa and the Middle East. What types of products do you think these areas produce for export, and why do you think the EU is...
-
For case 2 in Exercise 1, which country would prefer an international terms of trade of 1.2 rather than an international price of 1.66? Explain. Data from in exercise 1 For each of the following...
Study smarter with the SolutionInn App