IDEAS home Printed from https://ideas.repec.org/a/vrs/remava/v29y2021i2p52-70n5.html
   My bibliography  Save this article

Synthesis of Short-Cut DCF Appraisal and Spreadsheet Iteration of Freehold Rental Growth Rates Across Specific Valuation Epochs

Author

Listed:
  • Ataguba Joseph Obaje

    (Department of Estate Management and Valuation The Federal Polytechnic Idah, Kogi State Nigeria)

Abstract

While the use of simple deterministic models to calculate rental value growth (RVGrowth) rate of reversionary freeholds across epochs prior to upward rent review appears illusive, literature evidence of the synthesis between short-cut DCF valuation and Solver tools in a spreadsheet does not constitute an exhaustive list of solutions. This study examined alternative spreadsheet and iteration tools that can determine RVGrowth rate of freehold investment properties across rent review epochs. With recourse to a hypothetical case of a freehold investment property, this experimental study identified the mathematical composition of RVGrowth in an explicit DCF framework, performed short-cut DCF Valuation and equivalent yield calculation at specific epochs prior to and including the full reversion; as well as using Goal Seek to calculate RVGrowth across all epochs prior to- and including the full reversion. Excel® Solver and Goal Seek, as well as the graphing/root-solving tool in Kyplot® were found to feasibly produce identical results for RVGrowth rate. This is among the limited studies that identified and researched the veracity of alternative tools for RVGrowth rate iteration. The value of this study is the awareness of alternative analytical tools avail freehold investors who desire knowledge of RVGrowth rate when making purchase-, hold-, and sales decisions.

