Calculator
Purchase Price Sensitivity
Tight purchase-price sweep with workbook-backed cashflow and ROI outputs.
Rental assumptions
Set the incoming rent that the price sweep will test against.
Finance and costs
These assumptions stay fixed while purchase price moves.
Sweep range
Define the purchase-price range and row count for the sensitivity table.
Sweep summary
Use this view to find the highest sensible purchase price under one rent assumption.
Sensitivity table
Server-rendered workbook parity with interest-only and principal-plus-interest views.
| Purchase price | Invested | IO cashflow | IO ROI | P&I cashflow | P&I ROI |
|---|---|---|---|---|---|
| $300,000 | $74,700 | $7,570.00 | 10.13% | $4,109.54 | 5.5% |
| $325,000 | $80,925 | $6,570.00 | 8.12% | $2,821.17 | 3.49% |
| $350,000 | $87,150 | $5,570.00 | 6.39% | $1,532.79 | 1.76% |
| $375,000 | $93,375 | $4,570.00 | 4.89% | $244.42 | 0.26% |
| $400,000 | $99,600 | $3,570.00 | 3.58% | -$1,043.95 | -1.05% |
| $425,000 | $105,825 | $2,570.00 | 2.43% | -$2,332.32 | -2.2% |
| $450,000 | $112,050 | $1,570.00 | 1.4% | -$3,620.69 | -3.23% |
| $475,000 | $118,275 | $570.00 | 0.48% | -$4,909.07 | -4.15% |
| $500,000 | $124,500 | -$430.00 | -0.35% | -$6,197.44 | -4.98% |
| $525,000 | $130,725 | -$1,430.00 | -1.09% | -$7,485.81 | -5.73% |
| $550,000 | $136,950 | -$2,430.00 | -1.77% | -$8,774.18 | -6.41% |
| $575,000 | $143,175 | -$3,430.00 | -2.4% | -$10,062.55 | -7.03% |
| $600,000 | $149,400 | -$4,430.00 | -2.97% | -$11,350.93 | -7.6% |
| $625,000 | $155,625 | -$5,430.00 | -3.49% | -$12,639.30 | -8.12% |
| $650,000 | $161,850 | -$6,430.00 | -3.97% | -$13,927.67 | -8.61% |
| $675,000 | $168,075 | -$7,430.00 | -4.42% | -$15,216.04 | -9.05% |
| $700,000 | $174,300 | -$8,430.00 | -4.84% | -$16,504.41 | -9.47% |
| $725,000 | $180,525 | -$9,430.00 | -5.22% | -$17,792.78 | -9.86% |
| $750,000 | $186,750 | -$10,430.00 | -5.59% | -$19,081.16 | -10.22% |
| $775,000 | $192,975 | -$11,430.00 | -5.92% | -$20,369.53 | -10.56% |
| $800,000 | $199,200 | -$12,430.00 | -6.24% | -$21,657.90 | -10.87% |
| $825,000 | $205,425 | -$13,430.00 | -6.54% | -$22,946.27 | -11.17% |
| $850,000 | $211,650 | -$14,430.00 | -6.82% | -$24,234.64 | -11.45% |
| $875,000 | $217,875 | -$15,430.00 | -7.08% | -$25,523.02 | -11.71% |
| $900,000 | $224,100 | -$16,430.00 | -7.33% | -$26,811.39 | -11.96% |
| $925,000 | $230,325 | -$17,430.00 | -7.57% | -$28,099.76 | -12.2% |
| $950,000 | $236,550 | -$18,430.00 | -7.79% | -$29,388.13 | -12.42% |
| $975,000 | $242,775 | -$19,430.00 | -8% | -$30,676.50 | -12.64% |
| $1,000,000 | $249,000 | -$20,430.00 | -8.2% | -$31,964.88 | -12.84% |