Cash Flow Forecast Template for Rental Properties

A rental property looks predictable: the same rent, the same mortgage payment, every month. In practice a landlord’s cash flow is shaped by the months that aren’t normal: a unit sitting empty between tenants, a boiler replacement, a property tax bill that arrives twice a year, or a tenant who pays late. A cash flow forecast turns those surprises into planned events.

Why landlord cash flow is different

• Vacancy is the biggest risk. One empty month on a single-unit rental wipes out most of a year’s profit. Across a portfolio, a realistic vacancy allowance is essential.
• Big bills are annual or twice a year. Property taxes, insurance renewals and licensing fees arrive in lumps.
• Repairs are uneven. Most months cost little; then a roof or heating system costs thousands.
• Deposits aren’t income. Security deposits are held for tenants and must be returned, often with deductions disputed.
• Management fees follow rent. Agents usually charge a percentage of rent collected, so fees fall when units are empty.

A worked example

A landlord owns eight units at an average of $1,450 a month. With full occupancy and 98 percent collection, rent collected is about $11,370 a month. The mortgage is $5,250, management 8 percent of rent, and maintenance and utilities about $1,500.

That looks comfortable until the $7,800 property tax installment lands in the same month as a vacancy. Without a forecast, the landlord finds out when the bank account goes negative. With one, they know to set aside about $1,300 a month for the two tax payments.

How to build a rental cash forecast

1. List every unit with its rent and lease end date.
2. Apply an occupancy rate by month, with lower occupancy around lease ends.
3. Apply a collection rate for late or missed payments.
4. Add mortgage payments, management fees, utilities you pay, and a monthly repair allowance.
5. Schedule property taxes, insurance and licences in the months they’re due.
6. Plan capital improvements separately from routine repairs.

Common mistakes

Budgeting as if every unit is always let. Treating deposits as spendable cash. Forgetting that a rate rise on a variable mortgage changes every future month. And using one bank account for the rental and personal spending, which hides the true position.

What the template gives you

The Rental Property template includes a Rent Roll tab where you enter units, average rent, occupancy by month and your collection rate; it calculates rent collected and the management fee automatically. An Annual Bills tab schedules property taxes and insurance renewals, so they appear in the right months of the forecast.

Key assumptions built into the Real Estate & Rental Property template

• The Rent Roll tab calculates “Rent collected” as 8 rental units × average rent per unit per month ($1,450) × occupancy, after a 98% collection rate, plus management fee at 8% of that revenue. The example occupancy runs from 88% in the quietest month to 100% at peak.
• The Annual Bills tab lists large, irregular payments with the month each starts, how many payments there are and how often they repeat. The example includes property tax, 1st half, property tax, 2nd half and landlord insurance renewal. Each one is routed to the right line of the forecast, and there are spare rows for your own.
• 5 cash in lines and 8 cash out lines are already named for real estate & rental property businesses, and every one can be renamed or extended.
• The example figures follow a fairly even year, which suits most real estate & rental property businesses; add your own seasonal pattern if you have one.

Every assumption sits in a yellow input cell, so you replace the example with your own numbers in minutes. The same figures flow through a 13-week weekly view, a 12-month monthly view and a 3-year outlook, and a dashboard shows your lowest balance, the weeks that fall below your minimum buffer and your cash runway.

Free or premium?

If you only need the basics, the free 12-month template or the free 13-week template will get you started today. The premium Real Estate & Rental Property template saves the setup time and adds the tabs above, best and worst case scenarios, and an actual vs forecast tracker that shows where your forecast was wrong, so next month’s is better.

Real Estate & Rental Property cash flow forecasting: questions

What vacancy rate should I use in a rental cash flow forecast?

Use your own history if you have it. Otherwise many landlords assume 5 to 8 percent, or about one month empty per unit every one to two years.

Should security deposits be included in rental cash flow?

Include them as cash in and deposit refunds as cash out, but don’t treat them as income you can spend.

How do I plan for property tax in a rental forecast?

Enter each installment in the month it’s due, and set aside a monthly amount so the lump doesn’t coincide with a vacancy and leave you short.