Calculator
Interest Rate Sweep
Stress-test the deal against rising or falling borrowing costs.
Property
Base property and rent assumptions held constant while interest rates move.
Equity and costs
Debt settings and operating costs used in each scenario.
Sweep range
Choose the starting rate, increment, and row count to test.
Sweep summary
Use this view to understand how sensitive the deal is to changes in borrowing cost.
Sensitivity table
Fixed rent and property assumptions with interest-only and principal-plus-interest views.
| Interest rate | Expenses | IO cashflow | IO ROI | P&I cashflow | P&I ROI |
|---|---|---|---|---|---|
| 3.50% | -$6,430.00 | $1,090.00 | 0.66% | -$8,881.47 | -5.40% |
| 3.75% | -$6,430.00 | -$230.00 | -0.14% | -$9,773.00 | -5.95% |
| 4.00% | -$6,430.00 | -$1,550.00 | -0.94% | -$10,679.03 | -6.50% |
| 4.25% | -$6,430.00 | -$2,870.00 | -1.75% | -$11,599.31 | -7.06% |
| 4.50% | -$6,430.00 | -$4,190.00 | -2.55% | -$12,533.58 | -7.63% |
| 4.75% | -$6,430.00 | -$5,510.00 | -3.35% | -$13,481.58 | -8.20% |
| 5.00% | -$6,430.00 | -$6,830.00 | -4.16% | -$14,443.02 | -8.79% |
| 5.25% | -$6,430.00 | -$8,150.00 | -4.96% | -$15,417.63 | -9.38% |
| 5.50% | -$6,430.00 | -$9,470.00 | -5.76% | -$16,405.11 | -9.98% |
| 5.75% | -$6,430.00 | -$10,790.00 | -6.57% | -$17,405.18 | -10.59% |
| 6.00% | -$6,430.00 | -$12,110.00 | -7.37% | -$18,417.52 | -11.21% |
| 6.25% | -$6,430.00 | -$13,430.00 | -8.17% | -$19,441.84 | -11.83% |
| 6.50% | -$6,430.00 | -$14,750.00 | -8.98% | -$20,477.83 | -12.46% |
| 6.75% | -$6,430.00 | -$16,070.00 | -9.78% | -$21,525.18 | -13.10% |
| 7.00% | -$6,430.00 | -$17,390.00 | -10.58% | -$22,583.57 | -13.74% |