LIFO Inventory & Reserve Calculator            
    Current     Increase               ----LIFO Expense Components----  
Year Cumulative Inventory (Decrease) Cumulative Priced
  -Layers Remaining-
Layer Total
Period Current Deflator Deflator At Base At Base Inflator Increase     LIFO        LIFO   LIFO Layer Layer Inflation Erosion   LIFO
End Year Cost Index Index Prices Prices Index (Decrease) Inventory Reserve Expense At Base At Cost Effect Effect Expense
2006  $               -    $             -    $             -  
2007
2008
2009
2010
2011
2012
2013
2014
2015
        Totals:        
The LIFO calculator calculates the LIFO inventory balance for up to 10 Periods.  Shown above are the balances that would result from the current-year cost (FIFO) inventory balances & the LIFO indexes entered in columns B & C.  
Change current-year cost (FIFO inventory balance) and Current year deflator index values by clicking the appropriate cell with your mouse. All values to the right of the input cells will automatically update upon entering in new values. The base year (first year end/period of LIFO election) current-year cost (FIFO inventory balance) value should be entered on the first row of column B.  A current year deflator index of 1.00 should be entered in the first row of Column C. Hit the "F5" button on your keyboard (or click the refresh button in your internet browser screen) to refresh the LIFO Calculator to its original values.
LIFO Projections Calculator LIFO Inflation Calculator LIFO-PRO Homepage