The comparative condensed income statements of Dubai Company are shown below. Dubai Company Comparative Condensed Income Statements For the Years Ended December 31 2021 2020 Net sales Cost of goods sold Gross profit Operating expenses Net income $620,000 450,000 170,000 54.000 $116,000 $500,000 400,000 100,000 40,000 $ 60,000 Required: 1. Prepare a horizontal analysis of the income statement data for Dubai Company using 2020 as a base. (Show the amounts of increase or decrease.) 2. Prepare a vertical analysis of the income statement data for Dubai Company in columnar form for both years. 3. Based on the analysis in number 1 and 2, discuss briefly the financial position of Dubai Company.

The comparative condensed income statements of Dubai Company are shown below. Dubai Company Comparative Condensed Income Statements For the Years Ended December 31 2021 2020 Net sales Cost of goods sold Gross profit Operating expenses Net income $620,000 450,000 170,000 54.000 $116,000 $500,000 400,000 100,000 40,000 $ 60,000 Required: 1. Prepare a horizontal analysis of the income statement data for Dubai Company using 2020 as a base. (Show the amounts of increase or decrease.) 2. Prepare a vertical analysis of the income statement data for Dubai Company in columnar form for both years. 3. Based on the analysis in number 1 and 2, discuss briefly the financial position of Dubai Company.

Survey of Accounting (Accounting I)

8th Edition

ISBN:9781305961883

Author:Carl Warren

Publisher:Carl Warren

Chapter9: Metric-analysis Of Financial Statements

Section: Chapter Questions

Problem 9.1E

See similar textbooks

Similar questions

