Articles

How much revenue does a fixed-price contract recognise by cost-to-cost, and what happens when the estimate rises?

Revenue follows cost incurred over the latest estimate of total cost, not invoices. When the estimate moves, the whole difference lands in the quarter of the change.

A $5.00 million fixed-price contract with an estimated cost of $4.00 million recognises revenue of $1.00, 1.50, 1.50, 1.00 million over four quarters, a 20.0% margin. If the estimate rises to $4.60 million at the end of Q3, Q3 revenue falls from $1.50 million to $0.98 million and the quarter shows a loss of $0.22 million although the contract stays profitable. If it rises to $5.40 million, above the price, the whole expected loss of $0.40 million is booked in Q3: a result of $(0.90) million against a planned $0.30 million profit.

The assumptions

One illustrative fixed-price contract, $ millions
ItemValue
Contract price5.00
Estimated total cost at signing4.00
Expected margin at signing1.00 (20.0%)
Cost incurred, Q1 to Q40.80, 1.20, 1.20, 0.80
Invoiced, Q1 to Q42.00, 1.00, 1.00, 1.00
Revenue methodOver time, cost-to-cost input method

Step 1: the percentage of completion

Under the cost-to-cost method, progress is the share of the total estimated cost already incurred. Costs of $0.80 million against an estimate of $4.00 million put the contract 20.0% complete at the end of Q1.

Percentage complete = cumulative cost incurred / estimated total cost

Excel: =CumCost/EstTotalCost

Step 2: cumulative revenue, then the period

Cumulative revenue is the percentage times the price. The revenue of a quarter is the cumulative figure less what was recognised before, never the percentage of the quarter alone.

Revenue to date = percentage complete × contract price

Revenue of the period = revenue to date − revenue recognised to the prior period end

Excel: =Pct*Price and =RevToDate-PriorRevToDate

The plan, estimate unchanged at 4.00
QuarterCumulative cost% completeRevenue to dateRevenue of the periodMargin of the periodBilled to dateContract asset (liability)
Q10.8020.0%1.001.000.202.00(1.00)
Q22.0050.0%2.501.500.303.00(0.50)
Q33.2080.0%4.001.500.304.000.00
Q44.00100.0%5.001.000.205.000.00

The Q1 margin is $1.00 million of revenue less $0.80 million of cost, $0.20 million, which is 20.0% of revenue, the 20.0% margin at signing. The customer paid $2.00 million up front, so at the end of Q1 the company owes performance worth $1.00 million: a contract liability, not revenue.

Step 3: what a higher estimate does

At the end of Q3 the engineers raise the estimated total cost. Cost incurred to date is $3.20 million, so the percentage falls and revenue to date is restated with a cumulative catch-up: the whole difference goes through Q3, not the remaining quarters.

Position at the end of Q3 for three estimates of total cost
Estimated total costExpected margin% completeRevenue to dateRevenue of Q3Loss provisionResult of Q3Cumulative result
4.001.0080.0%4.001.500.000.300.80
4.600.4069.6%3.480.980.00(0.22)0.28
5.40(0.40)59.3%2.960.460.16(0.90)(0.40)

At an estimate of 4.60 the contract is still profitable at $0.40 million. Revenue to date is 69.6% × 5.00 = $3.48 million, Q3 revenue falls from $1.50 million to $0.98 million and the Q3 result is $0.98 − $1.20 = $(0.22) million, a loss in a quarter on a contract that will make money.

Step 4: when the estimate passes the price

At an estimate of 5.40 the contract loses $0.40 million over its life. The whole expected loss is recognised at once, not as the work proceeds. Revenue to date is 59.3% × 5.00 = $2.96 million against cost of $3.20 million, which already includes a loss to date of $0.24 million.

Provision = total expected loss − loss already in revenue to date less cost to date

Excel: =MAX(0,EstTotalCost-Price)-MAX(0,CumCost-RevToDate)

The provision is 0.40 − 0.24 = $0.16 million. The cumulative result is $2.96 − $3.20 − $0.16 = $(0.40) million, exactly the expected loss over the life of the contract. The Q3 result swings from the planned +$0.30 million to $(0.90) million, and the remaining work, $2.04 million of revenue against $2.20 million of cost, nets to zero against the provision.

What if: the contract bills ahead of the work

The balance sheet follows revenue to date, not invoices. With the original estimate, billing of $4.00 million at the end of Q3 equals revenue to date of $4.00 million and the contract asset is nil. Under the 5.40 estimate revenue to date is only $2.96 million, so the same invoices leave a contract liability of $1.04 million: the customer has paid for work the company has not yet earned under the revised measure.

The common mistakes

Takeaway

Questions readers ask

What is the cost-to-cost method?

An input method for revenue recognised over time: the percentage complete is the cost incurred to date over the estimated total cost, and revenue to date is that percentage times the contract price. It measures progress by the costs that contribute to it.

Why does revenue fall when the cost estimate rises?

Because the percentage complete is cost incurred over total estimated cost. A higher denominator lowers the percentage, and revenue to date is restated downwards. At an estimate of 4.60 the percentage at Q3 falls from 80.0% to 69.6%.

When is a loss on a contract booked?

As soon as total estimated cost exceeds the price. The whole expected loss, $0.40 million here, is recognised immediately, whatever the percentage complete.

The workbooks behind this article

The free companion files for The Financial Controller rebuild the allocation of a bundled hospital contract with its deferred revenue and the revenue contract review checklist. The cost-to-cost schedule in this article is a separate illustration and is not in them. No account and no email address.

Open the companion files →

Not on Amazon: 24 paperbacks by Julian R. Sterling on insurance and retirement, printed on demand and shipped worldwide. Browse the bookshop →

Also on this site

Reading guide: corporate finance, valuation and markets → · All 1908 articles →