Suggested Citation

  • Ataguba Joseph Obaje, 2021. "Synthesis of Short-Cut DCF Appraisal and Spreadsheet Iteration of Freehold Rental Growth Rates Across Specific Valuation Epochs," Real Estate Management and Valuation, Sciendo, vol. 29(2), pages 52-70, June.
    • Handle: RePEc:vrs:remava:v:29:y:2021:i:2:p:52-70:n:5
    DOI: 10.2478/remav-2021-0013
    as

    Download full text from publisher

    File URL: https://doi.org/10.2478/remav-2021-0013
    Download Restriction: no
    File URL: https://libkey.io/10.2478/remav-2021-0013?utm_source=ideas
    LibKey link: if access is restricted and if your library uses this service, LibKey will redirect you to where you can use your library subscription to access this item
    ---><---

    References listed on IDEAS

    as
    1. Jim Clayton & David Ling & Andy Naranjo, 2009. "Commercial Real Estate Valuation: Fundamentals Versus Investor Sentiment," The Journal of Real Estate Finance and Economics, Springer, vol. 38(1), pages 5-37, January.
    2. Angus P. J. McIntosh & Stephen G. Sykes, 1985. "A Guide to Institutional Property Investment," Palgrave Macmillan Books, Palgrave Macmillan, number 978-1-349-07154-8, December.
    3. Neil Crosby & Nick French & Charles Ward, 1997. "Contemporary UK market valuation methods for over-rented investment properties: a framework for risk adjustment," Journal of Property Research, Taylor & Francis Journals, vol. 14(2), pages 99-115, January.
    4. Adams, A.T. & Booth, P.M. & MacGregor, B.D., 1999. "Property Investment Appraisal," British Actuarial Journal, Cambridge University Press, vol. 5(5), pages 955-982, December.
    Full references (including those not matched with items on IDEAS)

    Most related items

    These are the items that most often cite the same works as this one and are cited by the same works as this one.
    1. Andrey Pavlov & Eva Steiner & Susan Wachter, 2018. "The Consequences of REIT Index Membership for Return Patterns," Real Estate Economics, American Real Estate and Urban Economics Association, vol. 46(1), pages 210-250, March.
    2. Jack Corgel & Crocker Liu & Robert White, 2015. "Determinants of Hotel Property Prices," The Journal of Real Estate Finance and Economics, Springer, vol. 51(3), pages 415-439, October.
    3. Charles Ka Yui Leung & Edward Chi Ho Tang, 2015. "Speculating China Economic Growth through Hong Kong? Evidence from Stock Market IPOs and Real Estate Markets," International Real Estate Review, Global Social Science Institute, vol. 18(1), pages 45-87.
    4. James D. Shilling & C.F. Sirmans & Barrett A. Slade, 2017. "Spatial Correlation in Expected Returns in Commercial Real Estate Markets and the Role of Core Markets," The Journal of Real Estate Finance and Economics, Springer, vol. 54(3), pages 297-337, April.
    5. Basse, Tobias & Desmyter, Steven & Saft, Danilo & Wegener, Christoph, 2023. "Leading indicators for the US housing market: New empirical evidence and thoughts about implications for risk managers and ESG investors," International Review of Financial Analysis, Elsevier, vol. 89(C).
    6. Daisy J. Huang & Charles Ka Yui Leung & Chung-Yi Tse, 2018. "What Accounts for the Differences in Rent-Price Ratio and Turnover Rate? A Search-and-Matching Approach," The Journal of Real Estate Finance and Economics, Springer, vol. 57(3), pages 431-475, October.
    7. Massimo Guidolin & Manuela Pedio & Milena T. Petrova, 2023. "The Predictability of Real Estate Excess Returns: An Out-of-Sample Economic Value Analysis," The Journal of Real Estate Finance and Economics, Springer, vol. 67(1), pages 108-149, July.
    8. Shulin Shen & Yiyi Zhao & Jindong Pang, 2024. "Local Housing Market Sentiments and Returns: Evidence from China," The Journal of Real Estate Finance and Economics, Springer, vol. 68(3), pages 488-522, April.
    9. Prashant Das & Julia Freybote & Gianluca Marcato, 2015. "An Investigation into Sentiment-Induced Institutional Trading Behavior and Asset Pricing in the REIT Market," The Journal of Real Estate Finance and Economics, Springer, vol. 51(2), pages 160-189, August.
    10. Prashant Das & Alan Ziobrowski & N. Coulson, 2015. "Online Information Search, Market Fundamentals and Apartment Real Estate," The Journal of Real Estate Finance and Economics, Springer, vol. 51(4), pages 480-502, November.
    11. Jun Li & Xiaoli Liang, 2020. "Beyond the Cap Rate: Valuation of Multifamily Properties," The Journal of Real Estate Finance and Economics, Springer, vol. 60(1), pages 99-110, February.
    12. Zhou, Zhengyi, 2018. "Housing market sentiment and intervention effectiveness: Evidence from China," Emerging Markets Review, Elsevier, vol. 35(C), pages 91-110.
    13. Dimitris Anastasiou & Panayotis Kapopoulos & Kalliopi-Maria Zekente, 2023. "Sentimental Shocks and House Prices," The Journal of Real Estate Finance and Economics, Springer, vol. 67(4), pages 627-655, November.
    14. Devaney, Steven & Holtemöller, Oliver & Schulz, Rainer, 2012. "Efficiency in the UK Commercial Property Market: A Long-run Perspective," IWH Discussion Papers 15/2012, Halle Institute for Economic Research (IWH).
    15. Bogle, David & Coyle, Christopher & Turner, John D., 2020. "Capital Market Development Over the Long Run: The Portfolios of UK Life Assurers Over Two Centuries," QBS Working Paper Series 2020/11, Queen's University Belfast, Queen's Business School.
    16. David Ling & Gianluca Marcato & Pat McAllister, 2009. "Dynamics of Asset Prices and Transaction Activity in Illiquid Markets: the Case of Private Commercial Real Estate," The Journal of Real Estate Finance and Economics, Springer, vol. 39(3), pages 359-383, October.
    17. Abdullah Yavas & Yildiray Yildirim, 2011. "Price Discovery in Real Estate Markets: A Dynamic Analysis," The Journal of Real Estate Finance and Economics, Springer, vol. 42(1), pages 1-29, January.
    18. Booth, Philip & Walsh, Duncan, 2001. "An option pricing approach to valuing upward only rent review properties with multiple reviews," Insurance: Mathematics and Economics, Elsevier, vol. 28(2), pages 151-171, April.
    19. Marcel Arsenault & Jim Clayton & Liang Peng, 2013. "Mortgage Fund Flows, Capital Appreciation, and Real Estate Cycles," The Journal of Real Estate Finance and Economics, Springer, vol. 47(2), pages 243-265, August.
    20. Nai Jia Lee & Tien Foo Sing & Dinh Hoang Tran, 2013. "REIT Share Price and NAV Deviations: Noise or Sentiment?," International Real Estate Review, Global Social Science Institute, vol. 16(1), pages 28-47.

    More about this item

    Keywords

    scenario analysis; rental growth; freehold investment property; short-cut DCF; equivalent yield;
    All these keywords.

    JEL classification:

    • C53 - Mathematical and Quantitative Methods - - Econometric Modeling - - - Forecasting and Prediction Models; Simulation Methods
    • D46 - Microeconomics - - Market Structure, Pricing, and Design - - - Value Theory
    • R30 - Urban, Rural, Regional, Real Estate, and Transportation Economics - - Real Estate Markets, Spatial Production Analysis, and Firm Location - - - General

    Statistics

    Access and download statistics

    Corrections

    All material on this site has been provided by the respective publishers and authors. You can help correct errors and omissions. When requesting a correction, please mention this item's handle: RePEc:vrs:remava:v:29:y:2021:i:2:p:52-70:n:5. See general information about how to correct material in RePEc.

    If you have authored this item and are not yet registered with RePEc, we encourage you to do it here. This allows to link your profile to this item. It also allows you to accept potential citations to this item that we are uncertain about.

    If CitEc recognized a bibliographic reference but did not link an item in RePEc to it, you can help with this form .

    If you know of missing items citing this one, you can help us creating those links by adding the relevant references in the same way as above, for each refering item. If you are a registered author of this item, you may also want to check the "citations" tab in your RePEc Author Service profile, as there may be some citations waiting for confirmation.

    For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: Peter Golla (email available below). General contact details of provider: https://www.sciendo.com .

    Please note that corrections may take a couple of weeks to filter through the various RePEc services.

    IDEAS is a RePEc service. RePEc uses bibliographic data supplied by the respective publishers.