Rental Property Calculator

What this rental property calculator estimates

This calculator combines a standard fixed-rate mortgage model with a simple rental operating statement. It estimates scheduled principal-and-interest payments, effective rental income after vacancy and management fees, recurring operating expenses, net operating income, cash flow, cap rate, cash-on-cash return, and projected equity at sale. The model is intended for preliminary deal screening and scenario comparison, not as personalized investment, tax, legal, or lending advice.

The results update as you type, so the most useful workflow is to begin with a realistic base case and then stress-test rent, vacancy, interest rate, maintenance, and appreciation. The Excel download captures the current assumptions, results, expense breakdown, and full annual projection in a genuine workbook that can be reviewed or extended offline.

How to enter purchase and financing assumptions

Purchase price, down payment, interest rate, and term

Purchase price is the amount paid for the property. Include only amounts that you intentionally want treated as property basis in this screening model. The down payment is cash paid toward the purchase price; the calculator sets loan amount equal to purchase price minus down payment. A down payment above the purchase price is invalid because it would imply a negative mortgage.

Interest rate is the annual nominal rate used for a fully amortizing monthly mortgage. A higher rate raises monthly debt service, reduces cash flow, and slows principal paydown. Loan term is entered in years. A longer term generally lowers the payment but increases total interest paid over the full loan. A zero interest rate is handled as straight-line principal repayment rather than producing a division error.

For consumer guidance on mortgage terms, payment structure, and loan estimates, review the Consumer Financial Protection Bureau’s home-loan resources.

How income and vacancy affect the result

Monthly rent is scheduled gross rent before losses and fees. Vacancy rate reduces scheduled rent to estimate collected rent. This field can also serve as a conservative allowance for credit loss or downtime between tenants. Management fee is applied to rent after vacancy, reflecting a fee charged on collected income rather than on uncollected rent.

Effective income therefore equals rent multiplied by one minus vacancy, then multiplied by one minus the management fee. Higher rent increases NOI and cash flow dollar for dollar after the vacancy and management adjustments. Higher vacancy or management fees reduce both NOI and cash flow. A common mistake is entering a management fee as a monthly dollar amount; this field requires a percentage.

How to enter recurring operating expenses

The property tax, insurance, maintenance, HOA, and other-cost fields each include a monthly or annual selector. Choose the period that matches the quote or budget you are using. The calculator converts every amount to a monthly basis before computing cash flow, and to an annual basis for the expense chart, NOI, cap rate, and workbook.

• Property tax should reflect recurring real-estate tax, not income tax or one-time transfer tax.
• Insurance should represent landlord or property coverage. Mortgage insurance is not modeled separately.
• Maintenance and repairs should include routine upkeep and a practical reserve for turnover work. Large renovations may be better modeled outside this simplified calculator.
• HOA fee is optional; leave it at ze ro when no association dues apply.
• Other costs can include owner-paid utilities, licensing, bookkeeping, pest control, landscaping, or recurring services.

Operating expenses exclude mortgage payments in the NOI calculation. This distinction matters because cap rate measures property operations independent of financing. The IRS explains common rental income and expense categories in Topic No. 414, Rental Income and Expenses; tax treatment can differ from the cash-flow categories used here.

How to read cash flow, NOI, cap rate, and cash-on-cash return

Monthly cash flow is effective rental income minus operating expenses and the mortgage payment. Positive cash flow means the modeled property produces cash before income taxes and irregular capital spending. Negative cash flow means the assumptions require additional owner funding. Annual NOI is effective income minus operating expenses, excluding debt service. NOI can be positive even when cash flow is negative if financing costs are high.

Cap rate helps compare the operating return of properties with different financing structures. A high cap rate can indicate stronger income relative to price, but it may also accompany higher property, tenant, or location risk. Cash-on-cash return focuses on the annual cash flow generated by the cash invested as down payment. A small down payment can magnify this percentage in either direction, so it should be interpreted alongside debt level and cash-flow resilience.

The total loan paid result is the sum of scheduled principal and interest over the complete mortgage term, not only the selected holding period. It does not include taxes, insurance, lender fees, or prepayments.

How the sale and equity projection works

Annual appreciation compounds the purchase price once per projection year. Negative appreciation is allowed for downside analysis. Holding period determines the projected selling price, remaining loan balance, equity, cumulative cash flow, chart horizon, and table length. The projected equity at sale equals projected property value minus remaining mortgage principal.

The line chart compares property value, loan balance, and equity. Equity can grow from both appreciation and principal repayment. The table shows the same data year by year, plus constant annual NOI, debt service, cash flow, and cumulative cash flow. Because the model excludes selling commissions, transfer taxes, capital gains tax, depreciation recapture, and closing adjustments, projected equity is not the same as net cash proceeds from a real sale.

Practical stress tests and common mistakes

Test at least three cases: a base case, a conservative case with lower rent and higher vacancy or maintenance, and a financing stress case with a higher interest rate. Also test zero appreciation so you can see how much equity comes from amortization alone. Avoid relying on a single year of unusually low repairs, and do not treat cap rate or cash-on-cash return as a guarantee.

For broader housing and mortgage market context, Freddie Mac publishes housing and mortgage research, while the U.S. Census Bureau provides rental vacancy and homeownership data. Local taxes, insurance premiums, rent regulations, tenant protections, and transaction costs can materially change a property’s economics, so replace example values with location-specific estimates before making a decision.