Horizontal Analysis: Horizontal analysis is prepared to make comparison between the financial statements to determine the changes in the financial statements for the previous year to the current year. The changes of the company are measured in dollars as well as in percentage. Formula: Percentage Change = 100 × Later Period Amount − Base Period Amount Base Period Amount To prepare: Horizontal Analysis

Question

Want to see the full answer?

Answer 1

Question

Chapter 13, Problem 13.9BE

To determine

Horizontal Analysis: Horizontal analysis is prepared to make comparison between the financial statements to determine the changes in the financial statements for the previous year to the current year. The changes of the company are measured in dollars as well as in percentage.

Formula:

Percentage Change=100×Later Period Amount −Base Period AmountBase Period Amount

To prepare: Horizontal Analysis

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Students have asked these similar questions

- 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. Use the minus sign to indicate a decrease in the "Difference" columns. McDade Company Comparative Income Statement For the Years Ended December 31, 20Y2 and 20Y1 Sales Cost of merchandise sold Gross profit Selling expenses Net income Administrative expenses Total operating expenses Income from operations Other revenue Income before income tax expense $100,382 $170,000 Income tax expense 28,100 51,000 $72,282 $119,000 2. Net income has Difference Amount 7 20Y2 20Y1 $818,551 $703,000 589,600 440,000 $228,951 $263,000 $ $84,080 $59,000 48,320 37,000 $132,400 $96,000 $ $96,551 $167,000 3,831 3,000 from 20Y1 to 20Y2. Sales have Difference Percent - % % % % % % % 1% % % 1% increased decreased however, the cost of merchandise sold has causing the gross profit to Previous Next

Vertical Analysis of Income Statement Revenue and expense data for Innovation Quarter Inc. for two recent years are as follows: Current Year Previous Year Sales Cost of merchandise sold Selling expenses Administrative expenses Income tax expense Sales 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 $388,000 100 248,320 Cost of merchandise sold Gross profit Selling expenses Administrative expenses Total operating expenses Income from operations Income tax expense $388,000 248,320 54,320 62,080 7,760 Net income $353,000 208,270 56,480 52,950 14,120 $ 54,320 62,080 7,760 % % % % % % % % % Previous year Amount Previous year Percent $353,000 100 ✓ % 208,270 $ 56,480 52,950 14,120 % % % % % % % %

Vertical analysis (common-size) percentages for Baker Company’s sales revenue, cost of goods sold, and expenses are as follows. Did Baker’s net income as a percent of sales increase, decrease, or remain unchanged over the 3-year period? Provide numerical support for your answer. Vertical Analysis 2018 2017 2016 Sales revenue 100.0% 100.0% 100.0% Cost of goods sold 60.0 63.9 65.0 Expenses 26.0 26.6 27.5