** PLEASE DESCRIBE THIS IMAGE **

 

LIFO Calculators


Click on button links below to use any of LIFO-PRO’s calculators:


LIFO Reserve Calculator
LIFO Inflation Calculator
LIFO Projections Calculator

LIFO Reserve Calculator


Year EndCurrent-Year Cost (LIFO Inventory Balance)Current Year Deflator IndexCumulative Deflator IndexInventory At Base PricesIncrease (Decrease) At Bsae PricesCumulative Inflator IndexPriced Increase (Decrease) LIFO Inventory Balance LIFO ReserveLIFO ExpenseLIFO Layer Remaining At BaseLIFO Layer Remaining At CostLIFO Inflation EffectLIFO Layer Erosion EffectTotal LIFO Expense
2006 $21,920,010 1.000000 1.000000 $21,920,010 $21,920,010 1.000000 $21,920,010 $21,920,010 $0 $0 $21,920,010 $21,920,010 $0 $0 $0
2007 $22,522,762 1.027210 1.027210 $21,926,151 $6,141 1.027210 $6,309 $21,926,319 $596,443 $596,443 $6,141 $6,309 $596,443 $0 $596,443
2008 $23,259,051 1.032669 1.060768 $21,926,616 $465 1.060768 $493 $21,926,811 $1,332,240 $735,796 $465 $493 $735,796 $0 $735,796
2009 $24,505,175 1.047507 1.111162 $22,053,651 $127,035 1.111162 $141,156 $22,067,968 $2,437,207 $1,104,968 $127,028 $141,148 $1,104,968 $0 $1,104,968
2010 $25,300,997 1.032476 1.147248 $22,053,644 -$7 1.111162 -$8 $22,067,960 $3,233,037 $795,830 $0 $0 $795,830 $0 $795,830
2011 $25,789,810 1.013539 1.162781 $22,179,431 $125,787 1.162781 $146,263 $22,214,223 $3,575,587 $342,550 $125,787 $146,263 $342,550 $0 $342,550
2012 $29,843,743 1.024264 1.190994 $25,057,840 $2,878,409 1.190994 $3,428,169 $25,642,392 $4,201,351 $625,764 $2,878,409 $3,428,169 $625,764 $0 $625,764
2013 $37,613,136 1.020149 1.214992 $30,957,529 $5,899,688 1.214992 $7,168,071 $32,810,463 $4,802,673 $601,322 $4,404,098 $5,350,942 $601,322 $0 $601,322
2014 $41,081,647 1.015524 1.233853 $33,295,412 $2,337,883 1.233853 $2,884,605 $35,695,068 $5,386,579 $583,906 $0 $0 $583,906 $0 $583,906
2015 $36,636,810 1.007843 1.243530 $29,461,938 -$3,833,474 1.226494 -$4,701,734 $30,993,334 $5,643,476 $256,897 $0 $0 $322,203 -$65,306 $256,897
Totals: $29,461,938 $30,993,334 $5,643,476 $29,461,938 $30,993,334 $5,708,783 -$65,306 $5,643,476



The LIFO Calculator automatically computes the following for 10 periods:

  • Cumulative Deflator Index
  • Inventory at base prices
  • Cumulative inflator index
  • Increments (decrements)
  • LIFO inventory balance
  • LIFO Reserve
  • LIFO Expense
  • Layers remaining at base prices
  • Layers remaining at cost
  • Inflation effect of LIFO expense
  • Layer erosion effect of LIFO expense

Click here to use the LIFO Reserve Calculator

LIFO Inflation Calculator


LIFO Inflation Calculator

The LIFO Inflation Calculator outputs the following values:

  • Total number of years for calculated index
  • Cumulative inflation as a percentage
  • Simple annual average inflation as a percentage
  • Actual annual average inflation as a percentage

Click here to use the LIFO Inflation Calculator

LIFO Projections Calculator


LIFO Expense Resulting from the Inflation Index Values Listed Below:

