Capital Allocation Lines Assignment | Homework For You

NOTE it will not allow me to upload excel or the pdf. I need to upload either one or other, i tried pasting in but its too much info even for one question.

Don't use plagiarized sources. Get Your Assignment on
Capital Allocation Lines Assignment | Homework For You
Just from $13/Page
Order Now

Question 1. Capital Allocation Lines. Suppose that different hospitals within the Partners system choose different mixes of the STP and the baseline LTP.

Assume that the STP is a “risk-free asset” for the purposes of our analysis. The expected returns and risk of the STP and LTP are plotted on Exhibit 3 of the case.Homework For You

Using the Exhibit 3 data in the spreadsheet “PartnersHealthcare.xls”

  1. Reproduce the scatter plot from Exhibit 3 of the case. (Note: You will need to convert the data in the spreadsheet into numbers before you can plot it. You will also need to add rows for the STP and the LTP. This information is on p. 3 of the case.)
  2. On your scatter plot, illustrate the combinations of risk and return that are available by combining the risk free asset (STP) with the baseline LTP. (Hint: A straightforward way to do this in Excel is to use the formula for the capital allocation line we derived in class and then to plug in the various standard deviations in Exhibit 3. You can add this to your scatter plot as a new data series (the standard deviations are the x’s and the values from the formula for the capital allocation line are the y’s).)
  3. Similarly, on your scatter plot, illustrate the combinations of risk and return that are available by combining the risk free asset (STP) with the US Equity portfolio.
  4. If you had to choose a portfolio from only one of these two capital allocation lines, which line would you prefer? Why?

Question 2. Investment Opportunity Sets. In Exhibits 5 – 8, the case provides us with data to trace out an investment opportunity set for different underlying groups of risky asset classes. Our goal is to assess how these sets change as we add additional asset classes to the mix.

  1. Use the data on the 12 portfolios in Exhibit 5a to produce a figure illustrating the combinations of expected returns and standard deviations that can be achieved by forming portfolios of U.S. Equities, Foreign Equities, and Bonds. Check your work by comparing your graph to the curve in Exhibit 5B of the case. (They should look the same.) Once you have this, parts (2), (3), and (5) can be done essentially by copying and pasting.
  2. Add to your figure a new data series using the array of optimal portfolios with four assets classes presented in Exhibit 6. Note that here the new asset class that is added to the mix is REITs.
  3. Add to your figure a new data series using the array of optimal portfolios with four assets classes presented in Exhibit 7. Note that here the new asset class that is added to the mix is commodities.
  4. Separately compare the sets you obtain in parts (2) and (3) to the baseline case in part (1). Which asset class produces a bigger change to your investment opportunity set when it is added to the baseline: REITS or commodities? Why is this the case? (Hint: A look at the correlation table in Exhibit 3 and a review of our discussion in class for the two risky asset case might put you on the right track.)
  5. Finally, add to your figure a new data series using the array of optimal portfolios with all five assets classes presented in Exhibit 8.
  6. From which of the four graphed opportunity sets would you prefer to choose an investment portfolio? Why does the set of risky asset classes underlying this graph produce the most favorable combinations of expected return and risk? (A sentence or two will suffice here.)

Bonus Question. Optimization. (For this part, no additional computations are required. A clear explanation with reference to the graphs you have already produced is sufficient.) Consider the opportunity set you picked in Question 2, part 6 (Call this Set A). Now re-consider the scenario in Question 1. Putting the riskfree STP back in the mix, would hospitals prefer to choose an investment portfolio from the capital allocation line you identified in part 4 of Question 1 or from a capital allocation line formed by mixing the STP with a portfolio from Set A? (Note that this could be any portfolio from Set A that you wish.) Briefly explain.Get Finance homework help today

Calculate the price
Make an order in advance and get the best price
Pages (550 words)
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
How it works
Receive a 100% original paper that will pass Turnitin from a top essay writing service
step 1
Upload your instructions
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
Pro service tips
How to get the most out of your experience with Homework Writing Services
One writer throughout the entire course
If you like the writer, you can hire them again. Just copy & paste their ID on the order form ("Preferred Writer's ID" field). This way, your vocabulary will be uniform, and the writer will be aware of your needs.
The same paper from different writers
You can order essay or any other work from two different writers to choose the best one or give another version to a friend. This can be done through the add-on "Same paper from another writer."
Copy of sources used by the writer
Our college essay writers work with ScienceDirect and other databases. They can send you articles or materials used in PDF or through screenshots. Just tick the "Copy of sources" field on the order form.
See why 20k+ students have chosen us as their sole writing assistance provider
Check out the latest reviews and opinions submitted by real customers worldwide and make an informed decision.
Excellent work!
Customer 463463, October 13th, 2022
Customer 462865, April 18th, 2022
Excellent work.
Customer 462823, April 21st, 2022
Good work.
Customer 459155, May 22nd, 2022
This submission was excellently done. Looking foward to your future contribution.
Customer 463463, December 12th, 2022
The writer did a phenomenal job with the Research Report #1: Data Breach Incident Analysis & Report. All expectations were met and exceeded! Thank you for delivering an amazing product and a HUGE thank you to the customer service department for sending me an email to let me know the paper was checked to quality assurance team to ensure the paper was within standards of the instructions.
Customer 452455, February 3rd, 2023
Thank you for doing a great job. I really am glad that you did not use someones else work like the first person who did this did. Awesome job. Because of this I will continue to use this site!
Customer 454345, June 2nd, 2020
Human Resources Management (HRM)
Good work.
Customer 462499, May 29th, 2022
English 101
thank you for your professional work
Customer 454759, July 1st, 2020
Good work.
Customer 462759, June 15th, 2022
Great job on the revision. Rating reflects the revision after upgrading the writer. Previous tutor's assistance was not very good at all. I am still very happy with the assistance provided by the tutor and the support team.
Customer 454145, April 5th, 2020
Marketing & Advertising
Well written and researched. Looking forward to working with you in future.
Customer 463473, November 10th, 2022
Customer reviews in total
Current satisfaction rate
3 pages
Average paper length
Customers referred by a friend
15% OFF your first order
Use a coupon FIRST15 and enjoy expert help with any task at the most affordable price.
Claim my 15% OFF Order in Chat