Best writers. Best papers. Let professionals take care of your academic papers

Order a similar paper and get 15% discount on your first order with us
Use the following coupon "FIRST15"
ORDER NOW

Bank Statements

Each  student  will  prepare  a  10-12  minute  presentation,  summarizing  the  financial  statement
analysis completed on the company that was the focus of the Excel Project.

I have the financials in excel that I can share. The part I need is for you to read the data and answer the question by providing a PowerPoint of the finds. Nothing fancy.

INSTRUCTIONS
Start by preparing a PowerPoint presentation that concisely summarizes the following key areas:

1. INTRODUCTION: A general description of the Company, its products/services, industry,
primary customer base, and major competitors

2. INCOME:  A  discussion  of  the  company’s  primary  sources  of  core  and  comprehensive
income, major sources of non-operating or transitory earnings (if applicable), and quality
of earnings

3. CASH  FLOWS:  A  discussion  of  cash  flow  trends  for  each  of  the  3  major  categories
(operating, investing, financing)

4. RATIO ANALYSIS: Key conclusions drawn from the company’s last 3 years of ratios, as
well as a comparison to industry averages and competitors.  Should include a discussion
for  each  major  category  of  ratios,  including  liquidity,  solvency/leverage,  efficiency,
profitability, and market value.

5. MARKET  VALUATION:  A  consideration  of  any  unrecorded  assets,  as  well  as  the
company’s general market value or stock price trends.

6. STRENGTHS/WEAKNESSES:  Summarize  the  company’s  key  financial  strengths  and
weaknesses, in comparison to its competitors and the industry.

7. FUTURE  PROSPECTS:  Discuss  what  conclusions  you  were  able  to  draw  regarding  the
company’s future prospect from your financial analysis and research.

8. BIBLICAL WORLDVIEW: Evaluate the company’s financial position and organizational
strategy in relation to a Biblical worldview.

  • Company 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#

    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 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#

    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

    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

    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

    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

    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

    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

    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

    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#

    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#

    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/