Answered step by step
Verified Expert Solution
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:
- 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).
- 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 |
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started