Question

In: Finance

The following transactions occurred for the Levy Company during 2019: Beginning inventory consists of 50 units...

The following transactions occurred for the Levy Company during 2019: Beginning inventory consists of 50 units with a price per unit of $40. Transactions during 2019 (in order) were: 1) Purchased 100 units @ $42 2) Purchased 110 units @ $43 3) Sold 190 units Required: a) Use the above information and compute the ending inventory and cost of goods sold for 2018 assuming is used: periodic LIFO, periodic FIFO, WAC. b) Assume the use of LIFO and a market value of inventory at the end of 2019 of $ 2,800. What is the value of ending inventory to be reported in the balance sheet? What is the value of cost of goods sold to be reported in the income statement? c) Conceptually, how does pretax income using FIFO (in times of rising prices) compare to LIFO pretax income? Explain briefly your answer.

Solutions

Expert Solution

A) Computation of year-end inventory and cost of goods sold for 2018:

1) Using Periodic LIFO Method:

Under LIFO it is assumed that the recent inventories are sold on priority and the earlier units of inventories are given less preference.

Particulars Units Rate ($) Value ($) Inventory Valuation ($)
Opening Inventory 50 40 2,000 2,000
Add: First Purchase 100 42 4,200 6,200
Add: Second Purchase 110 43 4,730 10,930
Less: Sales (COGS) 190 42.58 -8,090 2,840
Year-end Valuation 70 40.57 2,840 2,840

Calculation of rate of sales using LIFO Method:

= [(110 * 43) + (80 * 42)] / 190 = $ 42.58

Calculation of cost of goods sold = [(110 * 43) + (80 * 42)] = $ 8,090

2) Using Periodic FIFO Method:

Under FIFO it is assumed that the earlier inventories are sold on priority and the earlier units of inventories are cleared only after the older inventories are sold.

Particulars Units Rate ($) Value ($) Inventory Valuation ($)
Opening Inventory 50 40 2,000 2,000
Add: First Purchase 100 42 4,200 6,200
Add: Second Purchase 110 43 4,730 10,930
Less: Sales (COGS) 190 41.68 -7,920 3,010
Year-end Valuation 70 43 3,010 3,010

Calculation of rate of sales using FIFO Method:

= [(50 * 40) + (100 * 42) + (40 * 43)] / 190 = $ 41.68

Calculation of cost of goods sold = [(50 * 40) + (100 * 42) + (40 * 43)] = $ 7,920

3) Using WAC Method:

Under WAC, the inventory valuation is done on the basis of any change in the units. Meaning thereby, the units are valued on the basis of total costs and total units, whereas the valuation changes as and when there is any movement in the inventory.

Particulars Units Rate ($) Value ($) Total Units Total Value Calculation of WA Rate = Total Value / Total Units Inventory Valuation ($)
Opening Inventory 50 40 2,000 50 2,000 40 2,000
Add: First Purchase 100 42 4,200 150 6,200 41.33 6,200
Add: Second Purchase 110 43 4,730 260 10,930 42.04 10,930
Less: Sales (COGS) 190 42.04 -7,987 70 2,843 42.04 2,843
Year-end Valuation 70 2,843 42.04 2,843

B) Valuation of inventory in Financial Statements using LIFO Method:

Valuation of inventory - inventories at the end of the Financial Year are valued at the lower of its cost or Net Realizable Value (NRV).

In the given case, the cost of the inventory as per LIFO Method from above is $ 2,840 and the market value (NRV) of the inventory at the end of the year is $ 2,800. Therefore, the inventory would be reported at the NRV of $ 2,800.

Value of year-end inventory to be reported in Balance Sheet = $ 2,800

Value of Cost of Goods Sold (COGS) in the Income Statement = Cost of Goods Sold as per the LIFO valuation and value of written-off inventory

Value of COGS in Income Statement = $ 8,090 + ($ 2,840 - $ 2,800) = $ 8,130

C) Comparison of pre-tax income under FIFO (at the time of rising prices) and LIFO:

Method of Inventory Valuation Inventory Valuation Overall impact on pre-tax income
FIFO (at the time of rising prices)

Since FIFO assumes earlier inventories are taken out first, the inventory valuation is always driven by the cost of the inventories purchased later/ held at the end of the period.

Therefore, in the event of inflatory market conditions, FIFO method reports higher inventory valuation and lower COGS. Sometimes, the inventory is overstated, leading to reporting of higher unrealized gains as on year-end.

The inventory valuation is higher in such times and the pre-tax income reported is also higher on account of unrealized gains in the form of high inventory valuation.

Further, higher pre-tax income would also result into higher taxes for the income which are unrealized.

LIFO LIFO assumes that the recent inwards of inventory is taken out first and the valuation of inventory at year-end is driven by the inventories purchased earlier. Under normal circumstances, LIFO method might not represent a true picture of the profitability of the business as the inventory is valued at the outdated prices, which might seem irrelevant as on year-end.
LIFO (at the time of rising prices)

Since LIFO assumes that the latest purchases of inventory is taken out first, the method perfectly matches the recent purchases with the COGS of recent sales at the times of rising prices.

Due to this, the COGS reported is higher along with lower inventory valuation under LIFO during inflation.

At the time of inflation, LIFO shows higher COGS and lower inventory valuation leading to lower pre-tax income.

Moreover, under inflatory markets, gross margins derived by using LIFO method are better indicator of the profitability, as unrealized gains in inventory are limited and the inventory is valued at the cost of inventory purchased earlier at lower costs.


Related Solutions

