Real Estate Underwriting Guide: How to Analyze Multifamily & Commercial Deals

By Maurice L. Naylon IV, CPA

Real estate underwriting is often presented as a spreadsheet exercise. Enter the rent, subtract expenses, apply a capitalization rate, and calculate a return. The formulas matter, but they are usually not the hardest part of the analysis.

The harder work is deciding which information deserves to go into the model. A rent roll may show what tenants are supposed to pay, while bank deposits show what the owner actually collected. A trailing operating statement may include unusually low repairs because maintenance was deferred. A broker may project market rents that are achievable only after renovation, vacancy, and additional capital. A lender may size the loan using more conservative income and expenses than the buyer used to calculate the purchase price.

Underwriting is the process of reconciling those facts, forming supportable assumptions, and measuring what happens if the business plan does not unfold as expected. The output should help an investor answer four questions: What is the property likely to earn? What is it worth? How much debt and equity will the investment require? What could cause the expected return to change? Investors who want an independent review of their assumptions can use real estate consulting services to discuss the deal, underwriting model, financing, and development considerations

This guide focuses on acquisitions of multifamily and income-producing commercial property in the United States. The same framework can be adapted to office, retail, industrial, self-storage, hospitality, and other asset classes, but the documents, lease structures, expense responsibilities, and operating risks will differ.

What Is Real Estate Underwriting?

Real estate underwriting is the structured evaluation of a property, its expected cash flow, its financing, and the risks surrounding the investment. Investors underwrite to decide whether to buy, how much to pay, how to finance the acquisition, and whether the expected return justifies the risk. Lenders underwrite to decide whether the property and borrower can support a proposed loan.

Those perspectives overlap, but they are not identical. A lender concentrates on repayment, collateral value, borrower capacity, and downside protection. An equity investor also cares about appreciation, distributions, tax consequences, operational upside, and the return received for capital at risk.

A complete investor underwriting should therefore cover the property as it operates today, the proposed business plan, the financing structure, and the exit. It should also clearly separate documented facts from estimates and estimates from aspirations.

Working rule: Every important assumption should have a source, an explanation, or a sensitivity case. If none exists, the model is expressing hope rather than analysis.

Start With the Decision, Not the Spreadsheet

Before building the model, define the decision it must support. Are we screening a listing, setting an offer price, preparing for a lender, comparing renovation plans, or making a final investment-committee decision? The level of detail should increase as the cost of being wrong increases.

·       Initial screen: Is the opportunity worth additional time?

·       Offer analysis: What price and terms are supportable before diligence?

·       Due diligence underwriting: Do leases, collections, expenses, physical condition, and legal documents support the original thesis?

·       Financing analysis: What proceeds, covenants, reserves, amortization, and maturity risk should we expect?

·       Final approval: What is the base case, what is the downside case, and what unresolved risks remain?

This staged approach prevents two common errors: spending hours polishing an unattractive deal and relying on a rough screen after significant capital has already been committed.

Step 1: Collect and Reconcile the Source Documents

The underwriting model should be traceable to the documents that support it. For a multifamily acquisition, the starting package commonly includes the current rent roll, trailing 12-month operating statement, at least two or three prior years of financial statements, bank or property-management reports, leases, delinquency and concession schedules, utility bills, property-tax records, insurance information, payroll detail, service contracts, capital-expenditure history, and the seller’s offering memorandum.

Commercial properties may require more lease-level work. Review base rent, contractual increases, renewal and termination options, expense reimbursements, tenant-improvement obligations, leasing commissions, free-rent periods, co-tenancy provisions, guarantees, percentage rent, and rollover dates. A building with stable current occupancy may still carry meaningful risk if a large tenant’s lease expires shortly after closing.

Reconciliation is essential. Scheduled rent should be compared with the general ledger and actual collections. The trailing statement should agree, or be reconcilable, to underlying accounting records. Property-tax assumptions should reflect the rules in the property’s jurisdiction and the effect a sale may have on assessed value. Insurance should be estimated for the buyer and proposed coverage, not copied automatically from the seller’s historical expense.

Step 2: Build Potential and Effective Gross Income

Potential gross income represents the revenue the property could generate before vacancy and collection losses. For apartments, this normally begins with occupied unit rent plus market rent for vacant units, then adds recurring income such as utility reimbursements, parking, storage, laundry, pet fees, and other services. For commercial leases, the calculation may include base rent and contractual reimbursements by tenant and period.

Potential revenue is not the same as collectible revenue. Underwriting should account for physical vacancy, economic vacancy, concessions, bad debt, employee or model units, and other losses between scheduled rent and cash collected. The result is effective gross income.

