Free tool

Earned Value Formula: Worked Example in ₹ Crore and Programme Roll-Up

The earned value formulas work on one project, but at programme level the order of operations changes the answer: summing before dividing gives a cost performance index (CPI) of 1.00 where averaging gives 1.058 for the same three projects. What follows is a worked example in ₹ crore with a budget and progress taken from Indian projects, the three-project roll-up that shows the error, and a check on a government project list where the choice of baseline alone moved the headline index. Each term is defined where it first appears, so the page works as a formula sheet you can return to. The core formulas come from the US National Science Foundation's earned value gold card; the Indian figures come from the Ministry of Statistics and Programme Implementation (MoSPI) Flash Report for April 2026.

₹ crore

The total approved budget.

Share of the work scheduled to be done by the status date.

Share of the work actually done at the status date.

₹ crore

The money spent so far.

Cost performance index (CPI)

0.875

Planned value (PV)
₹600.00
Earned value (EV)
₹560.00
Cost variance (CV)
-₹80.00
Schedule variance (SV)
-₹40.00
Schedule performance index (SPI)
0.933
Estimate at completion (EAC)
₹914.29
Estimate to complete (ETC)
₹274.29
Variance at completion (VAC)
-₹114.29
To-complete performance index (TCPI)
1.5

Assumptions

  • PV is planned percent complete × BAC; EV is actual percent complete × BAC.
  • Spend never enters EV: it measures value of work done at budgeted rates, whatever it cost.
  • EAC uses BAC ÷ CPI, which assumes the cost efficiency achieved so far continues.
  • TCPI is the BAC-based form: work remaining (BAC − EV) divided by cost remaining (BAC − AC).

By Sanjeev Kumar, Founder · Updated 24 Oct 2026

In brief

Programmes sum project totals before dividing, never averaging. Averaged, the programme looks under budget when it is exactly on budget: the CPI is 1.058 where summing gives 1.00 for the same three projects. Dividing total earned value by total spend instead removes the error.

Worked example at the defaults

With Budget at completion (BAC) at 800₹ crore, Planned percent complete at 75%, Actual percent complete at 70%, Actual cost to date (AC) at 640₹ crore:

Planned value (PV)
₹600.00
Earned value (EV)
₹560.00
Cost variance (CV)
-₹80.00
Schedule variance (SV)
-₹40.00
Cost performance index (CPI)
0.875
Schedule performance index (SPI)
0.933
Estimate at completion (EAC)
₹914.29
Estimate to complete (ETC)
₹274.29
Variance at completion (VAC)
-₹114.29
To-complete performance index (TCPI)
1.5

Multiply budget by percent complete to get EV, then compare it with spend. CPI is EV ÷ AC and SPI is EV ÷ PV. The core formulas follow the NSF earned value gold card: CV, SV, CPI, SPI, EAC = BAC ÷ CPI, VAC and EAC = AC + ETC. The BAC-based TCPI is our working from standard earned value practice, where the card's own TCPI divides work remaining by (EAC − AC).

Key takeaways

  • The earned value formula needs three numbers at a status date (planned value, earned value and actual cost) and a budget at completion. With a ₹800 crore budget, 70% done and ₹640 crore spent, CPI is 0.875 and the cost forecast is ₹914.29 crore.
  • For a programme, divide total earned value by total actual cost for CPI, and by total planned value for the schedule performance index (SPI). In our three-project example, averaging the project CPIs gives 1.058 while the true programme CPI is 1.00.
  • Forecast each project's final cost separately and add the results (₹810.6 crore in our example), because one project's overrun does not shrink when another underspends.
  • Report CPI against both the original and the revised budget. On the 1,981 MoSPI projects we calculated 1.04 against original costs and 1.28 against revised costs.

What does the earned value formula work out, and what do you enter?

The earned value formula compares three ₹ amounts at a status date: planned value (PV), the budgeted value of the work scheduled by now; earned value (EV), the budgeted value of the work actually done; and actual cost (AC), the money spent. Add the budget at completion (BAC), the total approved budget. Everything else is arithmetic on these four.

