Income statements for Gibson Company for Year 3 and Year 4 follow: GIBSON COMPANY Income Statements Year 4 Year 3 $200,600 143,600 Sales Cost of goods sold Selling expenses Administrative expenses Interest expense Total expenses $180,600 121,600 19,500 14,500 5,800 $161,400 19,200 3,500 $ 15,700 21,500 12,500 3,800 $181,400 19,200 5,000 $ 14,200 Income before taxes Income taxes expense Net income Required a. Perform a horizontal analysis, showing the percentage change in each income statement component between Year 3 and Year 4. b. Perform a vertical analysis, showing each income statement component as a percentage of sales for each year.

Income statements for Gibson Company for Year 3 and Year 4 follow: GIBSON COMPANY Income Statements Year 4 Year 3 $200,600 143,600 Sales Cost of goods sold Selling expenses Administrative expenses Interest expense Total expenses $180,600 121,600 19,500 14,500 5,800 $161,400 19,200 3,500 $ 15,700 21,500 12,500 3,800 $181,400 19,200 5,000 $ 14,200 Income before taxes Income taxes expense Net income Required a. Perform a horizontal analysis, showing the percentage change in each income statement component between Year 3 and Year 4. b. Perform a vertical analysis, showing each income statement component as a percentage of sales for each year.

Intermediate Accounting: Reporting And Analysis

3rd Edition

ISBN:9781337788281

Author:James M. Wahlen, Jefferson P. Jones, Donald Pagach

Publisher:James M. Wahlen, Jefferson P. Jones, Donald Pagach

Chapter22: Accounting For Changes And Errors.

Section: Chapter Questions

Problem 4RE: Refer to RE22-2. Assume Heller Company had sales revenue of 510,000 in 2019 and 650,000 in 2020....

See similar textbooks

Similar questions

