Calculating various ratios for analysis (Learning Objectives 2 & 3) 20-25 min.
Comparative financial statement data of Shabby Chic Furniture Company follow:
Shabby Chic Furniture Company Income Statement Years Ended December 31, 2913 and 2017 |
||||
2018 | 2017 | |||
Net Sales Cost of Goods Sold Gross Profit Operating Expenses Income from Operations Interest Expense Income Before income tax Income Tax Expense Net income |
$453,000 231,000 |
$490,000 240,000 |
||
222,000 133,000 |
250,000 132,000 |
|||
89,000 16,000 |
118,000 10,000 |
|||
73,000 24,000 |
108,000 30,000 |
|||
$49,000 | $78,000 |
Shabby Chic Furniture Company Balance Sheet December 31, 2018 and 2017 (Selected 2016 amounts given for computation of ratios) |
||||||||
2018 | 2017 | 2016 | ||||||
Current Assets: Cash Inventory Prepaid Expenses Total Current Assets Property, Plant, and Equipment, Net Total Assets Total Current Liabilities Long-Term Liabilities Total Liabilities Common Stockholders’ Equity, No Par Total Liabilities and Stockholders’ Equity |
$98,000 51,000 216,000 22,000 |
$97,000 45,000 230,000 30,000 |
$42,000 206,000 280,000 |
|||||
387,000 176,000 |
402,000 198,000 |
|||||||
$563,000 | $600,000 | |||||||
$203,000 | $210,000 121,000 |
|||||||
113, 000 | 331,000 269,000 |
|||||||
343,000 220,000 $563,000 |
$600,000 |
Other information follows:
- a. Market price of a share of common stock was $31.00 at December 31, 2018, and $48.50 at December 31, 2017.
- b. Average common shares outstanding were 11,000 during 2018 and 12,000 during 2017.
Requirements
- 1. Compute the following ratios for 2018 and 2017. Round to two decimal places. Assume all sales are on credit.
- a.
Current ratio - b. Inventory turnover
- c. Accounts receivable turnover
- d. Interest coverage ratio
- e. Return on equity
- f. Earnings per share of common stock
- g. Price-earnings ratio
- 2. Decide (a) whether Shabby Chic Furniture Company’s performance improved or deteriorated during 2018 and (b) whether the attractiveness of its common stock as an investment seems to have increased or decreased.
- 3. how will what you learned n this problem help you evaluate an investment?
Want to see the full answer?
Check out a sample textbook solutionChapter 12 Solutions
Pearson eText for Financial Accounting -- Instant Access (Pearson+)
- Mac Donald company reported the following on its comparative income statement: 2017 2018 2019 Revenue 9,000 10,000 14,000 Cost of goods sold 6,000 4,000 9,000 Prepare a horizontal analysis of revenue , cost of goods sold and gross profitarrow_forwardThe following are the financial statement JNC Ltd. for the year ended 31 March 2020: JNC Ltd. Income statement For the year ended 31 March 2020 $”M” Revenue 1276.50 Cost of sales (907.00) 369.50 Distribution costs (62.50) Administrative expenses (132.00) 175.00 Interest received 12.50 Interest paid (37.50) 150.00 Tax (70.00) Profit after tax 80.00 JNC Ltd. Statement of financial position as at 31 March 2020 2019 $”M” $”M” ASSETS: Non- current assets: Property, plant and equipment 190 152.5 Intangible assets 125 100 Investments 12.5 Current assets: Inventories 75 51 Receivables 195 157.5 Short-term investment 25 Cash in hand 1 0.5 Total assets 611 474 Equity and liabilities: Equity: Share capital (10 million ordinary shares of $ 10 per value) 100 75 Share premium 80 75 Revolution reserve 50 45.5 Retained earnings 130 90 Non-current liabilities: Loan 85 25…arrow_forwardsalamagundi, inc. has the following income statement: For the year ended December 31, 2021 net sales: $160 Cost of goods sold: $100 gross profit: $60 Operating expenses: $40 Net income: $20 Using vertical analysis, what percentage is assigned to operating expenses? a. 25% b. 40% c. 66.7% d. 200%arrow_forward
- KORBIN COMPANY Comparative Income Statements For Years Ended December 31, 2019, 2018, and 2017 2019 2018 2017 Sales $ 459,716 $ 352,180 $ 244,400 Cost of goods sold 276,749 223,282 156,416 Gross profit 182,967 128,898 87,984 Selling expenses 65,280 48,601 32,261 Administrative expenses 41,374 30,992 20,285 Total expenses 106,654 79,593 52,546 Income before taxes 76,313 49,305 35,438 Income tax expense 14,194 10,108 7,194 Net income $ 62,119 $ 39,197 $ 28,244 KORBIN COMPANY Comparative Balance Sheets December 31, 2019, 2018, and 2017 2019 2018 2017 Assets Current assets $ 58,718 $ 39,300 $ 52,535 Long-term investments 0 500 4,280 Plant assets, net 109,047 99,561 58,646 Total assets $ 167,765 $ 139,361 $ 115,461 Liabilities and Equity Current liabilities $ 24,494…arrow_forwardSelected comparative financial statements of Haroun Company follow. HAROUN COMPANY Comparative Income Statements For Years Ended December 31, 2021–2015 ($ thousands) 2021 2020 2019 2018 2017 2016 2015 Sales $ 2,318 $ 2,030 $ 1,847 $ 1,693 $ 1,580 $ 1,469 $ 1,204 Cost of goods sold 1,667 1,356 1,167 1,021 949 887 707 Gross profit 651 674 680 672 631 582 497 Operating expenses 497 389 356 263 228 225 187 Net income $ 154 $ 285 $ 324 $ 409 $ 403 $ 357 $ 310 HAROUN COMPANY Comparative Year-End Balance Sheets December 31, 2021–2015 ($ thousands) 2021 2020 2019 2018 2017 2016 2015 Assets Cash $ 89 $ 118 $ 122 $ 125 $ 130 $ 128 $ 132 Accounts receivable, net 640 672 608 467 411 389 275 Merchandise inventory 2,315 1,685 1,472 1,241 1,114 946 686 Other…arrow_forwardSelected information from Bigg Company's financial statements follows: Fiscal Year Ended December 31 2019 2018 2017 (in thousands) Gross sales $2,004,719 $1,937,021 $1,835,987 Less: Sales discounts 4,811 4,649 4,406 Less: Sales returns and allowances 2,406 2,324 2,203 Net sales $1,997,502 $1,930,048 $1,829,378 Cost of goods sold 621,463 619,847 660,955 Gross profit $1,376,039 $1,310,201 $1,168,423 Operating expenses 577,369 595,226 583,555 Operating income $798,670 $714,975 $584,868 Other income (expenses) 15,973 (6,070) (8,773) Net income $814,643 $708,905 $576,095 At December 31 2019 2018 2017 (in thousands) Accounts receivable $201,290 $195,427 $182,642 Less: Allowance for doubtful accounts 2,516 2,736 2,192 Net accounts receivable $198,774 $192,691 $180,450 Required: 1. Calculate the following ratios for 2018 and 2019. Round your answers to two decimal places. 2018 2019 a. Gross profit margin 67.88 % 68.89 % b. Operating margin 37.04 39.98 c. Net profit margin х % 36.77 40.78 % d.…arrow_forward
- The following are the financial statement Quick Ltd. for the year ended 31st December 2020: Quick Ltd. Income statement For year ended 31st December 2020 $”000” Revenue 1276.50 Cost of sales (907.00) 369.50 Distribution costs (62.50) Administrative expenses (132.00) 175.00 Interest received 12.50 Interest paid (37.50) Profit before tax 150.00 Tax (70.00) Profit after tax 80.00 Quick Ltd. Statement of financial position as at 31 December 2020 2019 $”000” $”000d” ASSETS: Non- current assets: Property, plant and equipment 190 152.5 Intangible assets 125 100 Investments 12.5 Current assets: Inventories 75 51 Receivables 195 157.5 Short-term investment 25 Cash in hand 1 0.5 Total assets 611 474 Equity and liabilities: Equity: Share capital 100 75 Share premium 80 75 Revolution reserve 50 45.5 Retained earnings 130 90 Non-current liabilities: Loan 85 25…arrow_forwardGIVE THE COMPARATIVE INCOME STATEMENT HORIZONTAL AND VERTICAL ANALYSIS FROM THE FOLLOWING INCOME STATEMENT BELOW JOLLIBEE INCOME STATEMENT ITEM 2016 2017 2018 2019 2020 Sales/Revenue 113.81B 133.61B 161.17B 179.63B 129.31B Sales Growth - 17.40% 20.62% 11.45% -28.01% Cost of Goods Sold (COGS) incl. D&A - - 132.96B 150.88B 115.39B COGS Growth - - - 13.47% -23.52% COGS excluding D&A 89.27B 105.39B 121.08B 137.38B 100.82B Depreciation & Amortization Expense 4B 4.75B 11.89B 13.5B 14.57B Depreciation 3.93B 4.66B 11.73B 13.34B 14.32B Amortization of Intangibles 68.99M 78.95M 151.82M 145.42M 245.23M Gross Income 20.54B 23.48B 28.21B 28.75B 13.92B Gross Income Growth - 14.30% 20.12% 1.93% -51.57% Gross Profit Margin - - - - 10.77% SG&A Expense - - 17.64B 20.21B 20.42B SGA Growth - - -…arrow_forwardThe following are the financial statement Kin Ltd. for the year ended 31 March 2020: Kin Ltd. Income statement For the year ended 31 March 2020 $”M” Revenue 1276.50 Cost of sales (907.00) 369.50 Distribution costs (62.50) Administrative expenses (132.00) 175.00 Interest received 12.50 Interest paid (37.50) 150.00 Tax (70.00) Profit after tax 80.00 Kin Ltd. Statement of financial position as at 31 March 2020 2019 $”M” $”M” ASSETS: Non- current assets: Property, plant and equipment 190 152.5 Intangible assets 125 100 Investments 12.5 Current assets: Inventories 75 51 Receivables 195 157.5 Short-term investment 25 Cash in hand 1 0.5 Total assets 611 474 Equity and liabilities: Equity: Share capital (10 million ordinary shares of $ 10 per value) 100 75 Share premium 80 75 Revolution reserve 50 45.5 Retained earnings 130 90 Non-current liabilities:…arrow_forward
- Selected comparative financial statements of Korbin Company follow. KORBIN COMPANY Comparative Income Statements For Years Ended December 31, 2019, 2018, and 2017 2019 2018 2017 $ 292,600 Sales $ 550,381 331,329 $ 421,637 Cost of goods sold 266,053 155,584 58,186 187,264 Gross profit 219,052 105,336 38,623 Selling expenses 78,154 49,534 127,688 91,364 16,994 Administrative expenses 37,104 24,286 Total expenses 95,290 60,294 12,360 62,909 Income before taxes 42,427 Income tax expense 8,613 Net income 74,370 47,934 33,814 KORBIN COMPANY Comparative Balance Sheets December 31, 2019, 2018, and 2017 2019 2018 2017 Assets Current assets Long-term investments Plant assets, net 2$ 61,979 %24 41,483 24 55,453 600 4,440 111,633 102.135 59,592 Total assets 173,612 24 144,218 $ 119,485 Liabilities and Equity Current liabilities 2$ 25,347 21,488 $ 64,000 $ 20,910 Common stock 64,000 46,000 Other paid-in capital Retained earnings 8,000 8,000 5,111 47,464 76,265 50,730 Total liabilities and equity 24…arrow_forwardSelected information from Bigg Company's financial statements follows: Fiscal Year Ended December 31 2019 2018(in thousands) 2017 Gross sales $2,004,719 $1,937,021 $1,835,987 Less: Sales discounts 4,811 4,649 4,406 Less: Sales returns and allowances 2,406 2,324 2,203 Net sales $1,997,502 $1,930,048 $1,829,378 Cost of goods sold 621,463 619,847 660,955 Gross profit $1,376,039 $1,310,201 $1,168,423 Operating expenses 577,369 595,226 583,555 Operating income $798,670 $714,975 $584,868 Other income (expenses) 15,973 (6,140) (8,773) Net income $814,643 $708,835 $576,095 At December 31 2019 2018(in thousands) 2017 Accounts receivable $201,290 $195,427 $182,642 Less: Allowance for doubtful accounts 2,516 2,736 2,192 Net accounts receivable $198,774 $192,691 $180,450 Required: 1. Calculate the following ratios for 2018 and 2019. Round your answers…arrow_forwardProblem I. The following data represent selected information from the comparative income statement and balance sheet for Little CPA Company for the years ended December 31, 2020 and 2019: 2020 2019 Net Sales (all on credit) P370,000 P333,000 Cost of goods sold 160,000 150,000 Gross profit 210,000 183,000 Income from operations 95,000 87,000 Interest expense 8,000 8,000 Net income 70,000 57,000 Cash 10,000 14,000 Accounts receivable, net 30,000 25,000 Inventory 43,000 40,000 Prepaid expenses 5,000 7,000 Total current assets 88,000 86,000 Total noncurrent assets 112,000 104,000 Total current liabilities 70,000 60,000 Total noncurrent liabilities 40,000 45,000 Ordinary share capital, no par* 60,000 60,000 Retained earnings 30,000 25,000 Note: 10,000 ordinary shares have been issued and outstanding since the company was established. They had a…arrow_forward
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education