Rent Roll Analyzer
Analyze rental income, vacancy loss, and effective gross income from a property rent roll.
About this calculator
The Rent Roll Analyzer walks from theoretical maximum rental income down to what a property actually collects — the standard progression real estate underwriters use when evaluating a multifamily property. Gross Potential Rent is Total Units x Average Rent per Unit x 12, the revenue if every unit were occupied and paying full asking rent all year. Vacancy Loss subtracts out the rent lost to Vacant Units, Concessions Loss subtracts a percentage of Gross Potential Rent for discounts and free-rent promotions, and Other Monthly Income (parking, laundry, storage fees, annualized) is added back in — the sum is Effective Gross Income, the figure lenders and appraisers actually use for underwriting and NOI calculations, not Gross Potential Rent.
Vacancy Rate is simply Vacant Units divided by Total Units, so adding more total units while holding the vacant count fixed mechanically lowers the vacancy rate even if nothing about actual leasing performance changed — a subtlety worth watching when comparing properties of different sizes. Other Monthly Income has no effect on Vacancy Rate or Occupancy Rate at all; those two outputs depend purely on the unit counts, while ancillary income only flows into the dollar-based Effective Gross Income figures.
Financial Disclaimer
This calculator is for educational purposes only and does not constitute financial advice. Results are estimates based on the inputs provided. Consult a qualified financial advisor before making investment or financial planning decisions.
Inputs
Results
Effective Gross Income (Annual)
$262,320.00
Monthly EGI
$21,860.00
How to Use This Calculator
- Enter Total Units, Average Rent per Unit, and number of Vacant Units.
- Add Other Monthly Income from parking, laundry, storage, or other ancillary revenue.
- Set Concessions % for any discounts, free-rent periods, or promotional pricing.
- Review Effective Gross Income (EGI) — the actual collectible income after vacancy and concessions.
- Check Occupancy Rate and compare against local market rates.
- Use monthly EGI for NOI calculations and lender underwriting submissions.
How the result changes with Total Units
| Total Units | Effective Gross Income (Annual) | Monthly EGI |
|---|---|---|
| 10 | $119,760.00 | $9,980.00 |
| 15 | $191,040.00 | $15,920.00 |
| 30 | $404,880.00 | $33,740.00 |
| 50 | $690,000.00 | $57,500.00 |
What each input means
- Total Units
- Total number of rentable units.
- Average Rent per Unit
- Average monthly rent per unit.
- Vacant Units
- Number of currently vacant units.
- Other Monthly Income
- Monthly income from parking, laundry, storage, etc.
- Concessions
- Percentage of gross rent lost to concessions and discounts.
How this is calculated
Worked example, using the default values
- Identify Input Parameters5 parametersTotal Units = 20, Average Rent per Unit = 1200, Vacant Units = 2, Other Monthly Income = 500, Concessions = 1 = 5 input(s) provided
- Calculate Effective Gross IncomeEffective Gross Income262320 = $262,320
- Calculate Monthly EGIMonthly EGI21860 = $21,860
- Calculate Gross Potential RentGross Potential Rent288000 = $288,000
- Calculate Vacancy LossVacancy Loss28800 = $28,800
Engine last updated . Checked against 1 independently-derived test — how we verify calculators. Built by Paul Gunder, a software engineer, not a licensed financial, medical, or legal professional.
Frequently Asked Questions
What is the difference between Gross Potential Rent and Effective Gross Income?
Gross Potential Rent is the theoretical maximum — Total Units times Average Rent per Unit times 12 — assuming every unit is occupied and paying full rent all year. Effective Gross Income is the realistic figure after subtracting Vacancy Loss and Concessions Loss and adding back Other Monthly Income; it's the number lenders, appraisers, and underwriters actually use for NOI and valuation, since Gross Potential Rent overstates what a property truly collects.
Why does adding more units lower my Vacancy Rate even if the number of empty units stays the same?
Vacancy Rate is calculated as Vacant Units divided by Total Units, so the same fixed number of vacant units becomes a smaller percentage of a larger total unit count. This is a purely mechanical effect of the ratio, not an indication that leasing performance actually improved — always compare vacancy rates alongside the raw vacant unit count, especially when sizing up properties of very different scales.
Does Other Monthly Income affect my Vacancy Rate or Occupancy Rate?
No. Vacancy Rate and Occupancy Rate depend only on Total Units and Vacant Units — Other Monthly Income (parking, laundry, storage, and similar ancillary revenue) has no effect on either percentage. It only flows into the dollar-denominated Effective Gross Income and Monthly EGI figures, where it's added on top of net rental income.
Why would a property have concessions loss even at full occupancy?
Concessions Loss represents discounts and promotional offers — like a free month's rent to attract a new tenant, or a reduced rate to retain a renewing one — applied as a percentage of Gross Potential Rent, independent of whether the unit is currently occupied or vacant. A fully leased property can still carry meaningful concessions loss if management used rent discounts as a leasing or retention tool during the period.
How should I use the Effective Gross Income figure?
Effective Gross Income (or its monthly form, Monthly EGI) is the realistic revenue figure to use as the starting point for calculating Net Operating Income — subtract operating expenses from it, not from Gross Potential Rent, which overstates actual collections. It's also the income figure lenders typically expect to see in underwriting submissions for a rent roll analysis.
Related Calculators
The questions that sit next to this one — chosen by subject, including calculators filed under a different category.
Multi-Family Cash Flow Calculator
Calculate monthly and annual cash flow, cap rate, and cash-on-cash return for multi-family properties.
Property ManagementOperating Expense Ratio Calculator
Calculate OER and benchmark operating expenses against effective gross income.
Property ManagementTurnover Cost Calculator
Calculate the total cost of tenant turnover including vacancy loss, repairs, and administrative costs.
Real Estate InvestingReal Estate Portfolio Analyzer Calculator
Analyze your entire rental portfolio: total value, equity, NOI, cash flow, DSCR, cap rate, and projected appreciation across all properties.
Investment LiteracyTarget Date Fund Analyzer
Analyze glide path, projected balance, fee impact, and retirement income for target date funds.
More in Real Estate & Property.