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 October 2024

 PPI CodeBLS PPI Category Description1M 10/24YTD 10/241YR 10/243YR 10/245Y 10/2410YR 10/2420Y 10/24
01FARM PRODUCTS0.1%1.4%2.8%3.7%6.5%1.2%3.1%
011Fruits & melons, fresh/dry vegs. & nuts-0.5%-1.2%8.4%2.0%2.0%2.2%1.9%
012Grains-1.3%-17.7%-17.6%-10.4%0.4%0.8%3.4%
013Slaughter livestock0.5%15.7%6.5%13.1%11.5%1.3%3.8%
014Slaughter poultry1.6%1.3%13.2%6.1%10.7%1.7%3.8%
015Raw cotton3.2%-15.8%-18.2%-13.8%1.7%-0.6%2.0%
016Raw milk14.4%26.0%26.4%17.0%8.9%1.0%3.0%
017Chicken eggs-20.6%46.9%99.6%34.8%29.2%6.9%8.1%
018Hay, hayseeds and oilseeds-3.6%-22.9%-21.2%-7.4%1.1%-0.1%3.1%
02PROCESSED FOODS AND FEEDS-0.5%3.4%1.8%4.0%4.9%2.0%2.9%
021Cereal and bakery products0.4%-0.4%-0.8%5.6%5.0%2.8%3.2%
022Meats, poultry, and fish-2.0%7.1%2.7%0.5%5.2%1.0%2.7%
023Dairy products-0.4%7.7%5.7%5.2%3.6%0.6%2.3%
024Processed fruits and vegetables0.6%1.7%2.0%10.2%7.3%4.3%3.9%
025Sugar and confectionery0.5%10.3%11.3%8.6%5.6%3.2%3.4%
026Beverages and beverage materials0.8%3.8%2.6%6.1%4.5%2.9%2.6%
027Fats and oils0.5%-7.9%-9.5%-4.4%6.4%2.2%2.9%
028Miscellaneous processed foods-1.1%1.7%2.0%6.4%5.1%2.8%2.8%
029Prepared animal feeds0.1%-4.3%-5.7%1.3%4.2%1.3%3.7%
03TEXTILE PRODUCTS AND APPAREL0.5%1.2%0.4%3.2%4.3%2.5%2.2%
031Synthetic fibers3.6%4.6%-0.1%2.6%4.8%3.0%2.2%
032Processed yarns and threads-0.2%0.7%-0.2%1.3%4.8%2.3%2.4%
033Greige fabrics-0.2%-0.7%-1.3%3.4%3.9%1.8%2.0%
034Finished fabrics0.3%0.6%0.9%3.4%4.7%2.8%2.6%
038Apparel & other fabricated textile prods0.2%1.9%1.7%3.9%3.3%2.2%1.9%
039Miscellaneous textile products/services-3.5%-7.0%-5.3%4.9%6.9%2.4%2.0%
04HIDES, SKINS, LEATHER, AND RELATED PRODUCTS0.5%-1.0%-0.7%-0.6%1.6%-2.7%0.3%
041Hides and skins, incl. cattle1.3%-11.8%-11.6%-14.5%-5.6%-12.2%-3.8%
042Leather1.1%-0.8%-0.5%-2.6%2.2%-4.3%-0.5%
043Footwear0.2%1.9%2.0%5.8%4.0%2.9%2.8%
044Other leather and related products0.1%1.7%1.9%3.9%3.1%2.4%2.1%
05FUELS AND RELATED PRODUCTS AND POWER1.0%-0.5%-10.5%-1.8%5.4%0.8%2.4%
051Coal-2.7%1.6%-2.4%13.0%7.4%3.9%4.9%
053Gas fuels10.2%-14.0%-16.1%-25.7%3.9%-5.8%-3.6%
055Utility natural gas0.2%-5.2%-0.6%-1.4%7.4%2.7%1.7%
056Crude petroleum (domestic production)10.8%5.5%-17.7%-4.0%6.6%-1.3%1.8%
057Petroleum products, refined3.1%-1.6%-17.5%-3.3%5.1%-0.4%2.9%
058Asphalt and other petroleum and coal products, n.e.c.-2.3%-9.6%-28.2%-3.6%1.7%-0.7%6.2%
06CHEMICALS AND ALLIED PRODUCTS0.8%2.2%0.5%0.3%4.1%2.1%3.4%
061Industrial chemicals1.3%2.7%-2.4%-2.5%4.5%0.6%2.9%
062Paints and allied products-0.1%0.5%-0.2%6.5%6.4%3.8%4.1%
063Drugs and pharmaceuticals0.2%2.3%2.4%2.8%2.4%3.7%4.4%
064Fats and oils, inedible-0.2%10.4%0.9%-2.3%12.0%4.2%4.9%
065Agricultural chemicals and chemical products0.2%-0.2%2.5%-0.8%6.0%1.8%3.4%
066Plastic resins and materials3.5%3.7%3.0%-6.0%3.8%0.3%2.3%
067Other chemicals and allied products-0.3%0.9%0.9%5.5%4.6%2.9%3.0%
07RUBBER AND PLASTIC PRODUCTS0.1%1.3%1.4%3.4%5.4%2.9%3.2%
071Rubber and rubber products0.3%2.4%2.2%4.5%4.7%2.4%3.0%
072Plastic products0.1%1.0%1.2%3.1%5.7%3.1%3.2%
08LUMBER AND WOOD PRODUCTS0.7%1.1%0.3%0.2%4.8%2.8%2.1%
081Lumber1.1%7.3%3.9%-3.9%4.3%1.9%1.1%
082Millwork0.4%1.5%1.1%2.8%6.2%4.3%3.0%
083Plywood1.0%-4.2%-5.1%1.5%6.8%2.5%1.8%
084Other wood products0.8%-3.3%-1.7%-1.1%3.4%2.6%2.2%
085Logs, bolts, timber, pulpwood, woodchips and other roundwood products-0.1%-1.4%-3.3%-0.5%1.8%0.6%1.4%
086Prefabricated wood buildings & components2.4%1.7%1.3%4.2%7.4%5.1%3.3%
087Treated wood and contract wood preserving0.4%-1.1%-0.9%5.9%5.6%3.0%2.6%
09PULP,PAPER, AND ALLIED PRODUCTS0.1%3.4%2.2%4.1%5.8%3.1%2.7%
091Pulp, paper, and prod., ex. bldg. paper-0.2%4.3%3.2%3.2%5.6%2.9%2.9%
092Building paper & building board mill prods.0.3%-10.1%-22.1%-7.3%7.6%4.4%2.4%
094Publications, printed matter & printing material0.6%2.5%2.8%7.9%6.1%3.6%
10METALS AND METAL PRODUCTS0.7%-0.7%1.3%-1.7%7.4%3.7%3.4%
101Iron and steel0.4%-10.3%-6.8%-11.0%7.6%2.5%2.5%
102Nonferrous metals2.7%9.3%11.4%2.0%7.8%3.9%4.4%
103Metal containers-0.4%0.6%-0.1%5.7%6.7%4.0%3.3%
104Hardware0.5%0.2%0.0%3.7%5.0%3.2%2.8%
105Plumbing fixtures and fittings0.0%1.6%1.6%4.4%3.7%3.0%3.0%
106Heating equipment0.1%2.3%2.5%6.9%7.3%5.0%4.3%
107Fabricated structural metal products-0.5%-2.0%-0.4%3.2%8.8%5.3%3.8%
108Miscellaneous metal products-0.1%2.5%2.8%4.9%5.3%3.2%2.6%
11MACHINERY AND EQUIPMENT0.1%2.6%2.8%5.6%4.6%2.8%1.9%
111Agricultural machinery and equipment0.5%0.7%0.3%6.1%6.2%3.8%3.3%
112Construction machinery and equipment0.1%0.9%2.6%6.7%5.6%3.6%3.2%
113Metalworking machinery and equipment0.6%3.4%3.8%6.2%4.9%3.1%2.5%
114General purpose machinery and equipment0.0%3.2%3.0%7.7%6.7%4.4%3.8%
115Electronic computers and computer equipment-0.1%2.3%3.2%56.6%30.9%12.7%2.9%
116Special industry machinery and equipment0.1%2.8%2.9%6.3%6.1%3.7%2.6%
117Electrical machinery and equipment0.2%2.4%2.6%4.0%3.4%1.9%1.0%
118Miscellaneous instruments0.1%3.4%3.7%6.3%4.5%3.1%2.4%
119Miscellaneous machinery-0.1%2.6%2.8%4.8%3.6%2.2%2.3%
12FURNITURE AND HOUSEHOLD DURABLES0.4%1.5%1.6%4.0%4.6%3.1%2.5%
121Household furniture-0.2%1.4%2.0%3.2%4.4%3.1%2.7%
122Commercial furniture0.0%2.9%3.2%6.0%6.3%4.2%3.3%
123Floor coverings3.4%3.5%1.0%1.4%2.0%1.7%2.3%
124Household appliances0.4%-1.0%-0.5%3.5%3.9%2.5%2.0%
125Home electronic equipment0.0%1.5%1.6%3.8%3.8%2.1%0.0%
126Other household durable goods0.0%1.1%1.3%3.7%4.4%2.8%2.2%
13NONMETALIC MINERAL PRODUCTS0.0%3.8%3.7%7.6%6.3%4.4%4.0%
131Glass-0.5%1.4%2.2%4.3%4.5%3.6%2.3%
132Concrete ingredients and related products-0.1%6.7%6.6%9.0%7.0%5.5%4.7%
133Concrete products-0.3%3.4%2.9%9.1%7.2%5.3%4.3%
134Clay construction products ex. refractories-0.1%0.5%0.9%4.7%4.3%2.7%2.0%
135Refractories0.5%1.7%2.0%5.5%4.4%3.6%3.9%
136Asphalt felts and coatings2.2%2.4%2.4%6.8%7.5%3.8%5.5%
137Gypsum products0.0%5.0%4.7%6.3%8.4%5.0%4.1%
138Glass containers0.1%7.5%6.6%9.5%7.1%4.3%3.6%
139Other nonmetallic minerals0.1%3.3%3.4%6.9%5.2%2.9%3.9%
14TRANSPORTATION EQUIPMENT0.3%1.5%1.6%2.9%2.5%1.7%1.6%
141Motor vehicles and equipment0.5%0.9%0.9%2.5%2.4%1.6%1.2%
142Aircraft and aircraft equipment0.0%3.3%3.6%3.9%2.8%2.0%2.3%
143Ships and boats-0.2%1.5%1.7%3.6%3.2%2.4%2.5%
144Railroad equipment-0.8%0.2%0.2%1.4%1.2%0.9%2.0%
149Transportation equipment, n.e.c.0.0%-1.5%-1.9%2.9%3.2%2.5%1.8%
15MISCELLANEOUS PRODUCTS0.0%4.7%5.2%6.4%5.6%4.1%3.4%
151Toys, sporting goods, small arms, etc.0.1%3.1%4.4%6.8%6.0%3.6%2.6%
152Tobacco products, incl. stemmed & redried0.4%9.6%9.5%10.6%9.4%7.5%6.1%
153Notions0.0%-0.1%1.7%5.1%5.0%3.1%3.6%
154Photographic equipment and supplies-5.9%-0.9%-0.2%4.4%4.1%2.9%2.6%
155Mobile homes0.1%1.5%-0.6%2.9%8.3%6.2%4.7%
156Medical, surgical & personal aid devices-0.1%1.7%2.2%2.9%2.2%1.6%1.3%
157Other industrial safety equipment0.2%3.6%3.8%6.5%5.6%3.2%2.4%
159Other miscellaneous products0.5%5.0%5.9%7.3%6.3%4.3%3.1%

