Question

Horizontal Analysis Bed Bath and Beyond, Inc. Income Statement 12 Months Ended In Thousands Mar. 03, 2018 Feb. 25, 2017 Amount Percentage Net sales $ 12,349,301 $ 12,215,757 $ 133,5...

Horizontal Analysis Bed Bath and Beyond, Inc. Income Statement 12 Months Ended In Thousands
Mar. 03, 2018 Feb. 25, 2017 Amount Percentage
Net sales $ 12,349,301 $ 12,215,757 $ 133,544 1.09%
Cost of sales 7,906,286 7,639,407 $ 266,879 3.49%
Gross profit 4,443,015 4,576,350 $ (133,335) -2.91%
Selling, general and administrative expenses 3,681,694 3,441,140 $ 240,554 6.99%
Operating profit 761,321 1,135,210 $ (373,889) -32.94%
Interest expense, net 65,661 69,555 $ (3,894) -5.60%
Earnings before provision for income taxes 695,660 1,065,655 $ (369,995) -34.72%
Provision for income taxes 270,802 380,547 $ (109,745) -28.84%
Net earnings $ 424,858 $ 685,108 $ (260,250) -37.99%
Horizontal Analysis Pier 1 Imports, Inc. Income Statement 12 Months Ended In Thousands
Mar. 03, 2018 Feb. 25, 2017 Amount Percentage
Net sales $ 1,798,522 $ 1,828,446 $ (29,924) -1.64%
Cost of sales 1,140,372 1,131,138 $ 9,234 0.82%
Gross profit 658,150 697,308 $ (39,158) -5.62%
Selling, general and administrative expenses 576,878 587,843 $ (10,965) -1.87%
Depreciation 53,603 54,603 $ (1,000) -1.83%
Operating income 27,669 54,862 $ (27,193) -49.57%
Nonoperating (income) and expenses:
Interest, investment income and other (2,590) (2,470) $ (120) N/M
Interest expense 12,362 12,073 $ 289 2.39%
Nonoperating (income) and expenses 9,772 9,603 $ 169 1.76%
Income before income taxes 17,897 45,259 $ (27,362) -60.46%
Income tax provision 6,271 15,130 $ (8,859) -58.55%
Net income $ 11,626 $ 30,129 $ (18,503) -61.41%
N/M designates not meaningful and is used when the base year is zero or negative.

1. Examine revenue and related accounts. Revenue is the largest item on the income statement, so we need to assess it on a quantitative and qualitative basis.

a. Explain what horizontal analysis is and why it is useful in the analysis process. Compare the horizontal analyses for the income statements of the two companies that I have prepared in the Excel Horizontal Analysis attachment.    Analyze each company over the last two years to identify two account changes that should be investigated for each company. Do not reference a computed figure on the income statement like Gross Margin, but a specific account. Why did you pick these items?

b. Read the management’s discussion and analysis (MD&A) section of the 10-Ks, which is found in Item 7 of the table of contents. Explain how the companies’ senior managers explain sales and net earnings (income) in the most recent fiscal year. Provide the page number(s) you are using from the 10-K as your reference to this question.

c. Find the footnote or notes to the financial statements on the operations of the business and/or what their segment(s) are. Provide a short summary of what the company considers their business and segments. Also, provide the page number you found this information. Remember that the notes to the financial statements are an integral part of the financial statements, so are part of Item 8 and follow the audited financial statements. Provide the page number you found this information.

d. Find the footnote or notes to the financial statements on sales revenue recognition and gift card revenue recognition policy if applicable. Provide how the company recognizes revenue. Also, compare the revenue recognition to each other.

0 0
Add a comment Improve this question Transcribed image text
Answer #1

A
Horizontal analysis is the process in which we compare financial statements or financial ratios across a number of years to track the growth and progress of the company. It is also known as trend analysis. It helps to analyze whether the company is improving or declining.

