How do I forecast cash flow across a real estate portfolio?
Cash flow forecasting for a real estate portfolio means building projections at the property level and rolling them up through entities to get a complete liquidity picture. The goal is to see where cash will be tight and where it will be available, weeks or months before you get there.
Start with each property’s expected operating cash flow. Take projected rental income, subtract operating expenses, and you have net operating income. But NOI alone doesn’t tell you what you can spend. Debt service comes next. For most portfolios, mortgage payments are the largest fixed outflow each month. Your forecast needs to account for every loan payment across every property, including any balloon payments or rate resets coming up.
Capital expenditures are harder to predict but matter just as much. Some capex is planned: the roof replacement you know is coming, the parking lot reseal on the schedule. Some is reactive: the HVAC failure in July. Your forecast should include known capex commitments and a reserve line for unplanned repairs. Without this, you’ll show healthy cash flow on paper right up until you don’t have it.
Reserves add another layer. Many loan agreements require capital reserve accounts. Operating agreements often specify reserves before distributions. Your forecast needs to track what goes into reserves and when those reserves release for use. Cash sitting in a restricted account doesn’t count toward what you can actually spend. Getting these details right is part of what makes real estate investor accounting different from general bookkeeping.
Once you have property-level cash flow, roll it up to the entity level. Most portfolios hold properties across multiple LLCs or partnerships. Each entity has its own bank accounts, its own debt, and its own distribution schedule. Your forecast needs to show cash position by entity because you can’t always move money freely between them. A surplus in one LLC doesn’t help if another LLC is short and there’s no mechanism to transfer funds.
Distributions add another timing dimension. If you have investors expecting quarterly distributions, those dates are fixed. Your forecast should show cash available for distribution after debt service, capex, and reserves. Forecasting this ahead of time lets you know whether you can make the distribution as planned or whether you need to communicate with investors early.
The “rolling” part means updating the forecast regularly as actuals come in. A 12-month rolling forecast always looks one year ahead, refreshed monthly as you close the books. Last month’s projections get replaced with actual results, and you add a new month at the end. This keeps the forecast current rather than a static document that goes stale.
For portfolios with any complexity, this kind of forecasting goes beyond monthly bookkeeping. It falls under virtual CFO services because it requires building models, stress-testing scenarios, and flagging issues before they become problems. At Rock Real Estate Services, Matthew Rodrigue works directly with portfolio owners on cash flow modeling so you always see liquidity ahead. Fully virtual across the 48 contiguous states.
Boutique Real Estate Accounting Firm
Next Step:
A Short Conversation
Tell us about your portfolio and your goals. We'll walk you through how we can help and what an engagement looks like.
More Questions
What is the difference between a repair and a capital improvement for taxes?
Repairs are deductible in the current year. Capital improvements must be capitalized and depreciated over time. The IRS has specific rules and safe harbors that determine which category an expense falls into.
Read answerWhat is the difference between a dealer and an investor for tax purposes?
A dealer holds property primarily for resale, like a flipper, and pays ordinary income plus self-employment tax with no access to capital gains rates or 1031 exchanges. An investor holds for rental or appreciation and can access both.
Read answerWhat does a real estate virtual CFO actually do?
A real estate virtual CFO provides senior financial leadership on a fractional basis. They handle cash flow modeling, acquisition underwriting, entity structuring, debt strategy, KPI dashboards, and formal annual budgeting.
Read answerI have partners in some deals and not others. How should the books reflect that?
Each deal needs its own set of books regardless of ownership structure. Solo deals track simple owner's equity, while partnership deals require capital accounts that show each partner's contributions, distributions, and current balance.
Read answerWhat is the QBI deduction and does my real estate qualify?
The QBI deduction under Section 199A allows a deduction of up to 20% of qualified business income. For rental real estate to qualify, the activity must rise to the level of a trade or business, but a safe harbor is available for rentals with at least 250 hours of rental services performed annually.
Read answerWhat is an investor portal and do I need one?
An investor portal is a secure online space where your investors log in to access reports, statements, K-1s, and documents. Whether you need one depends on your investor count and how many deals you're running.
Read answer