How to Underwrite a Multifamily Deal Step-by-Step

By Maurice L. Naylon IV, CPA

Multifamily underwriting connects property records, normalized operations, capital needs, financing, returns, and downside analysis.

Multifamily underwriting turns incomplete property information into a disciplined investment decision. The spreadsheet matters, but the real work is deciding which numbers deserve to enter it. A formula cannot rescue unsupported rents, missing expenses, optimistic renovation timing, or debt that does not fit the business plan.

A useful model creates an auditable chain. Each important assumption should connect to a source document, an explanation, a sensitivity, and a diligence item. The result is not a prediction. It is a structured view of what must happen for the deal to work, what could prevent it, and how much room the investment has when assumptions move against you.

Working rule: Underwrite the property that exists, model the plan you can execute, and test the result against conditions you do not control.

This tutorial applies the broader real estate underwriting guide to an existing multifamily acquisition. Use the real estate financial modeling guide when you need detailed workbook architecture for how to build a real estate underwriting model.

Step 1: Define the Investment Thesis and Decision

Write the investment thesis before building the model. Identify the property type, target tenant, current condition, expected hold period, renovation plan, management approach, financing, and exit. State what creates value. Is the deal attractive because in-place income is durable, rents are below supportable market levels, expenses can be normalized, occupancy can recover, units can be renovated, or financing is favorable?

Step 2: Assemble and Label the Source Documents

Begin with the current rent roll, trailing 12-month operating statement, prior two or three calendar years, current budget, general ledger detail when available, leases or lease summaries, utility bills, property tax records, insurance information, service contracts, capital history, offering materials, loan terms, property condition information, and relevant market comparables.

Record the source date for every key input. A rent roll from last month and a trailing statement ending six months ago do not describe the same operating period. Separate facts supplied by the seller from your assumptions and from third-party evidence. Missing information should remain visible as a diligence item rather than being buried in a hard-coded estimate.

Step 3: Rebuild the Rent Roll and Gross Potential Rent

Reconcile the number of units by unit type, occupied status, square footage, lease rent, concessions, delinquency, deposits, lease dates, and renovation status. Calculate in-place monthly rent and annualize it carefully. Do not treat asking rent, scheduled rent, and collected rent as the same measure.

Build gross potential rent from a stated approach. For a stabilized acquisition, that may begin with occupied lease rents plus supportable market rent for vacant units. For a renovation plan, model the turnover schedule, renovation downtime, renovated premium, lease-up pace, and loss-to-lease separately. Avoid applying the completed business plan on day one.

Step 4: Estimate Vacancy Concessions and Credit Loss

Physical vacancy is only one form of revenue loss. Economic vacancy may also include concessions, bad debt, non-revenue units, employee units, model units, and loss-to-lease depending on the model structure. Reconcile the historical trend with the current rent roll and market conditions. A single percentage should not conceal a collection problem or a lease-up period.

Step 5: Underwrite Other Income Separately

List material sources such as parking, utility reimbursements, pet income, laundry, storage, application fees, late fees, and other recurring property revenue. Test whether each item is permitted, collectible, recurring, and supportable under the planned operations. Do not underwrite security deposits, loan proceeds, insurance recoveries, or one-time gains as operating income.

Fannie Mae’s multifamily valuation and income guidance likewise distinguishes recurring property income from items that should not be included in effective gross income. Lender underwriting rules are not identical to an investor model, but they provide a useful discipline for separating durable operations from non-operating cash.

Step 6: Normalize Operating Expenses

Review expenses line by line rather than applying a single expense ratio. Typical categories include property taxes, insurance, utilities, repairs and maintenance, payroll, contract services, management fees, advertising, administrative costs, landscaping, security, and professional fees. Compare the trailing period, prior years, budget, contracts, invoices, and relevant expense comparables.

Normalize the forward year for known changes. Reassess property taxes after a sale when required by the municipality. Obtain current insurance indications. Adjust payroll and management to the planned operating structure. Separate recurring repairs from capital replacements. Remove genuine non-recurring items, but do not label an expense non-recurring merely because it hurts the model.

The real estate accounting guide explains why consistent property-level records are essential when converting reported results into underwriting assumptions.

Step 7: Calculate Net Operating Income

