EVM Calculator

What this calculator estimates

Earned value management connects scope, schedule, and cost in one measurement system. Instead of asking only how much money has been spent, it asks how much budgeted work has actually been completed and how much work should have been completed by the same status date. The calculator aggregates task-level data into the three core EVM measures: planned value (PV), earned value (EV), and actual cost (AC). From those values it calculates performance indices, variances, and a forecast of the final project cost.

The model is useful for a project review, milestone review, or recurring reporting date. All progress percentages should describe the same status date. The analysis is only as reliable as the underlying baseline, progress measurement method, and cost data. For formal implementation guidance, consult the Project Management Institute’s EVM standard and the NASA earned value management resources.

Field-by-field input guide

• Task name is optional but strongly recommended. Use a work package, deliverable, or control-account name that can be reconciled to your plan. Blank names are labeled automatically in reports and exports.
• Scheduled progress is the percentage of the task that should be complete at the status date. It is required for schedule analysis and should remain between 0% and 100%. A higher scheduled percentage increases PV and can reduce SPI if actual progress does not rise with it.
• Actual progress is the objectively measured completion percentage. It drives EV. A higher value increases earned value, improves both CPI and SPI, and usually lowers the forecast remaining cost. Avoid subjective “almost done” estimates; use weighted milestones, units complete, or another repeatable rule.
• Budget is the approved total budget for the task, not the amount planned to be spent by today. It is required to calculate PV and EV. Increasing a task budget raises the project’s budget at completion and gives that task more weight in every aggregate metric.
• Costs to date is the actual cost recorded for the task through the same status date. It drives AC and CPI. Include accrued costs when your reporting rules require them; omitting committed or unposted costs can make cost performance look temporarily better than reality.

Add as many tasks as needed. Removing a task immediately removes its values from totals, charts, the detail table, and the Excel workbook. Reset clears the example and leaves one neutral row so you can start a fresh project.

Core formulas

PV = scheduled progress × task budget

EV = actual progress × task budget

CPI = EV ÷ AC   |   SPI = EV ÷ PV

ETC = (BAC − EV) ÷ CPI   |   EAC = AC + ETC

The forecast assumes future cost efficiency will resemble current CPI. That is a transparent, common forecasting assumption, but it is not a guarantee. If the remaining work will be performed under materially different conditions, a bottom-up estimate to complete may be more appropriate.

How to read every result

Budget at completion (BAC) is the sum of all task budgets. PV is the budgeted value that should have been completed. EV is the budgeted value actually completed. AC is what the completed work has cost. When EV is below PV, the project is behind its baseline schedule. When AC is above EV, the project has spent more than the budgeted value of the work produced.

CPI measures cost efficiency. A CPI above 1.00 indicates favorable cost performance, below 1.00 indicates unfavorable performance, and exactly 1.00 means one dollar of budgeted value is being earned for each dollar spent. SPI uses the same interpretation for schedule efficiency. Zero or unavailable indices usually mean the denominator is zero, so there is not yet enough data for a meaningful ratio.

Cost variance (CV) is EV minus AC. Positive is favorable; negative is unfavorable. The displayed cost variance percentage follows the reference convention of dividing CV by EV. Schedule variance (SV) is EV minus PV, with its percentage divided by PV. These amounts show the scale of the gap, while CPI and SPI show proportional efficiency.

Estimate to complete (ETC) is the forecast cost of the remaining budgeted work. Estimate at completion (EAC) adds ETC to actual cost and is the primary forecast shown at the top. The difference between BAC and EAC is the expected budget surplus or overrun. A negative forecast variance means the project is expected to exceed its approved baseline.

Charts and task table

The budget allocation donut shows which tasks dominate the baseline. When more than five budget categories exist, the smallest categories are grouped into “Other” so the chart remains legible. A task with a large budget share deserves proportionally stronger progress validation because even a modest variance can materially alter project-level CPI, SPI, and EAC.

The performance bar chart compares PV, EV, and AC using the same currency scale. EV below PV signals schedule pressure. AC above EV signals cost pressure. The strongest condition is EV at or above PV while AC remains at or below EV. The task table provides the audit trail: each row contains the inputs and task-level PV, EV, CV, and SV; the footer cross-foots to the project totals.

Assumption changes and common mistakes

Higher actual progress increases EV and generally improves both indices. Higher costs reduce CPI and raise EAC. Raising scheduled progress without changing actual progress reduces SPI. Increasing a task budget can increase both PV and EV, so the effect depends on the task’s scheduled and actual percentages. Always compare scenarios using the same status date and the same progress-measurement rules.

Common mistakes include mixing reporting dates, treating money spent as progress achieved, entering the planned-to-date amount as the total task budget, excluding accruals from AC, and using subjective completion percentages. EVM also cannot replace scope control: if the baseline no longer represents approved work, re-baselining decisions must be governed separately. The U.S. Department of Energy EVMS implementation guidance discusses system discipline, while the GAO Cost Estimating and Assessment Guide provides broader context for credible cost baselines and forecasts.

This calculator is an analytical aid, not personalized financial, legal, accounting, or contractual advice. Apply your organization’s reporting policy and the governing project-control standard.