Hi there, I received only the part one and I don't have the part two can you please resubmit it to me thank you? Problems: Series AObj. 2PR 14-1A Horizontal analysis of income statementFor 20Y2, McDade Company reported a decline in net income. At the end of the year, T. Burrows,the president, is presented with the following condensed comparative income statement:V1. Sales, 12.0% increaseMcDade CompanyComparative Income StatementFor the Years Ended December 31, 20Y2 and 20Y1SHOW ME HOWEXCEL TEMPLATE20Υ220Υ1$ 15,000,000$ 16,800,000(11,500,000)$ 5,300,000$ (1,770,000)(1,220,000)$ (2,990,000)$ 2,310,000SalesCost of goods sold.Gross profitSelling expensesAdministrative expenses.(10,000,000)$ 5,000,000$ (1,500,000)(1,000,000)Total operating expenses$(2,500,000)$ 2,500,000Operating income.Other revenue256,950225,000Income before income tax expenseIncome tax expense...$ 2,566,950(1,413,000)$ 1,153,9502$2,725,000(1,500,000)$ 1,225,000Net incomeInstructions1. Prepare a comparative income statement with horizontal analysis for the two-year period, using20Y1 as the base year. Round percentages to one decimal place.2.To the extent the data permit, comment on the significant relationships revealed bythe horizontal analysis prepared in (1).

Horizontal analysis - Horizontal Analysis is part of the analysis in which individuals get the idea…

Problems: Series A Obj. 2 PR 14-1A Horizontal analysis of income statement For 20Y2, McDade Company reported a decline in net income. At the end of the year, T. Burrows, the president, is presented with the following condensed comparative income statement: V1. Sales, 12.0% increase McDade Company Comparative Income Statement For the Years Ended December 31, 20Y2 and 20Y1 SHOW ME HOW EXCEL TEMPLATE 20Y2 20Υ1 $ 16,800,000 (11,500,000) $ 5,300,000 $ (1,770,000) 000יוב1) $ (2,990,000) $ 2,310,000 Sales $ 15,000,000 Cost of goods sold. Gross profit. Selling expenses Administrative expenses. (10,000,000) $ 5,000,000 $ (1,500,000) (1,000,000) Total operating expenses $ (2,500,000) $ 2,500,000 Operating income. Other revenue ... 256,950 225,000 Income before income tax expense. $ 2,566,950 $ 2,725,000 (1,500,000) $ 1,225,000 Income tax expense (1,413,000) $ 1,153,950 Net income Instructions 1. Prepare a comparative income statement with horizontal analysis for the two-year period, using 20Y1 as the base year. Round percentages to one decimal place. 2. To the extent the data permit, comment on the significant relationships revealed by the horizontal analysis prepared in (1).

Problems: Series A Obj. 2 PR 14-1A Horizontal analysis of income statement For 20Y2, McDade Company reported a decline in net income. At the end of the year, T. Burrows, the president, is presented with the following condensed comparative income statement: V1. Sales, 12.0% increase McDade Company Comparative Income Statement For the Years Ended December 31, 20Y2 and 20Y1 SHOW ME HOW EXCEL TEMPLATE 20Y2 20Υ1 $ 16,800,000 (11,500,000) $ 5,300,000 $ (1,770,000) 000יוב1) $ (2,990,000) $ 2,310,000 Sales $ 15,000,000 Cost of goods sold. Gross profit. Selling expenses Administrative expenses. (10,000,000) $ 5,000,000 $ (1,500,000) (1,000,000) Total operating expenses $ (2,500,000) $ 2,500,000 Operating income. Other revenue ... 256,950 225,000 Income before income tax expense. $ 2,566,950 $ 2,725,000 (1,500,000) $ 1,225,000 Income tax expense (1,413,000) $ 1,153,950 Net income Instructions 1. Prepare a comparative income statement with horizontal analysis for the two-year period, using 20Y1 as the base year. Round percentages to one decimal place. 2. To the extent the data permit, comment on the significant relationships revealed by the horizontal analysis prepared in (1).

Managerial Accounting

15th Edition

ISBN:9781337912020

Author:Carl Warren, Ph.d. Cma William B. Tayler

Publisher:Carl Warren, Ph.d. Cma William B. Tayler

Chapter16: Financial Statement Analysis

Section: Chapter Questions

Problem 1PA

See similar textbooks

Similar questions

Profitability metrics The following selected data were taken from the financial statements of The O'Malley Group Inc. for December 31, 20Y5. 20Y4. and 20Y3: No dividends on common stock were declared between 20Y3 and 20Y5. a.Determine the return on total assets, the return on stockholders' equity, and the return on common stockholders' equity Tor the years 20Y4 and 20Y5. Round to one decimal place. b. What conclusions can be drawn from these data as to the company's profitability?
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?
Multiple-Step and Single-Step In coin Statements The following items were derived from Gold Companys December 31 adjusted trial balance: Additional data: 1. Screen thousand share of common stock have been outstanding the entire year. 2. The income tax rate is 30% on all items of income. Required: 1. Prepare a multiple-st income statement. 2. Prepare a single step income statement. 3. Next Level Discuss how Gold Companys income statement in Requirement I might be different if it used IFRS
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%.
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 Instuctins Times preferred earned
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 Earnings per share on common stock
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
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 Quick ratio