Income Property Calculator

Rohan Realty Rental Income Property Calculator

Enter the information below in the white boxes to see how your project does. DO NOT HIT the ENTER key. Use the TAB key or click another field with the mouse. If you make changes in the upper levels of the calculator, you will need to click on each level below to update the results. Just one box - not all of them. Also, there is no need to use currency signs, commas, or % signs. There is no need to put zero values, any blank cell is ignored. Just enter the numbers and the calculator takes care of the rest.

Category Inputs Year 1 Year 2 Year 3 Year 4 Year 5
Acquisition Costs
Property price:
(%) Closing costs
Total acquisition
Finance/Mortgage
(%) LTV
Loan amount
(%) Interest rate
Loan term (yrs)
Revenue
Monthly Rent Rates
(%) Rental growth/yr
Unit A rent (monthly)
# Unit A
Unit B rent (monthly)
# Unit B
Unit C rent (monthly)
# Unit C
SUBTOTAL
(%) Vacancy
Vacancy Cost
(%) Credit loss
Other Revenue
TOTAL REVENUE
Expenses (yearly)
Renovation / repairs
(%) Expense growth
Mortgage
Maintenance
Utilites
Insurance
Micellaneous
Property Management
Taxes
TOTAL EXPENSES
Cashflow
NOI
DSCR
Estimated Sales
Terminal CAP (%)
Sale Amt. @ Year
(%) Sales costs
SALES REVENUE
Returns
Total Cost
(%) OCC
Total Revenues
NPV
Equity Returns
Total Equity
(%) Required return
Mortgage Repay
Cash to Equity
Equity NPV

Notes: