Excel Model: Rental Property ROI & Cap Rate Calculator
Title: Rental Property ROI & Cap Rate Calculator
Description:
This spreadsheet is designed to help users evaluate the return on investment (ROI) and capitalization rate (Cap Rate) for rental properties. It includes sections for investment details, monthly expenses, monthly cash flow, loan details, and key financial metrics.
- Investment Details: Enter details about the purchase property price, taxes and fees, closing costs, realtor fees, and rehabilitation costs.
- Monthly Expenses: Includes maintenance and repairs, property management fees, real estate taxes, insurance, and other expenses.
- Monthly Cash Flow: Calculates monthly debt service, monthly revenue, and net cash flow.
- Loan Details: Provides information on the annual interest rate, term of the loan, and resulting monthly loan payment.
- Key Financial Metrics: Calculates the cap rate, cash on cash return, and overall ROI.
Source: Custom Calculator
Click the following icon to open the full workbook viewer in a new tab, allowing you to easily edit and save.
Click the following icon to download the spreadsheet, allowing you to save the file on your computer along with edits.
EN 
PT 
SW 
ML 
AR 
ZH 
ES 
EL 
ES_ES 
FR 
HI 
IT 
JA 
KO 
PT_PT 
PL 
DE 
LT 
UK 
KA 
DE_AT 
NB 
NN