<abstract xmlns="http://www.w3.org/1999/xhtml">

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.
</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.

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

Department of Estate Management and Valuation

Real Estate Management and Valuation

This work is licensed under the Creative Commons Attribution 4.0 International License.

While the use of simple deterministic models to calculate rental value growth (RVGrowth) rate of reversionary freeholds across epochs prior to upward rent...

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

Published Online: Jun 22, 2021

Page range: 52 - 70

DOI: https://doi.org/10.2478/remav-2021-0013

Keywords
scenario analysis, rental growth, freehold investment property, short-cut DCF, equivalent yield

© 2021 Joseph Obaje Ataguba, published by Sciendo

This work is licensed under the Creative Commons Attribution 4.0 International License.

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

Published Online: Jun 22, 2021

Page range: 52 - 70

DOI: https://doi.org/10.2478/remav-2021-0013

Keywordsscenario analysis, rental growth, freehold investment property, short-cut DCF, equivalent yield

© 2021 Joseph Obaje Ataguba, published by Sciendo

This work is licensed under the Creative Commons Attribution 4.0 International License.

Keywords
scenario analysis, rental growth, freehold investment property, short-cut DCF, equivalent yield