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 August 2026

 PPI CodeBLS PPI Category Description1M 8/26YTD 8/261YR 8/263YR 8/265Y 8/2610YR 8/2620Y 8/26
01FARM PRODUCTS-2.9%-0.9%-3.3%-3.5%6.5%3.8%3.3%
011Fruits & melons, fresh/dry vegs. & nuts-2.2%-13.3%-0.8%-8.3%3.8%1.8%2.7%
012Grains0.4%5.1%17.3%-14.9%-0.7%1.2%3.4%
013Slaughter livestock-6.4%2.4%-8.9%18.2%17.6%7.7%4.9%
014Slaughter poultry-0.3%3.7%0.8%-3.0%8.1%4.2%3.7%
015Raw cotton5.4%26.7%16.6%-9.6%-2.6%-0.2%1.1%
016Raw milk-7.5%-12.4%-18.2%-3.7%1.5%2.5%2.0%
017Chicken eggs49.1%-50.6%-59.4%-27.2%21.3%5.2%4.9%
018Hay, hayseeds and oilseeds-1.4%12.3%18.1%-10.9%-1.2%2.2%3.0%
02PROCESSED FOODS AND FEEDS-0.3%1.8%0.0%1.6%4.9%3.0%2.9%
021Cereal and bakery products0.1%1.3%0.9%0.5%5.0%2.9%3.1%
022Meats, poultry, and fish-1.8%-1.3%-4.6%5.5%6.4%3.8%3.1%
023Dairy products-1.0%4.3%-0.7%-2.7%2.4%1.5%1.9%
024Processed fruits and vegetables0.0%2.3%4.4%4.4%7.0%4.4%3.8%
025Sugar and confectionery4.0%3.2%3.1%6.6%6.4%3.4%3.2%
026Beverages and beverage materials-0.3%0.8%1.9%4.1%5.1%3.3%2.7%
027Fats and oils2.0%22.7%24.4%-7.7%4.8%3.1%3.2%
028Miscellaneous processed foods-0.3%-0.1%-2.9%-0.1%4.9%2.8%2.7%
029Prepared animal feeds-0.1%5.8%3.8%-4.1%1.9%2.4%3.5%
03TEXTILE PRODUCTS AND APPAREL0.6%3.1%5.7%1.1%5.2%3.0%2.3%
031Synthetic fibers0.0%4.8%6.3%0.6%5.5%3.3%1.9%
032Processed yarns and threads0.3%4.4%6.2%-1.8%5.8%3.0%2.4%
033Greige fabrics0.4%3.9%6.6%1.5%5.3%2.5%2.2%
034Finished fabrics0.8%3.6%5.1%1.2%5.2%3.3%2.6%
038Apparel & other fabricated textile prods0.4%0.7%5.3%3.7%4.6%2.7%2.2%
039Miscellaneous textile products/services2.5%7.1%7.8%-5.3%6.6%2.6%1.9%
05FUELS AND RELATED PRODUCTS AND POWER6.0%35.0%27.5%-4.7%6.1%3.9%1.0%
051Coal-2.1%-3.9%-0.2%1.2%9.3%4.6%4.8%
053Gas fuels-2.2%-14.4%5.4%-20.2%5.2%2.5%-5.3%
055Utility natural gas-0.8%-2.1%6.5%-0.6%7.6%5.6%0.7%
056Crude petroleum (domestic production)13.4%51.4%32.4%-7.7%5.0%5.4%-0.1%
057Petroleum products, refined11.7%80.2%58.1%-8.8%5.6%4.5%1.2%
058Asphalt and other petroleum and coal products, n.e.c.-4.2%44.4%54.9%-0.9%6.7%4.1%6.9%
06CHEMICALS AND ALLIED PRODUCTS-0.5%7.4%6.5%-1.1%4.0%2.8%2.8%
061Industrial chemicals0.5%15.0%12.9%-4.0%4.4%2.3%2.0%
062Paints and allied products1.5%2.6%5.3%0.6%6.9%4.7%3.9%
063Drugs and pharmaceuticals0.2%0.8%1.2%2.0%2.2%3.0%4.1%
064Fats and oils, inedible-4.0%31.9%26.4%0.1%11.1%7.5%5.1%
065Agricultural chemicals and chemical products-4.8%5.1%3.8%-7.5%7.1%3.0%3.2%
066Plastic resins and materials-4.2%10.7%5.7%-3.3%1.9%1.4%1.0%
067Other chemicals and allied products0.3%3.7%4.1%2.3%5.2%3.2%2.8%
07RUBBER AND PLASTIC PRODUCTS-0.4%5.4%5.7%-0.2%5.5%3.3%2.6%
071Rubber and rubber products-0.4%4.4%4.1%1.3%5.0%3.0%2.7%
072Plastic products-0.4%5.6%6.2%-0.6%5.6%3.4%2.6%
08LUMBER AND WOOD PRODUCTS-0.3%5.7%4.7%-1.0%1.7%3.1%2.1%
081Lumber-1.5%10.6%7.9%-0.3%-2.2%3.0%1.5%
082Millwork-0.3%4.1%3.5%-0.7%4.5%4.1%2.9%
083Plywood1.7%11.3%10.7%-3.0%1.3%3.3%2.0%
084Other wood products0.2%5.5%5.3%-1.7%3.2%2.9%2.0%
085Logs, bolts, timber, pulpwood, woodchips and other roundwood products0.1%-0.4%-1.4%-2.1%1.2%0.9%1.4%
086Prefabricated wood buildings & components0.8%3.5%4.2%1.5%6.9%5.2%3.3%
087Treated wood and contract wood preserving0.7%4.0%3.5%-1.2%2.1%2.8%2.2%
09PULP,PAPER, AND ALLIED PRODUCTS0.8%4.6%4.7%0.8%5.4%3.3%2.6%
091Pulp, paper, and prod., ex. bldg. paper1.4%5.5%5.4%0.5%5.5%3.2%2.8%
092Building paper & building board mill prods.-0.6%7.5%6.9%-11.4%-6.9%1.5%1.2%
094Publications, printed matter & printing material-0.7%1.8%2.7%3.0%6.5%3.9%
10METALS AND METAL PRODUCTS1.0%11.4%16.3%4.2%8.6%6.4%3.8%
101Iron and steel1.1%16.8%17.2%-0.4%7.4%6.6%3.2%
102Nonferrous metals1.0%17.0%31.9%11.3%10.3%8.4%4.7%
103Metal containers0.2%5.9%8.3%1.3%8.4%5.1%3.4%
104Hardware-0.1%2.4%3.7%2.9%6.1%3.9%3.0%
105Plumbing fixtures and fittings0.0%3.6%3.5%3.6%4.9%3.6%3.1%
106Heating equipment0.6%2.3%2.3%3.9%8.6%5.6%4.5%
107Fabricated structural metal products1.2%4.4%7.0%3.0%10.3%6.4%4.1%
108Miscellaneous metal products0.8%4.5%5.3%2.8%6.0%3.7%2.7%
11MACHINERY AND EQUIPMENT0.8%6.1%7.6%3.9%5.6%3.3%2.2%
111Agricultural machinery and equipment-0.3%0.6%2.1%1.4%6.1%3.9%3.2%
112Construction machinery and equipment0.0%0.5%2.1%4.7%6.5%4.1%3.3%
113Metalworking machinery and equipment0.0%3.7%5.2%4.6%5.8%3.5%2.6%
114General purpose machinery and equipment0.3%2.9%5.6%5.4%7.9%5.0%3.9%
115Electronic computers and computer equipment13.3%21.8%22.4%55.4%32.6%13.7%3.7%
116Special industry machinery and equipment0.2%2.9%4.6%3.6%6.6%4.1%2.7%
117Electrical machinery and equipment1.4%11.8%13.0%3.1%4.3%2.5%1.3%
118Miscellaneous instruments0.0%2.2%3.5%5.1%5.7%3.7%2.7%
119Miscellaneous machinery0.3%3.3%3.7%3.1%4.0%2.4%2.2%
12FURNITURE AND HOUSEHOLD DURABLES0.4%2.0%3.3%2.2%5.1%3.5%2.5%
121Household furniture0.3%5.0%5.6%1.3%4.9%3.4%2.6%
122Commercial furniture0.6%2.4%3.6%3.4%7.0%4.7%3.3%
123Floor coverings0.7%2.3%4.8%0.9%2.1%1.6%1.8%
124Household appliances0.1%-1.6%0.1%1.5%4.2%2.9%2.0%
125Home electronic equipment0.0%0.0%-1.5%2.5%4.6%2.6%0.3%
126Other household durable goods0.8%2.5%4.5%3.0%5.1%3.3%2.4%
13NONMETALIC MINERAL PRODUCTS0.4%4.0%4.3%3.9%6.5%4.4%3.8%
131Glass0.1%4.8%4.8%2.1%4.4%3.3%2.3%
132Concrete ingredients and related products-0.1%4.4%4.4%6.8%7.3%5.5%4.5%
133Concrete products0.6%3.7%4.2%4.3%7.1%5.0%3.9%
134Clay construction products ex. refractories0.2%1.0%1.3%2.2%4.2%2.7%1.7%
135Refractories-0.1%1.2%1.7%1.8%4.9%3.7%3.7%
136Asphalt felts and coatings1.4%7.2%4.1%1.4%6.5%4.4%4.6%
137Gypsum products0.7%0.4%0.7%1.4%7.9%5.5%3.3%
138Glass containers0.0%2.3%3.2%5.6%7.3%4.4%3.7%
139Other nonmetallic minerals0.2%3.9%5.3%3.5%6.2%3.4%3.7%
14TRANSPORTATION EQUIPMENT0.2%1.5%2.4%2.0%2.9%1.9%1.7%
141Motor vehicles and equipment0.2%1.3%2.5%1.5%2.8%1.8%1.5%
142Aircraft and aircraft equipment0.0%1.7%2.4%3.1%3.1%2.1%2.3%
143Ships and boats0.1%2.2%2.7%2.5%3.6%2.5%2.4%
144Railroad equipment1.2%3.0%3.0%0.9%1.3%0.7%1.5%
149Transportation equipment, n.e.c.0.0%1.2%1.3%0.5%3.2%2.5%1.7%
15MISCELLANEOUS PRODUCTS1.0%3.7%5.8%5.5%6.3%4.5%3.3%
151Toys, sporting goods, small arms, etc.-0.7%0.5%0.9%3.3%6.2%3.5%2.6%
152Tobacco products, incl. stemmed & redried2.2%7.7%10.5%10.9%10.3%8.0%6.5%
154Photographic equipment and supplies0.0%4.4%4.6%3.4%4.8%3.3%2.6%
155Mobile homes1.0%1.7%3.5%0.2%7.0%6.2%4.5%
156Medical, surgical & personal aid devices0.4%2.6%4.2%2.5%2.6%1.8%1.4%
157Other industrial safety equipment-0.2%3.8%7.1%4.2%6.2%3.5%2.7%
159Other miscellaneous products1.3%-0.5%2.2%4.9%7.3%4.9%3.3%

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

