Posted: December 17th, 2014
Global Investments- Portfolio Building
Project description
building portfolio
———-
Added on 16.12.2014 00:28
You are the Chief Investment Officer (CIO) of the $1.8 billion Private University Endowment Fund. The endowment board of trustee has decided to take a global approach and expanding asset classes to manage assets. The previous structure of an all U.S. exposure of 60% equities (large and small cap) and 40% fixed income has failed to return the 6.5% needed meet the spending requirements of the University. In 2013 the Fund returned 5.4% with a standard deviation risk measure of 8.9%.
In response the Funds Investment Committee revised the Endowments investment policy structure to include a wider range of investment options. The goal of the amended policy is to generate a real return of 8.7% (fund spending policy of 6.5% plus a 2.2% for inflation). The committee has developed the following investment policy constraints you will need to follow when creating your overall asset allocation strategy and hiring investment managers. The Efficient Frontier Optimization Spreadsheet will be used for this project.
Investment Policy Constraints for this exercise:
The risk as measured by standard deviation must be between 10% and 18%.
The overall asset allocation MAXIMUM EXPOSURE to the US is 40%, or $720 million.
The policy allows for asset allocation target range (constraints) for investments as follows:
Minimum – Maximum Allocations
Equities
25% – 65% (including sector, country funds, active, index investments)
Fixed Income
15% – 30% (including corporate, sovereign, US treasuries, high yield max. allocation is 5%.
Commodities
25% – 45% (including global commodities, hedge fund, private equity, REITS)
THE ASSIGNMENT
The Chair of the board of trustees has charged you with the task of devising a new asset allocation strategy following the constraints outlined above. Applying the concepts from class, and using the Efficient Frontier Optimization Spreadsheet on blackboard as your guide when making allocation decisions. Prepare an 8 – 10 page, double spaced written analysis to arrive at your recommendation. You should determine an optimal portfolio (asset mix) in an effort to meet the return and risk expectations of the plan employing the guidelines as established by the board of trustees. Graphics and charts can be included in the analysis provided they are not greater than 30% of the overall analysis.
You will be the CIO so investment selections MUST NOT include individual securities but use exchange traded funds ETFs, mutual funds, open or closed MF, master limited partnerships MLPs, or commingled instruments as investments. You will have complete flexibility with choosing the individual investment instruments, and can include an options strategy, and currency direct investment or hedging strategy. As discussed in class all investments must use a 3 or 5 year risk/return analysis to better reflect the risk return exposure of the asset class and the constraints outlined above must be followed, (refer to spreadsheet for some ideas). You can include index vs active strategies for the individual asset classes. The MINIMUM number of investments (ETFs, MLPs, MFs and/or commingled funds) will be 15. You must include the efficient frontier optimization spreadsheet or picture risk/return spreadsheet analysis as an exhibit to the overall paper.
———-
Added on 16.12.2014 00:37
In this report, simply use the data in the 2nd and the 3rd page of the spreadsheet to build an portfolio. You don”t have to invest in all of the products, but to choose some from them and meet the requirement in the instruction. After deciding what investment product you want to invest, you need to get their return and standard deviation which are in the spreadsheet already. Then you come to the first page of the spreadsheet and input the return and risk in the second part. After that, you need to input the percentage of investment in the first part of the efficient frontier as your allocation decision. The portfolio return and risk will be calculated automatically. In the report, you just need to explain what you have invested and why you make that decision. If you have any questions, please be free to contact me.
Take Home Final Project – Global Investments
You are the Chief Investment Officer (CIO) of the $1.8 billion Private University Endowment Fund. The endowment board of trustee has decided to take a global approach and expanding asset classes to manage assets. The previous structure of an all U.S. exposure of 60% equities (large and small cap) and 40% fixed income has failed to return the 6.5% needed meet the spending requirements of the University. In 2013 the Fund returned 5.4% with a standard deviation risk measure of 8.9%.
In response the Fund’s Investment Committee revised the Endowment’s investment policy structure to include a wider range of investment options. The goal of the amended policy is to generate a real return of 8.7% (fund spending policy of 6.5% plus a 2.2% for inflation). The committee has developed the following investment policy constraints you will need to follow when creating your overall asset allocation strategy and hiring investment managers. The Efficient Frontier Optimization Spreadsheet will be used for this project.
Investment Policy Constraints for this exercise:
• The risk as measured by standard deviation must be between 10% and 18%.
• The overall asset allocation MAXIMUM EXPOSURE to the US is 40%, or $720 million.
The policy allows for asset allocation target range (constraints) for investments as follows:
Minimum – Maximum Allocations
• Equities
25% – 65% (including sector, country funds, active, index investments)
• Fixed Income
15% – 30% (including corporate, sovereign, US treasuries, high yield max. allocation is 5%.
• Commodities
25% – 45% (including global commodities, hedge fund, private equity, REITS)
THE ASSIGNMENT
The Chair of the board of trustees has charged you with the task of devising a new asset allocation strategy following the constraints outlined above. Applying the concepts from class, and using the Efficient Frontier Optimization Spreadsheet on blackboard as your guide when making allocation decisions. Prepare an 8 – 10 page, double spaced written analysis to arrive at your recommendation. You should determine an optimal portfolio (asset mix) in an effort to meet the return and risk expectations of the plan employing the guidelines as established by the board of trustees. Graphics and charts can be included in the analysis provided they are not greater than 30% of the overall analysis.
You will be the CIO so investment selections MUST NOT include individual securities but use exchange traded funds ETFs, mutual funds, open or closed MF, master limited partnerships MLPs, or commingled instruments as investments. You will have complete flexibility with choosing the individual investment instruments, and can include an options strategy, and currency direct investment or hedging strategy. As discussed in class all investments must use a 3 or 5 year risk/return analysis to better reflect the risk return exposure of the asset class and the constraints outlined above must be followed, (refer to spreadsheet for some ideas). You can include index vs active strategies for the individual asset classes. The MINIMUM number of investments (ETF’s, MLP’s, MF’s and/or commingled funds) will be 15. You must include the efficient frontier optimization spreadsheet or picture risk/return spreadsheet analysis as an exhibit to the overall paper.
Deadline for submission via email or hand delivered is THURSDAY December 18 2014. Early submissions are encouraged. Late submissions will be penalized ½ a grade for each day of missing the deadline.
EFFICIENT FRONTIER ANALYSIS
Input Security 1 2 3 4 5 6 7 8 9 10
US Large Cap Equities 0.0% 10.0% 15.0% 17.0% 20.0% 25.0% 27.0% 28.0% 35.0% 35.0%
US Small Cap Equities 0.0% 5.0% 10.0% 12.0% 14.0% 16.0% 17.0% 20.0% 20.0% 25.0%
MSCI EAFE Non-US Developed Mkts. 0.0% 0.0% 0.0% 3.0% 6.0% 8.0% 9.0% 11.0% 10.0% 10.0%
MSCI Non-US Emerging Mkt Equity 0.0% 0.0% 0.0% 3.0% 5.0% 6.0% 8.0% 8.0% 10.0% 5.0%
US and Non-US Fixed Income (bonds) 100.0% 75.0% 65.0% 55.0% 45.0% 35.0% 26.0% 15.0% 5.0% 0.0%
Emerging Markets Fixed Inc (bonds) 0.0% 10.0% 6.0% 4.0% 2.0% 0.0% 0.0% 0.0% 0.0% 0.0%
Global REITS 0.0% 0.0% 2.0% 2.0% 3.0% 4.0% 5.0% 6.0% 6.0% 5.0%
Commodities 0.0% 0.0% 2.0% 2.0% 3.0% 3.0% 5.0% 5.0% 5.0% 5.0%
Private Equity 0.0% 0.0% 0.0% 2.0% 2.0% 3.0% 3.0% 7.0% 4.0% 7.5%
Hedge Funds 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 5.0% 7.5%
Must sum to 100% Allocation 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0%
Return 3.96% 5.22% 5.98% 6.34% 6.78% 7.25% 7.60% 8.14% 8.51% 9.13%
Risk 2.71% 3.47% 4.21% 5.36% 6.46% 7.89% 8.66% 10.43% 10.95% 11.85%
Input Security Return Risk
US Large Cap Equities 8.2% 13.4%
US Small Cap Equities 14.3% 15.2%
MSCI EAFE Non-US Developed Mkts. 6.5% 14.3%
MSCI Non-US Emerging Mkt Equity 4.5% 17.2%
US and Non-US Fixed Income (bonds) 4.0% 2.7%
Emerging Markets Fixed Inc (bonds) 7.2% 7.8%
Global REITS 7.9% 15.8%
Commodities 8.2% 28.0%
Private Equity 6.5% 26.1%
Hedge Funds 7.3% 7.2%
Correlation Matrix
15 year Correlation Matrix, U.S. Dollar Denominated
1991-2010 US Large Cap Equities US Small Cap Equities MSCI EAFE Non-US Dev. Mkts Emerging Mkt Eq, US & Non-US Fixed Inc (bonds) Emerging Market Fixed Inc. (bonds) Global REITS Commodities Private Equity Hedge Funds
US Large Cap Equities 1.00 0.74 0.59 0.54 0.22 0.23 0.46 -0.28 0.70 0.59
US Small Cap Equities 0.74 1.00 0.47 0.55 0.06 0.16 0.76 -0.32 0.76 0.54
MSCI EAFE Non-US Developed Mkts. 0.59 0.47 1.00 0.81 -0.10 0.38 0.30 -0.15 0.67 0.61
MSCI Non-US Emerging Mkt Equity 0.54 0.55 0.81 1.00 0.04 0.48 0.34 0.20 0.61 0.55
US and Non-US Fixed Income (bonds) 0.22 0.06 -0.10 0.04 1.00 0.43 0.10 -0.21 -0.67 0.17
Emerging Markets Fixed Inc (bonds) 0.23 0.16 0.38 0.48 0.43 1.00 0.27 0.16 -0.82 0.22
Global REITS 0.46 0.76 0.30 0.34 0.10 0.27 1.00 -0.27 0.82 0.61
Commodities -0.28 -0.32 -0.15 0.20 -0.21 0.16 -0.27 1.00 0.45 0.31
Private Equity 0.70 0.76 0.67 0.61 -0.67 -0.82 0.82 0.45 1.00 0.65
Hedge Funds 0.59 0.54 0.61 0.55 0.17 0.22 0.61 0.31 0.65 1.00
Covariance Matrix
1991-2010 US Large Cap Equities US Small Cap Equities MSCI EAFE Non-US Dev. Mkts Emerging Mkt Eq, US & Non-US Fixed Inc (bonds) Emerging Market Fixed Inc. (bonds) Global REITS Commodities Private Equity Hedge Funds
US Large Cap Equities 0.0180 0.0151 0.0112 0.0124 0.0008 0.0024 0.0097 -0.0105 0.0245 0.0057
US Small Cap Equities 0.0151 0.0231 0.0102 0.0144 0.0002 0.0019 0.0182 -0.0136 0.0301 0.0059
MSCI EAFE Non-US Developed Mkts. 0.0112 0.0102 0.0203 0.0199 -0.0004 0.0042 0.0067 -0.0060 0.0249 0.0063
MSCI Non-US Emerging Mkt Equity 0.0124 0.0144 0.0199 0.0297 0.0002 0.0064 0.0092 0.0096 0.0274 0.0068
US and Non-US Fixed Income (bonds) 0.0008 0.0002 -0.0004 0.0002 0.0007 0.0009 0.0004 -0.0016 -0.0047 0.0003
Emerging Markets Fixed Inc (bonds) 0.0024 0.0019 0.0042 0.0064 0.0009 0.0060 0.0033 0.0035 -0.0166 0.0012
Global REITS 0.0098 0.0181 0.0067 0.0093 0.0004 0.0033 0.0248 -0.0119 0.0337 0.0069
Commodities -0.0106 -0.0136 -0.0058 0.0097 -0.0016 0.0035 -0.0119 0.0784 0.0329 0.0062
Private Equity 0.0245 0.0301 0.0249 0.0274 -0.0047 -0.0166 0.0337 0.0329 0.0681 0.0122
Hedge Funds 0.0057 0.0059 0.0063 0.0068 0.0003 0.0012 0.0069 0.0062 0.0122 0.0052
PLACE THIS ORDER OR A SIMILAR ORDER WITH US TODAY AND GET AN AMAZING DISCOUNT 🙂
Place an order in 3 easy steps. Takes less than 5 mins.