Bob Richardson

Instructions:

  • Identify the year to date & 20 year average annual historical inflation rates for your company using the tables shown below the calculator
  • Enter the following values into the blue-colored cells:
    • Prior year end inventory balance at cost
    • Current year inflation rate
    • 20 year average annual inflation rate: used to calculate the 20 year projected tax savings
    • Combined federal & state tax rate
  • The green-colored cells will automatically update as soon as all values have been entered into the blue-colored input cells

Note: LIFO is adopted on a prospective basis & LIFO tax savings accrue beginning in the year of the change. Prior period benefits can NOT be retrospectively recaptured. 20 year cumulative taxable income reduction & after-tax cash savings shown in calculator are for analysis purposes only & is provided to project the potential tax savings from LIFO that could occur over the next 20 years based on your current year inventory balance at cost & the historical inflation rates.

BLS PPI Annual Inflation Rate Averages Table for Selected Commodities Through December 2025

 PPI CodeBLS PPI Category Description1M 12/25YTD 12/251YR 12/253YR 12/255Y 12/2510YR 12/2520Y 12/25
01FARM PRODUCTS0.3%-0.3%-0.3%-3.5%6.5%3.8%3.3%
011Fruits & melons, fresh/dry vegs. & nuts-9.6%-7.1%-7.1%-8.3%3.8%1.8%2.7%
012Grains2.2%-5.9%-5.9%-14.9%-0.7%1.2%3.4%
013Slaughter livestock2.0%20.2%20.2%18.2%17.6%7.7%4.9%
014Slaughter poultry6.3%-6.5%-6.5%-3.0%8.1%4.2%3.7%
015Raw cotton-0.8%-7.3%-7.3%-9.6%-2.6%-0.2%1.1%
016Raw milk15.3%-7.0%-7.0%-3.7%1.5%2.5%2.0%
017Chicken eggs-12.1%-53.2%-53.2%-27.2%21.3%5.2%4.9%
018Hay, hayseeds and oilseeds-5.7%7.1%7.1%-10.9%-1.2%2.2%3.0%
02PROCESSED FOODS AND FEEDS-0.9%1.8%1.8%1.6%4.9%3.0%2.9%
021Cereal and bakery products0.2%0.7%0.7%0.5%5.0%2.9%3.1%
022Meats, poultry, and fish-2.2%6.9%6.9%5.5%6.4%3.8%3.1%
023Dairy products-0.7%-5.0%-5.0%-2.7%2.4%1.5%1.9%
024Processed fruits and vegetables0.0%3.0%3.0%4.4%7.0%4.4%3.8%
025Sugar and confectionery-0.4%-1.1%-1.1%6.6%6.4%3.4%3.2%
026Beverages and beverage materials0.7%5.0%5.0%4.1%5.1%3.3%2.7%
027Fats and oils-0.2%1.9%1.9%-7.7%4.8%3.1%3.2%
028Miscellaneous processed foods-2.4%-1.0%-1.0%-0.1%4.9%2.8%2.7%
029Prepared animal feeds0.3%-1.3%-1.3%-4.1%1.9%2.4%3.5%
03TEXTILE PRODUCTS AND APPAREL0.8%4.0%4.0%1.1%5.2%3.0%2.3%
031Synthetic fibers0.0%0.2%0.2%0.6%5.5%3.3%1.9%
032Processed yarns and threads-0.2%2.3%2.3%-1.8%5.8%3.0%2.4%
033Greige fabrics0.0%5.5%5.5%1.5%5.3%2.5%2.2%
034Finished fabrics-0.1%4.0%4.0%1.2%5.2%3.3%2.6%
038Apparel & other fabricated textile prods2.5%6.6%6.6%3.7%4.6%2.7%2.2%
039Miscellaneous textile products/services0.4%2.9%2.9%-5.3%6.6%2.6%1.9%
05FUELS AND RELATED PRODUCTS AND POWER-3.4%-1.1%-1.1%-4.7%6.1%3.9%1.0%
051Coal2.7%3.0%3.0%1.2%9.3%4.6%4.8%
053Gas fuels21.2%-3.9%-3.9%-20.2%5.2%2.5%-5.3%
055Utility natural gas5.7%12.3%12.3%-0.6%7.6%5.6%0.7%
056Crude petroleum (domestic production)-3.5%-15.5%-15.5%-7.7%5.0%5.4%-0.1%
057Petroleum products, refined-11.9%-7.9%-7.9%-8.8%5.6%4.5%1.2%
058Asphalt and other petroleum and coal products, n.e.c.0.9%24.8%24.8%-0.9%6.7%4.1%6.9%
06CHEMICALS AND ALLIED PRODUCTS-0.3%0.9%0.9%-1.1%4.0%2.8%2.8%
061Industrial chemicals-0.1%-1.5%-1.5%-4.0%4.4%2.3%2.0%
062Paints and allied products0.0%4.3%4.3%0.6%6.9%4.7%3.9%
063Drugs and pharmaceuticals0.0%0.7%0.7%2.0%2.2%3.0%4.1%
064Fats and oils, inedible-1.1%14.3%14.3%0.1%11.1%7.5%5.1%
065Agricultural chemicals and chemical products-2.1%7.6%7.6%-7.5%7.1%3.0%3.2%
066Plastic resins and materials-1.5%-3.4%-3.4%-3.3%1.9%1.4%1.0%
067Other chemicals and allied products0.4%3.5%3.5%2.3%5.2%3.2%2.8%
07RUBBER AND PLASTIC PRODUCTS0.1%0.7%0.7%-0.2%5.5%3.3%2.6%
071Rubber and rubber products-0.2%2.0%2.0%1.3%5.0%3.0%2.7%
072Plastic products0.2%0.3%0.3%-0.6%5.6%3.4%2.6%
08LUMBER AND WOOD PRODUCTS0.1%-0.5%-0.5%-1.0%1.7%3.1%2.1%
081Lumber0.0%-2.0%-2.0%-0.3%-2.2%3.0%1.5%
082Millwork-0.1%-0.1%-0.1%-0.7%4.5%4.1%2.9%
083Plywood0.2%0.0%0.0%-3.0%1.3%3.3%2.0%
084Other wood products0.4%1.6%1.6%-1.7%3.2%2.9%2.0%
085Logs, bolts, timber, pulpwood, woodchips and other roundwood products0.2%0.1%0.1%-2.1%1.2%0.9%1.4%
086Prefabricated wood buildings & components-0.1%4.0%4.0%1.5%6.9%5.2%3.3%
087Treated wood and contract wood preserving0.2%-6.8%-6.8%-1.2%2.1%2.8%2.2%
09PULP,PAPER, AND ALLIED PRODUCTS0.1%1.1%1.1%0.8%5.4%3.3%2.6%
091Pulp, paper, and prod., ex. bldg. paper0.3%1.3%1.3%0.5%5.5%3.2%2.8%
092Building paper & building board mill prods.-2.5%-27.4%-27.4%-11.4%-6.9%1.5%1.2%
094Publications, printed matter & printing material-0.2%3.4%3.4%3.0%6.5%3.9%
10METALS AND METAL PRODUCTS3.2%13.7%13.7%4.2%8.6%6.4%3.8%
101Iron and steel5.5%11.2%11.2%-0.4%7.4%6.6%3.2%
102Nonferrous metals5.6%29.4%29.4%11.3%10.3%8.4%4.7%
103Metal containers1.9%8.9%8.9%1.3%8.4%5.1%3.4%
104Hardware0.7%7.0%7.0%2.9%6.1%3.9%3.0%
105Plumbing fixtures and fittings2.4%8.1%8.1%3.6%4.9%3.6%3.1%
106Heating equipment0.2%7.3%7.3%3.9%8.6%5.6%4.5%
107Fabricated structural metal products0.3%8.0%8.0%3.0%10.3%6.4%4.1%
108Miscellaneous metal products0.4%3.6%3.6%2.8%6.0%3.7%2.7%
11MACHINERY AND EQUIPMENT0.3%5.2%5.2%3.9%5.6%3.3%2.2%
111Agricultural machinery and equipment0.3%1.8%1.8%1.4%6.1%3.9%3.2%
112Construction machinery and equipment0.8%6.1%6.1%4.7%6.5%4.1%3.3%
113Metalworking machinery and equipment0.5%5.1%5.1%4.6%5.8%3.5%2.6%
114General purpose machinery and equipment0.4%7.7%7.7%5.4%7.9%5.0%3.9%
115Electronic computers and computer equipment0.1%4.7%4.7%55.4%32.6%13.7%3.7%
116Special industry machinery and equipment0.6%4.4%4.4%3.6%6.6%4.1%2.7%
117Electrical machinery and equipment0.2%4.7%4.7%3.1%4.3%2.5%1.3%
118Miscellaneous instruments0.1%6.5%6.5%5.1%5.7%3.7%2.7%
119Miscellaneous machinery0.1%2.3%2.3%3.1%4.0%2.4%2.2%
12FURNITURE AND HOUSEHOLD DURABLES0.4%4.6%4.6%2.2%5.1%3.5%2.5%
121Household furniture0.3%3.6%3.6%1.3%4.9%3.4%2.6%
122Commercial furniture0.6%5.3%5.3%3.4%7.0%4.7%3.3%
123Floor coverings-1.0%2.7%2.7%0.9%2.1%1.6%1.8%
124Household appliances1.1%5.3%5.3%1.5%4.2%2.9%2.0%
125Home electronic equipment-0.6%4.9%4.9%2.5%4.6%2.6%0.3%
126Other household durable goods0.3%4.9%4.9%3.0%5.1%3.3%2.4%
13NONMETALIC MINERAL PRODUCTS0.2%2.9%2.9%3.9%6.5%4.4%3.8%
131Glass0.4%2.9%2.9%2.1%4.4%3.3%2.3%
132Concrete ingredients and related products0.1%4.7%4.7%6.8%7.3%5.5%4.5%
133Concrete products0.2%1.9%1.9%4.3%7.1%5.0%3.9%
134Clay construction products ex. refractories0.0%1.6%1.6%2.2%4.2%2.7%1.7%
135Refractories-0.1%1.6%1.6%1.8%4.9%3.7%3.7%
136Asphalt felts and coatings-0.6%0.8%0.8%1.4%6.5%4.4%4.6%
137Gypsum products0.0%0.7%0.7%1.4%7.9%5.5%3.3%
138Glass containers0.9%2.4%2.4%5.6%7.3%4.4%3.7%
139Other nonmetallic minerals0.3%3.9%3.9%3.5%6.2%3.4%3.7%
14TRANSPORTATION EQUIPMENT0.3%2.3%2.3%2.0%2.9%1.9%1.7%
141Motor vehicles and equipment0.3%2.3%2.3%1.5%2.8%1.8%1.5%
142Aircraft and aircraft equipment0.3%2.2%2.2%3.1%3.1%2.1%2.3%
143Ships and boats0.1%3.0%3.0%2.5%3.6%2.5%2.4%
144Railroad equipment0.0%1.0%1.0%0.9%1.3%0.7%1.5%
149Transportation equipment, n.e.c.-0.2%1.0%1.0%0.5%3.2%2.5%1.7%
15MISCELLANEOUS PRODUCTS0.3%5.9%5.9%5.5%6.3%4.5%3.3%
151Toys, sporting goods, small arms, etc.0.4%1.9%1.9%3.3%6.2%3.5%2.6%
152Tobacco products, incl. stemmed & redried0.1%10.6%10.6%10.9%10.3%8.0%6.5%
154Photographic equipment and supplies0.1%3.2%3.2%3.4%4.8%3.3%2.6%
155Mobile homes-1.9%2.7%2.7%0.2%7.0%6.2%4.5%
156Medical, surgical & personal aid devices0.2%2.8%2.8%2.5%2.6%1.8%1.4%
157Other industrial safety equipment0.5%5.9%5.9%4.2%6.2%3.5%2.7%
159Other miscellaneous products0.9%6.4%6.4%4.9%7.3%4.9%3.3%

