Problem 12-2B (Algo) Perform horizontal analysis (LO12-2) The income statements for Galaxy Tennis for the years ending December 31, 2024 and 2023, are provided below. Required: 1. Complete the "Amount" and "%" columns to be used in a horizontal analysis of Galaxy Tennis income statement. (Decreases should be indicated by a minus sign. Round your percentage answers to 1 decimal place.) Net sales Cost of goods sold Gross profit Operating expenses Operating income Other income (expense) Income before tax Income tax expense Net income GALAXY TENNIS Income Statements. For the Years Ended December 31 2024 2023 $ 6,090,000 $ 6,210,000 2,830,000 2,910,000 3,260,000 3,300,000 1,500,000 1,382,000 1,760,000 1,918,000 58,000 81,000 1,999,000 433,000 1,818,000 386,000 $ 1,432,000 $1,566,000 Increase (Decrease) Amount %

Problem 12-2B (Algo) Perform horizontal analysis (LO12-2) The income statements for Galaxy Tennis for the years ending December 31, 2024 and 2023, are provided below. Required: 1. Complete the "Amount" and "%" columns to be used in a horizontal analysis of Galaxy Tennis income statement. (Decreases should be indicated by a minus sign. Round your percentage answers to 1 decimal place.) Net sales Cost of goods sold Gross profit Operating expenses Operating income Other income (expense) Income before tax Income tax expense Net income GALAXY TENNIS Income Statements. For the Years Ended December 31 2024 2023 $ 6,090,000 $ 6,210,000 2,830,000 2,910,000 3,260,000 3,300,000 1,500,000 1,382,000 1,760,000 1,918,000 58,000 81,000 1,999,000 433,000 1,818,000 386,000 $ 1,432,000 $1,566,000 Increase (Decrease) Amount %

Cornerstones of Financial Accounting

4th Edition

ISBN:9781337690881

Author:Jay Rich, Jeff Jones

Publisher:Jay Rich, Jeff Jones

Chapter12: Fainancial Statement Analysis

Section: Chapter Questions

Problem 87PSB

See similar textbooks

Similar questions

