Project Closeout Cost Forecast: The Final Figure You Can Actually Defend

A closeout forecast is the last honest estimate — reconcile the actuals, re-forecast what remains, and release only the reserve you’ve truly stopped needing. The final number should survive an audit.

A project’s cost story isn’t over when the work is done. The last milestone can close and the final invoice can still surprise you: unmasked supplier charges, demobilization labor, a warranty retainer you forgot was committed. The closeout cost forecast is the discipline that settles this — you take actuals to date, re-estimate only what’s genuinely left, apply the reserve you’ve already earned back, and produce the one number that goes into the final report and survives an audit. This guide covers the formulas behind that final figure, the closeout costs people routinely forget, and an Excel forecast you can run in an afternoon.

What a Closeout Cost Forecast Is

A closeout cost forecast is the end-of-project version of an estimate at completion (EAC): the total expected cost of the job once all remaining work, procurement close-out, and demobilization are settled. It’s built near the finish line, when there’s little work left but often plenty of reconciliation.

It answers one question with a number:what is the honest final cost of this project?Everything after that — releasing reserves, writing the final report, handing budget back to finance — flows from that answer.

Why Final Numbers Drift on Clean Projects

Teams that execute well still land late on closure, because a clean build doesn’t mean a settled ledger. The drift usually comes from costs that hide until the end:

• Demobilization— decommissioning equipment, releasing resources, closing facilities.
• Supplier reconciliation— final invoices, credit notes, and uncommitted line items.
• Warranty and retention— amounts held against future defects that were never zeroed.
• Documentation and close-out labor— handover packs, final testing, acceptance sign-off.
• Residual management reserve— funds set aside for unknown unknowns that never got spent.

None of these are surprises to a controller; all of them are surprises to a forecast that only tracked execution. That’s why the closeout forecast revises the numbers instead of copying the baseline.

The Three Numbers That Matter

Near completion, forecasting settles on three related figures:

• EAC (Estimate at Completion)— the total forecast cost of the job.
• ETC (Estimate to Complete)— what remainsfrom now on, the cost of finishing.
• VAC (Variance at Completion)— the gap between your approved budget and the forecast:VAC = BAC − EAC.

A negative VAC is an overrun; a positive one is headroom to return. The closeout focuses on making ETC realistic and VAC auditable, because those two decide how much of the reserve is genuinely released.

Estimate at Completion: Two Ways to Forecast

Per standard earned-value practice, EAC takes more than one form depending on how much you trust past performance:

• Extrapolate current efficiency:EAC = BAC ÷ CPI. If your cost performance won’t change, this projects the whole job at today’s efficiency — the classic EVM forecast from PMI.
• Bottom-up re-estimate:EAC = AC + ETC. At closeout you usually know the remaining work well enough to value it directly, so you add actual cost to a fresh, honest ETC instead of extrapolating.

Many tools, including Microsoft Project, compute EAC asAC + (remaining budgeted work ÷ CPI). The point is the same: the further along you are, the more you should trust a re-estimate of what’s left over a straight-line trend. Forecasting isn’t grading the past — it’s giving the remaining weeks a realistic number.

Reserve Release: The Boundaries

The two reserves behave differently at closeout, and mixing them up inflates or deflates the final figure:

Reserve	Purpose	At closeout
Contingency reserve	Known unknowns (identified risks)	Release what’s unspent after ETC is settled
Management reserve	Unknown unknowns	Release when scope is proven stable; don’t spend it on identified risks by default

Spending management reserve to cover an overrun of identified work is the kind of move that fails an audit of the final number. The forecast should state clearly which reserve is being used and why.

Run It Through a Worked Example

A $100,000 project (BAC) with $82,000 spent and a clean-but-not-perfect run closing out:

Figure	Value	How it’s derived
Actual cost (AC) to date	$82,000	Ledger reconciliation
Estimate to complete (ETC)	$9,500	Remaining demob + warranty + final docs
Estimate at completion (EAC)	$91,500	AC + ETC (bottom-up)
Budget at completion (BAC)	$100,000	Approved baseline
Variance at completion (VAC)	+$8,500	BAC − EAC
Reserve released	$8,500	Returned to finance, documented

The story the audit sees: a project that finished $8,500 under budget, with the reserve release explained and the ETC itemized — not a vague “rounded to budget” adjustment.

Build a Closeout Cost Forecast in Excel

1. Actuals sheet— pull every committed and invoiced cost from the ledger, and reconcile it against what was reserved.
2. Remaining-work sheet— list every close-out line: demobilization, final testing, warranty, documentation, legal and filing fees.
3. Forecast line—EAC = AC + ETC, thenVAC = BAC − EACas a formula.
4. Reserve column— flag contingency vs management reserve, and mark release decisions with a reason.
5. Check— ifEACis suspiciously close toBACwith no line items underneath it, you’ve manufactured a number instead of forecasting one.

Where Closeout Forecasts Fail

• Copying the baseline.Repeating the planned budget at closeout hides the real resulting cost.
• Forgetting demob and warranty.The remaining labor and retention are real money, even when execution was clean.
• Extrapolating when you should re-estimate.Straight-line EAC at 95% complete ignores the few-but-pricey items that remain.
• Raiding management reserve.Spending unknown-unknowns money on known overruns breaks the audit trail.
• Releasing reserve before ETC is settled.Releasing contingency before warranty closes leaves a hole the final invoice finds.

Frequently Asked Questions

What’s the difference between EAC and ETC?EAC is the total forecast cost of the job; ETC is only what remains from now on. They relate asEAC = AC + ETC.

At closeout, should I extrapolate or re-estimate?Re-estimate. Near the end you know the remainder well enough to value it directly, so bottom-upAC + ETCbeats a performance-pace trend.

What is variance at completion (VAC)?VAC = BAC − EAC. A negative value is an overrun; a positive value is headroom that usually returns as released reserve.

When should contingency reserve be released?After the ETC is settled and the remaining work is valued. Release unspent contingency and document the basis; management reserve releases only when scope is proven stable.

Is a closeout forecast the same as a final invoice?No. The forecast is the estimate you defend before closing the ledger; the final invoice is the billed reality that should land within it.

Settle the Number, Then Close the Book

The closeout forecast is where a project’s budget story becomes a number it can stand behind. Reconcile the actuals, re-estimate what’s genuinely left, and release only the reserve you’ve earned back. Get that right, and the final report — and the audit after it — writes itself.

Keep the monthly reconciliation on amonthly budget plannerhabit so cost actuals never pile up, and log every residual charge to anexpense tracker templateso the closeout has evidence, not memory. More free tools live atUse Office Toolkit.