Guia detalhado em breve
Estamos preparando um guia educacional completo para o Multi-Family Property Analyzer. Volte em breve para explicações passo a passo, fórmulas, exemplos reais e dicas de especialistas.
Multi-family property analysis is the comprehensive underwriting process for residential properties with two or more units — duplexes, triplexes, quadplexes, and apartment buildings of all sizes. Multi-family assets represent the most popular entry point for real estate investors seeking to scale from single-family rentals into commercial-style investing, and the analytical framework bridges both residential underwriting principles and commercial income property analysis. Small multi-family properties (2-4 units) can be financed with residential mortgage programs (FHA, conventional) if owner-occupied, providing access to low down payment options unavailable for larger commercial assets. Five units and above cross the threshold into commercial real estate, requiring commercial loans with different underwriting criteria, shorter amortization periods, and typically larger down payments (25-35%). This financing inflection point at the 5-unit threshold is a significant factor in investment strategy and portfolio building. The analytical framework for multi-family evaluates income across all units simultaneously, accounting for unit mix (studio, 1BR, 2BR, 3BR), individual lease expirations, current vs. market rents, and the potential for value-add through renovation or lease-up. Unlike single-family analysis, vacancy in multi-family is portfolio-level — one vacant unit in a 10-unit building represents 10% vacancy, not 100% as it would in a single-family rental. This diversification of vacancy risk is one of the most important structural advantages of multi-family investing. Value-add multi-family is one of the most active institutional investment strategies globally: acquire an underperforming property (below-market rents, high vacancy, deferred maintenance), invest capital in renovations and management improvement, drive rents toward market rate, stabilize occupancy, and either hold for long-term cash flow or sell at a lower (higher-value) cap rate. The math of value-add multi-family is compelling: every $1 increase in monthly rent per unit at a 6% cap rate adds $200 to the property's value ($12 annual NOI increase / 0.06). For a 20-unit building raising rents by $150/unit, the value creation is 20 x $150 x 12 / 0.06 = $600,000 — financed by renovation cost of perhaps $150,000 — a $450,000 equity creation event.
See calculator interface for applicable formulas and inputs Where each variable represents a specific measurable quantity in the finance and lending domain. Substitute known values and solve for the unknown. For multi-step calculations, evaluate inner expressions first, then combine results using the standard order of operations.
- 1Step 1 - Build the Rent Roll: Collect current lease information for every unit: unit number, unit type (studio, 1BR, 2BR), current rent, lease expiration date, and tenant status (occupied, vacant, month-to-month). Calculate total current monthly gross rent and compare each unit to current market rent for that unit type. Identify units with below-market rents (value-add opportunity) and above-market rents (rollover risk).
- 2Step 2 - Project Gross Scheduled Income (GSI): Calculate GSI as the sum of all units at 100% occupancy at either current or projected market rents, depending on whether you are analyzing current income (as-is) or stabilized income (as-stabilized). For a 12-unit building averaging $1,400/unit: GSI = 12 x $1,400 x 12 = $201,600/year.
- 3Step 3 - Apply Vacancy and Credit Loss: Apply a vacancy factor appropriate for the submarket and property type. Multifamily typically uses 5-8% in tight markets, 8-12% in average markets, and higher for value-add properties during lease-up. EGI = GSI x (1 - Vacancy Rate). For the 12-unit example at 7% vacancy: EGI = $201,600 x 0.93 = $187,488.
- 4Step 4 - Itemize Operating Expenses: Compile all annual operating expenses: (a) property taxes; (b) insurance; (c) property management (typically 8-10% of collected rents for multifamily); (d) maintenance and repairs ($500-1,000/unit/year for stabilized properties); (e) CapEx reserve ($500-800/unit/year); (f) utilities paid by owner (water/sewer common, trash, common area electric); (g) landscaping; (h) pest control; (i) administrative. For the 12-unit: total operating expenses might run $72,000-$84,000 (37-42% expense ratio).
- 5Step 5 - Calculate NOI and Valuation: NOI = EGI - Total Operating Expenses. Value (income approach) = NOI / Market Cap Rate. For the 12-unit: NOI = $187,488 - $78,000 = $109,488. At a 6.5% cap rate: Value = $109,488 / 0.065 = $1,684,431. Compare this to the asking price to determine if the property is fairly priced.
- 6Step 6 - Determine Financing and Cash Flow: Calculate debt service on the acquisition loan. For commercial (5+ units) multifamily, typical loan terms: 25-30 year amortization, 5-10 year term, LTV 75-80%, DSCR covenant 1.20-1.25+. Compute annual debt service and cash flow: CFBT = NOI - Annual Debt Service. Verify DSCR = NOI / Annual Debt Service meets lender requirement.
- 7Step 7 - Compute Per-Unit Metrics and Value-Add Upside: Calculate key per-unit benchmarks: price per unit, NOI per unit, rent per unit. Compare to market comps. Quantify value-add upside: for each $1/month in rent increase per unit, the NOI increases by $1 x 12 x units, and value increases by that NOI improvement / cap rate. Model a stabilized scenario showing projected NOI and value after planned improvements and lease-up.
Slightly negative at current rates — common for 2024 duplexes
GSI: ($1,400 + $1,350) x 12 = $33,000. EGI: $33,000 x 0.93 = $30,690. NOI: $30,690 - $12,900 = $17,790. Cap rate: $17,790 / $310,000 = 5.74%. Loan: $232,500 at 7%/30yr = $1,548/mo = $18,576/yr. CFBT: $17,790 - $18,576 = -$786/yr. At 7% mortgage rates, many small multifamily deals barely break even or are slightly negative — the value proposition relies on appreciation, rent growth, and below-market owner-occupant financing if house-hacking (FHA 3.5% down on an owner-occupied duplex).
Strong value-add upside
Current: GSI = 8 x $1,050 x 12 = $100,800. EGI = $100,800 x 0.85 = $85,680. NOI = $85,680 - $36,400 = $49,280. Current cap: $49,280 / $920,000 = 5.36%. Stabilized (at market rents, 7% vacancy): GSI = 8 x $1,350 x 12 = $129,600. EGI = $129,600 x 0.93 = $120,528. Assume expenses grow to $42,000. Stabilized NOI = $78,528. At market cap rate 6.0%: Value = $78,528 / 0.06 = $1,308,800. Equity created vs. $920,000 purchase: $388,800. Debt: $644,000 at 7%/25yr = $54,312/yr. Stabilized CFBT: $78,528 - $54,312 = $24,216/yr. CoC on $276,000 invested = 8.8%.
Solid mid-size multifamily with institutional-quality DSCR
GSI: (10 x $1,100 + 10 x $1,400) x 12 = $300,000/yr. EGI: $300,000 x 0.92 = $276,000. NOI: $276,000 - $120,000 = $156,000. Cap rate: $156,000 / $2,800,000 = 5.57%. Loan: $1,960,000 at 6.75%/30yr = $12,714/mo = $152,568/yr. DSCR: $156,000 / $152,568 = 1.02 (below commercial lender threshold). To meet 1.25 DSCR: need NOI of $190,710 or reduced loan size. With 35% down ($980,000), loan = $1,820,000, debt service = $141,672, DSCR = 1.10. Still tight — 40% down ($1,120,000), loan = $1,680,000, debt service = $130,776, DSCR = 1.19. This example shows how DSCR constraints drive equity requirements for commercial multifamily deals.
Class B multifamily in secondary market; solid institutional metrics
GSI: 50 x $1,200 x 12 = $720,000. EGI: $720,000 x 0.94 = $676,800. NOI: $676,800 - $420,000 = $256,800. Cap rate: $256,800 / $7,500,000 = 3.42% — compressed. This pricing implies significant value-add or appreciation expectations, or the rents are below market. At market rents of $1,500/unit (25% rent upside), stabilized NOI = (50 x $1,500 x 12 x 0.94) - $440,000 = $846,000 - $440,000 = $406,000. Stabilized cap at $7.5M purchase = 5.41%. At 5.5% exit cap: stabilized value = $406,000 / 0.055 = $7,382,000. Agency loan (Freddie Mac/Fannie Mae): $5,625,000 at 6.25%/30yr = $34,628/mo = $415,536/yr. DSCR at current NOI: $256,800 / $415,536 = 0.62 — would not qualify at current income; requires stabilized income underwriting.
Professionals in finance and lending use Multi Family Analysis as part of their standard analytical workflow to verify calculations, reduce arithmetic errors, and produce consistent results that can be documented, audited, and shared with colleagues, clients, or regulatory bodies for compliance purposes.
University professors and instructors incorporate Multi Family Analysis into course materials, homework assignments, and exam preparation resources, allowing students to check manual calculations, build intuition about input-output relationships, and focus on conceptual understanding rather than arithmetic.
Consultants and advisors use Multi Family Analysis to quickly model different scenarios during client meetings, enabling real-time exploration of what-if questions that would otherwise require returning to the office for detailed spreadsheet-based analysis and reporting.
Individual users rely on Multi Family Analysis for personal planning decisions — comparing options, verifying quotes received from service providers, checking third-party calculations, and building confidence that the numbers behind an important decision have been computed correctly and consistently.
In practice, this edge case requires careful consideration because standard assumptions may not hold. When encountering this scenario in multi family analysis calculations, practitioners should verify boundary conditions, check for division-by-zero risks, and consider whether the model's assumptions remain valid under these extreme conditions.
In practice, this edge case requires careful consideration because standard assumptions may not hold. When encountering this scenario in multi family analysis calculations, practitioners should verify boundary conditions, check for division-by-zero risks, and consider whether the model's assumptions remain valid under these extreme conditions.
In practice, this edge case requires careful consideration because standard assumptions may not hold. When encountering this scenario in multi family analysis calculations, practitioners should verify boundary conditions, check for division-by-zero risks, and consider whether the model's assumptions remain valid under these extreme conditions.
| Property Size | Financing Type | Typical Cap Rate | Typical Price/Unit | Typical DSCR Req. |
|---|---|---|---|---|
| Duplex (owner-occ) | Residential FHA/Conv | 5.0%-7.5% | $100K-$250K/unit | N/A (residential) |
| Duplex (investor) | Residential Conv | 5.0%-7.5% | $100K-$250K/unit | N/A (residential) |
| Triplex / Quadplex | Residential Conv | 5.5%-8.0% | $90K-$200K/unit | N/A (residential) |
| 5-20 Units (Class C) | Community bank | 6.0%-9.0% | $60K-$130K/unit | 1.20-1.30 |
| 5-20 Units (Class B) | Commercial / Agency small bal. | 5.0%-7.0% | $100K-$200K/unit | 1.20-1.25 |
| 21-100 Units (Class B) | Agency DUS / Freddie | 4.5%-6.5% | $130K-$280K/unit | 1.20-1.25 |
| 100+ Units (Class A) | Agency / Life Co. | 3.8%-5.5% | $200K-$600K+/unit | 1.20-1.30 |
| Value-Add (any size) | Bridge loan / Bank | 6.5%-9.0% (going-in) | 30-40% below stabilized | 1.05-1.15 (bridge) |
What is the key difference between 1-4 unit and 5+ unit multifamily financing?
Properties with 1-4 units are classified as residential real estate by Fannie Mae, Freddie Mac, FHA, and VA, allowing owner-occupied buyers to access residential mortgage programs with low down payments (3.5% FHA, 5-15% conventional for owner-occupied). Investors (non-owner-occupants) need 15-25% down for 1-4 unit conventional loans. Properties with 5 or more units cross into commercial real estate, requiring commercial mortgages from banks, life insurance companies, or agency lenders (Freddie Mac Small Balance, Fannie Mae DUS). Commercial multifamily loans typically require 25-35% down, have DSCR requirements (1.20-1.30+), and may have 5-10 year terms with balloon payments even if amortized over 25-30 years.
What is a good expense ratio for a multifamily property?
Operating expense ratios (OER) for multifamily properties typically range from 35-55% of effective gross income, depending on property age, size, tenant-paid vs. owner-paid utilities, and management structure. Smaller properties (2-4 units) often run 40-50% OER due to higher fixed cost burden per unit. Larger properties (50+ units) achieve economies of scale and may run 35-45% OER. Properties with owner-paid utilities (master-metered electric, water, heat) run higher expense ratios. When reviewing seller pro formas, be skeptical of expense ratios below 35% — they typically omit management fees (sellers often self-manage), CapEx reserves, or understate maintenance. Recast the expenses to include realistic management fees even if you plan to self-manage.
How do I determine if a multifamily property is a good value-add opportunity?
A good value-add opportunity shows: (1) Current rents measurably below market rate (15-40% below current achievable rents for the submarket and property class); (2) Physical deficiencies (dated kitchens and baths, worn flooring, deferred exterior maintenance) that can be remediated with a defined renovation budget; (3) Operational improvements possible (below-average occupancy that reflects management issues rather than market demand); (4) A clear path to higher NOI that, when capitalized at the market rate, creates equity significantly exceeding the renovation cost; and (5) Purchase price reflecting current (depressed) income rather than stabilized potential. The typical value-add thesis targets buying at a 1-2% cap premium above market (higher cap = lower price), then compressing to market cap upon stabilization.
What are agency loans and who qualifies for them?
Agency loans are multifamily mortgages originated by approved lenders and sold to or guaranteed by government-sponsored enterprises — Fannie Mae (through its Delegated Underwriting and Servicing or DUS program) and Freddie Mac (through its small balance and conventional programs). Agency loans are the gold standard for stabilized multifamily: they typically offer the lowest rates (often 50-150 basis points below bank or insurance company pricing), longer amortization (up to 30 years), and higher leverage (up to 80% LTV for Freddie, 75-80% for Fannie). Qualifying properties must be stabilized (typically 90%+ occupancy for 90 days), have adequate DSCR (1.20-1.25 minimum), and meet property condition standards. Minimum loan amounts are typically $1 million ($750,000 for small balance programs).
What is the difference between in-place NOI and pro forma NOI?
In-place NOI (also called as-is or current NOI) reflects the property's actual current income and expenses as documented — the rent roll today, current vacancy, and verified operating costs. This is the conservative underwriting baseline. Pro forma NOI (also called stabilized or as-stabilized NOI) projects the property's income after planned improvements: rents raised to market rate, occupancy stabilized, and expense management implemented. Value-add investors underwrite acquisition at in-place income (to determine fair entry price given current reality) and model the path to pro forma (to determine the value creation potential). Be extremely cautious with seller-prepared pro formas that project large rent increases without clear market evidence — independently verify market rents through your own rental market research.
How does the price-per-unit metric work in multifamily analysis?
Price per unit (PPU) is a quick, standardized metric for comparing multifamily property values across different building sizes and markets. PPU = Purchase Price / Number of Units. The utility of PPU depends on comparing truly comparable properties — same market, same unit mix (studio vs. 1BR vs. 2BR), similar age and condition, and similar submarket. As a 2024 rough guide: Class A multifamily in major coastal markets can trade at $300,000-$600,000+/unit; Class B in Sunbelt metros at $150,000-$250,000/unit; Class C workforce housing at $80,000-$150,000/unit. PPU is most useful as a first-pass screen; cap rate and DSCR provide the more rigorous income-based analysis.
What is RUBS and how does it affect multifamily NOI?
RUBS (Ratio Utility Billing System) is a method used by multifamily landlords to recover utility costs from tenants based on a formula (typically prorated by unit size, occupancy, or other factors) even where individual metering does not exist. Implementing RUBS in a master-metered building can transfer $50-150/unit/month in utility costs from landlord to tenants, directly increasing NOI by that amount. On a 20-unit building, $100/unit/month in RUBS = $24,000/year in additional NOI, which at a 6% cap rate creates $400,000 in additional property value. RUBS implementation must comply with state tenant protection laws — some states restrict or prohibit RUBS billing. It is one of the most high-ROI value-add strategies in multifamily operations.
Dica Pro
When analyzing multifamily deals, always build your own pro forma from the ground up using the actual rent roll rather than accepting the seller's income and expense summary. Start with each individual unit's current lease, rent, and expiration date. Independently verify market rents by calling comparable available units in the neighborhood. Reconstruct expenses using your own property management rate, actual property tax bill, insurance quotes, and maintenance estimates. This bottom-up approach reveals whether the seller's price is justified by the facts or inflated by optimistic assumptions.
Você sabia?
The largest private landlord in the United States is Invitation Homes, a publicly traded REIT, which owns over 80,000 single-family rental homes. However, most rental housing in America is still owned by small individual landlords — the National Rental Housing Council estimates that roughly 17 million individual landlords own approximately 22 million rental units, with about 70% owning only 1-3 properties. This vast cottage industry of small landlords — many of whom started by house-hacking a duplex or buying a first rental property — is the backbone of the US rental housing supply.