In: Accounting
[The following information applies to the questions displayed below.]
Selected comparative financial statements of Korbin Company follow:
| KORBIN COMPANY | |||||||||
| Comparative Income Statements | |||||||||
| For Years Ended December 31, 2018, 2017, and 2016 | |||||||||
| 2018 | 2017 | 2016 | |||||||
| Sales | $ | 444,857 | $ | 340,797 | $ | 236,500 | |||
| Cost of goods sold | 267,804 | 215,043 | 151,360 | ||||||
| Gross profit | 177,053 | 125,754 | 85,140 | ||||||
| Selling expenses | 63,170 | 47,030 | 31,218 | ||||||
| Administrative expenses | 40,037 | 29,990 | 19,630 | ||||||
| Total expenses | 103,207 | 77,020 | 50,848 | ||||||
| Income before taxes | 73,846 | 48,734 | 34,292 | ||||||
| Income tax expense | 13,735 | 9,990 | 6,961 | ||||||
| Net income | $ | 60,111 | $ | 38,744 | $ | 27,331 | |||
| KORBIN COMPANY | |||||||||
| Comparative Balance Sheets | |||||||||
| December 31, 2018, 2017, and 2016 | |||||||||
| 2018 | 2017 | 2016 | |||||||
| Assets | |||||||||
| Current assets | $ | 46,886 | $ | 36,682 | $ | 49,036 | |||
| Long-term investments | 0 | 900 | 3,460 | ||||||
| Plant assets, net | 89,807 | 95,152 | 57,474 | ||||||
| Total assets | $ | 136,693 | $ | 132,734 | $ | 109,970 | |||
| Liabilities and Equity | |||||||||
| Current liabilities | $ | 19,957 | $ | 19,777 | $ | 19,245 | |||
| Common stock | 64,000 | 64,000 | 46,000 | ||||||
| Other paid-in capital | 8,000 | 8,000 | 5,111 | ||||||
| Retained earnings | 44,736 | 40,957 | 39,614 | ||||||
| Total liabilities and equity | $ | 136,693 | $ | 132,734 | $ | 109,970 | |||
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 2016 as the base year. (Round your percentage answers to 2 decimal places.)
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Current Ratio = Current Asset / Current Liability
Percentage in Comon size income statement = Individuval item / Net Sales x 100%
Increase (Decrease) in Trend analysis balance sheet = amount in Current Year - Amount in base year
% changes = (Increase or Decrease) / Amount in base year x 100%
| Numerator | Denominator | Answer | |||
| 2018 | 46,886 | / | 19,957 | 2.35 | :1 |
| 2017 | 36,682 | / | 19,777 | 1.85 | :1 |
| 2016 | 49,036 | / | 19,245 | 2.55 | :1 |
Common size analysis of Income statement were as follows:
| KORBIN COMPANY | ||||||
| COMPARATIVE INCOME STATEMENT | ||||||
| 2018 | % | 2017 | % | 2016 | % | |
| Sales | 444,857 | 100.00% | 340,797 | 100.00% | 236,500 | 100.00% |
| Cost of Goods Sold | 267,804 | 60.20% | 215,043 | 63.10% | 151,360 | 64.00% |
| Gross Profit | 177,053 | 39.80% | 125,754 | 36.90% | 85,140 | 36.00% |
| Selling Expense | 63,170 | 14.20% | 47,030 | 13.80% | 31,218 | 13.20% |
| Administrative Expense | 40,037 | 9.00% | 29,990 | 8.80% | 19,630 | 8.30% |
| Total Expense | 103,207 | 23.20% | 77,020 | 22.60% | 50,848 | 21.50% |
| Income Before Tax | 73,846 | 16.60% | 48,734 | 14.30% | 34,292 | 14.50% |
| Income Tax Expense | 13,735 | 3.09% | 9,990 | 2.93% | 6,961 | 2.94% |
| Net Income | 60,111 | 13.51% | 38,744 | 11.37% | 27,331 | 11.56% |
Trend analysis of balance sheet as follows:
| KORBIN COMPANY | |||||||
| Balance sheet in Trend Percentage | |||||||
| 2018 | Increase (Decrease) | % Changes | 2017 | Increase (Decrease) | % Changes | 2016 | |
| Assets | |||||||
| Current Assets | 46,886 | (2,150) | -4.38% | 36,682 | (12,354) | -25.19% | 49,036 |
| Long Term Investment | - | (3,460) | -100.00% | 900 | (2,560) | -73.99% | 3,460 |
| Plant Asset Net | 89,807 | 32,333 | 56.26% | 95,152 | 37,678 | 65.56% | 57,474 |
| Total Assets | 136,693 | 26,723 | 24.30% | 132,734 | 22,764 | 20.70% | 109,970 |
| Liability and Equity | |||||||
| Current Liability | 19,957 | 712 | 3.70% | 19,777 | 532 | 2.76% | 19,245 |
| Common Stock | 64,000 | 18,000 | 39.13% | 64,000 | 18,000 | 39.13% | 46,000 |
| Other Paid in Capital | 8,000 | 2,889 | 56.53% | 8,000 | 2,889 | 56.53% | 5,111 |
| Retained Earnings | 44,736 | 5,122 | 12.93% | 40,957 | 1,343 | 3.39% | 39,614 |
| Total Liability and Equity | 136,693 | 26,723 | 24.30% | 132,734 | 22,764 | 20.70% | 109,970 |