This Earned Value Management (EVM) spreadsheet is a pre-built calculation tool that automates the core EVM metrics and forecasting formulas defined in PMBOK 8, allowing project managers to enter their project's planned value, earned value, and actual cost data and immediately generate performance indices, variance metrics, and cost-at-completion forecasts. According to the Project Management Institute (PMI), EVM is used in both the Finance Performance Domain (Monitor and Control Finances) and the Schedule Performance Domain (Monitor and Control Schedule) of PMBOK 8 as the primary quantitative method for integrated scope, schedule, and cost performance measurement.

What is Earned Value Management?

In PMBOK 8, Earned Value Management (EVM) is an integrated performance measurement approach that compares Planned Value (PV — the budgeted value of work scheduled), Earned Value (EV — the budgeted value of work actually accomplished), and Actual Cost (AC — the real cost incurred for work performed) to produce objective, quantitative performance metrics. EVM generates four key metrics: Cost Variance (CV = EV − AC), Schedule Variance (SV = EV − PV), Cost Performance Index (CPI = EV/AC), and Schedule Performance Index (SPI = EV/PV). It also produces forecasting values — Estimate at Completion (EAC), Estimate to Complete (ETC), and Variance at Completion (VAC) — that project the likely final cost based on current performance. The performance measurement baseline (PMB), which integrates the scope baseline, schedule baseline, and cost baseline, is the foundation against which all EVM metrics are calculated.

What's Included in This EVM Spreadsheet?

• Data Input Section - Structured fields for entering Planned Value (PV), Earned Value (EV), and Actual Cost (AC) by time period and cumulative, with space for the Budget at Completion (BAC) and project status date.
• Performance Variance Calculations - Automated calculations for Cost Variance (CV = EV − AC) and Schedule Variance (SV = EV − PV) with conditional formatting to highlight variances outside acceptable thresholds.
• Performance Index Calculations - Automated Cost Performance Index (CPI = EV/AC) and Schedule Performance Index (SPI = EV/PV), with visual indicators distinguishing values above 1.0 (favorable) from values below 1.0 (unfavorable).
• Forecasting Metrics - EAC calculations using three standard methods (EAC = BAC/CPI; EAC = AC + ETC; EAC = AC + BAC − EV), Estimate to Complete (ETC), Variance at Completion (VAC), and To-Complete Performance Index (TCPI).
• S-Curve Chart - Automatically generated S-curve displaying PV, EV, and AC over the project timeline, providing a visual representation of cumulative performance relative to the baseline plan.
• EVM Summary Dashboard - A one-page summary view of all key EVM metrics suitable for inclusion in status reports and stakeholder presentations.

How to Use This EVM Spreadsheet

1. Enter the Budget at Completion (BAC) and time-phased PV at project start - The BAC is the total authorized budget for the project. The time-phased PV distributes that budget across the project timeline according to the schedule baseline.
2. Update EV and AC each reporting period - Earned Value reflects the budgeted value of work actually accomplished. Enter EV based on the percentage complete of each work package multiplied by its budget. Enter AC from actual cost records.
3. Review variances against thresholds defined in the financial management plan - The financial management plan specifies acceptable variance thresholds (e.g., CPI ≥ 0.90). Use the EVM dashboard to identify when actual performance breaches those thresholds and requires corrective action.
4. Use EAC forecasts to update the estimate at completion - Compare the EAC produced by each calculation method and select the most appropriate based on the project's performance pattern and remaining work characteristics.

When to Use This Resource

This EVM spreadsheet should be set up during the Planning Focus Area once the performance measurement baseline (PMB) is established. Regular updates begin as soon as actual cost and work performance data is available during project execution. The spreadsheet is updated at every monitoring and controlling cycle — typically aligned with the reporting period defined in the financial management plan — and the resulting metrics feed into work performance information and work performance reports distributed to project stakeholders.

Related Resources

• Schedule Baseline Template
• Revenue and Cost Forecasts Template
• Work Performance Information Template
• Scope Baseline Template
• Project Schedule Template

Complete Guide & Filled-In Example

Get the most out of this template with the two companion resources below:

• Earned Value Management in PMBOK 8 - Complete Guide - Understand the purpose, key elements, and best practices before filling in the template.