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: 76% (17 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...
-
George Gingero is a one-third partner in Sweet Tooth, a restaurant that specializes in desserts. Gingero maintains a full-time job and earns a salary of $140,000. In the evenings and on weekends, he...
-
Jackson and Richard formed a partnership on 1 July 2025, agreeing to share profits and losses in the ratio of 2:1. Jackson contributed \($30\) 000 in cash and land with a fair value of \($180\) 000....
-
The Coca-Cola Company and PepsiCo, Inc. Instructions Go to the books companion website and use information found there to answer the following questions related to The Coca-Cola Company and PepsiCo,...
-
1. Find the focal length of a convex mirror of radius of curvature 1m. 2. Focal length of a convex mirror is 50 cm. What is its radius of curvature? 3. Radius of curvature of a concave mirror is 25...
-
A simple well-known game, tic-tac-toe, is played on a three-by-three grid of squares by two players. The players alternate turns. Each player chooses a square and places a mark in a square. (One...
-
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...
-
What was peculiar about the division of the Federal Reserve Bank into different districts?
-
The adjusting entry for prepaid expenses should a. debit the expenses account and credit the asset account. b. debit the expenses account and credit the liability account. c. debit the asset account...
-
Find the mean, the median, and the mode of the following salaries of employees of the Moe D. Lawn Landscaping Company: Salary $25,000 28,000 30,000 45,000 Frequency 4 3 2 1
-
Shoe size for a team of football players ranges from size 10 to 14 . The majority of players wear size 12 , and the number of players wearing size 11 is the same as the number wearing size 13. It is...
-
Match the equation and correlation in Problems 19-24 with a graph. \(y=-0.4 x+2 ; r=-0.4\) 777 E. 87654321 YD 1 2 3 4 5 6 7 8 9 10 22 .. 10 1 2 3 4 5 6 7 8 9 10 8 9 10 B. 4321 8755595 ALL 21 77777 1...
-
What are the main advantages of disclosing value-added in financial statements from an Islamic viewpoint?
-
For the op amp in Fig. 12.2, use the device data and operating point from the first example in Section 12.4.1. Assume all transistors operate in the active region. (a) Find the element values in the...
-
a. What is the cost of borrowing if Amarjit borrows $28 500 and repays it over a four-year period? b. How many shares of each stock would he get if he used the $28 500 and invested equally in all...
-
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 line of the following author reading segment would causes issues? 1: bookArr[i].authors = calloc(bookArr[i].numAuthors, sizeof(author_t)); 2: for (j=0; j < bookArr[i].numAuthors; j++) { 3: 4:...
-
3. (20 points) Consider three periodic tasks A, B and C with their respective periods as 4ms, 6ms and 8ms. The execution time required for each task is 1 ms. (a) Draw a figure/table to execute these...
-
Write a method (pseudocode) to reverse the queue using another empty queue. You may only use queue operations such as enqueue(), dequeue(), and size(). No other data structure can be used other than...
Study smarter with the SolutionInn App