A defence supplier pays costs as they occur and is paid at milestones; the cash gap, not the margin, decides whether the firm can accept the contract.
A EUR 6.00 million fixed-price development contract with EUR 0.70 million of cost a quarter, paid in four milestones with a one-quarter delay, leaves the supplier EUR 1.40 million short at the low point, 23.3% of the price and 3.5 times the EUR 0.40 million margin. If acceptance takes a second quarter the need becomes EUR 2.10 million; a 20% advance cuts it to EUR 0.80 million.
| Item | Value |
|---|---|
| Contract price | 6.00 |
| Duration | 8 quarters |
| Cost incurred each quarter, evenly | 0.70 |
| Total cost | 5.60 |
| Margin | 0.40 (6.7% of price) |
| Payment | 4 milestones of 1.50, at the end of quarters 2, 4, 6 and 8 |
| Delay from milestone to cash (acceptance and payment terms) | 1 quarter |
| Cost of the supplier’s borrowing | 9% a year |
The supplier pays staff and subcontractors as the work happens; the customer pays when a milestone is accepted. The gap between the two is financed by the supplier.
Each quarter, cash movement is receipts minus cost. The funding need is the lowest point of the running total.
Cumulative casht = cumulative casht−1 + receiptst − costt
Peak funding need = − MIN(cumulative cash)
Excel: =-MIN(CumulativeCash)
| Quarter | Cost | Receipts | Cumulative cash |
|---|---|---|---|
| Q1 | 0.70 | 0.00 | -0.70 |
| Q2 | 0.70 | 0.00 | -1.40 |
| Q3 | 0.70 | 1.50 | -0.60 |
| Q4 | 0.70 | 0.00 | -1.30 |
| Q5 | 0.70 | 1.50 | -0.50 |
| Q6 | 0.70 | 0.00 | -1.20 |
| Q7 | 0.70 | 1.50 | -0.40 |
| Q8 | 0.70 | 0.00 | -1.10 |
| Q9 | 0.00 | 1.50 | 0.40 |
The lowest point is −1.40 at the end of quarter 2: the supplier has paid 1.40 of cost by the time the first milestone is invoiced, and the cash arrives a quarter later. The peak funding need is EUR 1.40 million, 23.3% of the contract price. The contract ends with 0.40 in cash, equal to the margin.
Interest at 9% a year, 2.25% a quarter, on each quarter’s opening deficit adds up to 0.162, which is 40.5% of the 0.40 margin.
If each milestone takes two quarters to turn into cash, the receipts arrive in quarters 4, 6, 8 and 10 and the running total reaches −2.10 in quarter 3. The peak funding need rises from 1.40 to EUR 2.10 million, 35.0% of the price, and interest to 0.288, 72.0% of the margin. One more quarter of delay raises the peak by 0.70, which is the cost of a quarter, 0.70.
An advance of 1.20 at the start, with the milestones reduced pro rata, brings the peak funding need to EUR 0.80 million, 13.3% of the price, in quarter 8. The interest falls to 0.047. An advance covers 42.9% of the base case need.
Build the cumulative cash line quarter by quarter, receipts minus cost, and take the lowest point. In the example the low point is EUR 1.40 million.
The supplier pays all costs before the milestones turn into cash, while the margin is only earned at the end. Here the need is EUR 1.40 million against a margin of EUR 0.40 million.
An advance payment and shorter acceptance and payment terms. A 20% advance lowers the example's need to EUR 0.80 million; a second quarter of delay raises it to EUR 2.10 million.
The free companion files for Breaking Into European Defence Procurement hold four Excel workbooks with every figure in a dated input cell, the 35 per cent content test, the proposal economics that decide whether a firm can afford to bid, and the readiness checklists as working documents. The contract cash line in this article uses invented figures and is not in them. No account and no email address.
Not on Amazon: 19 paperbacks by Julian R. Sterling on energy, infrastructure and land, printed on demand and shipped worldwide. Browse the bookshop →
Reading guide: regulation, compliance and banking → · All 1908 articles →