Problem 12-2A (Algo) Perform horizontal analysis (LO12-2) The income statements for Anything Outdoors for the years ending December 31, 2024 and 2023, are provided below. Required: 1. Complete the "Amount" and "%" columns to be used in a horizontal analysis of the income statements for Anything Outdoors. (Decreases should be indicated by a minus sign. Round your percentage answers to 1 decimal place.) Net sales Cost of goods sold Gross profit Operating expenses Operating income Other income (expense) Income before tax Income tax expense Net income ANYTHING OUTDOORS Income Statements For the Years Ended December 31 2024 2023 $ 3,350,000 $2,520,000 $ 2,100,000 1,250,000 785,000 465,000 9,000 474,000 97,500 376,500 $ $ 1,355,000 1,165,000 610,000 555,000 5,500 560,500 135,000 425,500 $ Increase (Decrease) Amount 830,000 745,000 85,000 175,000 (90,000) 3,500 (86,500) (37,500) (49,000) % 32.9
Top executive officers of Tildon Company, a merchandising firm, are preparing the next year's budget. The controller has provided everyone with the current year's projected income statement. Current Year $1,600,000 1,120,000 480,000 190,000 Sales revenue Cost of goods sold Gross profit Selling & administrative expenses Net income 290,000 Cost of goods sold is usually 70 percent of sales revenue, and selling and administrative expenses are usually 10 percent of sales plus a fixed cost of $30,000. The president has announced that the company's goal is to increase net income by 15 percent. Required The following items are independent of each other: a. Prepare a pro forma income statement. What percentage increase in sales would enable the company to reach its goal? b. The market may become stagnant next year, and the company does not expect an increase in sales revenue. The production manager believes that an improved production procedure can cut cost of goods sold by 2 percent. Prepare a…
Complete this question by entering your answers in the tabs below. Analysis Analysis Bal Sheet Inc Stmt Prepare a vertical analysis of an income statements for Year 4 and Year 3. (Percentages may not add exactly due to rounding. Round your answers to 2 decimal places. (i.e., .2345 should be entered as 23.45).) Revenues Sales (net) Other revenues Total revenues Expenses Cost of goods sold FANNING COMPANY Vertical Analysis of Income Statements Year 4 Selling, general, and administrative expense Interest expense Income tax expense Total expenses Net income Amount $ 231,900 9,300 241,200 118,800 54,200 6,800 22,800 202,600 $ 38,600 Percentage of Total Analysis Bal Sheet % % Year 3 Amount $ 211,200 6,400 217,600 102,100 49,100 6,000 21,800 179,000 $ Percentage of Total % % 38,600 Analysis Inc Stmt > Show less
Perform a horizontal analysis for the entry "Gross Sales" shown on the income statement portion below. (Round percentages to one decimal place.) Increase/Decrease Revenue 2019 2018 Amount Percent Gross Sales $273,000 $200,100 $ % Less: Sales Returns and Allowances 14,200 12,400 Net Sales 258,800 187,700 Cost of Goods Sold Merchandise Inventory 31,900 33,800 Net Purchases 60,300 55,500 Goods Available for Sale 92,200 89,300 Less: Merchandise Inventory, Dec. 31 43,000 60,200 Cost of Goods Sold 49,200 29,100 Gross Margin 209,600 158,600
Requirement 1. Prepare a horizontal analysis of the comparative income statement of McCormick Designs, Inc. Round percentage changes to one decimal place. (Round the percentages to one decimal place, X.X%. Use a minus sign or parentheses to indicate a decrease.) McCormick Designs, Inc. Comparative Income Statement Years Ended December 31, 2024 and 2023 Increase (Decrease) 2024 2023 Amount Percentage Net Sales Revenue $429,000 $373,750 % Expenses: Cost of Goods Sold 204,000 190,450 % Selling and Administrative Expenses 96,000 91,050 % Other Expenses 7,450 5,750 % Total Expenses 307,450 287,250 % Net Income $121,550 $86,500 % Requirement 2. Why did 2024 net income increase by a higher percentage than net sales revenue? Net income increased by a higher percentage than total net…
The income statements for Galaxy Tennis for the years ending December 31, 2021 and 2020, are provided below.Required:1. Complete the “Amount” and “%” columns to be used in a horizontal analysis of Galaxy Tennis income statement. (Decreases should be indicated by a minus sign. Round your percentage answers to 1 decimal place.) GALAXY TENNIS Income Statements For the Years Ended December 31 Increase (Decrease) 2021 2020 Amount % Net sales $6,030,000 $6,170,000 Cost of goods sold 2,810,000 2,900,000 Gross profit 3,220,000 3,270,000 Operating expenses 1,490,000 1,374,000 Operating income 1,730,000 1,896,000 Other income (expense) 56,000 77,000 Income before tax 1,786,000 1,973,000 Income tax expense 382,000 431,000 Net income $1,404,000 $1,542,000
ASSESSMENT: Problem #1: On June 30, 2020, PSA Trading Co. has the following informatign: revenue from sales is Po8,760; sales return is P35,50o; cost of goods sold is P8.490: salaries cost P 14,600; rent is P8,090; light and water expenses are P7.550 and miscellaneous expenses are Po,520.Generate an income statement and find: a. Gross Profit b. Net Profit or Loss Problem #2: AMA 6operative store had the following activities for year ended 2021: gross sales amounting to Po4,653, the cost of goods sold was P48,923, the operating expensés were, P8,723.15, and refunds for defective goods amounted to P26,497.15. Generate an income slatemeni and find: a. Net Sales b. Gross Profit c. Net Profit Problem #3: AMA cooperative store had the following activities for year ended 2021: gross sales amounting to P94,653, the cost of goods sold was P48,923, the operating expenses were, P8,723.15, and refunds for defective goods amounted to P26,497.15. Generate an income statement and find: a. Net Sales…
Operating data for Joshua Corporation are presented as follows: Net Sales Cost of Goods Sold Selling Expenses Administrative Expenses Income Tax Expense Net Income 2022 800,000 520,000 120,000 60,000 30,000 70,000 Instructions Prepare a schedule showing a vertical analysis for 2022 and 2021. Net Sales Cost of Goods Sold Gross Profit Selling Expenses Your Answers: FYI: Format the percent cols to one decimal place. Ex 99.9% 2022 Administrative Expenses Total Operating Expenses Income Before Income Taxes Income Tax Expense Net Income 2021 600,000 408,000 72,000 48,000 24,000 48,000 Amount 800,000 520,000 280,000 120,000 60,000 180,000 100,000 30,000 70,000 Percent 100.0% 2021 Amount Percent 600,000 100.0% 408,000 192,000 72,000 48,000 120,000 72,000 24,000 48,000
Income statements for Campbell Company for Year 3 and Year 4 follow: CAMPBELL COMPANY Income Statements Year 4 Year 3 $180,800 120,400 19,900 14,500 Sales $200,800 Cost of goods sold Selling expenses Administrative expenses Interest expense Total expenses 142,400 21,900 12,500 3,900 $180,700 5,900 $160,700 20,100 3,700 Income before taxes 20,100 Income taxes expense 6,500 Net income $ 13,600 $ 16,400 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 percentage answers to 1 decimal place. (i.e., 0.234 should be entered…
Question (1) The income statements for Federer Sports Apparel for 2022 and 2021 are presented below. (A) Required: Prepare a vertical analysis of the data for 2022 and 2021. (Round your percentage answers to 1 decimal place.) Net sales Cost of goods sold Gross profit Operating expenses Depreciation expense Inventory write-down Loss (litigation) Income before tax Income tax expense Net income Net sales Cost of goods sold Gross profit Operating expenses Depreciation expense Inventory write-down Loss (litigation) Income before tax Income tax expense Net income FEDERER SPORTS APPAREL Net sales Cost of goods sold Gross profit Operating expenses Depreciation expense Inventory write-down Loss (litigation) Income Statement For the Years Ended December 31 Income before tax Income tax expense Net income Amount $18,800,000 $ 2022 13,200,000 5,600,000 1,600,000 1,000,000 200,000 1,500,000 1,300,000 450,000 850,000 % (B) Required: Prepare a horizontal analysis for 2022 using 2021 as the base year.…
Prepare an income statement for Hansen Realty for the year ended December 31, 2023. Beginning inventory was $1,242. Ending inventory was $1,594. Note: Input all amounts as positive values. Sales Sales returns and allowances Sales discount Purchases Purchase discounts Depreciation expense Salary expense Insurance expense Utilities expense Plumbing expense Rent expense HANSEN REALTY Income Statement For Year Ended December 31, 2023 Gross profit from sales Operating expenses: $ 34,300 1,086 1,146 10,212 Total operating expenses 534 109 4,900 2,300 204 244 174
Current Attempt in Progress Operating data for Grouper Corp. are presented as follows. Net sales Cost of goods sold Selling expenses Administrative expenses Income tax expense Net income 2022 $840,000 540,120 133,560 57,120 31,920 77,280 2021 $610,000 405,650 80,520 46,970 26,840 50,020 Prepare a schedule showing a vertical analysis for 2022 and 2021. (Round percentages to 1 decimal place, e.g. 12.1%.)