Real Estate Deal Analysis and Underwriting: A Comprehensive Guide to Analyzing a Property

Real estate deal analysis workspace with a model house, calculator, laptop, and investment documents.

Real estate deal analysis is the process of turning a property opportunity into a defensible investment decision.

A listing may tell you the asking price, bedroom count, square footage, projected rent, or seller-reported expenses. It does not tell you whether the investment actually works.

That requires analysis. The goal is to test the deal using realistic income, realistic expenses, financing terms, capital requirements, return metrics, and downside scenarios before you commit money.

A strong analysis answers more than one question.

It asks:

  • What does the property earn before financing?
  • What will the property cost to operate?
  • How much cash will I need to invest?
  • How much debt will the property carry?
  • What cash flow remains after debt service?
  • Which return metrics are relevant?
  • What happens if rent, vacancy, expenses, or financing are worse than expected?
  • What assumptions still need to be verified?
  • Does the deal justify proceeding, negotiating, investigating further, restructuring, or passing?

No single metric can answer all of those questions. That is why real estate deal analysis works best as a sequence: verify the inputs → model the property economics → add financing → calculate returns → stress-test the assumptions → make a decision.

This guide follows the complete decision path: assemble credible inputs, separate property performance from financing, test realistic downside scenarios, and decide what deserves further diligence.

It also explains how the analysis changes for rentals, commercial properties, renovations, and other investment strategies, so you can identify the calculations and evidence your particular property requires.

Deal analysis asks whether an opportunity fits your objectives and makes economic sense at the proposed price.

Real estate underwriting is the evidence-based part of that decision: verifying income, expenses, capital requirements and financing assumptions, then testing whether the investment remains viable when those assumptions change.

The two disciplines overlap, but they are not identical. The sections below explain how to evaluate an opportunity and test the investment case.

What Is Real Estate Deal Analysis?

Real estate deal analysis is the investor-side process of evaluating the financial performance, capital requirements, financing structure, and risk of a specific property opportunity.

It sits between broad real estate investing education and the decision to actually commit capital.

For a long-term rental property, analysis may include:

  • purchase price;
  • closing costs;
  • immediate repairs;
  • scheduled rent;
  • vacancy;
  • operating expenses;
  • net operating income;
  • financing;
  • debt service;
  • cash flow;
  • cash invested;
  • cap rate;
  • cash-on-cash return;
  • debt service coverage;
  • reserve needs;
  • and downside scenarios.

For a different strategy, some inputs will change. A fix-and-flip analysis, for example, may focus more heavily on acquisition cost, rehabilitation cost, holding cost, sale price, and transaction costs.

A commercial property may require deeper analysis of rent rolls, lease terms, tenant credit, recoveries, and operating statements.

But the core discipline remains the same: replace assumptions with evidence wherever possible, separate property performance from financing, and understand how the investment behaves when conditions are less favorable than the base case.

Deal Analysis vs Underwriting vs Due Diligence

These terms overlap, but they are not identical.

ProcessMain QuestionTypical FocusWhen It Happens
Deal analysisDoes this opportunity appear to meet my investment criteria?Income, expenses, financing, returns, riskEarly screening through decision-making
UnderwritingAre the assumptions defensible, normalized, and resilient under stress?Verified inputs, normalized economics, scenarios, debt coverageDuring deeper financial analysis
Due diligenceAre the property, legal, physical, financial, and transaction facts actually what I believe them to be?Inspections, title, leases, records, zoning, insurance, documentsBefore closing and capital commitment

Deal Analysis

Deal analysis is the broadest investor decision process.

It helps you decide whether a property deserves more time, whether the price makes sense, and whether the opportunity fits your strategy.

Underwriting

Underwriting is the more formal financial discipline inside that process. It takes the proposed assumptions and asks whether they are:

  • supported by evidence;
  • properly classified;
  • conservative enough;
  • internally consistent;
  • and resilient under downside conditions.

In practice, experienced investors often use the terms “deal analysis” and “underwriting” interchangeably.

The important distinction is functional: underwriting is not simply entering numbers into a spreadsheet. It is the process of deciding which numbers deserve to be entered and how much confidence to place in them.

Investor Underwriting vs Lender Underwriting

An investor typically underwrites the purchase price, property cash flow, required equity, holding period, likely exit, workload, and potential loss.

A lender primarily assesses whether the proposed loan meets its repayment, collateral, borrower, and risk requirements.

Both may examine income, expenses, property condition, and debt coverage, but their objectives and calculation conventions can differ.

A property might satisfy a lender’s minimum coverage test yet fail the investor’s return or liquidity requirements.

Conversely, an investor may find a property attractive but discover that the available financing cannot support the proposed debt amount or timetable. Treat lender terms as evidence to incorporate into your model, not as independent proof that the investment is a good deal.

Due Diligence

Due diligence is the verification stage. It asks whether the physical property, legal rights, leases, expenses, title, zoning, insurance, association documents, financing conditions, and other material facts support the assumptions in your model.

A deal can look attractive during preliminary analysis and still fail during due diligence. That is not a failure of the process. It is the process working correctly.

For commercial acquisitions, our commercial property due diligence guide explains how to verify leases, collection records, property condition, legal documents, and unresolved exceptions before making a transaction decision.

How the stages connect: Start with a quick screen to reject obvious mismatches, develop evidence-backed underwriting for promising opportunities, and use focused due diligence to resolve material uncertainties before committing capital.

These stages often overlap: reviewing leases, requesting insurance quotes, or inspecting the property may begin while the financial model is still being refined. A favorable spreadsheet is a reason to investigate, not proof that the transaction is ready to close.

The Inputs Every Real Estate Deal Analysis Needs

