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 a checklist suggests. A checklist treats 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. Many of the 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 a lender's rent roll template, and the asset manager running variance analysis at month 18. By the end, the underwritten Year 1 NOI is reproducible by hand from inputs disclosed on the page, and the later years of the cascade are carried as labeled illustrative assumptions.

Anatomy of the Multifamily Rent Roll

An institutional-grade rent roll - whether exported from Yardi Voyager, AppFolio, RealPage OneSite, Entrata, or formatted to a lender's rent roll template - has the same nineteen 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 a leading 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 articlefor 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. Lenders deduct concessions when they underwrite income.

• 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 a seller-side manipulation to check for 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, storage, pet rent, pet fee, RUBS recovery (utility billback), application fee, late fee, valet trash, and amenity fee. Each has its own fee schedule by property; the rent roll should tie to it. Table 2 carries illustrative ancillary bands of 5–12% of GPR, and ancillary income 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. Compare the arrears total to the bad-debt line on the T-12; the two should tell the same story. 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 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,200 (the tenant received two months of free rent on a 14-month lease: 12 × $1,400 ÷ 14 = $1,200, before the month-seven step). 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 income underwriting (Fannie Mae's underwritten net cash flow deducts concessions from gross potential rent; see the agency-debt overlay below).

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 illustrative ranges by deal strategy. The total rows are the sum of the component ranges at their extremes (for example, core EGRI low end = 100 − 5 − 2 − 7 − 1.5 = 84.5%), so the components do not all hit an extreme at once. GPR here is the sum of market rent; Fannie Mae's GPR is in-place rent for occupied units plus market rent for vacant units.

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. TheFannie Mae Multifamily Guide(Section 203.01, Underwritten Net Cash Flow) requires underwritten physical vacancy, concessions, and bad debt to total at least 5% of GPR, or the shortfall implied by trailing 3-month net rental collections if that is greater. Section 107 separately requires 85% physical and 70% economic occupancy on the Commitment Date and for the preceding 3-month period.

The physical-to-economic gap is the diagnostic. Here the gap is physical occupancy minus economic occupancy, which isolates the loss-to-lease, concessions, and bad debt lines. Summing the Table 2 ranges gives 1.5–8.5% for core and 9–25% for value-add. A gap toward the top of the band for the strategy indicates either pricing weakness (loss-to-lease and concessions running hot) or collections weakness (bad debt and arrears running hot). A gap above the top of the band 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 (a practitioner assumption, not a lender rule) - 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. Thevalue-add renovation premium modeling articlewalks 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. A conversational walkthrough lists a handful of red flags; 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 are the patterns that recur 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). The underwriting adjustments are practitioner assumptions, not lender requirements.

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. Recurring seller-side patterns to check for on Sun Belt value-add listings: 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 the LA Metro Home Finder rent roll red flags piecefor an additional operator-side perspective.

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

The institutional cascade is six 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 may be on an upward trajectory, but the underwritten base still stays at T-12 unless the rent roll forward supports the higher run rate. 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 (the worked deal assumes 50% of loss-to-lease is recaptured in Year 1 via lease expirations and 50% in Year 2). Layer concessions per the submarket (illustratively zero in stabilized prime, 2–6% in lease-up or oversupplied). Hold bad debt at a conservative floor (the worked deal uses 2.5% for a workforce property). Underwrite vacancy at 5–7% economic (Fannie Mae requires vacancy, concessions, and bad debt to total at least 5% of GPR; the institutional analyst should add 1–2% for safety). Apply operating expenses at a per-unit benchmark (the worked deal assumes $8,500/unit/year all-in for garden-style 1990s vintage, an illustrative assumption). 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 thevalue-add renovation premiumarticle. The stabilized NOI is what the exit is computed on.

• Exit. Stabilized NOI capped at the exit cap rate (the worked deal assumes the 5.0% going-in cap plus 75 bps, an illustrative assumption). The exit value drives the equity multiple and the back-end IRR.

The discount cascade: a disciplined Year 1 NOI lands at an illustrative 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 10–20% 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 arrives on 2026 acquisition desks as Sun Belt sellers come back to market. The setup, before reading the rent roll (an illustrative deal, with the inputs shown so the Year 1 math can be checked by hand):

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. Because the side letters are not on the rent roll, this is also the flag #5 pattern (concessions on the roll vs the marketing site); it stays a priced adjustment rather than a walk because it is confined to 15 of 200 units (7.5%). Adjustment: mark those 15 units to effective rent (−$36K of Year 1 concessions, amortized: 15 × ($1,400 − $1,200) × 12). Underwrite the cohort at 40% non-renewal in Year 1 (an underwriting assumption).

• 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, removing them from GPR at the corrected market rent of $1,580 (−$95K GPR: 5 × $1,580 × 12 = $94,800); budget the remaining 4 as continuing employee units.

• Flag #2: month-to-month concentration (B). 60 units (30% of the building, above the 25% trigger) are on month-to-month leases, all at face rent. The lease end column is blank.Adjustment: underwrite 24 of the 60 (40%, inside the 30–50% range) 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, which implies average in-place rent of $1,650 × 0.88 = $1,452. 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.2% ($70 on $1,650). Holding in-place rent at $1,452, true loss-to-lease is ($1,580 − $1,452) ÷ $1,580 = 8.1%, not 12%. GPR falls by $70 × 12 × 200 = $168K, and the Year 1 mark-to-market upside (50% of the gross loss-to-lease gap, $475K falling to $307K) shrinks by $84K.

