Calculate an efficient frontier with the asset classes

Reference no: EM131992724

Assignment -

Family Supermarket Chain: A Case Study on Family Foundation Asset Allocation

Part I - Develop asset class assumptions for each of the asset classes above. Risk, return and correlation. Support your methodology. (See long term monthly asset class performance in excel). Your inputs are to be forward looking in nature. If you wish to use historical data to calculate input data, comment on any adjustments you have made for your analysis.

Calculate an efficient frontier with the above asset classes. Ranging from the least risky portfolio to the riskiest portfolio. Calculate expected rate of return and standard deviation for various portfolios along the efficient frontier.

Part II - Submit three portfolios to the attorney based on his concerns for liquidity and risk as he defined it. In your analysis, in addition to calculating the asset class allocations, the portfolio's expected return, expected risk, please calculate the probability of losing money, calculate the probability of losing more than 5%, and calculate the probability of not making more than 5% over a one-year time period for each suggested portfolio. Also, comment on how that allocation might change over time and market conditions.

Part III - Assuming the portfolio was conservatively constructed as of December 31, 2007, how would your recommendation change as of December 31, 2008 given the market declines and assuming industry asset allocation averages allocations remained the same. If you are recommending a change, comment how you would implement that change - immediately or over time?

Index	2008
S&P 500	(37.00)
MSCI EAFE	(43.38)
MSCI Emerging	(53.33)
Aggregate Index	5.24
90 Till Bills	2.10

Further guidelines on the construction and analysis of the portfolios will be provided. All data should be maintained on Excel spreadsheets.

Attachment:- Assignment Files.rar

Reference no: EM131992724

Questions Cloud

Identify which will have the higher? price : What is the? bond's yield to maturity? (expressed as an APR with semiannual? compounding)? identify which will have the higher? price.

Determine how your results are relative to genetics : Write a 1,050- to 1,400-word paper describing your personality traits based on your findings from the Big Five assessment tool. Include the following.

Explain why you felt the article was relevant : Share a current event article with the class that relates to the concepts covered in this week's reading.

Make a gripping open or close when presenting : What are some specific ways you can make a gripping open or close when presenting? Give a brief example?

Calculate an efficient frontier with the asset classes : Family Supermarket Chain: A Case Study on Family Foundation Asset Allocation. Calculate an efficient frontier with the above asset classes

Improve performance ratings : We discussed in depth about four ways to improve performance ratings. Discuss in detail these four strategies. Identify the one that you

Write summary on the target behavior in observable term : Write a 175-word summary on the target behavior in observable and measurable terms. Include the methods that will be used to observe and acquire baseline data.

Maintenance cost decrease to justify the purchase : If your opportunity cost is 8%, by how much would the maintenance cost decrease to justify the purchase?

What do you estimate the inflation rate to be in taiwan : What do you estimate the inflation rate to be in Taiwan, if short-term Taiwanese government securities yield 10 percent per year?

User Account

All Pages