Multifamily Underwriting Fundamentals: The Rent Roll Reading Exercise

Key Takeaways

The Rent Roll Is the Bible

Multifamily underwriting begins where every institutional acquisition begins: with a seller's rent roll open in the next tab and a T-12 open underneath it. Of the dozen documents that arrive in a multifamily diligence package — financial statements, lease files, operating budgets, utility allocations, payroll registers, comp shops, environmental reports, capex schedules, tax bills — the rent roll is the only one that tells you what is happening at the property right now. The T-12 is backward-looking. The pro forma is forward-projected. The rent roll is the snapshot, and the institutional discipline is to trust nothing in the sponsor's pro forma until you have read the rent roll back to it.

The reading is harder than the SERP suggests. Most published walkthroughs treat the rent roll as one of fifteen items on a due-diligence checklist; the institutional reading treats it as the central artifact and walks it column by column, line by line. Current rent is not market rent. Scheduled rent is not effective rent. Physical occupancy is not economic occupancy. Twelve of the fifteen failure modes that produce a deal-killer at IC are visible on the rent roll if you know where to look — and only on the rent roll, because the sponsor's pro forma has already smoothed them out.

This article is the rent-roll reading exercise. You will work the columns, the four-rent disambiguation, the physical-vs-economic gap, the 15-flag taxonomy, the T-12 reconciliation, and a worked 200-unit Sun Belt garden-style value-add against the 2026 rate environment. The audience is the institutional acquisitions analyst with a live deal, the multifamily VP stress-testing analyst work before IC, the debt broker translating a Yardi rent roll into Fannie's Form 4090, and the asset manager running variance analysis at month 18. By the end, the cascade from the rent roll to the underwritten Year 1 NOI to the stabilized exit value is reproducible by hand from inputs disclosed on the page.

Anatomy of the Multifamily Rent Roll

An institutional-grade rent roll — whether exported from Yardi Voyager, AppFolio, RealPage OneSite, Entrata, or formatted to Fannie Mae's Form 4090 standard — has the same eighteen columns. The reading exercise is the same regardless of source system. The columns that matter, in the order they typically appear:

• Unit number. Identifies the unit physically. Cross-checks to the rent roll's unit count vs the property's gross unit count (model units, employee units, and amenity units sometimes carry separate identifiers and should not appear here).

• Unit type / floorplan. Studio, 1BR/1BA, 2BR/2BA, 3BR/2BA. The institutional reading groups the rent roll by unit type and computes rent-per-square-foot and rent-per-unit by floorplan. Loss-to-lease is read by floorplan, not in aggregate — one floorplan can be at market while another is 18% below.

• Square footage. Drives rent-per-square-foot, the comp-set normalization metric. Watch for square footage variance within the same floorplan — sometimes 2BR/2BA "A" units are 50 SF smaller than 2BR/2BA "B" units and command 4–6% lower rent. The roll should disclose this; if it doesn't, the marketing site usually will.

