Rent Roll Deep Dive: Red Flags, Reconciliation, and the Fields That Make or Break a CRE Acquisition

Key Takeaways

What a Rent Roll Actually Contains

A rent roll is a spreadsheet or report listing every lease at a property, one row per tenant (or per unit, in multifamily). The document is produced by the property's management software or accounting system and represents a snapshot of the property's leased status as of a specific date, called the "as-of date." That date matters. A rent roll dated six months before the listing date is stale. A rent roll dated within 30 days of the offering memorandum is current. The first thing to check is whether the as-of date aligns with the deal timeline.

Beyond the as-of date, the rent roll contains a set of fields that vary by property type and management system, but the institutional standard includes at least 15 columns. Each one tells you something specific about the property's income quality, tenant composition, and rollover risk. Understanding what each field communicates, and what it hides, is the foundation of rent roll analysis.

The 15 Core Fields

1. Unit or Suite Number. The physical identifier for the space. In multifamily, this is the apartment number. In office and retail, it is the suite number. Cross-reference this against the floor plan to confirm that every leasable unit appears on the rent roll. Missing units indicate either vacancy that is not disclosed or spaces that have been taken offline (converted to storage, used by management, or structurally compromised). If the property has 200 units and the rent roll shows 192, the eight missing units need an explanation.

2. Unit Type or Size. The unit type (one-bedroom, two-bedroom, studio) in multifamily, or the rentable square footage in office, retail, and industrial. This field anchors the per-unit or per-square-foot rent calculation. Verify that the total square footage on the rent roll matches the total rentable area in the offering memorandum and the building's certificate of occupancy. Discrepancies may indicate mismeasurement, unreported common-area conversions, or intentional inflation of rentable area through aggressive loss factor calculations.

3. Tenant Name. The legal name of the lessee. In commercial properties, this is the entity that signed the lease. In multifamily, it is the individual or individuals on the lease. Tenant names matter because they enable credit analysis. A commercial rent roll where 40% of the rent comes from a single tenant creates concentration risk. A multifamily rent roll where several units are leased to the same individual or entity may indicate a master lease or subletting arrangement that is not disclosed. Also watch for vacant units listed with placeholder names like "Model," "Office," or "Staff."

4. Lease Start Date. When the current lease term began. This field, combined with the lease end date, tells you the original lease term. It also tells you how long each tenant has been in occupancy. A property where 30% of tenants moved in within the last 90 days, coinciding with the marketing period, is a classic red flag for lease-up manipulation. Fannie Mae's Multifamily Mortgage Fraud Prevention guide specifically identifies rapid pre-sale lease-up as an indicator of rent roll inflation, where the seller fills vacant units at above-market rents to inflate the property's income for the sale, with the expectation that those tenants will vacate shortly after closing.

5. Lease End Date. When the current lease term expires. This is the field that drives lease expiration analysis. A blank or missing end date typically indicates a month-to-month tenancy. Lease end dates that cluster within a narrow window create rollover risk. Lease end dates far in the future (10+ years) on a multifamily property are unusual and warrant investigation, as residential leases rarely exceed 24 months.

6. Lease Term (Months). The total duration of the lease. Derived from the start and end dates, but sometimes listed separately. In commercial properties, longer terms generally indicate more stable income. In multifamily, standard terms are 12 months. Terms shorter than 6 months in a market where 12-month leases are standard suggest the property is offering short-term deals to fill vacancies, which inflates occupancy without stabilizing income.

7. Monthly Rent (Contract Rent). The monthly base rent the tenant is obligated to pay under the lease. This is the gross contractual amount before any adjustments for concessions, free rent periods, or expense reimbursements. It is the number that, when summed across all occupied units and annualized, produces the scheduled Gross Potential Rent (GPR). Contract rent is not the same as effective rent. A tenant paying $1,500/month with a two-month free rent concession on a 12-month lease has a contract rent of $1,500 but an effective rent of $1,250 ($15,000 net over 12 months divided by 12).

