Project planning

Earned Value Calculator

Enter your budget, planned value, earned value and actual cost to get CPI, SPI, cost and schedule variance, EAC, ETC, VAC and TCPI, with a plain-language status.

Inputs
Budgeted cost of work scheduled to date.
%
Fills earned value from BAC.
Cost actually spent on the work done.

Example figures shown. Use any currency, as long as all four values are in the same one.

Result–
Estimate at completion (EAC = BAC ÷ CPI) 0 –
CPI (EV ÷ AC)
–
SPI (EV ÷ PV)
–
Cost variance (EV − AC)
–
Schedule variance (EV − PV)
–
Estimate to complete (EAC − AC)
–
TCPI to finish on budget
–

Earned value management in one minute

Earned value management (EVM) compares three numbers at a status date: what you planned to have done (PV), what you have actually done, measured at budget rates (EV), and what it really cost (AC). Together they show whether a project is ahead or behind, and over or under budget.

CV = EV − AC · SV = EV − PV
CPI = EV ÷ AC · SPI = EV ÷ PV
EAC = BAC ÷ CPI · ETC = EAC − AC · VAC = BAC − EAC
TCPI = (BAC − EV) ÷ (BAC − AC)

How to read the indices

IndexAbove 1.00Below 1.00
CPIUnder budget for the work doneOver budget for the work done
SPIAhead of scheduleBehind schedule
TCPIMust work more efficiently to hit budgetCan be less efficient and still hit budget

Worked example

A AED 4.8 million project is 40% complete, so EV = 1.92 million. Planned value is 2.16 million and actual cost 2.07 million. CPI = 0.93 and SPI = 0.89: the project is over budget and behind schedule. If performance continues, EAC = 4.8 ÷ 0.93 = 5.18 million, a VAC of −0.38 million.

Frequently asked questions

Where do PV and EV come from in Primavera P6?

P6 calculates planned value from the baseline and earned value from activity % complete and budgeted cost. Export them from the Earned Value columns or the tracking layout at your data date.

Which EAC formula should I use?

BAC ÷ CPI assumes current cost performance continues, which is the most common choice. If the overspend was a one-off, AC + (BAC − EV) is more realistic.

Is SPI reliable near the end of a project?

No. SPI always returns to 1.00 at completion, even for late projects, because EV eventually equals PV. Use the time-based schedule from your programme for late-stage forecasting.