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

Benson Company’s net income was $225,000 for Year 1, $243,750 for Year 2, and $293,160 for Year 3. Assume trend percentages for net income over the three-year period are computed, with Year 1 serving as the base year.The trend percentage for Year 3’s net income is: Select one: A. 117.30% B. 86.36% C. 120.92% D. 130.29%
Compute common-size percents for the following comparative income statements (round percents to one decimal). Using the common-size percents, which item is most responsible for the decline in net income?
Revenue and expense data for Innovation Quarter Inc. for two recent years are as follows: Current Year Previous Year Sales $490,000 $446,000 Cost of merchandise sold 289,100 231,920 Selling expenses 78,400 84,740 Administrative expenses 88,200 75,820 Income tax expense 14,700 22,300 a. 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. Innovation Quarter Inc. Comparative Income Statement For the Years Ended December 31 Current year Amount Current year Percent Previous year Amount Previous year Percent Sales $490,000 % $446,000 % Cost of merchandise sold 289,100 % 231,920 % % % Selling expenses 78,400 84,740 % Administrative expenses 88,200 % 75,820 % % % Income tax expense 14,700 % 22,300 % % % b. The vertical analysis indicates that the cost of merchandise sold as a percent of sales - by 7 percentage points, while selling expenses by 3…
Return on Assets Ratio and Asset Turnover Ratio Northern Systems reported the following financial data (in millions) in its annual report: Previous Year Current Year Net Income $9,050 $7,500 Net Sales 52,350 37,200 Total Assets 58,734 68,128 If the company’s total assets are $55,676 at the beginning of the previous year, calculate the company’s: (a) return on assets (round answers to one decimal place - ex: 10.7%) (b) asset turnover for both years (round answers to two decimal places) Previous Year Current Year a. Return on Assets Ratio Answer Answer b. Asset Turnover Ratio Answer Answer
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. Yes
Comparative Income StatementsConsider the following income statement data from the Ross Company: Current Year Previous Year Sales revenue $525,000 $450,000 Cost of goods sold 336,000 279,000 Selling expenses 105,000 99,000 Administrative expenses 60,000 54,000 Income tax expense 7,800 5,400 Prepare a comparative 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%). ROSS COMPANYComparative Income Statements Current Year Previous Year Increase(Decrease) PercentChange Sales Revenue Answer Answer Answer Answer Cost of Goods Sold Answer Answer Answer Answer Answer Answer Answer Answer Answer Answer Selling Expenses Answer Answer Answer Answer Administrative Expenses Answer Answer Answer Answer Total Answer Answer Answer Answer Income before Income Taxes Answer Answer Answer Answer Answer Answer Answer Answer Answer Answer…
Subject: accounting
1. Multiple-Choice: Calculate Company Y's return on assets, to two decimal places, based on the following information for the current year. a) 7.50 b) 9.00 c) 8.18 d) 7.27
Subject: acounting
Prepare a horizontal analysis of Nebraska Technologies's income statements. For decreases or negative numbers use a minus sign. Round percentages to one decimal place. Year 1 Increase (Decrease) Percent Favorable/Unfavorable 1 2 3 4 5 6 7 Sales Wage expense Rent expense Utilities expense Total operating expenses Net income Year 2 $158,400.00 $80,000.00 28,000.00 30,000.00 $138,000.00 $162,500.00 $92,500.00 30,000.00 25,000.00 $147,500.00 $20,400.00 $15,000.00
Selected data from Decco Company are presented below: Total assets $1,600,000 Average assets 2,000,000 Net income 380,000 Net sales 1,500,000 Average common stockholders' equity 1,000,000 Instructions Calculate the following profitability ratios from the above information. 1. Profit margin. 2. Asset turnover. 3. Return on assets.
Income statement data for Winthrop Company for two recent years ended December 31, are as follows: Current Year Previous Year Sales $369,600 $280,000 Cost of goods sold 312,000 240,000 Gross profit $57,600 $40,000 Selling expenses $17,080 $14,000 Administrative expenses 15,600 12,000 Total operating expenses $32,680 $26,000 Income before income tax $24,920 $14,000 Income tax expenses 10,000 5,600 Net income $14,920 $8,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 Current Previous Increase Increase year year (Decrease) (Decrease) Amount Amount Amount Percent Sales $369,600 $280,000 $ % Cost of goods sold 312,000 240,000 % Gross profit $57,600 $40,000 %

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