Percentage-of-Completion Method Calculator
Calculates percent complete, cumulative revenue recognized, and current-period gross profit for a long-term contract — and correctly applies the rule most calculators miss: if the contract is now expected to run at a loss, GAAP requires recognizing the entire estimated loss immediately, not spread proportionally like profit is. Built for controllers and project accountants at construction, manufacturing, aerospace/defense, and engineering firms managing multi-year contracts, who need this period's numbers to actually reconcile the moment a cost re-estimate turns a healthy contract into a loss position.
Download This Calculator
Get the Excel spreadsheet behind this calculator to use offline, customize for your needs, and publish as a web tool using Sheetflow.
Immediate Full-Loss Recognition
Automatically detects when total estimated costs exceed the contract price and recognizes the entire estimated loss in the current period — not spread proportionally like profit is.
Prior-Period Reconciliation
Ties cumulative revenue and cost already recognized in prior periods to this period's figures, so the current-period gross profit swing always reconciles correctly.
Built for Multi-Year Contracts
Works for construction, manufacturing, aerospace/defense, and engineering contracts under ASC 606 or IFRS 15, wherever revenue is earned as work progresses.
Frequently Asked Questions
What is the percentage-of-completion method and when is it used?
The percentage-of-completion method recognizes revenue and profit on a long-term contract gradually, as work is performed, rather than waiting until the contract is finished. Percent complete is calculated as costs incurred to date divided by total estimated costs, then applied to the total contract price to determine cumulative revenue earned so far. It's the standard method for construction, manufacturing, aerospace and defense, shipbuilding, and engineering contracts that span more than one reporting period, and it's required under both ASC 606 (US GAAP) and IFRS 15 when the customer receives benefit as work progresses.
Using the calculator's defaults: costs incurred to date of $10,500,000 against total estimated costs of $15,000,000 puts the contract at 70% complete. Applied to a $12,000,000 total contract price, that's $8,400,000 in cumulative revenue recognized to date — a straightforward calculation when the contract is profitable.
Why does a loss have to be recognized immediately, instead of gradually like profit?
Because accounting standards treat expected losses asymmetrically from expected profits, on the principle of conservatism — once a loss on the entire contract becomes probable and estimable, recognizing it gradually over the remaining life of the contract would mean carrying a known loss on the books as if it hadn't happened yet, which overstates the company's financial position in the meantime.
Using the calculator's defaults: total estimated costs increased to $15,000,000 against a $12,000,000 contract price, meaning the entire contract is now expected to lose $3,000,000 by completion. Under the normal profit-recognition logic, only a proportional share of that loss would show up in any given period. Instead, GAAP requires the full $3,000,000 loss to be recognized in the period it's discovered — regardless of how much of the contract remains. Here, only 30% of the work is left, but 100% of the expected loss hits this period's financials.
How do I calculate this period's gross profit when a contract has become a loss contract?
Start with what's already been recognized cumulatively in prior periods (revenue previously recognized minus costs previously recognized), then compare it to what the FULL cumulative gross profit or loss should now be — which is simply the total estimated loss, in full, once a contract is expected to lose money overall. The difference between those two numbers is what hits the income statement this period.
Using the calculator's defaults: prior periods had recognized a cumulative profit of $500,000 (revenue of $6,000,000 minus costs of $5,500,000). Now that the full contract is expected to lose $3,000,000, cumulative gross profit must immediately equal negative $3,000,000. The swing from +$500,000 to -$3,000,000 is a full $3,500,000 hit — all recognized in this one period, even though revenue recognized this period is a comparatively modest $2,400,000. This is why loss contracts can produce a period where recognized costs ($5,900,000) are more than double recognized revenue ($2,400,000) — the math is deliberately front-loading the entire bad news.
What happens to the remaining periods once a loss has been fully recognized?
Once the full estimated loss is recognized in the period it's discovered, subsequent periods return to normal proportional recognition — revenue and costs recognize in step with percent complete, and (assuming the cost estimate doesn't change again) the contract finishes exactly at its estimated total loss, with no further profit or loss surprises baked in.
This is a meaningful practical implication: after a loss-recognition period, a project team might see revenue and costs moving together again and mistakenly read that as "things have stabilized" or "we're recovering" — when in reality, the full loss has simply already been taken, and the remaining periods are just executing the contract to its known, unprofitable conclusion. Watching for a second cost re-estimate (which would trigger yet another adjustment) matters more than watching the period-to-period profit trend once a contract has already been flagged as a loss contract.
What should I do if my cost estimate keeps changing from period to period?
Re-run this calculation every time your total estimated cost changes, since a shift from "profitable" to "loss" (or a further increase in an already-recognized loss) needs to flow through immediately, not at the next scheduled review. A contract can cross from profitable to loss-making gradually over several cost re-estimates, and catching the crossover the period it happens — rather than after several periods of drift — keeps your financials from carrying a known loss silently in the background.
Frequent cost re-estimation is also worth treating as an operational red flag in its own right, independent of the accounting mechanics: a contract whose total estimated cost keeps moving upward across multiple periods usually signals scope creep, underestimated risk, or execution problems that are worth investigating directly, not just recalculating around each time a new estimate comes in.
Transform Your Excel Models into Web Tools
Turn your complex Excel calculations into online calculators, web forms, and APIs. No coding required — upload your spreadsheet and publish your calculations instantly.
Calculations are for estimation and planning purposes. Users should verify important results for their specific situations. No signup required. Calculations performed securely.