Rental Property Analyzer
Institutional-style underwriting for a rental property. Cap rate, cash-on-cash, DSCR and IRR, plus a full value-add story. Year-by-year cash flows included.
| Year | Rent | Op. exp. | NOI | Debt svc | Cash flow | Property value | Loan balance | Equity |
|---|
About this tool
Underwrite an investment property like a professional: cap rate, cash-on-cash return, monthly cash flow, debt service coverage and a full IRR over your holding period, modeling the financing, operating costs, vacancy, rent growth, appreciation and the eventual sale.
The discipline this tool enforces is counting every cost. Vacancy, maintenance, management, insurance and taxes routinely consume 35-50% of gross rent, which is why properties that look profitable on rent-minus-mortgage math so often bleed cash in real life.
What is a good cap rate?
It depends on the market and the risk. The more useful question is the spread over the 10-year Treasury: a cap rate barely above the risk-free rate means you are being paid almost nothing for illiquidity, leverage and 2 am phone calls.
What is cash-on-cash return?
Annual pre-tax cash flow divided by the actual cash you put in. It measures what the deal pays you today, while IRR captures the whole arc including appreciation and the sale.
What is DSCR?
Debt service coverage ratio: net operating income divided by the annual mortgage payment. Lenders typically want 1.2 or better, meaning the property earns at least 20% more than the debt costs.