comparative income statements of ArabManufacturing Company are shown below.2019$38,610 $32,175 $25,74020202018Net sales25,100 19,950S13,510 S12,225 $10,3407,7004,270Cost of sales15,400Gross profitSelling expenses6,5655,148Administrative4.1753,861expensesTotal operatingS11,970 $10,740 $9.009expensesOperatingS 1,540 S1,485 $1,331incomeInterest expense11595100Net incomeS 1,425 S 1,390 $1,231before tax655645S 770 S 745541$ 690Income taxesNet incomeRequired:a. Perform a vertical, common size analysis of theincome statement data for Arab ManufacturingCompany in columnar form, using sales as thebase.b. Comment briefly on significant trends andrelationships revealed by the computations. :52 PM

Vertical analysis compares two amounts of a same period. In Vertical analysis, a figure is taken as…

comparative income statements of Arab Manufacturing Company are shown below. 2019 2020 $38,610 $32,175 $25,740 25,100 19,950 S13,510 S12,225 $10,340 7,700 4,270 2018 Net sales Cost of sales 15,400 Gross profit Selling expenses Administrative 6,565 5,148 4,175 3,861 expenses Total operating S11,970 $10,740 $ 9,009 expenses Operating S 1,540 S1,485 $ 1,331 income Interest expense 95 S 1,231 115 100 Net income S 1,425 S 1,390 before tax Income taxes 655 645 $ 770 $ 745 541 $ 690 Net income Required: a. Perform a vertical, common size analysis of the income statement data for Arab Manufacturing Company in columnar form, using sales as the base. b. Comment briefly on significant trends and relationships revealed by the computations.52 PI

comparative income statements of Arab Manufacturing Company are shown below. 2019 2020 $38,610 $32,175 $25,740 25,100 19,950 S13,510 S12,225 $10,340 7,700 4,270 2018 Net sales Cost of sales 15,400 Gross profit Selling expenses Administrative 6,565 5,148 4,175 3,861 expenses Total operating S11,970 $10,740 $ 9,009 expenses Operating S 1,540 S1,485 $ 1,331 income Interest expense 95 S 1,231 115 100 Net income S 1,425 S 1,390 before tax Income taxes 655 645 $ 770 $ 745 541 $ 690 Net income Required: a. Perform a vertical, common size analysis of the income statement data for Arab Manufacturing Company in columnar form, using sales as the base. b. Comment briefly on significant trends and relationships revealed by the computations.52 PI

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.2.2P

See similar textbooks

Similar questions

