Question

In: Accounting

The following is the balance sheet and income statement for Metro Eagle Outfitters, in condensed form,...

The following is the balance sheet and income statement for Metro Eagle Outfitters, in condensed form, plus some information from the cash flow statement.

Balance Sheet 2019 2018 2017
Cash and short-term investments $ 632,992 $ 747,044 $ 736,693
Accounts receivable 46,521 40,510 37,121
Inventory 334,452 371,514 303,208
Other current assets 129,835 132,420 101,388
Total current assets 1,143,800 1,291,488 1,178,410
Long-lived assets 581,832 644,482 590,802
Total assets $ 1,725,632 $ 1,935,970 $ 1,769,212
Current liabilities $ 437,902 $ 411,401 $ 389,837
Total liabilities 504,245 518,386 417,741
Shareholders’ equity 1,221,387 1,417,584 1,351,471
Total debt and equity $ 1,725,632 $ 1,935,970 $ 1,769,212
Income Statement
Sales $ 3,476,202 $ 3,120,265 $ 2,945,694
Cost of sales 2,087,480 1,977,471 1,765,143
Gross margin $ 1,388,722 $ 1,142,794 $ 1,180,551
Operating expenses 986,484 867,385 862,976
Earnings before interest and taxes $ 402,238 $ 275,409 $ 317,575
Net income $ 234,108 $ 151,905 $ 140,847
Interest paid in cash 82 184 163
Taxes paid in cash 142,209 99,856 45,937
Cash Flows
Cash flow from operations $ 510,671 $ 411,317 $ 382,416
Capital expenditures 94,139 89,866 76,304
Dividends 85,792 85,792 83,366

Required:

Calculate the following liquidity ratios for Metro Eagle in 2018 and 2019:

1. Inventory turnover

2. Current ratio.

3. Quick ratio

4. Cash flow ratio

Solutions

Expert Solution

Ans. 1 Inventory turnover = Cost of sales / Average Inventory
2019 $2,087,480 / $352,983 5.91 times
2018 $1,977,471 / $337,361 5.86 times
*Average inventory = (Beginning inventory + Ending inventory) / 2
2019 ($371,514 + $334,452) / 2 $352,983
2018 ($303,208 + $371,514) / 2 $337,361
Ans. 2 Current ratio   =   Total current assets / Total current liabilities
2019 $1,143,800 / $437,902 2.61 : 1
2018 $1,291,488 / $411,401 3.14 : 1
Ans. 3 Quick ratio   =   (Total current assets - Inventory) / Total current liabilities
2019 ($1,143,800 - $334,452) / $437,902 1.85 : 1
2018 ($1,291,488 - $371,514) / $411,401 2.24 : 1
Ans. 4 Cash flow ratio   =   Cash flow from operations / Total current liabilities
2019 $510,671 / $437,902 1.17
2018 $411,317 / $411,401 1.00

Related Solutions

