How this calculator works
The tool follows the standard institutional underwriting waterfall. Each step feeds the next, and every input is editable so you can stress-test a deal in seconds.
Step 1: Gross Scheduled Income (GSI)
GSI is total annual rent if every unit were occupied 100% of the time, plus other income like laundry, parking, or storage. Enter each unit’s rent separately; sellers’ pro formas often blend rents to hide a below-market lease.
Step 2: Effective Gross Income (EGI)
EGI = GSI − vacancy and credit loss. Small residential properties typically run 5-10% vacancy. Using 6% is a realistic default; using 0% is how beginners fool themselves.
Step 3: Operating expenses
- Fixed costs: property taxes (verify with the county; many jurisdictions reassess after a sale) and landlord insurance.
- Utilities: water, sewer, trash, and common-area electric. If tenants pay their own utilities, this line shrinks dramatically.
- Maintenance reserve: modeled as a percentage of GSI (8% is a common default for older buildings).
- CapEx reserve: the roof-and-boiler fund. This is the line sellers omit and buyers regret. Pre-1980 buildings often need 8-12% of GSI.
- Property management: computed on EGI (8-10% is market rate) even if you self-manage.
Step 4: Net Operating Income (NOI)
NOI = EGI − Total Operating Expenses
NOI deliberately excludes the mortgage. It measures the property’s income-producing ability independent of financing, which is why it drives both valuation and DSCR lending.
Step 5: Returns
- Cap rate= NOI ÷ purchase price. The property’s unlevered yield; use it to compare deals and estimate value (Value = NOI ÷ market cap rate).
- Cash-on-cash return = (NOI − annual debt service) ÷ total cash invested. What your actual dollars earn after financing.
- Monthly free cash flow = (NOI − debt service) ÷ 12. The number that hits your bank account.
Worked example
A $450,000 duplex with rents of $1,600 and $1,500 plus $100 a month of laundry income produces $38,400 of GSI. At 6% vacancy, EGI is $36,096. Expenses of $5,200 taxes, $2,400 insurance, $3,000 utilities, 8% maintenance ($3,072), 8% CapEx ($3,072), and 8% management ($2,888) total $19,632. NOI is $16,464, a 3.7% cap rate at the asking price. With $2,150 a month of debt service, annual cash flow is −$9,336: this deal fails at list price and needs either a price cut or a rent story. That is exactly the kind of verdict this calculator delivers in ten seconds.
Assumptions and limitations
- Reserves are percentage-based. For an older building, a component-level reserve study is more accurate; see how to budget CapEx for pre-1980 duplexes.
- Debt service is entered as a single monthly figure so you can model any loan. Build it with the mortgage calculator first if you do not have a quote.
- Results are pre-tax. Depreciation and Schedule E deductions can turn positive cash flow into a paper loss; the Schedule E guide covers that math.