Net operating income is effective gross income minus the operating expenses included under the model’s definition. NOI generally excludes debt service, income taxes, depreciation, owner distributions, and acquisition financing. Capital reserves and recurring replacements may be shown below NOI or included in a lender-specific cash-flow measure. Label the convention so readers can reconcile the calculation.

The basic sequence is gross potential rent plus other recurring income, less vacancy and collection loss, equals effective gross income. Effective gross income less normalized operating expenses equals NOI.

Worked Multifamily Underwriting Example

Illustrative Year 1 item	Calculation	Amount
Gross potential rent	40 units × $1,500 × 12 months	$720,000
Other income	Parking utility and pet income	30,000
Vacancy and credit loss	5% of gross potential rent	(36,000)
Effective gross income	$720,000 + $30,000 - $36,000	714,000
Operating expenses	45% of effective gross income	(321,300)
Net operating income	$714,000 - $321,300	$392,700

This hypothetical example uses a 40-unit property and simplified assumptions. A real model should underwrite the rent roll, other income, vacancy, and each operating expense line independently. The 45% ratio is a summary of the resulting assumptions, not a substitute for them.

Step 8: Separate Immediate Capital Needs from Operations

Identify repairs required at closing, deferred maintenance, unit renovations, building systems, life-safety items, accessibility work, exterior improvements, and recurring replacements. Estimate cost, timing, contingency, downtime, funding source, and effect on revenue. Capital spending may not appear in NOI, but it still consumes cash and affects total basis and return.

Step 9: Test Price and Going In Valuation

Calculate the going-in capitalization rate as Year 1 NOI divided by purchase price, using a clearly labeled NOI convention. At a $6,000,000 purchase price, the illustrative $392,700 NOI produces a 6.55% going-in cap rate. Compare the result with relevant transactions, property condition, location, growth, risk, and capital needs rather than treating one market average as definitive.

Step 10: Add Financing and Debt Coverage

Model loan amount, loan-to-value or loan-to-cost, interest rate, amortization, term, maturity, interest-only period, fees, reserves, escrows, recourse, covenants, and refinance or extension assumptions. Use an amortization schedule rather than approximating debt service from the interest rate.

Assume the $6,000,000 purchase receives 65% debt, or $3,900,000, at 6.25% with 30-year amortization. Monthly principal and interest are approximately $24,013, or $288,156 annually. NOI of $392,700 divided by annual debt service produces a debt-service coverage ratio of approximately 1.36x. Actual lender sizing may use different NOI, reserves, stress rates, and constraints.

Step 11: Calculate Levered Cash Flow and Equity Required

Build sources and uses. Equity must fund more than the down payment. Include closing costs, lender fees, escrows, reserves, immediate repairs, renovation costs, and working capital, net of any financed items. Then calculate cash flow after debt service and capital reserves under the stated convention.

If this example requires $2,100,000 of purchase equity, $120,000 of closing and financing costs, and $250,000 of immediate capital, total initial equity is $2,470,000. If annual capital reserves are $24,000, cash flow after debt service and reserves is approximately $80,544. The resulting Year 1 cash-on-cash return is approximately 3.26%. That modest initial yield may or may not be acceptable depending on the renovation plan, risk, later cash flow, and investor objectives.

Step 12: Model the Hold Period and Investor Returns

Project operations through the intended hold, including rent growth, occupancy, other income, expense growth, capital spending, renovation timing, debt amortization, and refinancing if applicable. Model the sale using a forward NOI, exit capitalization rate, selling costs, and remaining debt. Do not apply an exit cap rate to the wrong income period.

Calculate unlevered and levered cash flows separately. Common outputs include cap rate, DSCR, cash-on-cash return, equity multiple, and internal rate of return. No single metric captures timing, scale, leverage, liquidity, or downside.

Step 13: Run Sensitivities That Reflect the Business Plan

Start with the variables that can materially change value or liquidity: purchase price, rent growth, vacancy, renovation cost, renovation pace, expense growth, interest rate, loan proceeds, exit cap rate, sale timing, and capital events. Use two-variable tables for important combinations, such as rent growth and exit cap rate, but also run complete downside scenarios in which several adverse conditions occur together.

Step 14: Convert Assumptions into Diligence and a Decision

