Earned Value Management Calculator
Measure project cost and schedule performance from task-level planned progress, actual progress, budgets, and costs, then forecast the likely completion cost.
Task inputs
Enter one row per project task. Percentages use 0 – 100; money uses U.S. dollars.
EVM report
Planned, earned, and actual value
Compare what the project planned to accomplish by now, what it has actually earned, and what it has actually spent.
Planned value is $1,475.00, earned value is $1,300.00, and actual cost is $1,700.00.
Task detail
| Task | Scheduled progress | Actual progress | Budget | Costs | Planned value | Earned value |
|---|---|---|---|---|---|---|
| Task #1 | 100.00% | 80.00% | $1,000.00 | $900.00 | $1,000.00 | $800.00 |
| Task #2 | 75.00% | 75.00% | $500.00 | $550.00 | $375.00 | $375.00 |
| Task #3 | 20.00% | 25.00% | $500.00 | $250.00 | $100.00 | $125.00 |
How to use this earned value management calculator
What this calculator does
This calculator turns task-level schedule, progress, budget, and spending data into an earned value management snapshot. It estimates planned value (PV), earned value (EV), actual cost (AC), cost performance index (CPI), schedule performance index (SPI), two variance ratios, estimate to complete (ETC), and estimate at completion (EAC). The purpose is to show whether a project is producing the planned amount of value for the money and time consumed so far and to project a completion cost if the current cost-efficiency trend continues. It is a project-control aid, not a substitute for a complete integrated schedule, risk analysis, approved baseline, or formal EVMS governance. The U.S. Department of Energy describes EVM as an approach that integrates scope, cost, and schedule and supports objective assessment of current and future performance in its earned value management overview.
When to use it
Use this tool for a milestone review, a monthly project status meeting, a recovery-plan check, or a quick health review before escalating a cost or schedule concern. It is especially useful when several tasks have different budgets and completion percentages, making the overall picture difficult to judge by inspection.
How to calculate
- The calculator opens with a complete three-task demonstration and an immediately available XLSX export. Replace the example task values with your own current project data.
- For each task, enter Scheduled progress, Actual progress, Budget, and Costs. Use Add task for additional work items and Remove to delete a task row.
- Read the live EVM report. CPI focuses on cost efficiency; SPI focuses on schedule efficiency. Compare PV, EV, and AC in the chart and inspect the task table to identify which rows drive the totals.
- Select Download Excel to create a fresh workbook from the current validated model. Reset clears the demonstration and all task data. After Reset, export is disabled until at least one complete valid task is entered again.
Input guide
Scheduled progress is a required percentage from 0 to 100 showing how much of a task should be complete at the status date. Enter a plain decimal such as 75 for 75%. Higher scheduled progress raises that task's planned value. A common mistake is entering 0.75 when you mean 75%; this calculator interprets 0.75 as 0.75%.
Actual progress is a required percentage from 0 to 100 showing how much work has actually been completed. A realistic example is 80 for 80%. Higher actual progress raises earned value and generally improves CPI and SPI if spending and planned value are unchanged. Use a completion measure tied to accomplished scope rather than time elapsed.
Budget is the required nonnegative budget at completion for the task, entered in U.S. dollars. A value such as 1000 means $1,000.00. Budget drives both PV and EV because each is a progress percentage multiplied by budget. Do not enter spending to date here; that belongs in Costs.
Costs is the required nonnegative actual cost spent on the task to date, in U.S. dollars. A value such as 900 means $900.00. Higher costs increase AC and reduce CPI when earned value is unchanged. Costs may exceed a task budget; that can be exactly the condition EVM is intended to surface.
Add task appends an empty task row. Each added row must contain all four values before the overall model is valid. Remove deletes its task row; the calculator always keeps at least one row available for entry.
Output guide
Tasks is the live count of task rows included in the current valid model. Total budget is the sum of task budgets. Planned value (PV) is the budgeted value that should have been accomplished by now. Earned value (EV) is the budgeted value of work actually completed. Actual cost (AC) is spending to date. These three dollar measures form the foundation of the report and the comparison chart.
Cost performance index (CPI) equals EV ÷ AC. Above 1 indicates more budgeted value has been earned than money spent; below 1 indicates cost inefficiency. Schedule performance index (SPI) equals EV ÷ PV. Above 1 means earned value is ahead of planned value; below 1 means it is behind. A zero denominator makes the associated index unavailable rather than infinite.
Cost variance here is (EV – AC) ÷ EV, displayed as a percentage. Positive is favorable; negative indicates spending exceeds earned value relative to EV. Schedule variance is (EV – PV) ÷ PV; positive means earned value exceeds planned value. These are ratio conventions, not dollar variances.
Estimate to complete (ETC) forecasts the remaining cost as (total budget – EV) ÷ CPI, assuming the current cost efficiency continues. Estimate at completion (EAC) adds AC + ETC and is the primary forecast. If CPI is unavailable or zero, the calculator withholds ETC and EAC rather than inventing a finite value. The Task detail table shows Task, Scheduled progress, Actual progress, Budget, Costs, Planned value, and Earned value so you can trace project totals to their components.
Worked example
The opening example uses three tasks: Task 1 is scheduled at 100% but actually 80% complete with a $1,000 budget and $900 cost; Task 2 is 75% scheduled and 75% actual with a $500 budget and $550 cost; Task 3 is 20% scheduled and 25% actual with a $500 budget and $250 cost. PV is $1,475, EV is $1,300, and AC is $1,700. Therefore CPI = 1,300 ÷ 1,700 = 0.7647 and SPI = 1,300 ÷ 1,475 = 0.8814. With a $2,000 total budget, ETC = (2,000 – 1,300) ÷ 0.7647 = $915.38, and EAC = 1,700 + 915.38 = $2,615.38. The negative cost and schedule variance ratios confirm that this example is both over budget and behind schedule at the status point.
Learn more
For a fuller explanation of baselines, analysis, forecasting, and implementation practices, see the Department of Energy's EVMS implementation guidance. For program and project-control context, NASA publishes project planning and control guidance, including EVM handbooks.
How the model works
EVM separates three questions that are easy to blur together: how much work should have been done, how much value was actually earned, and how much money was actually spent. At task level, PV = scheduled progress × budget and EV = actual progress × budget. Project PV, EV, AC, and budget are sums across tasks.
Because the forecast uses CPI, it assumes the cost efficiency observed to date is a reasonable basis for the remaining work. That assumption can be weak when the remaining scope differs materially from completed scope, when a one-time event distorted costs, or when a recovery plan is expected to change performance. Treat EAC as a trend-based estimate rather than a committed forecast in those situations.
Interpretation and common mistakes
- CPI or SPI near 1.00: performance is close to the baseline relationship. Consider materiality and trend before reacting to small deviations.
- CPI below 1.00: the project is earning less budgeted value per dollar spent. Check whether the issue is concentrated in one task or widespread.
- SPI below 1.00: earned value trails planned value. This signals schedule-performance pressure but does not replace critical-path analysis.
- Progress quality matters: optimistic or inconsistent completion percentages can make EV look healthier than the underlying work.
- Baseline discipline matters: PV only carries meaning when scheduled progress and budgets come from a coherent performance baseline.
- Do not confuse dollar and ratio variances: this calculator reports the percentage conventions described above; many formal EVM reports also use dollar CV = EV – AC and dollar SV = EV – PV.