BLS CPI Historical Annual Inflation Rate Averages Through January 2026 Table for Selected Categories

BLS CPI CodeBLS CPI Category Description1M 1/261Y 1/263Y 1/265Y 1/2610Y 1/26 20Y 1/26
SAFFOOD & BEVERAGES0.4%2.8%2.6%4.8%3.3%2.9%
SAF11Food at home0.6%2.1%1.7%4.7%2.7%2.5%
SAF114Nonalcoholic beverages & beverage materials1.6%4.5%3.4%5.6%3.4%2.4%
SEFNJuices & nonalcoholic drinks2.6%2.3%3.0%5.3%3.6%2.5%
SEFN01Carbonated drinks4.0%3.5%3.1%5.4%4.1%2.9%
SEFN03Nonfrozen noncarbonated juices & drinks1.4%1.3%2.5%5.0%3.1%2.0%
SEFPBeverage materials including coffee & tea-0.5%9.9%4.3%6.2%3.0%2.2%
SEFP01Coffee0.6%18.3%6.3%8.1%3.6%2.9%
SEFP02Other beverage materials including tea-2.8%0.2%2.3%3.9%2.3%1.7%
SAF115Other food at home-0.1%2.1%1.8%5.1%3.0%2.5%
SEFT06Other miscellaneous foods-1.8%2.6%1.5%4.8%2.9%2.2%
SEFWAlcoholic beverages at home0.0%0.6%0.9%1.9%1.5%1.4%
SEFW01Beer, ale & other malt beverages at home0.4%1.7%1.9%3.3%2.6%2.3%
SEFW02Distilled spirits at home0.2%1.5%0.7%1.4%1.0%0.9%
SEFW03Wine at home-0.5%-0.9%-0.1%0.8%0.7%0.7%
SEHEFUEL OIL & OTHER FUELS-1.8%-6.0%-6.0%6.0%4.9%2.2%
SAH3HOUSEHOLD FURNISHINGS & OPERATIONS0.4%3.9%1.5%3.8%2.3%1.0%
SAAAPPAREL2.0%1.7%0.7%2.1%0.7%0.6%
SAM1MEDICAL CARE COMMODITIES-0.1%0.3%1.8%2.1%1.6%2.0%
SEMFMedicinal drugs-0.1%-0.1%1.8%2.0%1.6%
SEMF01Prescription drugs0.0%-0.5%1.4%1.6%1.6%8.6%
SEMF02Nonprescription drugs-0.5%0.9%2.9%3.0%1.3%
SEMGMedical equipment and supplies0.8%2.9%2.0%3.3%1.2%
SARRECREATION0.8%2.5%2.3%3.3%2.2%1.3%
SEGATOBACCO & SMOKING PRODUCTS2.1%8.5%7.6%7.2%6.1%6.2%
SEGBPERSONAL CARE PRODUCTS0.7%1.9%1.9%2.6%1.1%0.8%
SEGEMISCELLANEOUS PERSONAL GOODS2.3%3.8%-0.2%3.7%1.2%0.2%
SAGOTHER GOODS AND SERVICES1.5%5.9%4.6%5.0%3.6%3.2%
SEREOther recreational goods1.6%1.0%-1.3%0.0%-3.2%-3.5%
SERGRecreational reading materials0.2%1.9%1.4%1.5%2.0%1.8%