Be cautious with loss-to-lease. If occupied units are below current asking rents, the gap may represent upside, but it is not automatically available on day one. Capturing it may require lease expirations, renewals, renovation, tenant turnover, marketing, and sometimes additional concessions. The timing and cost belong in the model.

Step 3: Normalize Operating Expenses

The objective is not to repeat the seller’s last 12 months. It is to estimate the recurring cost of operating the property under the buyer’s plan. Review each expense line and decide whether the historical amount is recurring, temporary, omitted, capital in nature, paid by an affiliate, or likely to change after the sale.

·       Property taxes: consider reassessment, abatements, appeals, and jurisdiction-specific timing.

·       Insurance: obtain a current indication when possible, especially where catastrophe exposure or prior claims may affect pricing.

·       Repairs and maintenance: adjust for deferred work, unusual events, and the difference between routine expense and capital replacement.

·       Payroll and contracts: reflect the staffing and service model the property will actually use.

·       Utilities: reconcile bills, occupancy, rates, owner-paid services, and reimbursements.

·       Management fee: include a market-based cost even when the current owner self-manages.

·       Replacement reserves and recurring capital: show them clearly, even if the chosen NOI convention presents reserves “below the line.”

Different investors, appraisers, and lenders may classify selected items differently. Consistency and transparency are more useful than forcing every model into one convention. Define what the model includes in NOI, disclose material items below NOI, and avoid improving the return by moving a recurring economic cost out of sight.

Step 4: Calculate NOI and Property Value

Net operating income, or NOI, is effective gross income less recurring property operating expenses before debt service, income taxes, depreciation, and owner-level financing costs. NOI is central to income-property valuation because a capitalization rate converts a stabilized annual NOI into an implied value:

Commercial value formula: Property value = Stabilized NOI ÷ Capitalization rate

If stabilized NOI is $650,000 and the selected capitalization rate is 6.50%, the implied value is $10,000,000. At a 7.00% capitalization rate, the same NOI indicates approximately $9,285,714. A 50-basis-point change reduces the indicated value by more than $700,000.

The cap rate must match the income being capitalized. A buyer should not apply a market cap rate based on stabilized comparable sales to an inflated year-one NOI or to income that requires substantial additional capital. For properties with irregular cash flows, major lease rollover, development risk, or a multi-year repositioning plan, a discounted cash flow analysis may be more informative than one year of direct capitalization.

Step 5: Model Financing and Debt Risk

The property may produce acceptable NOI and still be a poor equity investment if the debt is expensive, highly leveraged, short-term, or exposed to refinancing risk. Model loan proceeds, interest rate, amortization, interest-only periods, fees, lender reserves, recourse, covenants, extension options, and maturity.

Debt-service coverage ratio, or DSCR, measures the relationship between underwritten NOI and annual debt service:

DSCR formula: DSCR = NOI ÷ Annual debt service

 An NOI of $650,000 and annual debt service of $500,000 produce a 1.30x DSCR. That does not mean the property has a 30% profit margin. It means underwritten NOI is 1.30 times scheduled debt service before capital expenditures, income taxes, and owner distributions. Lenders may calculate NOI or required coverage differently, so the investor should model the likely lender case as well as the investment case.

Also test maturity. A five-year loan on a seven-year business plan creates a refinancing event before the planned sale. The future loan amount may be constrained by the property’s NOI, the prevailing interest rate, lender-required DSCR, and appraised value. Underwriting a refinance at the original loan terms can hide a future equity requirement.

Step 6: Calculate the Total Equity Requirement

The equity requirement is more than purchase price less debt. Include acquisition closing costs, loan fees, immediate repairs, renovation, tenant improvements, leasing commissions, operating deficits, lender escrows, working capital, and reserves. If the business plan depends on future capital, show when it is needed and who is obligated to provide it.

A deal that appears to require $3 million at closing may require $3.8 million before stabilization. Calculating returns on only the initial contribution exaggerates performance and understates the investor’s liquidity risk.

Step 7: Project Cash Flow and Equity Returns

Once operations and debt are modeled, project cash available to equity by period. Property-level NOI is not the same as cash flow to the investor. Debt service, recurring capital expenditures, leasing costs, reserves, and other below-NOI items must be funded before distributions.

·       Cash-on-cash return: annual cash distributed relative to invested equity; useful for current yield, but it ignores timing beyond the measured period.

·       Equity multiple: total distributions divided by total equity contributed; simple and intuitive, but it does not account for how long the investment is held.

