Cash Flow Projection Template for Real Estate

Standard Operating Procedure: Real Estate Cash Flow Projection

Document ID: TR-FIN-7704
Effective Date: 2023-10-27
Version: 1.0.2
Review Cadence: Semi-Annual (Bi-annual)

1. Executive Summary & Purpose

This SOP establishes the standardized methodology for constructing, validating, and maintaining institutional-grade real estate cash flow projections. The purpose is to provide a deterministic model for evaluating asset performance, debt service coverage, and equity distributions, ensuring uniformity across the Template Registry portfolio.

2. Scope & Prerequisites

• Scope: Applies to all commercial and multi-family acquisition and asset management projections.
• Required Tools: Microsoft Excel 365 (latest build), CoStar/Reis market data, audited rent rolls, and historical P&Ls.
• Software Constraints: Disable circular references; set Iterative Calculation to "Off." Use consistent color-coding (Blue for inputs, Black for formulas).

3. Roles & Responsibilities (RACI Matrix)

4. Step-by-Step Procedure

Phase I: Data Normalization

• Ingest trailing 12-month (T12) operating statements.
• Adjust for non-recurring capital expenditures (CapEx) and owner-specific overhead.
• Align expense categories with industry standards (e.g., BOMA/IFMA).

Phase II: Revenue Modeling

• Input current Rent Roll with expiration schedule.
• Apply Loss-to-Lease (LTL) adjustments to match current market effective rents.
• Define vacancy loss and credit loss percentages based on submarket historicals.
• Calculate "Other Income" (parking, storage, utility bill-backs) as a fixed percentage of effective gross income (EGI).

Phase III: Expense & Debt Layering

• Model fixed vs. variable operating expenses (OpEx) with annual inflation escalation (standard: 3.0%).
• Input Real Estate Taxes; verify against current assessment vs. sale price reassessment.
• Integrate Debt Service (Interest Only or Amortization periods) per loan term sheet.

Phase IV: Sensitivity & Waterfall

• Build a 3-tier sensitivity table (Base, Upside, Downside) varying Exit Cap Rate and Rent Growth.
• Calculate Net Cash Flow (NCF) after Debt Service.
• Apply Waterfall distribution logic (Preferred Return → Catch-up → Promote).

5. Quality Assurance & Pro-Tips

• Metric Thresholds:
  • DSCR (Debt Service Coverage Ratio): Must not fall below 1.25x in any period.
  • Operating Expense Ratio (OER): Benchmark against regional averages (35%–45% for multi-family).
• Pro-Tips:
  • The "Sensity" Check: Never rely on a single exit cap rate. Always model a 50bps spread.
  • Zero-Check: Ensure that Total Revenue - Total OpEx - Debt Service = Cash Distribution. If the delta is non-zero, identify the orphan expense.
• Common Pitfalls: Assuming 0% vacancy in stabilized years; neglecting to account for leasing commissions (LCs) and tenant improvement (TI) allowances.

6. Frequently Asked Questions

Q: How should I handle unpredictable inflation spikes in the model?
A: Use a "Stress Scenario" tab where OpEx growth is set to 5%–7% while revenue growth remains flat. If the project survives the 1.15x DSCR floor under these conditions, it is considered "Defensive."

Q: Should I include depreciation in the Cash Flow model?
A: No. Cash flow models are strictly for operational liquidity. Depreciation is a non-cash tax accounting entry; exclude it from NCF calculations.

Q: What is the primary indicator of a "broken" template?
A: If the terminal value (exit price) accounts for >60% of the total projected Internal Rate of Return (IRR), the model is overly speculative and relies too heavily on exit yield compression rather than operational growth.

Authorized by: Julian Vance Chief Architect, Template Registry