Get a Free LIFO Election Benefit Analysis
Top LIFO Candidates & 2021 LIFO Lookout Guide
Get a Free LIFO Election Benefit AnalysisSample LIFO Election Benefit Analysis ReportLIFO Election Benefit Analysis Documentation Request

LIFOPro's OfferingsTurnkey Outsourcing SolutionsCPA Firm Offerings

LIFO Election Benefit Analysis Questionnaire

Get a complimentary, no obligation LIFO Election Benefit Analysis & turnkey outsourcing solutions fee quote emailed to you within one week of submitting the request form below!

Drag & Drop Files, Choose Files to Upload You can upload up to 20 files.
For example, a company with a December year end sending us these reports in December of 2021 would send us their November 2021 & December 2020 item detail reports. Please upload reports that include the following fields 1. Item/part/product code or number 2. Item/part description 3. Current period quantity on hand/weight 4. Current period item/unit cost. 5. Any product hierarchy fields if they are available, such as: category/subcategory, class/subclass, type, group, line, division, cost/profit center, business segment/unit, etc. Including product hierarchies will provide for a more accurate estimate of the projected tax savings from LIFO & will also likely reduce the turnkey outsourcing solutions fee quote. You will receive a complimentary LIFO benefit analysis report & turnkey outsourcing solutions fee quote within one week of submitting this form. See a sample item detail report file & product hierarchies by downloading this file: https://lifopro.com/publicdownloads/LIFOPro_Sample_Item_Detail_Report.xlsx Alternatively, you can email your item detail reports to lifopro@lifopro.com after submitting this request form.
=