Skip to main content
12 April 2024

Cash Flow Forecast Template with Scenario Planning

View original download ↗
# Cash Flow Forecast Template

We built this 12-week rolling model for clients who need quick visibility.

## Inputs
- Receipts by customer with probability weighting
- Supplier terms and seasonal spend
- Tax outflows (VAT, PAYE, CT) mapped to calendar

## How clients use it
- 15% average reduction in borrowing costs by surfacing surplus cash two weeks earlier.
- Weekly scenario reviews to avoid breaching covenants.

## Steps
1. Populate opening cash and committed receipts.
2. Layer variable spend and tax dates.
3. Run best/base/worst to set decision triggers.
4. Share PDF summaries directly with lenders or investors.