• Tenant name. Watch for blanks (vacant), "VACANT" or "DOWN" coding, "EMPLOYEE" or "MODEL" coding, and duplicate names across units (a household occupying two units, a friends-and-family discount that won't survive ownership change).

• Lease start date and move-in date. The two are usually the same but not always. A cluster of move-ins in the 60–90 days before listing is the single highest-frequency red flag in the taxonomy — the seller filled vacancies to juice occupancy heading into marketing. Cross-check the application standards and the security deposit ledger for those leases.

• Lease end date. The lease expiration ladder. Stack the end dates by month over the next 24 months and look for clustering. A flat distribution is normal; clustering in months 1–6 of the hold is execution risk; >25% month-to-month is a red flag.

• Lease status. Current, past-due, NSF, eviction filed, notice given. NSF and past-due coded as "current" is rent roll fraud; cross-check to the bank statement deposits and the age-receivable report.

• Current rent (in-place rent). The contractual monthly rent the tenant is obligated to pay today. Not necessarily what they paid last month (if there was a partial payment) and not what they will pay next month (if there is a scheduled step). This is the column the institutional Year 1 in-place NOI is built from.

• Market rent. The rent the unit could command if released today, per the property management company's market-rent schedule. This is sponsor-supplied and pressure-tested against a third-party comp set (Yardi Matrix, CoStar, Apartments.com, direct shops). See the cap rate calculator article for how this rolls into valuation.

• Scheduled rent / contractual escalations. If the lease has rent steps (e.g., $1,400/mo for months 1–6, $1,450/mo for months 7–12), this column records the next-step rent. Important for properties with annual escalators or initial promotional rates.

• Effective rent. Current rent minus the amortized value of concessions over the lease term. A unit with $1,400 current rent and two months of free rent on a 14-month lease has effective rent of $1,400 × (12/14) = $1,200, not $1,400. The lender's stress test uses effective rent.

• Concessions. Months free, gift cards, reduced rent during the lease, "look-and-lease" promotions. Concessions that are recorded as side letters (not on the rent roll) are the most common seller-side manipulation in oversupplied submarkets — you confirm by comp-shopping the property's own marketing listings on Apartments.com and Zillow Rentals.

• Security deposit. The institutional minimum is one month's rent; sub-floor deposits signal weak application standards or unrecorded concessions. Cross-check to the deposit ledger and the state minimum.

• Other / ancillary income by unit. Parking ($25–$200/mo per assigned space), storage ($25–$75/mo), pet rent ($25–$50/pet/mo), pet fee (one-time $250–$500), RUBS recovery (utility billback, typically $40–$90/unit/mo), application fee, late fee, valet trash, amenity fee. Ancillary income runs 5–12% of total revenue at a Class-B garden-style property and is a frequent source of seller-side inflation in the year before listing.

• Move-out notice / future vacancy. Units where notice has been given but the tenant has not yet moved out. Cross-check to the leasing pipeline and the renewal letters; high notice volume in the 60 days pre-close is a renewal-failure signal.

• Past-due balance / arrears. The amount owed by the tenant as of the rent roll date. Workforce properties run 1–3% in arrears at any given snapshot; Class A runs <1%. Significant arrears on units coded "current" is rent roll fraud.

• Lease type / addenda. Standard 12-month, 6-month, month-to-month, corporate housing, Section 8 / HCV, employee. Each carries different turnover, renewal, and bad-debt assumptions.

• Renewal status. Whether the current lease is a new lease, renewal at face, renewal with rent increase (and at what %), or renewal at a discount. The renewal trade-out percentage is the single best forward indicator of the property's rent-growth trajectory.

The columns above are the structured surface. The reading happens in the cross-checks: rent roll to T-12, rent roll to bank statements, rent roll to lease files, rent roll to comp set. The Yardi × Fannie Mae Rent Roll Digitizer pilot and the 2025–2026 cohort of AI rent roll standardization vendors (Slung, redIQ, RealQuant, PropRise) all exist because the unstandardized rent roll is a 1–2 hour workflow tax per deal — before the actual reading even begins.

The Four Rents: Current, Market, Scheduled, Effective

Four distinct rents appear on every institutional rent roll, and they answer four different questions. The single most common analyst mistake is reading them as synonyms.

Table 1. The four rents that appear on an institutional rent roll. Loss-to-lease is the spread between current and market; the value-add upside is the spread between effective and market.

A worked unit: 2BR/2BA, 1,050 SF, garden-style Sun Belt vintage 1996. Current rent $1,400. Market rent $1,650. Scheduled rent $1,450 (a one-step escalation kicks in at month seven of the lease). Effective rent $1,317 (the tenant received two months of free rent on a 14-month lease, so the face $1,400 amortizes to $1,400 × 12/14 = $1,200 for the concession period, blending to $1,317 over the lease term). Each number answers a different question. The institutional underwriter uses current to build Year 1 in-place NOI, market as the loss-to-lease ceiling and the value-add upside, scheduled to forecast the rate of change over the next four quarters, and effective for the lender's stress test (Fannie and Freddie both underwrite to effective rent on agency take-outs — see the agency-debt overlay in Section 10).

Loss-to-lease is the percentage gap between current rent (the rent roll's in-place column) and market rent (the PM's market schedule, validated by third-party comps). On the worked unit: ($1,650 − $1,400) ÷ $1,650 = 15.2%. That is at the high end of the value-add band. Read across all 200 units by floorplan, not in aggregate — loss-to-lease at a property level can mask a 22% gap on 2BRs and a 3% gap on 1BRs.

Physical vs Economic Occupancy and the Four-Number Income Leak

Physical occupancy is occupied units divided by total units. Economic occupancy is collected revenue divided by gross potential rent. A property reporting 97% physical can be running 88% economic, and the difference is the four-number income leak: loss-to-lease, concessions, bad debt, and economic vacancy (which is a function of physical vacancy plus down units plus non-revenue units). The institutional waterfall is built from gross potential rent to effective gross income through those four lines.

Table 2. The four-number income leak from Gross Potential Rent to Effective Gross Income, with institutional ranges by deal strategy.

The institutional reading: read your way down the waterfall and ask whether each line sits in its band. A stabilized core property with 18% loss-to-lease is not stabilized core — either market rent is overstated (the comp set was cherry-picked) or the asset is sick (something operational is blocking repricing). A workforce value-add property with 0.4% bad debt has been scrubbed; T-12 bank statements will show the actual collections. The Fannie Mae underwriting floor on vacancy is 5% even on a 100%-occupied building — this is the 90% sustained for 90 days requirement in the Fannie Multifamily Selling and Servicing Guide.

The physical-to-economic gap is the diagnostic. A 2–5% gap is healthy; 7–12% indicates either pricing weakness (loss-to-lease and concessions running hot) or collections weakness (bad debt and arrears running hot). A gap above 12% is a deal-stage red flag and almost always tracks to one of the fifteen items in the taxonomy in the next section.

The Lease Expiration Ladder

The lease-end-date column, when stacked by month, is a rollover ladder. Pull it into a histogram of expirations by month over the next 24 months and inspect the distribution. Three patterns matter.

A flat distribution. Roughly 1/12th of the leases expire each month over the trailing twelve months and forward twelve months. This is the institutional ideal — rollover risk is diversified and the leasing team has consistent demand to manage. Nothing to flag.

Clustering in months 1–6 of the hold. If 30–40% of leases roll in your first six months as owner, that is execution risk. You are absorbing the entire property's lease-up risk in your Year 1 underwriting. For a value-add deal where the business plan calls for renovating and re-leasing, this can be a feature — you want the rollovers to time with renovation milestones. For a core acquisition, it is a Material concern. Cross-check renewal letters issued in the 60 days pre-listing; if the seller stopped issuing renewals to keep the leases short, the cluster is artificial.

>25% month-to-month concentration. Month-to-month leases pay face rent but renew at will and can non-renew at will. Above 25% of the building, the rent roll is showing either (a) the seller has been releasing aggressively at face rates with month-to-month flexibility to keep optionality, or (b) the asset has high voluntary turnover that the seller has not absorbed into 12-month signings. Underwrite month-to-month tenants at a 30–50% non-renewal rate over the first six months — the rent roll forward is materially noisier than the current snapshot suggests.

On value-add specifically: a high month-to-month concentration can be desirable because it gives the new owner the flexibility to non-renew during a renovation rollout without bearing eviction costs. The value-add renovation premium modeling article walks the renovation scheduling math; for the purposes of reading the rent roll, the institutional discipline is to model month-to-month rollover explicitly into the Year 1 leasing pipeline.

The 15-Flag Institutional Red-Flag Taxonomy

The red-flag taxonomy is the differentiator. Most published walkthroughs list three to seven red flags conversationally; the institutional reading uses a structured table that maps every flag to the rent roll column where it surfaces, the cross-check document that confirms or refutes it, the severity grade (A = Diligence Item, B = Material Concern, C = Deal-Killer), and the specific underwriting adjustment that follows. The fifteen flags below cover roughly 90% of the rent roll manipulation playbook used by seller-side brokers on value-add multifamily listings.

Table 3. The 15-flag institutional red-flag taxonomy. Grade A = Diligence Item (price into a buffer); B = Material Concern (specific underwriting adjustment); C = Deal-Killer (renegotiate or walk). Roughly 90% of seller-side rent roll manipulation surfaces in one of these fifteen patterns.

The reading discipline: build the table as a checklist for every deal, walk the rent roll once with the checklist open in the second tab, and tag every flag with the column, the cross-check, the grade, and the specific dollar adjustment. A clean rent roll has zero Cs and at most one or two As. A typical value-add rent roll has two or three Bs and one or two As. A rent roll with three or more Cs is a renegotiate-or-walk conversation with the broker.

The seller-side games are not theoretical. The recurring patterns the institutional acquisitions desk sees on Sun Belt value-add listings in 2025–2026: filling vacancies in the 60 days before listing with employees and friends-of-employees at face rent, signing 14-month leases with two months free that are coded as 12-month leases at face rent on the rent roll (the side letter doesn't make the spreadsheet), recording NSF and partial payments as "current," using "model" and "employee" coding to hide non-revenue units in the occupancy count, and inflating RUBS and pet rent ancillary income in the 12 months pre-listing to support an EGI growth narrative. Each is visible on the rent roll if you read the columns against the cross-check documents. See CRE Daily and the LA Metro Home Finder rent roll red flags piece for additional operator-side perspectives.

T-12 → T-3 → Year 1 → Stabilized → Exit Reconciliation

The institutional cascade is five discrete reads, each proving something different. The discipline is to walk the cascade in order: T-12 first (what was collected), T-3 next (what is the most-recent run rate), rent roll forward 90 days third (what is currently contracted), underwritten Year 1 fourth (the institutional projection), stabilized Year 3 fifth (the business plan target), exit sixth (the disposition assumption).

• T-12. The trailing twelve months of actuals from the income statement. This is the backward-looking benchmark and the primary collections reconciliation against the rent roll. Read it line by line: GPR, vacancy loss, concessions, bad debt, EGI, OpEx by line, NOI. Cross-check to the bank statements (deposits should reconcile to EGI minus refunds and security deposits). The T-12 is the only number the seller cannot easily manipulate — the bank statements are the receipts.

• T-3 (or T-1 annualized). The most-recent three months annualized, or the most-recent single month annualized. The T-3 captures the run rate after any recent repricing, lease-up momentum, or seasonal vacancy. If T-3 annualized is materially above T-12 (10%+), the property is on an upward trajectory and Year 1 underwriting can lean toward T-3. If T-3 is materially below T-12, the property is softening and Year 1 should mark to T-3. The institutional discipline is to use the worse of T-12 and T-3 for the underwritten base, not the better.

• Rent roll forward 90 days. Take the current rent roll, apply the next 90 days of leasing pipeline (renewals, new leases, move-outs, scheduled rent steps), and produce the forward 90-day in-place revenue run rate. This is the income base. The cascade question: does the rent roll forward run rate match the T-3 annualized? If yes, the rent roll is clean. If the rent roll forward is materially higher than T-3 (sponsor has been releasing aggressively and the T-3 hasn't caught up yet), you have evidence of upside. If the rent roll forward is materially lower than T-3 (the T-3 was juiced by ancillary or one-time items), Year 1 should mark to the rent roll forward.

• Underwritten Year 1. The institutional overlay. Take the rent roll forward as the revenue base. Mark current rents to market over the leasing schedule (typically 50% of loss-to-lease is recaptured in Year 1 via lease expirations; 50% is recaptured in Year 2). Layer concessions per the submarket (zero in stabilized prime, 2–6% in lease-up or oversupplied). Hold bad debt at the institutional floor (2–3% for workforce; 1–1.5% for Class A/B+). Underwrite vacancy at 5–7% economic (Fannie floor is 5%; the institutional analyst should add 1–2% for safety). Apply operating expenses at the institutional benchmark ($8,500–$9,500/unit/year all-in for garden-style 1990s vintage in 2026, per recent IREM and NMHC operating-expense surveys). Land on underwritten Year 1 NOI.

• Stabilized Year 3. The business plan target. For a core deal, stabilized = Year 1 + 2–3% NOI growth annually. For a value-add deal, stabilized = post-renovation, post-repricing, post-concession-burn-off NOI; the renovation premium and rent uplift are modeled in the value-add renovation premium article. The stabilized NOI is what the exit is computed on.

• Exit. Stabilized NOI capped at the exit cap rate (NCREIF + 50–75 bps for the 5-year forward exit assumption in 2026). The exit value drives the equity multiple and the back-end IRR.

The discount cascade: a disciplined Year 1 NOI lands at 90–95% of T-12 NOI on a clean rent roll (after marking current to market, layering concessions, and applying institutional floors). On a rent roll with material red flags, Year 1 lands at 80–90% of T-12 — the 5–10% adjustment is the sum of the flag-by-flag underwriting adjustments in the taxonomy table.

Worked Example: 200-Unit Sun Belt Garden-Style Value-Add

The deal is the kind that arrived in volume on 2026 acquisition desks as MBA's forecast of +16% multifamily originations played out and Sun Belt sellers came back to market. The setup, before reading the rent roll:

The rent roll opens in front of you. You read it column by column with the 15-flag taxonomy as a checklist. Five flags surface:

• Flag #1: pre-listing move-in cluster (B). 22 of the 200 units (11%) have lease start dates in the 90 days before the property went to market. All 22 at face rent. Cross-checking the Apartments.com listings cached from those weeks: the property was running a "2 months free on 14-month lease" promotion. 15 of the 22 leases have side letters with two months of free rent — face $1,400 amortizes to effective $1,200. Adjustment: mark those 15 units to effective rent (−$36K Year 1 GPR). Underwrite the cohort at 40% non-renewal in Year 1.

• Flag #3: employee units coded "occupied" (B). 9 units carry "EMPLOYEE" in the tenant name field but show current rent of $1,200–$1,300. Cross-checking payroll: the units are non-revenue (rent abatement is an employee benefit). The PM agreement caps employee units at 4 (2% of total). Adjustment: re-code 5 units to non-revenue immediately (−$78K GPR); budget the remaining 4 as continuing employee units (institutional benchmark).

• Flag #2: month-to-month concentration (B). 14 units on month-to-month leases, all at face rent. The lease end column is blank. Adjustment: underwrite 8 of the 14 (57%) as non-renewal in Year 1; consistent with the value-add renovation rollout (you want the rollover for the rehab schedule anyway).

• Flag #7: loss-to-lease vs comp set (B). Sponsor claims 12% loss-to-lease against a market rent of $1,650 for 2BR/2BA. Fresh comp set from Yardi Matrix on three competing properties in the submarket: trade-out market rent on 2BR/2BA is $1,580, not $1,650. Adjustment: market rent is overstated by 4%; true loss-to-lease is 10%, not 12%. Reduce Year 1 mark-to-market by $90K of upside.

• Flag #11: ancillary income spike (B). Total ancillary income on the T-12 is $480K (12.5% of GPR), up from $310K (8.6%) on the T-24. The PM introduced a $35/unit/mo valet trash fee and a $25/unit/mo amenity fee in the 12 months pre-listing. Adjustment: hold ancillary at the T-24 average ($310K), not T-12 (−$170K Year 1 EGI).

The institutional reading then assembles the disciplined Year 1:

Table 4. Sponsor pro forma vs disciplined Year 1 NOI on the 200-unit Sun Belt value-add. Five flags account for $450K of Year 1 NOI adjustment — 21% lower than the sponsor's number.

The disciplined Year 1 NOI lands at $1.7M — 15% below T-12 NOI and 21% below the sponsor's pro forma. From here, the value-add execution lifts the property to stabilized Year 3:

• Renovation program: 75% of units (150 units) renovated over 24 months at $14K/door interior = $2.1M capex; rent uplift $200/unit on renovated units at month of completion
• Rent growth on unrenovated: 3% annual on the remaining 25%
• Ancillary recovery: after a year of operational stability, ancillary climbs back to $400K (10% of GPR) by Year 3
• Stabilized Year 3 NOI: $2.8M
• Exit Year 5 at 5.75% cap rate (NCREIF Q3 2025 core/core-plus + 75 bps for 5-year forward exit): $48.7M
• Equity check at disciplined Year 1: $40M purchase + $2.1M capex + $1.0M closing = $43.1M total; agency take-out at $28M after stabilization (1.25x DSCR / 75% LTV against the $48.7M exit appraisal); equity check $15.1M
• Levered IRR: ~14% (vs the sponsor's claimed 18.5%) — honest, defensible at IC

The discipline matters because the 18.5% sponsor IRR is built on a Year 1 NOI that the rent roll does not support. The 14% disciplined IRR is built on a Year 1 NOI that the rent roll, the T-12, and the bank statements all confirm. The decision at IC is whether 14% clears the firm's hurdle — not whether the sponsor's 18.5% is achievable. For levered return mechanics on top of this, see cash-on-cash return: levered vs unlevered.

Loss-to-Lease, Economic Vacancy, and Concession Burn-Off

Three concepts that institutional and retail underwriting treat differently. Each is a place where a sponsor's pro forma overstates the case and the institutional reading marks back to discipline.

Loss-to-lease as upside vs loss-to-lease as warning. Retail underwriting reads a 12% loss-to-lease as 12% of recoverable upside — the assumption being that market rent is correct and in-place rent will close to it over the leasing schedule. Institutional underwriting reads loss-to-lease as the gap that requires interrogation: is market rent overstated (the comp set was cherry-picked) or is the asset blocked from repricing (rent regulation, weak demand, soft submarket)? The discipline is to pressure-test market rent against a third-party comp set (Yardi Matrix, CoStar, Apartments.com, direct shops) before treating loss-to-lease as upside. On the worked deal: stated 12% became audited 10%; on average, sponsor-quoted loss-to-lease over-states by 1–3 percentage points across Sun Belt value-add listings.

Economic vacancy as the diagnostic. Physical vacancy is the units that are empty and visible on the walk; economic vacancy is the difference between gross potential rent and effective gross rental income. The gap between physical and economic occupancy is the diagnostic for asset health. A 2–5% gap is healthy. A 7–12% gap indicates either pricing weakness (loss-to-lease and concessions running hot) or collections weakness (bad debt and arrears running hot). Above 12% — deal-stage red flag, cross-reference flag #15 in the taxonomy. Fannie Mae and Freddie Mac both underwrite to a 5% vacancy floor (90% sustained for 90 days per the Fannie DUS program and the Freddie Optigo program); the institutional underwriter should add 1–2% above the lender floor for buffer.

Concession burn-off. A concession is "burning off" when the lease at a face rent above the current effective rent renews or expires and is replaced at face rent with no concession. Sponsors routinely model concessions burning off in Year 2 with no supporting evidence — the institutional discipline is to tie burn-off to specific evidence: a renovation milestone (the unit is brought to a higher product tier), a supply-pipeline absorption (the submarket's new deliveries lease up and reduce concession pressure), or a renewal at face with no concession. Without specific evidence, hold concessions flat. On the worked deal: 22 pre-listing leases with two months free will roll off as those leases expire in months 12–14 of the hold — if the renovation is on schedule, the units can be re-leased at market with no concession; if the renovation slips, concessions persist. The model both paths.

2026 Rate Environment and Agency-Debt Overlay

The 2026 macro frame matters because the rent roll's revenue is being underwritten against a debt cost that resets the whole leverage equation. The numbers as of Q1 2026:

• Cap rates. NCREIF NPI Q3 2025 recorded multifamily core/core-plus implied cap rates at 4.94% — the lowest tier of the cycle. MSCI/RCA Q1 2026 reported apartment transaction cap rates averaged 5.75%, up 10 bps YoY (see MSCI Real Capital Analytics). CRE Daily and CBRE consensus forecast a 5.31% multifamily cap by year-end 2026 as credit conditions ease.

• Agency caps expanded. The FHFA set 2026 multifamily loan-purchase caps at $88B for Fannie Mae and $88B for Freddie Mac ($176B combined, +20% YoY), with the workforce-housing carve-out excluded from the caps. Agency capacity is materially expanded vs the 2024–2025 ceiling. The DUS program and the Optigo program are the primary take-out paths.

• Rates. Per FRED 10-year Treasury in the 4.0–4.5% range through Q1 2026; SOFR at the FRED SOFR series sitting in the 4.3–4.5% zone; average fixed agency rates for 7–10 year permanent loans around 5.3% with multifamily spreads at 142 bps.

• Volume. The MBA Multifamily Originations Survey forecasts multifamily volume +16% YoY in 2026; CREF +24%. Transaction volume is thawing; acquisitions desks are seeing rent rolls again after the 2024 freeze.

• NOI growth. NCREIF residential sector showed −0.9% sequential NOI growth in Q3 2025 — the rent roll captures revenue forward, the T-12 captures it backward, and they will diverge meaningfully in a softening market. The institutional discipline is to mark the worse of the two.

For the worked deal: agency take-out at $28M / 5.30% / 30-year amortization / 24-month IO at the front / 1.25x DSCR / 75% LTV against the $48.7M exit appraisal. The agency take-out is what makes the value-add business plan financeable at the exit. Bridge or balance-sheet debt during the value-add execution period; agency take-out at stabilization. See CMBS conduit vs SASB for the comparable conduit alternative on assets that don't qualify for agency.

Five Mistakes Practitioners Make

• Misinterpreting loss-to-lease. Treating it as a sign of upside when it is often a sign that comp rents are overstated. The discipline is to pressure-test market rent against a fresh third-party comp set (Yardi Matrix, CoStar, Apartments.com, direct shops) before underwriting the loss-to-lease as recoverable. Sun Belt value-add listings in 2025–2026 routinely overstate market rent by 4–6%.

• Ignoring concession burn-off. Underwriting concessions as zero in Year 2 without supporting evidence is a chronic sponsor pro forma habit. The discipline is to tie burn-off to specific evidence — renovation milestones, supply-pipeline absorption data, renewal evidence. Without evidence, hold concessions flat through the lease expiration roll.

• Missing economic vacancy. Reading the headline physical occupancy of 95% and underwriting at the implied 5% physical vacancy is a deal-stage error. The discipline is to always reconcile physical to economic and underwrite to the economic floor (Fannie 5% + institutional buffer 1–2%). The 7–12% physical-to-economic gap on workforce properties is normal; missing it underwrites $200K+ of phantom revenue.

• Conflating the T-12 with the rent roll potential. The T-12 captures what was collected; the rent roll captures what is currently contracted. A property that has been repricing aggressively in the last quarter will show a T-12 that materially understates Year 1 in-place; a property that has been losing tenants will show a T-12 that overstates the rent roll forward. Always compute both and use the worse for the underwritten base unless evidence supports leaning to the better.

• Not walking the lease files. The rent roll is the summary; the leases are the source. Pull a 10–20% sample of leases and reconcile to the rent roll line by line. Discrepancies between the rent roll and the lease are common and almost always favor the seller: concession side letters not on the rent roll, scheduled rent steps not applied, security deposits below state minimum, lease termination dates that don't match the stated lease term.

From Rent Roll to Institutional Pro Forma

The reading exercise above is the institutional discipline; the modeling step is what consumes that discipline. Once you have walked the rent roll, marked the five flags, and produced a defensible disciplined Year 1 NOI, the next step is the institutional pro forma — debt sizing, value-add capex timing, stabilized exit, levered returns. We know you can build this in Excel from the inputs disclosed above; the reader can do it in Apers within minutes.

Related Articles

• Rental Property Pro Forma Calculator — the structured pro forma that consumes the rent roll discipline.
• Value-Add Multifamily: Renovation Premium Modeling — the renovation capex and rent-uplift mechanics for the worked deal.
• Cash-on-Cash Return: Levered vs Unlevered — the levered yield mechanics the pro forma feeds into.
• Cap Rate Calculator and Formula — the exit-value math that closes the cascade.
• CMBS Conduit vs SASB: Defeasance and Yield Maintenance — the conduit alternative to the agency take-out covered in Section 10.

FAQ