Cash Flow Projection Model Template
Build detailed cash flow projection for the next 12-24 months. Forecast operating, investing, and financing cash flows monthly.
How to use this template
Project operating cash
Starting with projected net income, adjust for depreciation, changes in working capital. Model monthly customer collections and vendor payments.
Project investing cash
Forecast monthly capital expenditures, asset disposals, and other investing activities based on capex plan and project schedule.
Project financing cash
Model debt draws and repayments, equity issuances or buybacks, and dividend payments based on financing plan.
Calculate monthly cash position
Calculate: Beginning cash + operating - investing - financing = ending cash. Track minimum cash required and borrowing capacity.
Identify liquidity needs
Assess cash position in each month. Identify months requiring additional borrowing or periods of excess cash. Plan accordingly.
Why use this template
- Provides detailed view of cash needs and timing
- Identifies periods requiring short-term financing or excess cash
- Supports treasury cash management and debt draw planning
- Enables proactive management of liquidity risks
Related templates
Rolling Forecast Model
Create a rolling 12-month forecast that updates each period. Replace outdated monthly budgets with current projections based on actual performance.
FP&AHeadcount and Compensation Forecast
Forecast future headcount and compensation by department and level. Project payroll expense and track personnel costs.
FP&AWorking Capital Forecast
Forecast changes in working capital (receivables, inventory, payables). Plan for cash needs or surpluses driven by operating growth.
Ready to streamline your close?
Vergo turns templates into automated workflows with real-time collaboration, integrations, and AI built in.