What'sBest! Markowitz Portfolio Selection

Problem: Selecting assets to meet a desired return at minimum variance.

(In the March, 1952, issue of Journal of Finance, Harry M. Markowitz published an article called "Portfolio Selection". In it, he demonstrated how to reduce the standard deviation of returns on asset portfolios by selecting assets which don't move in exactly the same ways. At the same time, he laid down some basic principles for establishing an advantageous relationship between risk and return, and his work is still in use forty years later.)

You're considering investing in three assets and historical data reveal that the return from each asset has fluctuated over time. You want to reduce variability, or risk, by spreading your investment over the three stocks.

From the historical data, you have calculated an expected return, the variance of the return rate, and the covariance of the return between the different assets. Variance is a measure of the fluctuation in the return - the higher the variance, the riskier the investment. The covariance is a measure of the correlation of return fluctuations of one stock with the fluctuations of another. High covariance indicates that an increase in one stock's return is likely to correspond to an increase in the other. A low covariance means the return rates are relatively independent and a negative covariance means that an increase in one stock's return is likely to correspond to a decrease in the other.

You have a target return of 15%. What percentages of your funds should you invest in each of the three assets to achieve this target and minimise the variance (or risk) of the portfolio? As an additional safety feature, you decide to invest no more than 75% in any single asset.

The objective is to determine the percent to invest in each asset while minimising risk of the entire portfolio.

 WHAT'SBEST! What'sBest! Overview What'sBest! Models Optimizers Overview Remarkable Home Page Email us PROBLEMS SOLVED Production Multi-Period Inventory Mgt Product Mix The Building Block Method Cutting Waste Minimisation Plant Locating Transportation Pipeline Optimisation Shipping Cost Reduction Traffic Cost Minimisation Truck Loading Blending Models Blending Chance-constrained Blends Engineering Models Box Design Flow Network Modeling Financial Models Bond Portfolio Optimisation Lockbox Location Markowitz Portfolio Selection Portfolio+Transaction Costs Portfolio Portfolio Scenarios Forecasting Seasonal Sales Factoring Forecasting Sales Marketing Stratified Sampling Car Pricing Media Buying Staff Scheduling Staff Scheduling Preferred Assignment 2- Stage Fixed Shift

Unless specified otherwise, the entire contents of this site are protected by copyright.