Spreadsheet Iteration of Reversionary Leasehold Rental Growth Rate Within The Framework of Explicit DCF Appraisals

Authors

DOI:

https://doi.org/10.11113/ijbes.v8.n1.576

Keywords:

Explicit DCF appraisal, Equivalent yield valuation, Implied rental growth, Reversionary leaseholds, Scenario analysis

Abstract

Income growth rates are required to justify decisions and strategies for property investments. Although existing studies addressed this phenomenon in freehold investments, a relative question regarding the determination of rental growth rates of leasehold investment properties valued part-way through rent review periods has not been addressed before now. This study examined the spreadsheet-assisted scenario analysis tools and techniques that are required for the determination of rental growth rates of leasehold investment properties valued part-way through rent review periods. A precursor to the scenario analysis was the development of a hybrid leasehold DCF valuation model arising from the equation of the formula for reversionary leasehold equivalent yield valuation to the formula for reversionary leasehold growth explicit DCF valuation model; thereby culminating into the identification of four unknown variables comprising the all risks yield and the implied growth rates of leasehold cash inflows and cash outflows which were subsequently derived using the solver tool of Excel®. From a total of eleven scenarios generated, the 9th successive scenario produced optimal results indicating zero slack between iterated and calculated values for the growth rates of leasehold cash inflows and cash outflows respectively. With recourse to the hybrid leasehold DCF valuation model, the spreadsheet-assisted scenario was found to produce mathematically valid growth rates that justify the valuation of leasehold investment properties part-way through rent review periods. The value of this research is the analytical tools and rigour it avails investors seeking income returns and growth from reversionary leasehold property as an instance of terminable investments.

Author Biography

Joseph Obaje Ataguba, Department of Estate Management and Valuation, The Federal Polytechnic Idah, P.M.B. 1037 Idah, Kogi State, Nigeria

Department of Estate Management and Valuation

School of Environmental Studies

Senior Lecturer

References

Adams, A., & Booth, P. (1996). The appraisal of over-rented property. Journal of Property Finance, 7(3): 7 - 22. doi: 10.1108/09588689610127127

Adams, A. T., Booth, P. M., & MacGregor, B. D. (1999). Property Investment Appraisal. British Actuarial Journal, 5: 955 - 982. doi: 10.1017/S1357321700000763

Adams, A. T., Booth, P. M., & MacGregor, B. D. (2003). Lease Terms, Option Pricing and the Financial Characteristics of Property. British Actuarial Journal, 9(3): 619 - 635. doi: 10.1017/S1357321700004293

Ajayi, C. A. (1998). Property Investment Valuation and Analysis. Ibadan: De-Ayo Publications.

Baum, A., & Yu, S.-M. (1985). The Valuation of Leaseholds: A Review: Part II. Journal of Property Valuation and Investment, 3(3): 230 - 247. doi: 10.1108/eb007973

Baum, A. E., & Crosby, N. (2008). Property Investment Appraisal. (3rd ed.). UK: Blackwell Publishing Ltd.

Baum, A. E., Mackmin, D., & Nunnington, N. (2011). The Income Approach to Property Valuation (6th ed.). London: Elsevier.

Blackledge, M. (2009). Introducing Property Valuation. London: Taylor & Francis.

Booth, P., Ashurst, R., Blundell, G., Brown, S., Cumberworth, M., Morrell, G., Pugh, R., & Waites, C. (2001). Options in Real Estate Contracts. Paper presented at the Finance and Investment Conference of the Faculty and Institute of Actuaries, Guernsey. https://www.actuaries.org.uk/system/files/documents/pdf/options-real-estate-contracts.pdf

Brown, G., & Matysiak, G. (2000). Real Estate Investment: A Capital Market Approach. England: Financial Times-Prentice Hall.

Buetow, G., & Albert, J. (1998). The Pricing of Embedded Options in Real Estate Lease Contracts. Journal of Real Estate Research, 15: 253-266.

Butler, D., & Richmond, D. (1990). Advanced Valuation. Basingstoke: Macmillan.

Clayton, J., Ling, D. C., & Naranjo, A. (2009). Commercial Real Estate Valuation: Fundamentals Versus Investor Sentiment. Journal of Real Estate Finance and Economics, 38: 5 - 37. doi: 10.1007/s11146-008-9130-6

Cornell, P. (2006). Beginning Excel What-If Data Analysis Tools: Getting Started with Goal Seek, Data Tables, Scenarios, and Solver. Berkeley: Apress.

Crosby, N. (1983). The Investment method of Valuation: A real value approach: 1. Journal of Valuation, 1(4): 341 - 350. doi: 10.1108/eb007937

Crosby, N. (1984). The Investment method of Valuation: A real value approach: 2. Journal of Valuation, 2(1): 48 - 59. doi: 10.1108/eb007948

Crosby, N. (1986a). The application of Equated Yield and Real Value Approaches to Market Valuation 2: Equivalent Yield or Equated Yield Approaches? Journal of Valuation, 4(3): 261 - 274. doi: 10.1108/eb007995

Crosby, N. (1986b). Real Value, Rational Model, D.C.F.: A Reply. Journal of Valuation, 4(1): 16 - 20. doi: 10.1108/eb007984

Crosby, N. (1986c). The application of Equated Yield and Real Value Approaches to Market Valuation 1: The Logic of Techniques and the Analysis of Comparables. Journal of Valuation, 4(2): 158 - 169. doi: 10.1108/eb007991

Crosby, N. (1996). Valuation and arbitrage: A Comment. Journal of Property Research, 13: 211 - 220. doi: 10.1080/09599916.1996.9965069

Crosby, N., French, N., & Ward, C. (1997). Contemporary UK market valuation methods for over-rented investment properties: A framework for risk adjustment. Journal of Property Research, 14: 99 - 115. doi: 10.1080/095999197368663

Crosby, N., & Goodchild, R. (1993). Reversionary Freeholds: Problems with Over-renting. Journal of Property Valuation and Investment, 11(1): 67 - 81. doi: 10.1108/14635789310031432

Crosby, N., & Henneberry, J. (2016). Financialisation, the valuation of investment property and the urban built environment in the UK. Urban Studies, 53(7), 1424-1441. doi: 10.1177/0042098015583229

Dayananda, D., Irons, R., Harrison, S., Herbohn, J., & Rowland, P. (2002). Capital Budgeting: Financial Appraisal of Investment Projects. Cambridge: Cambridge University Press.

Doppeigieter, J., & Rode, E. (2002). Capitalization rates and property yields: An analysis of South African commercial property market. Working Paper, International University in Germany, Bruchsal.

Fraser, W. D. (1988). Valuation Techniques: A Matter of Evidence and Motive. In A. R. MacLeary & N. Nanthakumaran (Eds.), Property Investment Theory, 14 - 25. London: E. & F. N. Spon

Fraser, W. D. (1993). Principles of Property Investment and Pricing (2nd ed.). Basingstoke: Macmillan.

French, N. (2006). Freehold valuations: the relationship between implicit and explicit DCF methods. Journal of Property Investment & Finance, 24(1): 87 - 91. doi: 10.1108/14635780610642999

French, N., & Ward, C. (1995). Valuation and arbitrage. Journal of Property Research, 12: 1 - 11.

French, N. S., & Ward, C. W. R. (1996). Applications of the arbitrage method of valuation. Journal of Property Research, 13: 47 - 56.

Geltner, D., & de Neufville, R. (2018). Flexibility and Real Estate Valuation under Uncertainty: A Practical Guide for Developers. New Jersey: Wiley-Blackwell.

Geltner, D. M., Miller, N. G., Clayton, J., & Eichholtz, P. (2010). Commercial Real Estate Analysis and Investments. (2nd ed.). Australia: Cengage Learning Inc.

