200 likes | 372 Views
PORTFOLIO OPTIMISATION. AGENDA. Introduction Theoretical contribution Perceived role of Real estate in the Mixed-asset Portfolio Methodology Results Sensitivity Conclusion and Advice. INTRODUCTION. OBJECTIVE : Portfolio Optimization Consider proportion of Property Investments Client:
E N D
AGENDA Introduction Theoretical contribution Perceived role of Real estate in the Mixed-asset Portfolio Methodology Results Sensitivity Conclusion and Advice
INTRODUCTION • OBJECTIVE : • Portfolio Optimization • Consider proportion of Property Investments • Client: • UK Pension Fund • Institutional Investor • Invest only in UK assets • Risk minimization !!!
THEORETICAL CONTRIBUTIONGeltner, Miller, Clayton and Eiccholtz (2006): Chapter 21 • Markowitz Portfolio Theory (MPT): • Framework for strategic asset allocation of investor’s capital across asset classes • Widely used in practice • In particular by institutional investors • Also called Modern Portfolio Theory
Markowitz Portfolio Theory (MPT) • Basic Assumptions: • Investors want to maximize return and minimize risk in their wealth portofolios (1) • hold portfolio on the efficient frontier • There exists a riskless asset (2) • Common Expectations (3) • Two-fund theorem: (1) + (2) • “all investors will prefer combinations of the riskless asset and a single specific risky asset portfolio” • Two-fund theorem + Common Expectations • Everyone will hold the same portfolio of risky assets, i.e. the market portfolio
Markowitz Portfolio Theory (MPT) • Selection of risky asset portfolio • Maximize the slope of the straight line connecting the portfolio’s risk & return with the risk and return of the riskless asset • I.e. Maximize the Sharpe ratio • Sharpe Ratio • Represents the price of risk • Risk premium per unit of risk
Markowitz Portfolio Theory (MPT) • Basic Assumptions: • Investors want to maximize return and minimize risk in their wealth portofolios (1) • hold portfolio on the efficient frontier • There exists a riskless asset (2) • Two-fund theorem: (1) + (2) • “all investors will prefer combinations of the riskless asset and a single specific risky asset portfolio”
PERCEIVED ROLE OF REAL ESTATE IN MIXED-ASSET PORTFOLIO • Represents alternative asset class • Opportunity for further fund diversification • Why ? • Not highly correlated with other asset classes • Hence high Diversification benefit
METHODOLODY - Optimal Portfolio weights • Expected Return • Variance • Standard deviation • -Bonds • Stocks • Real Estate
METHODOLOGY • Identify Asset Universe for inclusion in Portfolio • Stocks, Bonds & Real Estate • Determination of individual Asset statistics • Expected Return • Variance • Standard Deviation • Determine Asset Correlation coefficients Equation (1) – Expected Return Equation (2) - Variance Equation (3) – Standard Deviation Equation (4) - Correlation
METHODOLOGY Determine sharp maximising Portfolio … Ratio that measure return premium per unit of Risk Given by formula below Where: rp: Portfolio return rf : Risk free rate Sp: Portfolio sigma ( standard deviation)
METHODOLOGY • Maximisation of Sharp Ratio • Maximizes Return ( Vertical Axis) • At the Lowest possible portfolio Risk (horizontal Axis) • Creates portfolio that lies at point P • Results in Portfolio with best return premium per unit of Risk assumed.
METHODOLOGY Maximise: Where Total portfolio weights sum up to 1 : Solved Using Excel Solver No short selling Constraints were imposed.
Summary statistics: • Residential Property has the highest expected return • The Government bonds have the lowest expected return & lowest standard deviation • Stocks have the highest Variance and standard deviation
RESULTS • Correlation Matrix: • Real estate shows very low, some negative, correlations with asset classes • Good Diversification benefits
RESULTS Optimal asset allocations:
SENSITIVITY Adjustments made to asset expected returns – The re-run solver We believe that the returns of residential assets are too high, So we made an adjustment (supposing that the returns will fall 6%) and the government bond will rise 2%. then we ran the solver again, and the weights of the optimal portfolio changed (residential has much less weight then before)
CONCLUSION AND ADVICE Current weight of Real estate in pension Portfolio : 16% Proposed weight of Real estate : 76.5% Therefore client should increase his investment in Real estate as per the Sharp maximising Portfolio