Cash Flow Projection Template for 3 Years

Standard Operating Procedure: 3-Year Cash Flow Projection

---

1. Executive Summary & Purpose

This SOP establishes the standardized methodology for constructing a 3-year cash flow projection. The objective is to provide a deterministic model for liquidity forecasting, ensuring capital sufficiency for operational requirements, debt service, and strategic investment. This document mitigates variance risks in multi-year financial planning.

2. Scope & Prerequisites

• Scope: Applies to all financial modeling activities related to 36-month solvency projections.
• Software Requirements: Microsoft Excel (365/2019+), Google Sheets (with Version History enabled), or designated EPM software (Anaplan/Adaptive).
• Data Inputs: Audited trailing 12-month (TTM) financials, finalized annual budget, CAPEX schedule, and debt amortization tables.
• PPE: N/A (Digital-first environment).

3. Roles & Responsibilities (RACI)

---

4. Step-by-Step Procedure

Phase I: Data Normalization

• Aggregate TTM actuals; scrub for non-recurring expenses (e.g., one-time legal fees, divestments).
• Segment revenues by stream (e.g., recurring, transactional) to establish growth baselines.
• Calibrate seasonality adjustments based on historical monthly variance.

Phase II: Variable & Assumption Mapping

• Define top-line revenue growth rates (CAGR targets).
• Establish Cost of Goods Sold (COGS) as a percentage of revenue.
• Document fixed vs. semi-variable operating expenses (OPEX).
• Input debt service requirements (Principal + Interest) per maturity schedule.

Phase III: Construction of the Projection Model

• Build the Cash Inflow Module: Account for accounts receivable turnover (DSO).
• Build the Cash Outflow Module: Map AP cycles (DPO) and payroll liabilities.
• Integrate CAPEX/Investment schedule: Schedule depreciation tax shields.
• Link components into a unified 36-month monthly waterfall: Beginning Cash + Inflows - Outflows = Ending Cash.

Phase IV: Sensitivity & Stress Testing

• Execute "Base Case" scenario.
• Execute "Downside Case": Reduce revenue growth by 20% and increase COGS by 10%.
• Verify that Ending Cash never dips below the mandated liquidity threshold (e.g., 3 months of OPEX).

---

5. Quality Assurance & Pro-Tips

Best Practices

• Bottom-Up, Not Top-Down: Always build from granular unit economics up to the consolidated statement.
• The "Sensibility Check": Divide your total payroll expense by headcount to ensure it aligns with historical trends.
• Direct vs. Indirect: Always use the Direct Method for 3-year cash flows to provide better visibility into operational liquidity.

Common Pitfalls

• Working Capital Neglect: Forgetting to model the lag between revenue recognition and actual cash receipt.
• Static Assumptions: Failing to update inflation factors (CPI) on software licenses and utility costs over a 36-month horizon.

---

6. Frequently Asked Questions (FAQ)

Q: How should I handle seasonal variance in a 3-year model? A: Apply a monthly seasonality index derived from the last 24 months of data to your annual figures. Do not use linear monthly distribution.

Q: At what point is the model deemed "out of sync"? A: The model requires an immediate audit if actual monthly cash variance exceeds 10% of the projected amount for two consecutive periods.

---

Authorized by: Julian Vance, Chief Architect Location: Template Registry Internal Documentation Server