RPCF

Real Estate

Rental Property Cash Flow Calculator

Calculate scheduled and effective rent, gross income, NOI, capital reserve, debt service, monthly and annual cash flow, cap rate, DSCR, and an appreciation scenario.

Monthly scheduled rent-
Monthly rent after occupancy-
Effective rent plus other income-
Monthly capital reserve-
Monthly NOI before capital reserve and debt-
Monthly cash flow after reserve and debt-
Annual cash flow-
Annual NOI-
NOI divided by purchase price-
Annual debt service-
Entered appreciation scenario value-

Decision view

Monthly rental cash-flow waterfall

Monthly rental cash-flow waterfallScheduled rent, occupancy loss, other income, operating costs, reserve, and debt reconcile exactly to signed monthly cash flow.
Exact scenario comparisonExpected occupancy (%) changes while all other entered assumptions remain constant.
Expected occupancy (%)Monthly scheduled rentMonthly rent after occupancyEffective rent plus other incomeMonthly capital reserveMonthly NOI before capital reserve and debtMonthly cash flow after reserve and debtAnnual cash flowAnnual NOINOI divided by purchase priceAnnual debt serviceEntered appreciation scenario value

How to use Rental Property Cash Flow Calculator

  1. Enter rent per unit, units, occupancy, and other income.
  2. Enter operating expenses, annual capital reserve, and debt service.
  3. Enter purchase price and appreciation scenario assumptions.
  4. Use the live waterfall to trace every monthly cash-flow layer.

Calculator guide

Understanding Rental Property Cash Flow Calculator

Rental cash flow requires a strict order: scheduled rent is reduced for occupancy, other income is added, operating expenses create NOI, and capital reserve plus debt service are then deducted. Keeping those layers distinct prevents NOI from being confused with cash available to the owner.

Occupancy applies once Only scheduled rent is reduced.
NOI is not cash flow Reserve and debt remain.
Ratios use exact layers Cap rate and DSCR have different denominators.
Deficit stays signed Negative cash flow is not hidden.

Calculation method

How the calculation works

Apply occupancy only to scheduled rent, add other income, and keep operating expenses, capital reserve, debt service, NOI, cash flow, cap rate, and DSCR distinct. Annual debt service is reported directly so a debt-free property remains a finite unlevered case. Apply occupancy only to scheduled rent, add other income, subtract operating expenses for NOI, then subtract reserve and debt service for cash flow.

Detailed calculation process

Bridge scheduled rent to monthly cash flow

The default property has two units at $1,850 each, 94% occupancy, $120 other income, $1,450 operating expenses, $500 monthly capital reserve, and $2,300 debt service.

General formula: R_s = ruR_e = R_s oG = R_e+I_oNOI_m = G-E_oC_m = C_a/12CF_m = NOI_m-C_m-D_mcap = 12NOI_m/PDSCR = 12NOI_m/(12D_m) Occupancy affects rental revenue but not entered other income. NOI stops after operating expenses, while cash flow continues through capital reserve and debt service. Cap rate excludes financing, whereas DSCR compares NOI with debt service.

What each symbol means

r, u, o Rent per unit, unit count, and occupancy share.
R_s, R_e Scheduled and effective monthly rent.
I_o, G Other monthly income and monthly gross income.
E_o, NOI_m Operating expenses and monthly NOI.
C_a, C_m Annual and monthly capital reserve.
D_m, CF_m Monthly debt service and cash flow.
P, cap, DSCR Purchase price, cap rate, and debt-service coverage ratio.

Worked substitution with the default inputs

1. Calculate scheduled and effective rent R_s = 1,850(2) = $3,700R_e = 3,700(0.94) = $3,478 Only the scheduled rent is reduced by occupancy.
2. Build monthly gross income G = 3,478+120 = $3,598 Other income is added after the occupancy adjustment.
3. Calculate NOI and reserve NOI_m = 3,598-1,450 = $2,148C_m = 6,000/12 = $500 Capital reserve stays outside NOI in this page's definition.
4. Calculate cash flow CF_m = 2,148-500-2,300 = -$652CF_a = 12(-652) = -$7,824 The signed result shows a monthly and annual cash deficit under the entered assumptions.
5. Reconcile investment ratios NOI_a = 12(2,148) = $25,776cap = 25,776/525,000 = 4.910%DSCR = 25,776/27,600 = 0.934 Cap rate excludes financing, while DSCR below one means NOI is below entered debt service.

The defaults produce $2,148 monthly NOI but -$652 monthly cash flow, a 4.910% cap rate, and 0.934 DSCR.

Monthly reconciliation

Follow rent through the complete cash-flow waterfall

A true waterfall starts at scheduled rent, removes vacancy, adds other income, and then deducts operating cost, reserve, and debt to reach signed cash flow.

Revenue bridge Scheduled rent to gross income.
NOI checkpoint Before reserve and financing.
Owner obligations Capital reserve and debt.
Final cash flow Positive or negative monthly result.

Worked situations

Practical examples

  • Six percent vacancy reduces scheduled rent by $222.
  • NOI is $2,148 before reserve and debt.
  • After reserve and debt, monthly cash flow is -$652.

Better inputs

Useful tips

  • Keep operating expenses, capital items, and financing in their intended layers.
  • Stress-test occupancy and debt service.
  • Use property-specific expense and reserve histories where available.

Before relying on the result

Limitations and common mistakes

  • Concessions, bad debt, taxes, insurance, repairs, regulation, and resale costs require property-specific underwriting.
  • Appreciation is an entered scenario rather than a forecast guarantee.
  • Cap rate and DSCR definitions can vary by lender or analyst.

Reference

Key terms

Scheduled rent
Full monthly rent if all units are occupied.
Effective rent
Scheduled rent after entered occupancy.
NOI
Gross income minus entered operating expenses.
Cash flow
NOI minus capital reserve and debt service.

Important note

Calculated from the entered property and financing assumptions. It does not replace lender, appraisal, legal, tax, or investment review.

Frequently asked questions

Why is occupancy not applied to other income?

The page treats other income as a separately entered monthly amount.

Is capital reserve part of NOI?

Not in this calculator; it is deducted after NOI.

Why is DSCR below one?

Annual NOI of $25,776 is lower than $27,600 debt service.

Does appreciation improve current cash flow?

No. It affects only the separate horizon value scenario.