Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
Macy's Inc logo

Macy's Inc

Sector: Consumer Cyclical   

Industry: Department Stores

18.35
 
USD
  
-0.38
  
(-2.03%)
Optionable: Yes  Market Cap: 5,217 M  90-day average vol: 7,583,043

Previous close: 18.73  Open: 18.45  Bid: 18.39  Ask: 18.4
52 week range    
10.54   
   22.10
Peers   
KSS / 
DDS / 
TGT / 
JWN / 
Last updated: Friday 26th April 2024
53
MarketXLS Rank
85
Value
23
Technical
52
Quality

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
Search for a stock

🎉 Exciting news! 🎉

You are invited to join our Discord Channel.

Interact, learn, and grow with experts in the markets!

Join our Discord

Financials

M Balance Sheet

Annual
Jan-14Jan-15Jan-16Jan-17Jan-18Jan-19Jan-20Jan-21Jan-22Jan-23
"""debtc"""463 M76 M642 M309 M22 M43 M539 M452 M
Accounts payable1,691 M1,594 M1,526 M1,423 M1,590 M1,655 M1,682 M1,978 M2,222 M2,053 M
Accrued expenses4,863 M4,578 M5,086 M5,338 M5,157 M5,189 M5,211 M4,905 M5,416 M4,861 M
Accumulated depreciation & depletion-6,066 M-5,594 M-5,319 M-4,856 M-4,610 M-4,495 M-4,392 M-4,400 M-4,548 M-4,633 M
Additional paid in capital2,522 M1,048 M621 M617 M676 M652 M621 M571 M517 M467 M
Cash and equivalents2,273 M2,246 M1,109 M1,297 M1,455 M1,162 M685 M1,679 M1,712 M862 M
CashCashEquivalentsAndShortTermInvestments2,273 M2,246 M1,109 M1,297 M1,455 M1,162 M685 M1,679 M1,712 M862 M
CashEquivalents2,273 M2,246 M1,109 M1,297 M1,455 M1,162 M685 M1,679 M
Common par4 M4 M3 M3 M3 M3 M3 M3 M3 M3 M
Common stock equity6,249 M5,378 M4,250 M4,323 M5,745 M6,436 M6,377 M2,553 M3,621 M4,082 M
CommonStock4 M4 M3 M3 M3 M3 M3 M3 M3 M3 M
Cost in excess3,743 M3,743 M3,897 M3,897 M3,897 M3,908 M3,908 M828 M828 M828 M
CurrentAccruedExpenses3,448 M2,927 M3,086 M2,750 M
CurrentCapitalLeaseObligation282 M260 M306 M321 M327 M325 M331 M198 M328 M333 M
CurrentDeferredRevenue906 M856 M839 M616 M481 M399 M
CurrentDeferredTaxesAssets1,071 M1,281 M1,289 M1,313 M664 M669 M1,411 M1,390 M1,261 M1,215 M
CurrentDeferredTaxesLiabilities400 M1,443 M1,477 M1,443 M1,148 M1,238 M1,169 M908 M-2,244 M-2,162 M
Deferred revenues400 M362 M
DividendsPayable-421 M-456 M468 M470 M-90 M-173 M
EmployeeBenefits72 M64 M
Finished goods5,557 M5,417 M5,506 M5,399 M5,178 M
Float term debt6,714 M7,233 M6,995 M6,562 M5,861 M4,708 M3,621 M4,407 M3,295 M2,996 M
GoodwillAndOtherIntangibleAssets4,270 M4,239 M4,411 M4,395 M4,385 M4,386 M4,347 M1,265 M1,263 M1,260 M
Gross fixed assets (Plant Property & Equipment)13,996 M13,394 M12,935 M11,873 M11,282 M11,132 M11,025 M10,340 M10,213 M10,546 M
IncomeTaxPayable362 M296 M227 M352 M296 M168 M81 M108 M58 M
Intangibles527 M496 M514 M498 M488 M478 M439 M437 M435 M432 M
InterestPayable390 M395 M363 M367 M321 M261 M205 M284 M256 M175 M
Inventories5,557 M5,417 M5,506 M5,399 M5,178 M5,263 M5,188 M3,774 M4,383 M4,267 M
Invested capital12,963 M12,611 M11,245 M10,885 M11,606 M11,144 M10,565 M8,999 M10,211 M10,074 M
Land & improvements1,696 M1,664 M1,629 M1,541 M1,494 M1,454 M1,436 M1,390 M1,353 M
Leases43 M34 M34 M34 M34 M25 M10 M9 M
LineOfCredit1,500 M1,500 M1000000.01,500 M1,500 M1,500 M
LongTermCapitalLeaseObligation30 M29 M29 M27 M26 M25 M2,897 M3,166 M3,081 M6,832 M
LongTermDebtAndCapitalLeaseObligation6,714 M7,233 M6,995 M6,562 M5,861 M4,708 M3,621 M4,407 M3,295 M2,996 M
Machinery furniture & equipment4,811 M4,828 M4,910 M4,541 M4,204 M4,230 M4,402 M4,032 M3,922 M
Minority interest3 M-1000000.0-12 M
Net fixed assets (net PP&E)7,930 M7,800 M7,616 M7,017 M6,672 M6,637 M6,633 M5,940 M5,665 M5,913 M
Non-current deferred income taxes1,273 M1,443 M1,477 M1,443 M1,148 M1,238 M1,169 M908 M983 M947 M
NonCurrentDeferredLiabilities1,273 M1,443 M1,477 M1,443 M1,148 M1,238 M1,169 M908 M983 M947 M
NonCurrentDeferredTaxesAssets289 M305 M340 M379 M218 M222 M165 M104 M100 M112 M
Number of employees94570.094570.094570.094570.094570.094570.094570.094570.094570.094570.0
Other current assets189 M-1,480 M178 M167 M140 M149 M133 M113 M102 M80 M
Other equity adjustments-665 M-1,072 M-1,043 M-896 M-724 M-951 M-995 M-788 M
Other fixed assets5,665 M5,913 M
Other non-current assets732 M711 M897 M813 M880 M726 M714 M1,439 M1,096 M1,157 M
Other non-current liabilities1,658 M3,320 M2,123 M1,877 M1,662 M1,580 M4,255 M4,481 M4,275 M1,017 M
Other receivable438 M424 M558 M522 M363 M400 M409 M276 M297 M300 M
OtherCurrentBorrowings463 M76 M642 M309 M22 M43 M539 M452 M
OtherCurrentLiabilities85 M-64 M112 M96 M291 M269 M213 M2,800 M3,200 M2,963 M
OtherInventories4,383 M4,267 M
OtherPayable2,810 M3,109 M3,333 M3,563 M3,271 M3,366 M3,448 M387 M378 M
Payables4,863 M4,578 M5,086 M5,338 M5,157 M5,189 M1,763 M1,978 M2,330 M2,111 M
Preferred securities of subsidiary trust125 M125 M125 M125 M125 M125 M125 M125 M
PreferredStock125 M125 M125 M125 M125 M125 M125 M125 M
Prepaid expenses420 M493 M479 M408 M650 M620 M528 M455 M366 M424 M
Properties13 M8 M53 M147 M24 M24 M129 M95 M
Retained earnings6,235 M7,340 M6,334 M6,088 M7,246 M8,050 M7,989 M3,928 M4,646 M5,650 M
Short term debt463 M76 M642 M309 M22 M43 M539 M452 M
Total assets21,634 M21,461 M20,576 M19,851 M19,583 M19,194 M21,172 M17,706 M17,590 M16,866 M
Total current assets8,688 M8,679 M7,652 M7,626 M7,646 M7,445 M6,810 M6,184 M6,758 M5,853 M
Total current liabilities5,726 M5,536 M5,728 M5,647 M5,179 M5,232 M5,750 M5,357 M5,416 M4,861 M
Total equity6,249 M5,378 M4,250 M4,323 M5,745 M6,436 M6,377 M2,553 M3,621 M4,082 M
Total liabilities15,371 M16,658 M16,323 M15,529 M13,850 M12,758 M14,795 M15,153 M13,969 M12,784 M
Total non-current assets12,932 M12,750 M12,924 M12,225 M11,937 M11,749 M14,362 M11,522 M10,832 M11,013 M
Total non-current liabilities9,645 M12,068 M10,595 M9,882 M8,671 M7,526 M9,045 M9,796 M8,553 M4,960 M
TotalEquityGrossMinority6,249 M5,378 M4,253 M4,322 M5,733 M6,436 M6,377 M2,553 M3,621 M4,082 M
TotalEquityGrossMinorityInterest6,249 M5,378 M4,253 M4,322 M5,733 M6,436 M6,377 M2,553 M3,621 M4,082 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest21,634 M21,461 M20,576 M19,851 M19,583 M19,194 M21,172 M17,706 M17,590 M16,866 M
TotalNonCurrentLiabilitiesNetMinorityInteres9,645 M12,068 M10,595 M9,882 M8,671 M7,526 M9,045 M9,796 M8,553 M4,960 M
TotalTaxPayable362 M296 M227 M352 M296 M168 M81 M108 M58 M
Treasury stock-1,847 M-3,843 M-1,665 M-1,489 M-1,456 M-1,318 M-1,241 M-1,161 M-1,545 M-2,038 M
UnearnedIncome2,668 M2,878 M2,808 M2,683 M
UnearnedPremiums20 M77 M-22 M-28 M
Working capital2,962 M3,143 M1,924 M1,979 M2,467 M2,213 M1,060 M827 M1,342 M992 M
ltinv75 M97 M132 M112 M117 M101 M132 M100 M39 M35 M
Call: 1-877-778-8358
Ankur Mohan MarketXLS
Welcome! I'm Ankur, the founder and CEO of MarketXLS. With more than ten years of experience, I have assisted over 2,500 customers in developing personalized investment research strategies and monitoring systems using Excel.

I invite you to book a demo with me or my team to save time, enhance your investment research, and streamline your workflows.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and templates.

MarketXLS is a complete Excel stock solution

Kevin Hsu

StockKevin.com

I have used lots of stock and option information services. This is the only one which gives me what I need inside Excel

Lloyd Lenase

Option Day Trader

MarketXLS is a data junkie’s dream. It gives me the flexibility to mine for hidden treasures.

Dave

Swing trader since 2011

I like to access historical closing prices on a particular date. That makes tracking performance easy.

Patrick Cusatis, Ph.D., CFA

Associate Professor of Finance - Penn State University