Earned Value Management (EVM) Calculator

This simplified task-level earned value management calculator turns user-entered budget-weighted progress percentages into a compact performance report. Those percentages are a publisher-defined input mapping, not an approved EVMS progress-measurement method. For each task, enter scheduled progress, actual progress, budget, and actual cost. The calculator totals planned value (PV), earned value (EV), actual cost (AC), cost performance index (CPI), schedule performance index (SPI), variance percentages, and estimate at completion (EAC). It is designed for project controls, construction, engineering, software delivery, government contracting, and any project where scope, schedule, and cost must be reviewed together.

This page focuses on EVM math, not ordinary profitability. If you need to understand whether a product sale is profitable, use the gross margin calculator. If you need to model the revenue level where a business covers its costs, use the break-even calculator. If you want to see how core operations perform after operating expenses, use the operating margin calculator. EVM answers a different question: is the project earning planned budget value at the pace and cost expected?

How the calculator reads each task

Each task row has four numbers. Scheduled progress is the percent that should be complete at the status date. Actual progress is the percent actually complete at that same date. Budget is the approved budget for the task. Actual cost is the cost recorded for that task so far. The calculation converts percentages into decimals by dividing by 100, multiplies them by budget, and accumulates the totals.

The form requires at least one task and rejects negative budgets, negative costs, and progress below 0 or above 100. It also rejects reports where total budget, planned value, earned value, or actual cost is zero or less, because CPI, SPI, and EAC would not be meaningful.

Formula

For each task:

$\text{planned value} = \frac{\text{scheduled progress}}{100} \times \text{budget}$

$\text{earned value} = \frac{\text{actual progress}}{100} \times \text{budget}$

Across all tasks:

$\text{actual cost} = \text{sum of recorded task costs}$

$\text{CPI} = \frac{\text{EV}}{\text{AC}}$

$\text{SPI} = \frac{\text{EV}}{\text{PV}}$

Standard EVM dollar variances are:

$\text{CV} = \text{EV} - \text{AC}$

$\text{SV} = \text{EV} - \text{PV}$

This calculator displays normalized variance percentages:

$\text{cost variance percentage} = \frac{\text{EV} - \text{AC}}{\text{EV}} \times 100\%$

$\text{schedule variance percentage} = \frac{\text{EV} - \text{PV}}{\text{PV}} \times 100\%$

Estimate at completion is:

$\text{EAC} = \text{AC} + \frac{\text{total budget} - \text{EV}}{\text{CPI}}$

Example: calculating EVM project indicators

Use the default task list:

Task 1 has PV of $1,000 and EV of $800. Task 2 has PV of $375 and EV of $375. Task 3 has PV of $100 and EV of $125. Totals are therefore PV $1,475, EV $1,300, AC $1,700, and total budget $2,000.

The cost performance index is:

$\text{CPI} = \frac{\$1{,}300}{\$1{,}700} = 0.7647$

The schedule performance index is:

$\text{SPI} = \frac{\$1{,}300}{\$1{,}475} = 0.8814$

The standard dollar cost variance is EV minus AC, or negative $400. The standard dollar schedule variance is EV minus PV, or negative $175. The calculator displays percentages: negative $400 divided by EV equals about negative 30.77%, and negative $175 divided by PV equals about negative 11.86%.

The estimate to complete is unfinished budget divided by CPI:

$\text{estimate to complete} = \frac{\$2{,}000 - \$1{,}300}{0.7647} = \$915.38$

Add actual cost of $1,700 and the result is an estimate at completion of $2,615.38. Because the approved budget is $2,000, the forecast over budget amount is $615.38.

Interpretation

CPI and SPI are efficiency ratios. A CPI of 1 means the project has earned exactly one dollar of budgeted work for each dollar spent. A CPI below 1 means cost efficiency is weak; the default example earns about $0.76 of budgeted value for each $1.00 spent. A CPI above 1 means cost efficiency is favorable. SPI works the same way for schedule value. An SPI below 1 means the project has earned less budgeted work than the plan expected by the status date.

EAC is a forecast, not a promise. The calculator assumes current cost efficiency continues for the remaining budget. That is reasonable when overruns come from recurring labor productivity, estimating errors, or repeated rework. It can be too pessimistic when a one-time purchase hit the ledger early, or too optimistic when future work is more complex than completed work.

Caveats

EVM depends on disciplined progress measurement. A task that is “80 percent done” should have an objective rule: installed quantities, accepted deliverables, completed story points, inspected milestones, or another auditable basis. If progress is guessed, EV becomes a guess too. Also align dates. Costs through Friday should not be compared with progress reported from the previous Tuesday.

The calculator reports task earned value in a group so you can see which rows drive the totals. When a project has many work packages, review the outliers instead of reacting only to the project-level EAC. One delayed or overrun task may be recoverable, while a broad CPI decline across many tasks usually calls for a plan change.

Sources

• U.S. Department of Energy, DOE EVMS Gold Card, version 2019-07-10 — official definitions and formulas for PV, EV, AC, BAC, CV%, SV%, CPI, SPI, work remaining, and CPI-based EAC.

The per-task percentage multiplication is this calculator’s simplified input method. It should not be represented as a DOE-prescribed progress measurement technique.