SPI CPI Calculator

Calculator Inputs

Planned Value (PV)

Budgeted cost of scheduled work.

Earned Value (EV)

Budgeted cost of completed work.

Actual Cost (AC)

Actual cost of completed work.

Budget at Completion (BAC) (optional)

Total planned budget for the project.

EAC Method (optional)

Used only when BAC is provided.

Planned Duration (optional)

Days or weeks—keep units consistent.

Actual Duration (optional)

Enables a simple planned/actual time ratio.

Reset

Example Data Table

Use these sample values to see how the metrics behave.

Scenario	PV	EV	AC	SPI	CPI
On schedule, under budget	100000	100000	95000	1.0000	1.0526
Behind schedule, over budget	120000	100000	110000	0.8333	0.9091
Ahead of schedule, over budget	90000	105000	115000	1.1667	0.9130

Formulas Used

SPI = EV / PV
CPI = EV / AC
SV = EV − PV
CV = EV − AC
Percent Complete = (EV / BAC) × 100
EAC (method choices):
- EAC = BAC / CPI
- EAC = AC + (BAC − EV)
- EAC = AC + (BAC − EV) / (CPI × SPI)
ETC = EAC − AC
VAC = BAC − EAC

How to Use This Calculator

Enter PV, EV, and AC for the same reporting date.
Optionally add BAC to estimate EAC, ETC, and VAC.
Choose an EAC method that fits your control approach.
Press Submit to view results above the form.
Download CSV or PDF to share with your team.

FAQs

1) What does SPI indicate?

SPI compares earned value to planned value. Values above 1 mean progress is ahead of plan; below 1 means behind plan for the same point in time.

2) What does CPI indicate?

CPI compares earned value to actual cost. Values above 1 suggest cost efficiency; below 1 indicates you spent more than planned for completed work.

3) Can SPI and CPI be used together?

Yes. Together they show whether the project is progressing fast enough and spending efficiently. A project can be ahead of schedule but over budget, or vice versa.

4) When should I provide BAC?

Provide BAC when you want forecasting outputs such as EAC, ETC, and VAC. Without BAC, you still get SPI, CPI, and variances for performance diagnosis.

5) Which EAC method should I choose?

Use BAC/CPI when future work follows current cost efficiency. Use AC+(BAC−EV) when remaining work matches the original plan. Use the CPI×SPI option when both cost and schedule trends persist.

6) Why must PV, EV, and AC use the same date?

Earned value metrics are meaningful only when all values refer to the same reporting cutoff. Mixing dates can distort indices and lead to incorrect corrective actions.

7) What if EV is zero?

If EV is zero, the indices may be zero, signaling no measurable progress. Confirm that work is truly incomplete and that progress measurement rules are consistent across the team.