Here are the comparative condensed income statements of Concord Corporation. Concord Corporation Condensed Income Statements For the Years Ended December 31 Net sales Cost of goods sold Gross profit Operating expenses Net income (a) 2022 Net sales $636,000 502,440 133,560 89,040 $44,520 2022 2021 $524,000 Cost of goods sold 502,440 435,444 Prepare a horizontal analysis of the income statement data for Concord Corporation, using 2021 as a base. (Show the amounts of increase or decrease.) (Enter negative amounts and percentages using either a negative sign preceding the number e.g. -45, -45% or parentheses e.g. (45), (45%). Round percentages to 1 decimal place, e.g. 12.3%.) 88,556 49,780 $38,776 2021 CONCORD CORPORATION Condensed Income Statements $636,000 $524,000 435,444 $ Increase or (Decrease) During 2022 Amount Percentage % %
Perform comparative analysis of Eastman Corporation by completing the analysis below. PROBLEM 1-3 Describe and comm ent on any significant findings in y our co mparative analysis. Comparative Income Statemenrt Analysis EAST MAN COR PORATION Income State ment ($ millions) For Years Ended December 31 Average Cumulative Annual Year 6 Year 5 Year 4 Amount Amount Net sales 21 3,210 %24 2,610 $3,490 $2,860 %24 Cost of goods sold Gross profit. - 3,670 680 1,050 1,800 Operating expenses Income before taxes 2,740 215 105 Net inc ome $1,485 145 58 CHECK Average net income. $563
a. Prepare a common-sized income statement comparing the results of operations for Dawg Electronics Company with the industry average. If required, round percentages to one decimal place. Dawg Electronics Company Common-Sized Income Statement Dawg Electronics Dawg Electronics Electronics Industry Company Amount Company Percent Average Sales $3,750,000 100.0 % 100.0% Cost of goods sold (2,062,500) 550.0 % (61.0)% Gross profit $1,687,500 45.0 % 39.0% Selling expenses $(1,125,000) 0.3 % (23.0)% Administrative expenses (262,500) 0.7 % (10.0)% Total operating expenses $(1,387,500) 37.0 % (33.0)% Operating income $300,000 8.0 % 6.0% Other revenue and expense: Other revenue 15,000 0.4 % 3.0% Other expense (3,750) 0.1 % (1.0)% Income before income tax $311,250 8.3 % 8.0% Income tax expense (93,750) 25 % (2.5)% Net income $217,500 5.8 % 5.5%
Use the following comparative income statements and balance sheets to complete the required ratio analysis. Comparative Income StatementFor the Years Ended December 31, 20-C and 20-B 20-C 20-B Net Sales $965,400 $1,028,600 Cost of goods sold 515,100 590,300 Gross profit $450,300 $438,300 Operating expenses Selling expenses $142,000 $173,400 Administrative expenses 150,200 182,400 Interest expense 29,300 34,100 Total operating expenses $321,500 $389,900 Income tax expense 45,500 18,200 Total expenses $367,000 $408,100 Net income $83,300 $30,200 Comparative Balance SheetDecember 31, 20-C and 20-B Assets 20-C 20-B Cash $45,100 $48,500 Accounts receivable (net) 59,800 101,500 Merchandise inventory 150,900 171,600 Property, plant, and equipment (net) 710,500 808,800 Total…
GIVE THE COMPARATIVE INCOME STATEMENT HORIZONTAL ANALYSIS FROM THE FOLLOWING INCOME STATEMENT BELOW JOLLIBEE INCOME STATEMENT ITEM 2016 2017 2018 2019 2020 Sales/Revenue 113.81B 133.61B 161.17B 179.63B 129.31B Sales Growth - 17.40% 20.62% 11.45% -28.01% Cost of Goods Sold (COGS) incl. D&A - - 132.96B 150.88B 115.39B COGS Growth - - - 13.47% -23.52% COGS excluding D&A 89.27B 105.39B 121.08B 137.38B 100.82B Depreciation & Amortization Expense 4B 4.75B 11.89B 13.5B 14.57B Depreciation 3.93B 4.66B 11.73B 13.34B 14.32B Amortization of Intangibles 68.99M 78.95M 151.82M 145.42M 245.23M Gross Income 20.54B 23.48B 28.21B 28.75B 13.92B Gross Income Growth - 14.30% 20.12% 1.93% -51.57% Gross Profit Margin - - - - 10.77% SG&A Expense - - 17.64B 20.21B 20.42B SGA Growth - - - 14.57% 1.02%…
Comparative income statements for Pearle Company are provided: Required: Perform a horizontal analysis of Pearle Company's income statement by computing horizontal percentages for each item. Note: Round your answers to 1 decimal place. Sales Less cost of goods sold Gross margin Less operating expenses Income before taxes Income taxes Net income Pearle Company Comparitive Income Statement Years Ended December 31, Year 2 Year 1 $ 600,000 $ 539,700 388,700 361,650 $ 211,300 113,950 97,350 42,440 54,910 $ 178,050 103,770 74,280 33,412 40,868 Percentage Change 90.0 % % % % % % %
GIVE THE COMPARATIVE INCOME STATEMENT HORIZONTAL AND VERTICAL ANALYSIS FROM THE FOLLOWING INCOME STATEMENT BELOW JOLLIBEE INCOME STATEMENT ITEM 2016 2017 2018 2019 2020 Sales/Revenue 113.81B 133.61B 161.17B 179.63B 129.31B Sales Growth - 17.40% 20.62% 11.45% -28.01% Cost of Goods Sold (COGS) incl. D&A - - 132.96B 150.88B 115.39B COGS Growth - - - 13.47% -23.52% COGS excluding D&A 89.27B 105.39B 121.08B 137.38B 100.82B Depreciation & Amortization Expense 4B 4.75B 11.89B 13.5B 14.57B Depreciation 3.93B 4.66B 11.73B 13.34B 14.32B Amortization of Intangibles 68.99M 78.95M 151.82M 145.42M 245.23M Gross Income 20.54B 23.48B 28.21B 28.75B 13.92B Gross Income Growth - 14.30% 20.12% 1.93% -51.57% Gross Profit Margin - - - - 10.77% SG&A Expense - - 17.64B 20.21B 20.42B SGA Growth - - -…
GIVE THE COMPARATIVE INCOME STATEMENT VERTICAL ANALYSIS FROM THE FOLLOWING INCOME STATEMENT BELOW JOLLIBEE INCOME STATEMENT ITEM 2016 2017 2018 2019 2020 Sales/Revenue 113.81B 133.61B 161.17B 179.63B 129.31B Sales Growth - 17.40% 20.62% 11.45% -28.01% Cost of Goods Sold (COGS) incl. D&A - - 132.96B 150.88B 115.39B COGS Growth - - - 13.47% -23.52% COGS excluding D&A 89.27B 105.39B 121.08B 137.38B 100.82B Depreciation & Amortization Expense 4B 4.75B 11.89B 13.5B 14.57B Depreciation 3.93B 4.66B 11.73B 13.34B 14.32B Amortization of Intangibles 68.99M 78.95M 151.82M 145.42M 245.23M Gross Income 20.54B 23.48B 28.21B 28.75B 13.92B Gross Income Growth - 14.30% 20.12% 1.93% -51.57% Gross Profit Margin - - - - 10.77% SG&A Expense - - 17.64B 20.21B 20.42B SGA Growth - - - 14.57% 1.02%…
Vertical Analysis of Income Statement Revenue and expense data for Innovation Quarter Inc. for two recent years are as follows: Previous Year Sales Cost of goods sold Selling expenses Administrative expenses Income tax expense Current Year $447,000 272,670 71,520 71,520 13,410 $384,000 215,040 69,120 57,600 15,360
Operating data for Sheridan Corporation are presented as follows. Net sales Cost of goods sold Selling expenses Administrative expenses Income tax expense Net income Net sales Cost of goods sold Gross profit Selling expenses Administrative expenses Total operating expenses Income before income taxes Income tax expense $ 2027 Prepare a schedule showing a vertical analysis for 2027 and 2026. (Round percentages to 1 decimal place, e.g. 12.1%.) Net income $ $842,800 530,964 126,420 80,066 37,926 67,424 2026 Amount $645,500 413,120 77,460 50,349 25,820 78,751 2027 SHERIDAN CORPORATION Condensed Income Statements For the Years Ended December 31 Percent % % % % % % % % $ % $ Amount 2026 Percent Ih SUPP
Prepare a comparative income statement for 20X2 and 20X1 using vertical analysis, and| Problem 2 VERTICAL ANALYSIS. The Lyons Corporation reported the following income stateme data: 20X2 20X1 Net sales $400.000 $250.000 Cost of goods sold $280.000 S160.000 Operating expenses S75.000 $56.000 Requirement: Prepare a comparative income statement for 20X2 and 20X1 using vertical analysis, ana evaluate the results.
Vertical Analysis of Income Statement Revenue and expense data for Rogan Technologies Co. are as follows: 20Y8 20Υ7 Sales $572,000 $503,000 Cost of goods sold 366,080 286,710 Selling expenses 80,080 85,510 Administrative expenses 91,520 100,600 Income tax expense 17,160 10,060 a. Prepare an income statement in comparative form, stating each item for both 20Y8 and 20Y7 as a percent of sales. If required, round percentages to one decimal place. Enter all amounts as a positive number. Rogan Technologies Co. Comparative Income Statement For the Years Ended December 31, 20Y8 and 20Y7 20Y8 Amount 20Y8 Percent 20Y7 Amount 20Y7 Percent % % % % Gross profit % % % Total operating expenses % % % Net income