SB The following condensed balance sheet is... The following condensed balance sheet is presented for the...
SB The following condensed balance sheet is... The following condensed balance sheet is presented for the partnership of D, E, and F who share profits and losses in the ratio of 5:3:2, respectively: Cash $ 100,000 Other Assets 480,000 $ 580,000 Liabilities $ 160,000 D, Capital 200,000 E, Capital 130,000 F, Capital 90,000 Total $ 580,000 The partners agreed to liquidate the partnership after selling the other assets. TB MC Qu. 16-12 Refer to the above information. If the other......
Condensed balance sheet and income statement data for Landwehr Corporation appear below.
Condensed balance sheet and income statement data for Landwehr Corporation appear below.   Additional information: 1. The market price of Landwehr’s common stock was $4.00, $5.00, and $8.00 for 2016, 2017, and 2018, respectively. 2. All dividends were paid in cash.   Instructions (a) Compute the following ratios for 2017 and 2018. (1) Profit margin. (2) Asset turnover. (3) Earnings per share. (Weighted-average common shares in 2018 were 32,000 and in 2017 were 31,000.) (4) Price-earnings ratio. (5) Payout ratio....
Below is a condensed Income Statement for the SPECTRE Company for 2018 along with balance sheet...
Below is a condensed Income Statement for the SPECTRE Company for 2018 along with balance sheet information income statement service revenue 3,660,000 Operating expenses 2,700,000 income b4 income tax 960,000 Income tax expense 288,000 Net income 672,000 Balance sheets 12/31/2018 12/31/2017 Cash 1,317,000 270000 1,047,000 accounts receivable 480,000 360,000 Wages payable 330,000 240,000 Income taxes payable 90,000 165,000 Additional information a) During the year Sprectre issued common stock for $420,000 b) Long-term investments were sold by Spectre during the year...
Below is a condensed Income Statement for the SPECTRE Company for 2018 along with balance sheet...
Below is a condensed Income Statement for the SPECTRE Company for 2018 along with balance sheet information Income statement service revenue 3,660,000 Operating expenses 2,700,000 income b4 income tax 960,000 Income tax expense 288,000 Net income 672,000 Balance sheets 12/31/2018 12/31/2017 Cash 1,317,000 270000 accounts receivable 480,000 360,000 Wages payable 330,000 240,000 Income taxes payable 90,000 165,000 Additional information a) During the year Sprectre issued common stock for $420,000 b) Long-term investments were sold by Spectre during the year for...
Condensed balance sheet and income statement data for Swifty Corporation appear below: SWIFTY CORPORATION Balance Sheet...
Condensed balance sheet and income statement data for Swifty Corporation appear below: SWIFTY CORPORATION Balance Sheet December 31 2021 2020 2019 Cash $ 27,500 $ 23,500 $ 18,500 Accounts receivable 50,500 50,000 48,500 Other current assets 94,500 95,500 65,000 Property, plant, and equipment (net) 530,000 471,500 401,000 $702,500 $640,500 $533,000 Current liabilities $ 71,500 $ 77,500 $ 70,000 Long-term debt 77,500 84,500 46,500 Common shares 318,000 280,000 287,000 Retained earnings 235,500 198,500 129,500 $702,500 $640,500 $533,000 SWIFTY CORPORATION Income Statement...
Selected balance sheet and income statement information follows for Snap Inc. and Golden Eagle Inc. for...
Selected balance sheet and income statement information follows for Snap Inc. and Golden Eagle Inc. for the fiscal year ended January 30, 2020. For Fiscal Year Ended Jan. 30, 2020 ($ millions) Snap Golden Eagle Income statement information: Interest expense $236 $6 Income before interest and taxes 9,296 1,932 Balance sheet information: Cash and cash equivalents 7,946 1,534 Accounts receivable 1,692 478 Current assets 24,309 4,410 Current liabilities 15,971 2,691 Total assets 46,333 9,833 Total liabilities 30,554 3,422 Total stockholders’...
Complete, in good form, an Income Statement, Balance Sheet, and Statement of Cash Flows for the...
Complete, in good form, an Income Statement, Balance Sheet, and Statement of Cash Flows for the following transactions. Transactions: T1 Company issues $200,000 of common stock @ $8.00 per share. T2 Company issues preferred stock @ 7% for $22 per share. T3 The company borrows on April 1st, 1 million dollars @ 7% interest rate T4 On June 1st, The company purchases 15 taxi cabs for $20,000, 5% salvage value, 5-year life T5 Revenue for the whole year was $600,000...
Condensed balance sheet and income statement data for Jergan Corporation are presented here. Jergan Corporation Balance...
Condensed balance sheet and income statement data for Jergan Corporation are presented here. Jergan Corporation Balance Sheets December 31 2020 2019 2018 Cash $ 30,600 $ 17,300 $ 17,300 Accounts receivable (net) 50,900 44,500 48,600 Other current assets 90,100 94,800 64,900 Investments 54,700 70,600 44,600 Plant and equipment (net) 500,600 370,000 358,700 $726,900 $597,200 $534,100 Current liabilities $85,600 $79,000 $70,700 Long-term debt 144,200 85,000 50,900 Common stock, $10 par 384,000 319,000 308,000 Retained earnings 113,100 114,200 104,500 $726,900 $597,200 $534,100...
Condensed balance sheet and income statement data for Jergan Corporation are presented here. Jergan Corporation Balance...
Condensed balance sheet and income statement data for Jergan Corporation are presented here. Jergan Corporation Balance Sheets December 31 2020 2019 2018 Cash $ 30,000 $ 16,600 $ 18,700 Accounts receivable (net) 49,900 44,600 47,400 Other current assets 90,800 94,500 64,100 Investments 55,400 69,800 44,600 Plant and equipment (net) 500,100 370,700 357,700 $726,200 $596,200 $532,500 Current liabilities $84,500 $79,200 $69,800 Long-term debt 144,900 84,800 50,500 Common stock, $10 par 369,000 312,000 315,000 Retained earnings 127,800 120,200 97,200 $726,200 $596,200 $532,500...
Condensed balance sheet and income statement data for Pina Corporation are presented here. PINA CORPORATION Balance...
Condensed balance sheet and income statement data for Pina Corporation are presented here. PINA CORPORATION Balance Sheets December 31 2022 2021 2020 Cash $ 32,000 $ 22,000 $ 20,000 Accounts receivable (net) 52,000 47,000 50,000 Other current assets 97,000 102,000 71,000 Investments 62,000 77,000 52,000 Plant and equipment (net) 500,000 370,000 358,000 $743,000 $618,000 $551,000 Current liabilities $ 87,000 $ 82,000 $ 72,000 Long-term debt 152,000 92,000 57,000 Common stock, $10 par 327,000 317,000 307,000 Retained earnings 177,000 127,000 115,000...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT