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
Prepaid Expense Workpaper
Track and amortize prepaid expenses with a structured workpaper that keeps your schedules accurate and audit-ready every close.
Close ManagementStandard Month-End Close Checklist
A comprehensive checklist to ensure nothing falls through the cracks during your month-end close. Track every task, owner, and deadline in one place.
Close ManagementClose Calendar Template
Plan out your entire month-end and quarter-end close timeline with a structured calendar. Coordinate across teams and set clear deadlines.
Ready to streamline your close?
Vergo turns templates into automated workflows with real-time collaboration, integrations, and AI built in.