Rental Lease Renewal Rent Increase Calculator in Excel: Find the Raise That Keeps the Unit Full

A landlord in Tampa had a tenant paying $1,500 on a single-family rental. The market had moved, comparable units were listing at $1,650, and his property manager told him to "raise it to market" at renewal. He sent the notice for $1,650, a clean $150 jump. The tenant, who had paid on the first for three years and never filed a maintenance request, found a comparable place at $1,580 and gave notice. The unit sat empty for six weeks, the make-ready ran $2,400, the PM charged a full month to fill it, and the replacement tenant negotiated $1,600. He raised the rent $100 above where he started and netted less money for the year than if he had done nothing. A rental lease renewal rent increase calculator in Excel would have told him the $150 jump was a losing bet before he mailed it. This article builds that calculator and shows you how to read it.

The renewal increase is not a pricing decision. It is a probability bet. Every dollar you add to the rent raises the odds the tenant walks, and a tenant walking is one of the most expensive events in a small rental portfolio. The question is never "what is market rent." Market rent is a ceiling, not a target. The real question is which increase maximizes your expected cash flow once you weigh the gain from a higher rent against the cost of the turnover that higher rent might trigger. That is an expected value problem, and Excel solves it in about fifteen minutes.

Why "Raise to Market Every Year" Quietly Loses Money

The advice to push rent to market at every renewal treats the tenant as if they will pay anything. They will not. A good tenant has a switching cost, the hassle and expense of moving, and they will tolerate a below-market rent up to a point because staying is easier than leaving. Cross that point and they go. When they go, you do not just lose the rent difference, you eat the entire turnover stack: lost rent during vacancy, make-ready, leasing fees, screening, and the risk that the next tenant pays worse and stays shorter.

Run the numbers on the Tampa example. The $150 increase, if it had stuck, was worth $1,800 over the year. The turnover it caused cost roughly $4,000 all in, and the replacement tenant came in $50 under the target anyway. The expected value of that aggressive raise, once you account for how likely it was to trigger a move, was negative. A smaller increase that the tenant would have accepted, say $50 to $75, would have captured real money with almost no flight risk. The point is not to avoid raising rent. The point is to raise it to the number that survives the renewal, not the number on a comp sheet.

Build the Renewal Rent Increase Calculator in Excel

The model has two parts. An input block holds the four numbers that drive every renewal, and a scenario table runs several possible increases through the same expected value formula so you can see which one wins. Put the inputs in column B so they are visible and editable.

The Inputs That Drive It

The turnover cost in B4 is the full stack, not just lost rent. If you have not built a turnover number yet, use $3,000 to $4,500 for an average single-family rental and refine it later. B5 is how long the unit realistically sits if the tenant leaves, expressed in months, because a re-rent at market only earns for the months the unit is actually occupied.

The Expected Value Formula

Now the scenario table. Lay out a row for each increase you might propose, from zero up to a full market match. The columns walk from the proposed increase to the expected net annual value, measured against the baseline of renewing flat at the current rent.

Start with the new rent and your estimated probability the tenant leaves at that increase. The new rent is simple:

B9 =$B$2+A9

The probability in column C is the one number you supply by judgment, and the next section gives you a method for it. With those two in place, column D computes the expected gain if the tenant stays, which is the extra rent collected over twelve months weighted by the odds they accept:

D9 =(1-C9)A912

Column E captures what happens if they leave. This is the part every simple calculator skips. When a tenant leaves you pay the turnover cost, but you also re-rent at market, so the new tenant pays the market gap for the months they occupy. The expected value of leaving is the recaptured market gap minus the turnover cost, weighted by the odds they go:

E9 =C9(($B$3-$B$2)(12-$B$5)-$B$4)

Add the two outcomes and you have the expected net annual value of that increase compared to doing nothing:

F9 =D9+E9

Copy the row down for every increase you want to test. The winner is whichever row produces the highest F. Pull it out with one formula so you do not eyeball it:

B16 =INDEX(A9:A14,MATCH(MAX(F9:F14),F9:F14,0))

And the value that increase is worth over a flat renewal:

B17 =MAX(F9:F14)

Read the Table: The Optimal Increase Is Usually Below Market

Here is the scenario table filled out with the example inputs above. The probabilities reflect a solid tenant in a normal market, where small increases barely move the flight risk and large ones spike it.

Read the F column. The expected net peaks in a band between $50 and $75, at roughly $244. Push to a $100 increase and the expected value collapses to $54, because the one-in-three chance of turnover wipes out most of the rent gain. Go all the way to market at $150 and the expected value turns negative, minus $499, which means raising rent to the comp number is expected to lose you about $500 versus simply renewing flat. The aggressive raise looks great on paper and bleeds money in practice. That is the entire lesson, and it is invisible without the probability column.

Notice the $0 row is also slightly negative at minus $95. Even a flat renewal carries a small turnover risk, because tenants leave for reasons that have nothing to do with rent. This is why doing nothing is not free, and why a modest, well-targeted increase that the tenant accepts is the genuine optimum. The calculator does not tell you to avoid raising rent. It tells you to raise it to the number with the best risk-adjusted payoff, which in this case is half the market gap, not the full thing.

How to Estimate the One Number Everyone Fudges

The probability of leaving in column C decides the whole model, so estimate it with a method instead of a feeling. The strongest predictor is how the new rent sits relative to market. A tenant who is still paying under market after the increase has little reason to move, while a tenant pushed above market has every reason. Start from this table and adjust.

Then nudge the number for the things the gap alone does not capture. A tenant in year three or four has roots and a higher switching cost, so shave a few points off. A high local vacancy rate gives them options and easy comps, so add points. Winter renewals see less movement than summer ones, so a December lease end leans toward staying. If the tenant has already grumbled about price or mentioned a job change, raise the probability regardless of the math. You can encode the tenure adjustment directly so you do not forget it:

=MAX(0.02,C9-MIN(0.08,(TenureYears-1)*0.02))

That formula trims up to eight points off the base probability for a long-tenured tenant and never lets it fall below 2%, because no tenant is a guaranteed renewal. The goal is not a perfect number. The goal is a number you can defend, because even a rough probability beats the silent assumption of zero that aggressive renewal advice depends on.

When You Actually Want the Tenant to Leave

The model has a second use that flips the usual instinct. Look at the expected value of leaving in column E. It is negative in the example because the market gap, $150 a month, does not earn back the $4,000 turnover cost within the year. But widen the gap and the sign flips. If your current rent is $1,500 and market is genuinely $1,900, the recaptured gap is $400 times the occupied months, which can exceed the turnover cost. At that point turnover is net positive, and pushing the rent toward market is the correct move even though it raises flight risk. A single flag tells you which regime you are in:

=IF(($B$3-$B$2)*(12-$B$5)>$B$4,"Gap exceeds turnover cost: push toward market","Turnover costs more than the gap: protect the tenant")

When that flag says protect the tenant, a small increase or even a flat renewal is the disciplined choice, and you should be grateful for a payer who stays. When it says push toward market, you have been under-renting badly enough that the turnover is worth eating, and the renewal increase becomes a tool to reset the rent to where it should have been all along. Most renewals fall in the first camp, which is exactly why the blanket advice to raise to market every year costs landlords money.

Build It Once, Run It on Every Renewal

The renewal rent increase calculator turns a gut call into a fifteen-minute decision with a number behind it. Set the four inputs, fill the probability column with the guidance above, and read the increase that maximizes expected net value. In a normal market that number lands below market rent, often at half the gap, because turnover risk is real and expensive and the comp sheet ignores it entirely. Raise rent to that number, keep the good tenant, and pocket a gain that survives the renewal instead of evaporating in a six-week vacancy.

If you would rather not rebuild this model from scratch every leasing season, the SheetCraft Rental Property Analyzer has the renewal increase logic, the turnover cost stack, and the probability guidance wired together across your whole portfolio. Enter the current rent, your market comp, and a turnover estimate, and it returns the risk-adjusted increase for each unit, flags the tenants you should protect, and rolls the expected cash flow impact up to the portfolio level. It is the same math this article walks through, ready on every renewal so you price the raise that keeps the unit full and the cash flow climbing.