Rental Property Pro Forma Calculator: A Small-Multifamily Practitioner's Guide

Rental Property Pro Forma Calculator

The default state loads the worked example below: a 12-unit garden walk-up in a secondary market at $1.8M ($150K/door), 70% LTV agency small-loan at an illustrative 7.00% on a 30-year amortization, Year 1 NOI of $135K growing to $175K by Year 5, exit at an 8.00% cap (the 7.5% going-in cap on price plus 50 bps). Edit any input. Outputs recompute live. The DSCR card uses the agency lender basis (NOI less replacement reserves, divided by the amortizing payment) and flags red below 1.25x (fails the agency small-loan floor), amber from 1.25x to 1.35x (sizes, but tight), and green at 1.35x and above.

The Calculator Small-MF Buyers Actually Need

Most free rental property calculators are built for the 1-4 unit retail landlord. A typical one is a single-period cash flow screen, not a multi-period CRE pro forma. It does not run DSCR alongside IRR, does not let you toggle agency small-loan debt against community-bank recourse debt, and does not model an exit cap separate from the going-in cap. The practitioner underwriting a 12-unit, $1.8M garden walk-up in a secondary market needs all of those, and usually ends up rebuilding the math in Excel or paying for software such as PropertyMetrics to get the multi-period version.

This page is the rental property pro forma calculator built for that buyer. The widget below runs a year-by-year operating cash flow grid for a 5-50 unit small-MF acquisition, takes acquisition cost / debt terms / NOI by year / exit assumptions as inputs, and returns levered IRR, MOIC, total profit, average annual cash-on-cash, going-in cap rate, exit-year cap, year-one lender-basis DSCR, and breakeven occupancy live as you edit. Newton-Raphson IRR solver with bisection fallback and standard amortizing-payment debt math: the same cash flow arithmetic an institutional acquisitions model runs. No paywall, no email gate, no PRO tier. Below the widget: the rent-roll-to-IRR walk-through that retail calculators skip, the 2026 debt-sizing decision framework across agency small-loan and community-bank product, the buyer-rotation context that explains who is buying small multifamily in 2026, and the graduate-to flow when the pocket screen passes and you need a full underwrite.

Why Retail Calculators Fail on Small Multifamily

The 1-4 unit retail rental calculator is a different tool answering a different question. It computes a single-period annualized cash flow on a single-family rental, applies a 30-year residential mortgage analog to the debt, treats rent as if it grows on a smooth line, and outputs a cash-on-cash return next to a "1% rule" or "50% rule" pass/fail indicator. For a single-family rental financed with a conventional investor mortgage, that's a reasonable approximation. For a 12-unit garden walk-up with twelve leases on staggered roll, a Fannie Mae Small Loan with DSCR / debt-yield / LTV constraints, a 5-7 year institutional hold, and an exit at a reversion cap that isn't the same as the going-in cap, the retail calculator answers a question you weren't asking.

