Accessibility navigation

Computing Markowitz efficient frontiers using a spreadsheet optimiser

Byrne, P. and Lee, S., (1994) Computing Markowitz efficient frontiers using a spreadsheet optimiser. Working Papers in Land Management & Development. 25/94. Working Paper. University of Reading, Reading. pp10.

Full text not archived in this repository.

It is advisable to refer to the publisher's version if you intend to cite from this work. See Guidance on citing.


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 the variance or standard deviation. These portfolios can then be connected to generate what is termed an 'Efficient Frontier' (EF). In this paper we discuss the calculation of the Efficient Frontier for combinations of assets, again using the spreadsheet Optimiser. To illustrate the derivation of the Efficient Frontier, we use 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, we adopt a fairly typical pension fund profile, with no more than 20% of the total held in Property. The paper shows that it is now relatively easy to use the Optimiser 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.

Item Type:Report (Working Paper)
Divisions:Henley Business School > Real Estate and Planning
ID Code:27276
Publisher:University of Reading
Publisher Statement:The copyright of each working paper remains with the author. If you wish to quote from or cite any paper please contact the appropriate author; in some cases a more recent version of the paper may have been published elsewhere.

University Staff: Request a correction | Centaur Editors: Update this record

Page navigation