Applying Excel 11: Complete the Excel file - AVERAGE and Financial Ratios

In excel, please explain after

• Download and upload the file.
• Read the information on the instructions tab.
• Click on theRatios tab and enter your name in cell C1.
• Each yellow cell requires a formula.
• The AVERAGE function must be used to calculate Accounts receivable turnover, inventory turnover, Total asset turnover, and Return on total assets.

If cell C1 is left blank, y Each yellow cell requires a formula. =A1+84 =A1-84 =Al*B4 =A1/84 Using the AVERAGE function Order of operations PEMDAS P E M A S Using absolute addresses Tapping the F4 button [Absolute Column and Absolute Kow $8$28, Absolute Column and Relative Row $128, Relative Column and Absolute Row B$28)\fRatio Formula Measure of Liquidity and Efficiency Current ratio Current assets = Current liabilities Short-term debt-paying ability Acid-test ratio Cash + Short-term investments + Current receivables Current liabilities Immediate short-term debt-paying abil Accounts receivable turnover Net sales = Average accounts receivable, net Efficiency of collection Cost of goods sold Inventory turnover Efficiency of inventory management Average inventory Days' sales uncollected Accourts receivable, net = X 365 Net sales Liquidity of receivables Days' sales in inventory Ending inventory Cost of goods sold X 365 Liquidity of inventory Total asset turnover Net sales = Average total assets Efficiency of assets in producing sales Solvency Debt ratio = Total liabilities Total assets Creditor financing and leverage Equity ratio Total equity = Total assets Owner financing Debt-to-equity ratio S. Total liabilities Total equity Debt versus equity financing Times interest earned Ircome before interest expense and income taxes = Protection in meeting interest payment Interest expense