Find the mean and standard deviation

Assignment Help Finance Basics
Reference no: EM131263011

Finance Assignment-

Objective: To engage you in a "real life" asset allocation exercise. The project will require you to apply fundamental concepts of modern portfolio theory to come up with an efficient portfolio allocation to meet certain objectives.  In short, the project will require you to implement what you have learned in this course.

Teri Riley is a consultant to several college investment offices around the country. She is a specialist in asset allocation studies. She has accumulated performance figures from a number of different college endowments, as well as information about the typical stocks/bonds/cash mixtures common in the endowment universe. She practices a broad policy approach, which means that she makes recommendations about allocations across asset classes, rather than about which managers to choose, or which stocks to pick.

Riverdale College is a small mid-western, liberal arts college with a $50 million endowment as of Dec. 31, 2015.  It has had a fixed investment policy of 40% domestic stocks (spread equally between small and large cap portfolios labeled SMLSTK and LRGSTK, respectively), 20% international stocks (EAFE), 15% investment-grade corporate bonds (CBOND), 15% U.S. government bonds (GBOND), and 10% T-bills. This portfolio has been held from 1996 through 2015. The monthly returns on these asset classes are contained in the Excel spreadsheet titled "dataset2.xls" (available on the course web site). The portfolio manager hired by the college to manage its endowment fund is a successful alumnus. Most of Riverdale's assets are liquid. Enrollment at Riverdale has decreased steadily since its peak of 2200 students in 1998 to a low of 1500 in 2015.  Thus far, increased spending from endowment has offset the shortfall in revenue caused by declining tuition revenues. Since 1998, the annual average spending from endowment has been 4% (of the total value of the endowment fund) annually. In 2014 and 2015, the college had to spend 6% and 7%, respectively, and anticipates additional spending  of $5 million for the year 2016. Contributions to the endowment have continued steadily at 2% per year.  However, the poor record of the college's football team in recent years is a matter of concern since it directly affects contributions by alumni (in the mid-seventies the college won three consecutive Division III national championships).  Since the role of the endowment in meeting budget needs has increased dramatically in the past few years, the college has decided to review its past performance and future contributions to the institution.

Howard Weaver is the chairman of the endowment committee for the board of trustees of Riverdale. He found out about Ms. Riley from a friend of his who serves on the board of Rotter Dame University.  Rotter Dame employed Riley in 2015 to review its investment policy and to recommend an optimal portfolio mix.  Riley presented an asset mix for the Rotter Dame endowment that changed their exposure to stocks from 70% to 40% and  increased their exposure to bonds and alternative assets to 50%. Should Riverdale consider a change in its long-standing investment policy? How has the endowment and its money managers performed over the period since 1996? Weaver decided to have Teri and her firm look into these issues.

Weaver was also concerned with how risks should be defined in the context of Riverdale's investments.  He anticipated the need to continue relying on the endowment fund in the coming years. He felt strongly that a return of 0.01 (or 1 %) per month represented a target portfolio return that the college should seek to achieve. He wanted Riley to suggest an efficient asset allocation to achieve this goal. Lastly, Weaver wanted to know whether the board should be concerned about whether the endowment is adequate for the school's future needs. Can any improvements be suggested that would help the college to meet its needs going forward?

Based upon her consultations with Weaver, Riley has drawn up a list of issues that need to be addressed.  She has decided to hire your group for this task. You are required to prepare a preliminary report, which will address the following questions/tasks.  

1. How did the Riverdale portfolio perform over the 1998-2015 period? Report the portfolio mean, standard deviation, and Sharpe ratio.

2. Plot the portfolio frontier given the five risky assets the college is investing in (you may use the Solver module in Excel for this purpose).

3. Find the mean and standard deviation of the  portfolio of  risky  assets (consisting of investments in  three  stock portfolios and  two bond portfolios) currently chosen by the college's fund manager. Plot it. Is this an efficient portfolio? If not, calculate the investment proportions in the five assets required to construct an efficient risky portfolio, which would deliver the same expected return as the current choice of risky portfolio.

4. Calculate the investment proportions required to achieve the optimal (tangency) risky portfolio (you may use the Solver module in Excel for this purpose). What is the expected return and standard deviation of such a portfolio? Also, be sure to report the weights and the Sharpe ratio of the tangency portfolio. How does the Sharpe ratio compare to that of Riverdale's current risky portfolio?

5. Calculate the investment proportions required to construct a complete portfolio (i.e. one which mixes the optimal risky portfolio with T-bills) that has an expected return equal to the present (complete) portfolio's expected return. What is the expected standard deviation of return on such a portfolio?  How does this compare with the standard deviation of Riverdale's current complete portfolio?

6. Suggest a complete portfolio allocation between the optimal risky portfolio and T-bills to achieve the college's objective of a rate of return equal to 0.01 (1%) per month. What is the expected standard deviation of the portfolio?

7. Weaver is also interested in knowing if the college should include some alternative asset classes - specifically, real estate, commodities, private equity, hedge funds, and high-yield bonds - in its portfolio. Make a case for or against the inclusion of five alternative assets (labeled REITs, TIMBER, PE, HFMACRO, and HYBOND) in the college's overall portfolio.

