FINANCIAL STATEMENT ANALYSIS SPREADSHEET PROJECT Project is due April 22 Directions: The purpose of this project is to learn how to analvsis a company using ratios. Open the spreadsheet called Financial Analysis Project Spreadsheet in Week 14 module. There are two tabs in the spreadsheet labeled Walmart Financials and Target Financials. You will place your answers on the word file called Student Template for Answers. That will be the file you submit in the Financial Analysis Drop Box. Calculate the following ratios for both Target and Walmart for 2021 and 2020: Liquidity 1. Current Ratio (current assets / current liabilities) 2. Quick Ratio ((cash + marketable securities + accounts receivable) / current liabilities) Profitability 3. Net Margin (net income / total revenue) 4. Operating margin (operating income / total revenue) 5. Gross Profit (sales - cost of sales) 6. Gross Margin (gross profit / sales) Debit 1. Debt Ratio (total debt (liabilities) / total assets) 2. Debt to equity Ratio (total debt (liabilities) / total equity) Additional Notes 1. Comment on which company has better liquidity, better profitability, and less debt. Comment on whether each company has improved or worsened its liquidity, profitability, and debt.

0 4 if +4 time fine berm derter Lere termi inast obegrtions Defrond incorse tares and ceher roeal Hablhtiet frutty Cersimen storer Cipital in eacets of tar vacue Rotained eamines Recumulated ober comprehendve bos Voncontrolling ihterent Total equity Fetal tlabilities and expilty 0 4 if +4 time fine berm derter Lere termi inast obegrtions Defrond incorse tares and ceher roeal Hablhtiet frutty Cersimen storer Cipital in eacets of tar vacue Rotained eamines Recumulated ober comprehendve bos Voncontrolling ihterent Total equity Fetal tlabilities and expilty