Concept explainers
Horizontal Analysis of the Income Statement
(Picture is attached below and let me know what the right answers are)
Income statement data for Winthrop Company for two recent years ended December 31 are as follows:
Current Year | Previous Year | ||||
Sales | $2,240,000 | $2,000,000 | |||
Cost of goods sold | (1,925,000) | (1,750,000) | |||
Gross profit | $315,000 | $250,000 | |||
Selling expenses | $(152,500) | $(125,000) | |||
Administrative expenses | (118,000) | (100,000) | |||
Total operating expenses | $(270,500) | $(225,000) | |||
Income before income tax expense | $44,500 | $25,000 | |||
Income tax expense | (17,800) | (10,000) | |||
Net income | $26,700 | $15,000 |
a. Prepare a comparative income statement with horizontal analysis, indicating the increase (decrease) for the current year when compared with the previous year. If required, round to one decimal place.
Winthrop Company | ||||
Comparative Income Statement | ||||
For the Years Ended December 31 | ||||
Current year Amount |
Previous year Amount |
Increase (Decrease) Amount |
Increase (Decrease) Percent |
|
Sales | $2,240,000 | $2,000,000 | $fill in the blank 046aeef91077033_1 | fill in the blank 046aeef91077033_2% |
Cost of goods sold | (1,925,000) | (1,750,000) | fill in the blank 046aeef91077033_3 | fill in the blank 046aeef91077033_4% |
Gross profit | $315,000 | $250,000 | $fill in the blank 046aeef91077033_5 | fill in the blank 046aeef91077033_6% |
Selling expenses | $(152,500) | $(125,000) | fill in the blank 046aeef91077033_7 | fill in the blank 046aeef91077033_8% |
Administrative expenses | (118,000) | (100,000) | fill in the blank 046aeef91077033_9 | fill in the blank 046aeef91077033_10% |
Total operating expenses | $(270,500) | $(225,000) | $fill in the blank 046aeef91077033_11 | fill in the blank 046aeef91077033_12% |
Income before income tax expense | $44,500 | $25,000 | $fill in the blank 046aeef91077033_13 | fill in the blank 046aeef91077033_14% |
Income tax expense | (17,800) | (10,000) | fill in the blank 046aeef91077033_15 | fill in the blank 046aeef91077033_16% |
Net income | $26,700 | $15,000 | $fill in the blank 046aeef91077033_17 | fill in the blank 046aeef91077033_18 |
b. The net income for Winthrop Company increased between years. This increase was the combined result of an increase in sales and a lower percentage increase in cost of goods sold. The cost of goods sold increased at a slower rate than the increase in sales, thus causing the percentage increase in gross profit to be greater than the percentage increase in sales.
Trending nowThis is a popular solution!
Step by stepSolved in 2 steps
- Revenue and expense data for the current calendar year for Tannenhill Company and for the electronics industry are as follows. Tannenhill's data are expressed in dollars. The electronics industry averages are expressed in percentages. Electronics Tannenhill Industry Company Average Sales $2,320,000 100 % Cost of merchandise sold 1,624,000 73 Gross profit $696,000 27 % Selling expenses $394,400 15 % Administrative expenses 162,400 Total operating expenses $556,800 21 % Income from operations $139,200 6 % Other revenue and expense: Other revenue 46,400 2 Other expense (23,200) Income before income tax expense $162,400 7 % Income tax expense 69,600 Net income $92,800 3 %arrow_forwardHorizontal Analysis of the Income Statement Income statement data for Boone Company for the years ended December 31, 20Y5 and 20Y4, are as follows: 20Υ5 20Υ4 Sales $673,200 $510,000 Cost of goods sold (572,000) (440,000) Gross profit $101,200 $70,000 Selling expenses $(30,500) $(25,000) Administrative expenses (27,300) (21,000) Total operating expenses $(57,800) $(46,000) Income before income tax $43,400 $24,000 Income tax expenses (17,400) (9,600) Net income $26,000 $14,400 a. Prepare a comparative income statement with horizontal analysis, indicating the increase (decrease) for 20Y5 when compared with 20Y4. Round percentage answers to one decimal place. Boone Company Comparative Income Statement For the Years Ended December 31, 20Y5 and 20Y4 20Y5 Amount 20Y4 Amount Increase (Decrease) Amount Increase (Decrease) Percent Sales $673,200 $510,000 % Cost of goods sold (572,000) (440,000) Gross profit $101,200 $70,000 % Selling expenses $(30,500) $(25,000) Administrative expenses (27,300)…arrow_forwardRevenue and expense data for Innovation Quarter Inc. for two recent years are as follows: Current Year Previous Year Sales $490,000 $446,000 Cost of merchandise sold 289,100 231,920 Selling expenses 78,400 84,740 Administrative expenses 88,200 75,820 Income tax expense 14,700 22,300 a. Prepare an income statement in comparative form, stating each item for both years as a percent of sales. If required, round percentages to one decimal place. Enter all amounts as positive numbers. Innovation Quarter Inc. Comparative Income Statement For the Years Ended December 31 Current year Amount Current year Percent Previous year Amount Previous year Percent Sales $490,000 % $446,000 % Cost of merchandise sold 289,100 % 231,920 % % % Selling expenses 78,400 84,740 % Administrative expenses 88,200 % 75,820 % % % Income tax expense 14,700 % 22,300 % % % b. The vertical analysis indicates that the cost of merchandise sold as a percent of sales - by 7 percentage points, while selling expenses by 3…arrow_forward
- Comparative Income StatementsConsider the following income statement data from the Ross Company: Current Year Previous Year Sales revenue $525,000 $450,000 Cost of goods sold 336,000 279,000 Selling expenses 105,000 99,000 Administrative expenses 60,000 54,000 Income tax expense 7,800 5,400 Prepare a comparative income statement, showing increases and decreases in dollars and in percentages. Note: Round "Percent Change" answers to one decimal place (ex: 0.2345 = 23.5%). ROSS COMPANYComparative Income Statements Current Year Previous Year Increase(Decrease) PercentChange Sales Revenue Answer Answer Answer Answer Cost of Goods Sold Answer Answer Answer Answer Answer Answer Answer Answer Answer Answer Selling Expenses Answer Answer Answer Answer Administrative Expenses Answer Answer Answer Answer Total Answer Answer Answer Answer Income before Income Taxes Answer Answer Answer Answer Answer Answer Answer Answer Answer Answer…arrow_forwardHorizontal Analysis of the Income Statement Income statement data for Winthrop Company for two recent years ended December 31 are as follows: Current Year Previous Year Sales $660,000 $500,000 Cost of merchandise sold 554,700 430,000 Gross profit $105,300 $70,000 Selling expenses $31,720 $26,000 Administrative expenses 28,600 22,000 Total operating expenses $60,320 $48,000 Income before income tax expense $44,980 $22,000 Income tax expenses 18,000 8,800 Net income $26,980 $13,200arrow_forwardCochran corporation, Inc. has the following income statement: Cochran corporation, Inc. Income statement For the year ended December 31, 2021 net sales $240 Cost of goods sold $150 gross profit $90 Operating expenses $65 Net income $25 Using vertical analysis, what percentage is assigned to operating expenses? a. 27,1% b. 43.3% c. 72.2% d. 260.0%arrow_forward
- Income statement data for Winthrop Company for two recent years ended December 31, are as follows: Current Year Previous Year Sales $369,600 $280,000 Cost of goods sold 312,000 240,000 Gross profit $57,600 $40,000 Selling expenses $17,080 $14,000 Administrative expenses 15,600 12,000 Total operating expenses $32,680 $26,000 Income before income tax $24,920 $14,000 Income tax expenses 10,000 5,600 Net income $14,920 $8,400 a. Prepare a comparative income statement with horizontal analysis, indicating the increase (decrease) for the current year when compared with the previous year. If required, round to one decimal place. Winthrop Company Comparative Income Statement For the Years Ended December 31 Current Previous Increase Increase year year (Decrease) (Decrease) Amount Amount Amount Percent Sales $369,600 $280,000 $ % Cost of goods sold 312,000 240,000 % Gross profit $57,600 $40,000 %arrow_forwardFollowing is an incomplete current-year income statement. Determine Net Sales, Cost of goods sold and Net Income. Additional information follows: Return on total assets is 16% (average total assets is $62,500). Inventory turnover is 5 (average inventory is $7,800). Accounts receivable turnover is 8 (average accounts receivable is $7,700). Income Statement Net Sales Cost of goods sold Selling, general, and administrative expenses 8800 Income tax expenses 3800 Net Incomearrow_forwardProvide answer pleasearrow_forward
- Selected data from the financial statements of Rags to Riches are provided below: Current Year Prior Year Accounts Receivable $120,000 $ 76,000 Inventory 24,000 32,000 Total Assets 900,000 760,000 Net Sales 760,000 540,000 Cost of Goods Sold 320,000 420,000 Which of the following would result from vertical analysis of the company's income statement? a. The accounts receivable turnover ratio is 7.76 in the current year. b. Gross profit is 57.9% of net sales for the current year. c. Net sales are 84.4% of total assets for the current year. d. Cost of goods sold decreased by $50,000 or 23.8% duringarrow_forwardCommon-Sized Income Statement Revenue and expense data for the current calendar year for Tannenhill Company and for the electronics industry are as follows. Tannenhill's data are expressed in dollars. The electronics industry averages are expressed in percentages. Electronics Tannenhill Industry Company Average $1,390,000 100 % Sales 736,700 59 Cost of merchandise sold $653,300 41 % Gross profit $417,000 25 % Selling expenses Administrative expenses 152,900 10 Total operating expenses $569,900 35 % Income from operations $83,400 6 % Other revenue and expense: Other revenue 27,800 2 Other expense (13,900) 1 Income before income tax expense $97,300 7 % Income tax expense 41,700 Net income $55,600 2 % a. Prepare a common-sized income statement comparing the results of operations for Tannenhill Company with the industry average. If required, round percentages to one decimal place. econ.docx Show all Type here to search 6:05 AM 59 F 局 10/30/2021 12 prt sc 00 5.arrow_forwardThe income statement of Sheridan Company is shown below. Sheridan Company Income Statement For the Year Ended December 31, 2025 Sales revenue $7,030,000 Cost of goods sold Beginning inventory $1,950,000 Purchases 4,600,000 Goods available for sale 6,550,000 Ending inventory 1,680,000 Cost of goods sold 4,870,000 Gross profit 2,160,000 Operating expenses Selling expenses 500,000 Administrative expenses 640,000 1,140,000 Net income $1,020,000 Additional information: 1. Accounts receivable decreased $330,000 during the year. 2. Prepaid expenses increased $160,000 during the year. 3. Accounts payable to suppliers of merchandise decreased $270,000 during the year. 4. Accrued expenses payable decreased $120,000 during the year. 5. Administrative expenses include depreciation expense of $60,000. Prepare the operating activities section of the statement of cash flows for the year ended December 31, 2025, for Sheridan Company, using the indirect method. (Show amounts that decrease cash flow…arrow_forward
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education