Question

In: Accounting

Exercise 13-04 Operating data for Sheffield Corp. are presented below. 2022 2021 Sales revenue $839,100 $649,000...

Exercise 13-04

Operating data for Sheffield Corp. are presented below.

2022

2021

Sales revenue

$839,100 $649,000

Cost of goods sold

522,400 410,700

Selling expenses

121,700 76,300

Administrative expenses

76,200 54,000

Income tax expense

34,200 24,400

Net income

84,600 83,600

Prepare a schedule showing a vertical analysis for 2022 and 2021. (Round percentages to 1 decimal place, e.g. 12.1%.)
SHEFFIELD CORP.
Condensed Income Statement

choose the accouning period

For the Month Ended December 31December 31For the Years Ended December 31

2022

2021

Amount

Percent

Amount

Percent

Sales

$839,100

enter percentages

%

$649,000

enter percentages

%

Cost of goods sold

522,400

enter percentages

%

410,700

enter percentages

%

Gross profit

316,700

enter percentages

%

238,300

enter percentages

%

Selling expenses

121,700

enter percentages

%

76,300

enter percentages

%

Administrative expenses

76,200

enter percentages

%

54,000

enter percentages

%

Total operating expenses

197,900

enter percentages

%

130,300

enter percentages

%

Income before income taxes

118,800

enter percentages

%

108,000

enter percentages

%

Income tax expense

34,200

enter percentages

%

24,400

enter percentages

%

Net income

$ 84,600

enter percentages

%

$ 83,600

enter percentages

Solutions

Expert Solution

Ans. SHEFFIELD CORP.
Condensed Income Statement
For the Years Ended December 31, 2022 and 2021
2022 2021
Amount Percent (%) Amount Percent (%)
Sales $839,100 100.0% $649,000 100.0%
Cost of goods sold $522,400 62.3% $410,700 63.3%
Gross profit $316,700 37.7% $238,300 36.7%
Selling expenses $121,700 14.5% $76,300 11.8%
General and Administrative expenses $76,200 9.1% $54,000 8.3%
Total operating expenses $197,900 23.6% $130,300 20.1%
Income before income taxes $118,800 14.2% $108,000 16.6%
Income tax expense $34,200 4.1% $24,400 3.8%
Net income $84,600 10.1% $83,600 12.9%
Amount in percentage for 2022 =   Particular amount of 2022 / Net sales * 100
Amount in percentage for 2021 =   Particular amount of 2021 / Net sales * 100

Related Solutions

