9860

The Price-Terms Tradeoff

It is widely accepted that commodities have two prices: a cash price and a different price if payment is deferred to some later time. Delayed payment for a real estate investment acquisition can involve many individual terms, such as loan-to-value ratio (LTV), interest rate, and term. Woven into this are assumptions the investor must make about the future, such as growth rate and discount rate. This Demonstration shows the most common variables and produces a net present value for each set. The third column provides an increment of positive change in that variable. The last output (right column) in the grid is the net present value (NPV) of the change in that variable after an up increment. Thus, the user desiring to know how much price difference a particular relaxation of terms may be worth can make that change and see the net present value difference, all else remaining constant. In the lower-right cell the change from the last NPV is shown.
The interplay of all the variables can, under the right set of conditions, have a canceling effect. The increase in one variable can be offset by a decrease (or increase) in another variable, which is the point of the price-terms tradeoff. Having in mind a value for each change can improve decision making.
  • Contributed by: Roger J. Brown
  • Reproduced by permission of Academic Press from Private Real Estate Investment ©2005

SNAPSHOTS

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

DETAILS

Notice what appears to be an anomaly: when price increases, NPV also increases. This, however counterintuitive, is the result of an assumption that capitalization rate is constant over the holding period (the "Constant CR" option). For this to be possible, growth must occur on both income and value at the same rate. The alternate assumption, that different growth rates apply to value and income, produces capitalization rates that vary over time ("Variable CR" option) and results in NPV change depending on the relative direction and magnitudes of the different growth rates.
This Demonstration shows the value, in terms of NPV, of incremental changes in negotiated variables. Following that purpose, one can use the sliders to learn about scale and direction. For instance, the default values show that a 5% change in LTV produces a trivial difference in NPV, while a change of one-tenth of that amount on the projected growth rate has a very substantial effect. Not surprisingly, the direction of NPV change is the opposite for interest rate and cap rate. It may be more helpful to know that, at the default values, a change of capitalization rate of roughly half the change in interest rate is nearly offsetting.
There are some comforting results to be found. Here are three examples: First, when the computed internal rate of return is less than the pre-specified discount rate, the net present value is, as expected, negative. Second, setting the income growth lower than the value growth over time and a high initial capitalization rate (which is the point value of the ratio of income to value at the time of purchase) produces, as expected, high net present values. This is the mathematical representation of the investment strategy that always works: buy low and sell high. Third, one can model the opposite, choose either graphic view and move the initial discount rate to the right to show the disastrous results arising from owning during a time when rates are moving in the wrong direction.
There is also a comment to be made about linearity. While some forms of NPV may be linear, in general NPV is not linear in each variable. Thus, note that moving the slider for capitalization rate reflects a constant NPV change for each increment of capitalization rate change. Also note that three other variables—interest rate, LTV, and sale cost—have constant change values at all levels of capitalization rate within the range of this Demonstration.
More information is available in Chapter Four 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.

PERMANENT CITATION

Contributed by: Roger J. Brown
Reproduced by permission of Academic Press from Private Real Estate Investment ©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.









 
RELATED RESOURCES
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 © 2014 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+