Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

So, this is what I have so far in regards to the following question: Provide common-size analysis of your companys income statement and balance sheet

So, this is what I have so far in regards to the following question:

  1. Provide common-size analysis of your companys income statement and balance sheet for the 2 most recent years (must be done using Excel with formulas).
  2. Provide horizontal analysis of your companys income statement and balance sheet, showing the dollar amount and percent of change using the 2 most recent years (you must use an Excel spreadsheet with formulas). Can someone help me pretty pretty please. :( My assignment is due tomorrow.

I'm using the latest annual report found on Bed Bath and Beyond's website for my figures.

2021 2020 100% Current YR 100% Previous YR
Net Sales 9,233,028 11,158,580
Cost of Sales 6,114,947 7,616,920
Gross Margin 3,118,081 3,541,660 34% 31.74%
Research & Development
Selling, general and administrative 3,224,363 3,732,498
Total Operating Expenses
Operating Income
Other income, net
Income before provision for income taxes (336,762) (764,853)
Provision for Income Taxes (185,989) (151,037)
Net Income

image text in transcribed

BED BATH & BEYOND INC. AND SUBSIDIARIES Consolidated Statements of Operations (in thousands, except per share data) Twelve Months Ended February 29, 2020 $ 11,158,580 7,616,920 3,541,660 3,732,498 509,226 March 2, 2019 $12,028,797 7,924,817 4,103,980 3,681,210 509,905 February 27, 2021 $9,233,028 6,114,947 3,118,081 3,224,363 127,341 102,202 1,062 (336,887) 76,913 (77,038) (336,762) (185,989) $ (150,773) $ (1.24) $ (1.24) 121,446 121,446 (700,064) 64,789 Net sales Cost of sales Gross profit Selling, general and administrative expenses Goodwill and other impairments Restructuring and transformation initiative expenses Loss on sale of businesses, including impairment of assets held for sale Operating loss Interest expense, net Gain on extinguishment of debt Loss before benefit from income taxes Benefit from income taxes Net loss Net loss per share - Basic Net loss per share - Diluted Weighted average shares outstanding - Basic Weighted average shares outstanding - Diluted Dividends declared per share See accompanying Notes to Consolidated Financial Statements. (87,135) 69,474 (764,853) (151,037) $ (613,816) $ (4.94) $ (4.94) 124,352 124,352 0.68 (156,609) (19,385) $ (137,224) $ (1.02) $ (1.02) 134,292 134,292 0.64

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Modern Financial Markets And Institutions

Authors: Glen Arnold

1st Edition

0273730355, 9780273730354

More Books

Students also viewed these Accounting questions

Question

which of the following is a way to compute GDP?

Answered: 1 week ago