Justify your decision by depicting the portfolio frontier that includes the five alternative assets. Plot it on the same graph you constructed for number (2). 

8a. Find the optimal (tangency) portfolio consisting of all ten asset classes. 

8b. Calculate the complete portfolio allocation required to achieve the target rate of return mandated by the college using this expanded universe of assets. What is the expected standard deviation of such a portfolio?

9. Find the 5-asset tangency portfolio, assuming no short sales of risky assets are allowed. Also, find the 10-asset tangency portfolio, assuming no short sales are allowed. Compare these results to the tangency portfolios when short sales are allowed. What happens to the Sharpe ratio? Which assets drop out and which assets dominate?

10. Present a forceful argument for using your services, summarizing what you have shown. Also, make a few succinct points that might help sway a board member skeptical of asset allocation methods (the member believes that individual stock selection is more important than asset allocation).

Attachment:- Assignment.rar

Verified Expert

In the given assignment, we were required to resolve the statistical assignment through application of formulas issued by various statisticians.

Reference no: EM131263011

Questions Cloud

The securities and exchange commission : The accounting and auditing professions are impacted by a number of regulatory and professional bodies. These include the Public Company Accounting Oversight Board (PCAOB) created by the Sarbanes Oxley Act of 2002; the Securities and Exchange Commiss..
Motivational techniques and processes : In this module, you learned about the motivational techniques and processes utilized by leaders in motivating employees. The purpose of this discussion is to explore the factors in the workplace that motivate people, tools utilized by employees to..
What are some workarounds you have had to learn : Things work and look a little differently in Office on a Mac than on a PC. Mac users - talk about some of the differences you intially noticed when switching from a PC to a Mac. What are some workarounds you've had to learn? If you've run into iss..
What was over-underapplied manufacturing overhead for year : Southern Rim Parts estimates its manufacturing overhead to be $374,500 and its direct labor costs to be $1,070,000 for year 1. The first three jobs that Southern Rim worked on had actual direct labor costs of $66,000 for Job 301, $91,000 for Job 302,..
Find the mean and standard deviation : Finance 320 Fall 2016 Assignment. Find the mean and standard deviation of the  portfolio of  risky  assets (consisting of investments in  three  stock portfolios and  two bond portfolios) currently chosen by the college's fund manager
Factors designated team characteristics : Multiple factors are associated with team effectiveness. They include factors designated Team Characteristics, Nature of Work, and the environmental Context.
Record the journal entry for the purchase of the equipment : ABC Company purchases a new machine. The machine costs are $100,000. The company also must pay freight of $500 to get the machine delivered and $1,000 to get the machine installed. Record the journal entry for the purchase of the equipment for this y..
Addressing overall expenditures : Addressing Overall Expenditures in the U.S. Health Care Industry Many people believe that health care in the United States is unaffordable. Do you agree? If so, what can and should be done to address this?
About the transaction analysis : Polly's Cards & Gifts Shop had the following transactions during the year: Polly's purchased inventory on account from a supplier for $7,840. Assume that Polly's uses a periodic inventory system. Assume that Polly's accounting year ends on December 3..

Reviews

len1263011

11/2/2016 4:35:54 AM

Answer the 10 questions using excel, and post the answer in the word file. The requirements are to use solver and other functions. To engage you in a "real life" asset allocation exercise. The project will require you to apply fundamental concepts of modern portfolio theory to come up with an efficient portfolio allocation to meet certain objectives.

Write a Review

 

Finance Basics Questions & Answers

  The short run aggregate supply curve

Explain how Firms and workers reduce their expectations of future inflation affects the short-run aggregate supply curve.

  What if the company finds out the monthly rent

What if the company finds out the monthly rent will increase to $3,000, what budgets are affected? Why? What is the New Net income (Loss)?

  Evaluate the above recommendation of the working group

suppliers and clients but still equated with their general common interest, which is to safeguard the prosperity and continuity of the company." Evaluate the above recommendation of the working group.

  What annual interest rate is idaho first bank pay

The company plan to make 20 equal deposits of $186,078.54, starting in six months, to accumulate the $5 million fund. What annual interest rate is Idaho First Bank & Trust paying on the balance of the fund?

  List some examples of financial decisions

List some examples of financial decisions that construction managers must make.

  Approach to motivation

What's the worse job you've ever had? (If you haven't worked professionally, that's okay. Think about the worst task you ever had to do, personally). What approach to motivation was used to get you to perform?

  What is the best estimate of the stock current market

The required return on this low-risk stock is 9.00%. What is the best estimate of the stock's current market value?

  Determine company projected net income

Corporation x recently reported the following 2008 income statement in millions of dollars, this year the company is forecasting a 25 percent increase in sales.

  Explain which account would earn more money for the

for this assignment you will prepare a powerpoint presentation evaluating and explaining the 401k and individual

  Which of the following approaches for calculating

which of the following approaches for calculating operational risk capital charges leads to a higher capital charge for

  Qthe analyst has modelled the stock of the company by using

q.the analyst has modelled the stock of the company by using a fama-french three-factor model. risk-free rate is 3

  Interest earned tell us about fixed charge coverage explain

What does times interest earned tell us about a firm's short-term and long-term debt paying ability? What does times interest earned tell us about fixed charge coverage? Explain.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd