Scheduled rent, NOI, cash flow, and taxable income are different numbers. Keep a separate line for each.
A property advertised at $2,400 monthly rent does not produce $2,400 of spendable income. Occupancy gaps, operating bills, loan payments, and future replacements all need funding. A useful cash-flow worksheet follows the same rent dollar through those layers before calling anything a surplus.
Begin with supportable scheduled rent
Scheduled rent is the amount expected at full occupancy and collection. Compare similar properties, lease terms, condition, and included services. An optimistic asking rent is not the same as signed income, and a one-time concession changes the effective amount collected.
Keep other income, such as a contracted parking payment, separate. Identify whether it is dependable and whether it disappears when the unit is vacant. RentWise’s simple tool applies vacancy to base rent only, so reduce other-income inputs yourself when collection is uncertain.
Allow for income loss before subtracting bills
At $2,400 scheduled monthly rent and a 5% vacancy-and-collection allowance, modeled effective rent is $2,280 monthly. The $120 allowance is a planning average. It does not mean a property loses precisely $120 each month.
A full vacant month removes $2,400 of rent at once while many bills continue. This timing difference explains why a positive annual average is not a substitute for accessible operating cash. Test a longer vacancy period separately when assessing liquidity.
Calculate NOI before financing
Subtract recurring operating expenses from effective income. Include property taxes, insurance, routine repairs, management, owner-paid utilities, and association charges where applicable. Keep loan payments and the separate capital reserve out of this NOI definition.
In the example, $650 operating costs leave $1,630 monthly NOI, or $19,560 annually. NOI helps describe the property before its financing. It is not automatically the taxable result, and it is not what the owner can withdraw.
Subtract debt and capital planning
If monthly principal-and-interest debt service is $1,400 and the capital reserve is $150, the example leaves $80 monthly cash flow. That is only $960 over a year under the selected steady assumptions. A single unplanned expense can materially change the outcome.
Routine repair costs and capital reserves should have different purposes. A reserve for a future roof is not a claim that the roof costs exactly that much this month. Avoid entering the same replacement allowance in both operating costs and the reserve field.
Stress-test the narrowest margin
Increase vacancy to 8% while keeping everything else the same. Effective rent falls to $2,208, leaving only $8 monthly cash flow. Increase operating costs by another $100 and the property requires $92 monthly support. Small shifts matter when the original margin is thin.
Run those alternatives in the rental cash flow calculator and compare them with a saved baseline. Investigate assumptions that have the largest effect instead of treating a positive first result as a purchase recommendation.
Common questions
Is cash flow the same as taxable rental income?
No. Tax treatment can involve depreciation, capitalization, deductions, and limits that a cash worksheet does not model. The IRS rental income and expenses overview is a starting reference; obtain transaction-specific tax advice when needed.
Does principal repayment create a return?
It reduces debt and can build equity, but it is included in debt-service cash outflow. Track equity changes separately from cash available to spend.
Can good cash flow remove investment risk?
No. Condition, market rent, concentration, financing, tenant turnover, and liquidity still matter. A worksheet organizes assumptions; due diligence tests them.
Make the numbers yours.
Use your own inputs, review the assumptions, and compare a second scenario.
Try the rental cash flow toolPrepared with AI assistance and numerical examples. No professional financial review is claimed. Read our editorial approach or suggest a correction.
