Cost Performance Trend Calculator
Turn incremental planned value, earned value and actual cost into a period-by-period performance record. The calculator displays cumulative CPI and SPI alongside a three-period moving CPI, with a table that makes every accumulation and undefined denominator visible.
By Dr. Hassan Khames EliwaLast updated
Result
- Cumulative SPI
- 1.0000
- Periods
- 3
- Cumulative CPI
- Cumulative SPI
- 3-period moving CPI
Incremental inputs and cumulative indices; — means zero denominator, non-finite ratio or fewer than three periods. Lines connect defined observations across gaps.
| Period | PV | EV | AC | Cum PV | Cum EV | Cum AC | CPI | SPI | 3-period CPI |
|---|---|---|---|---|---|---|---|---|---|
| 1 | 100.00 | 80.00 | 100.00 | 100.00 | 80.00 | 100.00 | 0.8000 | 0.8000 | — |
| 2 | 100.00 | 100.00 | 125.00 | 200.00 | 180.00 | 225.00 | 0.8000 | 0.9000 | — |
| 3 | 100.00 | 120.00 | 100.00 | 300.00 | 300.00 | 325.00 | 0.9231 | 1.0000 | 0.9231 |
How it works
Prepare one consistent reporting series
Enter one comma-separated PV, EV, AC row for each consecutive reporting period, oldest first. Rows contain incremental amounts, not cumulative balances. Use the same currency and price basis throughout, without currency symbols, thousands separators or a header. Each amount must be finite and nonnegative. Input is bounded to 200 periods, 30,000 characters and one trillion per amount, keeping recalculation predictable in the browser. Negative reversals must be reconciled outside this simplified tool rather than silently discarded.
Read the cumulative indices
For period t, add each measure from the first period through t. Cumulative CPI equals cumulative EV divided by cumulative AC; cumulative SPI equals cumulative EV divided by cumulative PV. A value of one indicates equality on that budget basis. CPI below one means recorded spending exceeds the budgeted value earned. SPI below one means less budgeted work has been earned than scheduled. Neither ratio is a direct measure of cash flow, profit or calendar delay.
Calculate a weighted recent indicator
The three-period moving CPI first appears at period three. It equals the sum of EV in the current and previous two periods divided by the sum of AC over the same window. It is not the arithmetic mean of three individual CPI values. This rolling-sum definition weights periods by their actual expenditure and avoids giving a tiny mobilisation period the same influence as a major production period. Windows are based on row count, so mixing weekly and monthly rows defeats the intended interpretation.
Handle missing ratios honestly
A zero denominator or a ratio exceeding finite numeric range produces an em dash in the table and no chart point, including zero divided by zero. A positive denominator with zero EV correctly produces zero. The chart connects defined observations across gaps; use the table to identify missing periods rather than reading the connecting line as measured performance. The first two moving values are also undefined because a full three-period window does not yet exist. No infinity, arbitrary replacement ratio or partial-window average is introduced.
Worked example
Scenario 1: three production periods
Enter rows 100,80,100; 100,100,125; and 100,120,100 on separate lines. Cumulative PV and EV both reach 300.00, while cumulative AC reaches 325.00. Final CPI is 300 ÷ 325 = 0.9231 and final SPI is 1.0000. The three-period moving CPI is also 0.9231 because its first full window covers the entire series. The earlier cumulative CPI values are 0.8000 and 0.8000, making the final recovery visible without implying that the cost overrun disappeared.
Scenario 2: a zero-cost opening period
Enter 0,0,0; 100,50,100; 100,100,100; and 100,150,100. The first period has undefined CPI and SPI. By period four the totals are PV 300.00, EV 300.00 and AC 300.00, giving CPI 1.0000 and SPI 1.0000. The period-three moving CPI is 0.7500, while the period-four moving CPI is 1.0000. This distinguishes missing ratios from genuine recovery and confirms that zeros are retained in the rolling sums.
Expert tips
Common mistakes
- Entering cumulative amounts as period rows double-counts earlier work. Convert cumulative reports into period differences before using this calculator.
- Averaging period CPI ratios gives small and large cost periods equal influence. Use the rolling EV total divided by rolling AC total instead.
- SPI approaches one as all baseline work is eventually earned, including on late projects. Do not use a closing SPI of one as evidence of on-time completion.
Frequently asked questions
Are the rows monthly?
They can be weeks, months or another consistent interval. The three-period window means three rows, not automatically three calendar months.
Can I enter currency symbols?
No. Enter plain numeric amounts with decimal points if needed. All rows must share one currency; the tool does not convert exchange rates.
Why is the first moving CPI blank?
A complete three-period window requires three rows. The first two observations deliberately remain undefined rather than using shorter and incomparable windows.
Does CPI above one mean profit?
Not necessarily. CPI compares earned budget with incurred cost. Commercial margin depends on revenue, contract terms, exclusions and other costs outside that comparison.
Can I include negative adjustments?
This tool accepts only nonnegative period amounts. Reconcile credits and progress reversals within your controls process before preparing an equivalent valid series.
Does the graph forecast future performance?
No. All plotted values summarize supplied periods. A favorable recent window is a signal to investigate and sustain, not an automatic estimate at completion.
Related calculators
Related guides
Construction & ProjectCPI and SPI trends: read the direction, not just the numberRead period and cumulative CPI and SPI together, test the data behind changing trends, and turn earned-value signals into practical decisions.16 November 2026 · 8 min read
Construction & ProjectResource histograms and levelling: spot the peak earlyBuild a resource histogram, distinguish levelling from smoothing, and test whether a flatter labour plan is genuinely deliverable.16 November 2026 · 8 min read
Construction & ProjectCrew size, man-hours and productivity: labour arithmeticConvert scope and production rates into labour-hours and crew sizes, then test utilization, whole-shift bookings and labour cost.16 November 2026 · 8 min readSources and standards
About the author
Dr. Hassan Khames Eliwa holds a PhD in Construction & Built Environment and has more than 20 years of international project controls experience. He is Director of Eliwa Project Controls Limited in Auckland and founder of PMMilestone.org and PMMilestone.com.
Buy me a coffee