πŸ“‹ Earned Value Calculator

Is the project on budget and on schedule?

-

Project health: schedule and cost indices

Estimates for planning only, not financial advice.

Earned value management judges a project by what was accomplished, not what was spent. With a $500,000 budget, $200,000 of planned value, $180,000 of earned value, and $210,000 of actual cost, the project is behind schedule (SPI 0.90) and over budget (CPI 0.86). The forecast completion cost is $583,333, which is $83,333 over budget. Two ratios saw the overrun coming long before the invoices piled up.

How to Use This Calculator

Enter the budget at completion and the three status-date figures: planned value, earned value, and actual cost. The calculator returns the schedule and cost indices, both variances, the completion forecast, and the efficiency required to still meet the budget.

1

Enter the total approved budget (BAC) for the project or phase.

2

Enter planned value (what should be done), earned value (what is done, in budget dollars), and actual cost (what was spent).

3

Read SPI and CPI first, then the forecast. Act on CPI below 0.90 immediately; recovery gets harder every week.

The Core Formulas

SPI = EV / PV (schedule: above 1 is ahead) CPI = EV / AC (cost: above 1 is under budget) EAC = BAC / CPI (forecast total cost) VAC = BAC - EAC (expected over/under run)

Earned value is the budgeted cost of work actually performed, which is why it bridges schedule and cost in one number. Planned value is where the schedule said you would be; actual cost is where the spending says you are. The indices divide accomplishment by expectation, so 1.0 is always par and the direction of the miss is instantly readable.

Worked Example

BAC $500,000, PV $200,000, EV $180,000, AC $210,000. SPI = 180,000 / 200,000 = 0.90: 10 percent behind schedule. CPI = 180,000 / 210,000 = 0.86: getting 86 cents of value per dollar spent. Cost variance = -$30,000; schedule variance = -$20,000. EAC = 500,000 / 0.86 = $583,333; the project will overrun by $83,333 if efficiency does not improve. TCPI = (500,000 - 180,000) / (500,000 - 210,000) = 1.10: the team must perform at 110 percent efficiency for the rest of the project just to meet the original budget.

Reading the Indices

PatternMeaning
SPI < 1, CPI < 1Behind and over budget: trouble
SPI < 1, CPI > 1Slow but efficient: usually recoverable
SPI > 1, CPI < 1Fast but expensive: crashing with overtime
Both near 1.0On track, keep monitoring

Why EVM Beats Percent Complete

Teams reporting "90 percent complete" for months are measuring effort or optimism, not value. Earned value forces the question: what budgeted work is actually done and accepted? It also separates the two failure modes cleanly. A project can be on schedule but over budget, or under budget but late, and each needs a different fix: efficiency coaching for cost problems, scope or resource changes for schedule problems. Percent complete conflates them; EVM distinguishes them.

Common Mistakes

Measuring earned value by costs incurred instead of work accomplished defeats the method; EV must reflect deliverables. Updating the baseline every time the forecast slips hides the variance the system exists to reveal; re-baseline rarely and formally. And ignoring TCPI wastes the most actionable number: it tells the team exactly what efficiency the remaining work demands. For the business case behind the project, our ROI calculator and payback period calculator keep the investment logic honest.

Lightweight EVM for Small Projects

Full EVM suits hundred-million-dollar programs, but its logic scales down beautifully. For a $50,000 website project, define five milestones worth $10,000 each of budgeted value. When three milestones are accepted and $35,000 is spent, EV is $30,000, PV depends on the schedule date, and CPI is 0.86, the same math, the same early warning, none of the bureaucracy. The method is the ratios; the paperwork is optional.

The key adaptation is milestone discipline. Small projects fail at EVM when "percent complete" is guessed, so tie earned value to binary gates: a milestone is either accepted by the client or it earns zero. The 0/100 rule feels harsh on week three and looks brilliant on week ten, when it prevents the classic "90 percent done for two months" stall that kills small-project margins.

Freelancers and agencies can run this on a single spreadsheet row per project per week. Five minutes of updates buys the same foresight that billion-dollar programs pay consultants to produce: which projects are drifting, by how much, and what the final cost will be. The projects that need it most are exactly the ones that claim they are too small for it.

EVM Reporting That Gets Read

EVM data dies in 40-page reports nobody opens. The format that works is one page: SPI and CPI as big numbers with red-green indicators, a two-line forecast of final cost and date, and three bullet actions for anything below 0.95. Executives read it in ninety seconds and ask the right questions, which is the entire purpose of the system.

Pair the numbers with a short narrative explaining the why behind any variance. "CPI 0.86 due to overtime covering a supplier delay; recovery plan cuts overtime next month" turns a scary number into a managed situation. Numbers without narrative invite panic; narrative without numbers invites complacency. The one-pager with both invites confidence.

Estimates for planning only, not financial advice.

Frequently Asked Questions

What is earned value management?

A project control method comparing planned value, earned value, and actual cost to measure schedule and cost performance objectively. It forecasts the final cost from current efficiency.

How do you calculate SPI and CPI?

SPI = earned value / planned value; CPI = earned value / actual cost. Values above 1.0 are good, below 1.0 signal trouble.

What is estimate at completion?

The forecasted total project cost: budget at completion divided by CPI. It assumes current cost efficiency continues for the remaining work.

What is the difference between PV, EV, and AC?

Planned value is the budgeted cost of work scheduled; earned value is the budgeted cost of work performed; actual cost is what was really spent. EVM compares all three.

What is TCPI?

To-complete performance index: the efficiency the remaining work must achieve to meet the budget. Above 1.0 means the team must outperform its plan from here on.

When should EVM be used?

On projects with defined scope, budgets, and schedules, especially construction, engineering, and large IT programs. It is overkill for small or purely exploratory work.

What are the limitations of EVM?

It measures cost and schedule, not quality or value delivered. It also needs honest progress measurement; garbage EV inputs produce garbage forecasts.

What CPI triggers corrective action?

Below 0.90 demands immediate action on most projects; below 0.85 often means the baseline is unrecoverable. Trends matter more than single readings.

How is earned value actually measured?

By completed deliverables against the budget: 0/100, 50/50, or percent-complete with gates. Milestone-based rules resist optimism better than subjective estimates.

Does agile use earned value?

Adapted versions exist, using story points or features delivered as the value measure. The core idea, accomplishment versus plan and spend, transfers directly.