Sensitivity Analysis
Economic Surface
Real Net Cost (Negative is Surplus)
SURPLUS
-$465,983
Break-Even Horizon
T* (YEARS)
7.0yrs
Variable Impact
Sensitivity plot vs Net Cost
→
→
Surplus (Best)Break EvenHigh Cost (Worst)
-$755,131$0$49,694
r
T
10.0%7.5%5.0%2.5%0.0%
18162330
Real Net Cost Equation
Continuous Time ModelCn=(Pϕ+Λ)+∫0T[(1−e−rTPr+(τ+ι+κ)eit+(V0−P)rm)−(erT−1Prert+V0aeat+R0egt+θ(1−e−rTPr−erT−1Prert+τeit))]e−itdt+V0e(a−i)T(α+β+γ)
Term 1Upfront Capital
Term 2Integrative Cashflow
Term 3Opportunity Cost
Term 4Terminal Friction
Variable Definitions
| Variable | Definition | Economic Role |
|---|---|---|
| Cn | Real Net Cost | Total wealth change (Negative = Profit; Positive = Loss). |
| P | Loan Principal | The total amount of debt taken (impacts interest cost and equity speed). |
| V0 | Initial Value | The purchase price of the home at $t=0$, which yields the down payment ($V_0 - P$). |
| R0 | Initial Rent | Annualized market rent at the time of purchase. |
| r | Interest Rate | The continuous mortgage interest rate (the cost of debt). |
| a | Appreciation Rate | The continuous annual growth rate of the home's market value. |
| g | Rent Growth Rate | The continuous annual growth rate of market rental prices. |
| i | Inflation Rate | The continuous discount rate (CPI) used to bring future dollars to PV. |
| T | Time Horizon | The number of years the home is held. |
| τ | Property Taxes | Annualized nominal cost of property taxes. |
| ι | Insurance | Annualized nominal cost of homeowners insurance. |
| κ | Maintenance | Annualized nominal repair and upkeep costs. |
| ϕ | Origination % | Points/fees expressed as a decimal of the loan amount. |
| Λ | Fixed Closing Fees | One-time fees for items such as appraisal, title, and escrow. |
| α,β,γ | Selling Frictions | Percentages for agent commission, transfer taxes, and concessions. |
| rm | Market Return Rate | The continuous benchmark return rate for forgone equity. |
| θ | Marginal Tax Rate | Tax rate applied to combined deductible interest and property taxes. |