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 February 2025

 PPI CodeBLS PPI Category Description1M 2/25YTD 2/251YR 2/253YR 2/255Y 2/2510YR 2/2520Y2/25
01FARM PRODUCTS7.4%9.2%16.7%3.9%9.8%3.9%4.0%
011Fruits & melons, fresh/dry vegs. & nuts4.1%-11.9%-0.4%2.0%3.9%2.9%3.1%
012Grains2.4%5.8%6.5%-10.6%3.7%1.6%4.1%
013Slaughter livestock2.7%6.0%16.9%13.1%13.5%3.9%4.4%
014Slaughter poultry-4.0%-2.3%0.7%0.2%9.6%3.8%3.7%
015Raw cotton-0.7%-3.1%-26.0%-18.3%0.4%-0.1%1.9%
016Raw milk13.5%9.3%28.5%5.1%7.5%4.6%2.6%
017Chicken eggs53.6%101.8%183.3%75.0%59.2%19.4%14.0%
018Hay, hayseeds and oilseeds-0.9%2.4%-10.4%-12.4%2.6%0.3%3.1%
02PROCESSED FOODS AND FEEDS0.6%1.1%4.1%3.3%5.3%2.6%2.9%
021Cereal and bakery products-0.1%0.0%-0.3%3.8%4.9%2.7%3.2%
022Meats, poultry, and fish-0.3%0.4%5.9%1.6%6.2%2.0%2.6%
023Dairy products0.1%0.8%5.8%1.6%3.3%2.3%2.2%
024Processed fruits and vegetables1.0%1.2%1.5%9.2%7.3%4.2%3.9%
025Sugar and confectionery-2.0%-2.5%9.3%8.4%5.8%3.3%3.3%
026Beverages and beverage materials-0.4%0.2%2.3%4.8%4.3%2.8%2.5%
027Fats and oils-0.1%-2.1%-2.3%-8.2%5.8%2.5%3.1%
028Miscellaneous processed foods5.1%6.2%7.4%7.6%6.7%3.6%3.2%
029Prepared animal feeds0.9%1.1%-0.7%-0.9%4.2%1.5%3.8%
03TEXTILE PRODUCTS AND APPAREL-0.4%0.2%0.5%1.7%4.4%2.6%2.1%
031Synthetic fibers-3.3%-0.9%1.4%1.9%4.8%3.0%2.1%
032Processed yarns and threads-0.3%-0.3%0.5%-1.2%4.8%2.5%2.4%
033Greige fabrics0.0%-0.4%-2.5%1.2%4.1%1.8%2.0%
034Finished fabrics0.5%0.6%1.5%2.0%4.9%2.9%2.6%
038Apparel & other fabricated textile prods0.2%0.5%1.5%2.8%3.4%2.2%1.9%
039Miscellaneous textile products/services0.2%0.7%-8.7%0.1%6.7%2.3%1.8%
04HIDES, SKINS, LEATHER, AND RELATED PRODUCTS-1.1%-1.2%-2.7%-0.1%1.4%-2.5%0.3%
041Hides and skins, incl. cattle-10.7%-10.9%-22.2%-14.4%-7.4%-12.4%-4.2%
042Leather0.1%-0.2%-1.7%0.3%1.9%-3.8%-0.5%
043Footwear1.3%1.4%2.7%5.0%4.4%3.0%2.9%
044Other leather and related products0.1%0.1%1.3%3.3%3.1%2.3%2.1%
05FUELS AND RELATED PRODUCTS AND POWER0.8%6.0%-3.5%-3.3%7.8%3.5%2.6%
051Coal-2.2%-1.5%-0.6%7.5%7.7%3.6%4.7%
053Gas fuels-8.1%6.2%15.7%-18.7%16.0%1.3%-2.4%
055Utility natural gas1.0%5.0%4.1%0.8%9.9%4.0%1.8%
056Crude petroleum (domestic production)-4.8%8.7%-4.4%-7.0%9.2%4.6%2.6%
057Petroleum products, refined2.8%7.8%-12.6%-6.4%7.5%4.2%3.3%
058Asphalt and other petroleum and coal products, n.e.c.11.1%23.3%16.9%-5.1%8.6%2.0%7.8%
06CHEMICALS AND ALLIED PRODUCTS0.5%1.3%1.0%-0.6%4.1%2.7%3.2%
061Industrial chemicals0.0%2.1%2.4%-3.7%4.6%2.3%2.7%
062Paints and allied products0.2%0.5%1.1%3.6%6.4%3.8%3.9%
063Drugs and pharmaceuticals0.4%0.1%0.5%2.0%2.0%3.4%4.4%
064Fats and oils, inedible1.1%1.2%-0.8%-2.6%10.9%4.4%4.8%
065Agricultural chemicals and chemical products2.1%2.2%2.3%-5.8%7.2%2.2%3.4%
066Plastic resins and materials2.5%2.3%-1.9%-4.1%4.4%1.1%1.7%
067Other chemicals and allied products-0.2%1.4%1.5%4.2%4.8%3.1%2.8%
07RUBBER AND PLASTIC PRODUCTS-0.3%-0.1%1.0%1.4%5.4%3.0%3.0%
071Rubber and rubber products0.1%0.6%2.2%3.0%4.7%2.7%2.9%
072Plastic products-0.5%-0.4%0.6%0.9%5.6%3.1%3.0%
08LUMBER AND WOOD PRODUCTS0.4%0.4%0.9%-5.7%4.8%3.0%2.1%
081Lumber1.6%1.4%7.0%-14.0%4.6%2.6%1.4%
082Millwork0.4%0.1%-0.3%-0.4%6.0%4.2%3.0%
083Plywood0.8%0.5%-4.4%-9.3%6.8%2.9%1.7%
084Other wood products-0.3%0.6%-0.2%-2.2%3.6%2.6%2.1%
085Logs, bolts, timber, pulpwood, woodchips and other roundwood products0.5%0.6%-1.1%-1.7%2.0%0.5%1.3%
086Prefabricated wood buildings & components0.4%2.2%2.9%1.8%7.8%5.2%3.4%
087Treated wood and contract wood preserving-2.3%-3.4%-2.2%-1.4%5.1%3.0%2.3%
09PULP,PAPER, AND ALLIED PRODUCTS0.3%0.1%2.2%2.8%5.8%3.1%2.7%
091Pulp, paper, and prod., ex. bldg. paper0.4%0.0%2.5%2.4%5.7%2.9%2.8%
092Building paper & building board mill prods.-1.8%-4.6%-6.6%-11.7%8.3%4.9%2.1%
094Publications, printed matter & printing material0.3%0.8%2.3%5.8%6.1%3.6%
10METALS AND METAL PRODUCTS1.3%2.0%-0.1%-1.5%7.4%4.2%3.4%
101Iron and steel2.6%3.0%-12.2%-8.5%7.5%3.6%2.6%
102Nonferrous metals2.0%3.5%13.1%1.1%7.6%4.6%4.2%
103Metal containers-0.3%1.7%1.3%0.3%6.7%4.2%3.1%
104Hardware0.3%0.7%1.3%2.1%5.1%3.3%2.8%
105Plumbing fixtures and fittings0.5%1.6%2.2%3.7%3.8%3.0%2.8%
106Heating equipment0.1%0.4%2.0%4.8%7.4%5.1%4.1%
107Fabricated structural metal products0.1%0.1%-0.9%1.3%9.0%5.4%3.8%
108Miscellaneous metal products0.3%0.7%3.0%3.8%5.6%3.3%2.6%
11MACHINERY AND EQUIPMENT0.2%0.8%2.4%4.6%4.7%2.9%2.0%
111Agricultural machinery and equipment0.2%0.1%1.0%4.0%5.9%3.8%3.1%
112Construction machinery and equipment-0.5%0.2%0.2%5.3%5.4%3.6%3.2%
113Metalworking machinery and equipment0.3%0.7%2.6%5.3%5.0%3.2%2.5%
114General purpose machinery and equipment0.4%0.8%3.0%6.2%6.8%4.4%3.8%
115Electronic computers and computer equipment0.0%-0.1%-1.6%53.8%30.9%12.8%3.1%
116Special industry machinery and equipment0.1%0.3%1.9%4.6%6.0%3.7%2.6%
117Electrical machinery and equipment-0.1%0.5%2.1%3.3%3.4%2.1%1.0%
118Miscellaneous instruments0.4%2.9%5.7%5.9%5.0%3.4%2.5%
119Miscellaneous machinery0.3%0.9%2.2%4.5%3.8%2.3%2.2%
12FURNITURE AND HOUSEHOLD DURABLES0.7%1.3%2.2%3.3%4.7%3.2%2.4%
121Household furniture0.4%1.0%2.6%2.6%4.6%3.2%2.7%
122Commercial furniture0.5%1.0%3.0%4.9%6.4%4.3%3.3%
123Floor coverings2.0%2.0%1.7%3.0%2.0%1.7%2.2%
124Household appliances0.6%2.0%0.5%2.9%3.9%2.5%1.9%
125Home electronic equipment0.0%0.0%1.5%2.4%3.7%2.1%-0.1%
126Other household durable goods0.7%0.8%2.6%2.2%4.7%2.9%2.2%
13NONMETALIC MINERAL PRODUCTS0.1%2.6%3.5%6.6%6.5%4.5%4.0%
131Glass0.1%1.0%2.2%3.8%4.6%3.5%2.3%
132Concrete ingredients and related products1.2%3.8%5.7%8.7%7.4%5.7%4.8%
133Concrete products-0.1%1.1%3.0%7.9%7.2%5.2%4.2%
134Clay construction products ex. refractories-0.2%0.2%-0.2%4.2%4.1%2.7%1.8%
135Refractories0.3%1.1%2.0%3.7%4.6%3.7%3.9%
136Asphalt felts and coatings-0.7%-1.0%-0.8%3.5%6.7%4.0%5.2%
137Gypsum products0.0%0.1%3.0%5.2%8.2%4.6%4.1%
138Glass containers0.0%1.2%4.9%6.0%6.8%4.2%3.6%
139Other nonmetallic minerals-0.2%5.9%4.5%6.4%5.8%3.5%4.0%
14TRANSPORTATION EQUIPMENT0.2%0.4%1.7%2.6%2.7%1.8%1.6%
141Motor vehicles and equipment0.1%0.3%1.4%2.1%2.6%1.7%1.3%
142Aircraft and aircraft equipment0.5%0.7%2.6%3.9%2.9%2.0%2.3%
143Ships and boats0.1%0.3%1.7%2.7%3.3%2.3%2.5%
144Railroad equipment0.2%0.0%-0.1%0.9%1.1%0.7%1.7%
149Transportation equipment, n.e.c.0.1%-0.4%-1.6%0.3%2.9%2.4%1.7%
15MISCELLANEOUS PRODUCTS1.1%1.3%5.3%5.9%5.9%4.2%3.4%
151Toys, sporting goods, small arms, etc.0.0%-1.0%-0.7%4.4%5.7%3.4%2.5%
152Tobacco products, incl. stemmed & redried2.3%2.4%10.7%11.1%9.8%7.6%6.2%
153Notions-0.6%4.1%4.1%5.4%5.8%3.5%3.8%
154Photographic equipment and supplies9.0%6.5%8.6%6.3%5.4%3.6%2.9%
155Mobile homes0.2%0.3%1.7%0.1%8.3%6.1%4.5%
156Medical, surgical & personal aid devices-0.1%0.9%2.1%2.6%2.5%1.6%1.3%
157Other industrial safety equipment-0.6%1.2%3.2%6.2%5.6%3.2%2.5%
159Other miscellaneous products0.7%1.0%5.8%5.6%6.3%4.4%3.1%

