Real Estate Portfolio Analysis Using a Spreadsheet Optimizer

Abstract

Discusses a spreadsheet tool called an “optimizer” which is useful for examining certain real estate investment problems. Describes what this tool is (a means of, for example, maximizing return while minimizing risk) and how it functions, giving examples of calculations and functioning. Concludes that such a tool is potentially powerful, but that formulae could easily be set up incorrectly. Adds that spreadsheets and manuals do not contain enough documentation for beginners to understand results fully.

Citation

Byrne, P. and Lee, S. (1994), "Real Estate Portfolio Analysis Using a Spreadsheet Optimizer", Journal of Property Finance, Vol. 5 No. 4, pp. 19-31. https://doi.org/10.1108/09588689410080266