In the following table, you will find annual return data for six high-tech companies between the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
In the following table, you will find annual return data for six high-tech companies between the years 1997 and 2007. Use the information below to compute the variance - covariance matrix of the returns. A B C DE F G H 1 Data for 6 High-Tech Companies 2 MSFT 3 1997 4 1998 36.67% 122.82% 5 1999 INTC 0.20% 61.43% 195.09% 14.44% 63.51% -38.38% CSCO 41.54% DELL 21.92% IBM GOOG 26.13% 22.50% 62.27% 73.38% 117.89% -1.27% 45.15% 7.80% 6 2000 21.39% 28.42% 1.30% 81.17% 24.27% 38.14% 7 2001 45.36% -7.44% 21.89% 19.83% 10.73% 54.48% 8 2002 20.19% 48.27% 9.11% -10.21% -11.92% 26.82% 9 2003 -8.94% -11.28% 12.65% 13.77% 7.06% -6.24% 10 2004 27.02% 12.85% 12.08% 32.55% -7.55% 123.03% 11 2005 -11.64% 2.42% -17.13% -6.48% 1.31% 15.48% 12 2006 20.29% 6.90% 3.62% 50.12% -5.54% 19.92% 13 2007 34.08% 22.21% 33.46% 84.40% 5.71% 62.76% 14 15 Beta 0.80 16 Mean returns 29.24% 0.95 20.68% 0.65 0.85 0.85 1.40 25.02% 31.64% 15.34% 43.87% <=AVERAGE(G3:G13) In the following table, you will find annual return data for six high-tech companies between the years 1997 and 2007. Use the information below to compute the variance - covariance matrix of the returns. A B C DE F G H 1 Data for 6 High-Tech Companies 2 MSFT 3 1997 4 1998 36.67% 122.82% 5 1999 INTC 0.20% 61.43% 195.09% 14.44% 63.51% -38.38% CSCO 41.54% DELL 21.92% IBM GOOG 26.13% 22.50% 62.27% 73.38% 117.89% -1.27% 45.15% 7.80% 6 2000 21.39% 28.42% 1.30% 81.17% 24.27% 38.14% 7 2001 45.36% -7.44% 21.89% 19.83% 10.73% 54.48% 8 2002 20.19% 48.27% 9.11% -10.21% -11.92% 26.82% 9 2003 -8.94% -11.28% 12.65% 13.77% 7.06% -6.24% 10 2004 27.02% 12.85% 12.08% 32.55% -7.55% 123.03% 11 2005 -11.64% 2.42% -17.13% -6.48% 1.31% 15.48% 12 2006 20.29% 6.90% 3.62% 50.12% -5.54% 19.92% 13 2007 34.08% 22.21% 33.46% 84.40% 5.71% 62.76% 14 15 Beta 0.80 16 Mean returns 29.24% 0.95 20.68% 0.65 0.85 0.85 1.40 25.02% 31.64% 15.34% 43.87% <=AVERAGE(G3:G13)
Expert Answer:
Answer rating: 100% (QA)
Anwers To calculate the variancecovariance matrix of the returns we first need to calculate the returns for each company over the 11year period The returns are calculated as the difference between the ... View the full answer
Related Book For
Posted Date:
Students also viewed these finance questions
-
(20 points)Write a program that prompts the user to input five decimal numbers. The program should then add the five decimal numbers, convert the sum to the nearest integer, and print the result....
-
Determine the transfer function from U(s) to Y(s) for the following block diagram. Provided are some recommended steps to take: a. Label each signal (line with arrow) b. Write the equation for each...
-
A researcher wanted to find out if there was difference between older movie goers and younger movie goers with respect to their estimates of a successful actors income. The researcher first...
-
[10 marks] Click the link below to see the code for a program. Your task is as in assignment 3: re-write the code of this program so that, to a user of the program, it works as before, but in your...
-
You desire to do a study of likely voters in Michigan to determine whether they would support the reinstatement of the death penalty for those convicted of murdering public safety officers. a)...
-
Susan can pick 4 pounds of coffee in an hour or gather 2 pounds of nuts. Tom can pick 2 pounds of coffee in an hour or gather 4 pounds of nuts. Each works 6 hours per day. a. What is the maximum...
-
For each of the following situations, calculate the \(z\)-statistic \((z)\). a. \(\mathrm{X}^{-}=14.00 ; \mu=11 ; \sigma=6 ; N=36\) b. \(\mathrm{X}^{-}=7.00 ; \mu=8 ; \sigma=3 ; N=9\) c....
-
Calculating Cash Flows Consider the following abbreviated financial statements for Parrot head Enterprises: a. What is owners?? equity for 2006 and 2007? b. What is the change in net working capital...
-
Your grandpa has $550,000 in his account and he needs to receive monthly payments of $55,000. If he receives the payments at the end of the month, and the current interest rate is 17 percent,...
-
You are required to answer the following questions: a) Explain why a firm might prefer a stock repurchase rather than an increase in the firm's regular dividend. b) Company B has 6,000 shares of...
-
Weisberg Corporation has 10,000 shares of \($100\) par value, 6%, preference shares and 50,000 ordinary shares of \($10\) par value outstanding at December 31, 2015. Instructions Answer the questions...
-
Loxley Corporation is authorized to issue 50,000 shares of \($10\) par value ordinary shares. During 2015, Loxley took part in the following selected transactions. 1. Issued 5,000 shares at \($45\)...
-
On January 2, 2015, Jones Company purchases a call option for \($300\) on Merchant ordinary shares. The call option gives Jones the option to buy 1,000 shares of Merchant at a strike price of \($50\)...
-
Derrick Company issues 4,000 restricted shares to its CFO, Dane Yaping, on January 1, 2015. The shares have a fair value of 120,000 on this date. The service period related to these restricted shares...
-
Alladin Company purchased Machine #201 on May 1, 2015. The following information relating to Machine #201 was gathered at the end of May. Price \($85\),000 Credit terms 2/10, n/30 Freight-in costs $...
-
Chemical energy is released or absorbed from reactions in various forms. The most easily measurable form of energy comes in the form of heat, or enthalpy. The enthalpy of a reaction can be calculated...
-
Could the owner of a business prepare a statement of financial position on 9 December or 23 June or today?
-
Find the sum 1. 2. 3. 4 3i 10 k-1
-
1. Two functions f and g can be combined by the arithmetic operations of ________, ________, ________, and _________ to create new functions. 2. The ________ of the function f with the function g is...
-
Use the Remainder Theorem and synthetic division to find each function value. Verify your answers using another method. f (x) = 2x3 7x + 3 (a) f (1) (b) f (2) (c) f (3) (d) f (2)
-
A company expects to receive which of the following benefits when it uses its budgeting process? a. The planning required to develop the budget helps managers foresee and avoid potential problems...
-
A direct materials budget would be used in which of the following types of companies? a. Service b. Merchandising c. Manufacturing d. All of the above
-
A disadvantage to merchants from accepting debit and credit cards would be a. lost sales. b. transaction fees. c. bounced checks. d. longer time to receive cash.
Study smarter with the SolutionInn App