Need EVM Formulas in Excel for Project Managers?

QI Macros has a Ready-Made EVM Formula Template!

Earned Value Management Formulas Outlined in the PMBOK®.

The Earned Value Management technique (EVM) helps measure project progress in an objective way. This method can combine scope, cost, and schedule values to give early warning (or reassurance) of performance progress. These numbers can also help prevent scope creep, communicate with stakeholders, and keep the project and project team on track.

Earned Value Cost:

  • Cost Variance
  • CPI Cost Performance Index
  • Earned Value
  • Actual Cost
  • Expected Monetary Value
  • Benefit Cost Ratio
  • Cost Benefit Ratio
Earned Value Cost template
earned value mgmt template2

Earned Value Schedule:

  • Earned Value (alt method)
  • Schedule Variance
  • Schedule Performance Index
  • Planned Value
  • Estimate at Completion (4 formulas)
  • Estimate to completion (3 formulas)
  • Variance at Completion
  • Pert
  • Communication Channels
earned value schedule template
earned value schedule part 2

Haven't you waited long enough?
Start creating your EVM Excel Formulas in just minutes.

Download a free 30-day trial. Get the EVM Excel Formulas now!

The EVM Excel Formulas is one of many tools included in QI Macros add-in for Excel.

QI Macros adds a new tab to Excel's menu, making it easy to find any tool you need. If you can't locate a tool, use the find tools feature on the far right side of QI Macros menu.

find tools on QI Macros menu

Other Charts Included in QI Macros Add-in for Excel