Question

In: Accounting

FIFO versus LIFO: Ratio Analysis Presented below are the financial statements of two companies that are...

FIFO versus LIFO: Ratio Analysis

Presented below are the financial statements of two companies that are identical in every respect except the method of valuing their inventories. The method of valuing inventory is LIFO for the LIFO Company and FIFO for the FIFO Company.

Comparative Balance Sheets FIFO Company LIFO Company
Sales 19,750,000 19,750,000
Less: Cost of goods sold 13,000,000 13,840,000
Gross profit 6,750,000 5,910,000
Less: Operating expenses 5,000,000 5,000,000
Net income before tax 1,750,000 910,000
Comparative Balance Sheets FIFO Company LIFO Company
Assets
Cash 600,000 600,000
Receivables 1,200,000 1,200,000
Inventory 4,750,000 3,910,000
Total current assets 6,550,000 5,710,000
Total noncurrent (net) 4,000,000 4,000,000
Total 10,550,000 9,710,000
Liabilities and Equities
Current liabilities 1,840,000 1,840,000
liabilities 1,800,000 1,800,000
liabilities 3,640,000 3,640,000
Total shareholders’ equity 6,910,000 6,070,000
Total 10,550,000 9,710,000

Required
Using the two sets of financial statements, calculate the ratios below for each firm. Ignore the effect of taxes (i.e., assume zero taxes for both firms).

Round all answers to nearest one decimal place, except for 10. Earnings per share (example for percentage ratios: 0.2345 = 23.5%).
Round Earnings per share two decimal places.

FIFO Company LIFO Company
1. Current Ratio
2. Inventory Turnover ratio
3.
Inventory-on-hand period
4. Return on total assets % %
5. Total debt to total assets % %
6. Long-term debt to shareholders’ equity % %
7. Gross margin ratio % %
8.
Return on sales
% %
9.
Return on shareholders’ equity
% %
10.
Earnings per share (assume 2 million shares outstanding)
$ $

Presented below are the financial statements of two companies that are identical in every respect except the method of valuing their inventories. The method of valuing inventory is LIFO for the LIFO Company and FIFO for the FIFO Company.

Solutions

Expert Solution

FIFO Company FIFO Working LIFO Company LIFO Working
1 Current Ratio                   3.6 =6550000/1840000                   3.1 =5710000/1840000
2 Inventory Turnover ratio                   2.7 =13000000/4750000                   3.5 =13840000/3910000
3 Inventory-on-hand period               133.4 =4750000*365/13000000               103.1 =3910000*365/13840000
4 Return on total assets 16.6% =1750000/10550000 9.4% =910000/9710000
5 Total debt to total assets 34.5% =3640000/10550000 37.5% =3640000/9710000
6 Long-term debt to shareholders’ equity 26.0% =1800000/6910000 29.7% =1800000/6070000
7 Gross margin ratio 34.2% =6750000/19750000 29.9% =5910000/19750000
8 Return on sales 8.9% =1750000/19750000 4.6% =910000/19750000
9 Return on shareholders’ equity 25.3% =1750000/6910000 15.0% =910000/6070000
10 Earnings per share (assume 2 million shares outstanding)                 0.88 =1750000/2000000                 0.46 =910000/2000000

Related Solutions

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...
Presented below are condensed financial statements adapted from those of two actual companies competing in the...
Presented below are condensed financial statements adapted from those of two actual companies competing in the pharmaceutical industry—Benatar and Jett, Inc. ($ in millions, except per share amounts). Balance Sheets ($ in millions, except per share data) Benatar Jett Assets: Cash $ 18,143 $ 12,398 Short-term investments 6,390 12,646 Accounts receivable (net) 9,184 11,385 Inventory 6,016 10,135 Other current assets 6,100 5,965 Current assets 45,833 52,529 Property, plant, and equipment (net) 16,254 24,695 Intangibles and other assets 20,030 73,355 Total...
Presented below are condensed financial statements adapted from those of two actual companies competing in the...
Presented below are condensed financial statements adapted from those of two actual companies competing in the pharmaceutical industry—Johnson and Johnson (J&J) and Pfizer, Inc. ($ in millions, except per share amounts). Balance Sheets ($ in millions, except per share data) J&J Pfizer Assets: Cash $ 5,377 $ 1,520 Short-term investments 4,146 10,432 Accounts receivable (net) 6,574 8,775 Inventories 3,588 5,837 Other current assets 3,310 3,177 Current assets 22,995 29,741 Property, plant, and equipment (net) 9,846 18,287 Intangibles and other assets...
Ratio analysis of financial statements allows us to see how well a company is operating versus...
Ratio analysis of financial statements allows us to see how well a company is operating versus its past and in relation to other companies. Pick one type of ratios d and share how the ratio is calculated and what the results mean. If you could explain one so that I, a non accounting major who is struggling to understand, might get it.
evaluate financial statements using ratio analysis
evaluate financial statements using ratio analysis
Using the below financial statements to complete the ratio analysis and statement of Cash Flow questions...
Using the below financial statements to complete the ratio analysis and statement of Cash Flow questions following the financial statements. Milky Way corp comparative Balance sheet December 31, 20XX and 20XX (Prior) Assets Current Prior Cash 1,580 1,080 Account Receivable 1,300 1,680 Inventory 12,420 12,000 Total Current Assets 15,300 14,760 Land 12,300 10,200 Equipment 11,480 9,600 Accumulated Depreciation (2,040) (1,080) Total Long-term Assets 37,040 33,480 Liabilities Account Payable 1,920 960 Salaries Payable 5,060 4,080 Total Current Liabilities 6,980 5,040 Long-term...
The financial statements for the Nitai’s Nail Supplies for the past two years are presented below....
The financial statements for the Nitai’s Nail Supplies for the past two years are presented below. Nitai’s nail SUPPLIES Comparative Income Statements for the year ended 30 June     2019    2020 Sales Cost of sales $400 000 350 000 $ 500 000    458 000 Gross profit Interest income Loss on sale of fixtures 50 000 1 000      42 000      2 000      800 51 000    43 200 Office supplies used Other expenses 10 000    29 000 11 000     29 000    39...
Financial information for two companies are presented below. Fill in the missing amounts. Sandhill Company Carla...
Financial information for two companies are presented below. Fill in the missing amounts. Sandhill Company Carla Vista Company Sales revenue $ 90,800 $ Sales returns and allowances $  5,000 Net sales 83,000 127,000 Cost of goods sold 55,200 Gross profit $ 41,000 Operating expenses 14,580 Net income $ 18,000 eTextbook and Media List of Accounts Calculate the profit margin and the gross profit rate for each company. (Round answers to 1 decimal place, e.g. 15.5%.) Sandhill Company Carla Vista Company Profit...
in 500 words or more, discuss the limitations of financial statements and financial ratio analysis.
in 500 words or more, discuss the limitations of financial statements and financial ratio analysis.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT