A rental analysis calculator estimates whether a rental property is likely to be profitable by comparing income, expenses, and financing costs. You enter the purchase price, expected rent, operating costs, and loan details; it returns key metrics like cap rate, cash-on-cash return, and net operating income (NOI).
Formula
The calculator uses three standard formulas that real estate investors rely on:
- Net Operating Income (NOI): NOI = (Monthly Rent − Monthly Operating Expenses) × 12. This is the annual profit before debt service (mortgage payments).
- Cap Rate: Cap Rate = NOI ÷ Purchase Price × 100%. It expresses the return as if you paid all cash, ignoring financing.
- Cash-on-Cash Return: Cash-on-Cash = (NOI − Annual Debt Service) ÷ Down Payment × 100%. This measures the return on the actual cash you invested.
Annual debt service is calculated from the standard amortizing loan payment formula: Payment = P × [i(1+i)^n] / [(1+i)^n − 1], where P is the loan principal (purchase price minus down payment), i is the monthly interest rate (annual rate ÷ 12), and n is the number of monthly payments (loan term × 12).
Worked Example
Using the default values: purchase price $250,000, monthly rent $1,800, monthly expenses $500, down payment $50,000, interest rate 6.5%, and 30-year term.
- Monthly net cash flow before debt: $1,800 − $500 = $1,300.
- Annual NOI: $1,300 × 12 = $15,600.
- Cap rate: $15,600 ÷ $250,000 = 0.0624, or 6.24%.
- Loan principal: $250,000 − $50,000 = $200,000.
- Monthly interest rate: 6.5% ÷ 12 = 0.5416667% (0.005416667).
- Number of payments: 30 × 12 = 360.
- Monthly payment: $200,000 × [0.005416667(1.005416667)^360] / [(1.005416667)^360 − 1] ≈ $1,264.14.
- Annual debt service: $1,264.14 × 12 = $15,169.68.
- Cash-on-cash return: ($15,600 − $15,169.68) ÷ $50,000 = $430.32 ÷ $50,000 = 0.0086064, or 0.86%.
The calculator shows NOI = $15,600, cap rate = 6.24%, and cash-on-cash = 0.86% (rounded).
Assumptions
- Rent and operating expenses are constant each month; no rent growth or inflation is modeled.
- Operating expenses include property taxes, insurance, maintenance, property management fees, and vacancy allowance, but not mortgage payments.
- The mortgage is a fixed-rate, fully amortizing loan with equal monthly payments.
- No vacancy or repair costs beyond the monthly expense estimate.
- The purchase price is the full acquisition cost; closing costs and capital expenditures are not included.
How to Use the Results
Cap rate and cash-on-cash return are benchmarks, not predictions. Cap rate tells you the yield if you paid cash; it is useful for comparing properties in the same market. A higher cap rate often means higher risk (older property, weaker location, higher vacancy). Cash-on-cash return reflects your actual return on the down payment, which is what most investors care about. A positive number means the property generates more income than the mortgage costs; a negative number means you are covering the shortfall out of pocket.
For example, if the cash-on-cash return is 0.86%, you are barely breaking even after financing. Many investors look for at least 8–12% cash-on-cash, but that depends on market and risk tolerance. The cap rate of 6.24% is typical for single-family rentals in many US markets, but it varies widely by city and property type.
Common Mistakes and Misconceptions
- Confusing NOI with cash flow: NOI is before mortgage payments; cash flow is after. The calculator shows both, but beginners often mix them up.
- Forgetting vacancy and maintenance: A common error is setting monthly expenses too low. A rule of thumb is to set aside 5–10% of rent for vacancy and another 5–10% for maintenance, but actual figures depend on the property.
- Using the wrong down payment: If you put down less than 20%, you may need to pay private mortgage insurance (PMI), which is an extra expense not included here.
- Ignoring closing costs: The purchase price is not the total upfront cash. Closing costs (appraisal, title, inspection, loan fees) can add 2–5% of the price.
- Relying on the cap rate alone: Cap rate ignores financing, so it does not tell you if the mortgage is affordable. Always check cash-on-cash.
Limitations of This Calculator
This tool is a starting point, not a full investment analysis. It does not model rent growth, property appreciation, tax benefits (depreciation, mortgage interest deduction), or the cost of capital improvements. It also assumes a fixed-rate mortgage; adjustable-rate loans will change your payments. For a complete picture, you would need a more detailed pro forma that projects income and expenses over several years and calculates internal rate of return (IRR) or net present value (NPV).
Also, the cash-on-cash formula here uses the full annual debt service, which is correct for a standard loan. However, if you make extra principal payments, your cash-on-cash will change over time.
Alternatives and Related Metrics
Besides cap rate and cash-on-cash, investors often calculate:
- Gross Rent Multiplier (GRM): Purchase price ÷ annual gross rent. A quick screen, but ignores expenses.
- Debt Service Coverage Ratio (DSCR): NOI ÷ annual debt service. Lenders want this above 1.2–1.5.
- Cash Flow After Taxes: Includes tax deductions and property appreciation, which this calculator does not.
- 50% Rule: A rough estimate that operating expenses (excluding mortgage) are about 50% of gross rent. You can use that to estimate monthly expenses if you lack detailed data.
For example, with $1,800 rent, the 50% rule would suggest $900/month in expenses, which is higher than the $500 default. That would lower NOI to $10,800 and cap rate to 4.32%, a more conservative estimate.
Frequently Asked Questions
What is a good cap rate for a rental property?
There is no universal number. In expensive coastal cities, cap rates of 3–5% are common; in the Midwest or South, 6–10% is typical. Higher cap rates often come with higher risk (older buildings, weaker tenants, less appreciation). Compare cap rates only among similar properties in the same market.
How do I estimate monthly operating expenses?
Start with actual property taxes, insurance, and HOA fees. Then add property management (usually 8–12% of rent), maintenance (1% of property value per year is a common rule), and vacancy (5–10% of rent). If you do not have actual numbers, the 50% rule is a rough starting point.
Does the calculator include property appreciation?
No. It only looks at income from rent versus costs. Appreciation is a separate potential profit, but it is not guaranteed and depends on the market. To include it, you would need to project future sale price and calculate a total return.
What is the difference between cash-on-cash return and ROI?
Cash-on-cash return is the annual pre-tax cash flow divided by the cash you actually put in (down payment). ROI (return on investment) typically includes total profit (cash flow plus equity paydown plus appreciation) over a holding period, divided by total investment. Cash-on-cash is a simpler, one-year snapshot.
Should I use this calculator before buying a rental property?
Yes, as a first pass. It helps you quickly see if a property might cash flow. But you should also run a more detailed analysis that includes closing costs, capital expenditures, tax effects, and a multi-year projection. This calculator is a screening tool, not a final decision maker.
Related
Formula used
in m | Purchase price | $ | 250000 | 0 in r | Monthly rent | $ | 1800 | 0 in e | Monthly operating expenses (taxes, insurance, maintenance, vacancy) | $ | 500 | 0 in d | Down payment | $ | 50000 | 0 in i | Annual interest rate | % | 6.5 | 0 in n | Loan term | years | 30 | 1 out noi | Net operating income (annual) | $/yr | (r - e) * 12 | 0 out cap | Cap rate | % | ((r - e) * 12) / m * 100 | 2 out cc | Cash-on-cash return | % | ((r - e) * 12 - (m - d) * (i / 100 / 12) * (1 + i / 100 / 12) ^ (n * 12) / ((1 + i / 100 / 12) ^ (n * 12) - 1) * 12) / d * 100 | 2
Each line is one input (in, sel, list) or one result (out: label, unit, formula, decimals). How the calculators work
Method: the standard formula for this calculation with the constants and conversion factors written on the page, rounded as each result states. See method and constants, the disclaimer or report an error.
More in this section
- QPP Calculator Canada: How It Works & How to Use It
- PPP Calculator World Bank: How It Works & How to Use It2,000.00
- PPP Calculator: India vs USA Cost Comparison1,000.00 USD
- PPP Calculator USD to INR: How It Works2,335 INR
- PPP Calculator India vs Dubai: Real Cost Comparison8,954.58 AED
- PPP Calculator India vs UK: Real Cost Comparison103.63 GBP