A deal model is only as useful as the assumptions inside it. That means the first job is not calculating a return. It is building a reliable input set.

Document and Verify the Assumptions

Before relying on a projected return, keep an assumption log alongside the deal model. For each important figure, record the amount, source, source date, whether it is actual or estimated, and what remains unverified.

Label seller projections and broker pro formas as projections rather than treating them as collected income or paid expenses.

  • Rent and collections: compare signed leases and the rent roll with bank deposits or collection reports; note arrears, concessions, lease expirations, and the date each record covers.
  • Vacancy and market rent: distinguish historical occupancy from a forward-looking assumption; check relevant rental comparables and the property’s leasing condition.
  • Taxes and insurance: check the current tax bill and possible post-sale reassessment, then obtain a property-specific insurance indication or quote rather than copying the seller’s premiums.
  • Repairs and replacements: use inspections, contractor scopes, age and condition of major systems, and a clearly labeled allowance for costs not yet quoted.
  • Loan terms and cash required: distinguish an illustrative financing scenario from lender-provided terms; record the rate, debt amount, fees, amortization, reserves, and any maturity or refinancing exposure.
  • Future sale or refinance: date supporting comparable evidence and label exit price, cap rate, timing, and transaction costs as estimates rather than guaranteed results.

When a house is being converted from owner occupancy to a tenant-occupied rental, the seller’s homeowners premium may not reflect the buyer’s insurance needs. Our landlord insurance vs homeowners insurance comparison explains how to check eligibility for the intended rental use, review policy limitations, and obtain a written quote suited to the property before underwriting the cost.

Assign each input an evidence status such as verified, contractual, estimated, or unresolved. Move consequential gaps into the due-diligence request list and test their downside effect in the model.

When new documentation arrives, update the input and its date instead of silently overwriting the old assumption.

Acquisition Inputs

Purchase Price

The purchase price is the starting point, but not the full cost of the investment.

A property can be attractively priced and still require too much additional capital to produce an acceptable return.

Closing and Acquisition Costs

Depending on the transaction, acquisition costs may include:

  • lender fees;
  • appraisal costs;
  • title or settlement costs;
  • inspections;
  • legal or recording fees;
  • prepaid taxes or insurance;
  • transfer-related costs;
  • and other closing charges.

The CFPB explains that mortgage transactions can involve more than the loan amount itself, including closing and upfront costs that affect the total cash required. Its overview of mortgage costs is a useful reminder that financing has transaction-level costs beyond principal and interest.

Immediate Repairs or Renovation

If the property requires work before stabilization, those costs belong in the acquisition model.

Examples can include:

  • deferred maintenance;
  • safety corrections;
  • paint and flooring;
  • appliance replacement;
  • roofing;
  • plumbing;
  • electrical work;
  • HVAC;
  • unit turns;
  • or larger renovation work.

The important point is to separate the purchase price from the total cost to put the property into the condition required by the investment plan.

Initial Cash Requirement

A useful deal analysis should ultimately answer: How much actual investor cash must be committed before the property reaches the expected operating condition?

That may include:

  • down payment or acquisition equity;
  • closing costs;
  • immediate repairs;
  • initial reserves;
  • lender-required reserves;
  • prepaid costs;
  • and other cash paid at or shortly after closing.

Income Inputs

Scheduled Rent

Use the rent the property can realistically support, not the highest number you can find.

Useful evidence can include:

  • current leases;
  • actual rent rolls;
  • comparable rentals;
  • recent signed leases;
  • unit condition;
  • concessions;
  • amenities;
  • and local leasing competition.

For an occupied property, actual contractual rent matters. For a vacant property, market rent must be estimated carefully.

For a value-add property, future rent should be treated as an assumption that still depends on successful execution.

Other Property Income

Depending on the property, other recurring income might include:

  • parking;
  • laundry;
  • storage;
  • pet-related charges;
  • utility reimbursements;
  • or other lawful property-level income.

Do not assume every possible fee is collectible or appropriate. Use only income that is legally permitted, operationally realistic, and supported by the investment model.

Vacancy and Credit Loss

Scheduled rent is not the same as collected rent. Vacancy, turnover, nonpayment, concessions, and leasing delays can reduce actual income.

A model that assumes 100% occupancy and 100% collection indefinitely is usually too optimistic.

Operating-Expense Inputs

Operating expenses are the recurring costs required to run the property.

Common categories include:

  • property taxes;
  • insurance;
  • repairs;
  • maintenance;
  • property management;
  • utilities paid by the owner;
  • association fees;
  • landscaping;
  • pest control;
  • licensing;
  • inspections;
  • administrative costs;
  • and other recurring property-level expenses.

For residential rentals, IRS Publication 527 provides federal tax guidance on rental income, expenses, depreciation, and related reporting.

Its tax categories can help investors recognize costs they may need to account for, but tax treatment should not be used as a substitute for investment-performance definitions.

For the broader federal tax framework covering rental income, deductions, depreciation, basis, passive-loss rules, and 1031 exchanges, see Real Estate Investing Taxes.

Repairs vs Capital Expenditures

Routine repairs and major replacements should not be blended thoughtlessly.

A property can appear profitable in a short period while still requiring major capital spending later.

Roofing, HVAC systems, plumbing, electrical systems, exterior components, parking surfaces, and major appliances all have useful lives.

An investor should understand how future replacements affect the economic picture even when the exact timing is uncertain.

Financing Inputs

Financing changes the investor’s cash requirement and return profile.

Key inputs can include:

  • loan amount;
  • interest rate;
  • amortization period;
  • maturity;
  • loan fees;
  • points;
  • required reserves;
  • prepayment terms where relevant;
  • and annual debt service.

The CFPB’s explanation of what a mortgage is is useful for separating the debt obligation from the property itself.

