Landlord Lease Break Fee Calculator Excel | SheetCraft

Your tenant calls on November 1. Job transfer, out by December 31, five months left on a lease at $1,850 a month. The lease says they owe you $9,250. A landlord lease break fee calculator in Excel built on that number is the wrong tool. In Texas and New York the statute makes you try to re-rent the unit, and the tenant owes you the gap, not the balance. In California the tenant can subtract any rental loss they prove you could have avoided. In Florida you can choose to stand by and bill the rent as it comes due, but you are then collecting $9,250 from someone who already lives in another city.

The question that decides your early termination fee is different: what does this departure cost you, in this month, in this market? On the example unit below, the answer runs from $1,894.79 for a May move-out to $4,304.80 for a December one. The five months left on the lease barely move it. The calendar does.

Every figure in this article comes from one example unit: $1,850 rent, $650 of make-ready, $150 of marketing, a $1,850 deposit and 60 days of notice. Swap in your own numbers; the structure is what you keep.

What a broken lease costs once you have to re-let

When the tenant leaves and you re-rent in good faith, the cost of a tenant breaking a lease has three parts, and only three:

Rent lost while the unit sits empty. Vacancy days times the daily rent, capped at the days left on the lease. If the lease had three weeks to run, you cannot lose eight weeks of rent on it.
Re-letting cost. Cleaning, paint touch-up, listing, showings. On the example unit, $650 of make-ready and $150 of marketing. A property manager charging half a month to place a tenant would make that second line $925.
Rent shortfall. If the replacement signs at $1,800 instead of $1,850, the old tenant owes the $50 difference for the rest of the original term only.

In the spreadsheet, put the inputs in column B: rent in B2, months left in B3, make-ready in B4, marketing in B5, deposit in B6. Then for any move-out month, with expected vacancy days in B13 and the monthly concession in C13:

Rent lost: =ROUND(MIN(B13,$B$3*365/12)*$B$2*12/365,2)

The MIN is the cap. It stops the sheet from billing more vacant days than the lease had left. $B$2*12/365 is the daily rent, $60.82 on $1,850.

Shortfall: =ROUND(C13*MAX(0,$B$3-B13*12/365),2)

This charges the concession only for the months between the new move-in and the end of the old lease. The MAX(0,...) returns zero when the vacancy outlasts the lease.

Total cost of the departure: =D13+$B$4+$B$5+E13

Run it for the November call and for a tenant who gives the same notice in February and leaves April 30:

Line	Leaves April 30	Leaves December 31
Vacancy before the next tenant moves in	20 days	55 days
Rent lost	$1,216.44	$3,345.21
Make-ready and marketing	$800.00	$800.00
Shortfall ($50 a month winter concession)	$0.00	$159.59
Total cost of the departure	$2,016.44	$4,304.80
What the lease says they owe	$9,250.00	$9,250.00

The December tenant leaves on January 1 with 55 empty days ahead, so the replacement moves in February 25 and the $50 concession runs for 3.19 months until the old lease would have ended on May 31. That is where $159.59 comes from.

Now hold the month and change the months left. A December departure with 3 months left costs $4,204.80. With 5 months left, $4,304.80. With 8 months left, $4,454.80. Five extra months on the lease add $250, and only because of the concession. An April departure costs $2,016.44 whether 3, 5 or 8 months remain, because the unit is re-let well inside all three. The number every landlord starts from, "five months left," is the input that matters least. Months left only bite at the very end: with one month left, the December case drops to $2,650.00 because the cap stops the rent loss at $1,850.00.

Two months' rent is generous in April and short in December

Most fee clauses use a round number, and two months' rent is the common one. On the example unit that is $3,700. Put the twelve possible move-out months in rows 13 to 24, fill column B from your own vacancy log (the days below are an example of a market with a slow winter), and compare.

Move-out month	Vacancy days	Concession / mo	Rent lost	Shortfall	Total cost	$3,700 fee minus cost
January	45	$50	$2,736.99	$176.03	$3,713.02	-$13.02
February	40	$50	$2,432.88	$184.25	$3,417.13	$282.87
March	28	$0	$1,703.01	$0.00	$2,503.01	$1,196.99
April	20	$0	$1,216.44	$0.00	$2,016.44	$1,683.56
May	18	$0	$1,094.79	$0.00	$1,894.79	$1,805.21
June	18	$0	$1,094.79	$0.00	$1,894.79	$1,805.21
July	20	$0	$1,216.44	$0.00	$2,016.44	$1,683.56
August	25	$0	$1,520.55	$0.00	$2,320.55	$1,379.45
September	32	$0	$1,946.30	$0.00	$2,746.30	$953.70
October	40	$0	$2,432.88	$0.00	$3,232.88	$467.12
November	50	$50	$3,041.10	$167.81	$4,008.91	-$308.91
December	55	$50	$3,345.21	$159.59	$4,304.80	-$604.80