Six things change at five units. First, the loan changes. You graduate from a residential 30-year fixed (qualifying on DTI) to a commercial small-balance loan (qualifying on DSCR and debt yield): a Fannie Mae Small Loan, Freddie Mac Conventional Small (which replaced Freddie's Small Balance Loan program in April 2026), or a community-bank recourse loan, all with different loan-size minimums, LTV caps, amortization tenors, and rate sheets. Second, the rent roll has structure. Twelve leases on a 12-month-staggered roll behave nothing like a single tenancy that turns once every two years. Third, the operating expense base has line items the retail tool doesn't track: payroll for an on-site manager once the property is large enough to carry one, RUBS utility allocation, and replacement reserves (this article uses $200-$600 per unit per year as an illustrative working range). Fourth, the exit is a cap-rate sale to a next buyer, not an appreciation curve applied to the entry price. Fifth, the relevant return metric is IRR (and MOIC, and DSCR clearance), not cash-on-cash in isolation, which is what the retail tools quote. Sixth, the deal has a multi-year hold with a reversion event that swamps the operating years on contribution to total return.

The institutional version of this calculation is what brokers, lenders, and acquisitions teams have always built in Excel. It is what PropertyMetrics sells behind a SaaS subscription. This page puts it on the open web because the practitioner doing a 12-unit acquisition is the same practitioner who deserves the same tooling the institutional buyer of a 240-unit garden complex has.

What a Rental Property Pro Forma Actually Contains

A rental property pro forma for small multifamily is a six-section document. The retail calculators show you sections three and four. The institutional pro forma carries all six and the relationships between them.

1. Gross Potential Rent. Units × in-place rent × 12 months. For a 12-unit garden walk-up with a $1,650 average in-place rent, GPR is 12 × $1,650 × 12 = $237,600. Other income (utility reimbursement through RUBS, laundry, parking, pet fees, application fees, late fees) sits on top; this article's illustrative working range is 4-8% of GPR for small MF, and the worked example carries $13,800, or 5.8%. The institutional pro forma builds GPR from the rent roll line by line, then normalizes to a stabilized in-place or market rent for Year 1.

2. Effective Gross Income (EGI). GPR plus other income, less vacancy and credit loss. As an illustrative working assumption rather than a published benchmark, this article models stabilized small-MF vacancy plus credit loss at 5-9% depending on submarket and unit mix, with older walk-up product at the higher end; the worked example uses 7% of GPR. Do not take a broker's vacancy figure as given: re-derive it from T-12 occupancy reports and the submarket benchmark.

3. Operating Expenses. Property tax + insurance + repairs & maintenance + management fee + utilities (the portion not reimbursed) + payroll (for properties large enough to carry on-site staff) + general & administrative. This article uses an illustrative working range of 38-48% of EGI for the small-MF expense ratio, depending on the tax burden, the management structure, and the age of the building; the worked example runs at 42.4%. High property-tax jurisdictions push the ratio up. New construction tends to sit lower because R&M is suppressed in the early years; older walk-up product tends to sit higher.

4. Net Operating Income (NOI). EGI minus operating expenses. This is the line the cap rate is computed off; it is what the broker quotes; it is what the next buyer underwrites at exit. NOI does not include debt service, depreciation, or capital expenditures; those are all below-line items in the institutional convention. The going-in cap rate is Year 1 stabilized NOI divided by the all-in basis (purchase price + closing costs + immediate capex).

5. Debt Service. The annual mortgage payment on the acquisition loan. For a 70% LTV Fannie Mae Small Loan at 7.00% on a 30-year amortization on a $1.8M purchase, the loan is $1.26M and the annual debt service is roughly $100,600. Agency small-loan lenders do not test DSCR on raw NOI. Under the Fannie Mae Multifamily Selling and Servicing Guide, Part III, Section 905, underwritten NOI minus a replacement reserve (the greatest of $200, $250 or $300 per unit by property condition rating, or the inspection-based amount) equals underwritten net cash flow, and DSCR is that net cash flow divided by a level, amortizing debt service payment. On the worked example that is ($135,000 − $3,600) / $100,594 = 1.31x at 70% LTV. At 75% LTV the $1.35M loan carries $107,779 of debt service and the ratio falls to 1.22x, below the 1.25x Fannie Small Loan minimum, so 75% does not size. Sized to exactly 1.25x, the DSCR test caps proceeds at about $1.32M, roughly 73% LTV; the worked example takes 70% to leave a cushion above the floor. Agency small-loan product requires 1.25x; some banks will go to 1.20x. Below the floor the deal does not size: the buyer either takes the LTV down or walks.

6. Pre-Tax Cash Flow to Equity. NOI minus debt service minus replacement reserves. This article's illustrative working ranges are $250-400/unit/year for garden small-MF, $400-600/unit/year for older walk-up, and $200-300 for new construction; the worked example uses $300, Fannie Mae's small-loan underwriting minimum for a property with a condition rating of 3. Retail calculators often skip this line; the institutional pro forma always includes it. The pre-tax cash flow to equity is the line the IRR is computed against, plus the reversion event at exit.

Build the same six sections for Years 2 through N with rent growth, expense growth, and (where applicable) a value- add renovation lift that breaks the smooth growth curve. Add a reversion row in the exit year: exit value (Year-N NOI / exit cap) minus selling costs minus loan payoff equals net sale proceeds to equity. That is the cash flow stream the IRR computes against. The fuller treatment of rent-roll-to-NOI construction is in the sibling article on small-MF underwriting fundamentals; the broader cap rate work is in the cap rate calculator pillar.

Walk-Through: A 12-Unit, $1.8M Garden Walk-Up

The widget's default state is a worked example you can reproduce by hand. A 12-unit garden walk-up in a Sunbelt secondary market (think Memphis, Birmingham, Greenville or Tulsa). Asking price $1.8M ($150K/door). Closing costs 2.5% ($45K). Immediate capex $50K (HVAC, parking lot reseal, common-area light fix). All-in basis $1.895M. Equity check at 70% LTV is the all-in basis minus the loan: $1.895M minus $1.26M = $635K of equity at Year 0.

The debt is a Fannie Mae Small Loan at an illustrative 7.00% on a 30-year amortization with no IO. At $1.26M the loan clears Fannie's $1M Small Loan minimum but sits below the $2M floor of Freddie Mac's Conventional Small product, so the realistic executions are Fannie Small or bank debt. The 10-year Treasury rose from about 4.8% to about 5.3% over September 2026, and conventional agency paper prices at roughly 95-195 bps over the index on Northmarq's October 8, 2026 rate sheet, whose Fannie grid excludes loans under $6M (it refers those to a Fannie representative). Small-balance product prices wider: multifamily.loans quoted Fannie Small at 6.10-8.20% in August 2026, and Walker & Dunlop's October 6, 2026 Fannie grid for $2M-$6M loans runs 7.17-8.37% across terms and leverage tiers. The 7.00% coupon therefore sits inside the August band but below Walker & Dunlop's October grid; the +50 bp rate stress in the debt section prices the 7.50% case. A 5-year community-bank loan quoted 6.64-7.64% in August 2026, with recourse options. At the asking 75% LTV, the $1.35M loan would carry $107,800 of annual debt service, and ($135K NOI − $3.6K reserves) / $107.8K is a 1.22x lender-basis DSCR, below the 1.25x agency floor. At 7.00% the DSCR test caps proceeds at about $1.32M, roughly 73% LTV, and the worked example takes 70% LTV to leave a cushion above the floor. Annual debt service on the $1.26M loan is approximately $100,600, for a 1.31x lender-basis DSCR (1.34x on NOI before reserves) and a $34K residual to equity before replacement reserves. The going-in cap rate on Year 1 NOI of $135K against an all-in basis of $1.895M is 7.1%; on the purchase price alone it is 7.5%. Both quotes are useful. The all-in cap measures the yield on every dollar invested; the price cap is the like-for-like comparison for the exit cap, because the exit cap is applied to a gross sale price.

NOI grows from $135K in Year 1 to roughly $175K by Year 5, a 6.7% blended growth rate that absorbs both assumed market rent growth (3-4%) and an assumed value-add light renovation lift (turning unit interiors at $4-6K per turn for a $75-100/mo rent bump on rollover). At Year 5, the property exits at an 8.0% cap: the 7.5% going-in cap on purchase price plus 50 bps, the low end of the value-add convention described in the exit section below. Year 5 NOI of $175K divided by an 8.0% exit cap implies a $2.19M exit value. Less 2% selling costs ($44K), less the year-5 outstanding loan balance ($1.19M after five years of amortization), the net sale proceeds to equity are roughly $958K. Plus the Year 5 operating cash flow of $71K, total Year 5 distribution to equity is $1.03M.

The full cash flow stream to equity:

Punching these into the widget above (or into Excel) returns the headline metrics:

• Levered IRR: 15.0% (Newton-Raphson converges in a few iterations from the 12% guess)
• MOIC: 1.90x ($251K of operating distributions plus $958K of net sale on $635K of equity)
• Total profit: $574K
• Average annual cash-on-cash: 7.9% (operating years 1-5, before exit)
• Going-in cap rate: 7.1% (on all-in basis); 7.5% (on purchase price alone)
• Year 1 DSCR: 1.31x on the lender basis (NOI less reserves over amortizing debt service; 1.34x on raw NOI), clearing the 1.25x agency floor at 70% LTV
• Breakeven occupancy: about 80% ((OpEx $99.6K + debt service $100.6K) / gross potential income $251.4K)

The deal clears the screen this article uses, on a convention exit cap rather than a compression call: going-in cap 7.1% (at or above 6.5%), IRR 15.0% (at or above 14%), lender-basis DSCR 1.31x (at or above 1.25x), breakeven occupancy about 80% (at or below 85%). The margin is thin: the IRR sits about 100 bps above the hurdle, and holding the exit at 7.0% (50 bps of compression) is what turns it into a 20.5% deal on paper. The 2026 fingerprint is the leverage: at a 6.25% coupon a 75% LTV loan would clear at a 1.32x lender-basis DSCR, while at a 7.00% coupon the DSCR test caps proceeds near 73% LTV and the example takes 70%, with a $90K larger equity check than at 75%. This is the deal a 2026 small-MF buyer takes forward into a full underwrite, with two shortfalls flagged at IC: the +100 bp exit-cap result (12.4%, below the 14% screen) and the 15% vacancy stress (1.10x lender-basis DSCR, below the 1.25x floor, and a levered IRR of about 4-6%). It is a cap-rate- and vacancy-sensitive deal. The widget gets you to the screen in ninety seconds. The full underwrite, with the unit-mix rent roll, the lease-roll schedule, the renovation phasing, the exit-cap sensitivity table, and the debt-comparison run across agency, community-bank and CMBS, is what AQ-112 absorbs.

Single-Period vs Multi-Period: Why Retail Tools Miss the Deal

The single-period rental calculator computes Year 1 cash flow and stops. The multi-period pro forma computes the full hold and the exit. On a 5-year small-MF deal, the difference is not academic: it is the deal. For the worked example, Year 1 pre-tax cash flow is $31K, which on a $635K equity check is a 4.9% Year 1 cash-on-cash. A single-period calculator stops there and reports "cash flow positive, looks like a deal." But the Year 1 cash-on-cash is the smallest cash flow contribution to the IRR. The Year 5 reversion event delivers $958K of net sale proceeds, about thirty times the Year 1 operating cash and roughly 79% of all distributions to equity.

The shape of the cash flow stream matters as much as the magnitude. Two deals with the same Year 1 cash-on-cash can produce IRRs that differ by 600-800 basis points based purely on the exit cap assumption and the NOI growth curve between entry and exit. The single-period tool cannot see this; the multi-period tool surfaces it on every input change.

This is why the multi-period frame is the institutional default and the single-period frame is a screen-out filter for the retail cohort. The math doesn't care which tool you're using (the deal either underwrites or it doesn't), but the tool determines whether you see the underwriting correctly. The retail calculator will show you a positive Year 1 on a deal that loses money over the hold (negative leverage on a bridge, an exit cap expansion that swamps the operating gain, a value-add lift that never lands). The pro forma surfaces all three failure modes by Year 5.

The Debt Math: Amortization, IO Periods, DSCR, and the Refi Event

The debt panel in the widget is one of the highest-leverage inputs on small-MF returns. On the worked example, a 50-bp move in the interest rate (7.00% to 7.50%) changes the year-one lender-basis DSCR by ~0.06x (1.31x to 1.24x, just under the 1.25x floor) and the IRR by ~80 bps. A 5-point move in LTV (from 70% to 75%) changes the equity check by ~$90K on a $1.8M deal and the IRR by ~110 bps, but drops the lender-basis DSCR to 1.22x, which does not size. Getting the debt right matters as much as getting the growth rate right.

The debt service formula is the standard amortizing-payment (PMT) formula:

For 2026 small-MF, three loan products cover essentially all the volume. Each has different sizing constraints and different rate sheets:

Small-MF debt-sizing comparison. Agency, bank and Freddie Conventional Small terms and the August 11, 2026 rate bands are from multifamily.loans; the Freddie program change is described on its Freddie Mac small balance page. Fannie Small IO terms are from Walker & Dunlop. CMBS rates and leverage are from the October 8, 2026 Northmarq rate and spread sheet, which also shows the 10-year Treasury at 5.30% and 30-day average SOFR at 3.80%. Daily SOFR history is at FRED.

The choice between agency and community-bank product is the single biggest financing decision a small-MF buyer makes. Agency wins on LTV (80% vs up to 75%) and non-recourse status. On rate, the quoted bands now overlap: the August 2026 multifamily.loans sheet shows Fannie Small at 6.10-8.20% and a 5-year bank loan at 6.64-7.64%. Agency fixed paper prices off a 10-year Treasury that pushed above 5% in late September 2026, while SOFR, at roughly 3.9% after the Fed's September 16, 2026 quarter-point hike, remains well below the roughly 5.3% it averaged from mid-2023 to mid-2024. Community-bank debt wins on speed (typically a faster close than agency execution), flexibility (prepayment terms), and underwriting discretion (a relationship bank can look past a soft DSCR quarter that the agency sizer will not), and it is the execution in the table above that reaches below Fannie's $1M Small Loan minimum. For a value-add deal with a near-term refi plan, community-bank as the acquisition loan and agency as the take-out is a common structure. The bridge-loan article walks through the financing-environment context that pushed buyers toward this barbell strategy in 2025-2026.

The DSCR constraint is the most important sizing test. On agency small-loan product it is underwritten net cash flow (NOI less replacement reserves) divided by a level, amortizing debt service payment, with a 1.25x minimum; some banks will go to 1.20x. Below the floor the deal does not size at the quoted LTV: the lender will require a lower LTV (more equity in) until DSCR clears the threshold. The widget flags this live on the same lender basis: red below 1.25x, amber 1.25-1.35x, green at 1.35x and above. If your deal flashes red, your options are: take LTV down (more equity), take rate down (negotiate or shop), grow NOI before close (renegotiate timing post-stabilization), or walk. There is no fifth option.

The IO period at the front of the loan is a cash-yield booster in the early years. Fannie Small Loan executions offer partial-term and full-term IO on a 30-year amortization schedule. During the IO period, debt service is loan × rate (~$88K/year on the worked example, vs roughly $100,600 amortizing). The extra ~$12K/year flows directly to equity in the IO years, lifting Year 1 cash-on-cash from 4.9% to ~6.8%, but the IRR moves only ~10-20 bps on a 5-year hold (15.0% to 15.1% with one year of IO, 15.2% with three to five). The higher loan balance at exit claws back most of the early cash. Lenders still size DSCR on the amortizing payment, so IO raises cash yield without raising loan proceeds.

The refi event is the third debt-math input that matters. A common small-MF structure: acquire on a community-bank bridge or short-IO agency loan, execute the value-add renovation over 18-24 months, refinance to a 30-year agency loan at the stabilized NOI. The refi pulls equity out (the new loan against the stabilized NOI sizes larger than the original loan against the in-place NOI) and resets the rate to the take-out market. Modeling the refi requires a Year-2 or Year-3 cash inflow equal to (new loan proceeds − old loan payoff − refi closing costs), and a reset of the debt service schedule from that year forward. The widget supports this conceptually by allowing the NOI grid to absorb the lift; AQ-112 supports it explicitly with a separate refi-event row.

Exit Assumptions and the Reversion Cap

The exit cap rate is the single most important assumption in a small-MF pro forma after the in-place NOI. It dominates the IRR because the sale at exit is typically the largest single cash flow in the stream, often 70-85% of total distributions for a 5-year hold (79% on the worked example). At the 7-8% caps used here, a 25-bp change in exit cap moves the implied sale value by 3-4%; a 50-bp change moves it by 6-8%; a 100-bp change moves it by 11-17%. The retail calculators that assume going-in cap equals exit cap are hiding the deal's biggest underwriting choice.

The convention this article applies for the 2026 rate environment (a working rule, not a published standard) is to underwrite exit cap 25-50 bps wider than the going-in cap on price for stabilized small-MF, and 50-75 bps wider for value-add small-MF. The worked example, a value-add light deal, exits at 8.0% against a 7.5% going-in cap on price. The reasoning is structural: the going-in cap rate reflects today's financing environment (10-year Treasury above 5% since late September 2026, after small-balance agency quotes of 6.10-8.20% in August). The exit cap reflects the financing environment 5 years from now, which is unknowable. The conservative position is to assume some expansion; the aggressive position is to underwrite flat caps; underwriting cap compression is a market call that should be argued explicitly at IC.

The exit cap selection also prices the next buyer's required return. The next buyer underwrites the Year 5 NOI against their own cost of capital, so the exit cap should trend toward the going-in cap of comparable deals at the projected exit date, plus an allowance for the building being five years older. The fuller treatment of going-in vs exit cap is in the cap rate pillar.

Selling costs at exit (broker commission, transfer tax, legal, closing costs) are modeled here at an illustrative 2-3% of gross sale price; the widget defaults to 2%. The loan payoff at exit equals the outstanding loan balance at the exit year: for a 30-year amortizing loan at 7.00%, ~94% of the original balance remains at year 5. For an IO loan, 100% remains at year 5. The widget computes the loan balance live from the amortization schedule and nets it against the gross sale to produce net proceeds to equity.

MOIC and IRR diverge at the exit. MOIC is time-blind: it sums total cash returned and divides by equity in. A 2.05x MOIC over 5 years and over 8 years are very different deals: same total cash, different annualized return. IRR is time-weighted. Quote both. A small-MF buyer holding for cash flow first and capital appreciation second cares more about MOIC; a small-MF buyer holding for capital appreciation first cares more about IRR. The fuller treatment ofequity multiple and MOIC is in the returns-analysis cluster.

Sensitivity: Where the IRR Breaks

The institutional discipline that separates the small-MF buyer who survives a cycle from the one who doesn't is sensitivity testing. The base-case IRR is a number; the IRR distribution under stressed inputs is the deal. Five stresses to run on every small-MF pro forma:

Exit cap expansion. Re-run the model with exit cap at the going-in cap on price, going-in + 25 bps, going-in + 50 bps, and going-in + 100 bps. For the worked example (7.5% going-in on price): at 7.5% the IRR is 17.7%; at 7.75%, 16.3%; at 8.0% (the base case), 15.0%; at 8.5%, 12.4%. Underwrite 50 bps of compression to a 7.0% exit and it prints 20.5%. The 100-bp stress is the structural-margin test: if the IRR stays above your cost of equity at +100 bps exit cap expansion, the deal has structural margin. If it doesn't, the deal is a cap-rate-trajectory bet, not an income bet, and the shortfall belongs in the IC memo. The worked example's 12.4% at +100 bps falls below the 14% screen, so it goes forward flagged as a cap-rate-sensitive deal.

Rent growth haircut. Re-run with flat 0%, 1%, 2%, and 3% annual NOI growth from the $135K Year 1, versus the base case's 6.7% blended growth. At the 8.0% exit the worked example IRR falls to about −0.5%, 2.3%, 4.8%, and 7.2% respectively. The base case depends on the value-add lift landing: strip it out to 3% market growth and the IRR drops by about 780 bps, below any of the return bands in the FAQ.

OpEx ratio expansion. Re-run with a 45%, 48%, and 52% OpEx ratio versus the base case 42.4%. Expense ratios can drift up over a 5-year hold as deferred maintenance surfaces and tax burden grows. Applied to every year of the NOI grid at the 8.0% exit, the worked example IRR falls to about 12.1%, 8.4%, and 2.8%. The 52% stress (about +960 bps of expense ratio) is what happens when the buyer underestimated R&M and property tax growth.

Vacancy stress. Re-run with 10% and 15% vacancy versus the base case 7% of GPR. A 15% vacancy stress is the local-market-downturn test. Applying the stressed vacancy to all $251.4K of gross potential income and holding OpEx at $99.6K, the worked example's lender-basis DSCR is about 1.22x at 10% vacancy (1.26x on raw NOI) and about 1.10x at 15% (1.13x on NOI): below lender covenant levels, but still above 1.0x. At 15% vacancy and the 8.0% exit, the levered IRR falls to about 4-6% (the low end if the vacancy loss grows with rents, the high end if it stays flat in dollars), so the deal goes forward flagged as vacancy-sensitive. Cash flow after reserves turns negative at roughly 19% vacancy, and NOI stops covering debt service at roughly 20%, which is the ~80% breakeven occupancy seen from the other side.

Rate-shock refi. If the pro forma contemplates a Year 2 or Year 3 refi event, re-run with the take-out rate at 100, 200, and 300 bps above today's quote. The 300-bp stress is the 2021-2023 stress: buyers who underwrote 3.5% take-outs in 2021 saw 6.5% take-outs in 2023, and a meaningful share of those deals went sideways on the refi. This is the most important stress for any deal with a near-term refi in the pro forma.

The institutional pro forma runs all five as a 2×2 sensitivity grid (exit cap on one axis, rent growth on the other) at minimum, with the OpEx and vacancy stresses as side tables. AQ-112 builds this grid automatically from the input panel. The IRR sensitivity analysis article walks through the construction. The discipline is to publish the sensitivity table next to the base case in every IC memo. The IRR is a distribution, not a number.

The 2025-2026 Small-MF Buyer Rotation

Who is buying small multifamily in 2026? The answer is the most important demand-side context in the small-MF market today, and it explains why retail calculators fall short for the buyers now doing the underwriting.

Between 2020 and 2022, institutional core-plus multifamily funds aggregated small-MF portfolios aggressively. Bridge debt was cheap (3-4% floating), agency take-out was abundant (3.5-4.5% locked), and large funds were running aggregation strategies: buying 5-50 unit deals one or two at a time, holding for 24-36 months, and refinancing into the lower-cost-of-capital portfolio at stabilization. The Apers bridge-loan articlewalks through the financing-environment dynamic that supported this aggregation cycle.

From late 2022 through 2024, bridge debt tightened materially. Floating rates moved from 3.5% to 8-9% as SOFR repriced; bridge lenders pulled back loan-to-cost; the agency take-out at stabilization repriced from 3.5% to 6.0-6.5% (small-balance agency quotes ran 6.10-8.20% in August 2026, before the 10-year Treasury pushed above 5% in late September). The aggregation math broke. A meaningful share of 2021-2022 vintage small-MF aggregations failed to refi cleanly: the take-out debt sized smaller than the bridge payoff at the new rate, and the GP-LP capital stack couldn't bridge the gap without a meaningful equity write-down. Institutional appetite for stabilized small-MF aggregation slowed sharply.

Into that vacuum stepped a new buyer profile: family offices, small-fund aggregators, sophisticated direct buyers, and the LP-individual crossover. The institutional cohort that had been outbidding individuals on every small-MF deal in 2021-2022 stepped back; the small-MF supply that had been getting aggregated into institutional portfolios instead trickled back into the individual-buyer market. On the lending side, MBA's first-quarter 2026 originations survey showed multifamily originations up 49% year over year. Across all commercial and multifamily lending, investor-driven lenders (+133%) and depositories (+80%) posted the largest year-over-year gains by lender type, with GSE volume up 38%. MBA's full-year 2026 forecast calls for $399.2B of multifamily originations, up 20.8% from 2025. The rate backdrop has a 2026 twist. SOFR, at roughly 3.9% after the Fed's September 16, 2026 quarter-point hike, remains well below the roughly 5.3% it averaged from mid-2023 to mid-2024, while the 10-year Treasury has pushed above 5%. Floating-rate money priced off the short end is cheaper than it was in the 2022-2024 squeeze; fixed agency paper priced off the long end is not.

This is the buyer the calculator on this page is built for. Not the new landlord buying a first single-family rental, but the sophisticated direct buyer underwriting a 12-unit value-add in a Sunbelt secondary market with a Fannie Small Loan, a 5-year hold, and a $635K equity check. Retail tools do not model that deal, and the institutional tools that do mostly sit behind paid software.

The small-loan menu has also changed under these buyers. MBA attributed the 80% first-quarter jump in depository lending in part to the large volume of bank-held loans maturing in 2026. Freddie Mac folded its Small Balance Loan program into its conventional platform in April 2026, moving the minimum loan from $1 million to $2 million, which leaves Fannie Small as the only agency option below $2M, alongside bank debt. The buyers are different, the deal sizes are smaller, and the holds are longer; the underwriting tools need to match.

Seven Mistakes Small-MF Buyers Make

• Underwriting from the owner's P&L rather than a market expense ratio. Small-MF sellers often under-report R&M, management, and utilities. Many of them self-manage and don't pay themselves a market management fee; many treat capital improvements as expensed maintenance to suppress NOI for tax purposes (which suppresses the apparent cap rate at sale, but the buyer who underwrites off the suppressed expense ratio inherits the actual cost structure). Reconcile the seller's numbers to a market expense ratio (this article's illustrative working range is 38-48% of EGI, lower for new construction, higher for older walk-up) before signing an LOI.

• Modeling in-place rent as the Year 1 baseline when market rent is materially higher (or lower).Small-MF leases roll on staggered schedules. If half the leases are at 6-9 months from rollover and market rents are 10% above in-place, the Year 1 NOI is somewhere between in-place and market, usually averaged through a lease-roll schedule that recognizes new market-rate leases on the rollover dates. Modeling Year 1 at full market rent overstates the year; modeling at full in-place understates. Build the lease-roll schedule.

• Using a residential 30-year mortgage analog for the debt. The retail rental calculators apply a residential mortgage formula to the debt panel: same 30-year amortization, same rate sheet, no DSCR constraint, no debt-yield floor. The actual small-MF loan is a commercial small-balance product with DSCR sizing, debt-yield floors, prepayment penalties, and non-recourse vs recourse choices. The residential analog produces a debt service number that is too low (no commercial pricing premium) and an LTV cap that is too high (no DSCR test), both of which produce a flattering IRR that doesn't survive contact with a real lender quote.

• Skipping replacement reserves. Retail calculators often skip the reserve line item. This article's illustrative working range is $250-400/unit/year for garden-style small-MF and $400-600/unit/year for older walk-up product. For a 12-unit walk-up at $400-600 per unit, that's $4.8-7.2K/year of cash flow that doesn't go to equity. On the worked example, skipping it overstates Year 1 pre-tax cash flow by roughly 16-26% and the IRR by roughly 65-95 bps. Agency lenders deduct a reserve before testing DSCR; the retail buyer who skips it inherits the actual capital spend without having underwritten for it.

• Modeling exit cap at going-in cap. This is a common error in retail-calculator small-MF underwriting. The going-in cap is the financing environment today; the exit cap is the financing environment 5-7 years from now plus an allowance for an older building. The convention this article applies is 25-75 bps of exit-cap expansion over the going-in cap on price, depending on rate trajectory and the value-add profile. On the worked example, the gap between a 7.0% and an 8.0% exit is 550 bps of IRR. Underwriting cap compression in 2026 is a market call that should be flagged at IC, not a quiet default in a spreadsheet cell.

• Conflating NOI and cash flow to equity. NOI is pre-debt-service; cash flow to equity is post-debt-service. Agency lenders test DSCR on NOI less replacement reserves; investors quote cash-on-cash off cash flow to equity. They are different numbers from the same pro forma, and the retail calculators often conflate them or report only one. The institutional pro forma carries both: NOI for the cap rate calculation, net cash flow and debt service for the DSCR test, cash flow to equity for the IRR. Make sure your output panel shows all three.

• Quoting IRR alone without MOIC or DSCR. Same critique as the IRR pillar applies. A 22% IRR on a 14-month flip is a smaller dollar return than a 14% IRR on a 6-year hold. A 16% IRR with a 1.05x DSCR is a debt-service-risk deal that won't survive a stress test. A 16% IRR with a 1.35x DSCR and a 2.05x MOIC is a structural deal. Quote the stack (IRR, MOIC, DSCR, going-in cap, breakeven occupancy) every time. The five-number quote is the institutional discipline that separates the practitioner pro forma from the retail cash-flow calculator. See the cash-on-cash articlefor the levered-vs-unlevered framing.

How to Model the Pro Forma in Excel

The widget on this page does the work the institutional shop does inside Excel. If you want to build the same model in Excel (for an LOI, a debt-broker package, or an internal IC memo that needs the audit trail), the canonical structure is five tabs:

• Tab 1: Rent Roll. Unit-by-unit table with unit number, square footage, lease start, lease end, in-place rent, market rent, concessions, occupancy status. Sum to gross potential rent at the bottom. For small MF, this is typically 5-50 rows. The institutional standard adds RUBS allocation, parking assignments, and storage rentals as side columns. Pull from the seller's rent roll PDF or the property-management system export; normalize all units to a consistent rent definition (gross vs net of concessions, includes utilities or not).

• Tab 2: Operating Expenses. 12-month line-item OpEx schedule built from the T-12 (or T-3 if ownership recently changed). Normalize for one-time items, market-rate the management fee even if owner-managed, compare against expense benchmarks for the asset class. The expense ratio (OpEx / EGI) is the headline check; this article's illustrative working range for 2026 small-MF is 38-48%.

• Tab 3: Debt Schedule. Loan amount, rate, amortization period, IO period. Build the monthly amortization schedule using =PMT() and =IPMT()/=PPMT(). Sum to annual debt service for the cash flow grid. Carry the outstanding balance by year for the exit-year loan payoff.

• Tab 4: Cash Flow Waterfall. Year-by-year, Year 0 through exit year. Rows: GPR, +Other Income, −Vacancy, =EGI, −OpEx, =NOI, −Debt Service, −Reserves, =Pre-Tax Cash Flow to Equity. Add a reversion row at exit: Exit Value (Year-N NOI / Exit Cap) − Selling Costs − Loan Payoff = Net Sale Proceeds. The Year-N total cash flow to equity is operating cash plus net sale proceeds.

• Tab 5: Returns & Sensitivity. =IRR() or =XIRR() on the cash flow stream for levered IRR. Sum of distributions / equity in for MOIC. Average of operating-year cash flows / equity for cash-on-cash. Build a 2×2 sensitivity grid with exit cap on one axis and rent growth on the other. Add side tables for OpEx and vacancy stresses.

Excel-side errors that show up most often: forgetting to format Year 0 as negative (the IRR returns no value); using =IRR() instead of =XIRR() when the cash flows aren't on perfectly annual intervals (most acquisitions close mid-year, so the cash flow timing is not Jan 1 to Dec 31); double-counting the loan amount when computing the equity check; understating the loan payoff at exit by missing IO-period amortization (in IO years, no principal is paid, so the loan balance at exit is the original loan balance for that subset of years). The widget at the top of this page handles all of these automatically. In a production Excel model, default to=XIRR() with explicit cash flow dates and a separate amortization schedule.

From a Pro Forma to an Institutional Underwrite

The widget on this page runs the pocket math. When the pocket clears (going-in cap at or above 6.5%, IRR at or above 14% on base-case inputs with a convention exit cap, lender-basis DSCR at or above 1.25x, breakeven occupancy at or below 85%), the deal warrants a full underwrite. The full underwrite is a different document: unit-level rent roll on a lease-roll schedule, OpEx built line-by-line from T-12 with normalization, debt sized across three lender quotes, exit-cap and rent-growth sensitivity, agency-vs-bank debt comparison, capital improvement schedule with phasing, and IC-ready outputs.

Apers ships a stack of multifamily acquisition models that handle the underwriting end-to-end:

• AQ-112: Small Multifamily (5-50 Units) Pro Forma. The natural graduate-to from this calculator. Unit-mix rent roll, lease-roll schedule, agency-small-loan-vs-community-bank debt comparison, 5- to 10-year hold, 2×2 exit-cap and rent-growth sensitivity, replacement reserves, breakeven occupancy stress. Built for the 12-unit-to-50-unit acquisition.
• AQ-111: Multifamily Core Pro Forma. When the deal scales up to stabilized institutional core. 10-year annual cash flow from a unit-type rent roll, linear loss-to-lease burn-off, fixed-rate senior debt, unlevered + levered IRR / equity multiple / cash-on-cash, and sensitivity tables across rent growth, exit cap, LTV, and rate. Sized for pension-fund, insurance-company, family-office, and open-end core fund allocations.
• AQ-131: Multifamily Value-Add Pro Forma. When the deal has a renovation angle. 120-month monthly cash flow with phased renovation schedule, unit-level rent premiums, downtime vacancy, sources-and-uses with debt sizing, and sensitivity tables across exit cap × rent growth and purchase price × exit cap.
• AQ-141: Multifamily Opportunistic Pro Forma. The most sophisticated underwrite in the stack, for distressed or heavy-lift acquisitions with significant capital investment and extended lease-up. Phased renovation budgets with construction-style draw schedules, S-curve absorption over up to 36 months, bridge-to-permanent refinancing analysis, and GP/LP waterfall distribution with simple or multi-tier IRR hurdles. Base / Upside / Downside scenarios side-by-side.

Related Articles

The small-MF pro forma calculator links into the broader returns-analysis and valuation clusters on Apers Learn:

• Cap Rate Calculator and Formula: the entry-yield metric every pro forma references; the cap rate decomposition framework.
• IRR Calculator and Formula for Real Estate: the methodology twin to this calculator; the formula and the reinvestment-assumption discussion.
• Equity Multiple and MOIC: When the Multiple Matters More Than IRR: the time-blind complement to IRR.
• Cash-on-Cash Return: Levered vs Unlevered: the current-yield metric the retail calculators lead with.
• IRR Sensitivity Analysis and Stress Testing: how to read IRR as a distribution, not a number.
• Bridge Loans, Floating-Rate Risk, and the Exit Assumption: the financing-environment context that drove the 2025-2026 small-MF buyer rotation.
• Multifamily Underwriting Fundamentals: From Rent Roll to NOI: the deeper rent-roll construction walkthrough.

FAQ