The property produces operating economics. The financing determines how those economics are divided between the lender and the investor. That distinction matters throughout deal analysis.

Hold and Exit Assumptions

Some analyses also model:

  • holding period;
  • future sale price;
  • selling costs;
  • refinance assumptions;
  • and terminal value.

These assumptions can materially affect metrics such as IRR and equity multiple. The farther into the future an assumption reaches, the more uncertainty it usually carries.

A strong model should not hide that uncertainty behind precise-looking numbers.

From Gross Income to Net Operating Income

One of the most useful analytical steps is separating property income from property operating expenses before financing. The basic operating bridge is:

Potential Gross Income

minus Vacancy and Credit Loss

equals Effective Gross Income

minus Operating Expenses

equals Net Operating Income

Or more simply: NOI = effective property income − operating expenses

NOI is one of the central building blocks of real estate analysis because it measures the property’s operating performance before financing.

What NOI Includes

NOI generally reflects property-level income less recurring operating expenses before financing.

Capital expenditures and replacement reserves may be handled separately depending on the underwriting convention, so the model should define its treatment consistently.

Tax deductibility is a separate question from NOI classification.

Use a consistent calculation convention: recurring, property-level operating expenses reduce NOI; interest and loan principal payments do not.

Major capital replacements are commonly shown separately from recurring operations, while some lender models also apply a replacement-reserve deduction when calculating coverage.

An estimated annual replacement allowance is not the same as a completed capital expenditure, an opening cash reserve, or a lender-required account balance.

State which figure appears above or below NOI, and avoid deducting the same cost twice.

What NOI Does Not Include

Debt service is excluded from NOI. Mortgage principal and interest are financing costs, not property operating expenses.

This distinction matters because two investors can own the same property with the same NOI but have very different cash flow depending on how the property is financed.

To calculate property-level operating income before financing, see Net Operating Income for Rental Property.

Core Real Estate Deal Analysis Metrics

No single metric tells you whether a deal is good. Each metric answers a different question.

MetricWhat It Helps AnswerFinancing-Sensitive?What It Does Not Tell You
NOIHow much operating income does the property produce before debt?NoInvestor cash flow after financing
Cap rateWhat is the property’s unleveraged income yield relative to value or price?NoLeveraged investor return
Cash flowHow much cash remains after modeled property costs and debt service?YesTotal return or long-term equity growth
Cash-on-cash returnWhat cash return is being produced relative to investor cash invested?YesAppreciation or total multi-year return
DSCRHow well does property income cover annual debt service?YesInvestor total return
GRMHow does price compare with gross rent?NoExpenses, financing, or actual profitability
Break-even occupancyRoughly how much occupancy is required to cover the obligations included in the model?Depends on formulaLong-term total return
IRRWhat annualized return is implied by the timing of modeled cash flows?YesWhether the assumptions are realistic
Equity multipleHow much total cash is projected to be returned relative to equity invested?YesHow long it takes to earn that return

Net Operating Income

NOI is the foundation for several other metrics. It is useful because it separates the property’s operating performance from financing.

Cap Rate

Cap rate is commonly calculated as: Cap Rate = NOI ÷ Property Value or Purchase Price

Cap rate can help compare income-producing properties on an unleveraged basis.

For the complete rental-specific calculation and interpretation process, see our Rental Property Cap Rate guide.

But cap rate does not tell you:

  • your actual mortgage payment;
  • your cash invested;
  • your cash-on-cash return;
  • your future appreciation;
  • or your total investment return.

There is no universal “good cap rate” that applies to every market, property, strategy, and risk profile.

Cash Flow

Cash flow is the cash remaining after the income and modeled obligations included in your analysis are paid. For a financed rental, debt service is a major difference between NOI and investor cash flow.

For clarity, distinguish cash flow after debt service from cash remaining after a separately modeled replacement allowance.

The latter is a planning view that may be lower even when the allowance has not yet been spent. Cash-on-cash calculations should identify which cash-flow measure is used, and their denominator should reflect the initial investor cash committed under the stated assumptions.

Lenders may use their own DSCR and reserve conventions, so do not assume a single definition or approval threshold applies to every loan.

For a rental-specific calculation process, see our Rental Property Cash Flow guide for income, vacancy, operating expenses, debt service, reserves, and worked examples.

Cash-on-Cash Return

Cash-on-cash return compares annual pre-tax cash flow with the amount of investor cash committed.

A simplified form is: Cash-on-Cash Return = Annual Pre-Tax Cash Flow ÷ Total Cash Invested

This metric is financing-sensitive.

A lower down payment reduces the cash invested but generally increases debt service. Depending on how those effects interact, cash-on-cash return can rise or fall; leverage and downside sensitivity generally increase.

Debt Service Coverage Ratio

DSCR compares operating income with debt service.

A common formulation is: DSCR = NOI ÷ Annual Debt Service

The Office of the Comptroller of the Currency describes DSCR as a measure that relates net operating income to annual debt service in real estate underwriting. Its Commercial Real Estate Lending handbook also emphasizes cash-flow analysis and sensitivity testing as underwriting disciplines.

This does not mean one universal DSCR threshold applies to every investor, property, or lender.

Different lenders and loan structures can use different requirements.

Gross Rent Multiplier

GRM compares property price with gross rent. It is fast, but limited.

It ignores:

  • operating expenses;
  • financing;
  • vacancy;
  • capital expenditures;
  • and management quality.

That makes GRM a screening metric, not a complete underwriting result.

Break-Even Occupancy

Break-even occupancy estimates the occupancy level needed for property income to cover the obligations included in the model.

It can be useful for understanding how much vacancy pressure the property can absorb.

If the break-even calculation includes debt service, financing affects the result. If it is calculated only against property operating costs, it does not.

