Real Estate
Rental Property Return Calculator
Calculate effective rental income, NOI, mortgage payment, annual cash flow, cap rate, initial cash, cash-on-cash return, projected sale value, remaining loan balance, net sale proceeds, total profit, and return on initial cash. A dedicated property cash-flow bridge distinguishes operations from financing and exit.
Initial mortgage principal-
Monthly principal and interest-
Annual effective rental income-
Annual net operating income-
Annual cash flow after debt service-
Going-in capitalization rate-
Initial cash invested-
First-year cash-on-cash return-
Projected property value at sale-
Mortgage balance at planned sale-
Net sale proceeds after costs and debt-
Modeled profit through sale-
Total return on initial cash-
Decision view
Rental operations, financing, and exit
Rental operations, financing, and exitProperty operations reconcile to NOI and cash flow while remaining debt and selling costs reconcile the future sale.
Exact scenario comparisonScheduled monthly rent changes while all other entered assumptions remain constant.
| Scheduled monthly rent | Initial mortgage principal | Monthly principal and interest | Annual effective rental income | Annual net operating income | Annual cash flow after debt service | Going-in capitalization rate | Initial cash invested | First-year cash-on-cash return | Projected property value at sale | Mortgage balance at planned sale | Net sale proceeds after costs and debt | Modeled profit through sale | Total return on initial cash |
|---|
Investment detail
Annual holding projection and return reconciliation
How to use Rental Property Return Calculator
- Enter acquisition cash separately from recurring operating assumptions.
- Confirm vacancy and expenses are annualized on a consistent basis.
- Stress rent, vacancy, expenses, appreciation, selling cost, and hold period before relying on the return.
Calculator guide
Understanding Rental Property Return Calculator
Rental return combines an operating business, a mortgage, and a future sale. This calculator keeps those layers separate so cap rate, first-year cash flow, equity at sale, and total holding-period return can be audited instead of blended.
Calculation method
How the calculation works
Combine operating income, vacancy, expenses, mortgage amortization, projected sale value, selling costs, and remaining debt to estimate cash flow and a holding-period return on initial cash. Reduce scheduled rent by vacancy, subtract operating expenses for NOI, subtract mortgage debt service for cash flow, amortize the loan to sale, deduct selling costs and debt from sale value, then reconcile all cash flows with initial cash invested.
Underwriting layers
Review the property in four passes
A headline return can hide which assumption is doing the work.
Worked situations
Practical examples
- NOI excludes principal and interest because it describes property operations before financing.
- Cash-on-cash return uses first-year cash flow divided by down payment, closing costs, and rehab.
- Net sale proceeds subtract both selling costs and the remaining mortgage.
Better inputs
Useful tips
- Include management, maintenance, insurance, tax, utilities, and reserves consistently in annual expenses.
- Model capital expenditures and income tax in a fuller underwriting workbook.
- Compare return with liquidity, concentration, operational workload, and downside risk.
Before relying on the result
Limitations and common mistakes
- Rent growth, operating-expense growth, capital expenditures, taxes, depreciation, refinancing, and irregular cash flows are excluded.
- Appreciation and a sale at the exact horizon are assumptions, not forecasts.
- This is not an appraisal, lending decision, securities analysis, or investment recommendation.
Reference
Key terms
- NOI
- Effective rental income less operating expenses before financing.
- Cash-on-cash return
- First-year after-debt cash flow divided by initial cash.
- Loan balance at sale
- Principal remaining after modeled amortization.
- Net sale proceeds
- Sale value less selling costs and remaining debt.
Important note
Calculated from the entered property and financing assumptions. It does not replace lender, appraisal, legal, tax, or investment review.
Frequently asked questions
Why is mortgage payment excluded from NOI?
NOI measures property operations before financing so properties can be compared independently of capital structure.
Does total profit include appreciation?
Yes, through modeled sale value and net sale proceeds.
Are taxes included?
Property tax can be included in entered operating expenses; income and capital-gains taxes are not modeled separately.
Is cash-on-cash the same as total return?
No. Cash-on-cash is a first-year income measure; total return also includes modeled sale proceeds over the holding period.