Does This Rental Property Actually Make Money in 2026? How to Run the Numbers

The question every investor is asking in 2026: does this rental actually make money?

With 30-year fixed mortgage rates sitting in the low-to-mid 6% range and showing no signs of dropping below 6% any time soon, the math on rental property has quietly changed. A deal that printed money at 3% can bleed cash at 6.4%. That is why the single most-searched question among investors right now is brutally simple: is this rental property actually worth it?

The honest answer is that you cannot know from the listing price or the seller's pro forma. You only know after you run the real numbers — the cash flow, the cash-on-cash return, the IRR, and a stress test against the things that go wrong. This guide walks you through exactly how to do that, and gives you a faster way to do it at the end.

Why "good on paper" deals lose money in 2026

Here is a scenario that plays out constantly. The seller's numbers show $3,200 in monthly rent and $2,400 in expenses — a tidy $800 of monthly cash flow. You buy it. Six months later you are writing checks to cover a shortfall. What happened? The taxes were underestimated, monthly maintenance was ignored, and the pro forma assumed zero vacancy. Mistakes like these routinely cost investors thousands of dollars a year and turn a "profitable" property into an expensive hobby.

At today's rates, the margin for that kind of error has all but disappeared. When financing is expensive, your monthly mortgage payment eats a far bigger slice of the rent, and a property can flip from positive to negative cash flow on a single wrong assumption. The protection against that is not optimism. It is analysis.

The four numbers that tell you if a rental is worth buying

1. Monthly cash flow

Cash flow is the money left over after every expense is paid — mortgage, property taxes, insurance, maintenance, management, and reserves for vacancy. Positive cash flow means the property pays you every month. Negative cash flow means you pay the property. Many investors will accept $200–$300 of negative cash flow betting on appreciation, but that strategy requires deep reserves and real risk tolerance. In 2026, with prices forecast to rise only modestly, betting purely on appreciation is a dangerous game.

2. Cash-on-cash return

This is the annual cash flow divided by the actual cash you put into the deal (down payment, closing costs, renovation). It tells you how hard your invested money is working. Conservative investors target 8–12%. If a property's cash-on-cash return is lower than what you would earn in a far more liquid investment, that is a signal to negotiate harder or walk away.

3. IRR and equity IRR

The internal rate of return folds together everything — your initial equity, the cash flow each year, and the eventual sale proceeds — into a single annualized percentage. Equity IRR is the version that matters most to you, because it measures the return on the capital you actually invested after financing costs. It is also the cleanest way to compare a real estate deal against what you might earn in the stock market.

4. Return on equity (ROE) and NPV

Return on equity shows your profit as a percentage of the equity you put in. Net present value (NPV) tells you whether the deal clears your required rate of return: a positive NPV means the returns exceed your discount rate, a negative NPV means they fall short. Together, these two numbers separate a genuinely good deal from one that merely looks busy on a spreadsheet.

The step serious investors never skip: the stress test

Knowing your numbers in the base case is not enough. The investors who survive are the ones who ask "what if I'm wrong?" before they sign. What happens to your IRR if you end up paying 5% more than planned? What if rent comes in 10% lower than the market suggested? What if the sale price in year ten disappoints?

This is called sensitivity analysis (or elasticity analysis), and it does two powerful things. First, it gives you a clear walk-away price — the maximum you can pay before the deal stops working. Second, it hands you negotiation leverage, because you know exactly how much room you have. A deal that holds up under a stress test is a deal worth pursuing. One that only works in a perfect world is a trap.

How to run all of this without building a spreadsheet from scratch

You can absolutely build these calculations yourself in Excel. But getting IRR, MIRR, NPV, amortization across five financing methods, a 30-year cash flow projection, and a two-variable sensitivity table to all work together correctly — with no formula errors — takes serious time and financial modeling know-how. Most investors either get it wrong or give up and rely on gut feel.

That is exactly the problem our Professional Real Estate Investment Bundle solves. It is two professional Excel tools that work together the way real investors actually make decisions:

• The 5-Deal Analyzer — enter up to five properties side by side (purchase price, rent, expenses, loan details) and instantly see which one delivers the best cash flow, ROE, and equity IRR. This is your screening tool: filter a pile of listings down to your strongest candidate in minutes.
• The Advanced Calculator — take your top deal and analyze it in depth: ROI, ROE, IRR, MIRR, equity IRR, NPV, cash-on-cash return, payback period, and a built-in stress test. Switch between five financing methods (fixed-rate, fixed-rate with extra principal, adjustable-rate, interest-only, and fixed principal) with a single change to see exactly how leverage and today's rates affect your return.

Just enter your numbers in the white cells — the formulas are protected, the calculations are automatic, and there is nothing to set up. A single bad purchase can cost you tens of thousands of dollars over the life of a deal. The right analysis pays for itself the first time it helps you walk away from a property that looked good on the surface but failed under pressure.

The bottom line

In a 6%-plus rate environment, "I think it'll cash flow" is not a strategy — it is a gamble. The investors who win in 2026 are the ones who screen fast, analyze deeply, and stress test before they commit a single dollar. Run the real numbers first. Then decide with confidence.

→ Get the Professional Real Estate Investment Bundle and analyze your next deal today.