Question

In: Finance

Passive Stock Market Investor (PSMI) holds one stock market index ETF in his/her portfolio, but has...

Passive Stock Market Investor (PSMI) holds one stock market index ETF in his/her portfolio, but has learned that investing in a bond market index ETF as well may reduce his/her portfolio risk due to diversification. The annual returns for both ETFs for the last ten years are listed below. Measured by the standard deviation of returns, by how much would PSMI’s portfolio’s historical risk been reduced if PSMI invested 70% in the stock market index ETF and 30% in the bond market index ETF rather than his current allocation of 100% in the stock market index ETF? Enter your answer rounded to two decimal places. Do not enter % in the answer box. For example, if your answer is 0.12345 or 12.345% then enter as 12.35 in the answer box.

Year Stock ETF Bond ETF

2009 39.00% 5.00%

2010 18.00% 6.00%

2011 1.00%    8.00%

2012 16.00% 4.00%

2013   34.00% -3.00%

2014 13.00% 5.00%

2015 0.00% 0.00%

2016 13.00% 2.00%

2017 21.00% 4.00%

2018 -5.00%   0.00%

Solutions

Expert Solution

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE

JUST WRITTEN IN EXCEL, NO EXCEL FORMULA IS USED

jeff jeffy answered 1 year ago
Next > < Previous

Related Solutions

Passive Stock Market Investor (PSMI) holds one stock market index ETF in his/her portfolio, but has...
Passive Stock Market Investor (PSMI) holds one stock market index ETF in his/her portfolio, but has learned that investing in a bond market index ETF as well may reduce his/her portfolio risk due to diversification. The annual returns for both ETFs for the last ten years are listed below. Measured by the standard deviation of returns, by how much would PSMI’s portfolio’s historical risk been reduced if PSMI invested 60% in the stock market index ETF and 40% in the...
8. A German investor holds a portfolio of British stocks. The market value of the portfolio...
8. A German investor holds a portfolio of British stocks. The market value of the portfolio is £20 million, with a ? of 1.5 relative to the FTSE index. In November, the spot value of the FTSE index is 4,000. The dividend yield, euro interest rates, and pound interest rates are all equal to 4% (flat yield curves). a. The German investor fears a drop in the British stock market (but not in the British pound). The size of FTSE...
An investor holds one share of Tesla stock. The investor purchased the stock at $125. The...
An investor holds one share of Tesla stock. The investor purchased the stock at $125. The current price is now $136. If the investor also purchased an option at the time he bought the share, at a premium of $1, with a strike price of $125, what would the investor prefer to be holding right now? (Please Explain Answer). call option put option either call or put, they have the same profit $0
What is the difference between active and passive investing? Is an investor in a non-ETF mutual...
What is the difference between active and passive investing? Is an investor in a non-ETF mutual fund an active or a passive investor?
The standard deviation of the market index portfolio is 10%. Stock A has a beta of...
The standard deviation of the market index portfolio is 10%. Stock A has a beta of 2 and a residual standard deviation of 20%. A) calculate the total variance for an increase of .10 in its beta. B) calculate the total variance for an increase of 1% in its residual standard deviation.
What is the difference between a Market Index ETF and a Market Index Mutual Fund?
What is the difference between a Market Index ETF and a Market Index Mutual Fund?
Suppose Emma holds a well-diversified stock portfolio. Her son, Andrew, who is a portfolio manager, has...
Suppose Emma holds a well-diversified stock portfolio. Her son, Andrew, who is a portfolio manager, has just advised her not to invest in stocks of oil refining industry because their prices tend to have much higher volatility relative to other stocks. Is Andrew’s advice sound? Explain.
Suppose Emma holds a well-diversified stock portfolio. Her son, Andrew, who is a portfolio manager, has...
Suppose Emma holds a well-diversified stock portfolio. Her son, Andrew, who is a portfolio manager, has just advised her not to invest in stocks of oil refining industry because their prices tend to have much higher volatility relative to other stocks. Is Andrew’s advice sound? Explain. Karen currently has $5 million invested in a long-term bond fund which has an expected return of 7% and a standard deviation of 18%. Her son, Michael, recommends her to consider changing to invest...
Suppose Emma holds a well-diversified stock portfolio. Her son, Andrew, who is a portfolio manager, has...
Suppose Emma holds a well-diversified stock portfolio. Her son, Andrew, who is a portfolio manager, has just advised her not to invest in stocks of oil refining industry because their prices tend to have much higher volatility relative to other stocks. Is Andrew’s advice sound? Explain. Karen currently has $5 million invested in a long-term bond fund which has an expected return of 7% and a standard deviation of 18%. Her son, Michael, recommends her to consider changing to invest...
Suppose Emma holds a well-diversified stock portfolio. Her son, Andrew, who is a portfolio manager, has...
Suppose Emma holds a well-diversified stock portfolio. Her son, Andrew, who is a portfolio manager, has just advised her not to invest in stocks of oil refining industry because their prices tend to have much higher volatility relative to other stocks. Is Andrew’s advice sound? Explain.
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT