Horizontal Analysis of Income StatementThe following data (in millions) are taken from the financial statements of Target Corporation:Recent YearPrior YearRevenue$72,618$71,279Operating expenses68,08366,109Operating income$ 4,535$ 5,170a. For Target Corporation, determine the amount of change in millions and the percent of change (round to one decimal place) from the prior year to the recent year for:1. Revenue2. Operating expenses3. Operating income (For those boxes in which you must enter negative numbers use a minus sign.)Amount of ChangePercent of Change(in millions)(round to 1 decimal place)Increase or Decrease1. Revenue2. Operating expenses3. Operating incomeb. During the recent year, revenueand operating expensesAs a result, operating incomefrom the prioryear.

Answered: Horizontal Analysis of Income Statement…

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Revenue and expense data for Innovation Quarter Inc. for two recent years are as follows: Current Year Previous Year Sales $586,000 $527,000 Cost of merchandise sold 345,740 279,310 Selling expenses 93,760 100,130 Administrative expenses 105,480 89,590 Income tax expense 17,580 21,080. Prepare an income statement in comparative form, stating each item for both years as a percent of sales. If required, round percentages to one decimal place. Enter all amounts as positive numbers.
Vertical Analysis Two income statements for Upward Company follow: Upward Company Income Statements For the Years Ended December 31 20Y5 20Y4 Fees earned $924,000 $784,000 Operating expenses 545,160 478,240 Income from operations $378,840 $305,760 a. Prepare a vertical analysis of Upward Company's income statements. Enter percents as whole numbers. Upward Company Income Statements For the Years Ended December 31 20Y5 Amount 20Y5 Percent 20Y4 Amount 20Y4 Percent Fees earned $924,000 100 % $784,000 100 % 545,160 0X % 478,240 X % Operating expenses X % $305,760 X % Income from operations $378,840
Long-Term Solvency Ratios Summary data from year-end financial statements of Palm Springs Company for the current year follow. Summary Income Statement Data Sales $10, 500, 600 Cost of goods sold 6, 050,000 Selling expenses 685,000 Administrative expenses 945,000 Interest expense 783, 500 Income tax expense 427,791 8,891,291 Net income $1,609,309 Summary Balance Sheet Data Cash $84, 700 Total liabilities $749,700 Noncash assets 885,500 Stockholders' equity 220, 500 Total assets $970, 200 Total liabilities and equity $970, 200 Round answers to one decimal place. a. Compute the ratio of times - interest - earned. Answer times b. Compute the debt-to-equity ratio. Answer
Vertical analysis The following income statement data for AT&T Inc. and Verizon Communications Inc. were taken from their recent annual reports (in millions): AT&T Verizon Revenues $132,447 $127,079 Cost of services (expense) 60,611 49,931 Selling and marketing expense 39,697 41,016 Depreciation and other expenses 20,393 16,533 Operating income $ 11,746 $ 19,599 Required: a. Prepare a vertical analysis of the income statement for AT&T. Round to one decimal place. AT&T Income Statement Amount Percent Revenues Cost of services (expense) Selling and marketing expense Depreciation and other expenses Operating income b. Prepare a vertical analysis of the income statement for Verizon. Round to one decimal place. Verizon Income Statement Amount Percent Revenues Cost of services (expense) Selling and marketing expense Depreciation and other expenses Operating…
Comparative Income Statements Consider the following income statement data from the Mono Company: Sales revenue Cost of goods sold Selling expenses Administrative expenses Income tax expense 2019 2018 $600,000 $450,000 336,000 279,000 105,000 99,000 60,000 50,000 4,000 3,000 Prepare a contparative income statement, showing increases, and decreases in dollars and in percentages. Note: Round "Percent Change" answers to one decimal place (ex: 0.2345 = 23.5%). Sales Revenue Cost of Goods Sold MONO COMPANY Comparative Income Statements ♦ Selling Expenses Administrative Expenses Total Income before Income Taxes ◆ → $ $ 2019 0 $ 0 0 0 0 oooo 0 0 $ 2018 Increase (Decrease) 0 $ 0 0 0 0 0 0 0 0 $ 0 0 0 0 0 0 0 0 0 Percent Change 0% 0% 0% 0% 0% 0% 0% 0% 0 %
Horizontal Analysis of the Income Statement Income statement data for Winthrop Company for two recent years ended December 31, are as follows: Current Year Previous Year Sales $418,200 $340,000 Cost of goods sold 350,900 290,000 Gross profit $67,300 $50,000 Selling expenses $19,210 $17,000 Administrative expenses 16,940 14,000 Total operating expenses $36,150 $31,000 Income before income tax $31,150 $19,000 Income tax expenses 12,500 7,600 Net income $18,650 $11,400 a. Prepare a comparative income statement with horizontal analysis, indicating the increase (decrease) for the current year when compared with the previous year. If required, round to one decimal place. Winthrop Company Comparative Income Statement For the Years Ended December 31 CurrentyearAmount PreviousyearAmount Increase(Decrease)Amount Increase(Decrease)Percent Sales $418,200 $340,000 $fill in the blank…
Trend Analysis Critelli Company has provided the following comparative information: Year 5 Year 4 Year 3 Year 2 Year 1 Net income $940,300 $810,600 $681,200 $582,200 $493,400 Interest expense 319,700 291,800 252,000 192,100 153,000 Income tax expense 300,896 226,968 190,736 151,372 118,416 Average total assets 5,779,817 5,103,704 4,360,748 3,704,785 3,153,171 Average stockholders' equity 1,975,420 1,769,869 1,548,182 1,373,113 1,203,415 You have been asked to evaluate the historical performance of the company over the last five years. Selected industry ratios have remained relatively steady at the following levels for the last five years: Industry Ratios Return on total assets 21.5 % Return on stockholders’ equity 44.4 % Times interest earned 4.6 Instructions: Calculate three ratios for Year 1 through Year 5. Round to one decimal place. a. Return on total assets: Year 5…
Forecast an Income Statement Following is the income statement for Medtronic PLC. Consolidated Statement of Income ($ millions) For Fiscal Year Ended April 26, 2019 Net sales $27,807 Costs and expenses Cost of products sold 8,331 Research and development expense 2,330 Selling, general, and administrative expense 9,480 Amortization of intangible assets 1,605 Restructuring charges, net 198 Certain litigation charges, net 166 Other operating expense, net 258 Operating profit 5,439 Other nonoperating income, net (373) Interest expense 1,314 Income before income taxes 4,498 Income tax provision 547 Net income 3,951 Net income loss attributable to noncontrolling interests (19) Net income attributable to Medtronic $3,932 Use the following assumptions to prepare a forecast of the company’s income statement for FY2020. Note: Complete the entire question in Excel using the following template: Excel Template. Format each answer to two decimal…
Vertical analysis Two income statements for Cornea Company follow: Cornea Company Income Statements For the Years Ended December 31 20Y9 20Y8 Fees earned $1,570,000 $1,300,000 Expenses (832,100) (780,000) Net income $737,900 $520,000 Required: a. Prepare a vertical analysis of Cornea Company’s income statements. If required, round your percentage to the nearest whole number. Cornea Company Income Statements For the Years Ended December 31 20Y9 20Y8 Amount Percent Amount Percent Fees earned $1,570,000 % $1,300,000 % Expenses (832,100) % (780,000) % Operating income $737,900 % $520,000 % b. Does the vertical analysis indicate a favorable or an unfavorable trend?
Selected income statement and balance sheet data from Merck & Co. for Year 9 are reproduced below: MERCK & COMPANY, INC. Year 9 Selected Financial Data ($ millions) Merck & Co. Income Statement Data Sales revenue... Depreciation...... Interest expense. $7,120 230 10 Pretax income... 2,550 Income taxes.. 900 Net income. 1,650 Balance Sheet Data Current assets... $4,850 Fixed assets, net... 2,400 Total assets.. 7,250 Current liabilities... 3,290 Long-term debt... 100 Shareholders' equity... 3,860 Total liabilities & shareholders' equity.. Required: a. Calculate return on common equity for Year 9 using year-end amounts and assuming no preferred dividends. b. Disaggregate Merck's ROCE. Comment on Merck's use of leverage. (Assume all assets and current liabilities are operating and a 35% tax rate.). c. Disaggregate ROA and comment on that.
Horizontal Analysis of the Income Statement Income statement data for Winthrop Company for two recent years ended December 31 are as follows: Current Year Previous Year Sales $536,800 $440,000 Cost of merchandise sold 444,000 370,000 Gross profit $92,800 $70,000 Selling expenses $25,760 $23,000 Administrative expenses 22,800 19,000 Total operating expenses $48,560 $42,000 Income before income tax expense $44,240 $28,000 Income tax expenses 17,700 11,200 Net income $26,540 S16,800 a. Prepare a comparative income statement with horizontal analysis, indicating the increase (decrease) for the current year when compared with the previous year. If required, round to one decimal place. Winthrop Company Comparative Income Statement For the Years Ended December 31 Current Increase Increase (Decrease) Previous year year (Decrease)
Ratios Analyzing Firm ProfitabilityThe following information is available for Buhler Company: Annual Data Current Year Previous Year Net sales $8,800,000 $8,200,000 Gross profit on sales 3,053,000 2,736,000 Net income 567,600 488,000 Dec. 31, Dec. 31, Year-End Data Current Year Previous Year Total assets $6,700,000 $6,300,000 Stockholders' equity 3,800,000 3,200,000 Calculate the following ratios for the current year: Note: Round answers to one decimal place, unless otherwise noted. a. Gross profit percentageAnswer%b. Return on salesAnswer%c. Asset turnover (Round answer to two decimal places.)Answerd. Return on assetsAnswer%e. Return on common stockholders' equity (Buhler Company has no preferred stock.)Answer% PreviousSave AnswersNext

SEE MORE QUESTIONS

Recommended textbooks for you

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

Horngren's Cost Accounting: A Managerial Emphasis…

Accounting

ISBN:

9780134475585

Author:

Srikant M. Datar, Madhav V. Rajan

Publisher:

PEARSON

Intermediate Accounting

Accounting

ISBN:

9781259722660

Author:

J. David Spiceland, Mark W. Nelson, Wayne M Thomas

Publisher:

McGraw-Hill Education

Financial and Managerial Accounting

Accounting

ISBN:

9781259726705

Author:

John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS