Earn Value Calculator Template

Earned Value Calculator

Five numbers in, the truth about your project out — and every formula shown so you can defend it.

Earned value gets quoted badly more often than it gets calculated properly. This does the arithmetic correctly, then explains what the result actually means, in a sentence you could read out in a steering meeting.

What it calculates

• Earned value, cost variance and schedule variance
• CPI and SPI
• Estimate at completion, estimate to complete, variance at completion
• TCPI — how well you would have to perform for the rest of the project to still finish on budget, which is the number that tells you whether recovery is realistic
• Forecast duration and slip in months

It tells you what it means

Not just indices — a verdict and a readout:

• "At today's performance this project finishes at $1.19M against a budget of $1.00M — an overrun of $187.5k — and takes about 15 months instead of 12."
• "You have spent $380.0k and earned $320.0k of value. The difference, $60.0k, is money spent with nothing to show for it."
• "To still finish on budget you would have to run the rest of the work at a CPI of 1.10."

Every formula is shown

A full table of every measure with the formula beside it — EV = BAC × % complete, CPI = EV ÷ AC, and so on. So when someone asks where the number came from, you can point at it.

What's included

• One HTML file — double-click, works in any browser
• Live chart of PV, EV, AC, BAC and EAC against the budget line
• Print or save as PDF, download as CSV
• Your own branding: five lines at the top set your business name, website and colours

Why not a spreadsheet

Because a spreadsheet does not tell you what the numbers mean, and this does. It also runs anywhere, needs no login and no subscription, and your project figures never leave your computer.

Built in Australia from more than twenty years of program delivery experience. Licensed for use within the purchasing organisation, not for resale or redistribution.