Solve the previous problem, but analyze GE instead of Microsoft. Data from Previous Problem: Given the data
Question:
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 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: 72% (18 reviews)
This data was downloaded from sites like httpfinanceyahoocomqhpa00b0c2004d11e30f2013gmsmcd Model for estimating GE beta Possible objectives Betas for various objectives for GE Parameters 3year All dat...View the full answer
Answered By
Utsab mitra
I have the expertise to deliver these subjects to college and higher-level students. The services would involve only solving assignments, homework help, and others.
I have experience in delivering these subjects for the last 6 years on a freelancing basis in different companies around the globe. I am CMA certified and CGMA UK. I have professional experience of 18 years in the industry involved in the manufacturing company and IT implementation experience of over 12 years.
I have delivered this help to students effortlessly, which is essential to give the students a good grade in their studies.
3.50+
2+ Reviews
10+ 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
-
The technique for calculating a bid price can be extended to many other types of problems. Answer the following questions using the same technique as setting a bid price; that is, set the project NPV...
-
Repeat the previous problem, but this time for perpetual options. What do you notice about the prices? What do you notice about the exercise barriers? In previous problem Let S = $100, K = $90, =...
-
Repeat the previous problem, but make the correlation between the two inputs equal to 0.7. Explain how the results change. Data from Previous Problem: When you use @RISKs correlation feature to...
-
Graph the sets of points whose polar coordinates satisfy the equations and inequalitie. 0 , r = 1
-
Baseball scouts often use a radar gun to measure the speed of a pitch. One particular model of radar gun emits a microwave signal at a frequency of 10.525 GHz. What will be the increase in frequency...
-
Find the Fourier transform of (without using Table III in Sec. 11.10). Show details. -|x| f(x) = e-lal (-0
-
Distinguish between job costing process costing and batch costing fully explaining each approach.
-
Linda Lechner has just been severely chastised for her inventory policy. Sue Surrowski, her boss, believes that the service level should be either 95% or 98%. Compute the safety stock levels for a...
-
For 0 02, solve the below equations for all values of 6. Using your filled out unit circle will help to solve these. sin(6) = 3 3 tan(0) = 1 tan (0) = 2 tan(0) = 3 3
-
California Health Center, a for-profit hospital, is evaluating the purchase of new diagnostic equipment. The equipment, which costs $600,000, has an expected life of five years and an estimated...
-
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...
-
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...
-
Why is mercury a suitable working fluid for the topping portion of a binary vapor cycle but not for the bottoming cycle?
-
Conlon Chemicals manufactures paint thinner. Information on the work in process follows: Beginning inventory, 40,900 partially complete gallons. Transferred out, 206,000 gallons. Ending inventory...
-
Discuss the Issues, concerns and problems regarding the downfall of the brand Forever 21.
-
Thompson Trailers (TT) manufactures utility trailers for small landscaping companies to haul their equipment to residential sites. Demand for the trailers is fairly even throughout the year, as snow...
-
Please give and define three principles when producing a new product. Please give an example of each.
-
Britelite Manufacturers produces a product which has the following standard costs: Material A: 3 kilograms at R20 per kilogram Material B: 5 kilograms at R15 per kilogram Direct labour: 8 hours at...
-
Calculate Paymore's cash payments to its suppliers under the assumption that the firm pays for its goods with a 1-month delay. Therefore, on average, two-thirds of purchases are paid for in the...
-
(8%) Problem 6: A student attaches a f= 3.5 kHz oscillator to one end of a metal rail of length L = 25 m. The student turns on the oscillator and uses a piezoelectric gauge at the other end to...
-
Howard Gartman is a 40% partner in the Horton & Gartman Partnership. During 2017, the partnership reported the total items below (100%) on its Form 1065: Ordinary income $180,000 Qualified dividends...
-
Dean makes a pledge of $30,000 to a local college. The college is willing to accept either cash or marketable securities in fulfillment of the pledge. Dean owns stock in Ajax Corporation worth...
-
On December 1, 2017, Rebecca Ward, a single taxpayer, comes to you for tax advice. At the end of every year, she donates $5,000 to charity. She has no other itemized deductions. This year, she plans...
-
Which of the following comments is true regarding Justin Paperny's comments during his presentation? A. Justin believes that the main reason he was sentenced to prison is because his actions were key...
-
Which of the following is an example of qualitative factors that can effect investment decisions? Select one: a. All of the choices b. Over time, how will the quality of goods produced impact the...
-
The head of the accounting department of your company has determined that there is idle cash and is considering options for investing it. You are assigned to explain the costs and benefits of various...
Study smarter with the SolutionInn App