FINANCIAL ANALYSIS PRESENTATION ASSIGNMENT INSTRUCTIONS OVERVIEW
Smith1234mtm
ACT370ExcelProject-ProjectingFinancialStatementMichaelMattox.xlsxCompany Information
| ACCT 370 Excel Project | |||
| Best Buy Co., INC. | |||
| Electronics Shop | |||
| Michael Mattox | |||
| Company Name | Best Buy Company | ||
| Ticker Symbol | BBY | ||
| Industry | Electronics Shop | ||
| Products and Services Offered | Technology Products, Consumer Electronics, Appliances, Entertainment, and Services | ||
| Major Competitors | Multi-channels reatilers, e-commerce business, technology service provider such as: Walmart, Target. | ||
| https://www.sec.gov/cgi-bin/viewer?action=view&cik=764478&accession_number=0000764478-22-000008&xbrl_type=v# | |||
| https://www.sec.gov/cgi-bin/viewer?action=view&cik=764478&accession_number=0000764478-22-000008&xbrl_type=v# | |||
| https://www.sec.report/Document/0000764478-20-000017/ | |||
| https://www.sec.gov/cgi-bin/viewer?action=view&cik=764478&accession_number=0000764478-22-000008&xbrl_type=v# |
Historical Income Statements
| Best Buy Co., INC. | |||
| Consolidated Income Statement | |||
| As of January 29, 2022, January 30, 2021, and February 01, 2020 | |||
| $s in Millions | |||
| Jan. 29, 2022 | Jan. 30, 2021 | Feb. 01, 2020 | |
| Revenue | $ 51,761 | $ 47,262 | $ 43,638 |
| Cost of sales | $ 40,121 | $ 36,689 | $ 33,590 |
| Gross profit | $ 11,640 | $ 10,573 | $ 10,048 |
| Selling, general and admin expenses | $ 8,635 | $ 7,928 | $ 7,998 |
| Restructuring charges | $ (34) | $ 254 | $ 41 |
| Operating income | $ 3,039 | $ 2,391 | $ 2,009 |
| Other income (expense) | |||
| Gain on sale of investements | $ - 0 | $ 1 | $ 1 |
| Investement income and other | $ 10 | $ 37 | $ 47 |
| Interest expense | $ (25) | $ (52) | $ (64) |
| EBIT | $ 3,024 | $ 2,377 | $ 1,993 |
| Income tax expense | $ 574 | $ 579 | $ 452 |
| Equity in income of affiliates | $ 4 | ||
| Net earnings | $ 2,454 | $ 1,798 | $ 1,541 |
| Basic EPS | $ 10 | $ 7 | $ 6 |
| Diluted EPS | $ 10 | $ 7 | $ 6 |
| Weighted-average common shares outstanding | |||
| Basic | $ 247 | $ 260 | $ 265 |
| Diluted | $ 249 | $ 263 | $ 268 |
| https://www.sec.gov/cgi-bin/viewer?action=view&cik=764478&accession_number=0000764478-22-000008&xbrl_type=v# |
Historical Balance Sheets
| Best Buy Co., INC. | |||||
| Consolidated Balance Sheet | |||||
| As of January 29, 2022, January 30, 2021, and January 30, 2020 | |||||
| $s in Millions | |||||
| Jan. 29, 2022 | Jan. 30, 2021 | Feb. 01, 2020 | |||
| Cash and cash equivalents | $ 2,936 | $ 5,494 | $ 2,229 | ||
| Recievables, net | $ 1,042 | $ 1,061 | $ 1,149 | ||
| Merchandise inventories | $ 5,965 | $ 5,612 | $ 5,174 | ||
| Other current assets | $ 596 | $ 373 | $ 305 | ||
| Total current assets | $ 10,539 | $ 12,540 | $ 8,857 | ||
| Land and buildings | $ 671 | $ 658 | $ 650 | ||
| Leasehold improvements | $ 2,160 | $ 2,192 | $ 2,203 | ||
| Fixtures and equipemnt | $ 5,419 | $ 6,333 | $ 6,286 | ||
| Property under finance leases | $ 91 | $ 73 | $ 89 | ||
| Gross property and equipment | $ 8,341 | $ 9,256 | $ 9,228 | ||
| Less accumulated depreciation | $ 6,091 | $ 6,996 | $ 6,900 | ||
| Net property and equipment | $ 2,250 | $ 2,260 | $ 2,328 | ||
| Operating lease assets | $ 2,654 | $ 2,612 | $ 2,709 | ||
| Goodwill | $ 1,384 | $ 986 | $ 984 | ||
| Other Assets | $ 677 | $ 669 | $ 713 | ||
| Total Assets | $ 17,504 | $ 19,067 | $ 15,591 | ||
| Accounts payable | $ 6,803 | $ 6,979 | $ 5,288 | ||
| Accrued compensation and related expenses | $ 845 | $ 725 | $ 410 | ||
| Accrued liabilities | $ 946 | $ 972 | $ 906 | ||
| Short-term debt | $ - 0 | $ 110 | $ - 0 | ||
| Current portion of operating lease liabilities | $ 648 | $ 693 | $ 660 | ||
| Current portion of long-term debt | $ 13 | $ 14 | $ 14 | ||
| Total current liabilities | $ 9,255 | $ 10,521 | $ 7,278 | ||
| Long-term operating lease liabilities | $ 2,061 | $ 2,012 | $ 2,138 | ||
| Long-term liabilities | $ 533 | $ 694 | $ 657 | ||
| Long-term debt | $ 1,216 | $ 1,253 | $ 1,257 | ||
| Preferred Stock $1.00 par value: 400,000 Shares; Issued and outstanding none | |||||
| Common Stock $0.10 par value: 1.0 billion shares; issued and oputstanding 227.4 and 256.9 shares, respectively | $ 23 | $ 26 | $ 26 | ||
| Additional paid-in-capital | $ - 0 | $ - 0 | $ - 0 | ||
| Retained Earnings | $ 2,668 | $ 4,233 | $ 3,158 | ||
| Accumulated other comprehensive income | $ 329 | $ 328 | $ 295 | ||
| Total equity | $ 3,020 | $ 4,587 | $ 3,479 | ||
| Total liabilities and equity | $ 16,085 | $ 19,067 | $ 14,809 | ||
Historical Statement Cash Flows
| Best Buy Co., INC. | |||
| Consolidated Income Statement | |||
| As of January 29, 2022, January 30, 2021, and February 01, 2020 | |||
| $s in Millions | |||
| Jan. 29, 2022 | Jan. 30, 2021 | Feb. 01, 2020 | |
| Net earnings | $ 2,454 | $ 1,798 | $ 1,541 |
| Adjustements | |||
| Depreciation and amortization | $ 869 | $ 839 | $ 812 |
| Restructuring charges | $ (34) | $ 254 | $ 41 |
| Stock-based compensation | $ 141 | $ 135 | $ 143 |
| Deferred income taxes | $ 14 | $ (36) | $ 70 |
| Other, net | $ 11 | $ 3 | $ 21 |
| Changes in operating assets and liabilities | |||
| Receivables | $ 17 | $ 73 | $ (131) |
| Merchandise inventories | $ (328) | $ (435) | $ 237 |
| Other assets | $ (14) | $ (51) | $ 16 |
| Accounts payable | $ (201) | $ 1,676 | $ 47 |
| Income taxes | $ (156) | $ 173 | $ (132) |
| Other liabilities | $ 479 | $ 498 | $ (100) |
| Total cash provided by operating activities | $ 3,252 | $ 4,927 | $ 2,565 |
| Additions to property and equipment, net of $46, $32 and $10, respectively, of non-cash cap.exp. | $ (737) | $ (713) | $ (743) |
| Purchases of investments | $ (233) | $ (620) | $ (330) |
| Sales of investments | $ 66 | $ 546 | $ 322 |
| Acquisitions, net of cash acquired | $ (468) | $ - 0 | $ (145) |
| Other, net | $ - 0 | $ (1) | $ 1 |
| Total cash provided by (used in) investing activities | $ (1,372) | $ (788) | $ (895) |
| Repurchase of common stock | $ (3,502) | $ (312) | $ (1,003) |
| Issuance of common stock | $ 29 | $ 28 | $ 48 |
| Dividends paid | $ (688) | $ (568) | $ (527) |
| Borrowings of debt | $ - 0 | $ 1,892 | $ - 0 |
| Repayments of debt | $ (133) | $ (1,916) | $ (15) |
| Other, net | $ (3) | $ (1) | |
| Total cash used in financing activities | $ (4,297) | $ (876) | $ (1,498) |
| Effect of exchange rate changes on cash and cash equivalents | $ (3) | $ 7 | $ (1) |
| Increase (decrease) in cash, cash eqivalents and restricted cash | $ (2,420) | $ 3,270 | $ 171 |
| Cash, cash equivalents and restricted cash at beginning of period | $ 5,625 | $ 2,355 | $ 2,184 |
| Cash, cash equivalents and restricted cash at end of period | $ 3,205 | $ 5,625 | $ 2,355 |
| $ 716 | $ 442 | $ 514 | |
| Income taxes paid | $ 22 | $ 50 | $ 62 |
| Interest paid | |||
| https://www.sec.gov/ix?doc=/Archives/edgar/data/764478/000076447821000024/bby-20210130x10k.htm |
Target Income Statement
| Target | ||||||||
| Consolidated Income Statement | ||||||||
| As of January 30, 2021, January 30, 2020, and February 01, 2019 | ||||||||
| $s in Millions | ||||||||
| 2021 | 2020 | 2019 | ||||||
| Operating activities | ||||||||
| Sales | $ 104,611.00 | $ 92,400.00 | $ 77,130.00 | |||||
| Other revenue | $ 1,394.00 | $ 1,161.00 | $ 982.00 | |||||
| Total revenue | $ 106,005.00 | $ 93,561.00 | $ 78,112.00 | |||||
| Cost of sales | $ 74,963.00 | $ 66,177.00 | $ 54,864.00 | |||||
| Selling, general and administrative expenses | $ 19,752.00 | $ 18,615.00 | $ 16,233.00 | |||||
| Depreciation and amortization (exclusive of depreciation included in cost of sales) | $ 2,344.00 | $ 2,230.00 | $ 2,357.00 | |||||
| Operating income | $ 8,946.00 | $ 6,539.00 | $ 4,658.00 | |||||
| Net interest expense | $ 421.00 | $ 977.00 | $ 477.00 | |||||
| Net other (income) / expense | $ (382.00) | $ 16.00 | $ (9.00) | |||||
| Earnings from continuing operations before income taxes | $ 8,907.00 | $ 5,546.00 | $ 4,190.00 | |||||
| Provision for income taxes | $ 1,961.00 | $ 1,178.00 | $ 921.00 | |||||
| Net earnings from continuing operations | $ 6,946.00 | $ 4,368.00 | $ 3,269.00 | |||||
| Discontinued operations, net of tax | $ 14.23 | - | $ 12.00 | |||||
| Net earnings | $ 14.10 | $ 4,368.00 | $ 3,281.00 | |||||
| Basic earnings per share | ||||||||
| Continuing operations | $ 14.23 | $ 8.72 | $ 6.39 | |||||
| Discontinued operations | $ - 0 | - | $ 0.02 | |||||
| Net earnings per share | $ - 0 | $ 8.72 | $ 6.41 | |||||
| Diluted earnings per share | ||||||||
| Continuing operations | $ 14.10 | $ 8.64 | $ 6.34 | |||||
| Discontinued operations | $ - 0 | - | $ 0.02 | |||||
| Net earnings per share | $ 14.10 | $ 8.64 | $ 6.36 | |||||
| Weighted average common shares outstanding | $ - 0 | |||||||
| Basic | $ 488.10 | $ 500.60 | $ 510.90 | |||||
| Diluted | $ 492.70 | $ 505.40 | $ 515.60 | |||||
| Antidilutive shares | $ - 0 | - | ||||||
| https://investors.target.com/static-files/3c797291-58c5-48c1-9364-e989ca4a5787 | ||||||||
| https://investors.target.com/static-files/3c797291-58c5-48c1-9364-e989ca4a5787 |
Target Balance Sheet
| Target | ||||||||
| Consolidated Balance Sheet | ||||||||
| As of January 29, 2022, January 30, 2021, and February 01, 2020 | ||||||||
| $s in Millions | ||||||||
| 2021 | 2020 | 2019 | ||||||
| Assets | ||||||||
| Cash and cash equivalents | $ 8,511.00 | $ 2,577.00 | $ 1,556.00 | |||||
| Inventory | $ 10,653.00 | $ 8,992.00 | $ 9,497.00 | |||||
| Other current assets | $ 1,592.00 | $ 1,333.00 | $ 1,466.00 | |||||
| Total current assets | $ 20,756.00 | $ 12,902.00 | $ 12,519.00 | |||||
| Property and equipment | ||||||||
| Land | $ 6,141.00 | $ 6,036.00 | $ 6,064.00 | |||||
| Buildings and improvements | $ 31,557.00 | $ 30,603.00 | $ 2,924.00 | |||||
| Fixtures and equipment | $ 5,914.00 | $ 6,083.00 | $ 5,912.00 | |||||
| Computer hardware and software | $ 2,765.00 | $ 2,692.00 | $ 2,544.00 | |||||
| Construction-in-progress | $ 780.00 | $ 533.00 | $ 460.00 | |||||
| Accumulated depreciation | $ (20,278.00) | $ (19,664.00) | $ (18,687.00) | |||||
| Property and equipment, net | $ 26,879.00 | $ 26,283.00 | $ 25,533.00 | |||||
| Operating lease assets | $ 2,227.00 | $ 2,236.00 | $ 1,965.00 | |||||
| Other noncurrent assets | $ 1,386.00 | $ 1,358.00 | $ 1,273.00 | |||||
| Total assets | $ 51,248.00 | $ 42,779.00 | $ 41,290.00 | |||||
| Liabilities and shareholders' investment | ||||||||
| Accounts payable | $ 6,122.00 | $ 9,920.00 | $ 9,761.00 | |||||
| Accrued and other current liabilities | $ 1,144.00 | $ 4,406.00 | $ 4,201.00 | |||||
| Current portion of long-term debt and other borrowings | $ 7,266.00 | $ 161.00 | $ 1,052.00 | |||||
| Total current liabilities | $ 20,125.00 | $ 14,487.00 | $ 15,014.00 | |||||
| Long-term debt and other borrowings | $ 11,536.00 | $ 11,338.00 | $ 10,223.00 | |||||
| Noncurrent operating lease liabilities | $ 2,218.00 | $ 2,275.00 | $ 2,004.00 | |||||
| Deferred income taxes | $ 990.00 | $ 1,122.00 | $ 972.00 | |||||
| Other noncurrent liabilities | $ 1,939.00 | $ 1,724.00 | $ 1,780.00 | |||||
| Total noncurrent liabilities | $ 16,683.00 | $ 16,459.00 | $ 14,979.00 | |||||
| Shareholders' investment | ||||||||
| Common stock | $ 42.00 | $ 42.00 | $ 43.00 | |||||
| Additional paid-in capital | $ 6,329.00 | $ 6,226.00 | $ 6,042.00 | |||||
| Retained earnings | $ 8,825.00 | $ 6,433.00 | $ 6,017.00 | |||||
| Accumulated other comprehensive loss | $ (756.00) | $ (868.00) | $ (805.00) | |||||
| Total shareholders' investment | $ 14,440.00 | $ 11,833.00 | $ 11,297.00 | |||||
| Total liabilities and shareholders' investment | $ 51,248.00 | $ 42,779.00 | $ 41,290.00 | |||||
| https://investors.target.com/static-files/3c797291-58c5-48c1-9364-e989ca4a5787 |
Target Cash Flows
| Target | ||||||||
| Consolidated Cash Flows | ||||||||
| As of January 29, 2022, January 30, 2021, and February 01, 2020 | ||||||||
| $s in Millions | ||||||||
| 2021 | 2020 | 2019 | ||||||
| Operating activities | ||||||||
| Net earnings | $ 6,946.00 | $ 4,368.00 | $ 3,281.00 | |||||
| Earnings from discontinued operation, net of tax | - | $ 12.00 | ||||||
| Net earnings from continuing operations | $ 6,946.00 | $ 4,368.00 | $ 3,269.00 | |||||
| Adjustments to reconcile net earnings to cash provided by operations: | ||||||||
| Depreciation and amortization | $ 2,642.00 | $ 2,485.00 | $ 2,604.00 | |||||
| Share-based compensation expense | $ 228.00 | $ 200.00 | $ 147.00 | |||||
| Deferred income taxes | $ 522.00 | $ (184.00) | $ 178.00 | |||||
| Loss on debt extinguishment | $ (335.00) | $ 512.00 | $ 10.00 | |||||
| Noncash losses / (gains) and other, net | $ - 0 | $ 86.00 | $ 29.00 | |||||
| Changes in operating accounts: | ||||||||
| Inventory | $ (3,249.00) | $ (1,661.00) | $ 505.00 | |||||
| Other assets | $ (78.00) | $ (137.00) | $ 18.00 | |||||
| Accounts payable | $ 2,628.00 | $ 2,925.00 | $ 140.00 | |||||
| Accrued and other liabilities | $ (746.00) | $ 1,931.00 | $ 199.00 | |||||
| Cash provided by operating activities—continuing operations | $ 8,625.00 | $ 10,525.00 | $ 7,099.00 | |||||
| Cash provided by operating activities—discontinued operations | $ - 0 | - | $ 18.00 | |||||
| Cash provided by operations | $ 8,625.00 | $ 10,525.00 | $ 7,117.00 | |||||
| Investing activities | ||||||||
| Expenditures for property and equipment | $ (3,544.00) | $ (2,649.00) | $ (3,027.00) | |||||
| Proceeds from disposal of property and equipment | $ 27.00 | $ 42.00 | $ 63.00 | |||||
| Other investments | $ 363.00 | $ 16.00 | $ 20.00 | |||||
| Cash required for investing activities | $ (3,154.00) | $ (2,591.00) | $ (2,944.00) | |||||
| Financing activities | ||||||||
| Additions to long-term debt | $ 1,972.00 | $ 2,480.00 | $ 1,739.00 | |||||
| Reductions of long-term debt | $ (1,147.00) | $ (2,415.00) | $ (2,069.00) | |||||
| Dividends paid | $ (1,548.00) | $ (1,343.00) | $ (1,330.00) | |||||
| Repurchase of stock | $ (7,356.00) | $ (745.00) | $ (1,565.00) | |||||
| Stock option exercises | $ 8.00 | $ 23.00 | $ 73.00 | |||||
| Cash required for financing activities | $ (8,071.00) | $ (2,000.00) | $ (3,152.00) | |||||
| Net increase / (decrease) in cash and cash equivalents | $ (2,600.00) | $ 5,934.00 | $ 1,021.00 | |||||
| Cash and cash equivalents at beginning of period | $ 8,511.00 | $ 2,577.00 | $ 1,556.00 | |||||
| Cash and cash equivalents at end of period | $ 5,911.00 | $ 8,511.00 | $ 2,577.00 | |||||
| Supplemental information | ||||||||
| Interest paid, net of capitalized interest | $ - 0 | $ 939.00 | $ 492.00 | |||||
| Income taxes paid | $ - 0 | $ 1,031.00 | $ 696.00 | |||||
| Leased assets obtained in exchange for new finance lease liabilities | $ - 0 | $ 428.00 | $ 379.00 | |||||
| Leased assets obtained in exchange for new operating lease liabilities | $ - 0 | $ 262.00 | $ 464.00 | |||||
| https://corporate.target.com/annual-reports/2020/download/pdf?parts=part6 | ||||||||
| https://investors.target.com/static-files/3c797291-58c5-48c1-9364-e989ca4a5787 |
Walmart INC Income Statement
| Walmart INC | ||||||||
| Consolidated Income Statement | ||||||||
| As of January 31, 2022, January 31, 2021, and January 31, 2020 | ||||||||
| $s in Millions | ||||||||
| 2022 | 2021 | 2020 | ||||||
| Operating activities | ||||||||
| Revenues | ||||||||
| Net Sales | $ 567,762.00 | $ 555,233.00 | $ 519,926.00 | |||||
| Membership and other income | $ 4,992.00 | $ 3,918.00 | $ 4,038.00 | |||||
| Total revenues | $ 572,754.00 | $ 559,151.00 | $ 523,964.00 | |||||
| Costs and expenses | ||||||||
| Cost of sales | $ 429,000.00 | $ 420,315.00 | $ 394,605.00 | |||||
| Operating, selling, general and administrative expenses | $ 117,812.00 | $ 116,288.00 | $ 108,791.00 | |||||
| Operating income | $ 25,942.00 | $ 22,548.00 | $ 20,568.00 | |||||
| Interest: | ||||||||
| Debt | $ 1,674.00 | $ 1,976.00 | $ 2,262.00 | |||||
| Finance lease | $ 320.00 | $ 339.00 | $ 337.00 | |||||
| Interest income | $ (158.00) | $ (121.00) | $ (189.00) | |||||
| Interest, net | $ 1,836.00 | $ 2,194.00 | $ 2,410.00 | |||||
| Loss on extinguishment of debt | $ 2,410.00 | - | - | |||||
| Other (gains) and losses | $ 3,000.00 | $ (210.00) | $ (1,958.00) | |||||
| Income before income taxes | $ 18,696.00 | $ 20,564.00 | $ 20,116.00 | |||||
| Provision for income taxes | $ 4,756.00 | $ 6,858.00 | $ 4,915.00 | |||||
| Consolidated net income | $ 13,940.00 | $ 13,706.00 | $ 15,201.00 | |||||
| Consolidated net income attributable to noncontrolling interest | $ (267.00) | $ (196.00) | $ (320.00) | |||||
| Consolidated net income attributable to Walmart | $ 13,673.00 | $ 13,510.00 | $ 14,881.00 | |||||
| Net income per common share: | ||||||||
| Basic net income per common share attributable to Walmart | $ 4.90 | $ 4.77 | $ 522.00 | |||||
| Diluted net income per common share attributable to Walmart | $ 4.87 | $ 4.75 | $ 5.19 | |||||
| Weighted-average common shares outstanding: | ||||||||
| Basic | $ 2,792.00 | $ 2,831.00 | $ 2,850.00 | |||||
| Diluted | $ 2,805.00 | $ 2,847.00 | $ 2,868.00 | |||||
| Dividends declared per common share | $ 2.20 | $ 2.16 | $ 2.12 | |||||
| https://www.sec.gov/ix?doc=/Archives/edgar/data/104169/000010416921000033/wmt-20210131.htm |
Walmart INC Balance Sheet
| Walmart INC | ||||||||
| Consolidated Balance Sheet | ||||||||
| As of January 31, 2022, January 31, 2021, and January 31, 2020 | ||||||||
| $s in Millions | ||||||||
| 2022 | 2021 | 2020 | ||||||
| ASSETS | ||||||||
| Current assets: | ||||||||
| Cash and cash equivalents | $ 14,760.00 | $ 17,741.00 | $ 9,465.00 | |||||
| Receivables, net | $ 8,280.00 | $ 6,516.00 | $ 6,284.00 | |||||
| Inventories | $ 56,511.00 | $ 44,949.00 | $ 44,435.00 | |||||
| Prepaid expenses and other | $ 1,519.00 | $ 20,861.00 | $ 1,622.00 | |||||
| Total current assets | $ 81,070.00 | $ 90,067.00 | $ 61,806.00 | |||||
| Property and equipment, net | $ 94,515.00 | $ 92,201.00 | $ 105,208.00 | |||||
| Operating lease right-of-use assets | $ 13,758.00 | $ 13,642.00 | $ 17,424.00 | |||||
| Finance lease right-of-use assets, net | $ 4,351.00 | $ 4,005.00 | $ 4,417.00 | |||||
| Goodwill | $ 29,014.00 | $ 28,983.00 | $ 31,073.00 | |||||
| Other long-term assets | $ 22,152.00 | $ 23,598.00 | $ 16,567.00 | |||||
| Total assets | $ 244,860.00 | $ 252,496.00 | $ 236,495.00 | |||||
| LIABILITIES AND EQUITY | ||||||||
| Current liabilities: | - | - | ||||||
| Short-term borrowings | $ 410.00 | $ 224.00 | $ 575.00 | |||||
| Accounts payable | $ 55,261.00 | $ 49,141.00 | $ 46,973.00 | |||||
| Accrued liabilities | $ 26,060.00 | $ 37,966.00 | $ 22,296.00 | |||||
| Accrued income taxes | $ 851.00 | $ 242.00 | $ 280.00 | |||||
| Long-term debt due within one year | $ 2,803.00 | $ 3,115.00 | $ 5,362.00 | |||||
| Operating lease obligations due within one yea | $ 1,483.00 | $ 1,466.00 | $ 1,793.00 | |||||
| Finance lease obligations due within one year | $ 511.00 | $ 491.00 | $ 511.00 | |||||
| Total current liabilities | $ 87,379.00 | $ 92,645.00 | $ 77,790.00 | |||||
| Long-term debt | $ 34,864.00 | $ 41,194.00 | $ 43,714.00 | |||||
| Long-term operating lease obligations | $ 13,009.00 | $ 12,909.00 | $ 16,171.00 | |||||
| Long-term finance lease obligations | $ 4,243.00 | $ 3,847.00 | $ 4,307.00 | |||||
| Deferred income taxes and othe | $ 13,474.00 | $ 14,370.00 | $ 12,961.00 | |||||
| Commitments and contingencies | $ - 0 | $ - 0 | $ - 0 | |||||
| Equity: | ||||||||
| Common stock | $ 276.00 | $ 282.00 | $ 284.00 | |||||
| Capital in excess of par value | $ 4,839.00 | $ 3,646.00 | $ 3,247.00 | |||||
| Retained earnings | $ 86,904.00 | $ 88,763.00 | $ 83,943.00 | |||||
| Accumulated other comprehensive loss | $ (8,766.00) | $ (11,766.00) | $ (12,805.00) | |||||
| Total Walmart shareholders' equity | $ 83,253.00 | $ 80,925.00 | $ 74,669.00 | |||||
| Noncontrolling interes | $ 8,638.00 | $ 6,606.00 | $ 6,883.00 | |||||
| Total equity | $ 91,891.00 | $ 87,531.00 | $ 81,552.00 | |||||
| Total liabilities and equity | $ 244,860.00 | $ 252,496.00 | $ 236,495.00 | |||||
| https://www.sec.gov/ix?doc=/Archives/edgar/data/104169/000010416921000033/wmt-20210131.htm |
Walmart INC Cash Flows
| Walmart INC. | ||||||||
| Consolidated Cash Flows | ||||||||
| As of January 31, 2022, January 31, 2021, and January 31, 2020 | ||||||||
| $s in Millions | ||||||||
| 2022 | 2021 | 2020 | ||||||
| Cash flows from operating activities: | ||||||||
| Consolidated net income | $ 13,940.00 | $ 13,706.00 | $ 15,201.00 | |||||
| Adjustments to reconcile consolidated net income to net cash provided by operating activities: | ||||||||
| Depreciation and amortization | $ 10,658.00 | $ 11,152.00 | $ 10,987.00 | |||||
| Net unrealized and realized (gains) and losses | $ 2,440.00 | $ (8,589.00) | $ (1,886.00) | |||||
| Losses on disposal of business operations | $ 433.00 | $ 8,401.00 | $ 15.00 | |||||
| Asda pension contribution | $ - 0 | $ - 0 | $ (1,036.00) | |||||
| Deferred income taxes | $ (755.00) | $ 1,911.00 | $ 320.00 | |||||
| Loss on debt extinguishment | $ 2,410.00 | $ - 0 | $ - 0 | |||||
| Other operating activities | $ 1,652.00 | $ 1,521.00 | $ 1,981.00 | |||||
| Changes in certain assets and liabilities, net of effects of acquisitions and dispositions | ||||||||
| Receivables, net | $ (1,796.00) | $ (1,086.00) | $ 154.00 | |||||
| Inventories | $ (11,764.00) | $ (2,395.00) | $ (300.00) | |||||
| Accounts payable | $ 5,520.00 | $ 6,966.00 | $ (274.00) | |||||
| Accrued liabilities | $ 1,404.00 | $ 4,623.00 | $ 186.00 | |||||
| Accrued income taxes | $ 39.00 | $ (136.00) | $ (93.00) | |||||
| Net cash provided by operating activities | $ 24,181.00 | $ 36,074.00 | $ 25,255.00 | |||||
| Cash flows from investing activities: | ||||||||
| Payments for property and equipment | $ (13,106.00) | $ (10,264.00) | $ (10,705.00) | |||||
| Proceeds from the disposal of property and equipment | $ 394.00 | $ 215.00 | $ 321.00 | |||||
| Proceeds from disposal of certain operations, net of divested cash | $ 7,935.00 | $ 56.00 | $ 833.00 | |||||
| Payments for business acquisitions, net of cash acquired | $ (359.00) | $ (180.00) | $ (56.00) | |||||
| Other investing activities | $ (879.00) | $ 102.00 | $ 479.00 | |||||
| Net cash used in investing activities | $ (6,015.00) | $ (10,071.00) | $ (9,128.00) | |||||
| Cash flows from financing activities: | ||||||||
| Net change in short-term borrowings | $ 193.00 | $ (324.00) | $ (4,656.00) | |||||
| Proceeds from issuance of long-term debt | $ 6,945.00 | $ - 0 | $ 5,492.00 | |||||
| Repayments of long-term debt | $ (13,010.00) | $ (5,382.00) | $ (1,907.00) | |||||
| Premiums paid to extinguish debt | $ (2,317.00) | $ - 0 | $ - 0 | |||||
| Dividends paid | $ (6,152.00) | $ (6,116.00) | $ (6,048.00) | |||||
| Purchase of Company stock | $ (9,787.00) | $ (2,625.00) | $ (5,717.00) | |||||
| Dividends paid to noncontrolling interes | $ (424.00) | $ (434.00) | $ (555.00) | |||||
| Sale of subsidiar stock | $ 3,239.00 | $ 140.00 | $ 52.00 | |||||
| Other financing activities | $ (1,515.00) | $ (1,376.00) | $ (960.00) | |||||
| Net cash used in financing activities | $ (22,828.00) | $ (16,117.00) | $ (14,299.00) | |||||
| Effect of exchange rates on cash, cash equivalents and restricted cash | $ (140.00) | $ 235.00 | $ (69.00) | |||||
| Net increase (decrease) in cash, cash equivalents and restricted cash | $ (4,802.00) | $ 10,121.00 | $ 1,759.00 | |||||
| Change in cash and cash equivalents reclassified from (to) assets held for sale | $ 1,848.00 | $ (1,848.00) | $ - 0 | |||||
| Cash, cash equivalents and restricted cash at beginning of year | $ 17,788.00 | $ 9,515.00 | $ 7,756.00 | |||||
| Cash, cash equivalent and restricted cash at end of year | $ 14,834.00 | $ 17,788.00 | $ 9,515.00 | |||||
| Supplemental disclosure of cash flow information: | ||||||||
| Income taxes paid | $ 5,918.00 | $ 5,271.00 | $ 3,616.00 | |||||
| Interest paid | $ 2,237.00 | $ 2,216.00 | $ 2,464.00 | |||||
| https://www.sec.gov/ix?doc=/Archives/edgar/data/104169/000010416921000033/wmt-20210131.htm |
Historical and Competitor Ratio
| Best Buy Co., Inc. | |||||||
| Historical Ratios | Competitor Ratio Analysis | ||||||
| for the years ended January 29, 2022,, 2021, 2020 | |||||||
| 2022 | 2021 | 2020 | Target | Walmart | *Industry Average | ||
| Liquidity | |||||||
| Current ratio | 1.14 | 1.19 | 1.22 | 10.70 | 0.93 | 1.32 | |
| Quick ratio | 0.43 | 0.62 | 0.43 | 0.50 | 0.28 | 0.60 | |
| Leverage Ratios | |||||||
| Debt to Total Assets Ratio | 0.53 | 0.55 | 66.00 | 0.39 | 0.36 | 0.73 | |
| Debt to Equity Ratio | 0.30 | 0.29 | 0.40 | 1.39 | 0.95 | 1.07 | |
| Long-Term Debt to Equity | 0.63 | 0.96 | 0.44 | 0.80 | 0.38 | 0.00 | |
| Times Interest Earned Ratio | -120.96 | -45.71 | 2.20 | 2.00 | 10.18 | 1.94 | |
| Activity Ratios | |||||||
| Inventory turnover | 3.45 | 3.47 | 9.30 | 7.04 | 7.59 | 32.90% | |
| Fixed Assets Turnover | 17.12 | 1.33 | 0.90 | -5.16 | 6.01 | 24.00% | |
| Total Assets Turnover | 1611.70 | 31.21 | 0.60 | 2961.65 | 160.00 | 14.00% | |
| Accounts Receivable Turnover | 1.29 | 0.11 | 9.90 | 9.82 | 4.00 | 10.00% | |
| Average Collection Period | 129.54 | 70.49 | 37.30 | 1.25 | 0.00 | 61.00% | |
| Profitability Ratios | |||||||
| Gross Profit Margin | 22.49% | 22.37% | 23.03% | 98.67% | 2.40% | 1.50% | |
| Operating Profit Margin | 70.99% | 71.18% | 70.09% | 98.67% | 99.12% | 7.82% | |
| Net Profit Margin | 0.02% | 25.02% | 333.00% | 0.01% | 2.46% | 3.32% | |
| Return on Total Assets (ROA) | 0.00% | 770.00% | 0.03% | 15.90% | -0.10% | ||
| Return on Shareholder’s Equity (ROE) | 81.26% | 39.20% | 745.90% | 0.10% | 15.17% | 3.21% | |
| Earnings Per Share (EPS) | 106.70 | 0.04% | 600.00% | 0.00 | 50.51 | 9.84 | |
| Price Earnings Ratio | 0.09 | 18819.38 | 10.50 | 0.00 | 26.17 | 9.18 | |
| *Industry average was from Ready ratios report | |||||||
| https://www.readyratios.com/sec/industry/G/ | |||||||
Common Sized Balance Sheet
| Best Buy Co., INC. | |||||
| Common Sized Balance Sheets | |||||
| As of January 29, 2022, January 30, 2021, and January 30, 2020 | |||||
| $s in Millions | |||||
| Jan. 29, 2022 | Jan. 30, 2021 | Feb. 01, 2020 | |||
| Cash and cash equivalents | 17% | 29% | 14% | ||
| Recievables, net | 6% | 6% | 7% | ||
| Merchandise inventories | 34% | 29% | 33% | ||
| Other current assets | 3% | 2% | 2% | ||
| Total current assets | 60% | 66% | 57% | ||
| Land and buildings | 31% | 33% | 40% | ||
| Leasehold improvements | 12% | 11% | 14% | ||
| Fixtures and equipemnt | 31% | 33% | 40% | ||
| Property under finance leases | 1% | 0% | 1% | ||
| Gross property and equipment | 48% | 49% | 59% | ||
| Less accumulated depreciation | 35% | 37% | 44% | ||
| Net property and equipment | 13% | 12% | 15% | ||
| Operating lease assets | 15% | 14% | 17% | ||
| Goodwill | 8% | 5% | 6% | ||
| Other Assets | 4% | 4% | 5% | ||
| Total Assets | 257% | 264% | 299% | ||
| Accounts payable | 39% | 37% | 34% | ||
| Accrued compensation and related expenses | 5% | 4% | 3% | ||
| Accrued liabilities | 5% | 5% | 6% | ||
| Short-term debt | 0% | 1% | 0% | ||
| Current portion of operating lease liabilities | 4% | 4% | 4% | ||
| Current portion of long-term debt | 0% | 0% | 0% | ||
| Total current liabilities | 53% | 50% | 47% | ||
| Long-term operating lease liabilities | 12% | 11% | 14% | ||
| Long-term liabilities | 3% | 4% | 4% | ||
| Long-term debt | 7% | 7% | 8% | ||
| Preferred Stock $1.00 par value: 400,000 Shares; Issued and outstanding none | |||||
| Common Stock $0.10 par value: 1.0 billion shares; issued and oputstanding 227.4 and 256.9 shares, respectively | 0% | 0% | 0% | ||
| Additional paid-in-capital | 0% | 0% | 0% | ||
| Retained Earnings | 15% | 22% | 20% | ||
| Accumulated other comprehensive income | 2% | 2% | 2% | ||
| Total equity | 17% | 24% | 22% | ||
Common Sized Income Statement
| Best Buy Co., INC. | |||
| Common Sized Income Statement | |||
| As of January 29, 2022, January 30, 2021, and February 01, 2020 | |||
| $s in Millions | |||
| Jan. 29, 2022 | Jan. 30, 2021 | Feb. 01, 2020 | |
| Revenue | 100% | 100% | 100% |
| Cost of sales | 78% | 78% | 77% |
| Gross profit | 22% | 22% | 23% |
| Selling, general and admin expenses | 17% | 17% | 18% |
| Restructuring charges | -0% | 1% | 0% |
| Operating income | 6% | 5% | 5% |
| Other income (expense) | |||
| Gain on sale of investements | 0% | 0% | 0% |
| Investement income and other | 0% | 0% | 0% |
| Interest expense | -0% | -0% | -0% |
| EBIT | 6% | 5% | 5% |
| Income tax expense | 1% | 1% | 1% |
| Equity in income of affiliates | 0% | 0% | 0% |
| Net earnings | 5% | 4% | 4% |
| Basic EPS | 0% | 0% | 0% |
| Diluted EPS | 0% | 0% | 0% |
| Weighted-average common shares outstanding | |||
| Basic | 0% | 1% | 1% |
| Diluted | 0% | 1% | 1% |
| https://www.sec.gov/cgi-bin/viewer?action=view&cik=764478&accession_number=0000764478-22-000008&xbrl_type=v# |
Horizontal Analysis Balance She
| Best Buy Co., INC. | |||||||||
| Horizontal Analysis Balance Sheet | |||||||||
| As of January 29, 2022, January 30, 2021, and January 30, 2020 | |||||||||
| $s in Millions | |||||||||
| Jan. 29, 2022 | $ Change | % Change | Jan. 30, 2021 | $ Change | % Change | Feb. 01, 2020 | |||
| Cash and cash equivalents | $ 2,936 | $ (8,430) | -153% | $ 5,494 | $ 3,265 | 146% | $ 2,229 | ||
| Recievables, net | $ 1,042 | $ (2,103) | -198% | $ 1,061 | $ (88) | -8% | $ 1,149 | ||
| Merchandise inventories | $ 5,965 | $ (11,577) | -206% | $ 5,612 | $ 438 | 8% | $ 5,174 | ||
| Other current assets | $ 596 | $ (969) | -260% | $ 373 | $ 68 | 22% | $ 305 | ||
| Total current assets | $ 10,539 | $ (23,079) | -184% | $ 12,540 | $ 3,683 | 42% | $ 8,857 | ||
| Land and buildings | $ 671 | $ (1,329) | -202% | $ 658 | $ 8 | 1% | $ 650 | ||
| Leasehold improvements | $ 2,160 | $ (4,352) | -199% | $ 2,192 | $ (11) | -0% | $ 2,203 | ||
| Fixtures and equipemnt | $ 5,419 | $ (11,752) | -186% | $ 6,333 | $ 47 | 1% | $ 6,286 | ||
| Property under finance leases | $ 91 | $ (164) | -225% | $ 73 | $ (16) | -18% | $ 89 | ||
| Gross property and equipment | $ 8,341 | $ (17,597) | -190% | $ 9,256 | $ 28 | 0% | $ 9,228 | ||
| Less accumulated depreciation | $ 6,091 | $ (13,087) | -187% | $ 6,996 | $ 96 | 1% | $ 6,900 | ||
| Net property and equipment | $ 2,250 | $ (4,510) | -200% | $ 2,260 | $ (68) | -3% | $ 2,328 | ||
| Operating lease assets | $ 2,654 | $ (5,266) | -202% | $ 2,612 | $ (97) | -4% | $ 2,709 | ||
| Goodwill | $ 1,384 | $ (2,370) | -240% | $ 986 | $ 2 | 0% | $ 984 | ||
| Other Assets | $ 677 | $ (1,346) | -201% | $ 669 | $ (44) | -6% | $ 713 | ||
| Total Assets | $ 17,504 | $ (36,571) | -192% | $ 19,067 | $ 3,476 | 22% | $ 15,591 | ||
| Accounts payable | $ 6,803 | $ (13,782) | -197% | $ 6,979 | $ 1,691 | 32% | $ 5,288 | ||
| Accrued compensation and related expenses | $ 845 | $ (1,570) | -217% | $ 725 | $ 315 | 77% | $ 410 | ||
| Accrued liabilities | $ 946 | $ (1,918) | -197% | $ 972 | $ 66 | 7% | $ 906 | ||
| Short-term debt | $ - 0 | $ (110) | -100% | $ 110 | $ 110 | 0% | $ - 0 | ||
| Current portion of operating lease liabilities | $ 648 | $ (1,341) | -194% | $ 693 | $ 33 | 5% | $ 660 | ||
| Current portion of long-term debt | $ 13 | $ (27) | -193% | $ 14 | $ - 0 | 0% | $ 14 | ||
| Total current liabilities | $ 9,255 | $ (19,776) | -188% | $ 10,521 | $ 3,243 | 45% | $ 7,278 | ||
| Long-term operating lease liabilities | $ 2,061 | $ (4,073) | -202% | $ 2,012 | $ (126) | -6% | $ 2,138 | ||
| Long-term liabilities | $ 533 | $ (1,227) | -177% | $ 694 | $ 37 | 6% | $ 657 | ||
| Long-term debt | $ 1,216 | $ (2,469) | -197% | $ 1,253 | $ (4) | -0% | $ 1,257 | ||
| Preferred Stock $1.00 par value: 400,000 Shares; Issued and outstanding none | $ - 0 | 0% | $ - 0 | 0% | |||||
| Common Stock $0.10 par value: 1.0 billion shares; issued and oputstanding 227.4 and 256.9 shares, respectively | $ 23 | $ (49) | -188% | $ 26 | $ - 0 | 0% | $ 26 | ||
| Additional paid-in-capital | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | ||
| Retained Earnings | $ 2,668 | $ (6,901) | -163% | $ 4,233 | $ 1,075 | 34% | $ 3,158 | ||
| Accumulated other comprehensive income | $ 329 | $ (657) | -200% | $ 328 | $ 33 | 11% | $ 295 | ||
| Total equity | $ 3,020 | $ (7,607) | -166% | $ 4,587 | $ 1,108 | 32% | $ 3,479 | ||
| Total loabilities and equity | $ 16,085 | $ (35,152) | -184% | $ 19,067 | $ 4,258 | 29% | $ 14,809 | ||
Horizontal Analysis of Income S
| Best Buy Co., INC. | |||||||
| Horizontal Analysis Income Statement | |||||||
| As of January 29, 2022, January 30, 2021, and February 01, 2020 | |||||||
| $s in Millions | |||||||
| Jan. 29, 2022 | $ Change | % Change | Jan. 30, 2021 | $ Change | % Change | Feb. 01, 2020 | |
| Revenue | $ 51,761 | $ 4,499 | 10% | $ 47,262 | $ 3,624 | 8% | $ 43,638 |
| Cost of sales | $ 40,121 | $ 3,432 | 9% | $ 36,689 | $ 3,099 | 9% | $ 33,590 |
| Gross profit | $ 11,640 | $ 1,067 | 10% | $ 10,573 | $ 525 | 5% | $ 10,048 |
| Selling, general and admin expenses | $ 8,635 | $ 707 | 9% | $ 7,928 | $ (70) | -1% | $ 7,998 |
| Restructuring charges | $ (34) | $ (288) | -113% | $ 254 | $ 213 | 520% | $ 41 |
| Operating income | $ 3,039 | $ 648 | 27% | $ 2,391 | $ 382 | 19% | $ 2,009 |
| Other income (expense) | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 |
| Gain on sale of investements | $ - 0 | $ (1) | -100% | $ 1 | $ - 0 | 0% | $ 1 |
| Investement income and other | $ 10 | $ (27) | -73% | $ 37 | $ (10) | -21% | $ 47 |
| Interest expense | $ (25) | $ 27 | -52% | $ (52) | $ 12 | -19% | $ (64) |
| EBIT | $ 3,024 | $ 647 | 27% | $ 2,377 | $ 384 | 19% | $ 1,993 |
| Income tax expense | $ 574 | $ (5) | -1% | $ 579 | $ 127 | 28% | $ 452 |
| Equity in income of affiliates | $ 4 | $ 4 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 |
| Net earnings | $ 2,454 | $ 656 | 36% | $ 1,798 | $ 257 | 17% | $ 1,541 |
| Basic EPS | $ 10 | $ 3 | 43% | $ 7 | $ 1 | 19% | $ 6 |
| Diluted EPS | $ 10 | $ 3 | 44% | $ 7 | $ 1 | 19% | $ 6 |
| Weighted-average common shares outstanding | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | |
| Basic | $ 247 | $ (13) | -5% | $ 260 | $ (5) | -2% | $ 265 |
| Diluted | $ 249 | $ (14) | -5% | $ 263 | $ (5) | -2% | $ 268 |
| https://www.sec.gov/cgi-bin/viewer?action=view&cik=764478&accession_number=0000764478-22-000008&xbrl_type=v# |
Projected Income Statement
| Best Buy Co., INC. | |||
| Projected Income Statement | |||
| As of January 29, 2025, January 30, 2024, and February 01, 2023 | |||
| $s in Millions | |||
| Jan. 29, 2022 | Jan. 30, 2021 | Feb. 01, 2020 | |
| Revenue | $ 51,761 | $ 47,262 | $ 43,638 |
| Cost of sales | $ 40,121 | $ 36,689 | $ 33,590 |
| Gross profit | $ 11,640 | $ 10,573 | $ 10,048 |
| Selling, general and admin expenses | $ 8,635 | $ 7,928 | $ 7,998 |
| Restructuring charges | $ (34) | $ 254 | $ 41 |
| Operating income | $ 3,039 | $ 2,391 | $ 2,009 |
| Other income (expense) | |||
| Gain on sale of investements | $ - 0 | $ 1 | $ 1 |
| Investement income and other | $ 10 | $ 37 | $ 47 |
| Interest expense | $ (25) | $ (52) | $ (64) |
| EBIT | $ 3,024 | $ 2,377 | $ 1,993 |
| Income tax expense | $ 574 | $ 579 | $ 452 |
| Equity in income of affiliates | $ 4 | ||
| Net earnings | $ 2,454 | $ 1,798 | $ 1,541 |
| Basic EPS | $ 10 | $ 7 | $ 6 |
| Diluted EPS | $ 10 | $ 7 | $ 6 |
| Weighted-average common shares outstanding | |||
| Basic | $ 247 | $ 260 | $ 265 |
| Diluted | $ 249 | $ 263 | $ 268 |
Projected Balance Sheet
| Best Buy Co., INC. | |||||||
| Projected Balance Sheet | |||||||
| As of January 29, 2025, January 30, 2024, and February 01, 2023 | |||||||
| $s in Millions | |||||||
| Jan. 29, 2025 | Jan. 30, 2024 | Feb. 01, 2023 | 2022 | Percentage Increase | |||
| Cash and cash equivalents | $ 3,248 | $ 3,140 | $ 3,036 | $ 2,936 | 3.42% | ||
| Recievables, net | $ 1,153 | $ 1,114 | $ 1,078 | $ 1,042 | |||
| Merchandise inventories | $ 6,598 | $ 6,380 | $ 6,169 | $ 5,965 | |||
| Other current assets | $ 659 | $ 637 | $ 616 | $ 596 | |||
| Total current assets | $ 11,658 | $ 11,272 | $ 10,899 | $ 10,539 | |||
| Land and buildings | $ 742 | $ 718 | $ 694 | $ 671 | |||
| Leasehold improvements | $ 2,389 | $ 2,310 | $ 2,234 | $ 2,160 | |||
| Fixtures and equipemnt | $ 5,994 | $ 5,796 | $ 5,604 | $ 5,419 | |||
| Property under finance leases | $ 101 | $ 97 | $ 94 | $ 91 | |||
| Gross property and equipment | $ 9,226 | $ 8,921 | $ 8,626 | $ 8,341 | |||
| Less accumulated depreciation | $ 6,738 | $ 6,515 | $ 6,299 | $ 6,091 | |||
| Net property and equipment | $ 2,489 | $ 2,407 | $ 2,327 | $ 2,250 | |||
| Operating lease assets | $ 2,936 | $ 2,839 | $ 2,745 | $ 2,654 | |||
| Goodwill | $ 1,531 | $ 1,480 | $ 1,431 | $ 1,384 | |||
| Other Assets | $ 749 | $ 724 | $ 700 | $ 677 | |||
| Total Assets | $ 19,362 | $ 18,722 | $ 18,103 | $ 17,504 | |||
| Accounts payable | $ 7,525 | $ 7,276 | $ 7,036 | $ 6,803 | |||
| Accrued compensation and related expenses | $ 935 | $ 904 | $ 874 | $ 845 | |||
| Accrued liabilities | $ 1,046 | $ 1,012 | $ 978 | $ 946 | |||
| Short-term debt | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Current portion of operating lease liabilities | $ 717 | $ 693 | $ 670 | $ 648 | |||
| Current portion of long-term debt | $ 14 | $ 14 | $ 13 | $ 13 | |||
| Total current liabilities | $ 10,237 | $ 9,899 | $ 9,572 | $ 9,255 | |||
| Long-term operating lease liabilities | $ 2,280 | $ 2,204 | $ 2,131 | $ 2,061 | |||
| Long-term liabilities | $ 590 | $ 570 | $ 551 | $ 533 | |||
| Long-term debt | $ 1,345 | $ 1,301 | $ 1,258 | $ 1,216 | |||
| Preferred Stock $1.00 par value: 400,000 Shares; Issued and outstanding none | $ - 0 | $ - 0 | $ - 0 | ||||
| Common Stock $0.10 par value: 1.0 billion shares; issued and oputstanding 227.4 and 256.9 shares, respectively | $ 25 | $ 25 | $ 24 | $ 23 | |||
| Additional paid-in-capital | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Retained Earnings | $ 2,951 | $ 2,854 | $ 2,759 | $ 2,668 | |||
| Accumulated other comprehensive income | $ 364 | $ 352 | $ 340 | $ 329 | |||
| Total equity | $ 3,341 | $ 3,230 | $ 3,123 | $ 3,020 | |||
| Total liabilities and equity | $ 17,792 | $ 17,204 | $ 16,635 | $ 16,085 | |||
| Reference | |||||||
| https://www.marketscreener.com/quote/stock/BEST-BUY-CO-INC-11778/financials/ |
Assumption Business will grow 2022-2025 at a percentage rate of 3.42 % According to Best Buy Investor Update They are expected to grow to be in three areas. 1. Technology is a necessity 2. Building an ecosystem of customer-centric assets 3. On-going investment in expanding their present in Health Care
Best Buy. (2022, March 3). A recap of Best Buy's 2022 Investor Update. Best Buy Corporate. Retrieved April 9, 2022, from https://corporate.bestbuy.com/recap-of-best-buys-2022-investor-update/
https://www.marketscreener.com/quote/stock/BEST-BUY-CO-INC-11778/financials/Projected Cash Flows
| Best Buy Co., INC. | |||||
| Projected Cash Flow | |||||
| As of January 29, 2025, January 30, 2024, and February 01, 2023 | |||||
| $s in Millions | |||||
| Jan. 29, 2025 | Jan. 30, 2024 | Feb. 01, 2023 | 2022 | Percentage Increase | |
| Net earnings | $ 2,713 | $ 2,624 | $ 2,537 | $ 2,454 | 3.40% |
| Adjustements | $ - 0 | $ - 0 | $ - 0 | ||
| Depreciation and amortization | $ 961 | $ 929 | $ 899 | $ 869 | |
| Restructuring charges | $ (38) | $ (36) | $ (35) | $ (34) | |
| Stock-based compensation | $ 156 | $ 151 | $ 146 | $ 141 | |
| Deferred income taxes | $ 15 | $ 15 | $ 14 | $ 14 | |
| Other, net | $ 12 | $ 12 | $ 11 | $ 11 | |
| Changes in operating assets and liabilities | $ - 0 | $ - 0 | $ - 0 | ||
| Receivables | $ 19 | $ 18 | $ 18 | $ 17 | |
| Merchandise inventories | $ (363) | $ (351) | $ (339) | $ (328) | |
| Other assets | $ (15) | $ (15) | $ (14) | $ (14) | |
| Accounts payable | $ (222) | $ (215) | $ (208) | $ (201) | |
| Income taxes | $ (172) | $ (167) | $ (161) | $ (156) | |
| Other liabilities | $ 530 | $ 512 | $ 495 | $ 479 | |
| Total cash provided by operating activities | $ 3,595 | $ 3,477 | $ 3,363 | $ 3,252 | |
| Additions to property and equipment, net of $46, $32 and $10, respectively, of non-cash cap.exp. | $ (815) | $ (788) | $ (762) | $ (737) | |
| Purchases of investments | $ (258) | $ (249) | $ (241) | $ (233) | |
| Sales of investments | $ 73 | $ 71 | $ 68 | $ 66 | |
| Acquisitions, net of cash acquired | $ (517) | $ (500) | $ (484) | $ (468) | |
| Other, net | $ - 0 | $ 1 | $ 1 | $ - 0 | |
| Total cash provided by (used in) investing activities | $ (1,517) | $ (1,466) | $ (1,418) | $ (1,372) | |
| Repurchase of common stock | $ (3,871) | $ (3,744) | $ (3,621) | $ (3,502) | |
| Issuance of common stock | $ 32 | $ 31 | $ 30 | $ 29 | |
| Dividends paid | $ (761) | $ (736) | $ (711) | $ (688) | |
| Borrowings of debt | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Repayments of debt | $ (147) | $ (142) | $ (138) | $ (133) | |
| Other, net | $ (3) | $ (3) | $ (3) | $ (3) | |
| Total cash used in financing activities | $ (4,750) | $ (4,594) | $ (4,443) | $ (4,297) | |
| Effect of exchange rate changes on cash and cash equivalents | $ (3) | $ (3) | $ (3) | $ (3) | |
| Increase (decrease) in cash, cash eqivalents and restricted cash | $ (2,675) | $ (2,587) | $ (2,502) | $ (2,420) | |
| Cash, cash equivalents and restricted cash at beginning of period | $ 6,218 | $ 6,014 | $ 5,816 | $ 5,625 | |
| Cash, cash equivalents and restricted cash at end of period | $ 3,543 | $ 3,427 | $ 3,314 | $ 3,205 | |
| $ 792 | $ 766 | $ 740 | $ 716 | ||
| Income taxes paid | $ 24 | $ 24 | $ 23 | $ 22 | |
| Interest paid | |||||
| https://www.marketscreener.com/quote/stock/BEST-BUY-CO-INC-11778/financials/ |
Assumptions: Cash Flow will grow every year over three year span 3.40 %. THis is based upon Market ScreenerAssumptions:
https://www.marketscreener.com/quote/stock/BEST-BUY-CO-INC-11778/financials/
