Why Your Monthly EV Report Matters
A monthly earned value report isn't a compliance exercise. It's the single most important commercial document a project produces between interim applications. Get the reporting wrong and you won't spot a deteriorating CPI until it's too late to recover.
On a target cost contract, the pain/gain calculation depends on the relationship between total Defined Cost and the target. Your EV report makes that relationship visible every month, not just at final account.
A good monthly EV report achieves four things:
- Early warning of cost and schedule drift - a CPI trending below 1.00 over three consecutive months is a pattern, not a blip
- Evidence for compensation event assessments - your EV baseline is a critical reference under NEC4 clause 63
- Pain/gain share visibility - monthly EAC and ETC forecasting tells you where you're heading before you arrive
- Audit trail for final account - contemporaneous monthly records support your commercial position when final account negotiations start
Section 1: Executive Summary
The section your project director actually reads. One page maximum. Written last, read first.
What to include:
- Reporting period (e.g., Period 7: January 2026)
- Headline metrics: BAC, cumulative EV, cumulative AC, CPI, SPI
- One-sentence status: "The project is 2.3% over budget and 1.3 weeks behind programme, with a forecast outturn £780K above target."
- Key movements this period: what changed since last month, which work packages drove the variance
- Top 3 risks, ranked by financial impact, with recommended actions
- Decisions required: what you need the reader to approve or escalate
Don't fill the summary with background. They know the project. Tell them what's changed and what they need to do.
Section 2: Cost Performance Analysis
The core of the report. Present the numbers, then explain them.
| Metric | Formula | This Period | Cumulative |
|---|---|---|---|
| BAC | Approved budget | - | £42,000,000 |
| Planned Value (PV) | Time-phased BAC | £3,150,000 | £24,500,000 |
| Earned Value (EV) | % complete x BAC | £3,020,000 | £23,800,000 |
| Actual Cost (AC) | Defined Cost incurred | £3,340,000 | £25,100,000 |
| Cost Variance (CV) | EV - AC | -£320,000 | -£1,300,000 |
| CPI | EV / AC | 0.90 | 0.948 |
For full formula derivations, see the earned value formulas guide. Don't just state that CPI is 0.95. Explain why. "CPI dropped from 0.97 to 0.95 this period, driven by a 12% labour overrun on WP-04 and unrecovered prelim costs following the 3-week access delay." A number without a cause is useless to a decision-maker.
Section 3: Schedule Performance Analysis
Schedule performance in EV terms measures whether you're delivering work at the planned rate - not whether activities are hitting programme dates. Your CPI and SPI tell different stories, and the report needs both.
| Metric | Formula | This Period | Cumulative |
|---|---|---|---|
| Schedule Variance (SV) | EV - PV | -£130,000 | -£700,000 |
| SPI | EV / PV | 0.96 | 0.971 |
| Time Variance (TV) | SV / (BAC / planned duration) | -0.2 weeks | -1.3 weeks |
Connect SPI to actual programme impacts. "SPI 0.971 equates to approximately 1.3 weeks of schedule slippage. The critical path runs through M&E installation on Level 3, delayed by late design information (CE-017, notified 14 January 2026)." Linking schedule variance to specific compensation events builds the evidence trail for time-based claims.
Section 4: Variance Analysis by Work Package
This is where a report stops being a summary and starts being useful. Most EV reports never get past the headline CPI. Break variance down at work package level - your commercial team needs to know exactly where the money is leaking.
| WP | Description | BAC (£) | EV (£) | AC (£) | CV (£) | CPI | Status |
|---|---|---|---|---|---|---|---|
| WP-01 | Enabling works | 3,200,000 | 3,200,000 | 3,050,000 | +150,000 | 1.05 | Complete |
| WP-02 | Substructure | 6,800,000 | 6,600,000 | 6,900,000 | -300,000 | 0.96 | On track |
| WP-03 | Superstructure | 12,400,000 | 8,100,000 | 8,500,000 | -400,000 | 0.95 | At risk |
| WP-04 | Structural steel | 5,600,000 | 3,200,000 | 3,650,000 | -450,000 | 0.88 | Red flag |
| WP-05 | M&E first fix | 8,200,000 | 2,700,000 | 2,800,000 | -100,000 | 0.96 | At risk |
| WP-06 | External works | 5,800,000 | 0 | 0 | 0 | - | Not started |
| Total | 42,000,000 | 23,800,000 | 25,100,000 | -1,300,000 | 0.948 |
Focus commentary on the 2-3 work packages with the worst CPI. WP-04 at 0.88 is the one bleeding money. Explain the root cause, quantify the impact, recommend corrective action. Don't waste space on work packages performing well. See the cost and schedule variance guide for formula breakdowns.
Section 5: Forecast to Completion
Use EAC, ETC and TCPI to project where the project is heading. Always present multiple methods - never a single forecast.
| Forecast Method | Formula | EAC | VAC |
|---|---|---|---|
| CPI-based | BAC / CPI | £44,303,797 | -£2,303,797 |
| CPI x SPI composite | AC + (BAC - EV) / (CPI x SPI) | £44,871,834 | -£2,871,834 |
| Bottom-up ETC | AC + management ETC | £43,400,000 | -£1,400,000 |
| TCPI (to BAC) | (BAC - EV) / (BAC - AC) | 1.077 | - |
A TCPI of 1.077 means delivering every remaining pound at 8% below the planned cost rate. If current CPI is 0.95, achieving that requires a dramatic improvement. Be honest about this in the report. False optimism in month 7 becomes a crisis in month 12.
Section 6: Trend Analysis and S-Curves
A single month's CPI is a data point. Six months of CPI is a story. Include three trend charts:
- S-curve chart - PV, EV and AC plotted cumulatively. When AC pulls away from EV, everyone in the room can see it. No formula required. See the S-curve tracking guide for build instructions.
- CPI/SPI trend chart - monthly indices on a line chart with the 1.00 baseline marked. Three consecutive months below 1.00 demands intervention.
- VAC trend - forecast overrun/underrun each month. If VAC worsens every period, corrective actions aren't working.
Translate trends for non-technical readers. Don't write "CPI has exhibited a declining trajectory over the last three reporting periods." Write: "We've been spending more than we're earning for three months running. The gap's widening. Without intervention, we'll finish £2.2M over target."
Section 7: Risk Register and Commercial Flags
Connect EVM data to real project risks. On NEC4 contracts, your EV report's risk section should feed directly into the Early Warning Register. If CPI is 0.88 on a work package and no early warning has been raised, that's a governance problem - not just a cost problem.
| # | Risk/Flag | Financial Exposure | Action Required |
|---|---|---|---|
| 1 | WP-04 labour productivity 12% below estimate (CPI 0.88) | £672,000 at completion | Recovery programme by Period 8 |
| 2 | CE-017 late design information (Level 3 M&E), 3-week delay to critical path | £180,000 time prelims | Quotation submitted 28 Jan 2026 |
| 3 | Subcontractor insolvency risk (cladding, WP-07 not started) | £400,000 re-procurement | Alternative subcontractor identified |
| 4 | Winter weather programme impact (SPI 0.97) | £90,000 per week delay | Acceleration options under review |
Section 8: Pain/Gain Share Forecast (Option C Specific)
Specific to NEC4 Option C and Option D target cost contracts. On a 50/50 pain share split, every pound of overrun costs the contractor 50p. Report this clearly every month - it's the number that actually motivates corrective action.
| Element | Value |
|---|---|
| Target Price (inc. implemented CEs) | £42,800,000 |
| Forecast Defined Cost (bottom-up EAC) | £43,400,000 |
| Forecast overrun | £600,000 |
| Contractor's share (50% first band) | 50% |
| Contractor's pain share exposure | £300,000 |
Track the pain/gain position cumulatively. Show how it's moved over the last 6 months. A shift from £200K gain share in Period 3 to £300K pain share in Period 7 demands executive attention.
Section 9: Recommendations and Actions
"Continue to monitor WP-04" is not an action. Every recommendation needs an owner, a deadline, and an expected outcome.
| # | Action | Owner | Deadline | Expected Impact |
|---|---|---|---|---|
| 1 | Deploy additional steelwork gang to WP-04 | Construction Manager | 10 Feb 2026 | Recover CPI to 0.95 within 3 periods |
| 2 | Submit CE-017 quotation with programme analysis | Commercial Manager | 28 Jan 2026 | Recover £180K time prelims |
| 3 | Escalate cladding subcontractor financial assessment | Commercial Director | 5 Feb 2026 | Mitigate £400K re-procurement risk |
| 4 | Review acceleration options for Level 3 M&E | Project Manager | 14 Feb 2026 | Recover 2 weeks of critical path float |
Worked Example: £42M Office Development, Period 7
Worked ExampleProject: £42M NEC4 Option C office development, 18-month duration. Reporting date: Period 7 (September 2025).
Data: BAC £42,000,000 | Cumulative PV £24,500,000 | Cumulative EV £23,800,000 | Cumulative AC £25,100,000 | Target Price (inc. 3 CEs) £42,800,000.
Step 1 - Headline Metrics
CV = £23.8M - £25.1M = -£1,300,000 (over budget)
SV = £23.8M - £24.5M = -£700,000 (behind programme)
CPI = £23.8M / £25.1M = 0.948
SPI = £23.8M / £24.5M = 0.971
Step 2 - Forecast Outturn
EAC (CPI-based) = £42M / 0.948 = £44,303,797
EAC (bottom-up) = £43,400,000
TCPI (to BAC) = (£42M - £23.8M) / (£42M - £25.1M) = 1.077
A TCPI of 1.077 means delivering the remaining £18.2M of work for £16.9M. Possible only with a genuine recovery programme.
Step 3 - Pain/Gain Position
Forecast Defined Cost £43,400,000 vs Target Price £42,800,000. Overrun £600,000. Contractor's share at 50%: £300,000 pain.
Step 4 - Executive Summary (Draft)
"Period 7 shows cumulative cost overrun of £1.3M (CPI 0.948) and schedule slippage of approximately 1.3 weeks (SPI 0.971). The primary cost driver is WP-04 (structural steelwork), where labour productivity is 12% below estimate. Bottom-up EAC of £43.4M represents a £600K overrun against target, equating to £300K pain share exposure. Recommended actions: deploy additional steelwork resource, submit CE-017 quotation, escalate cladding subcontractor financial risk."
For a complete 12-month walkthrough showing how these metrics evolve, see the construction EVM example.
Presenting EVM Data to Non-Technical Stakeholders
If stakeholders can't understand the report, they won't read it. Lead with three numbers:
- CPI - "For every pound we spend, we're getting 95p of value."
- SPI - "We're delivering work at 97% of the planned rate."
- EAC - "Current forecast is £43.4M against a target of £42.8M - a £600K gap."
| EVM Metric | What to Say |
|---|---|
| CPI = 0.95 | "We're getting 95p of work done for every £1 we spend" |
| SPI = 0.971 | "We're completing work at 97% of the planned rate - about 1.3 weeks behind" |
| CV = -£1.3M | "We've spent £1.3M more than the value of work completed" |
| TCPI = 1.077 | "To finish on budget, we'd need to deliver the rest at about 8% below planned cost" |
| EAC = £43.4M | "At current rates, the project will cost £43.4M - that's £600K over target" |
Gather automates data collection from site diaries, so the EV metrics are ready before the reporting deadline - not assembled the night before. Commercial teams spend time writing the narrative and planning interventions, not reconciling spreadsheets. See how it works.
Monthly EV Report Checklist
| Check | Description |
|---|---|
| Data reconciliation | PV, EV and AC figures reconciled across cost, planning and site records |
| Period alignment | All data from the same reporting period (no mixing months) |
| CPI/SPI calculated | Both cumulative and current-period indices included |
| Variance narrative | Every variance above threshold (e.g. 5%) has a written explanation |
| Forecast updated | EAC recalculated using at least two methods |
| Pain/gain updated | Current contractor's share position calculated (Option C/D) |
| Trend charts updated | S-curves and CPI/SPI trend charts reflect latest period |
| Risk register current | Top risks linked to EV metrics, financial exposure quantified |
| Actions from last month | Status update on previous period's recommended actions |
| Compensation events | All active and implemented CEs reflected in target price |
| Executive summary last | Written after all other sections are complete |
| Proofread | All figures internally consistent across sections |
Report Frequency
Monthly is standard, aligned with NEC4 assessment dates (clause 50.1) and management accounting periods. Move to weekly in three situations: during recovery periods (CPI or SPI below 0.90), when critical path activities are at risk, or in the final three months. Weekly reports should be a single page - CPI, SPI, EAC and top 3 risks only.
For the step-by-step EVM setup process, see the implementation guide. For common reporting failures, see common EVM mistakes.
.webp)