Internal Rate of Return

IRR measures the annualized return implied by the timing of modeled cash flows.

It can incorporate:

  • operating cash flow;
  • additional capital contributions;
  • refinance proceeds;
  • sale proceeds;
  • and holding period.

IRR can be useful in multi-year analysis, but it is highly sensitive to assumptions about future cash flows and exit value.

Equity Multiple

Equity multiple compares total projected cash distributions with the total equity invested.

A 2.0x equity multiple, for example, means the model projects two dollars of total cash returned for every dollar of equity invested.

That total includes the return of the original invested equity, so a 2.0x equity multiple does not mean a 200% profit.

It does not tell you how quickly that return occurs. That is why IRR and equity multiple are often viewed together in more advanced analysis.

Property Economics vs Financing Economics

One of the most common beginner mistakes is mixing property performance with financing performance. These should be separated.

Property Economics

Property economics include:

  • rent;
  • vacancy;
  • other income;
  • operating expenses;
  • NOI;
  • and cap rate.

These describe how the asset performs before the investor’s financing structure.

Financing Economics

Financing economics include:

  • loan amount;
  • interest rate;
  • amortization;
  • annual debt service;
  • cash invested;
  • cash flow after debt;
  • cash-on-cash return;
  • and DSCR.

Why the Difference Matters

Consider two investors buying the same property at the same price.

The property has the same:

  • rent;
  • vacancy;
  • expenses;
  • NOI;
  • and cap rate.

But Investor A uses more debt. Investor B uses more cash. Their property economics are identical. Their investor-level economics are not.

Investor A may have:

  • lower initial cash invested;
  • higher debt service;
  • higher leverage;
  • and potentially greater sensitivity to income disruption.

Investor B may have:

  • more equity invested;
  • lower debt pressure;
  • lower financial leverage;
  • and a different cash-on-cash return.

This is why a property cannot be judged only by its cap rate or only by its cash flow. The property and the financing must both be understood.

How Deal Analysis Changes by Property and Investment Strategy

The same underwriting sequence applies across many investments, but the evidence, cash-flow timing, risk exposures, and most informative metrics change with the asset and business plan.

Use the following distinctions to choose the right level of analysis. Use these distinctions to identify the assumptions that require closer examination for your property.

Long-Term Rentals and Small Multifamily Properties

For an occupied rental, start with in-place lease terms, actual collections, turnover, taxes, insurance, management, maintenance, and replacement needs.

For vacant units, test a supported market-rent estimate and realistic lease-up time rather than immediately assuming full occupancy. Compare NOI with debt service and then examine investor cash flow after separately modeled capital allowances.

A duplex or small multifamily building adds unit-level questions: Are rents consistent across units? Do leases expire at the same time? Could one prolonged vacancy materially change coverage? Test rent changes, turnover costs, and replacement needs at the unit level before deciding whether the projected return is dependable.

Value-Add and BRRRR-Style Acquisitions

A value-add model has at least two economic states: the property as acquired and the property after repairs, leasing, or stabilization. Separate acquisition equity, renovation spending, carrying costs, contingency, stabilized income, and the timing required to reach the improved condition.

A future appraisal, refinance, or higher rent is an assumption to validate, not money already available.

Where a BRRRR-style plan depends on refinancing, test lower-than-expected appraised value, less favorable proceeds, delays, and the possibility that more capital remains tied up than planned. Underwrite acquisition, rehabilitation, lease-up, and refinancing as separate stages. Do not count potential refinance proceeds as available investor cash before the loan and valuation conditions are met.

Fix-and-Flip Investments

A flip is driven mainly by purchase and renovation costs, the time required to finish and sell, financing and holding expenses, and net sale proceeds rather than stabilized rental cash flow. Model selling commissions, transaction costs, permit or contractor delays, and a lower resale price.

A project can show a promising gross spread yet produce a poor result after the entire carrying period and selling costs are included.

Before committing, ask which costs are documented, which depend on project execution, and how much additional cash a slower sale would require. Test whether the projected profit remains acceptable after realistic financing, holding, and selling costs.

Commercial and Larger Income Properties

For commercial acquisitions, analysis often starts with a tenant-by-tenant rent roll, current operating statements, leases, concessions, reimbursement obligations, and near-term rollover exposure.

Tenant concentration, credit quality, recoverable expenses, major capital obligations, and lease renewal timing can materially affect the stability of NOI. Compare trailing actual performance with the buyer’s forward-looking underwriting, rather than treating them as interchangeable.

Loan structure, coverage definitions, maturity, and refinancing risk may also carry more weight. Compare each material lease and operating assumption with available records, then investigate unresolved tenant, property, financing, or legal issues before committing capital.

Development, Construction, and Lease-Up Projects

For a development proposal, current rental NOI may tell little about whether the investment will work.

The model instead centers on land and acquisition costs, entitlement and approval uncertainty, construction budget, contingency, financing draws, timelines, lease-up or sales assumptions, and the cash required before stabilization.

Delays can increase interest and holding costs while postponing revenue.

Keep separate scenarios for approval delays, construction overruns, weaker achieved rents or sales prices, and a slower completion.

Model the funding needs at each major milestone, including land control, approvals, construction, and occupancy or sale. Document the cost of delays and the additional equity required if revenue starts later than planned.

How to apply the differences: identify the investment type, list the assumptions that drive its returns, and follow the seven-step analysis below.

Use the relevant resources near the end when you need more detail about a calculation or a specific type of property.

How to Analyze a Real Estate Deal

A consistent workflow makes deal analysis easier to repeat and compare.

1. Define the Investment Criteria

Before analyzing a property, define what the investment is supposed to accomplish.

That may include:

  • target strategy;
  • property type;
  • price range;
  • maximum capital commitment;
  • minimum liquidity after closing;
  • desired holding period;
  • workload tolerance;
  • debt tolerance;
  • and risk constraints.

Without criteria, almost any property can be made to look attractive by choosing favorable assumptions.

If you already own multiple properties, use Real Estate Portfolio Management to test whether a new acquisition improves the portfolio’s capital allocation, liquidity, leverage, diversification, and concentration risk rather than judging the deal only on its standalone returns.

2. Verify and Normalize the Income

Start with evidence.

Ask:

  • What rent is actually being collected?
  • Are leases current?
  • Are there concessions?
  • Is the property fully occupied?
  • Are there arrears?
  • Are projected rents supported by comparable properties?
  • Are other income sources recurring and realistic?

Normalize the income so the model reflects what the property can reasonably support rather than what the marketing package suggests.

3. Build Realistic Operating Expenses

Do not rely on one generic expense percentage unless it is only being used for preliminary screening. Build the expenses from the property itself where possible.

Check:

  • taxes;
  • insurance;
  • management;
  • utilities;
  • repairs;
  • maintenance;
  • association fees;
  • licensing;
  • recurring services;
  • and replacement needs.

If the seller reports unusually low expenses, investigate why.

4. Calculate NOI and Unleveraged Performance

Once income and operating expenses are normalized, calculate NOI. Then use NOI to evaluate unleveraged property performance. This is where cap rate becomes useful.

The purpose is to understand the asset before financing changes the investor-level outcome.

5. Add Financing and Total Investor Cash Requirement

Next, add:

  • loan amount;
  • rate;
  • amortization;
  • annual debt service;
  • lender fees;
  • closing costs;
  • immediate repairs;
  • and reserves.

Calculate how much total cash the investor must commit. This is the denominator that matters for cash-on-cash analysis.

6. Calculate Leveraged Returns and Debt Coverage

Now calculate the financing-sensitive metrics.

These may include:

  • cash flow;
  • cash-on-cash return;
  • DSCR;
  • and break-even occupancy.

For longer holding periods, you may also model:

  • IRR;
  • equity multiple;
  • and sale/refinance scenarios.

7. Stress-Test the Assumptions and Make a Decision

Do not stop with the base case. Change the assumptions that are most likely to disappoint.

Then ask:

  • Does the property still work?
  • Which assumption is carrying the deal?
  • How much margin for error exists?
  • Is the financing too aggressive?
  • Is the asking price the problem?
  • Are there unverified facts that matter?
  • Would a reasonable downside case create unacceptable losses or liquidity pressure?

The result is not always “buy” or “pass.”

A good analysis may tell you to:

  • negotiate;
  • investigate further;
  • change financing;
  • lower the price;
  • revise the business plan;
  • or wait for better information.

How to Underwrite a Real Estate Deal

Deal analysis estimates whether an opportunity is worth pursuing. Underwriting challenges the assumptions until the result can be explained and supported.

A defensible model distinguishes observed performance from projections, records why adjustments were made, and identifies what must be confirmed before committing capital.

1. Reconcile Actual Performance with Contracts and Collections

Start with the documents the property can actually support. For an occupied building, compare current leases and the rent roll with recorded collections, concessions, delinquency, and occupancy.

For a larger income property, a trailing 12-month operating statement (often called a T-12) can provide a historical income-and-expense baseline.

Check the covered period and any missing months rather than treating the document as automatically complete.

Small or newly renovated properties may lack a reliable T-12. In that case, document which figures come from actual bills or contracts and which are estimated from comparable properties or third-party quotes. Do not convert projected market rent into historical collected income.

2. Normalize Income, Expenses, and Future Capital Needs

Adjust the historical picture for changes that a new owner can reasonably expect. Examples include possible property-tax reassessment, new insurance premiums, ordinary management costs even when the seller self-managed, leasing expenses, recurring maintenance, and known changes to contracted rent. Explain any removal of unusual one-time income or expenses; do not erase recurring costs simply because the seller labels them exceptional.

Before accepting a seller’s property-tax expense as the buyer’s projected cost, verify the parcel’s current assessment, exemptions, and potential reassessment after purchase. Our property tax on investment property guide explains how to verify official tax records, estimate buyer-specific property taxes, and assess their impact on net operating income.

Keep immediate rehabilitation, major future replacements, operating expenses, and lender-required reserves in distinct model lines. This helps prevent an overstated NOI or the same cost being counted twice. An underwriting adjustment should have an explanation and supporting document or an explicit uncertainty label.

3. Compare As-Is, Business-Plan, and Downside Outcomes

An as-is scenario represents the property and leases in their current condition. A business-plan scenario reflects improvements, rent changes, or lease-up only after the costs, timing, permits, and execution steps are considered.

A downside scenario tests weaker income, delayed occupancy, cost inflation, repair overruns, or a less favorable exit. The relevant scenarios depend on the strategy; a stabilized building will not require the same assumptions as a construction project.

Keep the differences visible. If a return relies heavily on future rents or refinance proceeds, show what happens if those assumptions are delayed or never materialize. Use the sensitivity results to identify the assumptions that deserve the most scrutiny.

4. Test Financing Requirements and Investor Liquidity

Use the financing terms actually available, or label them as illustrative when no firm offer exists. Model the loan amount, interest rate, amortization, fees, maturity, payment schedule, and reserve requirements.

Check debt coverage using clearly stated definitions, and confirm the lender’s own calculation conventions rather than assuming that a single DSCR threshold or loan-to-value limit applies to every property.

Then test cash left after closing, repairs, lender reserves, and potential operating shortfalls. Financing may improve an equity return in a favorable case while increasing the risk of missed payments or a forced sale in a weaker case.

5. Translate the Model into a Supportable Purchase Price

The asking price is an input, not the outcome of underwriting. Consider what price and financing terms would allow the deal to meet the investor’s required cash flow, risk tolerance, and available capital.

Recalculate returns when acquisition price, closing costs, repair scope, and debt amount change together rather than adjusting one metric in isolation.

If the deal only meets the criteria after unsupported rent growth or unusually favorable exit assumptions, the appropriate response may be a lower offer, a different financing structure, more investigation, or a decision to pass.

There is no universal cap rate, cash-on-cash target, or maximum price that fits every investment.

6. Prepare a Decision Summary and Due-Diligence Exceptions List

A useful underwriting summary records the date of analysis, purchase assumptions, evidence sources, actual versus projected NOI, planned capital spending, financing terms, base and downside returns, liquidity requirements, and the unresolved items that could change the decision.

Clearly label each outstanding issue, the evidence needed to resolve it, and what result would trigger renegotiation or rejection.

This record lets you compare opportunities on a consistent basis and revisit the rationale when a tax bill, insurance quote, inspection, lease, or lender term sheet changes. It also provides a practical handoff into due diligence without turning a preliminary estimate into a claim of certainty.

Example: Testing a Rental Property Deal Before You Buy

Consider a hypothetical long-term rental purchased for $240,000. The example is designed to show how the numbers connect, not to represent typical U.S. prices, prevailing mortgage offers, or a guaranteed investment return.

Suppose the buyer finances $180,000 at an illustrative fixed 6.5% interest rate amortized over 30 years, resulting in approximately $13,653 of annual principal-and-interest payments. This simplified model assumes no other debt-service charges.

Once any immediate repairs are finished and the property reaches the assumed operating condition, calculate property income and expenses separately from financing:

Annual underwriting lineHypothetical amount
Scheduled rental income$30,000
Less vacancy and credit loss (5%)−$1,500
Effective rental income$28,500
Less recurring property operating expenses−$10,500
Net operating income (NOI)$18,000
Less annual loan debt service−$13,653
Cash flow after debt service, before capital allowance$4,347
Less separately modeled annual replacement allowance−$1,800
Illustrative cash remaining after allowance$2,547

For the initial cash requirement, assume $60,000 down payment + $6,000 closing costs + $8,000 immediate repairs + $5,000 initially funded cash reserve = $79,000 investor cash committed.

The $5,000 opening reserve is an initial cash commitment, not a recurring NOI expense. The $1,800 annual replacement allowance is a separate forward-looking planning deduction; it is not assumed to be an additional upfront payment.

Read the Metrics Together

  • Cap rate: $18,000 NOI ÷ $240,000 purchase price = 7.50%, before financing.
  • Debt service coverage ratio: $18,000 NOI ÷ approximately $13,653 annual debt service = 1.32x, using the stated simplified NOI-based convention.
  • Cash-on-cash before the separate replacement allowance: approximately $4,347 ÷ $79,000 = 5.50%.
  • Cash-on-cash after the modeled replacement allowance: approximately $2,547 ÷ $79,000 = 3.22%. This is a reserve-adjusted planning view, not a claim that every lender or investor uses the same return convention.

Each figure answers a different question. The 7.50% cap rate describes income relative to price; 1.32x DSCR expresses modeled debt coverage; the two cash-on-cash figures show how a separately modeled capital allowance changes the investor’s estimated spendable cash. None, by itself, proves the price is appropriate or the assumptions are reliable.

Run a Downside Case Before Making the Decision

Now change only two assumptions: vacancy and credit loss rise from 5% to 10% of scheduled rent, and annual operating expenses increase by 10%, from $10,500 to $11,550.

With rent otherwise unchanged, effective income becomes $27,000 and NOI falls to $15,450. The same debt service produces a DSCR of approximately 1.13x; after $13,653 of debt service and the $1,800 planning allowance, modeled annual cash is approximately negative $3, effectively break-even before unexpected costs or tax consequences.

The conclusion is not automatically “buy” or “pass.” It is that a seemingly positive base case has limited cushion under these particular stresses.

Before proceeding, the investor might investigate expense estimates, seek firmer insurance and repair evidence, negotiate the price, change financing, increase available liquidity, or reject the deal if it no longer meets the investment criteria. These are hypothetical stress assumptions, not forecasts.

Keep the example in perspective: the model omits potential tax effects, appreciation, disposition costs, changing interest rates, and many property-specific considerations. It demonstrates how the underwriting calculations connect.

For a real acquisition, use current property documents and a more detailed rental analysis before committing capital.

Quick Screening vs Full Underwriting

Investors often need a fast way to decide whether a property deserves deeper analysis. That is where screening rules can help.

The problem begins when screening rules are treated as final underwriting.

The 1% Rule

The 1% rule compares monthly rent with purchase price. It is often used as a quick rental-property screen.

But it ignores:

  • property taxes;
  • insurance;
  • vacancy;
  • management;
  • repairs;
  • capital expenditures;
  • financing;
  • and local operating conditions.

It can help you prioritize deals. It cannot tell you whether the deal is actually profitable.

The 50% Rule

The 50% rule is a rough screening heuristic that assumes operating expenses may consume about half of gross rental income before debt service.

It is not a substitute for actual expenses. Properties in different markets can have very different:

  • tax burdens;
  • insurance costs;
  • utilities;
  • association fees;
  • maintenance requirements;
  • and management costs.

GRM

GRM can be useful for rough price-to-rent comparison. But because it ignores expenses and financing, it should remain a screening metric.

Headline Cap Rate

A stated cap rate can also be misleading when the underlying NOI is based on optimistic income or incomplete expenses. The cap rate is only as reliable as the NOI behind it.

Stress Testing and Sensitivity Analysis

