Lowes.xlsx

Sheet1

Income Statement
Fiscal year is February-January. All values USD Millions. 2022 2021 2020 2019 2018 5-year trend
Sales/Revenue 96,250 89,597 72,148 71,309 68,619
Sales Growth 7.43% 24.19% 1.18% 3.92% -
Cost of Goods Sold (COGS) incl. D&A 65,856 61,424 50,467 49,878 47,589
COGS excluding D&A 63,457 59,351 48,589 48,271 46,049
Depreciation & Amortization Expense 2,399 2,073 1,878 1,607 1,540
Depreciation 2,367 1,979 1,730 1,477 1,404
Amortization of Intangibles 32 94 148 130 136
COGS Growth 7.22% 21.71% 1.18% 4.81% -
Gross Income 30,394 28,173 21,681 21,431 21,030
Gross Income Growth 7.88% 29.94% 1.17% 1.91% -
Gross Profit Margin 31.58% - - - -
SG&A Expense 18,139 17,291 15,102 15,326 14,444
Other SG&A - 17,291 15,102 15,326 14,444
SGA Growth 4.90% 14.49% -1.46% 6.11% -
EBIT 12,255 10,882 6,579 6,105 -
Unusual Expense 162 2,295 265 2,087 464
Non Operating Income/Expense -38 - - -3 3
Non-Operating Interest Income 12 24 27 28 16
Interest Expense 859 872 718 649 652
Interest Expense Growth -1.49% 21.45% 10.63% -0.46% -
Gross Interest Expense 862 872 719 652 657
Interest Capitalized 3 - 1 3 5
Pretax Income 11,208 7,739 5,623 3,394 5,489
Pretax Income Growth 44.82% 37.63% 65.67% -38.17% -
Pretax Margin 11.64% - - - -
Income Tax 2,766 1,904 1,342 1,080 2,042
Income Tax - Current Domestic 2,626 2,003 1,203 1,237 1,986
Income Tax - Deferred Domestic 140 -99 139 -157 56
Other After Tax Income (Expense) -33 -24 -13 -7 -11
Consolidated Net Income 8,409 5,811 4,268 2,307 3,436
Net Income 8,409 5,811 4,268 2,307 3,436
Net Income Growth 44.71% 36.15% 85.00% -32.86% -
Net Margin 8.74% - - - -
Net Income After Extraordinaries 8,409 5,811 4,268 2,307 3,436
Net Income Available to Common 8,409 5,811 4,268 2,307 3,436
EPS (Basic) 12.03 7.75 5.49 2.84 4.09
EPS (Basic) Growth 55.27% 41.23% 93.17% -30.56% -
Basic Shares Outstanding 696 748 777 811 839
EPS (Diluted) - 7.75 5.49 2.84 4.09
EPS (Diluted) Growth 0.00% 41.24% 93.09% -30.54% -
Diluted Shares Outstanding 699 750 778 812 840
EBITDA 14,654 12,955 8,457 7,712 8,126
EBITDA Growth 13.11% 53.19% 9.66% -5.09% -
EBITDA Margin - - - -
EBIT 12,255 10,882 6,579 6,105 -
Balance Sheet
Assets
Fiscal year is February-January. All values USD Millions. 2022 2021 2020 2019 2018 5-year trend
Cash & Short Term Investments 1,404 5,196 876 729 690
Cash Only 1,133 4,690 716 511 588
Short-Term Investments 271 506 160 218 102
Cash & Short Term Investments Growth -72.98% 493.15% 20.16% 5.65% -
Cash & ST Investments / Total Assets 3.03% 10.76% 2.14% 2.10% 1.96%
Inventories 17,605 16,193 13,179 12,561 11,393
Finished Goods 17,605 16,193 13,179 12,561 11,393
Other Current Assets 1,051 937 1,263 938 689
Miscellaneous Current Assets 1,051 937 1,263 938 689
Total Current Assets 20,060 22,326 15,318 14,228 12,772
Net Property, Plant & Equipment 23,179 22,987 22,560 18,432 19,721
Property, Plant & Equipment - Gross 41,067 40,534 39,836 35,863 36,940
Buildings 18,433 18,090 17,862 18,052 18,521
Land & Improvements 7,278 7,315 7,200 7,196 7,414
Machinery & Equipment 10,533 10,466 10,377 10,090 10,475
Construction in Progress 715 831 506 525 530
Accumulated Depreciation 17,888 17,547 17,276 17,431 17,219
Total Investments and Advances 247 200 372 256 408
Other Long-Term Investments 247 200 372 256 408
Intangible Assets 833 311 562 303 1,307
Net Goodwill 311 311 303 303 1,307
Net Other Intangibles - - 259 - -
Other Assets 157 571 443 995 915
Tangible Other Assets 157 571 443 995 915
Total Assets 46,330 48,290 40,990 34,641 35,291
Assets - Total - Growth -4.06% 17.81% 18.33% -1.84% -
Asset Turnover 2.03 - - - -
Return On Average Assets 17.77% - - - -
Liabilities & Shareholders' Equity
All values USD Millions. 2022 2021 2020 2019 2018 5-year trend
ST Debt & Current Portion LT Debt 1,504 1,653 3,039 1,832 1,431
Short Term Debt - 541 2,442 722 1,137
Current Portion of Long Term Debt 868 1,112 597 1,110 294
Accounts Payable 11,354 10,884 7,659 8,279 6,590
Accounts Payable Growth 4.32% 42.11% -7.49% 25.63% -
Income Tax Payable 128 168 - - -
Other Current Liabilities 6,682 6,025 4,484 4,386 4,075
Dividends Payable 537 440 420 385 340
Accrued Payroll 1,561 1,350 684 662 747
Miscellaneous Current Liabilities 4,584 4,235 3,380 3,339 2,988
Total Current Liabilities 19,668 18,730 15,182 14,497 12,096
Current Ratio 1.02 1.19 1.01 0.98 1.06
Quick Ratio 0.12 0.33 0.14 0.11 0.11
Cash Ratio 0.07 0.28 0.06 0.05 0.06
Long-Term Debt 27,880 24,558 20,711 14,391 15,564
Long-Term Debt excl. Capitalized Leases 23,319 20,104 16,156 13,682 14,718
Non-Convertible Debt 23,319 20,104 16,156 13,682 14,718
Capitalized Lease Obligations 540 564 612 709 846
Deferred Taxes -164 -340 -216 -294 -168
Deferred Taxes - Credit 1,690 1,555 1,519 133 -
Deferred Taxes - Debit 1,854 1,895 1,735 427 168
Other Liabilities 1,908 2,010 1,606 1,976 1,758
Other Liabilities (excl. Deferred Income) 781 991 712 1,149 955
Deferred Income 1,127 1,019 894 827 803
Total Liabilities 51,146 46,853 39,018 30,997 29,418
Total Liabilities / Total Assets 110.39% 97.02% 95.19% 89.48% 83.36%
Common Equity (Total) -4,816 1,437 1,972 3,644 5,873
Common Stock Par/Carry Value 335 366 381 401 415
Additional Paid-In Capital/Capital Surplus - 90 - - 22
Retained Earnings -5,115 1,117 1,727 3,452 5,425
Cumulative Translation Adjustment/Unrealized For. Exch. Gain -41 -37 -115 -209 11
Other Appropriated Reserves 5 -99 -21 - -
Common Equity / Total Assets -10.39% 2.98% 4.81% 10.52% 16.64%
Total Shareholders' Equity -4,816 1,437 1,972 3,644 5,873
Total Shareholders' Equity / Total Assets -10.39% 2.98% 4.81% 10.52% 16.64%
Total Equity -4,816 1,437 1,972 3,644 5,873
Liabilities & Shareholders' Equity 46,330 48,290 40,990 34,641 35,291