BLS CPI Historical Annual Inflation Rate Averages Through February 2025 Table for Selected Categories

BLS CPI CodeBLS CPI Category Description1M 1/251Y 1/253Y 1/255Y 1/2510Y 1/2520Y 1/25
SAFFOOD & BEVERAGES0.6%0.6%2.4%4.9%5.0%3.1%
SAF11Food at home0.8%0.8%1.9%4.7%5.0%2.5%
SAF114Nonalcoholic beverages & beverage materials2.2%2.2%2.2%6.1%5.5%3.0%
SEFNJuices & nonalcoholic drinks2.5%2.5%1.9%6.5%5.8%3.4%
SEFN01Carbonated drinks3.4%3.4%1.0%6.6%6.2%3.8%
SEFN03Nonfrozen noncarbonated juices & drinks1.4%1.4%2.1%6.2%5.4%3.1%
SEFPBeverage materials including coffee & tea1.2%1.2%3.2%5.2%4.8%1.8%
SEFP01Coffee1.9%1.9%3.1%4.7%5.0%1.6%
SEFP02Other beverage materials including tea0.6%0.6%3.7%6.2%4.5%2.4%
SAF115Other food at home0.5%0.5%0.8%5.4%5.4%2.8%
SEFT06Other miscellaneous foods-0.8%-0.8%0.1%4.9%5.1%2.6%
SEFWAlcoholic beverages at home0.4%0.4%0.8%2.4%2.2%1.5%
SEFW01Beer, ale & other malt beverages at home0.0%0.0%1.8%4.3%3.4%2.6%
SEFW02Distilled spirits at home0.5%0.5%0.8%1.0%1.6%0.8%
SEFW03Wine at home0.6%0.6%-0.2%1.3%1.4%0.8%
SEHEFUEL OIL & OTHER FUELS5.8%5.8%-1.3%1.5%5.6%3.2%
SAH3HOUSEHOLD FURNISHINGS & OPERATIONS0.5%0.5%0.4%2.1%3.6%1.9%
SAAAPPAREL0.9%0.9%0.4%1.2%1.2%0.5%
SAM1MEDICAL CARE COMMODITIES1.2%1.2%2.3%2.9%1.5%1.8%
SEMFMedicinal drugs1.4%1.4%2.6%2.9%1.6%1.8%
SEMF01Prescription drugs2.5%2.5%4.5%2.5%1.3%2.0%
SEMF02Nonprescription drugs-1.0%-1.0%-1.3%4.2%2.6%1.1%
SEMGMedical equipment and supplies-0.6%-0.6%-0.3%3.3%1.5%1.0%
SARRECREATION1.2%1.2%1.6%3.1%2.8%2.0%
SEEAEDUCATIONAL BOOKS & SUPPLIES0.9%0.9%9.9%2.5%2.6%1.7%
SEGATOBACCO & SMOKING PRODUCTS0.4%0.4%6.8%6.8%6.8%5.7%
SEGBPERSONAL CARE PRODUCTS0.4%0.4%0.4%3.6%2.3%0.8%
SEGEMISCELLANEOUS PERSONAL GOODS1.0%1.0%-2.4%1.8%2.2%0.4%
SAGOTHER GOODS AND SERVICES-0.1%-0.1%2.4%4.8%4.2%3.2%
SEREOther recreational goods1.6%1.6%-2.1%-1.2%-0.9%-3.7%
SERGRecreational reading materials2.1%2.1%1.9%1.8%2.0%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!

Click or drag files to this area 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.
=