VanillaPM
Sign in Get started free Dashboard
Free calculator

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.

CPI
SPI
EACif the cost rate continues
VACbudget minus EAC
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)
Download as Excel (.xlsx) The spreadsheet has live formulas: change the yellow cells and it recalculates.

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