Rental Property Calculator

cap rate · cash flow · IRR · MIRR · MOIC · DSCR · depreciation · tax

Purchase

Purchase Price ($)

Use Financing / Loan

Down Payment (%)

Down Amount ($)

Interest Rate (%)

Loan Term (years)

Closing Costs ($)

Repair / Rehab ($)

After Repair Value ($) if different from purchase

Income

Monthly Rent ($)

Annual Rent Growth (%)

Other Monthly Income ($)

Other Income Growth (%)

Vacancy Rate (%)

Management Fee (%)

Recurring Operating Expenses

Expense

Annual ($)

Growth %

Hold Period & Exit

Hold Period (years)

Cost to Sell (%)

I know the sell price

Value Appreciation (% / yr)

MIRR Reinvest Rate (%)

Land Value (%)

Marginal Tax Rate (%)

Modified AGI ($)

Cap Rate

—

NOI / purchase price

Cash-on-Cash

—

yr 1 cash flow / equity in

Gross Rent Mult

—

price / gross annual rent

NOI (Year 1)

—

net operating income

IRR

—

levered, over hold period

MIRR

—

modified IRR

MOIC

—

multiple on invested capital

Total Return

—

cumulative cash + equity

Deal Indicators

Year 1 Income & Expense Summary

Annual Cash Flow Over Hold Period

Cumulative Equity Growth

          Total Equity
          Loan Paydown
          Appreciation
        

NOI vs Debt Service Over Hold Period

Tax Analysis

Year-by-Year Schedule

Year	Gross Rent	EGI	Expenses	NOI	Debt Svc	Cash Flow	Property Val	Loan Bal	Equity	CoC %

IRR Sensitivity — Appreciation vs Cap Rate

Rows = value appreciation rate · Columns = exit cap rate · Highlighted = current inputs