PV is planned percent complete × BAC. EV is actual percent complete × BAC. Spend never enters EV: it measures value of work done at budgeted rates, whatever it cost.

Input
Budget at completion (BAC)
Unit
₹ crore
Default
800
Why this default
The median original cost of all 1,981 projects in the MoSPI April 2026 table is ₹791 crore (our calculation, method below)
Input
Planned percent complete
Unit
%
Default
75
Why this default
Our demonstration value
Input
Actual percent complete
Unit
%
Default
70
Why this default
The median physical progress of all 1,981 projects is 70% (our calculation)
Input
Actual cost to date (AC)
Unit
₹ crore
Default
640
Why this default
Our demonstration value, 80% of BAC

How do you calculate earned value, cost variance and CPI in ₹ crore?

Multiply budget by percent complete to get EV, then compare it with spend. With the defaults above, EV is ₹560 crore against ₹640 crore spent, so the CPI is 0.875: each rupee spent has bought 87.5 paise of budgeted work. The core formulas follow the NSF earned value gold card (published 15 October 2024, updated 5 June 2026).

The gold card gives CV, SV, CPI, SPI, EAC = BAC ÷ CPI, VAC and EAC = AC + ETC. The BAC-based TCPI above is our working from standard earned value practice: work remaining (BAC − EV) divided by cost remaining (BAC − AC), where the card's own TCPI divides work remaining by (EAC − AC).

Result
PV
Formula
planned % × BAC
Working (₹ crore)
75% × 800
Value
600
Result
EV
Formula
actual % × BAC
Working (₹ crore)
70% × 800
Value
560
Result
Cost variance (CV)
Formula
EV − AC
Working (₹ crore)
560 − 640
Value
−80
Result
Schedule variance (SV)
Formula
EV − PV
Working (₹ crore)
560 − 600
Value
−40
Result
Cost performance index (CPI)
Formula
EV ÷ AC
Working (₹ crore)
560 ÷ 640
Value
0.875
Result
Schedule performance index (SPI)
Formula
EV ÷ PV
Working (₹ crore)
560 ÷ 600
Value
0.933
Result
Estimate at completion (EAC)
Formula
BAC ÷ CPI
Working (₹ crore)
800 ÷ 0.875
Value
914.29
Result
Estimate to complete (ETC)
Formula
EAC − AC
Working (₹ crore)
914.29 − 640
Value
274.29
Result
Variance at completion (VAC)
Formula
BAC − EAC
Working (₹ crore)
800 − 914.29
Value
−114.29
Result
To-complete performance index (TCPI)
Formula
(BAC − EV) ÷ (BAC − AC)
Working (₹ crore)
240 ÷ 160
Value
1.50

Which estimate at completion formula should you use?

Use BAC ÷ CPI as your default forecast, because it assumes the cost efficiency you have achieved so far continues. Choose another formula only when you can state a different assumption about the remaining work. Each formula below is EAC = AC + ETC, the card's definition, with a different ETC. The card writes the CPI-based and composite forms with work remaining, which we read as BAC − EV; the one-off variant AC + (BAC − EV) is standard earned value practice, shown here as our working. All figures are on the defaults.

In our judgement, the "one-off" row is the one people abuse. Use it only if you can name the cause and show it has ended. Where risks are logged, add their exposure as the last row does; our guide to programme risk management covers how programmes size that exposure.

Assumption about remaining work
Cost efficiency to date continues
EAC formula
AC + (BAC − EV) ÷ CPI, the same as BAC ÷ CPI
EAC (₹ crore)
914.29
Assumption about remaining work
Overrun so far was a one-off; the rest costs what it was budgeted
EAC formula
AC + (BAC − EV)
EAC (₹ crore)
880.00
Assumption about remaining work
Cost and schedule drag both continue
EAC formula
AC + (BAC − EV) ÷ (CPI × SPI)
EAC (₹ crore)
933.88
Assumption about remaining work
You have re-estimated the remaining work bottom-up
EAC formula
AC + new ETC
EAC (₹ crore)
your estimate
Assumption about remaining work
Known risks are added
EAC formula
AC + ETC + risk exposure
EAC (₹ crore)
your estimate