8. Market Rent (Comparable Rent). The rent that the unit would command on the open market today, based on comparable transactions. Not every rent roll includes this field, but institutional-quality rent rolls should. The gap between contract rent and market rent is the mark-to-market exposure. Units with contract rents significantly above market are at risk of non-renewal or rent reduction at lease expiration. Units with contract rents below market represent upside potential, but only if the leases expire soon enough to capture that upside within the investment hold period.

9. Rent per Square Foot (or Rent per Unit). The normalized rent metric that enables comparison across units of different sizes. In office and retail, this is typically expressed as annual rent per rentable square foot. In multifamily, it is monthly rent per unit. This field makes it possible to identify outliers: units renting at $2.50/SF when the building average is $1.80/SF, or one-bedroom apartments at $2,100/month when comparable one-bedrooms in the building are at $1,650.

10. Security Deposit. The deposit amount held by the landlord. In multifamily, the standard is one month's rent. In commercial leases, the deposit may be one to three months of base rent, a letter of credit, or a guarantor arrangement. The security deposit field tells you two things: the property's exposure to uncollectable rent upon tenant default, and whether deposits are in line with market norms. A property where 30% of tenants have zero security deposit is exposed to higher bad debt risk.

11. Concessions. Any rent reductions, free rent periods, or other financial inducements granted to the tenant. This field is critically important and frequently missing from seller-provided rent rolls. Lev's rent roll analysis guide notes that concessions are the primary mechanism through which sellers inflate occupancy without maintaining actual economic rents. A property may show 96% occupancy at $1,500/unit on the rent roll, but if 20% of those tenants received two months of free rent, the effective economic occupancy is materially lower. Always ask for a separate concession log if the rent roll does not include this column.

12. Rent Escalation Schedule. The contractual rent increases built into the lease. In commercial leases, escalations are typically annual bumps of 2% to 3%, or CPI-based adjustments, or step-ups to fixed amounts at specified dates. In multifamily, escalations within a lease term are less common, but renewal terms may specify rent increases. This field matters for cash flow projection: a 10-year commercial lease with 3% annual escalations produces meaningfully different Year 5 income than a flat lease.

13. Lease Type or Expense Structure. Whether the lease is gross, net (NNN), modified gross, or percentage rent. This determines which operating expenses are the tenant's responsibility and which fall on the landlord. A rent roll that shows all tenants at $25/SF NNN tells a very different story than one at $40/SF gross, even though the landlord's net operating income may be similar. Mixing lease types within a single property, which is common in retail, requires unit-level expense modeling.

14. Renewal Options. Whether the tenant has the right to renew the lease at expiration, and at what terms. Renewal options affect the property's rollover risk profile. A tenant with a five-year renewal option at a pre-negotiated rate below market creates a long-term income constraint that the seller may not highlight. Conversely, a tenant with no renewal option and an expiring lease in six months may vacate, creating near-term vacancy risk.

15. Balance Due (Arrears). Any unpaid rent balance as of the rent roll date. This field is the most direct indicator of collections problems. A rent roll that shows zero arrears across all tenants is either a perfectly performing property or a rent roll that has been cleaned up for the sale. Cross-reference arrears against the T-12 operating statement's bad debt and collections loss line items to test consistency.

The Reconciliation Test: Rent Roll GPR vs T-12 GPR

The reconciliation between the rent roll and the trailing-twelve-month (T-12) operating statement is the single most revealing diagnostic test in rent roll analysis. The rent roll tells you what tenants are supposed to pay. The T-12 tells you what tenants actually paid. The gap between these two numbers, the reconciliation delta, quantifies the property's income leakage from vacancy, concessions, bad debt, and collections loss.

Start with the rent roll's scheduled Gross Potential Rent (GPR). This is the sum of all contract rents across all units, annualized, assuming 100% occupancy at current lease rates. If the rent roll shows 200 units at an average contract rent of $1,500/month, the scheduled GPR is $3,600,000. This number represents the theoretical maximum income the property can generate under current leases. It is not what the property actually earns.