The average of column F is $2,839.09: =AVERAGE(F13:F24). A flat $3,700 fee covers that average by $860.91 and falls short in three months out of twelve. The spread between the cheapest month and the most expensive one is $2,410.01, which is larger than the fee's margin over the average. A single number cannot price twelve different costs, so the real choice is which months you are willing to under-recover.

Add the flag in column G so the sheet tells you which side of the line each month falls on: =IF(F13>$B$7,"Fee short","Fee covers"), with the fee in B7 as =2*B2.

Your vacancy log is the input that decides this table. If you have not measured days from move-out to the next move-in by month, the vacancy rate calculator shows how to pull them from your rent roll, and the turnover cost calculator replaces the $650 and $150 with your real make-ready invoices.

What Florida, California, Texas, New York and federal law let you charge

The fee is a contract clause, and four state statutes and one federal one decide whether it survives. Here is what each text says:

Rule	What the statute says	What it does to your fee
Florida, Fla. Stat. §83.595	Four remedies when the tenant leaves early. Remedy (4) allows liquidated damages or an early termination fee if it does not exceed 2 months' rent, the tenant is required to give no more than 60 days' notice, and the tenant signs a separate addendum. The landlord also gets rent through the end of the month the landlord retakes possession, plus damage to the unit, and waives rent beyond that month.	Cap of $3,700 on $1,850 rent. The addendum text is prescribed in substance by the statute, with a box for "I do not agree."
California, Civ. Code §1671(c) and (d)	A liquidated damages clause in a residential lease (a lease of a dwelling) is void unless it would be "impracticable or extremely difficult to fix the actual damage."	A flat break fee is the clause most likely to be thrown out. Bill actual damages instead.
California, Civ. Code §1951.2	After abandonment the landlord recovers unpaid rent minus the rental loss "that the lessee proves could have been reasonably avoided," plus any other amount necessary to compensate for the detriment caused.	The tenant carries the burden of proving you could have re-let faster. Your marketing log is your defense.
Texas, Prop. Code §91.006	The landlord has a duty to mitigate damages if the tenant abandons the premises. A lease provision that purports to waive that duty is void.	No clause can turn "five months left" back into $9,250. The re-letting math above is what a Texas court measures.
New York, Real Property Law §227-e	The landlord must take reasonable and customary actions, in good faith, to re-rent at fair market value or the rate agreed in the lease, whichever is lower. The party seeking damages bears the burden of proof. A waiver of the duty is unenforceable.	You prove your vacancy days, and you cannot hold the unit empty for a higher rent and bill the wait.
Federal, 50 U.S.C. §3955 (SCRA)	A servicemember who signed before entering service, or who receives permanent change of station orders or orders to deploy for at least 90 days, may terminate. "The lessor may not impose an early termination charge."	The fee is $0. On a monthly lease, termination takes effect 30 days after the next rent due date following the notice.

Two lines in the calculator handle the cases where the statute sets the answer. The Florida cap check: =IF(B7>2*B2,"Over the Florida cap","OK"). The SCRA flag in B8 zeroes the fee, and for a notice date in B11 with rent due on the 1st, the effective termination date is =EOMONTH(B11,0)+1+30. A notice delivered March 10 makes the next rent due April 1 and the termination effective May 1, so the servicemember pays through April 30 and nothing more.

Florida's remedy (4) has a consequence most landlords miss. Signing the addendum means you waive the right to seek rent beyond the month you retake possession. In December, on the example unit, that waiver costs you $604.80 against actual damages.

A fee you collect beats damages you have to chase

The table above compares the fee to the cost as if you always collected your damages in full. You do not. With actual damages, you apply the $1,850 deposit and then chase the balance through a demand letter, small claims, or a collection agency. The fee is one number the tenant agreed to in writing before moving in, and a clause can make it payable with the notice, before the keys come back. Have your attorney check that wording against your state's statute before you use it.

So the comparison that decides the clause is the fee against the deposit plus the share of the remaining damages you actually recover. The damages route beats the fee only above the collection rate this formula returns:

=IF(F13<=$B$7,"Fee wins",($B$7-$B$6)/(F13-$B$6))

At that rate the two routes tie. For December, ($3,700 - $1,850) / ($4,304.80 - $1,850) = 75.4 percent. Unless you collect three quarters of every dollar past the deposit, the fee pays more even in the month when it is "short." For January the tie is at 99.3 percent. For November, 85.7 percent.

