NOI, rental cash flow and debt coverage

Operating income, cash after loan payments and return on invested cash describe different parts of a rental property. Use explicit definitions before comparing assets.

Begin with property operations

The forecast’s NOI is effective gross income less the displayed operating costs. It excludes loan principal, loan interest, capex and reserve allocation. This keeps the property’s modelled operating performance visible before the chosen financing structure.

A positive NOI does not ensure positive cash after debt. In the example, property A has $17,419.80 NOI but needs $15,967.20 of first-year debt payments. Capex of $600 and reserve allocations of $1,200 then leave a negative $347.40 available. Omitting those uses would overstate the amount available under the entered plan.

Separate a reserve from spending

Actual capex records money spent on capital items. A reserve allocation earmarks money for future uses. These are different concepts. If a reserve funds an actual expenditure, reconcile the transfers in the relevant accounts rather than automatically treating both as two operating expenses.

The forecast shows capex and reserve allocation separately below NOI. Its available-cash result is after both entered uses. That disclosed convention may differ from a lender’s normalized cash-flow measure or a tax calculation. The cash-record workbook likewise labels reserve allocation separately.

Use matching numerators and denominators

Cap rate uses NOI and the acquisition price. Cash-on-cash uses available cash after allocations and initial cash invested. Debt coverage can use a lender-specific net cash flow rather than this model’s NOI. The workbook therefore displays the stated numerator for each coverage ratio and does not apply an approval threshold.

With no debt service, coverage is unavailable. With zero initial cash invested, cash-on-cash is unavailable. Reporting infinity or a convenient zero would suggest a meaningful comparison where the denominator does not support one. Negative available cash and negative returns remain visible.

Inspect the year-end debt

Principal paid reduces the loan balance; interest does not. The first-year worksheet shows both each month. Annual principal and interest are flows and can be summed, while the year-end debt is the final closing balance. Summing all monthly balances would not describe debt owed at year-end.

The examples include no appreciation, future sale, taxes or refinancing. Use the disclosed scope and source records when deciding whether this simple first-year model answers your actual question.

Inspect the two-property analysis

Sources and definition boundaries

Fannie Mae Form 4254.DEF distinguishes rental operating income, operating costs and reserve-related measures. Its underwriting and reporting conventions are more detailed than this original model. The IRS rental-income overview explains the distinction between rent and refundable deposits, among other tax topics. These files do not determine tax treatment, prepare a tax return or certify lender coverage. Layouts and all numerical examples are original AllMarkets material.