Next, pull the actual rental income from the T-12 operating statement. This is the total rent collected during the trailing twelve months, after accounting for vacancy loss, concessions, bad debt write-offs, and collections shortfalls. If the T-12 shows $3,250,000 in actual rental income, the reconciliation delta is $350,000, or 9.7% of scheduled GPR.

Breaking Down the Delta

A reconciliation delta of 9.7% is not inherently problematic, but it requires itemization. The delta decomposes into four categories, each with different implications for underwriting:

Physical vacancy loss. The income lost from units that were physically unoccupied during the T-12 period. If the property averaged 5% physical vacancy, the vacancy loss on $3,600,000 GPR is $180,000. Physical vacancy is the most straightforward component of the delta and is typically verifiable through occupancy records and move-in/move-out logs.

Concession expense. The income reduction from free rent periods, move-in specials, and other financial inducements. If the property granted an average of 0.5 months free rent per new lease, and 40 new leases were signed during the T-12, the concession cost is approximately $30,000 (40 leases x 0.5 months x $1,500 average rent). Concessions are economic vacancy: the unit is occupied, but the income is not fully realized.

Bad debt and write-offs. The rent that was billed but never collected, ultimately written off as uncollectable. In a well-managed multifamily property, bad debt runs 0.5% to 1.5% of GPR. On the example property, 1% bad debt is $36,000. Bad debt above 2% of GPR signals either a challenging tenant base or weak credit screening and collections processes.

Collections loss (timing). The rent that is billed and expected to be collected but has not yet been received. This includes tenants who are late but not in default, partial payments, and disputed amounts. Collections loss differs from bad debt in that the landlord still expects to collect; it just has not arrived yet. In underwriting, collections loss is typically modeled as a separate line item from bad debt, at 0.5% to 1.0% of GPR.

What the Delta Tells You

The total size of the reconciliation delta matters, but the composition matters more. A 10% delta driven entirely by physical vacancy in a lease-up property is different from a 10% delta driven by bad debt and collections losses in a stabilized property. The vacancy-driven delta reflects market conditions and lease-up timing, both of which are visible and modelable. The bad-debt-driven delta reflects tenant quality and management effectiveness, which are harder to underwrite and more likely to persist post-acquisition.

As a general benchmark, a reconciliation delta below 5% on a stabilized property is considered tight. A delta between 5% and 10% warrants itemized investigation. A delta above 10% is a yellow flag that requires the seller to provide a line-by-line explanation of the gap. On value-add deals where vacancy is expected and the acquisition thesis depends on lease-up, larger deltas are acceptable, but the buyer should verify that the vacancy is physical (units are genuinely empty) rather than economic (units are occupied but not paying).

One test that catches a surprising number of misrepresentations: compare the rent roll's scheduled GPR against the T-12's rental income line divided by the average occupancy rate. If the rent roll shows $3,600,000 in scheduled GPR and the T-12 shows 95% average occupancy, the expected T-12 rental income is $3,420,000 (GPR x occupancy). If the T-12 actually shows $3,250,000, the $170,000 shortfall against the occupancy-adjusted expectation represents non-vacancy income leakage: concessions, bad debt, and collections problems that are not captured in the headline occupancy figure.

12 Red Flags That Signal Trouble

The following red flags are ranked from informational items that prompt further questions to deal-breakers that can kill an acquisition. Not every red flag means the deal is bad. But each one represents a risk that, if unaddressed, can materially affect post-acquisition cash flow. As Primior's seven-test rent roll framework emphasizes, the goal of red flag screening is not to find reasons to walk away, but to find the questions that need answers before you can underwrite the deal with confidence.

Red Flag 1: Recent Lease-Up Surge

If more than 15% of leases were signed within 90 days of the listing date, the seller may have inflated occupancy for the sale. This tactic involves filling vacant units at market or above-market rents shortly before marketing the property, boosting the rent roll's occupancy and GPR. The problem is that these newly signed tenants have no payment history, may have received undisclosed concessions, and are more likely to default or vacate shortly after closing. Fannie Mae identifies rapid pre-sale lease-up as one of the primary indicators of rent roll manipulation in multifamily transactions. Request the move-in dates and credit screening records for all tenants who signed within 90 days of listing.

