Saved

Press the star next to a tool's name to save it.

All my tools

Earned Value Management Calculator

Use this earned value management calculator to find CPI, SPI, cost and schedule variances, the estimate at completion and TCPI from BAC, PV, EV and AC.

Restored your last values ·

Enter the total budget, the value of work planned so far, the budgeted value of work actually done so far, and what that work has actually cost. Use the same currency and the same date for all three to-date figures.

Everything is worked out in your browser. Nothing you type is sent anywhere.

–

–

Fill in the boxes and press Calculate.

See full result

An earned value management calculator measures how a project is doing against its budget and schedule. Enter the budget at completion, the planned value of work scheduled to date, the earned value of work actually done and the actual cost of that work. The calculator works out the cost and schedule performance indexes, the cost and schedule variances, a forecast of the final cost, the cost still to come and the performance needed to finish on budget.

The earned value management formulas

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

The U.S. Government Accountability Office's Cost Estimating and Assessment Guide describes planned value (PV, the budgeted cost of work scheduled), earned value (EV, the budgeted cost of work performed) and actual cost (AC, the actual cost of work performed). It gives the cost variance as EV − AC, the cost performance index as EV ÷ AC, the schedule performance index as EV ÷ PV, and the estimate at completion as AC + (BAC − EV) ÷ an efficiency index. With the cost performance index as that index, this simplifies to BAC ÷ CPI. The to-complete performance index is the budgeted work remaining divided by the money left, which for the original budget is (BAC − EV) ÷ (BAC − AC).

How to use the earned value management calculator

  1. Enter the budget at completion: the total budget for the work.
  2. Enter planned value: the budget for the work scheduled to be done by now.
  3. Enter earned value: the budget for the work actually done by now.
  4. Enter actual cost: what that work has actually cost.
  5. Press Calculate.

Worked example

A project has a budget of $100,000. By the review date, work worth $50,000 was planned, work worth $40,000 has been done, and it has cost $45,000. The CPI is 40,000 ÷ 45,000 = 0.89, so each dollar spent has produced about 89 cents of planned work, and the cost variance is −$5,000. The SPI is 40,000 ÷ 50,000 = 0.80, and the schedule variance is −$10,000 of work. If cost performance continues, the estimate at completion is 100,000 ÷ 0.889 = $112,500, so $67,500 is still to be spent. To finish on the original budget, the remaining $60,000 of work would have to be done for the remaining $55,000, a TCPI of 1.09.

Reading the indexes

The guide explains that a CPI greater than 1 means the work accomplished cost less than planned, while a CPI below 1 means it cost more than planned. A CPI of exactly 1 means cost is on plan. An SPI above 1 means more work was accomplished than planned, and an SPI below 1 means less work has been done than was scheduled by this date.

Measuring earned value

The guide gives percent complete as EV ÷ BAC, so earned value is the budget at completion times the actual percentage complete, or the planned value of the work packages that are finished. Projects often use simple rules to decide how much value a task earns: some give no credit until a task is finished, while others give half the value when a task starts and the rest when it ends. Whichever rule you use, apply it consistently so that earned value means the same thing from one review to the next.

The estimate at completion

The formula BAC ÷ CPI assumes the project will keep spending money at the same efficiency as it has so far. The guide notes that the efficiency index used to adjust the remaining work changes the forecast, and that a cumulative CPI assumes the same efficiency for the rest of the project. If the overspend so far came from a one-off problem that is now fixed, the final cost may be closer to the original budget. If the problems are getting worse, it may be higher. Many teams compare this estimate with a bottom-up estimate of the remaining work.

The to-complete performance index

The TCPI shows the cost efficiency needed on the remaining work to finish within the budget. A TCPI well above the current CPI means finishing on budget would need a big improvement, which may not be realistic; that is a signal to revisit the budget or the scope. If the TCPI is measured against an estimate at completion of BAC ÷ CPI, it works out equal to the CPI, which follows from the formulas above. The guide treats a TCPI more than 5 percentage points above the CPI as a sign the estimate is too optimistic.

Why earned value helps

Comparing spending with the budget alone can mislead. A project that has spent half its budget halfway through might be on track, or it might have done only a quarter of the work. Earned value separates the two questions, cost and progress, so that project managers can see problems early. For the money side of a project, the project cost estimator helps, and for budget changes in percent the percentage calculator.

Common mistakes

  • Comparing actual cost with planned value. Compare actual cost with earned value.
  • Using different dates. PV, EV and AC must all be measured to the same date.
  • Overstating progress. Earned value should reflect work actually finished.
  • Treating EAC as certain. It is a forecast based on past performance.

What next

Use this often? Add Earned Value to your Home screen.

Frequently asked questions

How does an earned value management calculator work?

It compares earned value with actual cost and planned value to get CPI, SPI and the variances, then forecasts the final cost.

What does a CPI of 0.89 mean?

Each dollar spent has produced about 89 cents of planned work, so the project is over budget.

How is the estimate at completion worked out?

As BAC ÷ CPI, assuming cost performance so far continues.

What is the TCPI?

The cost efficiency needed on the remaining work: (BAC − EV) ÷ (BAC − AC).

Is an SPI above 1 good?

Yes. The GAO guide treats a CPI or SPI above 1.0 as more work or lower cost than planned.

What went wrong?

We only receive the reason you pick, never what you typed into the tool.

Thanks for your feedback.

More Finance Tools