Given the data in the file Stock Beta.xlsx, estimate the beta (and alpha) for Microsoft (MSFT). Do
Question:
Given the data in the file Stock Beta.xlsx, estimate the beta (and alpha) for Microsoft (MSFT). Do this for each criterion and each period of time to obtain a table analogous to that in the top right of Figure 7.49. What do you conclude about Microsoft?
Figure 7.49:
Transcribed Image Text:
The Beta Estimation Model (for McDonald's) K н 1 Model for estimating company betas Possible objectives 3-year Betas for various objectives for McDonald's 2 3 Parameters All data 3-year All data 4 Alpha 5 Beta 0.5023 0.0062 SE 0.0350 0.2010 SSE 0.3112 WSSE SAE MaxAE 0.3112 0.0318 0.1426 WSSE 0.3197 0.4737 0.4713 0.5203 0.7626 0.8906 3.9385 SAE 7 Weighting constant МахАЕ 0.3475 0.995 0.0640 0.1091 8. SqError 0.00029 Weight Mkt return AbsError Range names used: Alpha Beta Date Stock return -0.0088 Predicted Error =Model!$B$4 |=Model!$B$5 =Model!$E$7 |=Model!$F$7 =Model!$E$6 =Model!$F$6 |=Model!$E$4 =Modell$F$4 |=Model!$E$5 0.0083 0.0149 0.0200 0.0154 -0.0036 10 Dec-2013 11 Nov-2013 12 Oct-2013 13 Sep-2013 14 Aug-2013 15 Jul-2013 16 Jun-2013 17 May-2013 18 Apr-2013 0.0069 -0.0171 0.0171 0.9950 0.0024 0.0280 0.0172 0.00001 0.0024 |МaхАЕ_3 |МaхАЕ_All -0.0169 0.0042 -0.0266 -0.0309 0.0446 0.0031 0.00029 0.0169 0.9900 0.0042 0.0297 0.0197 0.00002 0.9851 0.00071 -0.0313 SAE_3 SAE_All -0.0302 0.0266 0.9801 0.0215 0.9752 -0.0093 0.00095 0.0309 0.0495 0.0015 0.0126 0.0118 0.0174 0.0009 0.0011 0.0100 SSE 3 |SSE_All WSSE 3 0.00056 -0.0150 0.0252 0.0237 0.0237 0.9704 -0.0597 0.0128 0.0222 -0.0480 0.9655 0.0208 -0.0470 0.00356 0.0597 0.0181 0.0246 0.00016 0.0128 0.9607 19 Mar-2013 126 Apr-2004 127 Mar-2004 128 Feb-2004 129 Jan-2004 0.0222 0.9559 0.5591 0.5563 0.0395 0.0360 0.00049 0.0023 -0.0168 -0.0471 0.0480 0.0087 0.0087 0.0895 -0.0164 0.0098 0.0001 0.0895 0.0122 0.0995 0.0080 0.5535 0.5507 -0.0379 0.0011 -0.0390 0.0015 0.0390 -0.0163
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 71% (7 reviews)
Data Monthly closing prices from Jan 2004 to Dec 2013 Month SP 500 AA AAPL AXP BA CAT CSCO CVX DD DIS FDX GE GT HPQ IBM IP JNJ JPM KO MCD MMM MO MRK MSFT PG T UTX WMT Dec2013 181832 994 54902 8757 136...View the full answer
Answered By
Susan Juma
I'm available and reachable 24/7. I have high experience in helping students with their assignments, proposals, and dissertations. Most importantly, I'm a professional accountant and I can handle all kinds of accounting and finance problems.
4.40+
15+ Reviews
45+ Question Solved
Related Book For
Practical Management Science
ISBN: 978-1305250901
5th edition
Authors: Wayne L. Winston, Christian Albright
Question Posted:
Students also viewed these Business questions
-
Solve the previous problem, but analyze GE instead of Microsoft. Data from Previous Problem: Given the data in the file Stock Beta.xlsx, estimate the beta (and alpha) for Microsoft (MSFT). Do this...
-
The demand for chicken in the United States, 19601982. To study the per capita consumption of chicken in the United States, you are given the data in the following table, where Y = per capita...
-
Beta is a common measure of stock-market risk or volatility. It is typically estimated as the slope coefficient for a simple regression model in which stock returns over time are the dependent Y...
-
Find the lengths of the curves. The cardioid r = 1 + cos
-
Two starships, the Enterprise and the Constitution, are approaching each other head-on from a great distance. The separation between them is decreasing at a rate of 782.5 km/s. The Enterprise sends a...
-
An inventor has developed a refrigeration unit that maintains the cold space at 14 F, while operating in a 77 F room. A coefficient of performance of 8.5 is claimed. How do you evaluate this?
-
The charter of Maple Leaf Capital Corporation authorizes the issuance of 1,000 shares of preferred stock and 10,000 shares of common stock. During a two-month period, Maple Leaf completed these...
-
Jay-Zee Company makes an in-car navigation system. Next year, Jay-Zee plans to sell 16,000 units at a price of $320 each. Product costs include: Direct materials ....... $68 Direct labor .............
-
1.Considering the same scenario as a new City Manager, how would you implement the "Telescope and Microscope "concept in addressing systematic turnover in the organization?
-
A small businesswoman faces a 10% chance of having a fire that will reduce her net worth to $1.00, a 10% chance that fire will reduce it to $50,000, and an 80% chance that nothing detrimental will...
-
Suppose Ford currently sells 250,000 Ford Mustangs annually. The unit cost of a Mustang, including the delivery cost to a dealer, is $16,000. The current Mustang price is $20,000, and the current...
-
In many cases, the portfolio return is at least approximately normally distributed. Then Excels NORMDIST function can be used to calculate the probability that the portfolio return is negative. The...
-
What are the typical characteristics of hoshin kanri?
-
discuss the ethical considerations inherent in automated decision-making systems, particularly concerning transparency, accountability, and fairness ?
-
Discuss two ways ( each ) that the mobile phone industry and healthcare industry might be transformed through digital disruption.
-
Discuss and explain what conflict resolution or handling methods will utilize to resolve dysfunctional conflicts within your project team.
-
Discuss how a foundation in physical activity enhances the understanding and management of sports organizations.
-
Choose one of the scenarios posted below and apply the Step-Wise approach. In this assignment, you are essentially demonstrating your understanding of applied ethics and determining an ethical...
-
Let a. Analyze b. Does the graph of f have any vertical asymptotes? Explain. c. Graph f and then sketch the graph with paper and pencil, correcting any errors obtained with the graphing utility. x2 ...
-
Consider the sections of two circuits illustrated above. Select True or False for all statements.After connecting a and b to a battery, the voltage across R1 always equals the voltage across R2.Rcd...
-
Brian Brown, an executive at a manufacturing enterprise, comes to you on December 1 of the current year for tax advice. He has agreed to donate a small tract of land to the Rosepark Community...
-
For several years, you have prepared the tax return for Alpha Corporation, a closely held corporation engaged in manufacturing garden tools. On February 20 of the current year, Bill Johnson, the...
-
Mark Hancock is a self-employed attorney who operates his law practice as an unincorporated sole proprietorship. In 2016, the IRS disallowed several business deductions he took in 2014 and 2015. In...
-
Students must useinformation literacy in their writing. Theprojectshould be at least #2000 words of content. Word document only! The students will be required to meet with a top level manager,...
-
Your agency has been directed by community leaders to develop and implement a community paramedic program targeting injury prevention among the elderly. You are now tasked with providing a briefing...
-
Write up an assessment record for one of the children/young people in a learning environment. The record must be set out clearly showing: - a) Your assessment of the learner's development b) How the...
Study smarter with the SolutionInn App