6 questions

Description

Having Trouble Meeting Your Deadline?

Get your assignment on 6 questions  completed on time. avoid delay and – ORDER NOW

I have 6 questions I need you to answer in an excel spreadsheet. I attached the data you need to use. answer all question. also other than the excel sheet attach a word document that include all relevant tables, figures, and commentary
that answer all questions. show everything.

data:

contains the monthly returns of valueweighted equity indexes divided into various groups:
• North America — Canada and the United states
• Japan
• Asia Pacific — Australia, Hong Kong, New Zealand, and Singapore
• Europe — Austria, Belgium, Denmark, Finland, France, Germany, Greece, Ireland, Italy, the
Netherlands, Norway, Portugal, Spain, Sweden, Switzerland, and the United Kingdom
• Global – All of the above countries
All index returns are in US dollar terms. In addition, the file contains the 1month US riskfree rate.


questions
1.) On a single chart, plot the value of $1 invested in each of the five indexes over time. I.e., for all
??, plot the cumulative return series for each index:
?????? = (1 + ??1)(1 + ??2) (1 + ????)
What patterns do you observe? (10 points)

2.) Plot a histogram of only the Global index returns. Does the distribution look normal? (5 points)

3.) Estimate the following for each of the indices. In calculating the statistics, “monthly” can be
interpreted as “not annualized”. (30 points)

a. Arithmetic average of monthly returns, and annualized arithmetic return using the APR
method
b. Geometric average of monthly returns, and annualized geometric return using the EAR
method. Why does the geometric average differ from the arithmetic average?
c. Standard deviation of monthly returns, and annualized standard deviation
d. Sharpe Ratio of monthly returns, and annualized Sharpe Ratio
e. Skewness of monthly returns
f. Kurtosis of monthly returns
g. 5% Value at Risk (VaR) of monthly returns
h. 5% Expected Shortfall of monthly returns
i. Only for the Global index: based on your answers for (e)(h), what do each indicate
about using just the standard deviation to estimate risk?

4.) Suppose you have a riskaversion coefficient of 3.0, and utility function of,
?? = ??[??] ? 1
2 ????2,
that uses your estimate of annual arithmetic returns (APR) and variance. Which index would
you invest in? (5 points)

5.) Assume that only a single risky asset exists (the Global index), and a single riskfree rate (the 1
month US riskfree rate) at which investors can borrow and lend. Assume the riskfree rate is
equal to its timeseries average and has zero variance. Also assume the utility function
provided in the previous problem, with a riskaversion coefficient of 3.0. For all parts use your
estimate of annualized arithmetic average returns (APR) and annualized variance.

a. Plot the capital allocation line (CAL) in the expected returnstandard deviation plane.
What does moving up and down the CAL represent about the allocation between the
two assets? What is the intercept of the line? What is its slope? What is the economic
significance of the intercept and slope?

b. Plot the investor’s utility of the complete portfolio as a function of the allocation to the
risky asset. What does the curve suggest about the investor’s approximate optimal
allocation to the risky asset?

On the same plot as the CAL in (a), plot the indifference curve in the expected return
standard deviation plane corresponding to a utility level of 0.03 for an investor with a
risk aversion coefficient of 3. Plot a second indifference curve corresponding to the
utility level suggested by (b). How does the second indifference curve differ from the
first? What is the relation of the second indifference curve with respect to the CAL?

d. What is the exact allocation to the risky asset in the complete portfolio that maximizes
the utility of the investor?

6.) Imagine that you are an investor on January 1, 2004, using the historical data up to that date.
I.e., unless otherwise indicated only use the data prior to 2004. Assume that the Global index
cannot be included in your portfolio. I.e., only use the returns for North America, Japan, Asia
Pacific, and Europe.

a. Plot the efficient frontier for the risky assets assuming that shortselling is allowed.
What does the efficient frontier represent?

b. What are the weights on the maximum Sharpe Ratio (SR) portfolio assuming short
selling is allowed? If you applied these weights to your portfolio on January 1, 2004,
what would the SR of your portfolio be over the next 10 years (i.e., an outofsample
test from 1/1/2004 through 12/31/2013)?

c. What are the weights on the maximum SR portfolio assuming shortselling is NOT
allowed? If you applied these weights to your portfolio, what would the SR of your
portfolio be over the next 10 years?

d. Comparing the performance of the two approaches in (b) and (c), which one generated
better outofsample performance? Explain.

e. What are the weights on the minimum global variance portfolio? If you applied these
weights to your portfolio, what would the SR of your portfolio be over the next 10
years?

Explanation & Answer

Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Order Now and we will direct you to our Order Page at Litessays. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.

Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.

Do you need an answer to this or any other questions?

Similar Posts