Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesProject & Task ManagementProject PlanningEarned Value Management Tracker

SpreadsheetProject PlanningFree

Earned Value Management Tracker

PV, EV, AC, cost and schedule variance, CPI, SPI, EAC, ETC and VAC for every work package and the whole project.

Shown with sample data

Colour

Earned Value Management Tracker

PV, EV, AC, cost and schedule variance, CPI, SPI, EAC, ETC and VAC for every work package and the whole project.

Budget at completion
$820,000
Earned value
$409,350
Project CPI
0.9
Below 1.00 = over budget
Project SPI
0.8
Below 1.00 = behind schedule
Percent complete
50%
Earned value ÷ BAC
Estimate at completion
$909,842
BAC ÷ CPI
Forecast final cost (EAC)
$916,470
Sum of work-package forecasts
Still to spend (ETC)
$462,270
Earned value vs actual cost over time
Jun 30, 2026Nov 30, 2026

Latest: $409,400

Variance at completion by work package
  • 5.0 Mobile apps$8,571
  • 2.0 UX and service design$3,800
  • 1.0 Discovery and requirements-$3,500
  • 9.0 Project management-$4,091
  • 6.0 Testing and assurance-$11,250
  • 3.0 Booking engine build-$30,000
  • 4.0 Integrations (records, payments)-$60,000

How to use it

  1. 1Set the status date on the Settings sheet.
  2. 2List each work package with its budget at completion (BAC) and baseline start and finish dates.
  3. 3Each period, enter % complete (work done, not money spent) and actual cost to date.
  4. 4Read CPI and SPI: below 1.00 means over budget or behind schedule. Check the Forecast sheet for EAC and VAC.
  5. 5Add a row to the Monthly trend sheet each period to build the S-curve.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

Earned value management answers the two questions sponsors care about: are we getting the work we paid for, and what will this cost at the end? Enter each work package’s budget, baseline dates, percent complete and actual cost; the tracker calculates planned value at the status date, earned value, variances, CPI and SPI, and forecasts EAC, ETC and VAC, with a monthly trend for the S-curve.

Who it’s for

  • Monthly cost reporting on fixed-budget projects
  • Early warning of overruns while there is time to act
  • Government and defence contracts that require EVM
  • PMP exam practice with a worked example

What’s included

  • Work packages sheet: Earned value for each work package at the status date.
  • Forecast sheet: Forecast final cost per work package if current cost performance continues.
  • Monthly trend sheet: Cumulative PV, EV and AC at each period end for the S-curve.
  • Settings sheet: Status date and project details.

How to use it

  1. 1Set the status date on the Settings sheet.
  2. 2List each work package with its budget at completion (BAC) and baseline start and finish dates.
  3. 3Each period, enter % complete (work done, not money spent) and actual cost to date.
  4. 4Read CPI and SPI: below 1.00 means over budget or behind schedule. Check the Forecast sheet for EAC and VAC.
  5. 5Add a row to the Monthly trend sheet each period to build the S-curve.

Tips

  • Measure % complete objectively: use milestones (0/50/100 rules) or units completed. Subjective estimates make EVM meaningless.
  • CPI rarely improves by more than 10% after a project is 20% complete. If CPI is 0.90 at that point, plan for an overrun rather than hope.
  • Planned value here assumes work is spread evenly between start and finish. If your baseline schedule front- or back-loads work, enter PV from the schedule instead.

Questions

What are PV, EV and AC?

Planned value (PV) is the budgeted cost of work scheduled to date. Earned value (EV) is the budgeted cost of work actually completed. Actual cost (AC) is what that work really cost.

How do you calculate CPI and SPI?

CPI = EV ÷ AC and SPI = EV ÷ PV. A CPI of 0.90 means you get 90 cents of work for every dollar spent; an SPI of 0.80 means you have done 80% of the work planned by now.

What is EAC and which formula is used?

Estimate at completion is the forecast final cost. This tracker uses EAC = BAC ÷ CPI, which assumes current cost performance continues. Other formulas include AC + (BAC − EV) for one-off variances.

What are ETC, VAC and TCPI?

ETC (estimate to complete) = EAC − AC, the money still needed. VAC (variance at completion) = BAC − EAC; negative means an overrun. TCPI is the cost efficiency needed on the remaining work to finish on budget.

Related searchesearned value managementevm templateearned value calculatorcpi spi calculatorestimate at completionproject cost control

Details

Format
Spreadsheet
Category
Project Planning
Sheets
4
Setup
30 min
Level
Advanced
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetProject PlanningFree

Earned Value Management Tracker

PV, EV, AC, cost and schedule variance, CPI, SPI, EAC, ETC and VAC for every work package and the whole project.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Project Planning
Sheets
4
Setup
30 min
Level
Advanced
Price
Free

Your copy is private to you.

More project planning templates

View all
Project Plan with Gantt Timeline
Task
W1W2W3W4W5W6W7W8W9W10
Kick-off and charter sign-off
Stakeholder interviews
Requirements document
Budget and resource plan
Plan approved
Wireframes
SpreadsheetProject Planning

Project Plan with Gantt Timeline

A real Gantt chart: tasks by phase with dates, owners, dependencies, progress bars across 16 weeks and schedule status.

10 min setupPreview
Project Tracker
Task
OctNov
Customer survey launched
Pricing page copy
Partner contract signed
Onboarding email sequence
Analytics dashboard
Sales training deck
SpreadsheetProject Planning

Project Tracker

Deliverables with owner, priority, dates, progress, health and a workload view by person.

10 min setupPreview
Work Breakdown Structure (WBS)2 sheets

Work packages

9

Total effort (hours)

386

Total cost

$42,040

ABCD
1WBS codeStageDeliverableWork package
21.11 DiscoveryRequirementsStakeholder interviews
31.21 DiscoveryRequirementsRequirements document and sign-off
42.12 DesignExperience designUser flows and wireframes
52.22 DesignVisual designDesign system and page designs
WBS
SpreadsheetProject Planning

Work Breakdown Structure (WBS)

Break a project into phases, deliverables and work packages with effort, cost and owner rolled up by phase.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