Accessibility navigation

A note on the use of spreadsheet optimisers in real estate analysis

Byrne, P. and Lee, S., (1994) A note on the use of spreadsheet optimisers in real estate analysis. Working Papers in Land Management & Development. 19/94. Working Paper. University of Reading, Reading. pp11.

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.


Modern Portfolio Theory (MPT) has been advocated as a more rational approach to the construction of real estate portfolios. The application of MPT can now be achieved with relative ease using the powerful facilities of modern spreadsheet, and does not necessarily need specialist software. This capability is to be found in the use of an add-in Tool now found in several spreadsheets, called an Optimiser or Solver. The value in using this kind of more sophisticated analysis feature of spreadsheets is increasingly difficult to ignore. This paper examines the use of the spreadsheet Optimiser in handling asset allocation problems. Using the Markowitz Mean-Variance approach, the paper introduces the necessary calculations, and shows, by means of an elementary example implemented in Microsoft's Excel, how the Optimiser may be used. Emphasis is placed on understanding the inputs and outputs from the portfolio optimisation process, and the danger of treating the Optimiser as a Black Box is discussed.

Item Type:Report (Working Paper)
Divisions:Henley Business School > Real Estate and Planning
ID Code:27270
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