Rent Increase Calculator
Model the trade-off between higher rent and tenant turnover risk. Find your break-even probability and make the decision with numbers instead of guesswork.
Every rent increase is a bet: you gain more revenue if the tenant stays, and absorb vacancy and turnover costs if they leave. Most landlords make this call on instinct. This calculator makes the math explicit — showing you exactly what probability of tenant departure makes the increase worthwhile, and what the expected outcome is at your own estimate of that risk.
What you enter
What you get
- Monthly and annual gain if the tenant stays at the new rent
- Full cost of turnover — vacancy months plus one-time costs — if they leave
- Break-even probability — the exact threshold below which the increase pays off
- Expected net annual value at your estimated probability
- Plain-language recommendation based on your inputs
- Sensitivity table showing expected outcomes from 5% to 90% probability, color-coded green (favorable) and red (use caution)
What's included
- Rent Increase Calculator Excel workbook (.xlsx)
- Calculator tab with inputs, results, and recommendation
- Sensitivity tab with full probability table and conditional formatting
- Lifetime minor updates included
- Immediate download after purchase
FAQ
What's the "probability tenant leaves" input?
Your estimate of the likelihood the tenant won't accept the new rent and moves out. You know your tenant — a long-term tenant in a tight market is low risk; a newer tenant in a soft market is higher risk. The Sensitivity tab shows you the outcome at every probability so you can see how sensitive the decision is to that estimate.
What counts as turnover cost?
Cleaning, touch-up repairs, advertising, any leasing fee — the costs you'd incur between tenants. These vary widely by market and property condition. Enter a realistic estimate; the model is most useful when the inputs are honest.
What does the break-even probability mean?
If your estimated probability of the tenant leaving is below the break-even, the expected annual value of the increase is positive — meaning the increase is mathematically favorable. If your estimate is above break-even, the expected outcome is negative. It tells you how much risk the increase can absorb and still be worth it.
Is this a subscription?
No. One-time purchase, lifetime minor updates included.