Red Flag 2: Above-Market Rents Without Concessions

Units renting at 10% or more above market comparables, with no recorded concessions, raise two concerns. First, the rents may be unsustainable and will revert to market at renewal, creating negative rent growth in the pro forma. Second, above-market rents without concessions may indicate that the seller has increased asking rents to inflate GPR, knowing that tenants will negotiate downward or vacate at renewal. Run a rent comparable analysis against at least three competing properties within a one-mile radius to establish the market rent range, then flag every unit renting above the 75th percentile of that range.

Red Flag 3: Identical Lease Execution Dates

If multiple unrelated tenants signed leases on the same date, it may indicate backdated or fabricated leases. In a normal operating property, leases are signed throughout the year as tenants move in and out. Finding ten leases all executed on March 1 suggests either a bulk lease restructuring (which should be disclosed) or document fabrication. Request the original signed lease documents for a sample of the same-date leases and verify the signatures and terms against the rent roll entries. This red flag is particularly concerning when combined with Red Flag 1 (recent lease-up surge).

Red Flag 4: Missing or Incomplete Fields

A rent roll that omits lease start dates, lease end dates, security deposits, or concession information is incomplete. Missing fields are not always fraudulent; they often reflect inadequate property management software or sloppy record-keeping. But missing data prevents the underwriter from performing standard analyses (lease expiration scheduling, month-to-month concentration, concession detection). Request the complete rent roll with all standard fields populated, and if the seller cannot produce one, treat the missing data as a risk factor in the underwriting.

Red Flag 5: Month-to-Month Concentration Above 15%

More than 15% of units (or 15% of total rent) on month-to-month leases creates material rollover risk. Month-to-month tenants can vacate with 30 days' notice, turning occupied units into vacancy without the lead time that a lease expiration provides. In markets with seasonal demand (college towns, resort areas), high month-to-month concentration in the off-season is expected. In stable suburban multifamily, month-to-month concentration above 15% indicates either a management team that is not renewing leases proactively or a tenant base that is reluctant to commit to new terms. See the dedicated section below for threshold benchmarks and haircut methodology.

Red Flag 6: Clustered Lease Expirations

More than 20% of total rent expiring within a single 12-month period creates a concentrated rollover event that exposes the property to simultaneous vacancy risk, capital expenditure spikes (from concurrent unit turns), and negotiating disadvantage (multiple tenants requesting concessions at the same time). In commercial properties, a single anchor tenant expiration can represent 30% to 50% of total rent. In multifamily, clustering can result from a bulk lease-up where all tenants signed at the same time and are now approaching a simultaneous renewal date. See the dedicated expiration schedule section below.

Red Flag 7: Rent Roll Date Significantly Predates the Offering

A rent roll with an as-of date more than 60 days before the offering memorandum is stale. Tenants may have moved out, rents may have changed, and concessions may have been granted since the rent roll was produced. Request a current rent roll dated within 30 days of your analysis date. If the seller resists providing an updated rent roll, treat the resistance itself as a red flag. Properties with deteriorating occupancy or increasing bad debt have an incentive to present the most favorable historical snapshot rather than the current reality.

Red Flag 8: Gross Rent Exceeds Operating Statement Income

If the rent roll's scheduled GPR significantly exceeds the T-12 rental income line, the property is not collecting what it bills. As discussed in the reconciliation section above, a delta above 10% requires a line-by-line explanation. This red flag is particularly concerning when the seller is using the rent roll GPR (rather than T-12 actual collections) as the basis for the asking price. A property priced on $3,600,000 in scheduled GPR but collecting only $3,250,000 is overpriced by the capitalized value of the $350,000 gap.

Red Flag 9: No Rent Escalation Clauses in Long-Term Leases

Commercial leases without rent escalation clauses lock in today's rent for the full lease term, eroding the landlord's income in real terms as operating expenses increase. A 10-year commercial lease at a flat $25/SF NNN with no escalation produces materially worse economics than the same lease with 2.5% annual bumps. If the rent roll shows multiple long-term leases with no escalation provisions, the property's income growth is constrained, and the pro forma should reflect flat or declining real income over the hold period.