·       Internal rate of return: a time-weighted measure based on the timing of contributions and distributions; useful for comparing modeled cash flows, but sensitive to assumptions and not a guarantee.

·       Net present value: the present value of projected cash flows at a selected discount rate less invested capital; useful when the investor has a defined required rate of return.

Returns should be calculated after all modeled capital contributions and transaction costs. Sponsor promotes, preferred returns, fees, and partnership waterfalls must also be incorporated when the return to a particular investor differs from the return at the property level.

Step 8: Model the Exit

Many projected returns depend heavily on the sale. Estimate exit value using a supportable future NOI and exit capitalization rate, then subtract selling costs and outstanding debt. Do not assume the terminal cap rate will automatically be lower than the going-in cap rate. An aging property, shorter remaining lease term, higher interest-rate environment, or weaker capital market may justify a higher exit cap rate.

A useful model shows how much of the expected profit comes from operations, debt amortization, renovation, market rent growth, and terminal valuation. If almost all of the return depends on a favorable sale price, the investment may be more speculative than the headline return suggests.

Step 9: Stress-Test the Assumptions

A base case is a forecast, not a boundary. Sensitivity analysis changes one or more assumptions to show how the result responds. At minimum, test rent growth, vacancy, operating expenses, renovation cost, timing, interest rate, refinance proceeds, and exit cap rate.

Risk variable	Base case	Illustrative downside question
Rent growth	3.0% annually	What if growth averages 1.0%?
Occupancy	95%	What if occupancy falls to 90% for one year?
Operating expenses	3.0% growth	What if insurance and taxes rise faster?
Renovation	On budget	What if cost is 10% higher and completion is six months late?
Exit cap rate	6.75%	What if the property sells at 7.25%?
Refinancing	Planned proceeds available	What if DSCR limits proceeds and equity must be contributed?

 The point is not to predict the exact downside. It is to identify the assumptions that control the outcome, estimate the investment’s margin for error, and determine whether the investor has sufficient liquidity and patience if the plan takes longer.

A Simplified Multifamily Underwriting Example

Assume a 60-unit apartment property is offered for $8,000,000. The current rent roll and other income imply $900,000 of potential annual revenue. After reviewing collections, concessions, vacancy, and bad debt, we underwrite $855,000 of effective gross income. Normalized operating expenses are $350,000, producing $505,000 of NOI.

Calculation	Amount / result
Potential gross income	$900,000
Less vacancy, concessions and bad debt	($45,000)
Effective gross income	$855,000
Less normalized operating expenses	($350,000)
Net operating income	$505,000
Going-in cap rate at $8,000,000	6.31%
Illustrative loan amount	$5,200,000
Illustrative annual debt service	$390,000
DSCR	1.29x
Cash flow before capital items and tax	$115,000

 The first-year cash flow is not enough to approve or reject the deal. We still need to include acquisition costs, initial capital work, reserves, future renovations, financing fees, sale assumptions, and the timing of equity contributions and distributions. We also need to compare the 6.31% going-in cap rate with the property’s condition, location, growth prospects, financing cost, and relevant market evidence.

Suppose the seller’s analysis used $560,000 of NOI. The $55,000 difference may come from lower vacancy, an omitted management fee, historical insurance, or repairs that do not reflect the property’s condition. At a 6.50% cap rate, that difference in NOI represents roughly $846,000 of implied value. Small operating assumptions can therefore have a large effect on the price an investor believes the property supports.

How Multifamily and Commercial Underwriting Differ

The framework is consistent across income-producing properties, but the work is not interchangeable. Multifamily properties usually have many shorter leases, allowing revenue to reset more frequently while creating continual turnover and collection activity. Commercial properties may have fewer tenants and longer leases, which can stabilize current revenue while concentrating rollover and credit risk.

Area	Multifamily emphasis	Commercial emphasis
Revenue	Unit rent, occupancy, concessions, bad debt and other income	Lease-by-lease rent, escalations, reimbursements and tenant credit
Lease risk	Frequent turnover across many units	Concentrated expirations, options and downtime
Capital needs	Unit turns, recurring replacements and amenities	Tenant improvements, leasing commissions and building systems
Expenses	Payroll, utilities, repairs, taxes, insurance and management	Recoverability, expense stops, caps and owner obligations
Market evidence	Comparable units, concessions, absorption and supply	Comparable leases, tenant demand, vacancy and rollover economics

Common Real Estate Underwriting Mistakes

·       Treating the offering memorandum as verified source data.