A deal should not be judged only by its most optimistic expected outcome. Stress testing asks what happens when one or more assumptions move against you.

ScenarioRent / IncomeVacancyOperating CostsFinancing / CapitalExit Assumptions
Base caseSupported by current evidenceNormalized assumptionCurrent realistic estimateKnown or expected termsConservative planned case
DownsideBelow base caseHigherHigherLess favorableWeaker
Severe downsideMeaningfully below baseSustained high vacancySignificant cost pressureHigher debt burden or limited refinanceLower value / slower exit

The purpose is not to predict the future precisely. It is to identify what would break the investment thesis.

Rent Stress

Ask what happens if rent is lower than expected or grows more slowly.

Vacancy Stress

Ask how the property performs if turnover takes longer or collection is weaker.

Expense Stress

Increase the assumptions for:

  • repairs;
  • insurance;
  • taxes;
  • utilities;
  • management;
  • and capital expenditures.

Financing Stress

If the loan is not locked, ask what happens if:

  • the rate is higher;
  • proceeds are lower;
  • fees increase;
  • or required reserves increase.

Stabilization Stress

If the property requires renovation or lease-up, ask what happens if stabilization takes longer than planned.

Exit Stress

If the model depends on sale or refinance proceeds, test a less favorable future value. A deal that only works under the base case has very little margin for error.

Common Real Estate Deal Analysis Mistakes

Treating Rent Minus Mortgage as Profit

Mortgage payment is not the only property cost. Taxes, insurance, vacancy, repairs, management, capital expenditures, and other expenses still matter.

Trusting the Seller’s Pro Forma Without Verification

A pro forma is a set of assumptions. It is not proof.

Verify:

  • actual rent;
  • actual expenses;
  • actual occupancy;
  • current property-tax assessment and potential post-sale reassessment;
  • insurance;
  • and deferred maintenance.

Ignoring Vacancy

Even strong properties experience turnover. Vacancy should be modeled.

Assuming Self-Management Has No Economic Cost

An investor may choose to self-manage. That does not make management economically irrelevant.

A deal that only works because management is assumed to cost nothing may become fragile if professional management is later required.

Ignoring Capital Replacements

Routine repairs are not the same as future roof, HVAC, plumbing, electrical, or other major replacement needs.

Mixing Debt Service Into NOI

NOI measures property operations before financing. Debt service belongs below NOI in the investor cash-flow view.

Using Cap Rate as a Leveraged Return Metric

Cap rate does not reflect the investor’s mortgage. Cash-on-cash return and cash flow do.

Relying on One Screening Rule

A 1% rule, 50% rule, GRM, or headline cap rate can help screen. None should replace underwriting.

Assuming Appreciation

Appreciation can improve returns. It should not be treated as guaranteed.

Ignoring Reserves and Liquidity

An investment may appear affordable at closing while leaving the investor dangerously short of cash afterward.

Comparing Different Strategies With One Metric

A stabilized rental, heavy value-add project, short-term hold, and long-term development should not automatically be compared using one metric without understanding the underlying strategy and risk.

How to Decide Whether the Deal Works

Deal analysis is not about finding one universal number that says “buy.” It is about determining whether the full investment case is coherent.

Are the Inputs Defensible?

Can you explain where the rent, expenses, vacancy, repair, financing, and value assumptions came from? If not, the model may be precise without being reliable.

Does Current Operating Income Support the Thesis?

A deal should not depend entirely on future appreciation or aggressive future rent increases unless that risk is intentional and understood.

What Happens in a Downside Case?

Does the property still cover obligations? How much liquidity would be needed? How quickly could the investment become uncomfortable?

Does Financing Create Too Much Pressure?

Leverage can increase returns. It can also reduce the margin for error.

Is the Expected Return Adequate for the Risk and Workload?

A return cannot be evaluated without context. The amount of capital, time, complexity, concentration, leverage, and downside risk all matter.

An investment should also be manageable in the context of your personal wellbeing. Excessive debt pressure, persistent financial uncertainty, demanding property operations, and inadequate cash reserves can create significant stress. Consider whether the investment’s responsibilities and potential setbacks are compatible with your available time, financial security, and capacity to manage uncertainty.

Is Price the Variable That Needs to Change?

Sometimes the property is attractive but the asking price is not. Analysis can identify the price at which the deal becomes more defensible.

What Facts Remain Unverified?

A deal should not move forward simply because the spreadsheet looks good. If critical assumptions depend on information you have not verified, the next step may be due diligence rather than a purchase decision.

Buy, Negotiate, Investigate, Restructure, or Pass

A useful decision framework is:

DecisionWhen It May Fit
Proceed to deeper diligenceThe assumptions are defensible and the deal meets criteria
NegotiateThe property may work at a different price or term
Investigate furtherImportant facts remain uncertain
Restructure financingProperty economics are acceptable but the capital structure creates too much pressure
Revise assumptionsNew evidence changes the model
PassThe deal cannot meet criteria without unrealistic assumptions

A disciplined investor should be comfortable passing. The purpose of analysis is not to prove that a property is a good deal. It is to find out whether it is.

If the property is a rental and the numbers still support moving forward, see our How to Buy a Rental Property guide for the next steps from financing and making an offer through due diligence and closing.

Deal Analysis and Underwriting: Where to Go Next

Real estate deal analysis is a central decision layer, but several parts of the process deserve their own deeper treatment.

Find and Screen Real Estate Deal Opportunities

If you are still selecting a target, begin with investing fundamentals, market analysis, and property sourcing. Check whether the location, property type, and purchase opportunity fit your investment criteria before investing time in full underwriting.

If Your Next Question Is…Our Topics
How do I learn the broader fundamentals of property investing?Real Estate Investing
How do I find investment properties?Finding Investment Properties
How do I compare the broader market before underwriting individual properties?Real Estate Market Analysis

Financial Analysis and Underwriting Metrics

Once you have a specific property, use the metric explanations above for NOI, cap rate, cash-on-cash return, and DSCR. The rental-property analysis guide gives a more detailed property-specific approach to income, expenses, financing, and returns.

If Your Next Question Is…Our Topics
What exactly is net operating income?Net Operating Income
How do I calculate and interpret cap rate?Cap Rate
How do I calculate cash-on-cash return?Cash-on-Cash Return
How do I calculate and interpret DSCR?DSCR Ratio and Formula
How do I analyze a rental property specifically?Rental Property Analysis

Underwriting by Property and Investment Strategy

Different investment strategies call for different evidence and risk assumptions. Use the guide that matches the property you are considering, then test the income, costs, time horizon, and execution risks that matter most for that strategy.

If Your Next Question Is…Our Topics
How does long-term rental ownership work?Rental Property Investing
How does analysis change by investment strategy?Real Estate Investment Strategies
How does underwriting change for larger commercial property?Commercial Real Estate Investing

Financing, Debt Coverage, and Investment Decisions

Financing terms can change investor returns even when property NOI is unchanged. Compare debt-service obligations, lender fees, and reserves with expected cash flow. If you already own investments, consider liquidity, leverage, and concentration across your portfolio rather than judging only this acquisition.

If Your Next Question Is…Our Topics
How should I finance an investment property?Investment Property Financing

Use a deeper metric or strategy guide when you need more detail on a specific calculation or investment approach.

Frequently Asked Questions

What Is Real Estate Deal Analysis?

Real estate deal analysis is the process of evaluating a specific property opportunity using income, expenses, capital requirements, financing, return metrics, and risk assumptions before committing capital.

What Is the Difference Between Deal Analysis and Underwriting?

Deal analysis is the broader investor decision process. Underwriting is the more formal process of normalizing, verifying, and stress-testing the financial assumptions.

What Does It Mean to Underwrite a Real Estate Deal?

Underwriting means testing a property investment’s income, expenses, capital requirements, financing, valuation assumptions, and risks using the strongest available evidence. The objective is to build a documented case that can withstand reasonable downside scenarios, not simply to produce an attractive spreadsheet.

What Documents Are Needed to Underwrite a Property?

Documents depend on the property, but may include signed leases, a current rent roll, actual collection records, recent operating statements, property-tax and insurance information, repair or contractor estimates, comparable rentals or sales, and financing terms. Some smaller properties will not have formal operating statements, so the model should clearly identify what is verified and what remains estimated.

Is Lender Underwriting the Same as Investor Underwriting?

No. A lender focuses on repayment, collateral, borrower qualifications, and loan risk, while an investor also considers equity returns, opportunity cost, workload, liquidity, and the investment’s fit within a broader plan. A loan approval does not establish that the acquisition meets the investor’s objectives.

What Numbers Do You Need to Analyze an Investment Property?

At minimum, you typically need:

  • purchase price;
  • acquisition costs;
  • projected or actual income;
  • vacancy;
  • operating expenses;
  • immediate repairs;
  • financing terms;
  • annual debt service;
  • total cash invested;
  • and reserve assumptions.

More advanced models may also include exit value, refinance assumptions, IRR, and equity multiple.

Is NOI the Same as Cash Flow?

No. NOI measures property operating income before debt service. Cash flow is generally measured after the financing obligations included in the investor model.

Is Cap Rate Affected by Financing?

No. Cap rate is based on NOI and property value or purchase price. It is an unleveraged property metric.

What Is a Good Cap Rate?

There is no universal good cap rate. A cap rate must be interpreted in the context of:

  • property type;
  • market;
  • risk;
  • condition;
  • income quality;
  • growth expectations;
  • and the investor’s strategy.

What Is Cash-on-Cash Return?

Cash-on-cash return compares annual pre-tax cash flow with the total investor cash invested. Because it depends on cash invested and debt service, it is affected by financing.

What Does DSCR Measure?

DSCR measures the relationship between property income and annual debt service. It is commonly used to evaluate whether property cash flow provides enough coverage for the debt obligation.

Are the 1% and 50% Rules Reliable?

They can be useful for quick screening. They are not substitutes for actual underwriting because they do not fully account for the property’s real income, expenses, financing, condition, and risk.

How Do You Stress-Test a Real Estate Deal?

Change the assumptions that could reasonably underperform.

Common stress tests include:

  • lower rent;
  • higher vacancy;
  • higher expenses;
  • larger repairs;
  • higher financing costs;
  • slower stabilization;
  • and weaker exit assumptions.

Then evaluate whether the property still meets your criteria.

When Should You Pass on an Investment Property?

Passing may be appropriate when the deal only works under unrealistic assumptions, the downside risk is unacceptable, the capital requirement is too high, financing creates excessive pressure, critical facts cannot be verified, or the expected return does not justify the risk and workload.

A Good Deal Analysis Should Make the Decision Clearer

Real estate deal analysis is not about making a spreadsheet look impressive. It is about reducing uncertainty before capital is committed.

A useful analysis separates:

  • facts from assumptions;
  • property economics from financing;
  • operating income from investor cash flow;
  • screening from underwriting;
  • and expected performance from downside risk.

The process should leave you with a clear explanation of:

  • what the property earns;
  • what it costs to operate;
  • how much cash you must invest;
  • how financing changes the outcome;
  • which return metrics matter;
  • what assumptions create the most risk;
  • and what would cause you to proceed, negotiate, investigate further, restructure, or pass.

That is the purpose of real estate deal analysis: not to prove that a property is a good investment, but to determine whether the numbers, assumptions, and risks support the decision.