Answered step by step
Verified Expert Solution
Question
...
1 Approved Answer
Provide common-size analysis of Bed Bath & Beyond's income statement for the 2 most recent years (you must use an Excel spreadsheet with formulas) Can
Provide common-size analysis of Bed Bath & Beyond's income statement for the 2 most recent years (you must use an Excel spreadsheet with formulas) Can you help me with the percentages?
Current Yr 2021 | 100% | Previous Yr 2020 | 100% | |
Assets | ||||
Cash and Cash Equivalents | 1,352,984 | 1,000,340 | ||
Short-term marketable securities | 0 | 385,642 | ||
Accounts receivable, net | 0 | 0 | ||
Inventories | 1,671,909 | 2,093,869 | ||
Vendor non-trade receiveables | 0 | 0 | ||
other current assets | 595,152 | 347,244 | ||
Total current assets | 3,620,045 | 3,826,285 | ||
Long-term marketable securities | 19,545 | 20,380 | ||
Property, Plant, and Equipment, net | 918,418 | 1,430,604 | ||
Goodwill | 1,596 | 44,332 | ||
Acquired intangible assets, net | 1,008 | 0 | ||
Other non-current assets | 311,821 | 506,280 | ||
Total Assets | 6,456,930 | 7,790,515 | ||
Liabilities | ||||
Accounts Payable | 986,045 | 944,194 | ||
Accrued Expenses | 636,329 | 675,776 | ||
Deferred Revenue | ||||
Commercial Paper | 312,486 | 340,407 | ||
Current Portion of long-term debt | 1,190,363 | 1,488,400 | ||
Total current liabilities | 2,294,921 | 2,466,526 | ||
Deferred Revenue- noncurrent | ||||
Long-term debt | 1,190,363 | 1,488,400 | ||
Other non-current assets | ||||
Total Liabilities | 5,179,994 | 6,025,580 | ||
Stockholder's equity | ||||
Common Stock | 343,241 | 343,683 | ||
Retained Earnings | 10,225,253 | 10,374,826 | ||
Accumulated other comprehensive income | ||||
Total stockholders' equity | 1,276,936 | 1,764,935 | ||
Total liabilities and stockholder's equity | 6,456,930 | 7,790,515 |
Also, can you help me with this? 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).
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started