• Preview of Earned Value Management Calculator (PV, EV, AC, CPI, SPI, EAC)Excel workbook preview

Project Cost, Budget and Earned Value

Earned Value Management Calculator (PV, EV, AC, CPI, SPI, EAC)

$17.99 Free XLSX
Excel workbook · 13 KB

3 downloads per free account, no card needed.

Need more than 3? Get all 300 templates for $249 One payment, lifetime access, including every template added later.

Who this is for

A project manager or PMO analyst who has to give the steering committee earned value figures this month and wants the formulas right.

What is inside

  • 8 worked control accounts for a website rebuild, with a project total row
  • Live formulas: CV, SV, CPI, SPI, EAC (BAC/CPI and CPI x SPI), ETC, VAC, TCPI
  • CPI and SPI turn red below 0.90 and amber below 0.95 (thresholds on Settings)
  • TCPI turns red when it exceeds CPI by more than 0.05 (GAO rule of thumb)
  • Blank-safe: IFERROR on every ratio, so empty rows stay empty
  • 16 blank formula rows, frozen header and filter, landscape print

How to use it: Enter BAC, PV, percent complete and AC per control account at each data date; the sheet computes the rest. Set your own thresholds on the Settings sheet.

Files & formats
  • XLSXearned-value-management-calculator.xlsx13 KB

Opens in Microsoft Word or Excel, Google Docs or Sheets and LibreOffice. Delivered instantly from your browser.

Free downloads & full access

Every account gets 3 free downloads. Re-downloading a template you already have does not count. This template on its own is $17.99, and buying it keeps your free downloads for something else. Full access is a one-time $249 for all 300 templates, for life.

Bought with a different email? Open your account and enter your order number.

Licence

Use and adapt the document inside your own organisation or for your own clients. Do not resell or republish the templates themselves.