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...
-
Susan Michaels is evaluating the Burton Tool Companys common stock and warrants to choose the better investment. The firms stock is currently selling for $16 per share; its warrants to purchase three...
-
If, in a two-way classification, the entire experiment is repeated \(r\) times, the model becomes \[Y_{i j k}=\mu+\alpha_{i}+\beta_{j}+\varepsilon_{i j k}\] Data From Theorem 12.2 for i = 1, 2,...,...
-
The Wedding Shop (TWS) started the 2013 accounting period with the balances given in the financial statements model shown below. During 2013 TWS experienced the following business events: 1....
-
The ledger of Rios Company contains the following balances: Retained Earnings $30,000, Dividends $2,000, Service Revenue $50,000. Salaries and Wages Expense $27,000, and Supplies Expense $7,000. The...
-
Which histograms are skewed to the left? Refer to histograms A through H in Figure 2.12. 2.0 -50 0.0 1.0 3 150 5 15 25 D -1 -3 8 14 -7 -4 -1 G Figure 2.12 Eight histograms LO 09 007 01 08 01 250 09...
-
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...
-
For any rhombus JKLM, decide whether the statement is always or sometimes true. Draw a diagram and explain your reasoning. JL = KM
-
The following information is available from the 2024 financial statements of Indigo Inc. and Sandhill Ltd.: Income tax expense Interest expense Net income Total assets Total current liabilities Total...
-
What is the Policing act in the State of Georgia? What is the second chance act in the State of Georgia? What is the police Reform in Georiga? References
-
If you wanted to know how much of its net income a corporation distributed as Which financial swement would you look at?
-
Discuss why persuasion is considered an essential role for a leader. How does persuasion relate to your conflict management style?
-
For stock and mutual fund investments only, research back to fair market value share price (or net asset value) one year ago, five years ago, and ten years ago. If you would have invested the same...
-
The Nicor family is planning to purchase a new home 3 years from now. If they have $240,000 now, how much will be available 3 years from now? The fund grows at a compound rate of 12% per year.
-
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...
-
You have $36,000 to Invest in Sophie Shoes, a stock selling for $60 a share. The initial margin requirement is 65 percent. calculate your rates of return if the stock rises to $90 a share and if it...
-
New Flyer Industries has decided to expand its production of hybrid transit buses. The firm expects incremental cash flows of? $40 million per year for the next 10 years. The upfront cost of the...
-
Calculate the mean, mode, median, standard deviation, and range for the Graduation Rate, Salary After Completing Program, and Annual Cost. our response to each of these should include only the mean,...
Study smarter with the SolutionInn App