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) BED BATH BEYOND INC AND SUBSIDIARIES Consolidated Balance Sheets (in thousands, except per share data) February 27, 2021 February 29, 2020 $ 1,352,984 1,671,909 595,152 Assets Current assets Cash and cash equivalents Short term investment securities Merchandise inventories Prepaid expenses and other current assets Assets held for sale Total current assets Long term investment securities Property and equipment, net Operating lease assets Other assets Total assets 3,620,045 19,545 918,418 1,587,101 311,821 $ 6,456,930 $ 1,000,340 385,642 2,093,869 248,342 98,092 3,826,285 20,380 1,430,604 2,006,966 506,280 $ 7,790,515

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Jul 15, 2024

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).

BED BATH & BEYOND INC. AND SUBSIDIARIES Consolidated Balance Sheets (in thousands, except per share data) February 27, 2021 February 29, 2020 $ 1,352,984 1,671,909 595,152 Assets Current assets: Cash and cash equivalents Short term investment securities Merchandise inventories Prepaid expenses and other current assets Assets held-for-sale Total current assets Long term investment securities Property and equipment, net Operating lease assets Other assets Total assets 3,620,045 19,545 918,418 1,587,101 311,821 $ 6,456,930 $ 1,000,340 385,642 2,093,869 248,342 98,092 3,826,285 20,380 1,430,604 2,006,966 506,280 $ 7,790,515