Assets - Inventory Analysis

Computing Inventory Balances
In computing ending inventory balances under the various methods we will use the following example.

Example:
Company ABC purchased these items in May, and sold item 102 and 103 for a total of $300:

1. Average-cost method - Under this inventory method the units in inventory are considered as a whole and their cost is averaged out. Companies that use this method carry large amount of units.

Total cost: $130
Average cost: $33 per unit (total cost / total number of units)
Cost of goods sold: $66 ($33*2 units sold)
Ending inventory: $66 ($33*2 units left)
Gross profit: $300-$66 = $234

2. First in first out - Under this inventory method, the units that were first purchased are assumed to be sold first.

Cost of goods sold: $65 (ID: 101 and 102)
Ending inventory: $65 (ID: 103 and 104)
Gross profit: $300-$65 = $235

3. Last in first out - Under this inventory method the units that were last purchased are assumed to be sold first.

Cost of goods sold: $65 (ID: 103 and 104)
Ending inventory: $65 (ID: 101 and 102)
Gross profit: $300-$65 = $235

Usefulness of Inventory Data When Prices Are Stable or Changing
If the cost of purchasing inventory remains stable, the method used to calculate the cost of goods sold (by FIFO, LIFO or average cost) will yield similar results. On the other hand, in a changing environment this can distort the reported income, cash flow and inventory.

I. Rising Price (Inflationary) Environment

FIFO method

  • COGS will be understated.
  • Income will be overstated.
  • The company will pay more income tax and have a lower cash flow.
  • Assets on the balance sheet will be more reflective of the actual market value.
  • Working capital and current ratio will be increased.
  • Inventory turnover (COGS / average inventory) will worsen (decrease).

LIFO method

  • COGS will be more reflective of current market environment.
  • Income will be lower.
  • The company will pay less income tax and cash flow will be higher.
  • Assets will be understated and not reflective of its market value.
  • Working capital and current ratio will be decreased.
  • Inventory turnover (COGS / average inventory) will improve (increase).

Average-cost method

  • Since it's an average, it would be in between LIFO and FIFO.

II. Decreasing Price (Deflation) Environment

FIFO method

  • COGS will be more reflective of current market environment.
  • Income will be lower.
  • The company will pay less income tax, and cash flow would be higher.
  • Assets will be understated and not reflective of its market value.
  • Working capital and current ratio will be decreased.
  • Inventory turnover (COGS / average inventory) will improve (increase).

LIFO method

  • COGS will be understated.
  • Income will be overstated.
  • The company will pay more income tax and have a lower cash flow.
  • Assets on the balance sheet will be more reflective of the actual market value.
  • Working capital and current ratio will be increased.
  • Inventory turnover (COGS / average inventory) will worsen (decrease).
Look Out!

Make sure you understand this concept very well. It can make or break an entire sample set if you reverse the effects conceptually

Analysts should be aware that companies that operate in a rising-price environment and utilize the LIFO method could manipulate their earnings. To manipulate the earnings management could simply stop purchasing new inventory and start dipping into their old and cheap inventory. This is call "LIFO liquidation".

Most U.S. companies use LIFO as opposed to FIFO. Given the fact that the U.S. has seen cost of inventory rise over the last 30 years (inflation) these companies were able to save on taxes. One should know that the Internal Revenue Service (IRS) does not allow companies to report LIFO for tax purposes and then FIFO on their general-purpose statements.

Analyzing the Financial Statements of Companies That Use Different Inventory Accounting Methods
When comparing two companies, one must ensure that they are comparing apples with apples. If the first company uses the FIFO method and the other the LIFO method, then there is a problem. To make the comparison relevant, one must convert LIFO to FIFO or FIFO to LIFO.

Converting LIFO to FIFO
Related Articles
  1. Career Education & Resources

    How Hard are the CFA Exams?

    Learn about the difficulty of the CFA exams with a description of the tests, some statistics on pass rates and suggestions that can help you pass the exams.
  2. Professionals

    What it Takes to be a Financial Analyst

    A financial analyst researches companies and economic conditions to make business, sector and industry recommendations.
  3. Career Education & Resources

    Financial Analyst: Career Path & Qualifications

    Read about what it takes to become a financial analyst in a corporation or securities firm, and learn how far you can rise in the profession.
  4. Career Education & Resources

    Financial Planner: Career Path & Qualifications

    Learn what education and certifications you need to become a financial planner, as well as the future prospects and earnings potential for financial planners.
  5. Career Education & Resources

    Where to Find Non-Profit Finance Jobs

    The non-profit sector offers a stable selection of jobs for those who seek other types of fulfillment from their jobs than just purely financial.
  6. Career Education & Resources

    Portfolio Manager: Career Path & Qualifications

    Learn about the basic requirements for getting hired as a portfolio manager, and discover how most professionals in the field rise into the position.
  7. Your Practice

    4 Professional Associations Advisors Should Join

    These four professional organizations are among the most respected and well known in the industry.
  8. Professionals

    Equity Research: Career Path and Qualifications

    Find out what equity research analysts do on a day-to-day basis, and learn more about the typical career progression for these securities professionals.
  9. Professionals

    What's on the CFA Level II Exam?

    The Chartered Financial Analyst Level II exam is the second of three tests that CFA candidates must pass.
  10. Professionals

    Financial Data Analyst: Career Path & Qualifications

    Learn more about the career options available to financial data analysts, and determine whether the profession is a good match for you.
RELATED TERMS
  1. Personal Financial Advisor

    Professionals who help individuals manage their finances by providing ...
  2. CFA Institute

    Formerly known as the Association for Investment Management and ...
  3. Security Analyst

    A financial professional who studies various industries and companies, ...
  4. Chartered Financial Analyst - CFA

    A professional designation given by the CFA Institute (formerly ...
RELATED FAQS
  1. What are the differences between a Chartered Financial Analyst (CFA) and a Certified ...

    The differences between a Chartered Financial Analyst (CFA) and a Certified Financial Planner (CFP) are many, but comes down ... Read Full Answer >>
  2. How do I become a Chartered Financial Analyst (CFA)?

    According to the CFA Institute, a person who holds a CFA charter is not a chartered financial analyst. The CFA Institute ... Read Full Answer >>
  3. What types of positions might a Chartered Financial Analyst (CFA) hold?

    The types of positions that a Chartered Financial Analyst (CFA) is likely to hold include any position that deals with large ... Read Full Answer >>
  4. Who benefits the most from prepaid expenses?

    Prepaid expenses benefit both businesses and individuals. Prepaid expenses are the types of expenses that are bought or paid ... Read Full Answer >>
  5. If I am looking to get an Investment Banking job. What education do employers prefer? ...

    If you are looking specifically for an investment banking position, an MBA may be marginally preferable over the CFA. The ... Read Full Answer >>
  6. Can I still pass the CFA Level I if I do poorly in the ethics section?

    You may still pass the Chartered Financial Analysis (CFA) Level I even if you fare poorly in the ethics section, but don't ... Read Full Answer >>
Hot Definitions
  1. Short Selling

    Short selling is the sale of a security that is not owned by the seller, or that the seller has borrowed. Short selling is ...
  2. Harry Potter Stock Index

    A collection of stocks from companies related to the "Harry Potter" series franchise. Created by StockPickr, this index seeks ...
  3. Liquidation Margin

    Liquidation margin refers to the value of all of the equity positions in a margin account. If an investor or trader holds ...
  4. Black Swan

    An event or occurrence that deviates beyond what is normally expected of a situation and that would be extremely difficult ...
  5. Inverted Yield Curve

    An interest rate environment in which long-term debt instruments have a lower yield than short-term debt instruments of the ...
  6. Socially Responsible Investment - SRI

    An investment that is considered socially responsible because of the nature of the business the company conducts. Common ...
Trading Center