How do you read CPI, SPI and TCPI without fooling yourself?

A CPI or SPI of 1.00 means on plan, below 1.00 means behind or over, above 1.00 means ahead or under. The traps are in the units and in the late stages of a job.

  • CV and SV are in rupees, not time. An SV of −₹40 crore means ₹40 crore of planned work is not done. Dividing it by the plan's spend per month gives a rough months-behind figure, but only where the plan is close to a straight line.
  • SPI drifts to 1.00 at the end. When all work is complete, EV equals BAC and PV equals BAC, so SPI reads 1.00 even for a project that finished late.
  • TCPI is a credibility test. Our example needs 1.50 on the remaining work to hit the original budget, against 0.875 achieved so far. When TCPI sits far above the CPI you have delivered, the original budget is a hope, not a forecast: reforecast.
  • Set thresholds in advance. Which CPI or SPI triggers escalation is a governance decision; write it into the programme management plan and the portfolio performance scorecard so nobody argues about it after the number turns red.

How do you roll up earned value across a programme's projects?

Sum the EV, PV and AC of the projects first, then divide. The programme CPI is total EV ÷ total AC, and the programme SPI is total EV ÷ total PV. These are our derivations: the card's CPI and SPI definitions applied to programme totals. The figures below are illustrative, in ₹ crore.

ProjectBACPVEVACCPISPICVEAC (BAC ÷ CPI)
A4002001801601.1250.900+20355.6
B3001501201500.8000.800−30375.0
C1004050401.2501.250+1080.0
Programme8003903503501.0000.8970810.6

Three things follow:

  1. Averaging misleads. The mean of the three CPIs is 1.058 and the mean of the SPIs is 0.983, which tell the sponsor the programme is under budget and nearly on schedule. The true figures are 1.00 and 0.897.
  2. Totals hide the problem project. Programme CV is zero, but project B is ₹30 crore over on work done, offset by A and C.
  3. Forecast per project, then add. Programme BAC ÷ programme CPI gives ₹800 crore. The sum of project forecasts gives ₹810.6 crore, so the variance at completion is −₹10.6 crore. B keeps costing 1.25 times its budget whatever A and C do.

What does earned value show when applied to 1,981 Indian government projects?

Applied to the 1,981 ongoing central-sector projects in the April 2026 MoSPI list, earned value gives a portfolio CPI of 1.04 on original costs and 1.28 on revised costs, so the choice of baseline changes the headline. We worked from Table 6 of the MoSPI Flash Report for April 2026, which covers central-sector infrastructure projects costing ₹150 crore and above. MoSPI does not publish a CPI; the figures below are ours.

How we calculated it (October 2026). This is a snapshot of the April 2026 report, the issue analysed, and later issues will differ. We extracted all 1,981 rows. Our totals match the report's headline: ₹37,12,662 crore original cost, ₹42,78,402 crore revised cost, ₹20,36,107 crore expenditure. For each project, EV = reported physical progress % × cost and AC = cumulative expenditure. The portfolio CPIs, the median cost and the median progress use all 1,981 projects. The median project CPI, the mean of project CPIs and the share below 1.00 use the 1,638 projects with both spend and progress above zero; the other 343 are excluded from those three figures. The median spend share uses the projects reporting spend above zero. The progress figures are reported to MoSPI by the ministries and implementing agencies, so these figures test method, not individual projects.