Uses of Horizontal analysis
It helps the management of the company to understand how well a company is doing in order to make decisions. It also helps in taking strategic decisions. It provides the management with an insight that whether there is need to improve the future performance of the company or not.
It helps the investors to make the decision whether they want to invest or sell their current investment; while management needs to know what moves to make in order to improve the future performance of the company.
It is an extremely useful tool for anyone trying to track a company’s performance over time.

Bed Bath and Beyond, Inc.
The net sales of the company has increased by $133,544 or 1.09% within a year. This shows the increase in the demand of the products of the company.
However, The cost of sales have increased much more than the net sales. To be specific, there is an increase of $266,879 or 3.49% within a year.
As the cost of sales has increased much more than net sales. This implies that gross profit of the company will not have increased although there is an increase in net sales.

Pier 1 Imports, Inc.
The net sales of the company has decreased by $29,924 or 1.64% within a year. This shows the decrease in the demand of the products of the company.
However, The cost of sales have increased only $9,234 or 0.82% within a year.
Decrease is net sales along with increase in the cost of sales means decrease in gross profit.


Net sales and cost of sales are major accounts to know about the revenues of the company. Therefore, I used these accounts to do horizontal analysis.

NOTE - Complete information regarding part B, C and D is not given.

Add a comment
Know the answer?
Add Answer to:
Horizontal Analysis Bed Bath and Beyond, Inc. Income Statement 12 Months Ended In Thousands Mar. 03, 2018 Feb. 25, 2017 Amount Percentage Net sales $ 12,349,301 $ 12,215,757 $ 133,5...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Required Perform a horizontal analysis, showing the percentage change in each income statement component between 2018...

    Required Perform a horizontal analysis, showing the percentage change in each income statement component between 2018 and 2019. Perform a vertical analysis, showing each income statement component as a percentage of sales for each year. CAMPBELL COMPANY Income Statements 2019 Sales $ 201,500 Cost of goods sold 143,200 Selling expenses 20,300 Administrative expenses 12,600 Interest expense 3,100 Total expenses $179,200 Income before taxes 22,300 Income taxes expense 5,900 Net income $ 16,400 2018 $181,500 121,200 18,300 14,600 5,100 $159,200 22,300...

  • 12 Months Ended in Millions $ Home Depot, Ine. Common Size Statement of Enmings Feb. 03,...

    12 Months Ended in Millions $ Home Depot, Ine. Common Size Statement of Enmings Feb. 03, 2019 Jan 28, 2018 Jan. 29, 2017 Feb. 03, 2019 Jan 28, 2018 Jan. 29, 2017 $ 108,203 71,043 37,160 $100,904 66,548 34,356 $ 94,595 62,282 32,313 17,864 1.811 6 Gross proft 7 Operating expenses Seng peneral and a n Deprecation and mortation 10 Impamentos 11 Tooperating expenses 12 Operating income 13 Interest and other income) expense: 14 Interest and investment income 19,513 1,870...

  • Complete a vertical and horizontal analysis on both the income statement and balance sheet. use total...

    Complete a vertical and horizontal analysis on both the income statement and balance sheet. use total assets on the balance sheet and net sales on the income statement for your vertical analysis. Styles Consolidated Statements of 12 Months Ended Earnings (USD $) In Millions, except Per Share data, unless otherwise specified Income Statement (Abstract] NET SALES Cost of Sales Vertical Vertical Horizontal Feb. 01, 2015 Feb. 02, 2014 Analysis Analysis Analysis $83,176 54,222 $78,812 51,422 GROSS PROFIT Operating Expenses: Selling,...

  • 12 Months Ended in Millions $ Percentages Lowe's Companies, Inc. Common Size Statement of Earings Feb....

    12 Months Ended in Millions $ Percentages Lowe's Companies, Inc. Common Size Statement of Earings Feb. 01, 2019 Feb. 02, 2018 Feb. 03, 2017 Feb 01, 2019 Feb. 02, 2018 Feb. 03, 2017 You must us references to Net Sales Cost of sales Gross $71,309 48,401 22,908 $ 68,619 46,185 22,434 $ 65,017 43,343 21,674 Song general and admi Depreciation and amo Operating income Interest - het Loss on extinguishment of debt Pre-tax Barnings Income tax provision Net earings 17,413...

  • McCormick Designs, Inc. Comparative Income Statement Years Ended December 31, 2018 and 2017 2018 2017 Net...

    McCormick Designs, Inc. Comparative Income Statement Years Ended December 31, 2018 and 2017 2018 2017 Net Sales Revenue $ 431,500 $ 371,150 Expenses: Cost of Goods Sold 201,550 Selling and Administrative Expenses 100,050 8,000 186,250 94,000 6,000 Other Expenses Total Expenses 309,600 286,250 $ 121,900 $ 84,900 Net Income 1. Prepare a horizontal analysis of the comparative income statement of McCormick Designs, Inc. Round percentage changes to one decimal place. Why did 2018 net income increase by a higher percentage...

  • Horizontal Analysis of Income Statement For 20Y2, McDade Company reported a decline in net income. At...

    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: McDade Company Comparative Income Statement For the Years Ended December 31, 20Y2 and 20Y1 20Y2 20Y1 Sales $352,096 $294,000 Cost of goods sold 266,000 190,000 Gross profit $86,096 $104,000 Selling expenses $37,500 $25,000 Administrative expenses 21,760 16,000 Total operating expenses $59,260 $41,000 Income from operations $26,836...

  • Horizontal Analysis of Income Statement For 20Y2, McDade Company reported a decline in net income. At...

    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: McDade Company Comparative Income Statement For the Years Ended December 31, 20Y2 and 20Y1 20Y2 20Y1 Sales $434,720 $370,000 Cost of goods sold 312,800 230,000 Gross profit $121,920 $140,000 Selling expenses $44,950 $31,000 Administrative expenses 26,480 20,000 Total operating expenses $71,430 $51,000 Income from operations $50,490...

  • Horizontal Analysis of Income Statement For 2012, McDade Company reported a decline in net income. At...

    Horizontal Analysis of Income Statement For 2012, 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: McDade Company Comparative Income Statement For the Years Ended December 31, 2012 and 2041 2012 2011 Sales $341,120 $304,000 Cost of goods sold 239.400 190,000 Gross profit $101.720 $114,000 Selling expenses $34,450 19,740 $26,000 16,000 Administrative expenses $54,190 $42.000 Total operating expenses Income from operations $47,530...

  • 12 Months Ended in Millions $ Percentages Jan. 29, 2017 Home Depot, Inc. Common Size Statement...

    12 Months Ended in Millions $ Percentages Jan. 29, 2017 Home Depot, Inc. Common Size Statement of Earnings Jan. 28, 2018 Jan. 29, 2017 Jan. 31, 2016 Jan. 28, 2018 Jan. 31, 2016 88,519 Net sales Cost of sales Gross profit Operating expenses Sel S 100,904 66,548 S 94,595 62,282 100.00% 100.00% 100.00% 58.254 34.16% 34.19% ling, general and administrative Depreciation and amortization Total operating expenses Operating income Interest and other (income) expense Interest and investment income nterest expense Interest...

  • Describe the changes of the Comparative Income Statement Analysis in 300 words or more. Horizontal Analysis...

    Describe the changes of the Comparative Income Statement Analysis in 300 words or more. Horizontal Analysis Income Statement As Reported Annual Income Statement Report Date 2016 2017 2018 Increase/ Decrease % Change Increase/ Decrease % Change Scale Thousand Thousand Thousand Net Sales $ 65,017,000 $ 68,619,000 $ 71,309,000 $    3,602,000 5.54% $   2,690,000 3.92% Cost of Sales $ 42,553,000 $ 45,210,000 $ 48,401,000 $    2,657,000 6.24% $   3,191,000 7.06% Gross Margin $ 22,464,000 $ 23,409,000 $ 22,908,000 $        945,000 4.21%...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT