RentalCalcs worksheet · Reviewed October 17, 2026. General investor research, not an agency form, approval or appraisal. Blank fields are for your records. This page does not save or transmit entries; print it when finished.
Read the complete worked example and limitations · Download example CSV
Keep current documented rent separate from conditional future rent. Every cell is NOI ÷ the assumed rate, before debt, reserves below NOI, selling costs and tax. A current lease does not prove that income continues forever.
| Rent and annual NOI | 6.5% | 7.0% | 7.5% |
|---|---|---|---|
| Current rent: $1,275; NOI $106,466.40 | $1,637,945 | $1,520,949 | $1,419,552 |
| Conditional future rent: $1,100; NOI $84,441.60 | $1,299,102 | $1,206,309 | $1,125,888 |
Scroll within the table or focus it and use arrow keys. Replace each rate with comparable-transaction evidence before using an indication in an offer.
| Item | Value |
|---|---|
| Unit count | 12 |
| Current monthly rent per unit | 1,275 |
| Lower monthly rent per unit | 1,100 |
| Loss percent both cases | 5 |
| Management percent of effective rent | 8 |
| Other operating expenses | 54,000 |
| Current NOI | 106,466.4 |
| Lower NOI | 84,441.6 |
| Current indicated value at 6.5 percent | 1,637,944.62 |
| Current indicated value at 7 percent | 1,520,948.57 |
| Current indicated value at 7.5 percent | 1,419,552 |
| Lower value at 6.5 percent | 1,299,101.54 |
| Lower value at 7 percent | 1,206,308.57 |
| Lower value at 7.5 percent | 1,125,888 |
| Loan principal | 1,000,000 |
| Loan rate percent | 7.25 |
| Loan term years | 30 |
| Annual principal and interest | 81,861.15 |
| Annual replacement reserve | 12,000 |
| Current cash after reserve and debt | 12,605.25 |
| Lower cash after reserve and debt | -9,419.55 |
Amounts are dollars unless the row names a percentage, count or term. The article states the complete method, source scope and rounding convention.