Red Flag 10: Unusually Low or Zero Security Deposits

Tenants with zero security deposit have no financial commitment at risk if they default. In multifamily markets where one month's deposit is standard, a rent roll showing 25% of tenants with zero deposit suggests either a weak tenant base that could not produce deposits or a management team that waived deposits to fill units. Either scenario increases bad debt exposure. In commercial properties, the absence of security deposits, letters of credit, or guarantor provisions on smaller tenants (non-credit tenants) indicates elevated collections risk.

Red Flag 11: Significant Arrears Across Multiple Tenants

If 10% or more of tenants show outstanding balances of 30 days or more on the rent roll, the property has a collections problem that will persist post-acquisition. Arrears concentration matters: three tenants each owing $500 is manageable, but one tenant owing $15,000 and facing eviction proceedings represents a near-term vacancy event that may not be reflected in the occupancy figure. Request an aging report that breaks out receivables by 0-30, 31-60, 61-90, and 90+ day buckets to assess the severity of the collections issue.

Red Flag 12: Tenant Names Suggest Related Parties

Units leased to entities affiliated with the seller, the property manager, or the listing broker are not arm's-length transactions. Rents on affiliated-party leases may be above or below market, and the tenants may vacate at closing. Common indicators include units leased to the seller's LLC, the property management company, "model" or "employee" designations, or multiple units leased to the same corporate entity. Fannie Mae's fraud prevention guidelines flag related-party occupancy as a common mechanism for artificially inflating a property's occupancy rate. Request disclosure of all related-party leases and exclude them from the stabilized income calculation.

Month-to-Month Concentration Analysis

Month-to-month (MTM) leases are leases that have either expired and converted to holdover tenancy or were originally structured without a fixed term. In either case, the tenant can vacate with 30 days' notice (or the notice period required by state law), and the landlord can non-renew with the same notice. MTM tenants are occupying the space, contributing to the occupancy rate, and paying rent, but their income is not secured by a lease term. From an underwriting perspective, MTM income is less durable than termed income.

The MTM concentration metric is the percentage of total rental income generated by month-to-month tenants. There are two ways to calculate it: by unit count (MTM units divided by total units) and by income (MTM rent divided by total scheduled rent). The income-based calculation is more meaningful because a single large commercial tenant on MTM represents more risk than ten small units on MTM.

Threshold Benchmarks

The haircut methodology for MTM income works as follows. If 20% of the property's rental income ($720,000 on the example $3,600,000 GPR property) comes from MTM tenants, and the underwriter applies a 15% haircut to MTM income, the adjusted MTM contribution is $612,000. The resulting stabilized GPR is $3,492,000 ($2,880,000 from termed tenants + $612,000 from MTM tenants), a reduction of $108,000 from the unadjusted figure. At a 5.5% cap rate, that $108,000 haircut reduces property value by approximately $1,964,000. Month-to-month concentration is not a line item on the pro forma; it is a valuation risk that the underwriter must model explicitly.

There is one important exception. In certain markets and property types, high MTM concentration is structural rather than problematic. Student housing in college towns, where leases align with the academic year, may show elevated MTM during summer months. Furnished corporate housing properties operate primarily on short-term and MTM arrangements at premium rents. In these cases, the MTM concentration reflects the business model, not a management failure. The underwriter should benchmark MTM concentration against comparable properties in the same submarket and asset class, not against a universal threshold.

Lease Expiration Schedule Analysis

The lease expiration schedule is a distribution of when current leases end, typically organized by year (or by quarter for near-term analysis). A healthy expiration schedule distributes expirations relatively evenly across time, so that no single period bears a disproportionate share of rollover risk. A risky schedule concentrates expirations into a narrow window, creating a "wall" of lease maturities that can overwhelm the leasing team and the capital budget simultaneously.

Building the Schedule

To build a lease expiration schedule from the rent roll, sort all leases by expiration date and group them by year. For each year, calculate: (a) the number of leases expiring, (b) the total rentable area expiring, (c) the total annual rent expiring, and (d) the expiring rent as a percentage of total scheduled rent. The result is a table or bar chart that shows the rollover exposure in each future year.

In the distributed profile, no single year exceeds 15% of total rent. The landlord can manage rollovers sequentially, spreading leasing effort and capital expenditure across time. In the clustered profile, 2028 and 2029 together account for 63% of total rent, creating a two-year window where the majority of the property's income is at risk. If the market softens during that window, the landlord faces either significant vacancy or material rent concessions across a large portion of the portfolio.

Clustering Risk Metrics

Two metrics quantify clustering risk. The first is the maximum single-year concentration: the highest percentage of total rent expiring in any one year. Institutional underwriting typically flags single-year concentrations above 20% for additional scrutiny. The second metric is the rolling two-year concentration: the maximum percentage of total rent expiring in any consecutive 24-month period. A rolling two-year concentration above 30% creates a scenario where more than one-third of the property's income base is turning over within a window that may be too short to re-lease at favorable terms.

Clustering risk is amplified by three factors. First, concurrent lease expirations create a negotiating disadvantage for the landlord. When 35% of tenants know that their neighbors' leases are also expiring, they can coordinate demands or simply observe how the landlord handles competing renewal negotiations. Second, concurrent expirations produce concurrent turnover, which means concurrent unit renovation costs. A 200-unit property where 70 leases expire in a single year may need to turn 20 to 30 units simultaneously, creating a capital expenditure spike that strains the operating budget. Third, concurrent vacancies from failed renewals compound the revenue loss. A 15% renewal failure rate on 70 expiring leases produces 10 to 11 simultaneous vacancies, versus 2 to 3 vacancies from the same failure rate spread evenly across a year.

The mitigation strategy for clustered expirations is staggered renewals: offering lease terms that deliberately spread future expirations across different years. For example, offering some tenants 11-month renewals, others 14-month renewals, and others 18-month renewals so that the next expiration cycle is distributed rather than clustered. This strategy sacrifices some of the administrative simplicity of uniform lease terms in exchange for reduced rollover concentration.

Concession Detection and Effective Rent

Concessions are the most common mechanism through which rent rolls overstate income. A concession is any financial inducement granted to a tenant to sign or renew a lease: free rent periods, reduced rent for the first or last months, move-in bonuses, waived application fees, or discounted parking. Concessions reduce the tenant's effective rent below the contract rent shown on the rent roll, but if the concession is not recorded on the rent roll, the scheduled GPR overstates the property's actual income.

Identifying Hidden Concessions

Not all concessions are visible on the rent roll. A seller who wants to present the strongest possible income picture may omit concession disclosures from the rent roll, especially if the concessions were structured as one-time payments (such as a move-in bonus paid from a separate marketing budget) rather than as adjustments to the monthly rent. Three techniques help detect hidden concessions:

Technique 1: Compare rent roll GPR to bank deposits. Request 12 months of bank statements showing rent deposits. If the total deposits are consistently below the rent roll's implied monthly collections (GPR less vacancy), the difference may represent unreported concessions. This comparison is more granular than the T-12 reconciliation because it uses actual cash flows rather than accounting entries that may include accruals.

Technique 2: Examine new-lease rents versus renewal rents. If new tenants are paying materially less than renewing tenants for comparable units, the new tenants likely received concessions that are not reflected in the rent roll's contract rent column. A one-bedroom unit that renews at $1,500/month but leases to a new tenant at $1,500/month with two months free has an effective new-lease rent of $1,250/month. If the rent roll shows both at $1,500, the concession is invisible.

Technique 3: Request the property's marketing materials. The property's online listings, flyers, and social media posts often advertise concessions that are not captured on the rent roll. "Move in this month and get one month free!" is a concession. "First month half off!" is a concession. These marketing materials provide evidence of concessions that should be reflected in the underwriting, even if the rent roll omits them. As PropRise's rent roll analysis guide notes, the gap between advertised rents and rent roll contract rents is a direct measure of the property's reliance on concessions to maintain occupancy.

