Articles

How much cash does a small supplier need to fund a milestone-paid defence contract?

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.

The assumptions

Illustrative fixed-price development contract, EUR million
ItemValue
Contract price6.00
Duration8 quarters
Cost incurred each quarter, evenly0.70
Total cost5.60
Margin0.40 (6.7% of price)
Payment4 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 borrowing9% 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.

Step 1: build the cumulative cash line

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)

Cash by quarter, base case
QuarterCostReceiptsCumulative cash
Q10.700.00-0.70
Q20.700.00-1.40
Q30.701.50-0.60
Q40.700.00-1.30
Q50.701.50-0.50
Q60.700.00-1.20
Q70.701.50-0.40
Q80.700.00-1.10
Q90.001.500.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.

Step 2: the cost of carrying it

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.

What if: acceptance takes a second quarter

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.

What if: the customer pays a 20% advance at signature

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.

The common mistakes

Takeaway

Questions readers ask

How do you calculate the cash a supplier needs to fund a milestone-paid contract?

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.

Why is the funding need larger than the margin?

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.

What reduces the funding need most?

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 workbooks behind this article

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.

Open the companion files →

Not on Amazon: 19 paperbacks by Julian R. Sterling on energy, infrastructure and land, printed on demand and shipped worldwide. Browse the bookshop →

Also on this site

Reading guide: regulation, compliance and banking → · All 1908 articles →