1. Operating data for Martinez Corp. are presented as follows. 2022 2021 Sales revenue $842,600 $639,100...
1. Operating data for Martinez Corp. are presented as follows. 2022 2021 Sales revenue $842,600 $639,100 Cost of goods sold 530,838 409,024 Selling expenses 122,177 76,692 Administrative expenses 71,621 51,128 Income tax expense 37,917 25,564 Net income 80,047 76,692 Prepare a schedule showing a vertical analysis for 2022 and 2021. (Round percentages to 1 decimal place, e.g. 12.1%.) 2. Here is financial information for Splish Brothers Inc. December 31, 2022 December 31, 2021 Current assets $109,852 $ 94,700 Plant assets...
Sheffield Corp.’s balance sheet at December 31, 2021, is presented below. SHEFFIELD CORP. Balance Sheet December...
Sheffield Corp.’s balance sheet at December 31, 2021, is presented below. SHEFFIELD CORP. Balance Sheet December 31, 2021 Cash $51,660 Accounts payable $53,760 Accounts receivable 95,550 Common stock ($10 par) 168,000 Allowance for doubtful accounts (3,150 ) Retained earnings 267,540 Supplies 9,240 Land 84,000 Buildings 298,200 Accumulated depreciation—buildings (46,200 ) $489,300 $489,300 During 2022, the following transactions occurred. 1. On January 1, Sheffield issued 2,520 shares of $40 par, 7% preferred stock for $103,320. 2. On January 1, Sheffield also...
Sheffield Corp.’s balance sheet at December 31, 2021, is presented below. SHEFFIELD CORP. Balance Sheet December...
Sheffield Corp.’s balance sheet at December 31, 2021, is presented below. SHEFFIELD CORP. Balance Sheet December 31, 2021 Cash $51,660 Accounts payable $53,760 Accounts receivable 95,550 Common stock ($10 par) 168,000 Allowance for doubtful accounts (3,150 ) Retained earnings 267,540 Supplies 9,240 Land 84,000 Buildings 298,200 Accumulated depreciation—buildings (46,200 ) $489,300 $489,300 During 2022, the following transactions occurred. 1. On January 1, Sheffield issued 2,520 shares of $40 par, 7% preferred stock for $103,320. 2. On January 1, Sheffield also...
Information pertaining to Yekstop Corp.'s sales revenue is presented below: November December January Cash sales $...
Information pertaining to Yekstop Corp.'s sales revenue is presented below: November December January Cash sales $ 98,000 $ 127,000 $ 80,000 Credit sales 290,000 452,000 236,000 Total sales $ 388,000 $ 579,000 $ 316,000 Management estimates that 5% of credit sales are eventually uncollectible. Of the collectible credit sales, 65% are likely to be collected in the month of sale and the remainder in the month following the month of sale. The company desires to begin each month with an...
The current sections of Grouper Corp.’s balance sheets at December 31, 2021 and 2022, are presented...
The current sections of Grouper Corp.’s balance sheets at December 31, 2021 and 2022, are presented here. Grouper Corp.’s net income for 2022 was $260,100. Depreciation expense was $45,900. 2022 2021 Current assets    Cash $178,500 $ 168,300    Accounts receivable 136,000 151,300    Inventory 285,600 292,400    Prepaid expenses 45,900 37,400 Total current assets $646,000 $649,400 Current liabilities    Accrued expenses payable $ 25,500 $ 8,500    Accounts payable 144,500 156,400 Total current liabilities $170,000 $ 164,900 Prepare the net cash provided (used) by operating...
Operating data for Navarro Corporation are presented below.
Operating data for Navarro Corporation are presented below.   Instructions Prepare a schedule showing a vertical analysis for 2017 and 2016.
Presented below is financial data for the XPO Corporation.   Amounts in thousands Sales revenue $11,750 Cost...
Presented below is financial data for the XPO Corporation.   Amounts in thousands Sales revenue $11,750 Cost of goods sold 7,925 Net income 2,250 Inventory 825 Current assets 5,875 Current liabilities 3,375 1. Calculate the following ratios. Inventory turnover Inventory-on-hand period The current ratio for the year    2. Assuming the following industry averages, comment on XPO Corp's performance in relation to the industry averages. Make sure to indicate what account(s) could be attributed to XPO's better or worse performance as...
Presented below is the income statement of Cowan, Inc.:          Sales revenue                      &nbsp
Presented below is the income statement of Cowan, Inc.:          Sales revenue                                                                        $380,000          Cost of goods sold                                                                 225,000          Gross profit                                                                             $155,000          Operating expenses                                                                   95,000          Income before income taxes                                                      60,000          Income taxes                                                                              24,000          Net income                                                                             $ 36,000 In addition, the following information related to net changes in working capital is presented:                                                                                                               Debit                  Credit          Cash                                                                                         $12,000          Accounts receivable                                                                   25,000          Inventories                                                                                                              $19,400          Salaries payable (operating expenses)                                        8,000         ...
Presented below is the income statement of Cowan, Inc.:          Sales revenue                      &nbsp
Presented below is the income statement of Cowan, Inc.:          Sales revenue                                                                         $380,000          Cost of goods sold                                                                    225,000          Gross profit                                                                             $155,000          Operating expenses                                                                    95,000          Income before income taxes                                                      60,000          Income taxes                                                                              24,000          Net income                                                                             $ 36,000 In addition, the following information related to net changes in working capital is presented:                                                                                                               Debit                     Credit          Cash                                                                                          $12,000          Accounts receivable                                                                   25,000          Inventories                                                                                                              $19,400          Salaries payable (operating expenses)                                        8,000          Accounts payable                                                                                                     14,000         ...
Question 3 Information pertaining to Yekstop Corp.'s sales revenue is presented below: November December January Cash...
Question 3 Information pertaining to Yekstop Corp.'s sales revenue is presented below: November December January Cash sales $ 105,000 $ 134,000 $ 87,000 Credit sales 297,000 459,000 243,000 Total sales $ 402,000 $ 593,000 $ 330,000 Management estimates that 3% of credit sales are eventually uncollectible. Of the collectible credit sales, 60% are likely to be collected in the month of sale and the remainder in the month following the month of sale. The company desires to begin each month...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT