How to Analyze a Rental Property Deal: NOI, Cap Rate, Cash Flow and Cash-on-Cash Return

Every rental property looks good in the listing photos. The numbers are what tell you whether it is actually a good investment. The good news is that a solid first-pass analysis only needs five key metrics, and once you understand them you can screen deals in minutes.

Step 1: Estimate gross income

Start with the gross scheduled income: the rent the property would earn if every unit were occupied all year. Use market rent from comparable listings, not the seller’s optimistic figure.

Then subtract a vacancy allowance for months when a unit sits empty between tenants. The result is your effective gross income (EGI).

Step 2: Add up operating expenses

Operating expenses are the costs of running the property, excluding the mortgage. Typical items include:

Underestimating expenses is the most common reason deals disappoint.

Step 3: Calculate net operating income (NOI)

NOI = Effective gross income − Operating expenses

NOI is the property’s income before financing. It lets you compare properties regardless of how they are funded.

Step 4: Calculate the cap rate

Cap rate = NOI ÷ Purchase price

The capitalisation rate shows the unlevered return on the property. It is useful for comparing similar properties in the same market, but it ignores financing entirely.

Step 5: Add financing, cash flow and cash-on-cash return

Now bring in the loan:

A worked example

Here is a single-family rental analysed from start to finish.

Purchase and financing

Income

Operating expenses

Results

What the example teaches

A 6.5% cap rate might look reasonable, but at a 7% interest rate the property barely cash flows. A small repair or one extra month of vacancy could push it negative, and the DSCR of 1.09 leaves very little margin.

That does not automatically make it a bad deal. You might negotiate the price, increase rent after light improvements, choose different financing or accept low cash flow in exchange for expected appreciation. The point is to make that decision knowingly, with the numbers in front of you.

Common analysis mistakes

Faster, repeatable analysis

The Viqsa Deal Analyzer is a desktop app for Windows, macOS and Linux that calculates these metrics automatically for rentals, fix and flips, short-term rentals, BRRRR, commercial and multi-family deals. You can save your default assumptions, model different loan structures, run 30-year tax-aware projections and use the built-in AI Copilot to question your assumptions, all with your data stored locally on your machine.

Key takeaway: Always look at NOI, cap rate, cash flow, cash-on-cash return and DSCR together. A property can look strong on one metric and weak on another, and financing often makes the difference.

Mortgage Amortization Schedules Explained for Real Estate Investors

When you finance a rental property, the monthly mortgage payment is usually fixed. What changes every month is how that payment is split between interest and principal. That split, laid out month by month, is your amortization schedule, and it has a bigger effect on your returns than most investors realise.

How the monthly payment is calculated

For a standard fixed-rate loan, the payment is calculated so the loan is fully repaid by the end of the term:

Payment = P × r(1 + r)ⁿ ÷ [(1 + r)ⁿ − 1]

Each month, interest is charged on the remaining balance. Whatever is left of the payment reduces the principal.

A worked example

Take a $300,000 loan at 6.5% over 30 years:

In the first month, about 86% of the payment is interest. As the balance falls, the interest portion shrinks and the principal portion grows:

Over the full 30 years, total interest comes to roughly $382,600, more than the original loan.

Why this matters for investors

Equity builds slowly at first

Principal paydown is a real part of your return, but in the early years it is small. If you plan to sell or refinance within five years, most of what you paid went to interest.

Your true return includes loan paydown

Cash flow is only one piece. Equity from principal paydown adds to your total return every month, even when cash flow is thin. A good analysis shows both.

Refinancing resets the clock

A new 30-year loan starts the amortization schedule again, with mostly interest in the early payments. That can improve monthly cash flow, but it slows equity growth.

Comparing loan terms

The same $300,000 at 6.5% over 15 years costs about $2,613 a month, around $717 more than the 30-year loan. Total interest falls to roughly $170,400, less than half.

For investors, the right choice depends on strategy:

The effect of extra payments

Adding $200 a month to the 30-year example pays the loan off in about 23 years instead of 30 and saves roughly $103,000 in interest. Extra payments go straight to principal, so they have the most impact early in the loan.

Whether that beats investing the $200 elsewhere, such as in your next down payment, depends on your interest rate and your expected returns.

Other loan structures investors use

Real-world financing is often more complex than a simple fixed-rate mortgage:

Each changes cash flow and risk, so model them before you commit.

Modelling amortization in your analysis

The Viqsa Deal Analyzer builds full amortization schedules automatically and supports the loan structures investors actually use. Because it links the schedule to 30-year projections, you can see cash flow, principal paydown and equity growth together, and compare different financing options side by side before you make an offer.

Key takeaway: Two loans with similar payments can produce very different long-term results. Look at the amortization schedule, not just the monthly payment, to understand how much of your return comes from equity and how quickly it builds.

Why 30-Year, Tax-Aware Projections Matter in Real Estate Investing

Most quick deal analyses stop at year one: what does the property earn today, after expenses and the mortgage? That is a useful filter, but it can badly misjudge a deal. A property with thin cash flow today can be an excellent long-term investment, and a property with strong year-one numbers can disappoint over time.

Long-term projections close that gap.

What year-one analysis misses

A single-year snapshot ignores several forces that shape real estate returns:

The four sources of real estate return

A long-term projection shows how each of these builds over time:

  1. Cash flow from rent after expenses and debt service
  2. Principal paydown from the mortgage balance falling
  3. Appreciation in the property’s market value
  4. Tax effects, including depreciation that can offset rental income

Looking at all four together is the only way to compare, for example, a high-cash-flow property in a slow market with a lower-cash-flow property in a growing one.

Why taxes belong in the model

Two investors can buy identical properties and end up with very different after-tax results. Depreciation can reduce taxable rental income for years, while tax on the eventual sale can take a meaningful share of the gain. A tax-aware projection shows returns on an after-tax basis, which is the number that matters to you.

Tax rules vary by country, state and personal situation, so always confirm your specific assumptions with a qualified tax professional.

Assumptions that matter most

Long-term projections are only as good as their inputs. Pay close attention to:

Use scenarios, not a single forecast

Nobody knows exactly what rents or values will do. Instead of one projection, compare three:

If a deal only works in the optimistic scenario, that tells you something important about its risk.

Metrics to compare over time

For each year of the projection, look at:

That last point is often overlooked. As equity grows, return on equity usually falls. Projections help you decide when a refinance or a sale and reinvestment makes sense.

Building projections without a giant spreadsheet

Custom spreadsheets can model all of this, but they are time-consuming to build and easy to break. The Viqsa Deal Analyzer includes a long-term investment forecast with 30-year, tax-aware projections and full amortization schedules. You can save default assumptions, compare scenarios and export results to share with partners or lenders. It runs as a desktop app with your data stored locally, and its AI Copilot can help you test the assumptions behind each projection.

Key takeaway: Judge a property by its full return over your holding period, including cash flow, loan paydown, appreciation and taxes, under more than one scenario. Year-one numbers are the starting point, not the answer.