·       Using scheduled rent when collections are materially lower.

·       Projecting market rent without modeling the time and cost required to achieve it.

·       Accepting historical property tax, insurance, repairs, or management costs without normalization.

·       Confusing NOI with cash flow available to equity.

·       Calculating returns before all acquisition, financing, capital, and sale costs.

·       Using aggressive rent growth and a more favorable exit cap rate in the same base case.

·       Ignoring loan maturity, covenant, reserve, and refinancing risk.

·       Hard-coding formulas or mixing inputs and calculations so the model cannot be audited.

·       Relying on one base case without sensitivity analysis or a written list of unresolved due diligence items.

A Practical Underwriting Checklist

1.     Define the decision and the required depth of analysis.

2.     Create a source-document index and note missing information.

3.     Reconcile the rent roll, operating statements, and actual collections.

4.     Build potential gross income and explicit vacancy, concession, and credit-loss assumptions.

5.     Normalize each operating expense using historical records and market evidence.

6.     Calculate NOI using a clearly disclosed convention.

7.     Value the property using a supportable cap rate and, when needed, a discounted cash flow.

8.     Model realistic loan terms, reserves, covenants, and maturity.

9.     Include the complete equity requirement and the timing of future capital.

10.  Calculate property-level cash flow and investor-level returns separately.

11.  Model sale proceeds after transaction costs and loan payoff.

12.  Stress-test the assumptions that control value, liquidity, and return.

13.  Track due diligence findings and update the model before final approval.

When a Focused Underwriting Consultation Can Help

A focused consultation can be useful when you have a specific decision and a manageable set of facts: reviewing a model, identifying missing assumptions, testing a purchase price, comparing loan options, or deciding what to investigate before an offer. Walutes Capital offers a 30-minute Zoom consultation for $75. We can review documents and models during the call, and each consultation includes a follow-up email with salient points or models discussed.

If you want an independent review from the combined perspective of a CPA, investor, developer, and asset manager, book a 30-minute real estate consultation.

A larger engagement may be appropriate when the work requires a model to be built or rebuilt, extensive source-document validation, lease abstraction, market research, multiple financing structures, partnership waterfalls, development feasibility, or continued updates through diligence. Those services are scoped separately on a case-by-case basis.

Continue Building Your Underwriting Process

For a broader treatment of homeownership, rental analysis, multifamily underwriting, development, bookkeeping, and real estate taxation, review The Investor’s Guide to Real Estate. The book page also includes free calculators and financial models, including a multifamily pro forma.

For project-based support, review Walutes Capital’s real estate development, asset management, accounting, underwriting, and financial-modeling services.

Frequently Asked Questions

What does underwriting mean in real estate?

Underwriting is the process of evaluating a property’s expected income, expenses, value, financing, returns, and risks. Investors use it to make acquisition and capital-allocation decisions; lenders use it to evaluate repayment and collateral risk.

What documents are needed to underwrite a multifamily property?

A useful starting package includes the rent roll, trailing 12-month operating statement, prior financial statements, collection and delinquency reports, leases, tax and insurance information, utility bills, payroll and contracts, capital history, and physical due-diligence information.

What is NOI in real estate underwriting?

Net operating income is effective gross income less recurring property operating expenses before debt service, income taxes, depreciation, and owner-level financing costs. The exact treatment of certain reserves and capital items should be disclosed and applied consistently.

How do cap rate and DSCR differ?

A cap rate relates property NOI to property value or price. DSCR relates underwritten NOI to annual debt service. Cap rate helps evaluate pricing and yield at the property level; DSCR helps evaluate debt capacity and repayment cushion.

Is multifamily underwriting different from commercial underwriting?

The core process is similar, but the revenue and risk analysis differs. Multifamily underwriting emphasizes unit-level rents, recurring turnover, collections, and operating expenses. Commercial underwriting often requires lease-by-lease review of tenant credit, reimbursements, rollover, tenant improvements, and leasing commissions.

Can a 30-minute consultation include a model review?

Yes. Walutes Capital can review documents and models during a 30-minute consultation when the question is focused. Building or validating a detailed model or conducting extensive diligence generally requires a separately scoped engagement.

Disclaimer

This article is provided for general educational and informational purposes only. It does not constitute tax, accounting, legal, investment, 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 tax and legal consequences vary based on each investor’s facts and applicable law. Before making an investment or implementing a tax, accounting, or legal strategy, consult qualified professionals who can evaluate your specific situation. A 30-minute consultation does not establish a formal CPA, tax-preparation, legal, or investment-advisory engagement.