What this tells a programme controller:

  • Never average indices. A handful of projects with almost no spend push the mean CPI to 79. Weighted by money, the same projects give 1.04.
  • Re-baselining flatters. Moving from original to revised costs lifts the portfolio CPI from 1.04 to 1.28 without any work being done. Take Guwahati Airport's new terminal: ₹1,712 crore original, ₹2,520 crore revised, ₹2,627.39 crore spent at 98% progress. Against the original budget its CPI is 0.64 (CV −₹949.63 crore); against the revised budget it is 0.94 (CV −₹157.79 crore), with an EAC near ₹2,681 crore.
  • A CPI above 1.00 is not always efficiency. Median spend (43%) trails median progress (70%). In our reading, that points to payments and expenditure booking lagging physical work, so check when spend is recorded before you celebrate a high CPI.

Our recommendation: report CPI against both the original approved baseline and the baseline after approved changes, and let the programme management plan say who may approve a change.

Measure
Portfolio CPI, EV on original cost (ΣEV ₹21.16 lakh crore ÷ ΣAC ₹20.36 lakh crore), all 1,981 projects
Result
1.04
Measure
Portfolio CPI, EV on revised cost (ΣEV ₹26.06 lakh crore), all 1,981 projects
Result
1.28
Measure
Simple mean of project CPIs, 1,638 projects (original cost)
Result
79
Measure
Median project CPI, 1,638 projects, original cost
Result
1.38
Measure
Projects with CPI below 1.00, original cost
Result
26% of 1,638
Measure
Projects whose revised cost exceeds original
Result
542 of 1,981
Measure
Median spend as a share of revised cost, projects reporting spend
Result
43%
Measure
Median physical progress, all 1,981 projects
Result
70%

Which course covers programme risk, stakeholders and benefits?

At programme level, cost control is one measure among several, and the failures that sink programmes are mostly outside the EV sheet: benefits that were never owned, risks shared across projects, stakeholders who moved. That is the ground our Program Management Essentials course covers: programme risk, stakeholder engagement, benefits planning and strategic alignment, across 10 modules, 12 weeks and 15+ hours of guided learning, with ready-to-use templates. As of October 2026 it is US$99 per enrolment, priced in US dollars; pricing varies by market.

We have mentored or trained 6,000+ professionals. If you are deciding whether to stay on the project path or take a programme seat, our free discovery consultation is available before enrolment through support@augmentconsultancy.com.

Keep reading

Frequently asked

Enter the inputs in B1 to B4 (BAC, planned percent, actual percent, AC), typing percentages as 75% or 0.75, then type these formulas: B5 PV =B1B2; B6 EV =B1B3; B7 CV =B6-B4; B8 SV =B6-B5; B9 CPI =B6/B4; B10 SPI =B6/B5; B11 EAC =B1/B9; B12 ETC =B11-B4; B13 VAC =B1-B11; B14 TCPI =(B1-B6)/(B1-B4). For a programme, add one row per project and divide the column totals, never the average of the ratios.

Once all work is done, EV equals BAC, and after the planned finish date PV also equals BAC, so SPI is EV ÷ PV = 1.00 whatever the actual finish date. SPI is reliable mid-project and weak at the end. For late-stage schedule, compare actual and planned milestone dates directly.
You can still work out cost variance and CPI, because they need only EV and AC. Schedule variance and SPI need PV, which means a time-phased budget, so build one before you report schedule performance. Without it, an SPI is a guess presented as a number.
Our recommendation is to report CPI against both: the original approved baseline to show total drift, and the baseline after approved changes to show current performance. Moving from original to revised costs lifts the portfolio CPI from 1.04 to 1.28 without any work being done, so the choice of baseline changes the headline. Let the programme management plan say who may approve a change.

Sources

  1. 1.NSF Earned Value Management Gold Card, National Science Foundation, published 15 October 2024, last updated 5 June 2026
  2. 2.MoSPI Flash Report, April 2026 (issue 486), Ministry of Statistics and Programme Implementation, April 2026
  3. 3.Program Management Essentials, Augment Consultancy, October 2026

Talk to a certification expert

Share your details and the program you are interested in.

Augment Consultancy.

Helping professionals worldwide achieve PgMP® and PfMP® certification through expert mentoring, practical learning, and proven success.

© 2026 Augment Consultancy

Powered by PageLens.ai

Talk to a certification expert.