The Effect of Holding Period on Real Estate Investment Return

A critical variable in investment return that is rarely modeled is the length of the holding period. While this is generally true of all investments with uncertain returns over time, in a real estate setting there is an important relationship between profitability and the change in both the discount and capitalization rates over the holding period. The model here employs an oscillating business cycle with upward drift, something common to capitalistic economies with a positive interest rate. The table shows the internal rate of return (IRR) for different holding periods during the cycle(s). Exiting at points where the plot is above the plane represents positive net present values. Cycle phase can be manipulated for different cycle extremes. An arbitrary initial cash flow of $5,000 is used as a starting point. This does not affect the shape of the plot ($1 could be used), serving only to make realistic the NPVs shown on its axis.
  • Contributed by: Roger J. Brown
  • Reproduced by permission of Academic Press from Private Real Estate Investment ©2005



  • [Snapshot]
  • [Snapshot]
  • [Snapshot]


This is an illustration of the oft-repeated phrase, "Timing is everything". The ideal direction of capitalization rate movement during a holding period is down because of the inverse relationship between capitalization rate and value. The zero plane, where NPV = 0, is set by choosing the discount rate on the axis as the hurdle rate in the NPV calculation. Internal rates of return higher than that chosen rate produce positive net present values where the plot is above the plane; the opposite is true for IRRs less than the hurdle rate where the plot appears beneath the surface of the plane (hence the vernacular "under water"). Very dramatic outcomes appear (in both directions) when going-in and going-out cap rates are at their opposite extremes. One of these extremes represents the end of a "bubble" and portends disaster for the greater fools who were the last to board the bus.
More information is available in Chapter Three of Private Real Estate Investment and at mathestate.com.
R. J. Brown, Private Real Estate Investment: Data Analysis and Decision Making, Burlington, MA: Elsevier Academic Press, 2005.
    • Share:

Embed Interactive Demonstration New!

Just copy and paste this snippet of JavaScript code into your website or blog to put the live Demonstration on your site. More details »

Files require Wolfram CDF Player or Mathematica.

Mathematica »
The #1 tool for creating Demonstrations
and anything technical.
Wolfram|Alpha »
Explore anything with the first
computational knowledge engine.
MathWorld »
The web's most extensive
mathematics resource.
Course Assistant Apps »
An app for every course—
right in the palm of your hand.
Wolfram Blog »
Read our views on math,
science, and technology.
Computable Document Format »
The format that makes Demonstrations
(and any information) easy to share and
interact with.
STEM Initiative »
Programs & resources for
educators, schools & students.
Computerbasedmath.org »
Join the initiative for modernizing
math education.
Step-by-Step Solutions »
Walk through homework problems one step at a time, with hints to help along the way.
Wolfram Problem Generator »
Unlimited random practice problems and answers with built-in step-by-step solutions. Practice online or make a printable study sheet.
Wolfram Language »
Knowledge-based programming for everyone.
Powered by Wolfram Mathematica © 2018 Wolfram Demonstrations Project & Contributors  |  Terms of Use  |  Privacy Policy  |  RSS Give us your feedback
Note: To run this Demonstration you need Mathematica 7+ or the free Mathematica Player 7EX
Download or upgrade to Mathematica Player 7EX
I already have Mathematica Player or Mathematica 7+