Question

In: Finance

Construct a portfolio from the following assets: - SPY (SPDR S&P 500 ETF Trust) - BND...

Construct a portfolio from the following assets:
- SPY (SPDR S&P 500 ETF Trust)
- BND (Vanguard Total Bond Market ETF)
- IYR (iShares US Real Estate ETF)
- SHV (iShares Short Treasury Bond ETF)
- DBC (Invesco DB Commodity Tracking)

With an investment period of 01/01/2014 to 01/01/2019, the goal is to achieve a target return of 4% with minimum volatility. Estimate expected returns and volatility from the 5-year time series. Assume a portfolio of $100 million, allocating no less than $10 million and no more than $50 million to each asset. You should compute the five weights for the five asset classes, as well as the expected return and volatility of the portfolio (annualized).

Expert Solution

Lets see brief about each and every stock before allocating and calculatig the return and volatality

SPY (SPDR S&P 500 ETF TRUST):

It is trust, which means it is a low risk stock and low return stock

BND (Vanguard total bond market ETF)

It is a bond, which means it is over risk than trust but usually it is low risk only and a fixed return stock

IYR (ishares US real estate ETF)

It is a share, and its is a real estate share, which means it is high risk stock and high return stock

SHV (ishares short teasury bond ETF)

it is a share and it is a short teasury bond share, which means it is a little less risk than IYR, but it is also usually risky and high return share

DBC (Invesco DB commodity trackig)

It is a commodity, which is also risky and high return but lower than shares.

Investment period:

01/01/2014 to 01/01/2019

Target return

4%

Portfolio amount

$100 million

Conditions:

1. Not less than $10 million in each and every stock

2. Not more than $50 million in each stock

So, the conclusion ,

As per condition number one invest $10 million in each and very stock

Invest balace $50 millions in SPY & BND for fixed return. Because it is low risky and we can easily achieve our target return of 4%

the above portfolio is low volatality

More information like return and risk of each and every stock required to evaluate exact return and volatality of stocks.

jeff jeffy answered 1 year ago

You currently own SPY, which is an ETF replicating the S&P 500 index. You consider adding...

You currently own SPY, which is an ETF replicating the S&P 500 index. You consider adding another ETF to your portfolio and your options are: TLT (iShares 20+ year bonds), DIA (Dow Jones Industrial Average SPDR), and GLD (SPDR Gold Shares). The table below gives you the correlation matrix for SPY, TLT, DIA, and GLD. Which is the best (worst) ETF to combine with SPY to obtain the maximum benefit from diversification? Correlation matrix SPY TLT DIA GLD SPY 1...

SPY and XIU are ETFs tracking the S&P 500 and S&P/TSX 60 index, which are often...

SPY and XIU are ETFs tracking the S&P 500 and S&P/TSX 60 index, which are often used as proxies for the U.S. and Canadian stock markets, respectively. From a set of their historical data, the annual expected returns and standard deviations of those two ETFs and their covariance are estimated as follows: SPY: E(r)= 0.15 σ=0.28 XIU: E(r)= 0.18 σ=0.32 Covariance between SPY and XIU = 0.0618 Suppose that you have $10 million to invest for one year and you...

A reason to hold a portfolio of S&P 500 shares is a. Such a portfolio achieves...

A reason to hold a portfolio of S&P 500 shares is a. Such a portfolio achieves close to optimal gains from equity diversification b. Such a portfolio has returns that approach market returns c. Such a portfolio can be easily acquired through mutual funds d. All of the above

Part 1: The following table shows historical stock prices of Spider S&P 500 ETF and Amazon...

Part 1: The following table shows historical stock prices of Spider S&P 500 ETF and Amazon stock. The prices listed are the adjusted closing prices on the first day of each month from 9/1/2016 to 8/1/2018. The monthly risk-free rates for the T-bills are also listed in the table. Using the price data, calculate the monthly returns for the Spider S&P 500 ETF and the Amazon stock, respectively, from September 2016 to July 2018 (note that the monthly return for...

Using the portfolio and hedge ratio from the previous question, and assuming the S&P 500 intitial...

Using the portfolio and hedge ratio from the previous question, and assuming the S&P 500 intitial value is 3109.55. What is our portfolio value if the market drops 6%? What is the change in value of our puts? What is our total profit or loss?

You have invested $100,000 in the US stock market via the S&P 500 Depository Receipts ETF...

You have invested $100,000 in the US stock market via the S&P 500 Depository Receipts ETF (SPY) which tracks the S&P 500 Index. You are going to pull out your money once your investment triples in value (i.e. becomes $300,000). Assume, that the S&P 500 Depository Receipts ETF (SPY) which you have invested in earns a 9% per annum rate of return. How many years is it expected to be until you are going to pull out your money? Round...

The Daily S&P 500® Bull 3x ETF seeks daily investment results, before fees and expenses, of...

The Daily S&P 500® Bull 3x ETF seeks daily investment results, before fees and expenses, of 300% of the performance of the S&P 500® Index and Daily S&P 500® Bear 3x ETF seeks daily investment results, before fees and expenses, of 300% of the inverse (or opposite) of the performance of the S&P 500® Index. For the purposes of this question, disregard the effects of expenses and fees. Let the returns on S&P 500® Index on three consecutive days be,...

You have a $6,000,000 portfolio that has a beta of 1.9 to the S&P 500. You...

You have a $6,000,000 portfolio that has a beta of 1.9 to the S&P 500. You have decided you want to hedge this portfolio over the next 12 months. The 13-month S&P 500 futures price is $2300, and the current S&P 500 index value is $2250. The 12-month continuously compounded risk-free rate is 1% and the annual dividend yield on the S&P 500 is 2%. As a reminder, futures contracts are based on $250 multiplied by the index value. a)...

A fund manager has a well-diversified portfolio that mirrors the performance of the S&P 500 and...

A fund manager has a well-diversified portfolio that mirrors the performance of the S&P 500 and is worth $360 million. The value of the S&P 500 is 1,200, and the portfolio manager would like to buy insurance against a reduction of more than 5% in the value of the portfolio over the next six months. The risk-free interest rate is 6% per annum. The dividend yield on both the portfolio and the S&P 500 is 3%, and the volatility of...

You estimate that a passive portfolio invested to mimic the S&P 500 stock index yields an...

You estimate that a passive portfolio invested to mimic the S&P 500 stock index yields an expected rate of return of 10% with a standard deviation of 19%. Assume you manage a risky portfolio with an expected rate of return of 12% and a standard deviation of 24%. The T-bill rate is 5%. Your client would like to switch an 80% allocation in your portfolio to an 80% allocation in the stock market index. How much return would your client...