Portfolio return and standard deviation Jamie Wong is thinking of building an investment portfolio containing two...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Portfolio return and standard deviation Jamie Wong is thinking of building an investment portfolio containing two exchange traded funds (ETFs). Jamie plans to invest $3,000 in Vanguard S&P 500 ETF (VOO) and $7,000 in Invesco QQQ Trust (QQQ). Jamie has decided to analyze some historical returns to get a sense for her portfolio's possible future risk and return. Six years of historical annual returns for each ETF are shown in the following table: a. Calculate the portfolio return, r,, for each of the 6 years assuming that 30% is invested in VOO and 70% is invested in QQQ. b. Calculate the average annual return for each ETF and the portfolio over the six-year period. c. Calculate the standard deviation of annual returns for each ETF and the portfolio. How does the portfolio standard deviation compare to the standard deviations of the individual ETFs? d. Calculate the correlation coefficient for the two ETFs. How would you characterize the correlation of returns of the two ETFs? e. Discuss any likely benefits of diversification achieved by Jamie through creation of the portfolio. a. The portfolio return for year 2014 is %. (Round to two decimal places.) Data table (Click on the icon here in order to copy the contents of the data table below into a spreadsheet.) Historical return Year Voo 2014 12.65% QQQ 18.13% 2015 2.89% 9.19% 2016 12.82% 6.43% 2017 21.15% 32.34% 2018 - 4.79% -0.99% 2019 31.62% 38.56% Print Done Portfolio return and standard deviation Jamie Wong is thinking of building an investment portfolio containing two exchange traded funds (ETFs). Jamie plans to invest $3,000 in Vanguard S&P 500 ETF (VOO) and $7,000 in Invesco QQQ Trust (QQQ). Jamie has decided to analyze some historical returns to get a sense for her portfolio's possible future risk and return. Six years of historical annual returns for each ETF are shown in the following table: a. Calculate the portfolio return, r,, for each of the 6 years assuming that 30% is invested in VOO and 70% is invested in QQQ. b. Calculate the average annual return for each ETF and the portfolio over the six-year period. c. Calculate the standard deviation of annual returns for each ETF and the portfolio. How does the portfolio standard deviation compare to the standard deviations of the individual ETFs? d. Calculate the correlation coefficient for the two ETFs. How would you characterize the correlation of returns of the two ETFs? e. Discuss any likely benefits of diversification achieved by Jamie through creation of the portfolio. a. The portfolio return for year 2014 is %. (Round to two decimal places.) Data table (Click on the icon here in order to copy the contents of the data table below into a spreadsheet.) Historical return Year Voo 2014 12.65% QQQ 18.13% 2015 2.89% 9.19% 2016 12.82% 6.43% 2017 21.15% 32.34% 2018 - 4.79% -0.99% 2019 31.62% 38.56% Print Done
Expert Answer:
Posted Date:
Students also viewed these finance questions
-
According to Kurt Lewin, why is it so difficult to motivate employees to alter their patterns of behavior?
-
There are four resonance structures for anthracene, one of which is shown. Draw the otherthree. Anthracene
-
What is the relationship between the short-run Phillips curve and the long-run Phillips curve? Suppose that the expected inflation rate increases from 2 percent to 3 percent. What will happen to the...
-
What is debt finance, and how does it differ from equity finance?
-
The following cumulative frequency polygon shows the hourly wages of a sample of certified welders in the Atlanta, Georgia, area. a. How many welders were studied? b. What is the class interval? c....
-
Following is an incomplete current-year income statement. Determine Net Sales, Cost of goods sold and Net Income. Additional information follows: . Return on total assets is 15% (average total assets...
-
The manager of a music store has kept records of the number of CDs bought in a single transaction by customers who make a purchase at the store. The accompanying table gives six possible outcomes and...
-
Lily graduated from UCSD in 2015. Right now she has an excellent job with a take-home income (after taxes) of $5,000 a month. The following is her financial situation: 1. She is single and shares an...
-
On January 1, 2025, Paxton Planning Services issued $56,000 of 2% bonds that mature in five years. They were issued at face value. The bonds pay annual interest payments on December 31 of each year...
-
Visual Cable TV Company, an accrual basis taxpayer, allows its customers to pay by the year in advance ($350 per year), or two years in advance ($680). In September 2023, the company collected the...
-
A nation is deciding whether to license mining rights to a foreign entity. If the mining rights are licensed, the nation will be giving up access to some of its most important natural resources. On...
-
1. Purchase investment in bonds for $96,000. 2. Sell land costing $21,000 for only $13,900, resulting in a $7,100 loss on sale of land. 3. Purchase $51,000 in equipment by issuing a $51,000 long-term...
-
Two letters are chosen from the word TREE without replacement. Find the probability of selecting two Es given that at least one E was selected.
-
Discuss the information available from the following techniques in the analysis of inorganic pigments used in antique oil paintings: (i) Powder X-ray diffraction, (ii) Infrared and Raman...
-
When a company wants to reduce the market price per share of its stock, what action should it take? a. Issue a cash dividend b. Issue a stock dividend c. Do a reverse stock split d. Do a forward...
-
What type of company is typically characterized by a high dividend payout ratio? a. Technology company b. High-growth company c. Mature, low-growth company d. All of the above
-
Preferred stock that may be converted into common stock has which of the following characteristics? a. Call feature b. Cumulative feature c. Participation feature d. Convertible feature
Study smarter with the SolutionInn App