At the end of 2010, you decide to investigate a number of exchange-traded funds (ETFs) in an

Question:

At the end of 2010, you decide to investigate a number of exchange-traded funds (ETFs) in an attempt to build a diversified portfolio. You believe that the energy, natural resources, and telecommunications sectors are the best in which to invest. However, you are somewhat cautious in your outlook, so you are also considering some bonds. To begin, you have gathered the total returns from some ETFs in each of these sectors.

The data are shown in the following table. Note that the first three are equity index ETFs, while AGG and IEF are bond index ETFs.

At the end of 2010, you decide to investigate a

a. Calculate the average annual returns and standard deviations for each of the ETFs.
b. Which performed best on a risk/return basis during this period? Which was the worst? Use the Sharpe ratio and assume that the risk free rate was 3% during this period.
c. What is the expected return and standard deviation for an equally weighted portfolio that includes all of the ETFs, except for AGG?
d. Create an equally weighted portfolio of all the ETFs. Calculate the expected return and standard deviation of this portfolio.
e.
Compare the portfolios from part c and part d. Which would you prefer to own?

Expected Return
The expected return is the profit or loss an investor anticipates on an investment that has known or anticipated rates of return (RoR). It is calculated by multiplying potential outcomes by the chances of them occurring and then totaling these...
Portfolio
A portfolio is a grouping of financial assets such as stocks, bonds, commodities, currencies and cash equivalents, as well as their fund counterparts, including mutual, exchange-traded and closed funds. A portfolio can also consist of non-publicly...
Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  answer-question

Financial Analysis with Microsoft Excel

ISBN: 978-1111826246

6th edition

Authors: Timothy R. Mayes, Todd M. Shank

Question Posted: