KORBIN COMPANY Comparative Income Statements For Years Ended December 31, 2017, 2016, and 2015 2017 2016 2015 Sales $ 397,455 $ 304,483 $ 211,300 Cost of goods sold 239,268 192,738 135,232 Gross profit 158,187 111,745 76,068 Selling expenses 56,439 42,019 27,892 Administrative expenses 35,771 26,795 17,538 Total expenses 92,210 68,814 45,430 Income before taxes 65,977 42,931 30,638 Income taxes 12,272 8,801 6,220 Net income $ 53,705 $ 34,130 $ 24,418
KORBIN COMPANY Comparative Balance Sheets December 31, 2017, 2016, and 2015 2017 2016 2015 Assets Current assets $ 53,412 $ 41,789 $ 55,862 Long-term investments 0 1,000 4,480 Plant assets, net 99,195 105,398 62,431 Total assets $ 152,607 $ 148,187 $ 122,773 Liabilities andEquity Current liabilities $ 22,281 $ 22,080 $ 21,485 Common stock 69,000 69,000 51,000 Other paid-in capital 8,625 8,625 5,667 Retained earnings 52,701 48,482 44,621 Total liabilities andequity $ 152,607 $ 148,187 $ 122,773
Required:
1. Complete the below table to calculate eachyear's current ratio.
2. Complete the below table to calculate incomestatement data in common-size percents.
3. Complete the below table to calculate thebalance sheet data in trend percents with 2015 as the baseyear.
| KORBIN COMPANY | |||||||||
| Comparative Income Statements | |||||||||
| For Years Ended December 31, 2017, 2016, and 2015 | |||||||||
| 2017 | 2016 | 2015 | |||||||
| Sales | $ | 397,455 | $ | 304,483 | $ | 211,300 | |||
| Cost of goods sold | 239,268 | 192,738 | 135,232 | ||||||
| Gross profit | 158,187 | 111,745 | 76,068 | ||||||
| Selling expenses | 56,439 | 42,019 | 27,892 | ||||||
| Administrative expenses | 35,771 | 26,795 | 17,538 | ||||||
| Total expenses | 92,210 | 68,814 | 45,430 | ||||||
| Income before taxes | 65,977 | 42,931 | 30,638 | ||||||
| Income taxes | 12,272 | 8,801 | 6,220 | ||||||
| Net income | $ | 53,705 | $ | 34,130 | $ | 24,418 | |||
| KORBIN COMPANY | |||||||||
| Comparative Balance Sheets | |||||||||
| December 31, 2017, 2016, and 2015 | |||||||||
| 2017 | 2016 | 2015 | |||||||
| Assets | |||||||||
| Current assets | $ | 53,412 | $ | 41,789 | $ | 55,862 | |||
| Long-term investments | 0 | 1,000 | 4,480 | ||||||
| Plant assets, net | 99,195 | 105,398 | 62,431 | ||||||
| Total assets | $ | 152,607 | $ | 148,187 | $ | 122,773 | |||
| Liabilities andEquity | |||||||||
| Current liabilities | $ | 22,281 | $ | 22,080 | $ | 21,485 | |||
| Common stock | 69,000 | 69,000 | 51,000 | ||||||
| Other paid-in capital | 8,625 | 8,625 | 5,667 | ||||||
| Retained earnings | 52,701 | 48,482 | 44,621 | ||||||
| Total liabilities andequity | $ | 152,607 | $ | 148,187 | $ | 122,773 | |||
|
2. Complete the below table to calculate incomestatement data in common-size percents. 3. Complete the below table to calculate thebalance sheet data in trend percents with 2015 as the baseyear. | |||||||||
Related questions
| **PLEASE FILL OUT THE GRAPH DISPLAYED** Selected comparative financial statements of Korbin Companyfollow: |
| KORBIN COMPANY | ||||||||||||
| Comparative Income Statements | ||||||||||||
| For Years Ended December 31, 2015, 2014, and 2013 | ||||||||||||
| 2015 | 2014 | 2013 | ||||||||||
| Sales | $ | 378,645 | $ | 290,073 | $ | 201,300 | ||||||
| Costof goods sold | 227,944 | 181,586 | 128,832 | |||||||||
| Gross profit | 150,701 | 108,487 | 72,468 | |||||||||
| Selling expenses | 53,768 | 40,030 | 26,572 | |||||||||
| Administrative expenses | 34,078 | 25,526 | 16,708 | |||||||||
| Total expenses | 87,846 | 65,556 | 43,280 | |||||||||
| Income before taxes | 62,855 | 42,931 | 29,188 | |||||||||
| Income taxes | 11,691 | 8,801 | 5,925 | |||||||||
| Netincome | $ | 51,164 | $ | 34,130 | $ | 23,263 | ||||||
| KORBIN COMPANY | ||||||||||||
| Comparative Balance Sheets | ||||||||||||
| December 31, 2015, 2014, and 2013 | ||||||||||||
| 2015 | 2014 | 2013 | ||||||||||
| Assets | ||||||||||||
| Current assets | $ | 47,581 | $ | 37,227 | $ | 49,763 | ||||||
| Long-term investments | 0 | 900 | 4,800 | |||||||||
| Plant assets, net | 87,020 | 92,575 | 53,724 | |||||||||
| Total assets | $ | 134,601 | $ | 130,702 | $ | 108,287 | ||||||
| Liabilities and Equity | ||||||||||||
| Current liabilities | $ | 19,652 | $ | 19,475 | $ | 18,950 | ||||||
| Common stock | 72,000 | 72,000 | 54,000 | |||||||||
| Other paid-in capital | 9,000 | 9,000 | 6,000 | |||||||||
| Retained earnings | 33,949 | 30,227 | 29,337 | |||||||||
| Total liabilities and equity | $ | 134,601 | $ | 130,702 | $ | 108,287 | ||||||
| Choose Numerator | / | Choose Denominator | = | Current ratio | |
|---|---|---|---|---|---|
| / | = | Current ratio | |||
| 2015 | / | = | ____ to 1 | ||
| 2014 | / | = | ____ to 1 | ||
| 2013 | / | = | ____ to 1 |
Complete the below table to calculate income statement data incommon-size percents. (Round your percentage answers to 2decimal places.)
| Korbin Company | ||||||
| Common-size comparative income statements | ||||||
| For Years Ended December 31, 2015, 2014, and 2013 | ||||||
| 2015 | 2014 | 2013 | ||||
| Sales | % | % | % | |||
| Cost of goods sold | ||||||
| Gross profit | ||||||
| Selling expenses | ||||||
| Administrative expenses | ||||||
| Total expenses | ||||||
| Income before taxes | ||||||
| Income taxes | ||||||
| Net income | % | % | % |
Complete the below table to calculate the balance sheet data intrend percents with 2013 as the base year. (Round yourpercentage answers to 2 decimal places.)
| Korbin Company | ||||||
| Balance sheet data in trend percents | ||||||
| December 31, 2015, 2014, and 2013 | ||||||
| 2015 | 2014 | 2013 | ||||
| Assests | ||||||
| Current assets | % | % | 100.0 | % | ||
| Long-term investments | 100.0 | |||||
| Plant assets, net | 100.0 | |||||
| Total assets | 100.0 | |||||
| âLiabilities and Equity | ||||||
| Current liabilities | % | % | 100.0 | % | ||
| Common stock | 100.0 | |||||
| Other paid-in capital | 100.0 | |||||
| Retained earnings | 100.0 | |||||
| Total liabilities and equity | % | % | 100.0 | % |
**PLEASE FILL OUT THE GRAPH DISPLAYED**
Exercise 13-13
The condensed financial statements of Crane Company for theyears 2016 and 2017 are presented below.
CRANE COMPANY | ||||
2017 | 2016 | |||
| Current assets | ||||
| Cash and cash equivalents | $330 | $360 | ||
| Accounts receivable (net) | 530 | 460 | ||
| Inventory | 640 | 570 | ||
| Prepaid expenses | 130 | 160 | ||
| Total current assets | 1,630 | 1,550 | ||
| Property, plant, and equipment (net) | 410 | 380 | ||
| Investments | 70 | 70 | ||
| Intangibles and other assets | 530 | 510 | ||
| Total assets | $2,640 | $2,510 | ||
| Current liabilities | $880 | $850 | ||
| Long-term liabilities | 660 | 560 | ||
| Stockholdersâ equityâcommon | 1,100 | 1,100 | ||
| Total liabilities andstockholdersâ equity | $2,640 | $2,510 | ||
CRANE COMPANY | ||||
2017 | 2016 | |||
| Sales revenue | $3,980 | $3,640 | ||
| Costs and expenses | ||||
| Cost of goods sold | 1,030 | 950 | ||
| Selling & administrative expenses | 2,400 | 2,330 | ||
| Interest expense | 10 | 20 | ||
| Total costs and expenses | 3,440 | 3,300 | ||
| Income before income taxes | 540 | 340 | ||
| Income tax expense | 216 | 136 | ||
| Net income | $ 324 | $ 204 | ||
Compute the following ratios for 2017 and 2016. (Roundcurrent ratio and inventory turnover to 2 decimal places, e.g 1.83and all other answers to 1 decimal place, e.g. 1.8 or12.6%.)
| (a) | Current ratio. | |
| (b) | Inventory turnover. (Inventory on December 31, 2015, was$390.) | |
| (c) | Profit margin. | |
| (d) | Return on assets. (Assets on December 31, 2015, were$2,720.) | |
| (e) | Return on common stockholdersâ equity. (Equity on December 31,2015, was $950.) | |
| (f) | Debt to assets ratio. | |
| (g) | Times interest earned. |
