Decision instrument

Rental Analyzer

Model one rental from entered income, expense, and financing assumptions.

Your inputs

Adjust the fields and review the result in this workbench.

Rental underwriting worksheet

Use your own listing, rent, expense, and lender assumptions. Operating expenses are separate from debt service so NOI, cap rate, cash flow, cash-on-cash, and DSCR stay conceptually distinct.

Acquisition and income

Purchase price ($)

Initial cash invested ($)

Down payment, closing, and setup cash you choose to include; enter 0 to omit cash-on-cash.

Monthly rent ($)

Other monthly income ($)

Only recurring property income you support with evidence.

Vacancy and credit loss (%)

Monthly operating expenses

Property tax ($)

Insurance ($)

Repairs and maintenance ($)

Property management ($)

Owner-paid utilities ($)

HOA / condo fees ($)

Other operating expenses ($)

Financing

Monthly debt service ($)

Enter the payment you want to model. This tool does not quote a loan or determine eligibility.

Interpretation

How Rental Underwriting works

The worksheet turns entered monthly income, vacancy, operating expenses, debt service, purchase price, and initial cash into a single-year underwriting view. It does not assume a down payment, predict rent, estimate an appraisal, include selling costs, or approve financing.

Example

Key features

A realistic example to show how this tool can support an actual decision.

Formula

Monthly NOI = scheduled income − vacancy loss − operating expenses. Monthly cash flow = NOI − debt service.

Separate NOI from debt service
Cap rate, cash flow, cash-on-cash, and DSCR from entered assumptions
No hidden fixed down-payment assumption
Copyable worksheet for a lender, agent, accountant, or adviser discussion

Avoid mistakes

Common mistakes

A few things that can lead to misleading results or poor decisions.

Stress-test assumptions with figures you can document. Confirm tax, insurance, rent rules, repairs, lease-up, reserves, local regulation, and financing with the responsible parties before deciding to buy.

Related tools

Keep exploring

Continue with closely related tools in the same decision path.

Mortgage Calculator

Calculate monthly mortgage payments

Closing Cost Calculator

Plan cash to close from entered estimates

Rental Income Projector

Project rental income

Property Calculator

Calculate property metrics