• Flag #11: ancillary income spike (B). Total ancillary income on the T-12 is $480K (12.1% of the $3,960K GPR), up from $310K (7.8%) 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, which explain $144K of the $170K increase (($35 + $25) × 200 × 12). Adjustment: hold ancillary at the T-24 level ($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. Both columns use market-rent GPR (sponsor $1,650, disciplined $1,580 less 5 re-coded employee units) and leave 50% of the gross loss-to-lease gap unrecaptured in Year 1. The flags discussed above and the 7% vacancy and 2.5% bad-debt floors account for $440K of Year 1 NOI adjustment - 20.5% lower than the sponsor's number.

The disciplined Year 1 NOI lands at $1.71M - 14.5% below T-12 NOI ($1,710K ÷ $2,000K = 85.5%) and 20.5% below the sponsor's pro forma. Vacancy, concessions, and bad debt together are $447K, or 12.1% of the $3,697K GPR, well above the 5% Fannie Mae floor. From here, the value-add execution is assumed to lift 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 (150 × $200 × 12 = $360K a year at full run rate)
• Rent growth on unrenovated: 3% annual on the remaining 25%
• Ancillary recovery: after a year of operational stability, ancillary climbs back to $400K (about 10% of GPR) by Year 3
• Stabilized Year 3 NOI: $2.8M, an illustrative business-plan assumption. The levers listed sum to roughly $0.5M of the $1.09M increase over the $1.71M underwritten Year 1; the rest assumes recapture of the remaining loss-to-lease, concession burn-off and broader rent growth, none of which is modeled on this page. The model carries the total as an input.
• Exit Year 5 at 5.75% cap rate (the 5.0% going-in cap plus 75 bps, an illustrative assumption): $2.8M ÷ 5.75% = $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: about 10.3% (vs the sponsor's claimed 18.5%) on a deliberately simple annual cash-flow vector. Inputs: $15.1M of equity at closing; $28M loan at 6.30% from closing as a stand-in for bridge-then-take-out financing, interest-only for 24 months ($1.764M a year) and then amortizing over 30 years ($2.080M a year); NOI of $1.710M in Year 1, $2.255M in Year 2 (midpoint), and $2.8M in Years 3 through 5; sale at the end of Year 5 for $48.7M less the $26.96M remaining balance, with no sale costs. Equity cash flows in $M: −15.1, −0.05, 0.49, 0.72, 0.72, 22.46 (Year 5 includes $21.74M of net sale proceeds). Year 1 NOI covers only 0.97x of the interest-only payment, so equity funds that shortfall.

The discipline matters because the 18.5% sponsor IRR is built on a Year 1 NOI that the rent roll does not support. The roughly 10% 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 that return clears the firm's hurdle - not whether the sponsor's 18.5% is achievable. For levered return mechanics on top of this, seecash-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: the stated 12% becomes 8.1% once market rent is corrected from $1,650 to $1,580, and the recoverable upside shrinks with it.

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 (loss-to-lease plus concessions plus bad debt) is the diagnostic for asset health: 1.5–8.5% for core and 9–25% for value-add on the Table 2 ranges. A gap toward the top of the band indicates either pricing weakness (loss-to-lease and concessions running hot) or collections weakness (bad debt and arrears running hot). Above the band is a deal-stage red flag, cross-reference flag #15 in the taxonomy. Fannie Mae's Guide sets a floor of 5% of GPR on vacancy, concessions, and bad debt combined (Section 203.01); the institutional underwriter should add 1–2% above that 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: the 15 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 2026 context for the worked deal:

• Agency caps. TheFHFA set 2026 multifamily loan-purchase capsat $88B for Fannie Mae and $88B for Freddie Mac ($176B combined), with multifamily loans that finance workforce housing excluded from the 2026 limits. The DUS program and the Optigo programare the primary take-out paths.

• Rates. TheFRED 10-year Treasuryprinted 5.22% on October 8, 2026, while SOFR on theFRED SOFR series was 3.87% as of October 8. Floating-rate bridge debt prices off the lower index, while fixed agency take-outs price off the 10-year. The worked deal assumes a 6.30% take-out coupon, about 108 bps over the 5.22% 10-year (an illustrative assumption).

For the worked deal: agency take-out at $28M / 6.30% (the 5.22% 10-year Treasury plus roughly 108 bps) / 30-year amortization / 24-month IO at the front. At that coupon, annual debt service on the amortizing schedule is about $2.08M, a 1.35x DSCR on the $2.8M stabilized NOI, inside the 1.25x DSCR and 75% LTV sizing constraints 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. SeeCMBS conduit vs SASBfor 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. On the worked deal, a $70 overstatement of market rent ($1,650 vs $1,580) cuts GPR by $168K.

• 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's 5% of GPR for vacancy, concessions, and bad debt combined, plus an institutional buffer of 1–2%). A 9–25% physical-to-economic gap is normal on a value-add workforce property; on the worked deal's $3.96M of GPR, each 5 points of unrecognized gap is $198K of phantom revenue.

• Conflating the T-12 with the rent roll potential. The T-12 captures what wascollected; 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 the 2026 rate environment section above.

FAQ