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.
| Item | Value |
|---|---|
| Contract price | 5.00 |
| Estimated total cost at signing | 4.00 |
| Expected margin at signing | 1.00 (20.0%) |
| Cost incurred, Q1 to Q4 | 0.80, 1.20, 1.20, 0.80 |
| Invoiced, Q1 to Q4 | 2.00, 1.00, 1.00, 1.00 |
| Revenue method | Over time, cost-to-cost input method |
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
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
| Quarter | Cumulative cost | % complete | Revenue to date | Revenue of the period | Margin of the period | Billed to date | Contract asset (liability) |
|---|---|---|---|---|---|---|---|
| Q1 | 0.80 | 20.0% | 1.00 | 1.00 | 0.20 | 2.00 | (1.00) |
| Q2 | 2.00 | 50.0% | 2.50 | 1.50 | 0.30 | 3.00 | (0.50) |
| Q3 | 3.20 | 80.0% | 4.00 | 1.50 | 0.30 | 4.00 | 0.00 |
| Q4 | 4.00 | 100.0% | 5.00 | 1.00 | 0.20 | 5.00 | 0.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.
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.
| Estimated total cost | Expected margin | % complete | Revenue to date | Revenue of Q3 | Loss provision | Result of Q3 | Cumulative result |
|---|---|---|---|---|---|---|---|
| 4.00 | 1.00 | 80.0% | 4.00 | 1.50 | 0.00 | 0.30 | 0.80 |
| 4.60 | 0.40 | 69.6% | 3.48 | 0.98 | 0.00 | (0.22) | 0.28 |
| 5.40 | (0.40) | 59.3% | 2.96 | 0.46 | 0.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.
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.
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.
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.
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%.
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 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.
Not on Amazon: 24 paperbacks by Julian R. Sterling on insurance and retirement, printed on demand and shipped worldwide. Browse the bookshop →
Reading guide: corporate finance, valuation and markets → · All 1908 articles →