Requirea informatiON Exercise 13-9 Analyzing risk and capital structure LO P3 [The following information applies to the questions displayed below.] Simon Company's year-end balance sheets follow. At December 31 Current Yr 1 Yr Ago 2 Yrs Ago Assets Cash Accounts receivable, net Merchandise inventory Prepaid expenses Plant assets, net Total assets $ 24,930 71,524 89,927 8, 109 232,313 $426,803 $ 29,435 $ 49,965 69,429 7,881 211,224 30,652 38,886 42,258 3,307 185,497 $ 367,934 $ 300,600 Liabilities and Equity Accounts payable Long-term notes payable secured by mortgages on plant assets Common stock, $10 par value Retained earnings $105, 211 $ 62,803 $ 40,473 81,844 162,500 77,248 82,932 162,500 59,699 $ 367,934 $ 300,600 68,426 162,500 29,201 Total liabilities and equity $426,803 The company's income statements for the Current Year and 1 Year Ago, follow. For Year Ended December 31 Sales 1 Yr Ago $ 437,841 Current Yr $554,844 Cost of goods sold other operating expenses Interest expense…
Dela Rosa Company Company The income statement for the year ended December 31, 2020, for Dela Rosa Company Comnany contains the following condensed information. Dela Rosa Company Company Income Statement For the Year Ended December 31, 2X20 Sales revenue Cost of goods sold Operating expenses (excluding depreciation) Depreciation expense Loss on disposal of plant assets Income before income taxes Income tax expense Net income P6,583,000 P2,810,000 2,086,000 880,000 24.000 5,800.000 783,000 353,000 P430,000 The P24,000 loss resulted from selling equipment for P270,000 cash. The equipment was purchased at a cost of P750,000. The following balances are reported on Dela Rosa's comparative balance sheets at December 31, Dela Rosa Company Company Comparative Balance Sheets Cash Accounts receivable Inventory Accounts payable 2X20 P672,000 775,000 834,000 521,000 2X19 P130,000 610,000 867,000 501,000 Income tax expense of P353,000 represents the amount paid in 2020. Dividends declared and paid…
The following are the financial statement JNC Ltd. for the year ended 31 March 2020: JNC Ltd. Income statement For the year ended 31 March 2020 $”M” Revenue 1276.50 Cost of sales (907.00) 369.50 Distribution costs (62.50) Administrative expenses (132.00) 175.00 Interest received 12.50 Interest paid (37.50) 150.00 Tax (70.00) Profit after tax 80.00 JNC Ltd. Statement of financial position as at 31 March 2020 2019 $”M” $”M” ASSETS: Non- current assets: Property, plant and equipment 190 152.5 Intangible assets 125 100 Investments 12.5 Current assets: Inventories 75 51 Receivables 195 157.5 Short-term investment 25 Cash in hand 1 0.5 Total assets 611 474 Equity and liabilities: Equity: Share capital (10 million ordinary shares of $ 10 per value) 100 75 Share premium 80 75 Revolution reserve 50 45.5 Retained earnings 130 90 Non-current liabilities: Loan 85 25…
The comparative statements of Bonita Company are presented here. Net sales Bonita Company Income Statements For the Years Ended December 31 Cost of goods sold Gross profit Selling and administrative expenses Income from operations Other expenses and losses Interest expense Income before income taxes Income tax expense Net income 2022 $1,811,500 1,008,900 802,600 518,600 284,000 17,800 266,200 80,152 $ 186,048 2021 $1,752,200 982,000 770,200 472,800 297,400 13,800 283,600 76,400 $207,200
Income statements for Walton Company for Year 3 and Year 4 follow. WALTON COMPANY Income Statements Year 4 Year 3 Sales $201,800 $181,800 Cost of goods sold Selling expenses Administrative expenses Interest expense Total expenses 142,100 20,900 12,400 3,400 $178,800 120,100 18,900 14,400 5,400 $158,800 Income before taxes 23,000 5,200 23,000 3,300 Income taxes expense Net income $17,800 $19,700 Required a. Perform a horizontal analysis, showing the percentage change in each income statement component between Year 3 and Year 4. b. Perform a vertical analysis, showing each income statement component as a percentage of sales for each year. Complete this question by entering your answers in the tabs below. Required A Required B Perform a horizontal analysis, showing the percentage change in each income statement component between Year 3 and Year 4. (Negative answers should be indicated by a minus sign. Round your answers to 1 decimal place. (i.e., 0.234 should be entered as 23.4).) WALTON…
ncome statements for Adams Company for Year 3 and Year 4 follow: ADAMS COMPANY Income Statements Year 4 Year 3 Sales $ 200,900 $ 180,900 Cost of goods sold 143,800 121,800 Selling expenses 20, 100 18,100 Administrative expenses 13,000 15,000 Interest expense 4,000 6,000 Total expenses $ 180,900 $ 160,900 Income before taxes 20, 000 20,000 Income taxes expense 6,400 3,100 Net income $ 13,600 $ 16,900 Required a. Perform a horizontal analysis, showing the percentage change in each income statement component between Year 3 and Year 4. b. Perform a vertical analysis, showing each income statement component as a percentage of sales for each year.
Income statements for Franklin Company for Year 3 and Year 4 follow: FRANKLIN COMPANY Income Statements Year 4 Year 3 Sales $ 201,300 $181, 300 Cost of goods sold 143, 600 121,600 Selling expenses 20,100 18, 100 Administrative expenses 12,500 14,500 Interest expense 3, 900 5,900 Total expenses 180, 100 160, 100 Income before taxes 21, 200 21,200 Income taxes expense 6, 400 3,600 Net income $ 14,800 $ 17,600 Required Perform a horizontal analysis, showing the percentage change in each income statement component between Year 3 and Year 4. Perform a vertical analysis, showing each income statement component as a percentage of sales for each year.
Do the calculations in excel, attach excel screenshots and explain the steps and formulas used for solving the problem. Following are the particulars available
The following are the comparative financial statements for Outland Corporation for 2020 and 2019: OUTLAND CORPORATION Statement of Income For Periods Ending October 31 Sales Revenue Cost of Goods Sold Gross Profit.. 2020 167,500 100,000 67,500 2019 140,000 85,000 55,000 Expenses Depreciation Selling and Administrative Interest Expense. Total Expenses. 15,000 22,500 15,000 15,000 47,500 35,000 Net Income (before taxes). Income Taxes 25,000 10,000 15,000 22,500 7,500 15,000 Net Income OUTLAND CORPORATION Statement of Financial Position As at October 31 2020 2019 Assets Current Assets: 4,000 10,000 35,000 31,000 80,000 Cash. 2,500 7,500 30,000 25,000 65,000 Marketable Securities. Accounts Receivable. Inventory Total Current Assets Investments (at cost).. 30,000 32,500 Property, plant and equipment Property, Plant and Equipment.. Less: Accumulated Depreciation. 200,000 87,500 112,500 2,500 225,000 190,000 80,000 110,000 2,500 210,000 Goodwill Total Assets Liabilities and Shareholders'…
Required information For Year Ended December 31 Sales Cost of goods sold Other operating expenses Current Year $ 411, 225 209,550 12, 100 9,525 $ 673,500 642, 400 $31,100 $ 1.90 :. -. - == ....... 9 US Sa M
Income statements for Adams Company for Year 3 and Year 4 follow: ADAMS COMPANYIncome Statements Year 4 Year 3 Sales $ 200,400 $ 180,400 Cost of goods sold 143,700 121,700 Selling expenses 21,200 19,200 Administrative expenses 12,600 14,600 Interest expense 3,900 5,900 Total expenses $ 181,400 $ 161,400 Income before taxes 19,000 19,000 Income taxes expense 6,900 3,400 Net income $ 12,100 $ 15,600 Requireda. Perform a horizontal analysis, showing the percentage change in each income statement component between Year 3 and Year 4.b. Perform a vertical analysis, showing each income statement component as a percentage of sales for each year. Perform a horizontal analysis, showing the percentage change in each income statement component between Year 3 and Year 4. (Negative answers should be indicated by a minus sign. Round your percentage answers to 1 decimal place. (i.e.,…
The following income statement appears in the financial report of MERCADO Company for the year ending December 31, 2020: MERCADO Company Income Statement For the year ending December 31. 2020 Sales 72,485,000.00 Cost of goods sold Gross profit 39.866,750.00 32.618.250.00 Less: Operating expenses: Variable selling expenses: Salesmen's commissions 3,624,250.00 Communication expenses 1,812.125.00 Advertising and promotion 635.350.00 Representation expenses 215.385.00 Gas and oil - salesmen 1,285.000.00 Repairs and maintenance 1,150.000.00 3.722.110.00 Fixed selling expenses Salaries and wages 4,225,000.00 Franchises and royalties 524,150.00 Office supplies and materials 555.000.00 Depreciation 963 300.00 6.267,450.00 14.989,560.00 Fixed administrative expenses Salaries and wages 6.324,650.00 Employee benefits 316,490.00 Communications expenses 335,125.00 Office supplies and materials 275,150.00 Depreciation 325,500.00 104 250.00 7.681,165.00 9.947.525.00 Miscellaneous expenses Operating…