Rental Portfolio Leverage and Cash Flow Stress Test

Look at the whole portfolio and each property inside it. This calculator adds entered property values, debt and cash flow, then tests the rent and payment changes you choose. It shows where a portfolio total may be hiding a property that needs cash support.

What you enter

Create a row for each property with its estimated value, loan balance, expected collected revenue, operating costs, replacement savings and full mortgage cash payments. Enter either monthly figures for every property or annual figures for every property. Keep the measurement period consistent.

If a loan covers several properties, enter the debt once in a separate loan record and link the collateral properties to it. Do not copy the whole balance onto every property. Any allocation of that loan's payment among properties should be labeled as your management allocation, not a release price or a lender valuation.

Choose a rent stress and any expected payment changes. A future rate change needs the actual loan terms or a separately modeled payment. This tool can accept that payment, but it does not infer an adjustable rate reset from a current balance alone.

Example

Assume two rentals worth $400,000 and $300,000, with debt of $240,000 and $210,000. Total estimated value is $700,000 and debt is $450,000. The modeled portfolio loan to value ratio is about 64.29%.

Assume monthly revenue totals $6,000, operating costs and replacement savings total $1,800, and mortgage payments total $3,000. Monthly cash flow is $1,200 under these made up assumptions.

Reduce revenue by an assumed 10% while holding costs and payments fixed. Revenue falls to $5,400 and cash flow becomes $600. If a payment also rises by $400, stressed cash flow falls to $200. A positive total still needs a property by property check.

How much debt do I carry across the portfolio?

The calculator reports total debt and total debt divided by total entered value. It also shows each property's ratio where a separate debt balance can be assigned reliably.

This is a value weighted calculation. Averaging individual LTV percentages can give a different and misleading answer.

What happens to cash flow if rents drop?

The tool reduces the selected revenue rows and applies the expense response you specify. Its default stress should hold entered costs fixed rather than inventing automatic savings.

For an Airbnb, changing bookings can also change variable costs. Enter that response explicitly if you want it included.

What happens if rates reset?

Enter the new modeled loan payment and the date it would begin. The calculator shows the monthly cash flow effect, including which period bears the increase.

If the loan has a balloon payoff, record that separately. A large balance due is different from a higher monthly installment.

Which property is the weakest link?

Sort by stressed dollar cash flow and funding shortfall. A property can need cash even when the rest of the portfolio offsets it.

See Rental Portfolio Capital Allocation: Pay Down, Refinance or Buy Another for the decision after the numbers are clear. This tool does not prescribe how much leverage is safe for every investor.

This calculator gives an estimate only. It is not a loan offer or approval.