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 |