Question

In: Finance

A company presents its accounts for inventory on the LIFO basis. In the questions below, you...

A company presents its accounts for inventory on the LIFO basis. In the questions below, you need to perform the necessary conversions to FIFO to obtain a just comparison with peer companies.
The necessary financial information for the company for the year ended 31.December 2019 is presented below:

Statement of Financial Position as at 31 December 2019

US $million

2019

2018

Inventories

950

905

Statement of Profit or Loss and Other Comprehensive Income for the year ending 31 December 2019

Sales

8 100

7 400

Cost of sales

5 200

4 050

Depreciation and amortisation expense

605

720

Selling, general and administrative expense

900

750

Interest expense

92

65

Profit before tax

1 303

1 815

Income tax expense

378

526

Net income

925

1289

The LIFO reserve for each year

255

135

The effective tax rate

29%

29%

7.1 Explain each of the LIFO and FIFO methods of inventory valuation. Discuss when a company may choose to use LIFO rather than FIFO. Include in your response an explanation of the LIFO Reserve. (4)
7.2 Calculate the following using the FIFO method for the company for the year ended 31 December 2019:
7.2.1 Inventory value (2)
7.2.2 Cost of sales (2)
7.2.3 Net profit after tax. (2)

Solutions

Expert Solution

LIFO

LIFO stands for last-in-first-out. It is an inventory valuation method which assumes that the last items placed in inventory are the first sold during an accounting year. While the default inventory cost method FIFO (First In, First Out), business have an option to elect either of the two.

Please note that once the company has opted for LIFO method, they can’t switch back to FIFO unless they get an approval to change from the IRS. The IRS does allow businesses to change from FIFO to LIFO inventory accounting, but it requires an application Form 970 in order to do this. The company must file the form with tax return for the year in which they first used LIFO.

The LIFO method is used in the COGS (Cost of Goods Sold) calculation when the production cost or cost of acquiring inventory is increasing due to certain reasons, for example inflation

While the LIFO accounting method may result in a decrease in profits for the company, it can also mean less corporate tax. Should the cost increases last for some time, then these savings could be significant for a business.

Currently LIFO is permitted to be used only in the United States, under rules set out by GAAP

FIFO

The more commonly used accounting method FIFO or First In First Out method, is used to estimate the value of inventory on hand at the end of an accounting period and its cost of goods sold during the period.

This method assumes that inventory purchased first is sold first and newer inventory remains unsold. Thus cost of older inventory is assigned to COGS and that of newer inventory is assigned to ending inventory.

FIFO is a more easier way of valuing inventory and more widely used as well.

Under the below mentioned conditions the company uses either of the valuation method

Reason for Using FIFO Instead of LIFO

If a company’s cost of inventory items are continuously increasing and the company has been experiencing operating losses and negative taxable income, the use of FIFO means matching its oldest/lower costs with its current sales. The result is a larger gross profit and a positive operating income.

Reason for Using LIFO

If a company’s costs of inventory items are continuously increasing, a profitable company will have lower income tax payments with LIFO. This results from matching the most recent higher costs of its items to the most recent sales. (The higher cost of goods sold means lower net income and lower taxable income than FIFO.)

LIFO reserve

LIFO Reserve = FIFO Valuation - LIFO Valuation

The LIFO reserve is the difference between the cost of inventory calculated using the FIFO method and using the LIFO method. The ideal reason for valuing an inventory using LIFO is usually defer the payment of income taxes by increasing the cost of goods sold, the LIFO reserve essentially represents the amount by which an entity's taxable income has been deferred by using the LIFO method.

The entire LIFO reserve concept disappears if a business uses a weighted-average method to recognize the cost of its inventory, since that approach uses cost averaging, rather than cost layering, to determine the cost of an inventory.

Calculation

FIFO Inventory value = LIFO inventory + LIFO reservue - LIFO cash

Particulars 2018 2019
Inventory 905 950
LIFO Reserve 135 255
(-) Cash (LIFO reserve * Tax Rate) -39.15       -73.95
Inventory Value 1000.85 1131.05

FIFO COGS

FIFO COGS = LIFO GOGS - Change in LIFO Reserve

Particulars 2019
COGS     5,200
Changes in COGS (5,200 - 4,050)     1,150
COGS     4,050

Profit After Tax

Particulars 2018 2019
Sales         7,400         8,100
Cost of sales         4,050         4,050
Selling, general and administrative expense            750            900
EBITDA         2,600         3,150
Depreciation and amortisation expense            720            605
EBIT         1,880         2,545
Interest expense               65               92
PBT         1,815         2,453
Tax (PBT *29%)            526            711
Profit After Tax         1,289         1,742

Related Solutions

