Computing Markowitz Efficient Frontiers Using a Spreadsheet Optimizer

Authors: Byrne, Peter; Lee, Stephen

Source: Journal of Property Finance, Volume 5, Number 1, 1994 , pp. 58-66(9)

Publisher: Emerald Group Publishing Limited

Buy & download fulltext article:

OR

Price: $60.20 plus tax (Refund Policy)

Abstract:

Markowitz showed that assets can be combined to produce an "efficient" portfolio that will give the highest level of portfolio return for any level of portfolio risk, as measured by variance or standard deviation. These portfolios can then be connected to generate what is termed an "efficient frontier" (EF). Discusses the calculation of the efficient frontier for combinations of assets, again using the spreadsheet optimizer. To illustrate the derivation of the efficient frontier, uses the data from the Investment Property Databank Long Term Index of Investment Returns for the period 1971 to 1993. Many investors might require a certain specific level of holding or a restriction on holdings in at least some of the assets. Such additional constraints may be readily incorporated into the model to generate a constrained EF with upper and/or lower bounds. This can then be compared with the unconstrained EF to see whether the reduction in return is acceptable. To see the effect that these additional constraints may have, adopts a fairly typical pension fund profile, with no more than 20 per cent of the total held in property. Shows that it is now relatively easy to use the optimizer available in at least one spreadsheet (EXCEL) to calculate efficient portfolios for various levels of risk and return, both constrained and unconstrained, so as to be able to generate any number of efficient frontiers.

Keywords: Financial Modelling; Markowitz Efficient Frontiers; Portfolio Investment; Spreadsheets

Document Type: Research Article

DOI: http://dx.doi.org/10.1108/09588689410063210

Publication date: January 1, 1994

More about this publication?
Related content

Key

Free Content
Free content
New Content
New content
Open Access Content
Open access content
Subscribed Content
Subscribed content
Free Trial Content
Free trial content

Text size:

A | A | A | A
Share this item with others: These icons link to social bookmarking sites where readers can share and discover new web pages. print icon Print this page