Points Possible: 10 In column E, type the formula for each ratio formula. For example, type "Net credit sales/Average A/R." (It's okay to abbreviate.) Then, in column G, use cell references (linking) and Excel formulas to compute the selected risk and profitability ratios for 2022 . The receivables turnover ratio has been completed as an example. Save your file with your name in the file name. Submit on Canvas. Note: When calculating a ratio that uses an average, such as the receivables turnover ratio, you may either use two sets of parentheses or the AVERAGE function. For example, to divide net credit sales by average A/R: ='Given Data'!F7I(('Given Data'!F28+'Given Data'!G28)/2) or ='Given Data'!F7/AVERAGE('Given Data'!F28:G28) Given Data COVINGTON PRODUCTS COMPANY Income Statement For the Year Ended December 31, 2022 \begin{tabular}{lrr} Net [credit] sales & $3,900,000 \\ Cost of goods sold & 2,450,000 \\ Gross profit & 1,450,000 \\ Expenses: & 1,005,000 \\ Operating expenses & 40,000 \\ Depreciation expense & 23,000 \\ Interest expense & 75,000 \\ Income tax expense & 1,143,000 \\ Total expenses & $307,000 \\ Net income & \\ \hline \hline \end{tabular} COVINGTON PRODUCTS COMPANY Balance Sheets December 31, 2022 and 2021 Assets Current Assets: Liabilities and Stockholders' Equity Current Liabilities: Accounts payable Interest payable Income tax payable Total current liabilities Long-Term Liabilities: Notes payable Total Liabilities Stockholders' Equity: Common stock Retained earnings Total stockholders' equity Total Liabilities and Stockholders' Equity