December move-out, share of the balance collected	Damages route: deposit plus collections	Fee route
25 percent	$2,463.70	$3,700.00
50 percent	$3,077.40	$3,700.00
75 percent	$3,691.10	$3,700.00
100 percent	$4,304.80	$3,700.00

Take the collection rate from your own history of move-out balances: what you billed after the deposit, what came in within twelve months. If you track delinquent balances by age, the tenant delinquency aging report already holds it. If your history includes judgments you never collected, the eviction cost calculator shows what the court route costs before the first dollar arrives.

The cost no tenant pays: a replacement lease that ends in February

There is one cost of a winter break that no statute lets you bill, and you control it entirely. The December tenant leaves January 1, the replacement moves in February 25, and you hand them your standard 12-month lease. That lease ends February 24 of the next year, in the second-slowest month on your vacancy table. The break has moved your turnover into winter for good.

Set the replacement lease to end in your fastest month instead. With the start date in B27:

12-month end: =EDATE(B27,12)-1 returns February 24.
17-month end: =EDATE(B27,17)-1 returns July 24.
Expected vacancy at each end: =INDEX($B$13:$B$24,MONTH(C27)), which reads 40 days for February and 20 days for July from the season table.

The value of the longer term is the vacancy difference times the daily rent, weighted by the chance the tenant does not renew. With your renewal rate in B9 (50 percent in the example):

=(1-$B$9)*(INDEX($B$13:$B$24,MONTH(C27))-INDEX($B$13:$B$24,MONTH(D27)))*$B$2*12/365

On the example unit that is (1 - 0.5) × (40 - 20) × $60.82 = $608.22 of expected vacancy saved at the next turnover, which by itself cancels the $604.80 the Florida fee left on the table in December.

Laying out the lease break fee calculator in Excel

One sheet, three blocks. Keep the inputs at the top so every formula points at the same cells:

Cell	Input or result	Example
B2	Monthly rent	$1,850
B3	Months left on the lease	5
B4	Make-ready (cleaning, paint touch-up)	$650
B5	Marketing and leasing	$150
B6	Security deposit	$1,850
B7	Flat break fee, `=2*B2`	$3,700
B8	Tenant covered by the SCRA (Y/N)	N
B9	Renewal rate from your history	50 percent
B10	Florida cap check	OK
B11	Notice date	11/1
A13:H24	Season table: month, vacancy days, concession, rent lost, shortfall, total, fee gap, tie collection rate	See above
B27:F27	Replacement lease: start, 12-month end, 17-month end, vacancy saved	$608.22

Two rules keep it honest. First, the fee in B7 is one number for the whole year, so the season table has to show its worst month next to its average. Second, the fee you collect is non-recurring income. Book it on its own line, the way the other income tracker separates lease break fees from contractual rent, or a lender reading your T12 will haircut the whole other income line. The deposit itself stays in its own ledger; the security deposit tracker covers the return deadlines that still apply when a tenant leaves early.

Which clause to write in each state

On the example unit, the decision falls out of three numbers you now have: the average cost of a departure ($2,839.09), the worst month ($4,304.80 in December), and the collection rate at which damages tie with the fee (75.4 percent in December).

In Florida: offer the remedy (4) addendum, a lease buyout clause at the 2-month cap of $3,700, with the fee due with the notice. It covers the average by $860.91, it loses to actual damages only in three winter months, and in those months only if you collect more than 75.4 to 99.3 percent of a balance from someone who has moved away.
In California: do not rely on a flat fee. §1671(d) makes it void unless the actual damage is impracticable to fix, and a sheet that computes the actual damage month by month undercuts any argument that it is. Bill actual damages under §1951.2 from the season table, and keep the dated marketing log that answers the tenant's claim that you could have re-let faster.
In Texas and New York: price the clause from the season table and keep it close to the cost, because no clause can waive the duty to re-let, and in New York you carry the burden of proving every vacancy day.
Everywhere: set the SCRA flag before you quote any fee, and sign every winter replacement to a lease that ends in your fastest month. On the example unit that second step is worth $608.22 per turnover.

Then feed the result back into the deal. The season table gives you a measured cost per departure; multiply it by your break rate and it belongs in the vacancy and turnover lines of every rental you underwrite. The Rental Property Analyzer carries those lines in its operating expense analysis, next to management, maintenance reserve and insurance, and runs them through monthly cash flow, cash-on-cash return and a 10-year projection. It does not hold a season table or price a break fee; you build that sheet once from this article, and the Analyzer tells you what the number does to the return on each property you compare.