Property Underwriting Worksheet

Real Estate Investment Calculator

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.

1Acquisition

What it costs to get the keys.

$
$
$

2Financing

Loan terms for the mortgage.

amount
$
percent
%
%
yrs
pts

1 point = 1% of the loan amount, paid upfront at closing.

3Income

What the property brings in.

$
$

4Operating expenses

Recurring costs, excluding the mortgage.

$
$

Percentage assumptions

% rent
% rent
% rent
% rent
Quick preset Sets management 10%, vacancy 8%, maintenance 8%, CapEx 8%
$
$
Split into water, gas, electric…

Results

Cash-on-Cash ROI
0.0%
—
Cash required
Down payment$0
Closing costs$0
Rehab budget$0
Loan points cost$0
Total cash invested$0
Financing
Loan amount$0
Monthly P&I payment$0
Operating performance
Effective gross income (mo.)$0
Operating expenses (mo.)$0
Net operating income (mo.)$0
Net operating income (yr.)$0
Returns
Monthly cash flow$0
Annual cash flow$0
Cap rate0.0%
Cash-on-cash ROI0.0%
DSCR0.00
1% rule: 0.00% of purchase price collected in monthly rent.