Short answer
Net effective rent is the total rent over the lease minus all concessions, divided by the months in the lease: (monthly rent x term - concessions) / term. A $2,600 apartment on a 13-month lease with one month free costs $2,400.00 a month on average, $200.00 below the asking rent, a 7.69% effective discount.
- Net effective rent = (monthly rent x lease term - concessions) / lease term. Divide by the full term, not by 12.
- $2,600 with 1 month free on 13 months is $2,400.00; with 6 weeks free on 12 months it is $2,275.00.
- You still pay the gross rent in paid months; the net effective figure is an average.
- If a renewal uses the gross rent, $2,400.00 becomes $2,600: 8.33% more before any increase.
- A free month and an equal rent cut collect the same in the first term; they differ at renewal.
On this page
- How to calculate net effective rent: the formula
- Net effective rent calculator: free months and one-off concessions
- 13-month lease with one month free: worked example
- How to calculate 6 weeks free rent, a gift card or a waived fee
- Net effective rent table: common free-month offers compared
- Gross rent vs net effective rent: what a tenant actually pays
- Free month or lower rent? The landlord's arithmetic
- Commercial leases: net effective rent per square foot, and the discounted version
- Net effective rent calculator in Excel and Google Sheets
- Calculator, your own sheet, or a deal analyzer: which to use
- Step-by-step
- FAQ
How to calculate net effective rent: the formula
Net effective rent = (monthly rent x lease term - concessions) / lease term. Add up every month of rent the lease states, subtract the free months and any one-off credits, then spread what is left evenly over every month of the lease, including the free ones.
Take a $2,600 apartment on a 13-month lease with one month free. Rent over the term is $33,800.00. The concession is worth $2,600.00. That leaves $31,200.00, and $31,200.00 / 13 = $2,400.00 a month.
Two terms get mixed up. Gross rent (also called asking or face rent) is the monthly figure written in the lease: $2,600. Net effective rent is the average after concessions: $2,400.00. A New York City Comptroller report on retail leases describes net effective rent as "rent net of concessions, givebacks, free month's rent, etc.", which is the same idea in one line.
I build pricing arithmetic; I do not let or manage property. The $2,600 rent, the lease terms and every concession below are assumptions to replace with the figures on your own listing or lease. Nothing here is legal advice.
Net effective rent calculator: free months and one-off concessions
Enter the monthly asking rent, the lease term in months, the number of free months and any one-off concession in dollars. The calculator returns the net effective rent a month, with the gap to the asking rent and the effective discount underneath.
The defaults are the example above: $2,600 rent, 13 months, 1 month free, no other concession, giving $2,400.00. Free months can be fractional, so type 1.5 for six weeks. The calculator is the straight-line version: it treats a dollar saved in month 1 the same as a dollar saved in month 13. The discounted version is covered further down.
13-month lease with one month free: worked example
One month free on a 13-month lease at $2,600 is a net effective rent of $2,400.00, which is $200.00 a month, or 7.69%, below the asking rent. You pay rent in 12 months out of 13.
Worked example: 13-month lease, 1 month free, $2,600 asking rent (assumptions)
| Item | Value |
|---|---|
| Lease term (months) (input) | 13 |
| Free months (input) | 1 |
| Other one-off concessions (input) | $0.00 |
| Monthly rent (input) | $2,600.00 |
| Rent over the term before concessions | $33,800.00 |
| Value of the concessions | $2,600.00 |
| Rent actually paid over the term | $31,200.00 |
| Months of rent paid | 12 |
| Net effective rent a month | $2,400.00 |
| Gap between asking rent and net effective rent | $200.00 |
| Effective discount | 7.69% |
| Net effective rent a year | $28,800.00 |
Computed with the same formulas as the free calculators on this site. Change any input in the calculator above to see your own numbers.
Note the discount is 7.69%, not the 8.33% that "one month in twelve" suggests. The free month is one in thirteen. The same free month on a 12-month lease gives $2,383.33 and 8.33%. Always divide by the full term on the lease, not by 12.
How to calculate 6 weeks free rent, a gift card or a waived fee
Convert the offer to months of rent or to dollars, then use the same formula. Six weeks free is about 1.5 months, so on a 12-month lease at $2,600 the concession is worth $3,900 and the net effective rent is $2,275.00.
Worked example: 12-month lease, 6 weeks free entered as 1.5 months, $2,600 asking rent (assumptions)
| Item | Value |
|---|---|
| Lease term (months) (input) | 12 |
| Free months (input) | 1.5 |
| Other one-off concessions (input) | $0.00 |
| Monthly rent (input) | $2,600.00 |
| Rent over the term before concessions | $31,200.00 |
| Value of the concessions | $3,900.00 |
| Rent actually paid over the term | $27,300.00 |
| Months of rent paid | 10.5 |
| Net effective rent a month | $2,275.00 |
| Gap between asking rent and net effective rent | $325.00 |
| Effective discount | 12.5% |
| Net effective rent a year | $27,300.00 |
Computed with the same formulas as the free calculators on this site. Change any input in the calculator above to see your own numbers.
That is $325.00 a month below asking, an effective discount of 12.5%. Six weeks is 42 days, so 1.5 months is an approximation. If the lease states the free period in days, value it with the lease's day-count method (see the prorated rent calculator guide) and enter that amount as a one-off concession instead.
Gift cards, waived fees and other one-off concessions
A one-off concession is entered in dollars. Assume a $300 gift card plus a $200 waived fee on a 12-month lease at $2,600: $500 in total, and no free months.
Worked example: 12-month lease, $300 gift card plus $200 waived fee, no free months, $2,600 asking rent (assumptions)
| Item | Value |
|---|---|
| Lease term (months) (input) | 12 |
| Free months (input) | 0 |
| Other one-off concessions (input) | $500.00 |
| Monthly rent (input) | $2,600.00 |
| Rent over the term before concessions | $31,200.00 |
| Value of the concessions | $500.00 |
| Rent actually paid over the term | $30,700.00 |
| Months of rent paid | 12 |
| Net effective rent a month | $2,558.33 |
| Gap between asking rent and net effective rent | $41.67 |
| Effective discount | 1.6% |
| Net effective rent a year | $30,700.00 |
Computed with the same formulas as the free calculators on this site. Change any input in the calculator above to see your own numbers.
The net effective rent is $2,558.33, only $41.67 a month below asking (1.6%). Spread over 12 months, $500 is small. Only count a waived fee you would really have paid.
Net effective rent table: common free-month offers compared
The same asking rent produces very different net effective rents depending on the offer and the term. This table holds the asking rent at $2,600 (an assumption) and changes only the concession and the lease length.
| Offer | Value of the concession | Net effective rent a month | Below asking rent | Effective discount |
|---|---|---|---|---|
| 1 month free on a 12-month lease | $2,600 | $2,383.33 | $216.67 | 8.33% |
| 1 month free on a 13-month lease | $2,600 | $2,400 | $200 | 7.69% |
| 2 months free on a 14-month lease | $5,200 | $2,228.57 | $371.43 | 14.29% |
| 6 weeks free on a 12-month lease | $3,900 | $2,275 | $325 | 12.5% |
| 2 months free on a 12-month lease | $5,200 | $2,166.67 | $433.33 | 16.67% |
Two rows are worth a second look. "2 months free on 14" beats "6 weeks free on 12" on net effective rent, but it commits you to 14 months. And "1 month free on 13" is a smaller discount than "1 month free on 12", although the two adverts read almost the same. For another rent, multiply the asking rent by (1 - effective discount).
Gross rent vs net effective rent: what a tenant actually pays
The net effective rent is an average, not the payment. On the 13-month example you pay $2,600 in each of 12 months and $0 in the free month, unless the lease spreads the credit, in which case each of the 13 payments is $2,400.00. Read the lease to see which month is free and whether the credit is spread.
This matters for a budget. If you plan around $2,400.00 but the payment is $2,600, you are $200.00 short in every paid month.
Listings do not always show both figures. One rule that requires both: New York City's housing portal law (Local Law 81 of 2020) lists, for a unit offered for rent with a temporary reduction such as months without rent, the proposed monthly rent plus "the net effective rent for such unit and the period that such net effective rent will apply". That law covers units on the city's housing portal, not every listing. Wherever you rent, ask for the gross rent, the term and the exact concession in writing.
Comparing two listings on net effective rent
Listing A is the 13-month example: $2,600 with one month free, $2,400.00 net effective. Listing B (also an assumption) is $2,450 for 12 months with no concession, so its net effective rent is $2,450. A is $50 a month cheaper over the first term, even though its asking rent is $150 higher.
The renewal arithmetic
Check your lease: if the renewal is based on the gross rent and the concession is not repeated, your average monthly cost rises from $2,400.00 to $2,600 with no increase at all. That is $200 a month, $2,400 a year, or 8.33% more than you were effectively paying.
Add an assumed 3% increase on the gross rent and the renewal is $2,678: $278 a month more than the first term's net effective rent, or 11.58%. Listing B with the same 3% increase renews at $2,523.50. In year two, A costs $154.50 a month more than B. Whether a renewal uses the gross or the net figure, and whether any limit on increases applies, depends on your lease and local rules. Read both before you sign; I have not stated any state or city renewal rule here.
Free month or lower rent? The landlord's arithmetic
Over the first lease term, one free month and an equivalent rent cut collect exactly the same money. The difference is the rent written in the lease, and what follows from it afterwards.
| Line | $2,600 with 1 month free | Rent cut to $2,400, no concession |
|---|---|---|
| Rent stated in the lease | $2,600 | $2,400.00 |
| Rent collected over 13 months | $31,200.00 | $31,200 |
| Effective discount on $2,600 | 7.69% | 7.69% |
| Cash in the free month | $0 | $2,400.00 |
| Next 12 months if renewed at the stated rent, no new concession | $31,200 | $28,800 |
So the concession costs $2,600.00 once. The rent cut costs the same $2,600.00 over the first 13 months, then a further $2,400 in every later year the lower rent stays in place. If the tenant leaves at the end of the term, the two are identical. The concession only comes out ahead for the owner if the gross rent holds at renewal.
Two more checks. A free month is the same money as one month of vacancy at $2,600, so a concession that fills the unit a month sooner pays for itself. And the lease rent is not the income: $2,600 overstates first-term income by 7.69%, so value the unit on $2,400.00 until a renewal at the gross rent is signed.
Commercial leases: net effective rent per square foot, and the discounted version
Where rent is quoted per square foot per year, divide the annual net effective rent by the area: net effective rent per sq ft = net effective monthly rent x 12 / square feet.
Assume 2,000 sq ft at $5,000 a month ($30.00 per sq ft a year), a 60-month term with flat rent, and 3 months free. Rent over the term is $300,000, the free rent is worth $15,000, and the net effective rent is $4,750 a month, or $28.50 per sq ft a year. If you also deduct an assumed $10,000 one-off landlord allowance, concessions total $25,000 and the figure drops to $4,583.33 a month, $27.50 per sq ft a year. Which landlord costs count varies by analyst, so compare proposals on the same basis. The calculator assumes flat rent; for stepped rent, use the payment-column formula below.
The discounted (present value) version
The discounted version weights early months more heavily than late ones. Cornell's guide to its Free Rent Calculator, built for commercial leases, describes effective rent as "equivalent to the tenant paying a constant base rent over the entire lease term". To get a level figure in a spreadsheet, find the present value of the monthly payments, then convert it to a level payment. Microsoft's NPV and PMT pages give the syntax; NPV assumes each value arrives at the end of a period, so rent paid in advance needs the first month added outside it.
On the 13-month apartment example, at an assumed 6% annual discount rate with rent due at the start of each month, the levelled figure is $2,393.96 if the free month is month 1 and $2,405.93 if it is month 13. The straight-line calculator on this page returns $2,400.00 for both. The $11.97 gap is small on a 13-month lease and grows with longer terms and more free rent up front. The discount rate is your own assumption.
Net effective rent calculator in Excel and Google Sheets
Five formulas cover the calculation, the reverse calculation and the discounted version. Layout: B2 = monthly asking rent, B3 = lease term in months, B4 = free months, B5 = other one-off concessions, B6 = net effective rent (the first formula), B7 = an advertised net effective rent, B8 = square feet, B9 = annual discount rate, and D2:D14 = the rent actually due in each month of a 13-month lease, in order, with 0 in a free month.
Net effective rent a month (straight-line)
=(B2*B3-B2*B4-B5)/B3B2 = asking rent, B3 = term in months, B4 = free months, B5 = other one-off concessions. 2600, 13, 1, 0 returns 2400.
Effective discount
=(B2*B4+B5)/(B2*B3)Format as a percentage. 2600, 13, 1, 0 returns 7.69%.
Gross rent from an advertised net effective rent
=(B7*B3+B5)/(B3-B4)B7 = advertised net effective rent. 2400 on 13 months with 1 free returns 2600, the payment in each paid month.
Net effective rent per square foot per year
=B6*12/B8B6 = net effective monthly rent, B8 = square feet. 4750 a month on 2,000 sq ft returns 28.50.
Discounted net effective rent (rent paid in advance)
=-PMT(B9/12,COUNT(D2:D14),D2+NPV(B9/12,D3:D14),0,1)B9 = annual discount rate, D2:D14 = rent due each month with 0 in a free month. With D2 = 0, twelve payments of 2600 and 6% it returns 2393.96; at a 0% rate it returns the straight-line 2400.
The reverse formula is for adverts that show only the net effective figure: $2,400.00 on a 13-month lease with one month free means payments of $2,600. For stepped rent, =SUM(D2:D14)/COUNT(D2:D14) gives the straight-line figure from the payment column. Google Sheets uses the same syntax.
Calculator, your own sheet, or a deal analyzer: which to use
Use the calculator above for a single listing, your own sheet (one row per listing, formulas above) to compare several or handle stepped rent, and a deal analyzer only when the question is whether to buy the property.
What to put in a net effective rent sheet: asking rent, lease term, free months, which month is free, other one-off concessions and the renewal basis stated in the lease as inputs; concession value, net effective rent a month and a year, gap to asking rent and effective discount as outputs.
To be plain about the paid product: the Rental Property Deal Analyzer does not compute net effective rent. It screens a purchase, one rental at a time. You enter price, down payment, rate, term, closing and rehab costs, rent, vacancy and expenses, and it returns the mortgage payment, monthly and annual cash flow, total cash invested, cash-on-cash return, cap rate and the 1% rule check, colour-coded green, amber or red against targets you set. It runs in Excel and Google Sheets, costs $14.99 once, and is not a bookkeeping or rent-roll tracker.
The two connect at one cell. If the unit you are buying is let on a concession, type the net effective rent ($2,400.00 here), not the $2,600 lease rent, into the monthly rent input of the rental property analysis spreadsheet, and do not also raise the vacancy percentage for the same free month. The rental property analysis spreadsheet guide walks through the other inputs, and the rental yield calculator guide and cap rate calculator guide cover the ratios that rent figure feeds.
Rental Property Deal Analyzer
The spreadsheet version of this guide for Excel & Google Sheets: type your numbers into the highlighted cells and the formulas do the rest. One-time $14.99, no subscription, instant download.
See the real estate investment spreadsheet →Buy now — $14.99All 7 templates — $49Instant access by email after checkout via Payhip.
Step-by-step: Net Effective Rent Calculator: What Free Months and Concessions Really Cost
- Find the gross rent and the full lease term. Take the monthly rent stated in the lease and the term in months, including any free months. Example: $2,600 for 13 months.
- Total the rent before concessions. Multiply rent by term. $2,600 x 13 = $33,800.00.
- Value every concession in dollars. Free months x monthly rent, plus one-off items such as a gift card or waived fee. One free month is $2,600.00.
- Subtract and divide by the term. ($33,800.00 - $2,600.00) / 13 = $2,400.00 net effective rent a month.
- Compare with the asking rent. $2,600 - $2,400.00 = $200.00 a month, an effective discount of 7.69%.
- Check the payment schedule and the renewal basis. Read the lease for which month is free, whether the credit is spread, and whether a renewal starts from the gross rent.
Skip the setup: Rental Property Deal Analyzer
The spreadsheet version of this guide for Excel & Google Sheets: type your numbers into the highlighted cells and the formulas do the rest. One-time $14.99, no subscription, instant download.
See the Rental Property Deal Analyzer →Buy now — $14.99All 7 templates — $49Instant access by email after checkout via Payhip.
Frequently asked questions
How do you calculate net effective rent?
Multiply the monthly rent by the lease term, subtract the value of all concessions, and divide by the lease term. $2,600 for 13 months is $33,800.00; less one free month ($2,600.00) leaves $31,200.00; divided by 13 that is $2,400.00 a month.
What is net effective rent?
Net effective rent is the average monthly cost of a lease after free months and other concessions are spread over the whole term. It is lower than the rent written in the lease. On a $2,600 lease with one month free in 13, it is $2,400.00.
What is the difference between gross rent and net effective rent?
Gross rent is the monthly amount stated in the lease and the payment you make in each paid month. Net effective rent is that amount averaged down for concessions. In the 13-month example the gross rent is $2,600 and the net effective rent is $2,400.00, a gap of $200.00.
How do you calculate 6 weeks free rent?
Treat six weeks as about 1.5 months of rent. At $2,600 on a 12-month lease the concession is worth $3,900, so the net effective rent is $2,275.00 a month, 12.5% below asking. If the lease gives the free period in days, value it with the lease's day-count method instead.
Do I pay the net effective rent each month?
Not necessarily. If the lease states the gross rent, you pay $2,600 in paid months and nothing in the free month, which averages $2,400.00. Some leases spread the credit across every payment instead. Budget from the payment schedule in your lease, not the average.
What happens to net effective rent at renewal?
It depends on the lease. If the renewal starts from the gross rent and the concession is not repeated, a tenant averaging $2,400.00 moves to $2,600, 8.33% more before any increase. Check the renewal clause and your local rules before signing.
How do you calculate net effective rent per square foot?
Multiply the net effective monthly rent by 12 and divide by the square footage. With an assumed $5,000 a month on 2,000 sq ft, 60 months and 3 months free, net effective rent is $4,750 a month, or $28.50 per square foot a year against $30.00 gross.
How do I calculate net effective rent in Excel?
Put the asking rent in B2, the term in B3, free months in B4 and other concessions in B5, then use =(B2*B3-B2*B4-B5)/B3. For the discounted version, list each month's rent in a column and use PMT on the NPV of that column.
Sources
- New York City Comptroller, Retail Vacancy in New York City (report) — Describes net effective rent as 'rent net of concessions, givebacks, free month's rent, etc.' (chart notes).
- Local Laws of the City of New York for the Year 2020, No. 81 (housing portal) — Offered unit information for a rental: the proposed monthly rent and, if a temporary reduction such as months without rent is offered, 'the net effective rent for such unit and the period that such net effective rent will apply'.
- Cornell eCommons, Guide to Using the Free Rent Calculator (abstract) — Effective rent described as 'equivalent to the tenant paying a constant base rent over the entire lease term'.
- Microsoft Support, NPV function — NPV(rate,value1,...) syntax; values must be equally spaced and occur at the end of each period.
- Microsoft Support, PMT function — PMT(rate, nper, pv, [fv], [type]) syntax; type 1 = payments due at the beginning of the period.
I'm not a contractor, landlord or accountant. I build the pricing maths, and every number on this page shows its working so you can check it instead of trusting it. Guides are drafted with AI assistance; every worked figure is computed by the same code as the free calculators. How these guides are made → · Watch the breakdowns on YouTube →