Stockholm Co. accounts for its inventory using the last-in, first-out (LIFO) method. The data below concern...
Stockholm Co. accounts for its inventory using the last-in, first-out (LIFO) method. The data below concern items in Stockholm Co.’s inventory. Per Unit Gear Stuff Wickets Historical cost $190.00 $106.00 $53.00 Selling price 217.00 145.00 73.75 Cost to complete and sell 19.00 8.00 2.50 Current replacement cost 203.00 105.00 51.00 Normal profit margin 32.00 29.00 21.25 The cost amount that Stockholm Co. should use in the lower-of-cost-or-market (LCM) comparison of stuff is Group of answer choices $105 $108 $106 $137
DV LIFO: Conway Company uses FIFO in its internal inventory accounts.  At year end, it converts the...
DV LIFO: Conway Company uses FIFO in its internal inventory accounts.  At year end, it converts the FIFO results to DV LIFO. The company adopted LIFO on December 31, 2011 with a base inventory of $107,000.  The following table summarizes data available through December 31, 2014. Inventory at year end cost Cost Index 2012 ending inventory $116,600 1.06 2013 ending inventory $128,800 1.12 2014 ending inventory $129,950 1.15 a.  What amount would Conway report as the value of inventory under DV LIFO on...
4.            A government accounts for inventory on the purchases basis. Why must it offset its year?end inventory...
4.            A government accounts for inventory on the purchases basis. Why must it offset its year?end inventory balance with an addition to fund balance? 5.            Governments are not required to accrue interest on long?term debt in governmental funds even if the interest is applicable to a current period and will be due the first day of the following year. Explain and justify the standards that permit this practice
Presented below are income statements prepared on a LIFO and FIFO basis for Novak Company, which...
Presented below are income statements prepared on a LIFO and FIFO basis for Novak Company, which started operations on January 1, 2016. The company presently uses the LIFO method of pricing its inventory and has decided to switch to the FIFO method in 2017. The FIFO income statement is computed in accordance with the requirements of GAAP. Novak’s profit-sharing agreement with its employees indicates that the company will pay employees 10% of income before profit-sharing. Income taxes are ignored. LIFO...
Presented below are income statements prepared on a LIFO and FIFO basis for Bonita Company, which...
Presented below are income statements prepared on a LIFO and FIFO basis for Bonita Company, which started operations on January 1, 2019. The company presently uses the LIFO method of pricing its inventory and has decided to switch to the FIFO method in 2020. The FIFO income statement is computed in accordance with the requirements of GAAP. Bonita’s profit-sharing agreement with its employees indicates that the company will pay employees 10% of income before profit-sharing. Income taxes are ignored. LIFO...
petro company donated inventory to hospitals. the basis of the inventory was 70,000 and its fair...
petro company donated inventory to hospitals. the basis of the inventory was 70,000 and its fair market value was 120000. petro made no other cintributions this year. what is the charitable contribution deduction assuming that petry co taxes income before the dividend received deduction and charitable contributions deduction is 600,000 and included in income was a 100000 dividende received from a 15% owned domestic coproation
FIFO –LIFO The Inventory Company has provided you with three months of their inventory and purchases...
FIFO –LIFO The Inventory Company has provided you with three months of their inventory and purchases for the last three months: Date Item Quantity Unit Price July 1 Begin Inventory 2,500 $38 July 15 Purchase 3,300 $37 July 29 Purchase 5,500 $36 Aug 11 Purchase 4,100 $36 Aug 30 Purchase 6,700 $35 Sept 14 Purchase 3,900 $34 During three months the company sold 23,200 units.Selling price is $78 and the company’s tax rate is 32%. Required: A.Complete the worksheet for...
Lewis Company adopted the dollar-value LIFO method of inventory valuation on 12/31/18. Its inventory at that...
Lewis Company adopted the dollar-value LIFO method of inventory valuation on 12/31/18. Its inventory at that date was $320,000 and the relevant price index was 100. What will Lewis report as inventory at the end of 2019, 2020, 2021, and 2022 using dollar-value LIFO? Date Inv at current price current price index inv at base level price 12/31/19 338,000 104 325,000 12/31/20 371,000 106 350,000 12/31/21 372,600 108 345,000 12/31/22 381,500 109 350,000
[The following information applies to the questions displayed below.]    Green Brands, Inc. (GBI), presents its...
[The following information applies to the questions displayed below.]    Green Brands, Inc. (GBI), presents its statement of cash flows using the indirect method. The following accounts and corresponding balances were drawn from GBI’s 2017 and 2016 year-end balance sheets.      Account Title 2017 2016   Accounts receivable $ 20,500 $ 27,000   Merchandise inventory 57,300 50,600   Prepaid insurance 17,900 25,600   Accounts payable 23,900 19,100   Salaries payable 5,000 3,950   Unearned service revenue 650 2,750    The 2017 income statement is shown below:...
Sheridan Company began using dollar-value LIFO for costing its inventory two years ago. The ending inventory...
Sheridan Company began using dollar-value LIFO for costing its inventory two years ago. The ending inventory for the past two years in end-of-year dollars was $292000 and $459000 and the year-end price indices were 1.0 and 1.1, respectively. Assuming the current inventory at end of year prices equals $647000 and the index for the current year is 1.15, what is the ending inventory using dollar-value LIFO? (Round intermediate calculations and final answer to 0 decimal places, e.g. 10,000.) $600686. $596936....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT