Free tool · Project controls

Earned Value Calculator

On programme and on budget, or spending too much too early? Put in your plan, your monthly spend and how far through the job you are. You get SPI, CPI, a forecast at completion and a report you can export as a PDF.

01The project

Dates set the months in the table below.

Project name Planned start date Planned end date Actual start date Estimated end dateYour current best guess Total project valueWhat the client pays you £ Reporting monthStatus is measured at month end

02Month by month

Months up to the reporting month take actuals. Later months take your forecast.

Quick fill the baseline

Got a total budget but no monthly split yet? Spread it as a typical S-curve across the planned dates. You can overwrite any month after.

Quick fill the forecast

Enter your latest overall forecast cost. Whatever's left after spend to date is spread evenly to the estimated end date.

Month	BaselinePlanned cost (£)	ActualLabour (£)	ActualMaterials (£)	ActualTotal spend	Progress% complete to date	ForecastFuture spend (£)

% complete is cumulative: how much of the whole job is done by the end of that month. Not sure how to judge it? See how to measure progress.

03Where you are

Cost and schedule variance

Planned value (baseline) Earned value (work done) Actual cost Forecast cost

The numbers

Programme and margin

Month by month: planned vs actual

We planned to be here. We are here. Use this to spot when things started to drift.

How to measure % complete

% complete is the one number that needs judgement, and it drives everything else. Pick the method that suits the work and use it every month.

Count physical quantities. Best when the work is countable. Piles installed out of piles in scope, m³ of concrete poured, metres of drainage laid.
Weighted milestones. Split the job into packages, weight each by its budget, and credit 0% not started, 50% started, 100% finished. It keeps optimism out.
Judgement. The site or project manager's estimate. Fine for small packages. Sense check it against quantities where you can.
Never use spend. "We've spent 60% so we're 60% done" makes CPI equal 1 every month and hides the problem you're trying to find.

Done of units =-

What the terms mean

PV: Planned value. The budgeted cost of the work you planned to have done by now.
EV: Earned value. The budgeted cost of the work you've actually done. % complete × total budget.
AC: Actual cost. What you've spent to date on labour and materials.
SPI: Schedule performance index, EV ÷ PV. 1.00 is on programme. Below 1 is late. 0.90 means you've done 90% of the work you planned by now.
CPI: Cost performance index, EV ÷ AC. 1.00 is on budget. Below 1 is over. 0.92 means every £1 spent is earning 92p of work. It's your early warning.
BAC: Budget at completion. Your bottom-up cost forecast at the outset.
EAC: Estimate at completion. Spend to date plus forecast future spend.
TCPI: To-complete performance index. The CPI you need on the remaining work to still land on budget.

This calculator is for illustration only. We accept no liability for the accuracy of the figures presented or how you use them. Your figures stay in your browser. From Profit Intelligence, profitintelligence.co.uk