Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Portfolio return and standard deviation Jamie Wong is thinking of building an investment portfolio containing two exchange traded funds (ETFS). Jamie plans to invest $7,500

image text in transcribed

Portfolio return and standard deviation Jamie Wong is thinking of building an investment portfolio containing two exchange traded funds (ETFS). Jamie plans to invest $7,500 in Vanguard S&P 500 ETF (VOO) and $2,500 in Invesco QOQ Trust (Q00). 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 retum, fp, for each of the 6 years assuming that 75% is invested in VOO and 25% is invested in QQ0. 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 Data table a. The portfolio return for year 2014 is % (Round to two decimal places.) (Click on the icon here in order to copy the contents of the data table below a spreadsheet.) Year 2014 2015 2016 2017 2018 2019 Historical return voo QQQ 13.94% 19.55% 1.03% 9.38% 11.81% 7.99% 22.27% 32.73% - 3.21% -1.75% 31.94% 39.07%

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Modeling Using Excel And VBA

Authors: Chandan Sengupta

1st Edition

0471267686, 978-0471267683

More Books

Students also viewed these Finance questions

Question

What are the major ways in which audit quality can be assured?

Answered: 1 week ago

Question

Explain the factors influencing wage and salary administration.

Answered: 1 week ago

Question

Examine various types of executive compensation plans.

Answered: 1 week ago

Question

1. What is the meaning and definition of banks ?

Answered: 1 week ago

Question

Dont off er e-mail communication if you arent going to respond.

Answered: 1 week ago