Calculating Effective Rent

Once concessions are identified and quantified, the effective rent for each unit is calculated as:

In a property-wide analysis, the aggregate concession cost is the sum of all concessions across all units, annualized. If 30 out of 200 units received an average of 1.5 months of free rent at an average contract rent of $1,500/month, the annual concession cost is 30 x 1.5 x $1,500 = $67,500, or 1.9% of scheduled GPR. This figure should appear in the pro forma as a separate line item between scheduled GPR and effective gross income, alongside vacancy and bad debt. Burying concessions inside the vacancy line obscures the true occupancy picture.

Below-Market and Above-Market Rent Identification

Mark-to-market analysis compares each lease's contract rent to the current market rent for a comparable unit or space. The result is a property-wide map of which leases are above market (at risk of negative reversion at renewal) and which are below market (representing upside potential if re-leased at current rates). This analysis directly affects the acquisition pro forma because it determines whether rent growth projections are realistic or aspirational.

Establishing Market Rent

Market rent is established through three sources: (a) recent comparable lease transactions at competing properties, (b) the subject property's own recent new-lease rents (which reflect the market rate the property can actually achieve), and (c) third-party data from CoStar, Yardi Matrix, RealPage, or similar platforms. The best practice is to triangulate across all three sources, using competing property comps as the primary benchmark and the subject property's own recent leases as a reality check.

For multifamily, market rent is typically established at the unit-type level: all one-bedrooms in a submarket within a specified quality range are compared. For office and retail, market rent is established at the per-square-foot level, adjusted for floor, exposure, finish level, and lease structure (NNN vs gross). Industrial market rents are typically per-square-foot, adjusted for clear height, dock doors, and yard space.

The Mark-to-Market Exposure

Once market rents are established, each lease on the rent roll is tagged as below-market, at-market, or above-market. The thresholds are:

• Below market: Contract rent is more than 5% below the established market rent. These leases represent upside potential. The upside is realized only when the lease expires and the unit is re-leased at market, so the timing of the lease expiration determines when the upside is capturable.
• At market: Contract rent is within 5% of the established market rent. These leases are expected to renew at similar rates, producing stable income.
• Above market: Contract rent is more than 5% above the established market rent. These leases are at risk of non-renewal or rent reduction at expiration. If an above-market tenant vacates, the replacement tenant will lease at market, resulting in negative rent growth on that unit.

The property-wide mark-to-market exposure is the net of all below-market upside and above-market downside, weighted by the timing of each lease's expiration. A property with $200,000 in below-market upside but where those leases do not expire for five years has limited near-term benefit. A property with $150,000 in above-market downside where those leases expire within 18 months faces an imminent income reduction. The net exposure, time-weighted, feeds directly into the acquisition pro forma's rent growth assumptions.

One common mistake: treating above-market rents as sustainable income. A seller who points to "strong rents" without acknowledging that 15% of the rent roll is 10% above market is presenting an income picture that will deteriorate at each above-market lease expiration. The buyer's pro forma should model the above-market leases reverting to market at expiration, with the resulting negative rent growth reflected in the Year 1 and Year 2 cash flows.

Collections Ratio and Bad Debt Reserves

The collections ratio measures how much of the billed rent the property actually collects. It is calculated as:

The collections ratio is a trailing indicator: it tells you how the property has performed, not how it will perform. But it is highly predictive because collections behavior is driven by the tenant base and the market, both of which change slowly. A property with a 94% collections ratio is unlikely to jump to 98% without a significant change in management practices, tenant screening criteria, or market conditions. The buyer's pro forma should use the historical collections ratio as the starting point for the bad debt assumption, not the industry average.

Bad Debt Reserve Methodology

Bad debt reserves in the pro forma serve as an allowance for uncollectable rent. The reserve is expressed as a percentage of scheduled GPR (or, less commonly, of effective gross income) and is deducted from income before arriving at net operating income. The appropriate bad debt reserve depends on the property type, tenant profile, and market:

