Converts a dollar amount from one period to another period's dollars using two Consumer Price Index values.
Published for review. The Founder is checking every card himself; anything he strikes comes down the same hour.
Try it
Inputs
amount (number, currency units, required) min 0 : Amount stated in the starting period's dollars
cpi_start (number, required) min 0 : CPI index value for the starting period
cpi_end (number, required) min 0 : CPI index value for the ending period
Outputs
adjusted_value (currency units): Amount restated in the ending period's dollars
Steps
adjusted_value = amount * (cpi_end / cpi_start).
Round adjusted_value to 2 decimals (money to cents).
Constants
None.
Sources
How to Use the Consumer Price Index for Escalation (U.S. Bureau of Labor Statistics, 2026-09-30T22:29:13Z) - Confirmed live. BLS describes CPI escalation as changing a payment by the percent change in the CPI between two periods; the ratio form used here, amount * (CPI_end / CPI_start), is the mathematically equivalent multiplicative statement of that same percent-change method (1 + percent_change/100 = CPI_end / CPI_start).