SRL / KEYRING
ACQUISITION ANALYSIS
← OVERVIEW
NON-PERSISTENT WORKSHEET
ANALYSIS
A private underwriting worksheet. It never writes to the property ledger.
Purchase price
Down payment %
Closing costs
(optional)
Interest rate %
Loan term (years)
Potential monthly rent
Vacancy %
(of rent)
Other monthly income
Monthly operating expenses
(excludes debt)
Maintenance %
(of rent)
Annual capital reserve
(optional)
CALCULATE
MONTHLY DEBT SERVICE
—
Principal and interest only
MONTHLY CASH FLOW
—
After opex, reserve, debt
DEBT-SERVICE COVERAGE
—
Annual NOI ÷ annual debt
CAP RATE
—
Annual NOI ÷ price
CASH-ON-CASH
—
Annual cash flow ÷ invested