I need help with what to put in the excel document and the formulas needed for each answer.

Students will calculate 11 commonly reported financial ratios for the year ending January 2021 for Target Corporation and Walmart Inc. After the financial ratios are calculated, students will write 3 paragraphs explaining the financial results and their investment decision. Please continue reading for details. Income Statements and Balance Sheets for Target (TGT) and Walmart (WMT) are included as attachments. You can also find these financial statements on the company's website and the Security and Exchange Commission (SEC) EDGAR website. Target.com - scroll to the bottom, select Investor Relations on the left, select Read the 2020 Annual Report on the left, select 2020 Financials at the top of the page, scroll to the bottom, select 10-K Report on the left, select 10-K Part II at the top, select Item S: Financial Statements and Supplementary Data, Statements of Operations (Income Statement) and Statement of Financial Position (Balance Sheet) Walmart.com - scroll to the bottom, select Our Company, scroll to the bottom again, select Investors, select Annual Reports on the right side, select 2021 Annual Report PDF, scroll down to page 5 and select Item S: Financial Statements and Supplementary Data, pages 54 & 56; Statements of Income and Balance Sheets Security and Exchange Commission (SEC) EDGAR website reports the financial information for all publicly traded companies in the United States. http:/www.sec.cow/edgar/searchedzar/companysearch.html Enter the ticker symbol under "Company and Person Lookup" Ticker symbols: Target is TGT, Walmart is WMT Select 10-K annual reports on the right and select Annual Report for year ending January 30, 2021 Select Item 8: Financial Statements and Supplementary DataUse the following data in addition to the financial statements provided: Statements of Operations is another name for Income Statement Statements of Financial Position is another name for Balance Sheet All numbers on the financial statements are in millions. Use the numbers provided, do not add zeros Target market price per share of $181.17; as of Jan 29, 2021 Walmart market price per share of $140.49; as of Jan 29, 2021 Target weighted average number of outstanding common shares is 500.6 in millions Use the number provided, do not add zeros Walmart weighted average number of outstanding common shares is 2831 in millions Use the number provided, do not add zeros Neither company has issued preferred stock so there aren't any preferred dividends Please note: only common stock appears in the equity section of the balance sheet Both companies have a fiscal year end of January # Use January 31, 2021 for Walmart * Use January 30, 2021 (Statement of Financial Position-Balance Sheet) and 2020 (Statement of Operations-Income Statement) for Target Sales is another term for Revenue. For Target, use Sales. For Walmart, use Net Sales Net Earnings (Target: use 4368) in another term for Net Income (Walmart: consolidated use 13,510) Cost of Sales is another term for Cost of Goods Sold Target includes accounts receivable (AR) in "Other current assets." Use AR balances for year end 2021 as 631 and 2020 as 498 Total Shareholders' Investment (Target) is another term for Total Equity (Walmart) Important: The financial calculations should be completed for 2021 only. Annual reports provide several prior years' information so investors and creditors can spot trends from year to year. You will not use 2018 or 2019 information for any of your calculations. You need 2020 for all ratios that require an overage. For example: (end of year 2020 + end of year 2021) / 2 = average All ratios should include the numerators and denominators in columns F and I, and answers in columns G and J. Do NOT add zeros. Use the numbers provided. Show your work! After your financial analysis is complete in Excel, please answer: Which stock would you buy and why? Write three detailed paragraphs addressing the strengths and weaknesses of each company, as well as your reasons for purchasing Target or Walmart stock. The strengths, weaknesses, and your investment choice should be described in 1.5 to 2 pages typed, 12-point font, double spaced with one-inch margins. Minimum word count is 500, not including a title.Student's Full Name: calculate ratios then highlight with color which ratio Is best. Which company has the best Profit Margin, etc7 ACG2071 Principle of Managerial Accounting In this column, write the components show the numerator and denominator In column: F & !i Ratios for year-end 2021 data that are measured In the ratio. I have Target Walmart Ratio Categories completed three as examples: Profitability Profit Margin Net Income Net Income In each sales dollar Net Sales Profitability Gross Margin Ratio Gross Margin In each sales dollar Profitability Return on Total ABBELE Overall profitability of assets Profitability Return on Equity Profitabliity of owner Investment Profitability Basic Earnings Per Share Net Income - Preferred Dividends, Net Income per common share. of Common Stock (FE) Weighted-Average Common Shares Outstanding Analyzing stock/Market Prospects P/E ratio Market value relative to earnings (Price-gaming3).. Liquidity Current Ratio Ability to pay current llablinle solvency, Debt-to-Equity Ratio Debt versus equity financing. Turnover efficiency Inventory Turnover Cost of SaleE Sirclancy, of Inventory management Average Inventory Turnover efficiency AR Turnover friclency of AR collection (Accounts Receivable). Turnover efficlancy Total Asset Turnover Efficiency of assets In producing sales. 1. Write the ratio components in column D. For Example, Profit Margin is "Net Income / Net Sales" Sales is another term for Revenue For Target, use Sales. For Walmart, use Net Sales 2. Calculate the Financial Ratios for Target and Walmart for Fiscal Year ending January 2021 Write numerators and denominators in columns F & |. and answers in columns G & J SHOW ALL WORK! Round your answers to two decimal places. Follow the answer format in the chapter. For example; $. % or decimal 3. On the worksheet columns G & J. highlight which ratio is the 'best' when comparing the two corporations For most financial ratios, the higher result is better except when debt is in the numerator. Use the following data in addition to the financial statements: Target market price of $181.17 and Walmart market price of $140.49 Target weighted average number of outstanding common shares is 500.6 in millions Walmart weighted average number of outstanding common shares is 2831 in millions All financial numbers are in millions. Use the numbers provided. DO NOT add zeros. 4. Which stock would you purchase? Why? Write three complete paragraphs. addressing the strengths and weaknesses of each company and your reasons for purchasing Target or Walmart stock. Please read instruction page for additional information.FINANCIAL STATEMENTS Consolidated Statements of Financial Position January 30. February 1, (millions, except footnotes) 2021 2020 Assets Cash and cash equivalents 8,511 5 2,577 Inventory 10,653 8,992 Other currant assets 1,592 1,333 Total current assets 20,756 12,902 Proparty and equipment Land 6,141 6,036 Buildings and improvements 31,557 10,603 Fixtures and equipment 5,914 6,043 Computer hardware and software 2,765 2,692 Construction-in-progress 780 533 Accumulated dopreciation (20,278) 19.064) Property and equipment, net 26,879 26,243 Operating lease assets 2,227 2.236 Other noncurrent assets 1,386 1,358 Total assets $ 51,248 5 42.779 Liabilities and shareholders' Investment Accounts payable 12,859 5 9.920 Accrued and other current liabilities 6, 122 4.408 Current portion of long-term debt and other borrowings 1,144 161 Total current liabilities 20, 125 14.487 Long-term debt and other borrowings 11,536 11.338 Noncurrent operating lease liabilities 2,218 2.275 Deferred income taxes 990 1.122 Other noncurrent liabilities 1,939 1,724 Total noncurrent liabilities 16,683 16.459 Shareholders' investment Common stock 42 42 Additional paid-in capital 6,329 6.226 Retained earnings 8,825 6.433 Accumulated other comprehensive loss (756) (868) Total shareholders' investment 14,440 11,833 Total liabilities and shareholders' investment $ 51,248 $ 42,779 Common Stock Authorized 6,000,000,000 shares, $0.0833 par value: 500,877.129 shares issued and outstanding as of January 30, 2021: 504, 198,962 shares issued and outstanding as of February 1, 2020 Preferred Stock Authorized 5,000,000 shares, $0.01 par value; no shares were issued or outstanding during any period presented. See accompanying Notes to Consolidated Financial Statements. TARGET CORPORATION ( 2120 Form N-FINANCIAL STATEMENTS Consolidated Statements of Operations (millions, except per share data) 2020 2019 2018 Sales $ 92,400 5 77,130 5 74,433 Other revenue 1,161 902 923 Total revenue 93,561 78,112 75,356 Cost of sales 66,177 54,864 53,290 Solling, general and administrative expenses 18,615 16,233 15,723 Depreciation and amortization (exclusive of depreciation included in cost of sales] 2,230 2,357 2,224 Operating income 6,539 4,658 4,110 Net interest expense 977 177 461 Not other [income) / expense 16 (27) Earnings from continuing operations before income taxes 5,546 4,190 3,676 Provision for income taxes 1.178 921 746 Net earnings from continuing operations 4,368 3,269 2,930 Discontinued operations, not of tax 12 Net earnings $ 4,368 5 3,281 $ 2,937 Basic earnings per share Continuing operations $ 8.72 5 6.39 5 5.54 Discontinued operations 0.02 0.01 Net earnings per share $ 8.72 5 6.42 5 5.55 Diluted earnings per share Continuing operations 8.64 S 6.34 $ 5.50 Discontinued operations .02 0.01 Net earnings per share 8.64 5 6.36 5 5.51 Weighted average common shares outstanding Basic 500.6 510.9 528.6 Diluted 505.4 515.6 533.2 Antidilutive shares Note: Per share amounts may not foot due to rounding. See accompanying Notes to Consolidated Financial Statements. TARGET CORPORATION (O 2020 Form 10-KWalmart Inc. Consolidated Balance Sheets As of January 31, (Amounts in millions) 2021 2020 ASSETS Current assets: Cash and cash equivalents 17.741 5 9.463 Receivables, net 6516 6.284 Inventories 44.949 44.435 Prepaid expenses and other 20,861 1,622 Total current asset: 90.067 51,306 Property and equipment, net 92.201 105.208 Operating leave right-of-use assets 13.642 17.424 Finance lease right-of-use zaveta, net 4.005 4.417 Goodwill 28.983 31,073 Other long-term ageets 23.59 16,567 Total assets 252.496 5 236.495 LIABILITIES AND EQUITY Current liabilities: Short-term borrowing: 214 5 573 Accounts payable 49.141 46.973 Accrued lizbilities 37.966 22,296 Accrued income taxes 242 280 Long-term debt due within one year 3.115 5,362 Operating lease obligations due within one year 1.466 1,793 Finance lease obligations due within one year 491 511 Total current liabilities 92.645 77.790 Long-term debt 41.194 43.714 Long-term operating lease obligations 12.909 16,171 Long-term finance lease obligations 3.847 4,307 Deferred income taxes and other 14.370 12,961 Commitments and contingencies Equity: Common stock 282 284 Capital in excess of par value 3.646 3.247 Retained earnings 88.76 33,943 Accumulated other comprehensive loss (11,766) (12,805) Total Walmart shareholders' equity 30.925 4,569 Noncontrolling interest 6.606 6,383 Total equity 87.531 31,552 Total liabilities and equity 252,496 236.495Walmart Inc. Consolidated Statements of Income Fiscal Years Ended January 31, "Amounts in millions, except per share data 2021 2010 Revenues: Net sales 555.233 5 519,926 3 510.329 Membership and other income 3.918 1.038 4,076 Total revenues 559.151 523,964 514.405 Costs and expenses: Cost of sales 420.315 394,605 385.301 Operating, selling, general and administrative expenses 116.283 108,791 107.147 Operating income 22.548 20.568 21,957 Interest: Debt 1.976 2,262 1,975 Finance, capital leave and financing obligations 339 337 371 Interest income (121) 189 (217 Interest, net 2.194 2,410 2,129 Other (gains) and loaves (2101 (1,958) 8,368 Income before income taxes 20 564 20.116 11,460 Provision for income taxes 6.858 4,915 4,281 Consolidated net income 13,706 15,201 7.179 Consolidated net income attributable to noncontrolling interest (196) (320) (509 Consolidated net income attributable to Walmart 13.510 14,891 6,670 Net income per common share: Basic net income per common share attributable to Walmart 4.77 5 2 28 Diluted net income per common share attributable to Walmart 4.75 5.19 2 26 Weighted-average common shares outstanding: 2.831 2,850 2,929 Diluted 2.847 2,868 2,945 Dividends declared per common share 2.16 5 212 5 2.08