We are working on ratio's, I have formulas built in for ratios, I have attached the 2023 BKE Financial Data and their 10-K Filing. We need to fill in the information that is missing in the tan/yellow boxes. The information should be available from either the 10-K or financial data.

Complete Tab 3, The ratio analysis for the company calculating the ratios for 2023 - only. Competitor ratios have been provided for you._ _ Enter the numbers for the forumla in column C, the formula has been provided and will calculate for you in Col. D. (in milions of U.S. dollars) for the Year Ended toriconts! Analysis 20 23.22 22:21 21:20 20 29 Cast of sales Basic LeS Weighted Average Shares Outstanding an s Cash and a Short Term investments Long Term leaves Other assets other assets TOTAL ASSETS errued operating expens bursent portion of of Op lease Babilities Income Taxes Payable deferred Compens Long term waylon Lease TOTAL LIABILITIES EQUITY Preferred Stock TOTAL EQUITY LITIES AND EQUITY CASH FLOW STATEMENT Cash flows from operating activits Depreciation and amortization ferred Income Taxes errved Store Expenses come Taxes Payable Capital Expenditures ale of Assets raceeds sale of 1 Please explain the formulas and how it was calculated in the form below: Ratio Formula enter numbers here Buckle American Eagle Outfitter 2023 Liquidity and E Working Capital Current assets - current liabilities 423,336 197,293 $ $54,053 $ 26,043 Current Ratio Current assets 423,336 1.87 times 1.66 times current liablities 226,043 Acid-test ratio (Cash + Short-term investments + Current receivables) #DIV/O! times 0.86 times Current liabilities Cash Ratio cash + short term investments #DIV/OI times 5.01 times current liabilitys Management Accounts receivable turnover net sales #DIV/O! times 17.41 times Average accounts receivable, net Days' sales uncollected 365 #DIV/O! days 20.97 days Acct Receivable Turn Inventory turnover Cost of goods sold #DIV/O! times 5.86 times Average Inventory Days' sales in inventory 365 #DIV/O! days 62.26 days Inventory Turn Total asset turnover Net Sales #DIV/O! times 1.32 times Average Total Assets Fixed Asset Turnover Net Sales "DIV/O! time 2.09 times Average Fixed Assets Solvenc Debt ratio Total Liabilitys #DIV/O! 0.22 Total Assets Return on Equity Total Equuity #DIV/OI 0.38 Total Assets Debt-to-equity ratio Total Liabilities #DIV/O! times 1.66 times Total Equity Times interest earned Net Income before interest expense and income taxes (operating income) #DIV/OI times 3.41 times Interest expense Profitability Profit margin ratio Net Income WDIV/0! 2.51% % Net Sales Gross profit ratio = Net sales - Cost of goods sold #DIV/O! 13.95 % Net sales Return on total assets = Net income #DIV/O! 3.30% % Average total assets Return on common stockholders' equity = Net income - Preferred dividends #DIV/O! 8.79% % Average common stockholders' equity Book value per common share - Shareholders' equity applicable to common shares #DIV/O! 721.219 Number of common shares outstanding Basic earnings per share = Net income- Preferred dividends #DIV/O! 0.09 S Weighted-average common shares outstanding Market Prospects Price-earnings ratio Market price per common share #DIV/O! times 144.03 times Earnings per share Dividend yield Annual cash dividends per share #DIV/O! per shar 0.03 Market price per share Dividend payout Ratio Total Annual Dividends #DIV/O! 76% % net income Helpful Notes Average = (year 1 + year 2)/2 enter dividends as positive Skip times interest earned if you cannot find interest expense image.png image.pngE