Create a diligence list directly from the model. If the return depends on a rent premium, verify renovated comparables and achieved leases. If insurance materially affects NOI, obtain a property-specific indication. If utility savings matter, review bills and implementation cost. If taxes are assumed to remain flat, confirm the reassessment process. Assign each item a responsible party, deadline, source, and consequence.

Finish with a go, revise, or pass decision. Go means the evidence supports the price and plan within the investor’s requirements. Revise means the opportunity may work at a different price, financing structure, scope, or contingency. Pass means the remaining return does not compensate for the identified risk, or the necessary evidence cannot be obtained.

Use the two-pass framework in how to analyze a real estate deal to decide when an opportunity has earned this deeper work. The acquisition guide on buying an investment property places underwriting within the broader purchase process.

Common Multifamily Underwriting Mistakes

·       Starting with broker projections instead of rebuilding current operations from source records.

·       Applying market rent immediately without modeling lease expirations renovation downtime and lease-up.

·       Using an expense ratio without reviewing taxes insurance utilities payroll maintenance and management separately.

·       Excluding capital needs because they fall below NOI.

·       Approximating debt service or ignoring loan fees, reserves covenants, and maturity risk.

·       Using one optimistic exit assumption to solve a weak going-in basis.

·       Reporting IRR without showing equity requirements, cash distributions, and downside cases.

·       Failing to turn uncertain assumptions into diligence tasks before contingencies expire.

When an Independent Underwriting Review Helps

An independent review can be useful when the rent roll and operating statement do not reconcile, expenses require normalization, the renovation plan drives value, lender terms materially change returns, or the model has become too complex to challenge internally. A reviewer should identify the assumptions that control the decision and trace them back to evidence.

Walutes Capital offers a 30-minute Zoom consultation for $75. We can review documents and models during the call, and every consultation includes a follow-up email with salient points or models discussed. Our perspective combines CPA, investor, developer, and asset-management experience.

Learn when to hire a real estate consultant, review our real estate consulting services, or book a 30-minute consultation. The Investor’s Guide to Real Estate and Walutes Capital’s services provide additional context.

Frequently Asked Questions

What documents do I need to underwrite a multifamily deal?

Start with the current rent roll, trailing 12-month operating statement, prior years’ statements, budget, leases or summaries, utility bills, tax and insurance information, service contracts, capital history, loan terms, and property condition information. Add market comparables and third-party reports as the review advances.

How do you calculate multifamily NOI?

Under the common property-level convention, add gross potential rent and recurring other income, subtract vacancy and collection loss to reach effective gross income, then subtract normalized operating expenses. Clearly identify whether reserves or other items are included.

What is a good cap rate for a multifamily property?

There is no universal good cap rate. The appropriate comparison depends on market, location, asset quality, condition, operations, growth, capital needs, financing, and risk. Confirm that the numerator and valuation period are consistent before comparing deals.

What is DSCR in multifamily underwriting?

Debt-service coverage ratio generally divides a lender-defined property cash-flow measure by required debt service. Investors often begin with NOI divided by annual principal and interest, but lenders may use different adjustments, reserves, stress rates, and minimums.

Should I use the seller budget or trailing operations?

Use both as evidence, not as automatic assumptions. Historical operations show what occurred; the budget shows an expectation. Normalize the forward year using the rent roll, contracts, current pricing, market evidence, and the buyer’s executable operating plan.

How often should I update the underwriting model?

Update it whenever material evidence changes, including the rent roll, operating results, price, loan terms, insurance, taxes, physical condition, capital plan, or diligence findings. Preserve versions so decision-makers can see what changed and why.

Disclaimer

This article is provided for general educational and informational purposes only. It does not constitute tax, accounting, legal, investment, lending, appraisal, engineering, brokerage, or other professional advice and should not be relied upon as a substitute for advice tailored to your circumstances. Real estate investments involve risk, and operating results, financing terms, valuation, tax consequences, and legal requirements vary based on each investor, property, market, transaction, and applicable law. Before making an investment or implementing a tax, accounting, legal, financing, development, or operating strategy, consult qualified professionals who can evaluate your specific situation. A 30-minute consultation does not establish a formal CPA, tax-preparation, legal, investment-advisory, lending, appraisal, engineering, brokerage, or attestation engagement.