This is a Collaborative Learning Community $($CLC$)$ assignment.

The purpose of this assignment is to evaluate a company's profitability from the perspective of an external stakeholder.

Profitability ratios are used by potential investors to assess a company's productivity and may provide insight into the company's historical net profit margin.

Part $1$: External Stakeholder: Investor Ratios

In the Ratios tab of the FSAR Excel Spreadsheet, complete the Investor Ratios section. Calculate the investor ratios.

Address the following analysis questions in the comments section of each ratio:

Identify what accounts changed for the period and explain how this affected the Financial Analysis calculation.

Explain the account change during the period and what business decisions may have caused the change.

Describe how changes impact the company's performance. just the summary value.

This is on Walmart

$5$ Working Capital$6$ Current Ratio$7$Quick$/$Acid Test Ratio$8$Cash Ratio$9$Short$-$Term Debt or Liquidity RatiosLiquidity Ratios$10$ Times Interested Earned$11$ Fixed Charge CoverageLong$-$Term Solvency or Financial Leverage$12$ Debt Ratio $($Uses total liabilities$)13$ Debt$/$Equity Ratio $($Uses total liabilities$)14$ Debt$/$EBITDA$1715$ Debt Ratio $($Using Interest bearing debt only$)16$ Debt$/$Equity Ratio $($Int bearing debt only$)18$ Inventory TurnoverAsset Utilization or Turnover Ratios$19$ Days Sales in lInventory $($DSI$)20$ Receivables Turnover$2421$ Days Sales Outstanding $($DSO$)22$ Days Payable Outstanding $($DPO$)23$ Cash Conversion CycleProfitability Ratios$25$ Gross Profit Margin $\%26$ Operating Income Margin $\%27$ Net Profit Margin $\%28$ Sales to Fixed Assets$29$ Return on Assets$3330$ Return on Equity$31$ Total Asset Turnover$32$ Sales to Fixed AssetsInvestor Ratios$34$ Degree ofFinancial Leverage$35$ Basic Earnings per Share$36$ Diluted Earnings per Share$37$ Price$/$Earnings Ratio$38$ Dividend PayoutIncome StatementWorkbok StatisticsBRatios$1/31/2021-25780\mathrm{.}970\mathrm{.}490\mathrm{.}193\mathrm{.}040\mathrm{.}651\mathrm{.}881\mathrm{.}961\mathrm{.}891\mathrm{.}899\mathrm{.}3539\mathrm{.}0385\mathrm{.}814\mathrm{.}2510\mathrm{.}0033\mathrm{.}2924\mathrm{.}83\%1\mathrm{.}77\%3\mathrm{.}38\%$not stated$7\mathrm{.}48\%21\mathrm{.}59\%2\mathrm{.}21-0\mathrm{.}256\mathrm{.}686\mathrm{.}919\mathrm{.}820\mathrm{.}45$Sheet$1$ Balance SheetCompany$1/31/2022-63090\mathrm{.}930\mathrm{.}28$Ratios$0\mathrm{.}174\mathrm{.}500\mathrm{.}621\mathrm{.}661441\mathrm{.}891\mathrm{.}897\mathrm{.}5948\mathrm{.}0869\mathrm{.}175\mathrm{.}2844\mathrm{.}0025\mathrm{.}10\%2\mathrm{.}38\%4\mathrm{.}24\%$not stated$9\mathrm{.}92\%26\mathrm{.}43\%2\mathrm{.}340\mathrm{.}078\mathrm{.}708\mathrm{.}669\mathrm{.}361/31/20230\mathrm{.}45-165430\mathrm{.}820\mathrm{.}210\mathrm{.}097\mathrm{.}420\mathrm{.}659\mathrm{.}36$E $13\mathrm{.}271\mathrm{.}901\mathrm{.}870\mathrm{.}450\mathrm{.}468\mathrm{.}2044\mathrm{.}5377\mathrm{.}064\mathrm{.}74$T$36\mathrm{.}0024\mathrm{.}14\%1\mathrm{.}24\%2\mathrm{.}98\%$not stated$7\mathrm{.}50\%21\mathrm{.}72\%2\mathrm{.}510\mathrm{.}286\mathrm{.}706\mathrm{.}6711,140\mathrm{.}52$Comp