Free calculator
Earned value calculator: CPI, SPI, EAC and TCPI
Enter the budget, planned value, earned value and actual cost. The calculator returns the variances, both performance indices, the forecast cost at completion and the efficiency you need from here on.
Calculator
The formulas
| CV = EV − AC | cost variance: negative means over budget |
|---|---|
| SV = EV − PV | schedule variance, in money |
| CPI = EV / AC | value earned per unit of money spent |
| SPI = EV / PV | work done compared with work planned |
| EAC = BAC / CPI | forecast cost if efficiency stays the same |
| EAC = AC + (BAC − EV) | forecast if the rest goes to plan |
| ETC = EAC − AC | what is still to be spent |
| VAC = BAC − EAC | expected overrun or saving at the end |
| TCPI = (BAC − EV) / (BAC − AC) | efficiency needed from now on to finish on budget |
Worked example
A project has a budget of 1,000,000. By now the plan called for 400,000 of work. The team has completed work budgeted at 350,000 and has spent 420,000.
CPI is 350,000 / 420,000 = 0.83: every unit of money spent has bought 0.83 of planned work. SPI is 350,000 / 400,000 = 0.88. If cost efficiency stays at 0.83, the project ends at 1,000,000 / 0.833 = 1,200,000, which is 200,000 over. To finish on the original budget, the remaining work must be done at a TCPI of 650,000 / 580,000 = 1.12.
The earned value guide explains how to read these numbers and which EAC to use.
Without typing the numbers in
In Critova the planned value comes from the schedule and budget, earned value from the progress your team records, and actual cost from cost entries. CPI, SPI(t), EAC and TCPI update with every change, for each project and across the portfolio. See cost and earned value.
Common questions
What is a good CPI?
1.0 or above means the work costs what was planned or less. Below 0.90 usually needs a recovery plan or a new baseline.
Which EAC formula should I use?
BAC / CPI when the overrun reflects how the work is really going. AC + (BAC − EV) when the overrun was a one-off and the rest should go to plan.
Bring one schedule. See your critical path in an hour.
Free during our launch until 31 March 2027.