BLS CPI Historical Annual Inflation Rate Averages Through October 2024 Table for Selected Categories

BLS CPI CodeBLS CPI Category Description1M 10/241Y 10/243Y 10/245Y 10/2410Y 10/2420Y 10/24
SAFFOOD & BEVERAGES0.2%2.2%2.1%5.3%4.9%2.4%
SAF11Food at home0.1%1.7%1.1%5.1%4.9%2.4%
SAF114Nonalcoholic beverages & beverage materials0.5%2.2%1.7%5.8%5.3%2.6%
SEFNJuices & nonalcoholic drinks0.7%2.2%2.0%6.1%5.7%2.8%
SEFN01Carbonated drinks0.7%2.7%2.3%6.1%6.3%3.1%
SEFN03Nonfrozen noncarbonated juices & drinks0.7%1.5%1.5%5.9%5.1%2.5%
SEFPBeverage materials including coffee & tea0.1%2.4%1.1%5.1%4.2%2.1%
SEFP01Coffee0.7%2.4%-0.1%4.8%4.3%2.1%
SEFP02Other beverage materials including tea-0.7%2.3%3.0%5.5%4.2%2.1%
SAF115Other food at home0.2%1.1%0.4%6.3%5.3%2.6%
SEFT06Other miscellaneous foods0.7%0.4%0.4%6.0%5.3%2.6%
SEFWAlcoholic beverages at home-0.2%1.6%1.1%2.5%2.2%1.1%
SEFW01Beer, ale & other malt beverages at home0.1%2.7%2.6%4.4%3.6%1.8%
SEFW02Distilled spirits at home-0.4%0.7%0.1%0.9%1.8%0.9%
SEFW03Wine at home-0.3%1.1%0.3%1.5%1.2%0.6%
SEHEFUEL OIL & OTHER FUELS1.6%-7.1%-11.9%1.8%5.1%2.5%
SAH3HOUSEHOLD FURNISHINGS & OPERATIONS-0.1%0.8%-0.6%3.1%3.5%1.7%
SAAAPPAREL-1.7%5.9%0.3%2.3%1.1%0.5%
SAM1MEDICAL CARE COMMODITIES-0.2%0.6%1.0%2.9%1.5%0.7%
SEMFMedicinal drugs-0.2%0.6%0.9%2.8%1.5%0.7%
SEMF01Prescription drugs0.2%1.5%1.6%2.3%1.2%0.6%
SEMF02Nonprescription drugs-1.1%-1.0%-0.5%4.1%2.2%1.1%
SEMGMedical equipment and supplies0.0%0.3%2.1%4.5%1.7%0.8%
SARRECREATION0.3%1.0%1.0%2.8%2.7%1.3%
SEEAEDUCATIONAL BOOKS & SUPPLIES2.5%2.5%1.3%1.0%0.5%
SEGATOBACCO & SMOKING PRODUCTS0.6%5.7%6.8%6.9%6.7%3.3%
SEGBPERSONAL CARE PRODUCTS0.3%1.7%0.0%3.9%2.2%1.1%
SEGEMISCELLANEOUS PERSONAL GOODS1.5%-1.3%-2.4%3.1%2.4%1.2%
SAGOTHER GOODS AND SERVICES0.4%3.3%3.3%5.3%4.4%2.2%
SEREOther recreational goods-1.0%-1.2%-2.8%-0.4%-1.0%-0.5%
SERGRecreational reading materials3.4%4.2%3.5%2.7%2.6%1.3%

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