You are required to download the monthly data from yahoo finance Website for S & P...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
You are required to download the monthly data from yahoo finance Website for S & P Index and IT sector company. Analyse the mean returns, standard deviation, variance for both S & P and IT sector company in excel. Also, calculate the return of Portfolio with IT Sector Company (25% share) and another competitor IT sector company (75% share). Discuss (by writing in words) is it beneficial to invest in IT sector companies in comparison to S & P and also interpret investing in given portfolio will have high prospects, if not why? (5+5+5 = 15 You are required to download the monthly data from yahoo finance Website for S & P Index and IT sector company. Analyse the mean returns, standard deviation, variance for both S & P and IT sector company in excel. Also, calculate the return of Portfolio with IT Sector Company (25% share) and another competitor IT sector company (75% share). Discuss (by writing in words) is it beneficial to invest in IT sector companies in comparison to S & P and also interpret investing in given portfolio will have high prospects, if not why? (5+5+5 = 15
Expert Answer:
Answer rating: 100% (QA)
Mean returns standard deviation and variance for both S P and IT sectors can be calculated using the ... View the full answer
Related Book For
Posted Date:
Students also viewed these finance questions
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
The authors Web page (www.rotman.utoronto.ca/~hull/data) contains daily closing prices for crude oil futures contract and gold futures contract. You are required to download the data and answer the...
-
Trang had a rental home that received a notice of noncompliance because of her failure to maintain repairs. She received the notice on September 1, 2022 and did not complete any of the repairs until...
-
University Food Systems, Inc., has issued a 40 percent stock dividend. The company has 752,000 shares authorized and 200,000 shares outstanding. The par value of the stock is $10 per share, and the...
-
Access the 2018 Annual Report for Facebook, Inc., and answer the following questions. a. Using information from the companys Income Statement and Income Taxes footnote, what was the companys...
-
The change in entropy of an ideal gas during a reversible isothermal expansion is (a) Zero (b) Positive (c) Negative (d) Infinite.
-
Winningham Company maintains a petty cash fund for small expenditures. The following transactions occurred over a 2-month period. July 1 Established petty cash fund by writing a check on Cubs Bank...
-
Consider a smooth function f(x), x E [a, b] and the following approximating polynomial: p(x) = f(c) + f'(c)(x-c), c=(a+b)/2 (a) 3 Prove an error bound for f(x)-p(x)\, Vxe [a, b], where (b-a) and f...
-
Create two tables based on the E-R model shown in Figure 4-41 and the business rules in the following list for a work order tracking database. Include all the constraints in the CREATE TABLE...
-
a) Explain why the Internet Service Provide (ISP) below advertises its customers as 128.112.128.0/21. Please show your work and use subnet calculations and range to support your answer. Advertise...
-
(i) If our dependent variable y* is measured with error such that the data we observe is y where y = y* + e and where e is the measurement error, what do we require in order to ensure that we do not...
-
= Consider an economy with a single physical commodity and uncertainty captured by two states of nature S {a,b}. This economy is endowed with markets for two assets with payoffs r = [1 2] and r = [2...
-
Please visit http://www.nwlink.com/~donclark/leader/survlead.html to access a Leadership Self-Assessment Activity....
-
Consider three assets with returns in three states of nature as follows: 2 3 0 -(1) 2 3 T1 = 2 4 2 3 72 = , 13 = where k 0 is a parameter. (i) Examine whether or not this asset structure is...
-
You has just borrowed $5,000 on a four year loan at 8% simple amortized interest . Complete the Amortization table below for the first 6 month of the loan. USING A LOAN AMORTIZATION TABLE . Payment...
-
Golden Valley Company produced 4.500 units for the month of September. The following data are available for the month. Standard (for 1 unit of Product) DL hrs. Variable OH per DLH Fixed OH per DLH...
-
Horse serum containing specific antibody to snake venom has been a successful approach to treating snakebite in humans. How do you think this anti-venom could be generated? What are some advantages...
-
What is the price of a European put option on a non-dividend-paying stock when the stock price is $69, the strike price is $70, the risk-free interest rate is 5% per annum, the volatility is 35% per...
-
A three-month American call option on a stock has a strike price of $20. The stock price is $20, the risk-free rate is 3% per annum, and the volatility is 25% per annum. A dividend of $2 is expected...
-
Explain why a regular European call option is the sum of a down-and-out European call and a down-and-in European call.
-
In a study to determine whether the frequency of a certain mutant gene increases with age, the number of mutant genes per microgram of DNA was counted for each of 29 men. The results are presented in...
-
The following table presents the U.S. imports and exports (in billions of dollars) for each of 29 months. a. Compute the least-squares regression line for predicting exports (y) from imports (x). b....
-
For the house data in Table 4.1, the average selling price is y = 447.0. Imagine that you do not know the size of any house, so you predict the selling price of each of them to be 447.0. This is...
Study smarter with the SolutionInn App