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

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.

Digital Technologies as a Driver of Capitalization Growth in Shopping and Entertainment Centers

“…30, no.2, 2022 implementation of digital technology in a shopping and entertainment center. The use of a cost approach for assessing efficiency is justified and informative when it comes to real estate (Ataguba, 2021;Florêncio & de Alencar, 2020). This study sees digital technologies that affect the revenue side of the budget of a property and do not affect its operation costs.…”