Refer to RE22-2. Assume Heller Company had sales revenue of 510,000 in 2019 and 650,000 in 2020. Prepare Hellers partial income statements (through gross profit) for 2019 and 2020. RE22-2 Heller Company began operations in 2019 and used the LIFO method to compute its 300,000 cost of goods sold for that year. At the beginning of 2020, Heller changed to the FIFO method. Heller determined that its cost of goods sold under FIFO would have been 250,000 in 2019. For 2020, Hellers cost of goods sold under FIFO was 360,000, while it would have been 410,000 under LIFO. Heller is subject to a 21% income tax rate. Compute the cumulative effect of the retrospective adjustment on prior years income (net of taxes) that Heller would report on its retained earnings statement for 2020.
Profitability Ratios Tinker Corporation operates in the highly competitive consulting industry. Tinkers balance sheet indicates the following balances as of December 31, 2019. Required: Calculate Tinkers return on equity if Tinkers 2019 net income is $90,000.
Leverage Cook Corporation issued financial statements at December 31, 2019, that include the following information: Balance sheet at December 31,2019 Assets $8,000,000 Liabilities $1,200,000 Stockholders' equity (300,000 shares) $6,800,000 Income statement for 2019: Income from operations $1,200,000 Less: Interest expense (100,000) Income before taxes $1,100,000 Less: Income taxes expense (0,30) (330,000) Net income $ 770,000 The levels of assets, liabilities, stockholders' equity, and operating income have been stable in recent years; however, Cook Corporation is planning a 51,800,000 expansion program that will increase income from operations by $350,000 to $1,550,000, Cook is planning to sell 8.5% notes at par to finance the expansion. Required: What earnings per share does Cook report before the expansion?
Income Statement for Year Ended December 31, 2018 (Millions of Dollars) Net sales 795.0 Cost of goods sold 660.0 Gross profit 135.0 Selling expenses 73.5 EBITDA 61.5 Depreciation expenses 12.0 Earnings before interest and taxes (EBIT) 49.5 Interest expenses 4.5 Earnings before taxes (EBT) 45.0 Taxes (40%) 18.0 Net income 27.0 a. Calculate the ratios you think would be useful in this analysis. b. Construct a DuPont equation, and compare the companys ratios to the industry average ratios. c. Do the balance-sheet accounts or the income statement figures seem to be primarily responsible for the low profits? d. Which specific accounts seem to be most out of line relative to other firms in the industry? e. If the firm had a pronounced seasonal sales pattern or if it grew rapidly during the year, how might that affect the validity of your ratio analysis? How might you correct for such potential problems?
Twenty metrics of liquidity, solvency, and profitability The comparative financial statements of Automotive Solutions Inc. are as follows. The market price of Automotive Solutions Inc. common stock was $119.70 on December 31, 20Y8 Instructions Return on total assets
Fisafolia Corporation has gross income from operations of $210,000 and operating expenses of $160,000 for 2019. The corporation also has $30,000 in dividends from publicly traded domestic corporations in which the ownership percentage was 45 percent. Calculate the corporation's dividends received deduction for 2019. $_____________ Assume that instead of $210,000, Fisafolia Corporation has gross income from operations of $135,000. Calculate the corporation's dividends received deduction for 2019. $___________ Assume that instead of $210,000, Fisafolia Corporation has gross income from operations of $158,000. Calculate the corporation's dividends received deduction for 2019. $_____________
Sales transactions Using transactions listed in P4-2, indicate the effects of each transaction on the liquidity metric working capital and profitability metric gross profit percent. Indicate the gross profit percent for each sale (rounding to one decimal place) in parentheses next to the effect of the sale on the company’s ability to attain an overall gross profit percent of 30%.
Data for Lozano Chip Company and its industry averages follow. Calculate the indicated ratios for Lozano. Construct the extended DuPont equation for both Lozano and the industry. Outline Lozano’s strengths and weaknesses as revealed by your analysis. Lozano Chip Company: Balance Sheet as of December 31, 2019 (Thousands of Dollars) Lozano Chip Company: Income Statement for Year Ended December 31, 2019 (Thousands of Dollars)
Profitability ratios The following selected data were taken from the financial statements of Robinson Inc. for December 31, 2016, 2015 and 2014: December31 2016 2015 2014 Total assets......................................... 4,800,000 4,400,000 4,000,000 Notes payable (8% interest)........................... 2,250,000 2,250,000 2,250,000 Common stock...................................... 250,000 250,000 250,000 Preferred 4% stock, 100 par (no change during year)........................... 500,000 500,000 500,000 Retained earnings................................... 1,574,000 1,222,000 750,000 The 2016 net income was 372,000, and the 2015 net income was 492,000. No dividends on common stock were declared between 2014 and 2016. a. Determine the rate earned on total assets, the rate earned on stockholders equity, and the rate earned on common Stockholders equity for the years 2015 and 2016. Round to one decimal place. b. What conclusions can be drawn from these data as to the companys profitability?
Cost of Goods Sold, Income Statement. and Statement of Comprehensive Income Gaskin Company derives the following items from its adjusted trial balance as of December 31, 2019: The following; additional information is also available. The December 31, 2019, ending inventory is 14,700. During 2019, 4,200 shares of'common stock were outstanding the entire year. The income tax rate 30% on all items of income. Required: 1. As a supporting document for Requirements 2 and 3, prepare a separate schedule for Gaskins cost of goods sold. 2. Prepare a 2019 single-step income statement. 3. Prepare a 2019 multiple-step income statement. 4. Prepare a 2019 statement of comprehensive income.
Return on assets The following data (in millions) were adapted from recent financial statements of Tootsie Roll Industries Inc. (TR): The percent a company adds to its cost of sales to determine selling price is called a markup. What is Tootsie Roll’s markup percent? Round to one decimal place.
Twenty metrics of liquidity, solvency, and profitability The comparative financial statements of Automotive Solutions Inc. are as follows. The market price of Automotive Solutions Inc. common stock was $119.70 on December 31, 20Y8 Instructions Price-earnings ration