Hargitay, S., & Yu, S.-M. (1993). Property Investment Decisions: A Quantitative Approach. London: E & FN Spon.

Ifediora, B. U. (2005). Valuation Mathematics for Valuers and other Financial and Investment Analysts. Enugu: Immaculate Publications Ltd.

Isaac, D. (1998). Property Investment. Basingstoke: Macmillan.

Isaac, D. (2002). Property Valuation Principles. Basingstoke: Palgrave.

Jones, I. G. (1983). Equivalent Yield Analysis. Journal of Valuation, 1(3): 246 - 252.

Lucius, D. I. (2001). Real options in real estate development. Journal of Property Investment & Finance, 19(1): 73 - 78. doi: 10.1108/14635780110365370

Luenberger, D. G. (1998). Investment Science. Oxford: Oxford University Press.

Marshall, P. (1976). Equated yield analysis. Estates Gazette, 239: 493 - 497.

Mba, W. O. (2020). An Examination of Discounted Cash Flow Valuation Model as it relates to Property Investments in Nigeria. IDOSR Journal of Arts and Management, 5(1): 32 - 45.

McGough, T., & Tsolacos, S. (2001). Do yields reflect property market fundamentals. Real Estate Finance and Investment Research, City University Business School, London.

McIntosh, A., & Sykes, S. (1983). Towards a standard property income valuation model: Rationalisation or Stagnation? Journal of Property Valuation and Investment, 1(2): 117 - 135. doi: 10.1108/eb007927

McIntosh, A., & Sykes, S. G. (1985). A Guide to Institutional Property Investment. Basingstoke: Macmillan.

Morley, D., & Parker, C. S. (2011). Understanding Computers: Today and Tomorrow (13 ed.). Boston: Cengage Technology.

Nanthakumaran, N. (1988). The Current Discounted Cash Flow Models for the Valuation and Analysis of Property Investment: An Examination of Some of the Problems. In A. R. MacLeary & N. Nanthakumaran (Eds.), Property Investment Theory , 24 - 46. London: E. & F. N. Spon

Parsons, G. (Ed.). (2003). The Glossary of Property Terms. London: Estates Gazette.

Pezeshkian, H., Lashgari, S., & Stiller, D. (2014). The value of flexibility: A finance application of options to real estate. Cornell Real Estate Review, 12,: 26 - 37.

RICS. (1997). Commercial Investment Property Valuation Methods: An Information Paper. Coventry: RICS Business Services Limited.

Sayce, S., Smith, J., Cooper, R., & Venmore-Rowland, P. (2006). Real Estate Appraisal; Value and Worth. Oxford: Blackwell Publishers.

Shen, J., & Pretorius, F. (2013). Binomial option pricing models for real estate development. Journal of Property Investment & Finance, 31(5), 418 - 440. doi: 10.1108/JPIF-10-2012-0046

Sykes, S. G. (1984). Property Valuation: A Rational Model. Journal of Valuation, 2(3): 258 - 270. doi: 10.1108/eb007956

Udo, G. O. (1989). Modern Techniques of Property Investment Valuation: The Nigerian Response. The Estate Surveyor and Valuer, 13(1): 19 - 24.

Ward, C., & French, N. (1997). The Valuation of upwards-only rent review: An option pricing model. Journal of Property Valuation and Investment, 15(2): 171 - 182. doi: 10.1108/14635789710166376

Wood, E. (1986a). Positive valuation methods: 2. Journal of Valuation, 4(2): 170 - 184. doi: 10.1108/eb007992

Wood, E. (1986b). Positive valuation methods: 1. Journal of Valuation, 4(1): 7 - 15. doi: 10.1108/eb007983

Wyatt, P. (2013). Property Valuation (2nd ed.). Chichester: Wiley-Blackwell.

Downloads

Published

2020-12-29