In: Accounting
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
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