The following transactions occurred during the month of October, 2019 at the Tree Company. The balance...
The following transactions occurred during the month of October, 2019 at the Tree Company. The balance sheet for the Tree Company at September 30, 2019 was as follows: Balance Sheet Assets ---------------------------------------Liabilities Cash $ 4,500 ---------------- Accounts payable $ 16,000 Accounts receivable 24,000 -------- Notes payable 30,000 Supplies on hand 8,000 ---------------- Wages & salaries payable 5,000 Equipment 51,000 ----------------Invested capital 50,000 Truck 20,000 --------------------- Retained earnings 6,500 TOTAL $107,500 ----------- $107,500 According to the Chart of Accounts at Tree...
Tree Company The following transactions occurred during the month of October, 2019 at the Tree Company....
Tree Company The following transactions occurred during the month of October, 2019 at the Tree Company. The balance sheet for the Tree Company at September 30, 2019 was as follows: Balance Sheet Assets                                                                                      Liabilities Cash                        $ 4,500                         Accounts payable             $             16,000 Accounts receivable 24,000                         Notes payable                         30,000 Supplies on hand          8,000                         Wages & salaries payable        5,000 Equipment                  51,000                         Invested capital                       50,000 Truck                          20,000                        ...
At the beginning of November, Donkey Inc.'s inventory consists of 50 units with a cost per...
At the beginning of November, Donkey Inc.'s inventory consists of 50 units with a cost per unit of $100. The following transactions occur during the month of November. November 2 Purchase 80 units of inventory on account from Kong Inc. for $110 per unit, terms 2/10, n/30. November 3 Pay freight charges related to the November 2 purchase, $240. November 9 Return 20 defective units from the November 2 purchase and receive credit. November 11 Pay Kong Inc. in full....
At the beginning of November, Donkey Inc.'s inventory consists of 50 units with a cost per...
At the beginning of November, Donkey Inc.'s inventory consists of 50 units with a cost per unit of $100. The following transactions occur during the month of November. November 2 Purchase 80 units of inventory on account from Kong Inc. for $110 per unit, terms 2/10, n/30. November 3 Pay freight charges related to the November 2 purchase, $240. November 9 Return 20 defective units from the November 2 purchase and receive credit. November 11 Pay Kong Inc. in full....
During the month, the following transactions occurred for Trevor’s Supply Company.   The company uses the perpetual inventory...
During the month, the following transactions occurred for Trevor’s Supply Company.   The company uses the perpetual inventory method. Dec. 1 Accepted a 4-month, 6% note from a customer in settlement of $12,400 account. 3 Wrote off as uncollectible specific accounts totaling $680. 8 Purchased $17,200 of inventory on account, terms 2/10, n/30. 11 Sold $25,000 of inventory that cost $17,500, terms 1/15, n/45. 12 Paid $13,750 for employee salaries. 15 Customers returned $8,000 of inventory sold on December 11th that cost...
Business Events and Transactions for September 2019: The following transactions occurred during the first week of...
Business Events and Transactions for September 2019: The following transactions occurred during the first week of September. • September 1- Pay the $3,175 August interest owed to the bank. Also make a $40,000 payment on the bank note principal. • September 1- The company purchased office supplies for the first time in September. They purchased $2,400 in supplies from Office Depot and paid for it in cash. • September 5- the company has collected $225,000 in cash on the August...
Alternative Inventory Methods Nevens Company uses a periodic inventory system. During November, the following transactions occurred:...
Alternative Inventory Methods Nevens Company uses a periodic inventory system. During November, the following transactions occurred: Date Transaction Units Cost/Unit November 1 Balance 500 $3.50 8 Sale 350 13 Purchase 300 4.00 21 Purchase 200 5.00 28 Sale 150 Required: 1. Compute the cost of goods sold for November and the inventory at the end of November for each of the following cost flow assumptions. If required, round your answers to the nearest dollar. FIFO Cost of Goods Sold $...
The following transactions occurred during 2020 (the company uses a perpetual inventory system with FIFO): 1)...
The following transactions occurred during 2020 (the company uses a perpetual inventory system with FIFO): 1) Jan 4 Stockholders invested an additional $10,000 cash in the business in exchange for common stock 2) Jan 4 Purchased 20 rabbits at $50 each on account from Jelly Bean Farms. 3) Jan 4 Established a $200 petty change fund 4) Jan 5 Sold 6 rabbits for $200 each to Mr. Karrot, terms 2/10, n/30. 5) Jan 6 Sold 12 rabbits at $200 each...
CorpX has 50 units in beginning inventory with a cost of $300. During the year purchases...
CorpX has 50 units in beginning inventory with a cost of $300. During the year purchases were made as follows: January 15- 100 units @ 5.75 per unit                      =          $575 total cost June 15- 100 units @ 5.50 per unit                           =          $550 total cost October 20-50 units @ 5.00 per unit                        =          $250 total cost Total Units = 250                                                                   $1375 total cost An inventory count at year end reveals 60 units in ending inventory. Required: 1-what is the ending...
AU Company has the following inventory transactions for the month of March: Units Unit Cost Beginning,...
AU Company has the following inventory transactions for the month of March: Units Unit Cost Beginning, Mar. 1 10,000 15 Purchases, Mar. 10 20,000 18 Sold, Mar. 15 15,000 Purchases, Mar. 18 5,000 23 Sold, Mar. 25 6,000 The company uses the perpetual inventory system. Determine the cost of inventory on March 31 and cost of goods sold under: Inventory Cost Flow Ending Inventory Cost of Goods Sold First in, first out (FIFO) Moving Average Last in, first out (LIFO)
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT