⚡ Quick Summary
- This guide shows you how to build capex schedules that track deposits, progress draws, and retentions without losing sight of working capital balances.
- The core idea is simple: treat the capex schedule as a cash‑flow engine, not just a fixed asset list, and wire it into your working capital management processes.
- You’ll map every cash event-deposits, milestone payments, releases-using consistent working capital formulas so operating cash, investing cash, and financing flows stay aligned.
- The method makes calculating working capital changes straightforward: you see when cash leaves, when assets go live, and how retentions and holdbacks affect liquidity.
- It plugs into your broader capex & project evaluation framework, alongside project‑selection and buy vs lease templates.
- You’ll avoid the most common traps: double‑counting spend, missing retentions, ignoring tax, or mis‑timing payments.
- If you’re short on time, remember this: a good capex schedule is a time‑phased cash model first, and an accounting schedule second-and it must stay in lockstep with working capital metrics and covenants.
💡 Introduction: Why This Topic Matters
Most organisations have a “capex schedule”, but many are little more than static lists of projects and totals. They don’t show when deposits are due, how progress draws line up with supplier milestones, or when retentions are released, and they rarely connect cleanly to working capital or short‑term cash forecasts. That’s dangerous when projects are large, multi‑year, or debt‑funded. A small slip in timing can blow through net working capital buffers or covenants. This cluster article zooms in on the scheduling piece of your broader capex & project evaluation system. You’ll learn how to treat deposits, draws, and retentions as first‑class working capital balances, model them with simple working capital formulas, and integrate them into your forecasting rhythm. The result is a schedule that treasury, FP&A, and project teams can all trust-and that makes project execution compatible with tight working capital management targets.
🧩 A Simple Framework You Can Use
Use a three‑layer framework: project, schedule, and cash. At the project layer, capture scope, budget, supplier terms, and milestones. At the schedule layer, translate those terms into dated cash events: deposits, progress draws, retentions, and releases, using clear working capital formulas for how each item hits the balance sheet and cash. At the cash layer, connect the schedule to your short‑ and medium‑term forecasts so every capex dollar is visible in your working capital metrics and covenant views. The key discipline is to model deposits and retentions explicitly as working capital balances, not miscellaneous lines that disappear into “other”. That makes calculating working capital impacts trivial and allows you to test scenarios quickly. Once the pattern is defined, you can reuse it across projects and geographies, giving CFOs a unified view of capex commitments and their interaction with liquidity.
🛠️ Step-by-Step Implementation
Step 1: 🧾 Capture project scope, terms and funding plan
Start by standardising inputs. For each project, capture the total budget, supplier contracts, milestone definitions, deposit percentages, retention rules and expected completion dates. Record how the project is funded-operating cash, specific debt facility, vendor finance or a mix-and the constraints that matter: maximum monthly outflow, headroom buffers in working capital metrics, or covenant thresholds. Align project timing with your overall capex strategy and criteria from your project evaluation framework. Then map the project into your portfolio: where it sits relative to other investments, and whether it competes with a buy vs lease alternative. This framing ensures the schedule you build supports, rather than undermines, working capital management. It also allows treasury to see which projects are “locked in” and which are flexible if cash tightens, giving you practical entry and exit criteria in trading‑style levers for pausing or resequencing work.
Step 2: 📅 Translate contracts into a dated cash schedule
Next, convert contract terms into a time‑phased schedule. For each project, create lines for deposits, milestone‑based draws, retentions and final releases. Assign dates based on realistic delivery expectations, not just contract signatures. Use consistent working capital formulas to classify each cash event: deposits as prepayments, progress draws as capex outflows, retentions as balance‑sheet liabilities until released. Tie the schedule to your construction or commissioning timeline where relevant. Make sure all amounts reconcile to the approved budget so there’s no hidden “extra” spend. This is where many teams under‑model retentions, causing surprises when large releases land in a quarter with tight working capital balances. Once the dated schedule is built, it becomes the authoritative source for project cash timing, feeding both project dashboards and your central cash forecast.
Step 3: 💧 Integrate the schedule with working capital and cash forecasts
With the dated schedule in place, connect it to your short‑term cash model and working capital management processes. Allocate each cash event to the correct bank accounts, entities and currencies. Reflect payment terms and approvals: when invoices are received, when they’re approved, and how this interacts with payment runs and cut‑off dates. For large programs, roll individual project schedules into a portfolio view so you see the aggregate impact on working capital balances and headroom. Use your forecasting platform to sync these flows into your 13‑week cash forecast and monthly planning models. This alignment turns the capex schedule into a living source of truth: if a milestone slips, you move one date and instantly see changes in covenants, debt drawdowns and liquidity, rather than discovering them after the fact.
Step 4: 🔀 Model scenarios, delays and resequencing options
Capex rarely runs exactly to plan, so build scenarios into your schedule. For each major project, create toggles for delays, scope changes, cost overruns and retention disputes. Link these to shifts in deposits, draws and releases, and see how they flow through net working capital and covenants. Explore resequencing options: can you push a noncritical project back a quarter to protect working capital if trading conditions worsen? Use your existing downside and stress‑test frameworks to model capex shocks alongside revenue or margin shocks. Integrate this with your project ranking and capital allocation tools so you can pivot quickly to higher‑return initiatives if funding capacity tightens. The goal is to have clear, pre‑agreed entry and exit criteria in trading‑style rules for when projects start, pause or stop, rather than making panicked cuts under pressure.
Step 5: 🧱 Harden the schedule into a reusable, governed template
Finally, convert your best‑practice schedule into a governed template. Separate input sections (project details, contract terms, retention rules) from protected logic (timing, working capital formulas, roll‑ups). Apply basic validation-totals vs budget, date ordering, retention percentages—to catch errors early. Integrate the template into your standard project approval and monthly reporting processes so every new capex item enters via the same pattern. Link it to your central working‑capital and cash‑flow models using shared dimensions (project IDs, cost centres, entities) so calculating working capital impacts requires no extra work. Where possible, implement the template in a modelling platform that supports versioning and collaboration, rather than scattered spreadsheets. Over time, this becomes a core asset: a live, portfolio‑wide view of capex commitments that keeps working capital balances and liquidity firmly under control.
📈 Real-World Examples
A regional telco launched a multi‑year network upgrade with dozens of tower projects, each with different suppliers, deposits, and retentions. Initially, capex schedules lived in individual project spreadsheets, and treasury only saw totals. When demand softened and lenders tightened terms, the CFO needed to know which projects could be delayed without breaching coverage or working capital metrics. By rebuilding schedules using a standard template, the team created a consolidated view of deposits, draws, and retentions by month and entity. They quickly identified lower‑priority sites whose draws could be pushed back one or two quarters without affecting key coverage areas. That freed enough working capital headroom to keep critical upgrades on track and avoid expensive emergency financing. The same template is now used for data‑centre builds and major IT projects, providing a shared language between finance, procurement, and engineering.
⚠️ Common Mistakes to Avoid
One common mistake is modeling only total project spend, not timing, so deposits, draw,s and retentions hit working capital balances in unpredictable spikes. Another is treating retentions as “future problems”, with no visibility on when cash will actually leave or return. Teams also forget that delays usually push both cost and cash to the right, distorting net working capital and covenants if not reforecast. Some capex schedules live outside central tools, so project teams update one version while treasury relies on another. Finally, many organisations skip explicit entry and exit criteria in trading‑style rules for when projects start or pause, leading to ad‑hoc cuts when cash tightens. Avoid these traps by standardising working capital formulas, integrating schedules with your 13‑week cash and budgeting models, and agreeing on governance that forces every new project through the same template.
❓ FAQs
Your schedule must be detailed enough to show meaningful cash events, but not so granular that it’s impossible to maintain. Typically, deposits, key milestones, retentions and final payments are sufficient. Each should have a date, amount and classification that maps to your working capital and cash flow models. For mega projects, you might add a layer for major subcontracts, but still roll them into a single
project view for reporting. The litmus test: can treasury see how this project affects working capital balances and covenants month by month? If yes, you’re at the right level. If not, you may need to add structure rather than more lines.
Treat vendor finance and leases as alternative funding structures that sit on top of the same project schedule. The underlying cash for deposits, draws and retentions still occurs; what changes is who funds them and when repayments occur. Use your
buy vs lease template to structure these obligations, and then tie the resulting flows back to the project schedule and working capital metrics. This makes comparisons transparent: you can see whether vendor terms genuinely improve working capital or simply re label obligations. Integrating these pieces ensures decisions about funding structure are grounded in the same data as project timing.
Update schedules whenever a milestone date, contract term or project scope changes. In practice, that means at least monthly for active projects, and more often for large or risky ones. Because your schedule feeds straight into cash and
working capital management views, late updates create blind spots for treasury and the CFO. Automate as much as you can: pull status from project systems, then have finance validate and approve changes. The goal is a single source of truth that always reflects the latest view of deposits, draws and retentions, not a “best guess” compiled before board meetings.
Capex schedules should be tightly integrated with your budgeting and reforecasting rhythm. At budget time, schedules inform annual capex envelopes, headroom planning and target working capital balances. During the year, changes to schedules become one of the main drivers for reforecasting cash and debt needs. By building schedules in a shared modeling environment, updates cascade automatically into
13-week cash forecasts, rolling plans and working capital metrics dashboards. This avoids the common pattern where budgets assume smooth capex while actuals are lumpy and disruptive. The result is a planning process where project reality and financial plans stay aligned, rather than drifting apart.
🚀 Next Steps
You now have a blueprint for capex schedules that work as cash‑flow engines, not static lists. The next move is to embed this template as the only way new projects enter your portfolio. Connect it to your project evaluation process so approved initiatives automatically generate dated cash schedules. Integrate those schedules with your 13‑week cash and annual planning models, and route them into your working capital metrics dashboards so deposits, draws, and retentions are always visible. If you already use a modern forecasting or modelling platform, implement the schedule as a governed template and link it to your cash‑flow forecasting setup. Finally, agree on simple entry and exit criteria in trading‑style rules with executives, so decisions to start, pause, or resequence projects are grounded in real‑time views of working capital balances, not intuition.
Back