Finance questions

0 comments

Study below two questions, submit Excel spreadsheets in a file, along with Word file (one and a half to two pages),

Word file is for writing only. No need to put graphs there. A good format could be brief introduction, methodology, finding and conclusion (recommendation). No fixed format on Word file. All analysis and graphs need to be in EXCEL.

  1. Suppose different hospitals within the Partners system choose different mixes of the “risk-free” STP and the baseline LTP, whose future expected returns and risks are shown in Exhibit 3. On Exhibit 3, plot the returns and risks of the various potential portfolios that can be formed by allocating funds between the STP and the baseline LTP. What shape does a line drawn through these portfolios take? Why?
  2. Choose one of the below three questions to answer (not all unless you want to). Summarize how each of the “real assets” improves the potential opportunities for the hospitals investing in the LTP. (You need at least 30 combinations to finish each scenario) What are the important factors that determine the degree of improvement: 2.1. Plot the curve for the risks and expected returns of the optimal portfolio combinations in the 4 asset classes in Exhibit 6. 2.2. Plot the curve for the risks and expected returns of the optimal portfolio combinations in the 4 asset classes in Exhibit 7. 2.3. Plot the curve for the risks and expected returns of the optimal portfolio combinations in the 5 asset classes in Exhibit 8.
  3. plagiarism free

submit both word and excel

About the Author

Follow me


{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}