Earned value calculator
A free earned value management calculator — enter BAC, PV, EV and AC to get CV, SV, CPI, SPI, three EAC forecasts, ETC, VAC and TCPI, with every formula worked through.
- CV = EV − AC
- SV = EV − PV
- CPI = EV ÷ AC
- SPI = EV ÷ PV
- EAC = BAC ÷ CPI
- EAC = AC + (BAC − EV)
- EAC = AC + (BAC − EV) ÷ (CPI × SPI)
- ETC = EAC − AC
- VAC = BAC − EAC
- TCPI = (BAC − EV) ÷ (BAC − AC)
What earned value tells you
Earned value management compares three numbers at a point in time:
- PV (planned value): how much work, in money, the plan said should be done by now.
- EV (earned value): the budgeted value of the work that is done.
- AC (actual cost): what that work actually cost.
From these, CPI (EV ÷ AC) says how much value each unit of money is buying, and SPI (EV ÷ PV) says how much of the planned work is getting done. Below 1 is worse than plan; above 1 is better.
Which EAC to use
The estimate at completion depends on what you believe about the rest of the project:
- BAC ÷ CPI if the cost rate so far will continue (the usual assumption).
- AC + (BAC − EV) if the overrun so far was a one-off and the rest will go to plan.
- AC + (BAC − EV) ÷ (CPI × SPI) if both cost and schedule problems will keep dragging.
TCPI turns it round: the cost efficiency the remaining work must reach to finish on the original budget. A TCPI well above 1 is a sign the budget won't be met without a change.
On a real project
On the Coral Ridge Resort sample, a CPI of 0.95 means each dollar spent is buying about 95 cents of planned work. The finance lesson shows how that CPI, set against the contingency left, tells the sponsor whether the reserves can absorb the forecast overrun.
See it used on a real project: Pr6 · Plan and manage finance & budget