Property Underwriting Worksheet
Fill in the acquisition, financing, income and expense figures for a rental property. Every result — including cash-on-cash ROI — updates live as you type.
What it costs to get the keys.
Loan terms for the mortgage.
Paying the full purchase price in cash — the fields below are ignored while this is on.
1 point = 1% of the loan amount, paid upfront at closing.
What the property brings in.
Recurring costs, excluding the mortgage.
Market value at 0 uses the purchase price. 45 mills is only an example; use the non-homestead total from your township or city treasurer. Michigan: assessment ratio 50%, and taxable value resets to that level the year after a sale, so the seller's bill is not your bill. Exempt mills: up to 18 only if you will live there and file the Principal Residence Exemption; 0 for a rental. Other states: use your county's assessment ratio.
Percentage assumptions
One thing goes wrong at a time. A deal that keeps positive cash flow in every row is robust; one that fails several rows only works if everything goes right.
| Scenario | Monthly cash flow | Cash-on-cash | DSCR | Break-even occ. | Result |
|---|
We'll walk through the few fields that matter most for an accurate result. You can leave at any time.