Do common size for balance sheet and show work on excel please.
4 Cash & cash equivalents 5 Receivables 6 Merchandise inventories 7 Prepaid expenses & other current assets 8 Total current assets 9 Land 10 Buildings on ownedland 11 Buildings on leased land & leasehold improve 12 Fixtures & equipment 13 Leased properties under capitalized leases 14 Property & equipment, at cost 15 Less accumulated depreciation & amortization 16 Property & equipment, net 17 Goodwill 18 Other intangible assets, net 19 Other assets 20 Total assets 21 Senior debentures 22 Senior notes 23 Capital lease & current portion of other long-term obligations 24 Short-term debt 25 Merchandise accounts payable 26 Accounts payable 27 Gift cards & customer award certificates 28 Accrued wages & vacation 29 Allowance for future sales returns 30 Current portion of post employment & postretirement benefits 31 Taxes other than income taxes 32 Severance & relocation 33 Lease related liabilities 34 Current portion of workers' compensation & general liability reserves 35 Restructuring accruals, including severance 36 Accrued interest 37 Deferred real estate gains 38 Other accounts payable & accrued liabilities 39 Accounts payable & accrued liabilities 40 Income taxes 41 Deferred income taxes 42 Total current liabilities 43 Senior notes 44 Senior debentures 45 Amortizing debentures 46 Unamortized debt issue costs 47 Unamortized debt discount 48 Premium on acquired debt 49 Capital lease & other long-term obligations 50 Long-term debt 51 Deferred income taxes 52 Other liabilities 53 Common stock 54 Additional paid-in capital 55 Accumulated equity (deficit) 56 Treasury stock 57 Accumulated other comprehensive income (loss) 58 Total Macy's, Inc. shareholders' equity (deficit) 59 Noncontrolling interest 60 Total shareholders' equity 2246000 1109000 1297000 1455000 1162000 424000 558000 522000 363000 400000 5516000 5506000 5399000 5178000 5263000 493000 479000 408000 448000 620000 8679000 7652000 7626000 7444000 7445000 1664000 1629000 1541000 1494000 1454000 5049000 4690000 4212000 4106000 4019000 1819000 16720001545000 1444000 1404000 4828000 4910000 4541000 4204000 4230000 34000 34000 34000 34000 25000 13394000 12935000 11873000 11282000 11132000 5594000 5319000 4856000 4610000 4495000 7800000 7616000 7017000 6672000 6637000 3743000 3897000 3897000 3897000 3908000 496000 514000 498000 488000 478000 743000 897000 813000 880000 726000 21461000 20576000 19851000 19381000 19194000 69000 59000 300000 - 36000 - 577000 - 7000 6000 9000 22000 7000 76000 642000 309000 22000 43000 1693000 1526000 1423000 1590000 1655000 833000 814000i 754000 735000 983000 907000 920000 970000 967000 856000 193000 153000 215000 229000 268000 88000 96000 90000 269000 190000 257000 208000 194000 94000 187000 184000 166000 157000 134000 46000 123000 166000 155000 165000 174000 189000 180000 128000 127000 119000 108000 112000 - 93000 67000 93000 112000 74000 70000 51000 - 340000 65000 24000 284000 390000 281000 270000 228000 3109000 3333000 3563000 3167000 3366000 296000 227000 352000 296000 168000 362000 - - 5536000 5728000 5647000 5075000 5232000 4077000 4000000 4000000 2021000 3509000 2980000 2845000 2437000 3769000 1153000 33000 26000 22000 16000 9000 - -32000 -29000 -25000 -18000 - 18000 16000 16000 13000 -9000 164000 143000 121000 67000 39000 29000 29000 27000 26000 25000 7265000 69950001 6562000 5861000 4708000 1081000 1477000 1443000 1122000 1238000 2201000 21230001877000 1662000 1580000 4000 3000 3000 3000 3000 1048000 621000 617000 676000 652000 7340000 6334000 6088000 7174000 8050000 1942000 1665000 1489000 1456000 1318000 -1072000 -1043000 -896000 -724000 -951000 5378000 42500001 4323000 5673000 6436000 3000 1000 12000 - 4253000 4322000 5661000 6436000 mies 4 Cash & cash equivalents 5 Receivables 6 Merchandise inventories 7 Prepaid expenses & other current assets 8 Total current assets 9 Land 10 Buildings on ownedland 11 Buildings on leased land & leasehold improve 12 Fixtures & equipment 13 Leased properties under capitalized leases 14 Property & equipment, at cost 15 Less accumulated depreciation & amortization 16 Property & equipment, net 17 Goodwill 18 Other intangible assets, net 19 Other assets 20 Total assets 21 Senior debentures 22 Senior notes 23 Capital lease & current portion of other long-term obligations 24 Short-term debt 25 Merchandise accounts payable 26 Accounts payable 27 Gift cards & customer award certificates 28 Accrued wages & vacation 29 Allowance for future sales returns 30 Current portion of post employment & postretirement benefits 31 Taxes other than income taxes 32 Severance & relocation 33 Lease related liabilities 34 Current portion of workers' compensation & general liability reserves 35 Restructuring accruals, including severance 36 Accrued interest 37 Deferred real estate gains 38 Other accounts payable & accrued liabilities 39 Accounts payable & accrued liabilities 40 Income taxes 41 Deferred income taxes 42 Total current liabilities 43 Senior notes 44 Senior debentures 45 Amortizing debentures 46 Unamortized debt issue costs 47 Unamortized debt discount 48 Premium on acquired debt 49 Capital lease & other long-term obligations 50 Long-term debt 51 Deferred income taxes 52 Other liabilities 53 Common stock 54 Additional paid-in capital 55 Accumulated equity (deficit) 56 Treasury stock 57 Accumulated other comprehensive income (loss) 58 Total Macy's, Inc. shareholders' equity (deficit) 59 Noncontrolling interest 60 Total shareholders' equity 2246000 1109000 1297000 1455000 1162000 424000 558000 522000 363000 400000 5516000 5506000 5399000 5178000 5263000 493000 479000 408000 448000 620000 8679000 7652000 7626000 7444000 7445000 1664000 1629000 1541000 1494000 1454000 5049000 4690000 4212000 4106000 4019000 1819000 16720001545000 1444000 1404000 4828000 4910000 4541000 4204000 4230000 34000 34000 34000 34000 25000 13394000 12935000 11873000 11282000 11132000 5594000 5319000 4856000 4610000 4495000 7800000 7616000 7017000 6672000 6637000 3743000 3897000 3897000 3897000 3908000 496000 514000 498000 488000 478000 743000 897000 813000 880000 726000 21461000 20576000 19851000 19381000 19194000 69000 59000 300000 - 36000 - 577000 - 7000 6000 9000 22000 7000 76000 642000 309000 22000 43000 1693000 1526000 1423000 1590000 1655000 833000 814000i 754000 735000 983000 907000 920000 970000 967000 856000 193000 153000 215000 229000 268000 88000 96000 90000 269000 190000 257000 208000 194000 94000 187000 184000 166000 157000 134000 46000 123000 166000 155000 165000 174000 189000 180000 128000 127000 119000 108000 112000 - 93000 67000 93000 112000 74000 70000 51000 - 340000 65000 24000 284000 390000 281000 270000 228000 3109000 3333000 3563000 3167000 3366000 296000 227000 352000 296000 168000 362000 - - 5536000 5728000 5647000 5075000 5232000 4077000 4000000 4000000 2021000 3509000 2980000 2845000 2437000 3769000 1153000 33000 26000 22000 16000 9000 - -32000 -29000 -25000 -18000 - 18000 16000 16000 13000 -9000 164000 143000 121000 67000 39000 29000 29000 27000 26000 25000 7265000 69950001 6562000 5861000 4708000 1081000 1477000 1443000 1122000 1238000 2201000 21230001877000 1662000 1580000 4000 3000 3000 3000 3000 1048000 621000 617000 676000 652000 7340000 6334000 6088000 7174000 8050000 1942000 1665000 1489000 1456000 1318000 -1072000 -1043000 -896000 -724000 -951000 5378000 42500001 4323000 5673000 6436000 3000 1000 12000 - 4253000 4322000 5661000 6436000 mies
