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), 75% LTV agency small-loan at 6.25% on a 30-year amortization, Year 1 NOI of $135K growing to $175K by Year 5, exit at 7.00% cap (50 bps above the going-in cap). Edit any input. Outputs recompute live. The DSCR card flags red below 1.20 (lender deal-killer), amber between 1.20 and 1.35 (sizeable but tight), and green above 1.35 (clean clear).

The Calculator Small-MF Buyers Actually Need

Search "rental property calculator" on Google in May 2026 and the top ten results are Calculator.net, BiggerPockets, Stessa, Zillow Rental Manager, TurboTenant, SoFi, OmniCalculator, and a handful of property-management SaaS lead-gen pages. Every one of them is built for the 1-4 unit retail landlord. None of them is a multi-period CRE pro forma. None of them runs DSCR alongside IRR. None of them lets you toggle agency small-loan debt against community-bank recourse debt and see what happens to year-one cash flow. None of them models an exit cap separate from the going-in cap. The practitioner who is actually underwriting a 12-unit, $1.8M garden walk-up in a secondary market lands on those pages, realizes the tools won't hold the question, and leaves to rebuild the math in Excel or to pay PropertyMetrics for the multi-period version of what should be on the open web.

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 DSCR, and breakeven occupancy live as you edit. Newton-Raphson IRR solver with bisection fallback, standard amortizing-payment debt math, the same engine institutional acquisitions teams use. No paywall, no email gate, no PRO tier. Below the widget: the institutional rent-roll-to-IRR walk-through that the BiggerPockets / Stessa / Calculator.net cohort doesn't publish, the 2026 debt-sizing decision framework across agency small-loan and community-bank product, the buyer-rotation context that explains who is actually 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 in a vacation market with an FHA loan and a homeowner-occupant tenant, that's a reasonable approximation. For a 12-unit garden walk-up with seventeen 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) — Fannie Mae Small Loan, Freddie Mac Small Balance Loan, or a community-bank recourse loan, all with different 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 you cross ~20 units, RUBS utility allocation, replacement reserves at $250-$600 per unit per year. 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. It is what Adventures in CRE paywalls inside the Accelerator. It is what HelloData puts behind an email gate. 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 (RUBS), laundry, parking, pet fees, application fees, late fees — typically adds 4-8% of GPR for small MF. 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. Stabilized small-MF vacancy + credit loss runs 5-9% depending on submarket and the unit mix; older walk-up product clears the higher end. New construction Class A in a primary submarket clears 4-5%. Brokers consistently use the lower number; the underwriter consistently re-derives 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. For 2026, the small-MF expense ratio sits at 38-48% of EGI depending on the tax burden, the management structure, and the age of the building. Texas, Illinois, and New Jersey small-MF clear the high end of that band because of property tax burden. Tennessee, Georgia, and Florida clear the low end. New construction in any market clears the lower end because R&M is suppressed in the early years; older walk-up product clears the high end.

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 75% LTV Fannie Mae Small Loan at 6.25% on a 30-year amortization on a $1.8M purchase, the loan is $1.35M and the annual debt service is roughly $99,800 — close enough to NOI that the year-one DSCR is 1.35x and the deal sizes at quoted terms. DSCR is NOI / debt service. Lenders require 1.20-1.25x minimum on agency small-loan product in 2026; better deals clear 1.30-1.40x. Below 1.20x 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. Replacement reserves at $250-400/unit/year for garden small-MF; $400-600/unit/year for older walk-up. New construction $200-300. The retail calculators routinely skip this; 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 — Memphis, Birmingham, Greenville, Tulsa, the kind of submarket where small-MF transaction volume in 2026 has held up materially better than gateway market core. 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 75% LTV is the all-in basis minus the loan: $1.895M minus $1.35M = $545K of equity at Year 0.

The debt is a Fannie Mae Small Loan at 6.25% on a 30-year amortization with no IO (the 2026 agency small-loan rate sheet ranges 6.00-6.50% for stabilized small-MF; community-bank competitive bid sits at 6.75-7.50% with recourse and a 20-25 year amortization). Annual debt service on the $1.35M loan is approximately $99,800. Year 1 NOI of $135K against $99,800 of debt service is a 1.35x DSCR — clean clear for agency small-loan sizing — and a $35K 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 institutional convention is the all-in basis cap.

NOI grows from $135K in Year 1 to roughly $175K by Year 5 — that's a 6.7% blended growth rate that absorbs both market rent growth (3-4%) and the 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 a 7.0% cap (50 bps above the going-in cap — the institutional convention for the 2026 rate environment). Year 5 NOI of $175K divided by a 7.0% exit cap implies a $2.5M exit value. Less 2% selling costs ($50K), less the year-5 outstanding loan balance ($1.27M after five years of amortization), the net sale proceeds to equity are roughly $1.18M. Plus the Year 5 operating cash flow of $46K, total Year 5 distribution to equity is $1.226M.

