Build a three-year view of where cash is expected to come from, where it will be used, and how those movements affect the balance available at the end of each year.
This Excel workbook is designed for business owners, founders, controllers, and finance teams that need a structured long-range cash-flow projection. Enter annual assumptions for operating, investing, and financing activities, then review the section totals, net change in cash, ending cash balance, and cumulative three-year amounts in one consistent statement.
See the liquidity path
Follow beginning cash, annual net cash movement, and ending cash across the full three-year forecast period.
Separate sources and uses
Organize receipts and payments by operating, investing, and financing activity instead of relying on one undifferentiated cash total.
Test planned decisions
Update expected collections, spending, asset purchases, borrowings, or capital contributions and review their combined effect on cash.
What does the cash-flow projection help you analyze?
The workbook turns annual cash assumptions into a direct view of expected inflows, outflows, and closing liquidity. It is useful when the central question is not only whether the business is profitable, but whether cash is available when planned payments, investments, and financing obligations occur.
Operating cash generation: compare customer receipts with payments to suppliers and employees, interest, taxes, dividends, and other operating uses shown in the statement.
Investment demands: capture cash used for acquisitions, property, plant and equipment, or portfolio investments, together with proceeds and investment income.
Financing movements: organize expected share-capital proceeds, long-term borrowing proceeds, and debt repayments separately from day-to-day operations.
Potential cash gaps or surpluses: identify years in which net cash movement reduces or increases the available balance.
Three-year cumulative impact: review the total cash contribution or use from each line and section over the complete projection horizon.
What is inside the workbook?
The visible worksheet combines editable annual assumptions with calculated cash-flow subtotals and a closing cash summary. The structure keeps each activity class distinct while still showing how all sections reconcile into the net increase or decrease in cash.
Annual cash-flow inputs
Enter or revise the expected cash amounts for each of the three forecast years using the worksheet's highlighted assumption area.
Activity subtotals
Review separate totals for operating, investing, and financing activities before evaluating the overall cash movement.
Cash movement summary
Connect beginning cash to the net increase or decrease in cash and the resulting year-end cash balance, with total three-year figures alongside.
The workbook view groups annual cash receipts and payments by activity, calculates section totals, and carries the net movement into ending cash for each year.
One statement connects activity to ending cash
The worksheet presents three annual columns and a total for the full period. Operating cash flow shows the contribution from core business activity; investing activity captures longer-term uses and proceeds; financing activity shows capital and borrowing movements. The cash movement summary then links the opening balance to the ending balance, making it easier to trace which assumptions drive changes in liquidity.
How do you use the template?
Set the starting point
Confirm the three forecast years and enter the opening cash and cash-equivalents balance for the first year.
Enter operating assumptions
Add expected customer receipts and the operating cash payments relevant to the business, including supplier, employee, interest, tax, or dividend items where applicable.
Add investment and financing flows
Record planned asset purchases, investment proceeds, capital contributions, borrowings, and debt repayments in their respective sections.
Review and refine
Check section subtotals, annual net cash movement, ending cash, and cumulative totals; revise assumptions when the projected balance does not support the operating or investment plan.
Who is this template for?
This workbook fits businesses that need an annual, three-year cash planning view rather than a transaction-level treasury tool. It can support startup planning, established-company budgeting, capital expenditure reviews, debt planning, and internal discussions about how operating performance and financing choices affect future liquidity. Controllers and finance teams can also use it as a concise schedule for explaining the main drivers behind projected cash balances.
For more detailed timing, use the monthly cash flow template to break the forecast into monthly periods. Businesses managing near-term receipts and payments may prefer the 9-week cash flow forecast, while teams that monitor cash movement at a more immediate level can use the daily cash flow template.
Choosing a selection results in a full page refresh.
