Is This Rental Property Actually a Good Deal?
You’ve found a potential rental property. It looks nice, the neighborhood is decent, and the numbers seem okay on the surface. But before you pull the trigger on a $200,000+ investment, you need to actually know if it’s a good deal.
Too many new investors jump into rental properties based on gut feeling or FOMO (fear of missing out). Then six months in, they realize the cash flow is terrible, the expenses are higher than expected, and they’re losing money every month.
That’s exactly what I see in my coaching practice, and it’s totally preventable.
The truth? Analyzing a rental property doesn’t have to be complicated. You don’t need to be a finance wizard or have a degree in accounting. You just need a simple framework, a calculator, and maybe a spreadsheet.
In this post, I’m walking you through my 5-step process for analyzing rental properties—the same framework I use with my coaching clients. By the end, you’ll know exactly how to evaluate whether a property makes sense for your investment goals.
Step 1: Gather the Property Numbers
Before you can analyze anything, you need accurate data. This might seem obvious, but I’m amazed how often investors work with incomplete or incorrect information.
Purchase Information: Purchase price (or estimated after-repair value if it needs work), inspection costs, appraisal fee, closing costs (title, recording, attorney fees), and total capital required upfront.
Income Information: Market rent (what can you actually charge? Check Zillow, Rent.com, local listings), vacancy rate for the area (industry standard is 5-8%), and other income (parking, pet fees, laundry—though keep it conservative).
Expense Information: Property taxes (from county assessor records), insurance (get a quote from a local agent), HOA fees, maintenance (plan for 1% of property value annually), property management (8-12% of rent), and any utilities you’re paying for.
Financing Information: Loan amount, interest rate, loan term (15, 20, 30 years), and down payment percentage.
Pro tip: Most of this information is available online. Call the county tax assessor for property tax estimates, contact local insurance agents for quotes, and research comparable rentals on Zillow to determine market rent. Don’t guess—verify.
Step 2: Calculate Your Monthly Cash Flow
Cash flow is king in rental real estate. It’s the money left over after all expenses each month—the profit you actually pocket. The basic formula: Gross Rental Income minus Vacancy Loss minus Operating Expenses minus Mortgage Payment equals Net Monthly Cash Flow.
Sample Property: Single-Family Home, Purchase Price $250,000
With market rent of $2,000/month, a 5% vacancy factor (-$100), you get effective rental income of $1,900. Expenses total $758/month (property taxes, insurance, maintenance, and management). On a $200,000 loan at 6% for 30 years, the monthly mortgage payment is $1,199.
Cash flow: $1,900 – $758 – $1,199 = -$57/month (NEGATIVE). This property actually loses money each month.
Now here’s the same property purchased for $200,000 with a $150,000 loan: $1,900 – $758 – $899 = $243/month (POSITIVE). Much better. The purchase price matters a lot. Don’t overpay.
Step 3: Calculate Your Return Metrics (Cap Rate, Cash-on-Cash Return)
Okay, so you have positive cash flow. But is it actually a good return on your money? This is where cap rate and cash-on-cash return come in.
Cap Rate tells you what kind of return you’d get if you paid cash: Net Operating Income / Property Price. Using our example: $13,704 / $200,000 = 6.85%. Generally, below 4% is probably overpriced, 4-6% is moderate, and 6-8%+ offers better returns.
Cash-on-Cash Return shows what percentage return you’re getting on the actual cash you invested: Annual Cash Flow / Cash Invested. Our example: $2,916 / $50,000 = 5.83%. Most investors target 8-12%, so this is okay but not amazing.
Step 4: Stress-Test Your Numbers
Here’s where a lot of new investors fail: they use best-case scenarios. The rent will definitely be $2,000. The vacancy rate will be the city average. Everything will go perfectly. Spoiler: It won’t.
Ask yourself: What if vacancy hits 10% instead of 5%? What if you need to drop rent? What if insurance goes up 15%? What if the property needs a new roof in year 2?
In our stressed scenario (rent down to $1,850, vacancy up to 10%): $1,665 – $758 – $899 = $8/month. Still positive, but barely. One large repair and you’re negative. My rule: If the property doesn’t cash flow in the stressed scenario, don’t buy it.
Step 5: Compare to Your Investment Criteria
Finally, compare this property to your personal investment criteria. Everyone’s criteria are different, but you should have baseline standards: minimum cap rate, minimum cash-on-cash return, maximum purchase price, preferred locations, and minimum cash flow after stress-testing.
Our sample property has a great purchase price and good cap rate, but the cash-on-cash return is below target and stressed cash flow is too thin. I’d pass and keep looking. The whole point is being intentional and data-driven—not emotional.
Make It Easier: Use a Rental Property Calculator
Doing this analysis with a calculator and pen-and-paper is tedious, and one small math error throws off everything. That’s why I created the Rental Property Analyzer template—a spreadsheet that does all of this for you automatically. Just plug in the property numbers, and the template calculates monthly cash flow, cap rate, cash-on-cash return, break-even analysis, and multi-year projections.
No formulas to build, no calculator fumbling. It’s the tool I use with my coaching clients, and it saves hours of analysis time.
The Bottom Line
Analyzing a rental property is a five-step process: gather accurate numbers, calculate monthly cash flow, calculate cap rate and cash-on-cash return, stress-test your numbers, and compare to your investment criteria. Most deals won’t pass this analysis—and that’s actually good news. It means you’re eliminating bad deals before you lose money on them.
Ready to analyze properties like a pro? Try the Rental Property Analyzer template on a few properties you’re considering and see how they compare. The more properties you analyze, the faster you’ll get at spotting good deals.
Ready to Run the Numbers?
The Rental Property Analyzer does all the heavy lifting for you – plug in the numbers, and it calculates cash flow, ROI, cap rate, and cash-on-cash return instantly. Built by a financial strategist with 20+ years of experience.
Have questions about analyzing rental properties? Drop a comment below or reach out to schedule a consultation. Want to learn more? Check out our BRRRR Strategy Guide.
Simply Spreadsheets 
Leave a comment