LIFO Inventory Calculator: Determine Cost of Goods Sold (COGS) and Ending Inventory

Calculate Your LIFO Inventory & COGS

Inventory Layers (Chronological Order)

Enter your inventory data for beginning inventory and subsequent purchases. If a layer is not used, input '0' for units and cost.


Purchase Layer 1


Purchase Layer 2


Purchase Layer 3


Units Sold

Use our LIFO (Last-In, First-Out) calculator to easily determine your Cost of Goods Sold (COGS) and ending inventory value for financial reporting. Understand the impact of LIFO on your profitability and balance sheet, especially in periods of fluctuating costs. This tool simplifies complex inventory valuation, making it accessible for businesses, accountants, and students.

Formula:

The LIFO (Last-In, First-Out) method assumes that the last units purchased are the first ones sold. To calculate:

  • Cost of Goods Sold (COGS): Sum the costs of the most recent inventory purchases until the total units sold are accounted for.
  • Ending Inventory: Sum the costs of the remaining units from the earliest inventory purchases (including beginning inventory) after units sold are deducted from the most recent layers.
This calculator applies these principles to determine your inventory values.

Finance and Accounting Tools

12-Hour Shift Pay : Estimate Your Earnings & Overtime

Go to Calculator

28/36 Rule : Determine Your Mortgage Affordability

Go to Calculator

401k Early Withdrawal Penalty Net Proceeds

Go to Calculator

401k Retirement : Project Your Future Savings

Go to Calculator

529 College Savings Plan

Go to Calculator

6th Pay Commission Pay Scale for Indian Central Government Employees

Go to Calculator