BLS CPI CodeBLS CPI Category Description1M 8/261Y 8/263Y 8/265Y 8/2610Y 8/2620Y 8/26
SAFFOOD & BEVERAGES0.1%2.6%2.6%4.5%3.4%2.9%
SAF11Food at home0.0%2.2%1.9%4.4%3.0%2.6%
SAF114Nonalcoholic beverages & beverage materials0.2%3.7%3.2%5.5%3.6%2.4%
SEFNJuices & nonalcoholic drinks0.4%3.5%2.2%5.0%3.6%2.5%
SEFN01Carbonated drinks1.9%4.4%2.8%5.4%4.2%3.0%
SEFN03Nonfrozen noncarbonated juices & drinks-1.0%3.2%1.4%4.5%3.1%1.9%
SEFPBeverage materials including coffee & tea-0.3%4.0%5.3%6.4%3.4%2.4%
SEFP01Coffee-0.9%6.1%7.9%8.3%4.1%3.0%
SEFP02Other beverage materials including tea1.1%0.4%2.2%3.9%2.6%1.9%
SAF115Other food at home-0.2%2.4%1.4%4.9%3.1%2.6%
SEFT06Other miscellaneous foods-0.9%3.6%1.4%4.8%3.0%2.2%
SEFWAlcoholic beverages at home0.1%0.2%0.8%1.6%1.6%1.4%
SEFW01Beer, ale & other malt beverages at home0.2%2.4%2.4%3.2%2.8%2.4%
SEFW02Distilled spirits at home-0.3%-0.7%0.4%1.0%1.0%0.9%
SEFW03Wine at home0.3%-1.1%-0.4%0.5%0.7%0.6%
SEHEFUEL OIL & OTHER FUELS5.5%30.2%6.3%9.4%7.6%3.2%
SAH3HOUSEHOLD FURNISHINGS & OPERATIONS-0.1%2.0%1.7%3.4%2.6%1.0%
SAAAPPAREL1.9%3.6%1.4%2.4%0.9%0.8%
SAM1MEDICAL CARE COMMODITIES-0.2%-2.7%-0.2%1.5%0.9%1.7%
SEMFMedicinal drugs-0.4%-2.7%-0.3%1.4%0.8%
SEMF01Prescription drugs0.0%-2.9%-0.1%1.2%0.7%8.3%
SEMF02Nonprescription drugs-1.2%-2.0%-0.7%2.3%1.1%
SEMGMedical equipment and supplies1.0%-2.3%0.0%2.7%1.0%
SARRECREATION0.0%2.7%2.2%2.8%2.2%1.3%
SEEAEDUCATIONAL BOOKS & SUPPLIES-0.7%1.1%3.5%2.3%1.2%3.4%
SEGATOBACCO & SMOKING PRODUCTS0.6%-93.3%-57.4%-38.4%-19.5%-7.4%
SEGBPERSONAL CARE PRODUCTS0.2%2.9%1.4%3.0%1.3%0.9%
SEGEMISCELLANEOUS PERSONAL GOODS-0.6%3.6%1.1%2.7%1.5%0.2%
SAGOTHER GOODS AND SERVICES0.1%4.2%4.0%4.9%3.7%3.2%
SEREOther recreational goods-1.6%2.5%-0.1%0.3%-2.4%-3.3%
SERGRecreational reading materials2.9%4.2%3.0%2.3%2.5%2.0%

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.
=