In: Accounting
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 2015 as the base year. (Round your percentage answers to 2 decimal places.)
Required information
[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, 2017, 2016, and 2015 | |||||||||
| 2017 | 2016 | 2015 | |||||||
| Sales | $ | 440,342 | $ | 337,338 | $ | 234,100 | |||
| Cost of goods sold | 265,086 | 211,511 | 149,824 | ||||||
| Gross profit | 175,256 | 125,827 | 84,276 | ||||||
| Selling expenses | 62,529 | 46,553 | 30,901 | ||||||
| Administrative expenses | 39,631 | 29,686 | 19,430 | ||||||
| Total expenses | 102,160 | 76,239 | 50,331 | ||||||
| Income before taxes | 73,096 | 49,588 | 33,945 | ||||||
| Income taxes | 13,596 | 10,166 | 6,891 | ||||||
| Net income | $ | 59,500 | $ | 39,422 | $ | 27,054 | |||
| KORBIN COMPANY | |||||||||
| Comparative Balance Sheets | |||||||||
| December 31, 2017, 2016, and 2015 | |||||||||
| 2017 | 2016 | 2015 | |||||||
| Assets | |||||||||
| Current assets | $ | 53,155 | $ | 41,588 | $ | 55,593 | |||
| Long-term investments | 0 | 1,100 | 3,100 | ||||||
| Plant assets, net | 97,214 | 103,326 | 62,280 | ||||||
| Total assets | $ | 150,369 | $ | 146,014 | $ | 120,973 | |||
| Liabilities and Equity | |||||||||
| Current liabilities | $ | 21,954 | $ | 21,756 | $ | 21,170 | |||
| Common stock | 68,000 | 68,000 | 50,000 | ||||||
| Other paid-in capital | 8,500 | 8,500 | 5,556 | ||||||
| Retained earnings | 51,915 | 47,758 | 44,247 | ||||||
| Total liabilities and equity | $ | 150,369 | $ | 146,014 | $ | 120,973 | |||
|
KORBIN COMPANY |
|||||||||
|
Comparative Income Statements |
|||||||||
|
For Years Ended December 31, 2017, 2016, and 2015 |
|||||||||
|
2017 |
Percentage of total sales = Individual value/total sales |
2016 |
Percentage of total sales = Individual value/total sales |
2015 |
Percentage of total sales = Individual value/total sales |
||||
|
Sales |
$ |
440,342 |
100.00% |
$ |
337,338 |
100.00% |
$ |
234,100 |
100.00% |
|
Cost of goods sold |
265,086 |
60.20% |
211,511 |
62.70% |
149,824 |
64.00% |
|||
|
Gross profit |
175,256 |
39.80% |
125,827 |
37.30% |
84,276 |
36.00% |
|||
|
Selling expenses |
62,529 |
14.20% |
46,553 |
13.80% |
30,901 |
13.20% |
|||
|
Administrative expenses |
39,631 |
9.00% |
29,686 |
8.80% |
19,430 |
8.30% |
|||
|
Total expenses |
102,160 |
23.20% |
76,239 |
22.60% |
50,331 |
21.50% |
|||
|
Income before taxes |
73,096 |
16.60% |
49,588 |
14.70% |
33,945 |
14.50% |
|||
|
Income taxes |
13,596 |
3.09% |
10,166 |
3.01% |
6,891 |
2.94% |
|||
|
Net income |
$ |
59,500 |
13.51% |
$ |
39,422 |
11.69% |
$ |
27,054 |
11.56% |
|
KORBIN COMPANY |
|||||||||
|
Comparative Balance Sheets |
|||||||||
|
December 31, 2017, 2016, and 2015 |
|||||||||
|
2017 |
2016 |
2015 |
|||||||
|
Assets |
Increase or decrease over Year 2017 = (individual value 2017 -individual value 2015)/Individual value 2015) |
Individual values |
Increase or decrease over Year 2016 = (individual value 2016 -individual value 2015)/Individual value 2015) |
Individual values |
2015 = base value |
||||
|
Current assets |
-4.39% |
53,155 |
-25.19% |
41,588 |
$ |
55,593 |
|||
|
Long-term investments |
-100.00% |
0 |
-64.52% |
1,100 |
3,100 |
||||
|
Plant assets, net |
56.09% |
97,214 |
65.91% |
103,326 |
62,280 |
||||
|
Total assets |
24.30% |
150,369 |
20.70% |
146,014 |
$ |
120,973 |
|||
|
Liabilities and Equity |
|||||||||
|
Current liabilities |
3.70% |
21,954 |
2.77% |
21,756 |
$ |
21,170 |
|||
|
Common stock |
36.00% |
68,000 |
36.00% |
68,000 |
50,000 |
||||
|
Other paid-in capital |
52.99% |
8,500 |
52.99% |
8,500 |
5,556 |
||||
|
Retained earnings |
17.33% |
51,915 |
7.94% |
47,758 |
44,247 |
||||
|
Total liabilities and equity |
24.30% |
150,369 |
20.70% |
146,014 |
$ |
120,973 |
|||