Question

In: Accounting

Analyzing Effects of LIFO on Inventory Turnover Ratios The current assets of Exxon Mobil Corporation follow:...

Analyzing Effects of LIFO on Inventory Turnover Ratios

The current assets of Exxon Mobil Corporation follow:

$ millions 2014 2013
Current assets
Cash and cash equivalents $4,658 $4,913
Notes and accounts receivable, less estimated doubtful amounts 28,009 33,152
Inventories:
Crude oil, products and merchandise 12,384 12,117
Materials and supplies 4,294 4,018
Other current assets 3,565 5,108
Total current assets $52,910 $59,308

In addition, the following note was provided in its 2014 10-K report:

Inventories. Crude oil, products and merchandise inventories are carried at the lower of current market value or cost (generally determined under the last-in, first-out method—LIFO). Inventory costs include expenditures and other charges (including depreciation) directly and indirectly incurred in bringing the inventory to its existing condition and location. Selling expenses and general and administrative expenses are reported as period costs and excluded from inventory cost. Inventories of materials and supplies are valued at cost or less.

In 2014, 2013, and 2012, net income included gains of $187 million, $282 million, and $328 million, respectively, attributable to the combined effects of LIFO inventory accumulations and drawdowns. The aggregate replacement cost of inventories was estimated to exceed their LIFO carrying values by $10.6 billion and $21.2 billion at December 31, 2014, and 2013, respectively.

Required:
a. Exxon Mobil reported pretax earnings of $51,630 million in 2014. What amount of pretax earnings would have been reported by the company if inventory had been reported using the FIFO costing method?


b. Exxon Mobil reported cost of goods sold of $225,972 million in 2014. Compute its inventory turnover ratio for 2014 using total inventories.
(Round your answer to one decimal place.)
Answer



c. BP, p.l.c. (BP) reports its financial information using IFRS. For fiscal year 2014, BP reported cost of goods sold of $281,907 million, beginning inventory of $29,231 million and ending inventory of $18,373 million. Compute BP’s inventory turnover ratio for fiscal year 2014. (Round your answer to one decimal place.)
Answer



d. Compare your answers in parts b and c. BP can’t use LIFO to report under IFRS, so, revise your calculations in such a way as to find out which company has faster inventory turnover. (Hint: Calculate Exxon Mobil's inventory turnover ratio as if Exxon Mobil used the FIFO costing method.) (Round your answer to one decimal place.)
Answer

Solutions

Expert Solution

Answer

A.

Amount of pretax earnings would have been reported by the company under FIFO(Amount $ (' millions))

                             Pre Tax Earnings Existing                                                         =51,630

Add:                      Aggregate replacement cost of inventories for year 2014               =10,600

Less:                     Aggregate replacement cost of inventories for year 2013               =21,200

                                            Pre Tax Earnings under FIFO                                  =41,030

(The effect of Change in LIFO to FIFO for previous years has to be disclosed separately)

B.

Inventory Turnover = Cost of Goods sold / Average Inventories.

Inventory Turnover = [$ 225,972/ $ 12,250.5] million

= 18.4

Days Inventory Outstanding = 365 days/ 18.4 = 19.83 days

( Average Inventories = (Begining Inventories + Closing Inventories) / 2

= $ [(12,117+12,384) / 2] million

= $ 12,250.5 million )

C.

Inventory Turnover = Cost of Goods sold / Average Inventories.

Average Inventories = (Begining Inventories + Closing Inventories) / 2

= [$ (29,231+18,373) / 2] million

= $ 23,802 million

Inventory Turnover = [$ 281,907/ $ 23,802] million

= 11.8

Days Inventory Outstanding = 365 days/ 11.8

= 30.9 days

D.

Exxon Mobil's Inventory Turnover Ration using FIFO

Particulars $ Million
a. Cost of Goods sold      2,25,972
b.Opening Inventory (12117+21200)         33,317
c.Closing Inventory (12384+10600)         22,984
d. Average Inventory ((b+c)/2)         28,151
e. Inventory Turnover Ratio (a/d)                    8
Inventory Turnover in days (365/e)                  45

BP, p.l.c has faster inventory Turnover Ratio


Related Solutions

Analyzing Effects of LIFO on Inventory Turnover Ratios The current assets of Exxon Mobil Corporation follow:...
Analyzing Effects of LIFO on Inventory Turnover Ratios The current assets of Exxon Mobil Corporation follow: $ millions 2014 2013 Current assets Cash and cash equivalents $4,658 $4,913 Notes and accounts receivable, less estimated doubtful amounts 28,009 33,152 Inventories: Crude oil, products and merchandise 12,384 12,117 Materials and supplies 4,294 4,018 Other current assets 3,565 5,108 Total current assets $52,910 $59,308 In addition, the following note was provided in its 2014 10-K report: Inventories. Crude oil, products, and merchandise inventories...
Analyzing Effects of LIFO on Inventory Turnover Ratios The current assets of Exxon Mobil Corporation follow:...
Analyzing Effects of LIFO on Inventory Turnover Ratios The current assets of Exxon Mobil Corporation follow: $ millions 2014 2013 Current assets Cash and cash equivalents $4,658 $4,913 Notes and accounts receivable, less estimated doubtful amounts 28,009 33,152 Inventories: Crude oil, products and merchandise 12,384 12,117 Materials and supplies 4,294 4,018 Other current assets 3,565 5,108 Total current assets $52,910 $59,308 In addition, the following note was provided in its 2014 10-K report: Inventories. Crude oil, products and merchandise inventories...
E7-14 Analyzing and Interpreting the Effects of the LIFO/FIFO Choice on Inventory Turnover Ratio [LO 7-2,...
E7-14 Analyzing and Interpreting the Effects of the LIFO/FIFO Choice on Inventory Turnover Ratio [LO 7-2, LO 7-3, LO 7-5] Simple Plan Enterprises uses a periodic inventory system. Its records showed the following: Inventory, December 31, using FIFO ? 40 Units @ $15 = $600 Inventory, December 31, using LIFO ? 40 Units @ $11 = $440   Transactions in the Following Year    Units Unit Cost   Total Cost   Purchase, January 9 52 $ 16 832   Purchase, January 20 102 17 1,734...
COMPUTE AND ANALYZE THE LIQUIDITY RATIOS: CURRENT RATIO, ACCOUNTS RECEIVABLE TURNOVER, INVENTORY TURNOVER. EXPLAIN HOW THEY...
COMPUTE AND ANALYZE THE LIQUIDITY RATIOS: CURRENT RATIO, ACCOUNTS RECEIVABLE TURNOVER, INVENTORY TURNOVER. EXPLAIN HOW THEY AFFECT INVERSTORS' OR CREDITORS' DECISIONS REGARDING THE COMPANY.
Compute Financial ratios Current Ratio, Quick Ratio, Reeivables turnover, Inventory turnover, Profit margin, Asset turnover, Return...
Compute Financial ratios Current Ratio, Quick Ratio, Reeivables turnover, Inventory turnover, Profit margin, Asset turnover, Return on assets, Return on equity, Earnings per Share, Price-earnings, Cash Dicidend payot, Debt Ratio, Debt-to-Equity, and Times Interest earned Orange Company Income Statement For the Years Ended December 31 2013 2012 Net sales (all on account) $            600,000 $                520,000 Expenses: Cost of Goods Sold $            415,000 $                354,000 Selling and administrative $            120,800 $                114,600 Interest Expense $                7,800 $                    6,000 Income Tax...
Calculate the receivables and inventory turnover ratios for the year.
Universal Calendar Company began the year with accounts receivable and inventory balances of $100,000 and $80,000, respectively. Year-end balances for these accounts were $120,000 and $60,000, respectively. Sales for the year of $600,000 generated a gross profit of $200,000. Calculate the receivables and inventory turnover ratios for the year.
In the 5Cs method, the lender uses financial ratios such us Current Ratio, Inventory Turnover Ratio,...
In the 5Cs method, the lender uses financial ratios such us Current Ratio, Inventory Turnover Ratio, Gross Profit–Sales Ratio and Interest Coverage Ratio to decide whether to accept a loan application of a firm or to reject it. Please explain the role of each ratio in shaping the lender decision. Current ratio: Inventory Turnover Ratio: Gross Profit–Sales Ratio: Interest Coverage Ratio:
In the 5Cs method, the lender uses financial ratios such us Current Ratio, Inventory Turnover Ratio,...
In the 5Cs method, the lender uses financial ratios such us Current Ratio, Inventory Turnover Ratio, Gross Profit–Sales Ratio and Interest Coverage Ratio to decide whether to accept a loan application of a firm or to reject it. Please explain the role of each ratio in shaping the lender decision. Current ratio: Inventory Turnover Ratio: Gross Profit–Sales Ratio: Interest Coverage Ratio:
Total assets turnover: 1x Days sales outstanding: 37 daysa Inventory turnover ratio: 6x Fixed assets turnover:...
Total assets turnover: 1x Days sales outstanding: 37 daysa Inventory turnover ratio: 6x Fixed assets turnover: 3x Current ratio: 2.5x Gross profit margin on sales: (Sales - Cost of goods sold)/Sales = 15% aCalculation is based on a 365-day year. Do not round intermediate calculations. Round your answer to the nearest cent. Balance Sheet Cash $ Current liabilities $ Accounts receivable Long-term debt 30,000 Inventories Common stock Fixed assets Retained earnings 60,000 Total assets $200,000 Total liabilities and equity $...
Obtain monthly adjusted close prices of Microsoft (symbol: MSFT) and Exxon Mobil Corporation (symbol: XOM) during...
Obtain monthly adjusted close prices of Microsoft (symbol: MSFT) and Exxon Mobil Corporation (symbol: XOM) during December 1989 – December 2019 from Yahoo Finance. Using Excel, compute monthly returns of each company during January 1990 – December 2019. Also, compute and report the arithmetic average and the standard deviation of each company’s returns. Compute and report the correlation coefficient between these two stock returns. Next, form a portfolio that combines Microsoft and Exxon Mobil Corporation with equal weight. Compute monthly...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT