Question

In: Accounting

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

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

Solutions

Expert Solution

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


Related Solutions

            Common Size Income statement 2017 2016 $M Percentage $M Percentage Operating revenue 2319 100% 2375...
            Common Size Income statement 2017 2016 $M Percentage $M Percentage Operating revenue 2319 100% 2375 100% Operating expenses -1666 -71.84% -1725 -72.63% Earnings before interest, tax, depreciation, amortisation, changes in fair value of hedges and other signifcant items (EBITDAF) 653 28.16% 650 27.37% Depreciation and amortisation -264 -11.38% -236 -9.94% Impairment of assets -10 -0.43% -4 -0.17% Loss on sale of assets -4 -0.17% -1 -0.04% Net change in fair value of electricity and other hedges -76 -3.28% -15...
to create a common size income statement ---- all items on the income statement by -----...
to create a common size income statement ---- all items on the income statement by ----- a) divide; net income b) multiply; total revenue c) multiply; net income d) divide; total revenue
Question 1 of 10 Express net income as a common-size percentage using the following data. Sales...
Question 1 of 10 Express net income as a common-size percentage using the following data. Sales - $45,000; cost of goods sold - $29,340; gross profit from sales - $15,660; operating expenses - $10,800; net income - $4,860. A. 100 percent B. 31 percent C. 12 percent D. 10.8 percent            Question 2 of 10 The excess of total assets over total liabilities is called working capital. A. True B. False Question 3 of 10 Any reputable company has a cash...
Complete the following table: (Use Table 15.1) (Do not round intermediate calculations. Round your answers to...
Complete the following table: (Use Table 15.1) (Do not round intermediate calculations. Round your answers to the nearest cent.) First Payment Broken Down Into— Selling price Down payment Amount mortgage Rate Years Monthly payment Interest Principal Balance at end of month $150,000 $30,000 $120,000 7% 30 $ $ $ $
Using the table below create SinCo's Income Statement for 2013 and 2014.(Do not round intermediate calculations....
Using the table below create SinCo's Income Statement for 2013 and 2014.(Do not round intermediate calculations. Round your answer to 2 decimal places.) 2017 2018 Revenue $4,000 4053 Cost of Good Sold 1,600 1,702 Depreciation 500 505 Inventory 300 352 SG&A 500 545 Interest Expenses 150 160 Common Stock and Paid-in Capital 2,200 2,200 Federal and State Taxes (35% of EBT) 400 Accounts Payable 300 315 Accounts Receivable 400 437 Net Fixed Assets 5,000 5269 Retained Earnings (Balance Sheet) 1,000...
Using the table below create SinCo's Income Statement for 2013 and 2014.(Do not round intermediate calculations....
Using the table below create SinCo's Income Statement for 2013 and 2014.(Do not round intermediate calculations. Round your answer to 2 decimal places.) 2013 2014 Revenue $4,000 5252 Cost of Good Sold 1,600 2,101 Depreciation 500 524 Inventory 300 335 SG&A 500 534 Interest Expenses 150 175 Common Stock and Paid-in Capital 2,200 2,200 Federal and State Taxes (35% of EBT) 400 Accounts Payable 300 354 Accounts Receivable 400 424 Net Fixed Assets 5,000 4962 Retained Earnings (Balance Sheet) 1,000...
Complete the table below. (Note: Round off your answers to the nearest hundredths. Don't use comma)...
Complete the table below. (Note: Round off your answers to the nearest hundredths. Don't use comma) Ra r m t Present Value P 1,100 8% annually 20 years P 2,200 9% semi - annually 15 years P 3,300 10% quarterly 10 years P 4,400 11% monthly 5 years P5,500 12% annually 5 years
50. Provide common-size analysis of your company’s (La-Z-Boy) income statement and balance sheet for the 2...
50. Provide common-size analysis of your company’s (La-Z-Boy) income statement and balance sheet for the 2 most recent years (must be done using Excel with formulas).
Use the following data to prepare a common-size comparative income statement for Old Mill Corporation on...
Use the following data to prepare a common-size comparative income statement for Old Mill Corporation on December 31, 2016. Round percentages to one-tenth percent. 2016 2015 Net sales $1,151,000 $1,350,000 Expenses:    Cost of goods sold $980,000 $860,000    Selling and general expenses 290,000 230,000    Interest expense 59,000 59,000    Income tax expense 71,000 53,000    Total expenses $1,400,000 $1,202,000    Net income $110,000 $148,000
Using the data below, calculate the correlation of these samples. Round your answer to 1 decimal...
Using the data below, calculate the correlation of these samples. Round your answer to 1 decimal place. seed_mass seedling_height 2.06 7.91 5.06 7.22 2.2 7.29 5.91 8.91 5.6 6.93 4.54 6.62 6.6 8.47 4.79 2.87 6.15 9.18 5 6.14 5.77 6.34 4.33 2.22 5.38 7.7 4.25 2.77 5.41 8.29 5.01 7.66 6.26 6.73 5.07 6.26 5.5 2.89 5.23 7.14 4.24 2.48 5.89 8.36 5.32 6.26 5.56 6.04 4.95 6.97
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT