Some links are affiliate links. Rental Owner Studio may earn compensation from a qualifying action, at no additional cost to you. How our links work.
Analyze a rental by estimating its income, subtracting realistic costs, modeling the actual loan and testing a disappointing year. A low price or attractive rent-to-price ratio is only the beginning. The goal is to understand both the return and the cash you could need after closing.
In this guide
Gather the evidence before opening a spreadsheet
- Rent: current leases, payment records and comparable local rentals.
- Condition: inspection findings, immediate repair scope and age of major components.
- Expenses: insurance quote, taxes, HOA charges and owner-paid utilities or services.
- Financing: down payment, fees, rate, amortization, reset dates and any balloon.
- Cash: closing costs, renovation funds and reserves you will retain.
Mark each number as verified, quoted or estimated. A model with a long list of unverified assumptions needs more research before it needs a more precise return percentage.
Step 1: Estimate rent the property can actually collect
Compare similar homes, adjusting for condition, bedrooms, bathrooms, parking and utilities. For an occupied property, start with the existing lease and payment history. A potential future rent increase is a separate scenario, not current income.
Use RentCast to research estimated rent and comparable properties, then verify the result locally. This is an affiliate link; an automated estimate is not a lease commitment.
Step 2: Build operating costs and reserves
Subtract vacancy and collection losses, taxes, insurance, management, maintenance, owner-paid utilities and other recurring costs. Keep a separate allowance for major replacements such as a roof or HVAC. Decide which costs are percentages of rent and which are fixed bills.
If the seller self-manages, their records may show no management expense. Model what happens if you need to hire someone. If taxes or insurance are escrowed in the mortgage payment, avoid counting them twice.
Step 3: Separate property performance from financing
NOI is income after operating costs and before debt service. Cap rate divides annual NOI by the purchase price. Financing changes your cash flow, but it does not change NOI when the operating assumptions are identical.
For your own result, subtract loan payments and the cash you need to reserve. Compare the remainder with your total cash invested. The cap rate versus cash-on-cash guide walks through this distinction with numbers.
Enter the rent, expenses, cash investment and loan terms you have verified.
Open the cash flow calculatorStep 4: Check the total cash needed
A 25% down payment on a $200,000 property is $50,000. If closing costs are $6,000 and immediate work is $5,000, you have already committed $61,000 before adding an emergency reserve. These numbers are illustrative.
Budget for the timing of the money too. Renovation draws may reimburse work after it is completed. A reserve required by the lender is still cash you must have available even if it is not spent at closing.
Step 5: Compare three scenarios
| Scenario | Inputs | Question |
|---|---|---|
| Base | Supported rent, written loan quote, current expense estimates | Does this meet the return you require? |
| Conservative | Lower rent, higher recurring costs, more vacancy | Can the property cover its obligations? |
| Disruption | A major repair, leasing delay or loan reset | Do you have enough accessible cash? |
These are planning scenarios rather than predictions. Use them to identify which assumptions matter most. If small changes erase the result, negotiate a better price or terms, improve the scope, or pass.
Step 6: Decide what would make you walk away
Set your limits before negotiating: maximum cash required, minimum monthly margin, acceptable repair scope and the risks you understand well enough to take. A property that fits someone else's strategy may not fit your time, reserve balance or experience.
Compare deals using the same categories. A spreadsheet that includes management and major repairs for one home but omits them for another creates a false winner.
Which calculator should you use?
- 1% rule calculator: a quick initial screen.
- Cash flow calculator: monthly income after expenses and financing.
- Cash-on-cash calculator: cash return compared with cash invested.
- Cap rate calculator: operating yield before financing.
- BRRRR calculator: refinance proceeds and cash left in a renovation project.
For an example from my own portfolio, read the $73,000 purchase and renovation case study. Use the process to ask better questions about your deal, rather than assuming the same outcome.
Keep the work organized with the Rental Property Deal Analyzer.
Use the Rental Property Deal Analyzer to model cash flow, cap rate, cash-on-cash return, DSCR, a 10-year projection and up to five deals side by side.
View the matching tool on Etsy →Continue with these guides
Educational guide. Examples are illustrative and depend on your inputs. Check property-specific costs and applicable requirements before acting.
Put this guide into practice.
Model a purchase before you commit, compare five opportunities and review financing and a 10-year projection.
Digital spreadsheet · Excel .xlsx · Google Sheets import · Sold through Etsy
Preview the worksheets →