The full cash flow stream to equity:

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

• Levered IRR: 16.5% (Newton-Raphson converges in 5 iterations from the 12% guess)
• MOIC: 2.05x (total $1.12M of cumulative distributions plus $1.18M of net sale on $545K of equity)
• Total profit: $570K
• Average annual cash-on-cash: 9.4% (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.35x (clean clear for agency small-loan)
• Breakeven occupancy: 84% (debt service + OpEx covered at this occupancy)

The deal is real. Going-in cap clears 7%, IRR clears 15%, DSCR clears 1.30x, breakeven sits below in-place occupancy — every institutional small-MF screening hurdle holds. This is the deal a 2026 small-MF buyer takes forward into a full underwrite. 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 / 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 $545K equity check is a 5.7% 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 $1.18M of net sale proceeds — twenty times the Year 1 operating cash and three-quarters of the total IRR contribution.

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 the single highest-leverage input on small-MF returns. A 50-bp move in the interest rate changes the year-one DSCR by ~10 bps and the IRR by ~75 bps. A 5% move in LTV (from 70% to 75%) changes the equity check by ~$90K on a $1.8M deal and the IRR by ~150 bps. Getting the debt right matters more than 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 (May 2026). Agency Small Loan pricing per Fannie Mae and Freddie Mac SBL rate sheets, benchmarked against the MBA Multifamily Originations Survey. SOFR and 10-year Treasury references at FRED.

The choice between agency and community-bank product is the single biggest financing decision a small-MF buyer makes. Agency wins on rate (75-100 bps inside community-bank pricing), LTV (80% vs 70-75%), and non-recourse status. Community-bank wins on speed (3-5 weeks vs 8-12 weeks to close), flexibility (assumability, prepayment penalties), and underwriting discretion (a relationship bank will look past a soft DSCR quarter that the agency cap-strict sizer will not). 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. DSCR is Year 1 NOI / Year 1 debt service. Lenders quote 1.20-1.25x as the floor for agency small-loan. Below 1.20x 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: red below 1.20, amber 1.20-1.35, green above 1.35. 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 return-juicer in the early years. Agency Small Loans typically allow up to 5 years of IO on a 30-year amortizing structure. During the IO period, debt service is loan × rate (~$84K/year on the worked example, vs $99,800 amortizing). The extra ~$16K/year flows directly to equity in the IO years, lifting Year 1 cash-on-cash from 5.7% to ~8.6% and the IRR by ~80-120 bps. The trade-off: the loan balance at exit is higher (no amortization), which reduces net sale proceeds. On a 5-year hold, the IO net benefit to IRR is positive; on a 10-year hold, the IO benefit narrows because the buyer has surrendered five years of forced amortization.

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-80% of total return for a 5-year hold. 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 13-15%. The retail calculators that assume going-in cap equals exit cap are hiding the deal's biggest underwriting choice.

The institutional convention for the 2026 rate environment is to underwrite exit cap 25-50 bps wider than going-in cap for stabilized small-MF, and 50-75 bps wider for value-add small-MF. The reasoning is structural: the going-in cap rate reflects today's financing environment (10-year Treasury at 4.20-4.40%, agency small-loan at 6.0-6.5%). The exit cap reflects the financing environment 5 years from now, which is unknowable but is unlikely to be materially tighter than today. The conservative position is to assume some basis expansion; the aggressive position is to underwrite flat caps; the position that would have failed every IC meeting in 2024-2026 is to underwrite cap compression.

The exit cap selection also encodes a "buyer reserves" haircut for the next buyer's IRR. If a buyer wants a 7% IRR on a stabilized core deal in Year 5, and the asset will throw off 6.5% cap-rate-equivalent NOI growth, the exit cap needs to compensate the next buyer for the same return target the current buyer demands today. This is why exit caps trend toward the going-in cap of comparable deals at the projected exit date — the seller is selling into a market that is pricing the next buyer's required return. The fuller treatment of going-in vs exit cap is in the cap rate pillar.

Selling costs at exit are 2-3% of gross sale price for small-MF in 2026 (broker commission, transfer tax, legal, closing costs). 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, ~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 of equity 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 going-in cap, going-in + 25 bps, going-in + 50 bps, going-in + 100 bps. For the worked example: at 7.0% exit cap (base) the IRR is 16.5%. At 7.5% exit cap the IRR drops to 12.8%. At 8.0% exit cap the IRR drops to 9.4%. The 100-bp stress is the deal-killer 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.

Rent growth haircut. Re-run with 0%, 1%, 2%, 3% rent growth versus the base case. Most small-MF pro formas underwrite 3-4% rent growth in 2026 against a 10-year historical average of 2.8% per the CBRE / JLL multifamily quarterlies. The 1% rent-growth stress is the deal-killer test: at 1% rent growth, the worked example IRR drops to roughly 11.5% — still acceptable for a stabilized small-MF deal but below the value-add hurdle.

OpEx ratio expansion. Re-run with a 45%, 48%, and 52% OpEx ratio versus the base case 42%. Most small-MF expense ratios drift up over a 5-year hold as deferred maintenance surfaces and tax burden grows. The 52% stress (+1000 bps of expense ratio) is what happens when the buyer underestimated R&M and property tax growth — the worked example IRR drops to roughly 10.8% at this stress level.

Vacancy stress. Re-run with 10% and 15% vacancy versus the base case 7%. A 15% vacancy stress is the local-market-downturn test (a meaningful share of secondary-market submarkets cleared 12-14% vacancy in the 2009 cycle). The worked example holds DSCR above 1.0x at 10% vacancy but fails at 15% vacancy — the deal cannot service its debt at a deep downturn.

Rate-shock refi. If the pro forma contemplates a Year 2 or Year 3 refi event, re-run with the take-out rate at 50, 100, and 200 bps above today's quote. The 200-bp stress is the 2022-2024 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 actually buying small multifamily in 2026, and why is the audience reading this article? The answer is the most important demand-side context in the small-MF market today, and it explains why the retail calculator SERP is structurally failing to serve the practitioner cohort that has shown up to type "rental property calculator" into Google.

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 article walks 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%. 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 acquisitions of stabilized small-MF slowed from roughly $40B/year at the peak to under $20B by mid-2024 per NMHC and MBA Originations Survey data.

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. By Q1 2026, MBA data show multifamily originations up 49% YoY at a $399B annual run rate — much of the gain driven by smaller deal sizes financed by community banks and agency Small Loan product, not the institutional core-plus bridge that drove the 2021 cycle.

This is the buyer who has typed "rental property calculator" into Google in 2026. Not the new landlord buying their first single-family rental (that buyer is on BiggerPockets), 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 $545K equity check. The 2026 SERP is not yet serving this buyer — the institutional tools they need are paywalled at PropertyMetrics and RentalCalcs, the retail tools they don't need own page one, and the gap between the two is where this article lives.

The buyer rotation also explains why agency Small Loan and Freddie SBL volume has held up while institutional multifamily M&A has been slower. Per the Census Bureau housing starts data and the CBRE U.S. Multifamily Figures Q1 2026 report, the small-MF transaction volume in secondary and tertiary markets has outpaced gateway market volume by a 2-3x ratio in 2025-2026 — a structural reversal from the 2018-2022 cycle. The buyers are different, the deal sizes are smaller, the holds are longer, and the underwriting tools they need to do the work are not yet on the SERP they're searching. This article is the correction.

Seven Mistakes Small-MF Buyers Make

• Underwriting from the owner's P&L rather than a market expense ratio. Small-MF sellers consistently 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). Always reconcile to a 38-48% market expense ratio for 2026 small-MF (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. The retail calculators routinely skip the reserve line item. Garden-style small-MF requires $250-400/unit/year in reserves at minimum; older walk-up product requires $400-600/unit/year. For a 12-unit walk-up, that's $5-7K/year of cash flow that doesn't go to equity. Skipping it overstates the pre-tax cash flow by 8-12% and the IRR by 50-80 bps. Lenders and institutional buyers always include the reserve; 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 the most common single 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 a buyer-reserves haircut. The institutional convention is 25-75 bps of exit-cap expansion depending on rate trajectory and the value-add profile. 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. Lenders quote DSCR off NOI; investors quote cash-on-cash off cash flow to equity. They are different numbers from the same pro forma, and the retail calculators routinely conflate them or report only one. The institutional pro forma carries both — NOI for the cap rate calculation, 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 article for 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 NCREIF expense benchmarks for the asset class. The expense ratio (OpEx / EGI) is the headline check; should be 38-48% for 2026 small-MF.

• 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. Tactica RES, Adventures in CRE, and A Simple Model all publish small-MF Excel templates that follow this five-tab structure.

From a Pro Forma to an Institutional Underwrite

The widget on this page runs the pocket math. When the pocket clears — going-in cap above 6.5%, IRR above 14% on base-case inputs, DSCR above 1.30x — 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 (forthcoming sibling).

FAQ