Salary History Inflation Adjuster
Convert salary records into common-period values.
Salary History Inflation Adjuster: Scenario Inputs
Annual percentage rate or benchmark index change.
Inflation & Purchasing Power Analysis
Over 3 years at 3.5% inflation, a $75,000 salary requires $83,154 to retain equal purchasing power. Without matching raises, your real compensation experiences an effective reduction of $7,355 (-9.81%).
Need complete multi-year compound modeling?
Run detailed comparisons, custom CPI series, and visual breakdown charts.
How Salary History Inflation Adjuster Works?
The Salary History Inflation Adjuster matches each pay record to its month's price index. It uses the index ratio to put all amounts into one target period's money.
Paste or type records
Enter one row per salary change with a date and an amount. CSV input from a spreadsheet works.
Choose the target period
Select the month all records convert to, usually the latest available month.
Match index values
The adjuster looks up the index for each record's month.
Export adjusted rows
The output table lists original amounts, adjusted amounts and the factor used for each row.
Salary History Inflation Adjuster Formula
The Salary History Inflation Adjuster formula applies one index ratio per record, using the record's own month.
Adjustedi = Amounti × (CPItarget ÷ CPImonth i)
Variables
- Amounti
- Salary in record i
- CPImonth i
- Index value for the month of record i
- CPItarget
- Index value of the target month
Worked example
A $48,000 record from January 2015 (index 233.7) adjusts to $64,698 in a target month with an index of 315.0.
Salary History Inflation Adjuster Conversion Table
This table adjusts 5 dated salary records to a target month with an index of 315.0.
| Record date | Salary as paid | Example index | Factor | Adjusted salary |
|---|---|---|---|---|
| Jan 2015 | $48,000 | 233.7 | 1.3479 | $64,698 |
| Jul 2017 | $53,500 | 244.8 | 1.2868 | $68,842 |
| Mar 2019 | $57,000 | 254.2 | 1.2392 | $70,633 |
| Sep 2021 | $61,000 | 274.3 | 1.1484 | $70,051 |
| Apr 2023 | $69,000 | 303.4 | 1.0382 | $71,638 |
Index values are illustrative examples for the calculation.
What is Salary History Inflation Adjuster?
The Salary History Inflation Adjuster is a tool that converts a list of dated salary records into values for one common price period. The adjuster processes records in bulk, so a full employment history converts in one pass.
Each record keeps its original date and amount, and gains an adjusted amount in the target period's dollars.
What are the uses of Salary History Inflation Adjuster?
There are 4 main uses of the Salary History Inflation Adjuster.
Clean up personal records
Convert a full employment history from a spreadsheet into current dollars in one step.
Prepare HR audits
Restate past salaries for a group of employees to one period before comparing them.
Document legal claims
Produce adjusted wage schedules with the factor shown on each row for review.
Feed other tools
Export adjusted rows into charts, reports and spreadsheet models.
Related Inflation & Purchasing Power Calculators
Browse all 140+ toolsSalary Inflation Calculator
Adjust salary between selected periods.
Real Salary Calculator
Express pay in base-period purchasing power.
Historical Salary Equivalent Calculator
Convert current pay into past-period values.
Present-Day Salary Equivalent Calculator
Update historical pay using available inflation data.
Salary Purchasing Power Calculator
Compare what a salary can buy.
Required Salary Calculator
Calculate inflation-matching salary levels.