WOLFRAM|DEMONSTRATIONS PROJECT

The Price-Terms Tradeoff

​
price
2490000
cap rate
0.06
interest rate
0.06
LTV
0.65
value growth
0.03
sale costs
0.06
discount rate
0.06
sale year
10
​
prepayment
0
reset
growth regime & display
constant CR numeric
variable CR numeric
constant CR graphic
variable CR graphic
Variable
Value
Plus Increment
NPV Δ
Price
$ 2,490,000
$10,000.00
$ 2,066.01
Cap Rate
6.00%
00.25%
$ 51,784.55
Interest Rate
6.00%
00.50%
$ -56,337.62
LTV
65.00%
05.00%
$ 395.16
Growth Rate
3.00%
00.50%
$ 113,201.40
Holding Period
10 yr
1 yr
$ 56,575.75
Sale Cost
6.00%
00.50%
$ -9,342.93
Discount Rate
6.00%
00.50%
$ -56,329.43
Net Present Value
$514,436.63
Last Δ npv =
-3.26×
-9
10
Internal Rate of Return
11.832%
Prepayment 1 = 6 months interest on 80% of remaining balance Prepayment 2 = 5% yr 1; 4% yr 2, etc. declining to zero yr 6
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.