FIFO Values0.98000.99001.001.01001.02001.03001.04001.05001.06001.0700
$40,000,000 -$818,558 -$409,481 -$8,585 $384,373 $769,625 $1,147,396 $1,517,371 $1,875,265 $2,226,406 $2,570,987
$40,500,000 -$822,062 -$410,601 -$4,694 $393,176 $783,243 $1,165,737 $1,540,875 $1,908,868 $2,265,533 $2,614,422
$41,000,000 -$822,062 -$411,031 -$803 $401,978 $796,862 $1,184,078 $1,563,847 $1,936,383 $2,301,890 $2,657,856
$41,500,000 -$822,062 -$411,031 - $410,781 $810,481 $1,202,419 $1,586,819 $1,963,898 $2,333,863 $2,696,916
$42,000,000 -$822,062 -$411,031 - $411,031 $822,062 $1,220,759 $1,609,792 $1,991,414 $2,365,835 $2,733,263
$42,500,000 -$822,062 -$411,031 - $411,031 $822,062 $1,233,094 $1,632,764 $2,018,929 $2,397,808 $2,769,609
$43,000,000 -$822,062 -$411,031 - $411,031 $822,062 $1,233,094 $1,644,125 $2,046,444 $2,429,780 $2,805,956
$43,500,000 -$822,062 -$411,031 - $411,031 $822,062 $1,233,094 $1,644,125 $2,055,156 $2,461,753 $2,842,303
$44,000,000 -$822,062 -$411,031 - $411,031 $822,062 $1,233,094 $1,644,125 $2,055,156 $2,466,187 $2,877,223
$44,500,000 -$822,062 -$411,031 - $411,031 $822,062 $1,233,094 $1,644,125 $2,055,156 $2,466,187 $2,877,223
$45,000,000 -$822,062 -$411,031 - $411,031 $822,062 $1,233,094 $1,644,125 $2,055,156 $2,466,187 $2,877,223
$45,500,000 -$822,062 -$411,031 - $411,031 $822,062 $1,233,094 $1,644,125 $2,055,156 $2,466,187 $2,877,223
$46,000,000 -$822,062 -$411,031 - $411,031 $822,062 $1,233,094 $1,644,125 $2,055,156 $2,466,187 $2,877,223
$46,500,000 -$822,062 -$411,031 - $411,031 $822,062 $1,233,094 $1,644,125 $2,055,156 $2,466,187 $2,877,223
$47,000,000 -$822,062 -$411,031 - $411,031 $822,062 $1,233,094 $1,644,125 $2,055,156 $2,466,187 $2,877,223
$47,500,000 -$822,062 -$411,031 - $411,031 $822,062 $1,233,094 $1,644,125 $2,055,156 $2,466,187 $2,877,223
$48,000,000 -$822,062 -$411,031 - $411,031 $822,062 $1,233,094 $1,644,125 $2,055,156 $2,466,187 $2,877,223
$48,500,000 -$822,062 -$411,031 - $411,031 $822,062 $1,233,094 $1,644,125 $2,055,156 $2,466,187 $2,877,223
$49,000,000 -$822,062 -$411,031 - $411,031 $822,062 $1,233,094 $1,644,125 $2,055,156 $2,466,187 $2,877,223
$49,500,000 -$822,062 -$411,031 - $411,031 $822,062 $1,233,094 $1,644,125 $2,055,156 $2,466,187 $2,877,223
$50,000,000 -$822,062 -$411,031 - $411,031 $822,062 $1,233,094 $1,644,125 $2,055,156 $2,466,187 $2,877,223
$50,500,000 -$822,062 -$411,031 - $411,031 $822,062 $1,233,094 $1,644,125 $2,055,156 $2,466,187 $2,877,223
$51,000,000 -$822,062 -$411,031 - $411,031 $822,062 $1,233,094 $1,644,125 $2,055,156 $2,466,187 $2,877,223
$51,500,000 -$822,062 -$411,031 - $411,031 $822,062 $1,233,094 $1,644,125 $2,055,156 $2,466,187 $2,877,223
$52,000,000 -$822,062 -$411,031 - $411,031 $822,062 $1,233,094 $1,644,125 $2,055,156 $2,466,187 $2,877,223
$52,500,000 -$822,062 -$411,031 - $411,031 $822,062 $1,233,094 $1,644,125 $2,055,156 $2,466,187 $2,877,223
$53,000,000 -$822,062 -$411,031 - $411,031 $822,062 $1,233,094 $1,644,125 $2,055,156 $2,466,187 $2,877,223
$53,500,000 -$822,062 -$411,031 - $411,031 $822,062 $1,233,094 $1,644,125 $2,055,156 $2,466,187 $2,877,223
$54,000,000 -$822,062 -$411,031 - $411,031 $822,062 $1,233,094 $1,644,125 $2,055,156 $2,466,187 $2,877,223
$54,500,000 -$822,062 -$411,031 - $411,031 $822,062 $1,233,094 $1,644,125 $2,055,156 $2,466,187 $2,877,223
$55,000,000 -$822,062 -$411,031 - $411,031 $822,062 $1,233,094 $1,644,125 $2,055,156 $2,466,187 $2,877,223
$55,500,000 -$822,062 -$411,031 - $411,031 $822,062 $1,233,094 $1,644,125 $2,055,156 $2,466,187 $2,877,223
$56,000,000 -$822,062 -$411,031 - $411,031 $822,062 $1,233,094 $1,644,125 $2,055,156 $2,466,187 $2,877,223
$56,500,000 -$822,062 -$411,031 - $411,031 $822,062 $1,233,094 $1,644,125 $2,055,156 $2,466,187 $2,877,223
$57,000,000 -$822,062 -$411,031 - $411,031 $822,062 $1,233,094 $1,644,125 $2,055,156 $2,466,187 $2,877,223
$57,500,000 -$822,062 -$411,031 - $411,031 $822,062 $1,233,094 $1,644,125 $2,055,156 $2,466,187 $2,877,223
$58,000,000 -$822,062 -$411,031 - $411,031 $822,062 $1,233,094 $1,644,125 $2,055,156 $2,466,187 $2,877,223
$58,500,000 -$822,062 -$411,031 - $411,031 $822,062 $1,233,094 $1,644,125 $2,055,156 $2,466,187 $2,877,223
$59,000,000 -$822,062 -$411,031 - $411,031 $822,062 $1,233,094 $1,644,125 $2,055,156 $2,466,187 $2,877,223
$59,500,000 -$822,062 -$411,031 - $411,031 $822,062 $1,233,094 $1,644,125 $2,055,156 $2,466,187 $2,877,223
$60,000,000 -$822,062 -$411,031 - $411,031 $822,062 $1,233,094 $1,644,125 $2,055,156 $2,466,187 $2,877,223
$60,500,000 -$822,062 -$411,031 - $411,031 $822,062 $1,233,094 $1,644,125 $2,055,156 $2,466,187 $2,877,223
$61,000,000 -$822,062 -$411,031 - $411,031 $822,062 $1,233,094 $1,644,125 $2,055,156 $2,466,187 $2,877,223
$61,500,000 -$822,062 -$411,031 - $411,031 $822,062 $1,233,094 $1,644,125 $2,055,156 $2,466,187 $2,877,223
$62,000,000 -$822,062 -$411,031 - $411,031 $822,062 $1,233,094 $1,644,125 $2,055,156 $2,466,187 $2,877,223
Input Cells First Current Year Cost (FIFO) Inventory Balance Value FIFO Value Increment First Index Value Index Value Increment Prior Year Current Year Cost (FIFO) Inventory Balance Prior Year LIFO Inflation Index
Input Entries $40,000,000 $500,000 .9800 .0100 $41,103,157 1.0078



The LIFO Projections Calculator provides similar functionality of features available in the LIFO-PRO software. The LIFO projections report is used to forecast future LIFO calculations & shows the following:

  • Range of year end inventory current-year cost (FIFO or average cost) balances shown in the leftmost column
  • Range of inflation (deflation) indexes
  • Next year LIFO expense (income) amounts resulting from the prior year end LIFO calculations based on the inputted range of y/e inventory current year cost balances & inflation (deflation) indexes

The LIFO Expense (income) values are automatically recalculated based on the current-year cost (FIFO) inventory balances & LIFO inflation index values being entered in the green-colored input cells. Increments for current year cost and inflation (deflation) can also be changed and will update upon entering the values in the corresponding green-colored input cells.


The LIFO Projections Calculator tool shown above represent LIFO expense (income) values that are based on a static LIFO layer history and the underlying values used can not be changed on this website. The projected LIFO expense (income) values are estimates, and are not as precise as the calculations made by the LIFO-PRO Software’s LIFO Projections Report (Report 1).


Click here to use the LIFO Projections Calculator

LIFO Calculators Terms of Use:

LIFO-PRO, Inc. developed and is the sole owner of the LIFO Projections Calculator. LIFO-PRO, Inc. allows usage of the LIFO Projections Calculator by extending the LIFO-PRO Software’s calculation and reporting functionality for lifopro.com guests to use. The intent for this tool is to allow guests of the lifopro.com website to interact with the LIFO Projections Calculator to provide functional examples of the basic features available in the LIFO-PRO Software. Usage of the LIFO Projections Calculator outside of these terms are strictly prohibited.