The test for an appropriate bad debt reserve is whether it is consistent with the property's actual historical collections experience. A seller who presents a pro forma with a 0.5% bad debt reserve on a workforce multifamily property with a 94% historical collections ratio is understating bad debt by a factor of four. The buyer should replace the seller's reserve with one that reflects the trailing-twelve-month collections performance, adjusted for any anticipated improvements in management or tenant screening.

One additional consideration: bad debt reserves and concession costs are sometimes conflated in the pro forma. A property that shows 1% bad debt and 0% concessions, but whose reconciliation delta is 8%, is likely burying concession costs inside the bad debt line or not accounting for them at all. Separate the two. Bad debt is rent that was billed and never collected. Concessions are rent that was never billed because the tenant was offered a discount or free period. Both reduce income, but they have different causes and different remedies.

A Systematic Screening Framework

Rent roll analysis is most effective when performed as a structured sequence rather than an ad hoc review. The following five-step framework, adapted from American Ventures' guide to reading rent rolls and operating statements, provides a repeatable process that catches the majority of rent roll issues within the first two hours of diligence.

Step 1: Completeness Check (15 minutes)

Before analyzing the data, verify that the data is complete. Confirm the as-of date is within 30 days of the analysis date. Confirm that every leasable unit or suite appears on the rent roll (cross-reference against the property's unit inventory or floor plan). Confirm that the 15 core fields are populated for every row. Flag any blank fields. If the rent roll is missing lease dates, security deposits, or concession data, send a data request to the seller before proceeding.

Step 2: Reconciliation to T-12 (30 minutes)

Calculate the rent roll's scheduled GPR by summing all contract rents and annualizing. Compare this figure to the T-12 operating statement's total rental income line. Compute the reconciliation delta as a percentage of scheduled GPR. If the delta exceeds 5%, decompose it into vacancy, concessions, bad debt, and collections loss. This step reveals whether the rent roll's income representation matches the property's actual financial performance.

Step 3: Lease-Level Analysis (45 minutes)

Sort the rent roll by contract rent per unit (or per square foot) and identify outliers: units renting at more than 10% above or below the median. Sort by lease start date and flag tenants who signed within 90 days of listing. Sort by lease end date and build the expiration schedule. Calculate the MTM concentration. Identify the top five tenants by rent contribution and assess concentration risk. For commercial properties, review the expense structure (NNN vs gross) for each tenant.

Step 4: Red Flag Screening (30 minutes)

Run through the 12 red flags listed in this article. For each flag, note whether it is present, its severity (informational, investigate, or deal-breaker), and the follow-up action required. Document findings in a standardized format so that the investment committee can review the screening results alongside the financial model.

Step 5: Market Rent Comparison (30 minutes)

Pull comparable rents from at least three competing properties (or from a data provider). Calculate the mark-to-market exposure for the entire rent roll. Tag each lease as below-market, at-market, or above-market. Summarize the net mark-to-market position and identify the leases whose expirations will most impact the go-forward rent growth assumption.

Analyze It in Apers

Related Articles

• Due Diligence Checklist by Asset Class. The complete institutional DD checklist, organized by asset class, with the rent roll analysis steps embedded within the broader diligence workflow.
• Operating Statement Normalization and T-12 Adjustments. The companion analysis to rent roll review. How to normalize the T-12 operating statement by removing one-time items, adjusting for management fees, and reconciling expense categories to produce a stabilized NOI.
• Multifamily Underwriting Fundamentals: The Rent Roll. The asset-class-specific deep dive into multifamily rent roll analysis, including unit mix optimization, loss-to-lease calculations, and renewal probability modeling by unit type.
• Below the Line: TI, LC, CapEx, and Reserves. How the rent roll's lease expiration schedule drives below-the-line capital expenditure projections for tenant improvements, leasing commissions, and capital reserves at each rollover event.
• Renewal Probability and Rollover by Tenant Type. How renewal probabilities by tenant type affect the lease expiration schedule analysis and the expected vacancy at each rollover event in the pro forma.