20% OFF CODE: WELCOME2020% off with code WELCOME20Explore All Systems →
Home/Tools/Real Estate Cap Rate Calculator
Free Real Estate Underwriting Tool

Real Estate Cap Rate, NOI & Cash-on-Cash Calculator

Underwrite multifamily, commercial NNN, or residential rental properties in seconds. Compute Net Operating Income (NOI), Cap Rate %, Cash-on-Cash Return, and lender DSCR.

Property Deal Assumptions

Capitalization Rate
7.91%

NOI: $67,260/yr

Cash-on-Cash Return
7.73%

Cash Flow: $18,060/yr

Lender DSCR Ratio
1.37x
Passes 1.25x Bank Min
Total Cash Required
$233,750
Down Payment + 2.5% Close
Excel Formula: = (Effective_Gross_Income - Operating_Expenses) / Purchase_Price
Official Excel System
$7.20$9-20%

Landlord Rent Roll & Schedule E Workbook

Rent roll with late fees and deposits, a repair and expense log, and IRS Schedule E categories per property.

100% Macro-Free (.xlsx) • Native dynamic formulas
Single-user perpetual license • Zero monthly SaaS
Pre-filled demo workbook + Clean blank sheet
Instant .xlsx Download • Verified IT Safe • Polar Secured