RentalCalcs · Original decision worksheet

Rental screening worksheet

Use one annual income basis and record the evidence behind every important input. Fill locally, then print or save as PDF. Nothing is submitted or automatically saved.

Read the complete worked guide

Worked example

The hypothetical $220,000 house at $2,200 monthly rent has $16,162 NOI but only $877 annual cash after principal, interest and a $2,112 replacement contribution. The downside loses $1,431 annually.

1. Establish the evidence

Address, intended use, price and source/dateLease or comparable rent evidence; utilities and concessionsScheduled rent and vacancy/credit-loss assumptionUnknown inputs that could change the decision

2. Separate the annual budget

Taxes, insurance and routine repair allowance; evidence/dateManagement basis, leasing fees and other owner-paid operationsLoan amount, quoted rate, amortization, fees and payment scheduleReplacement contribution below NOI; no duplicate deduction

3. Make the next decision

Total funding including initial work, prepaids and retained reserveBase NOI, cash after debt/reserve, cap rate and cash-on-cash denominatorDownside input changes, resulting cash and available liquidityProceed, investigate or pass; reason, missing evidence, responsible person and next action

Calculation notes

Effective income = scheduled rent minus vacancy and credit loss. NOI = effective income minus operating expenses. Cash after reserve = NOI minus full principal-and-interest payments minus the replacement contribution. Cash-on-cash = annual cash after reserve divided by explicitly defined committed cash. In the downside, 10% vacancy replaces the 5% base assumption.

Reviewed October 14, 2026. Original RentalCalcs educational worksheet. Numbers are hypothetical, not property estimates or a lender commitment. OCC commercial real estate lending handbook; lender definitions may differ.