Question

In: Accounting

Selected comparative financial statements of Korbin Company follow. KORBIN COMPANY Comparative Income Statements For Years Ended...

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
Sales $ 386,357 $ 295,981 $ 205,400
Cost of goods sold 232,587 186,172 131,456
Gross profit 153,770 109,809 73,944
Selling expenses 54,863 40,845 27,113
Administrative expenses 34,772 26,046 17,048
Total expenses 89,635 66,891 44,161
Income before taxes 64,135 42,918 29,783
Income tax expense 11,929 8,798 6,046
Net income $ 52,206 $ 34,120 $ 23,737
KORBIN COMPANY
Comparative Balance Sheets
December 31, 2019, 2018, and 2017
2019 2018 2017
Assets
Current assets $ 55,556 $ 37,184 $ 49,706
Long-term investments 0 1,000 3,140
Plant assets, net 104,780 95,006 57,502
Total assets $ 160,336 $ 133,190 $ 110,348
Liabilities and Equity
Current liabilities $ 23,409 $ 19,845 $ 19,311
Common stock 73,000 73,000 55,000
Other paid-in capital 9,125 9,125 6,111
Retained earnings 54,802 31,220 29,926
Total liabilities and equity $ 160,336 $ 133,190 $ 110,348

Required:
1. Complete the below table to calculate each year's current ratio.

2. Complete the below table to calculate income statement data in common-size percents. (Round your percentage answers to 2 decimal places.)

3. Complete the below table to calculate the balance sheet data in trend percents with 2017 as base year. (Round your percentage answers to 2 decimal places.)

4. Refer to the results from parts 1, 2, and 3.

(a) Did cost of goods sold make up a greater portion of sales for the most recent year?

  • Yes

  • No



(b) Did income as a percent of sales improve in the most recent year?

  • Yes

  • No



(c) Did plant assets grow over this period?

  • Yes

  • No

Solutions

Expert Solution

1)

Current Ratio = Current Asset / Current Liabilities

2019 = 55556 / 23409 = 2.37

2018 = 37184 / 19845 = 1.87

2017 = 49706 / 19311 = 2.57

2)

Common Size Income Statement
2019 Percentage 2018 Percentage 2017 Percentage
Sales        386,357 100.00%        295,981 100.00%        205,400 100.00%
Cost of Goods Sold        232,587 60.20%        186,172 62.90%        131,456 64.00%
Gross Profit        153,770 39.80%        109,809 37.10%          73,944 36.00%
Selling Expense          54,863 14.20%          40,845 13.80%          27,113 13.20%
Administrative Expense          34,772 9.00%          26,046 8.80%          17,048 8.30%
Total Expense          89,635 23.20%          66,891 22.60%          44,161 21.50%
Income Before Taxes          64,135 16.60%          42,918 14.50%          29,783 14.50%
Income Tax Expense          11,929 3.09%            8,798 2.97%            6,046 2.94%
Net Income         52,206 13.51%         34,120 11.53%         23,737 11.56%

Percentage is found by dividing the each item by sales amount.

3)

Trend Analysis of Balance Sheet
2019 2017 Increase (Decrease) % of Change 2018 2017 Increase (Decrease) % of Change
Current Asset        55,556       49,706            5,850 11.77%       37,184       49,706        (12,522) -25.19%
Long Term Investment               -           3,140          (3,140) -100.00%         1,000         3,140          (2,140) -68.15%
Plant Asset - Net      104,780       57,502          47,278 82.22%       95,006       57,502          37,504 65.22%
Total Asset    160,336 110,348        49,988 45.30% 133,190 110,348        22,842 20.70%
Liabilities and Equity
Current Liabilities        23,049       19,311            3,738 19.36%       19,845       19,311               534 2.77%
Common Stock        73,000       55,000          18,000 32.73%       73,000       55,000          18,000 32.73%
Other Paid in Capital          9,125         6,111            3,014 49.32%         9,125         6,111            3,014 49.32%
Retained Earnings        54,802       29,926          24,876 83.13%       31,220       29,926            1,294 4.32%
Total Liabilities and Equity    160,336 110,348        49,988 45.30% 133,190 110,348        22,842 20.70%

Increase or decrease = Amount in Current Year - Amount in Base year

% changes = Increase or Decrease / Amount in Base year x 100%

4)

a) No . Cost of goods sold reducing year by year while comparing with sales.

b) Yes. Net income increased while comparing with last year

c) Yes increased


Related Solutions

Selected comparative financial statements of Korbin Company follow. KORBIN COMPANY Comparative Income Statements For Years Ended...
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 Sales $ 527,432 $ 404,056 $ 280,400 Cost of goods sold 317,514 252,939 179,456 Gross profit 209,918 151,117 100,944 Selling expenses 74,895 55,760 37,013 Administrative expenses 47,469 35,557 23,273 Total expenses 122,364 91,317 60,286 Income before taxes 87,554 59,800 40,658 Income tax expense 16,285 12,259 8,254 Net income $ 71,269 $ 47,541 $ 32,404 KORBIN...
Selected comparative financial statements of Korbin Company follow. KORBIN COMPANY Comparative Income Statements For Years Ended...
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 Sales $ 479,843 $ 367,599 $ 255,100 Cost of goods sold 288,865 230,117 163,264 Gross profit 190,978 137,482 91,836 Selling expenses 68,138 50,729 33,673 Administrative expenses 43,186 32,349 21,173 Total expenses 111,324 83,078 54,846 Income before taxes 79,654 54,404 36,990 Income tax expense 14,816 11,153 7,509 Net income $ 64,838 $ 43,251 $ 29,481 KORBIN...
Selected comparative financial statements of Korbin Company follow. KORBIN COMPANY Comparative Income Statements For Years Ended...
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 Sales $ 479,843 $ 367,599 $ 255,100 Cost of goods sold 288,865 230,117 163,264 Gross profit 190,978 137,482 91,836 Selling expenses 68,138 50,729 33,673 Administrative expenses 43,186 32,349 21,173 Total expenses 111,324 83,078 54,846 Income before taxes 79,654 54,404 36,990 Income tax expense 14,816 11,153 7,509 Net income $ 64,838 $ 43,251 $ 29,481 KORBIN...
Selected comparative financial statements of Korbin Company follow: KORBIN COMPANY Comparative Income Statements For Years Ended...
Selected comparative financial statements of Korbin Company follow: KORBIN COMPANY Comparative Income Statements For Years Ended December 31, 2017, 2016, and 2015 2017 2016 2015 Sales $ 392,189 $ 300,449 $ 208,500 Cost of goods sold 236,098 189,884 133,440 Gross profit 156,091 110,565 75,060 Selling expenses 55,691 41,462 27,522 Administrative expenses 35,297 26,440 17,306 Total expenses 90,988 67,902 44,828 Income before taxes 65,103 42,663 30,232 Income taxes 12,109 8,746 6,137 Net income $ 52,994 $ 33,917 $ 24,095 KORBIN COMPANY...
Selected comparative financial statements of Korbin Company follow.
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 Sales $ 484,546   $ 371,202   $ 257,600   Cost of goods sold   291,697     233,486     164,864   Gross profit   192,849     137,716     92,736   Selling expenses   68,806     51,226     34,003   Administrative expenses   43,609     32,666    ...
Selected comparative financial statements of Haroun Company follow. HAROUN COMPANY Comparative Income Statements For Years Ended...
Selected comparative financial statements of Haroun Company follow. HAROUN COMPANY Comparative Income Statements For Years Ended December 31, 2017–2011 ($ thousands) 2017 2016 2015 2014 2013 2012 2011 Sales $ 1,550 $ 1,357 $ 1,235 $ 1,132 $ 1,056 $ 982 $ 805 Cost of goods sold 1,115 907 780 683 635 594 473 Gross profit 435 450 455 449 421 388 332 Operating expenses 332 260 238 176 152 150 125 Net income $ 103 $ 190 $ 217...
Selected comparative financial statements of Haroun Company follow. HAROUN COMPANY Comparative Income Statements For Years Ended...
Selected comparative financial statements of Haroun Company follow. HAROUN COMPANY Comparative Income Statements For Years Ended December 31, 2019–2013 ($ thousands) 2019 2018 2017 2016 2015 2014 2013 Sales $ 2,778 $ 2,433 $ 2,214 $ 2,029 $ 1,893 $ 1,760 $ 1,443 Cost of goods sold 1,997 1,625 1,398 1,223 1,137 1,063 847 Gross profit 781 808 816 806 756 697 596 Operating expenses 595 465 427 315 273 269 224 Net income $ 186 $ 343 $ 389...
Selected comparative financial statements of Haroun Company follow. HAROUN COMPANY Comparative Income Statements For Years Ended...
Selected comparative financial statements of Haroun Company follow. HAROUN COMPANY Comparative Income Statements For Years Ended December 31, 2017–2011 ($ thousands) 2017 2016 2015 2014 2013 2012 2011 Sales $ 2,780 $ 2,435 $ 2,215 $ 2,030 $ 1,895 $ 1,762 $ 1,444 Cost of goods sold 2,000 1,626 1,399 1,225 1,138 1,064 848 Gross profit 780 809 816 805 757 698 596 Operating expenses 595 465 427 315 273 269 224 Net income $ 185 $ 344 $ 389...
Selected comparative financial statements of Haroun Company follow. HAROUN COMPANY Comparative Income Statements For Years Ended...
Selected comparative financial statements of Haroun Company follow. HAROUN COMPANY Comparative Income Statements For Years Ended December 31, 2017–2011 ($ thousands) 2017 2016 2015 2014 2013 2012 2011 Sales $ 1,475 $ 1,291 $ 1,175 $ 1,077 $ 1,005 $ 935 $ 766 Cost of goods sold 1,061 863 743 650 604 565 450 Gross profit 414 428 432 427 401 370 316 Operating expenses 316 247 227 167 145 143 119 Net income $ 98 $ 181 $ 205...
Selected comparative financial statements of Haroun Company follow. HAROUN COMPANY Comparative Income Statements For Years Ended...
Selected comparative financial statements of Haroun Company follow. HAROUN COMPANY Comparative Income Statements For Years Ended December 31, 2017–2011 ($ thousands) 2017 2016 2015 2014 2013 2012 2011 Sales $ 1,648 $ 1,443 $ 1,313 $ 1,204 $ 1,123 $ 1,044 $ 856 Cost of goods sold 1,184 963 828 725 674 630 502 Gross profit 464 480 485 479 449 414 354 Operating expenses 353 276 253 187 162 160 133 Net income $ 111 $ 204 $ 232...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT