The following information was gathered from a company's balance sheet and income statement. \begin{tabular}{|lrr|} \hline & Current & Previous \\ \hline Cash & $60,000 & $50,000 \\ Accounts receivable & $30,000 & $35,000 \\ Inventory & $35,000 & $45,000 \\ Long-term assets & $250,000 & $160,000 \\ \hline Total assets & $375,000 & $290,000 \\ \hline \end{tabular} \begin{tabular}{|lr|} \hline & \multicolumn{1}{l}{ Current } \\ \hline Current liabilities & $50,000 \\ \hline Long-term liabilities & $90,000 \\ \hline Total liabilities & $140,000 \\ \hline Stockholders' equity & $235,000 \\ \hline Total liabilities and equity & $375,000 \\ \hline & \\ \hline & Current \\ \hline Net sales & $360,000 \\ \hline Cost of goods sold & $170,000 \\ \hline Operating expenses & $61,000 \\ Interest expense & $12,000 \\ Income tax expense & $22,000 \\ \hline Net income & $95,000 \\ \hline \end{tabular} \begin{tabular}{|lr|} \hline Stock price & $40.00 \\ Average shares outstanding & 10000 \\ \hline \end{tabular} Required: Use the information above to calculate the financial ratios listed below. After you complete column D, ratio values will auto-populate in column F. (Use cells A2 to C27 from the given information above to complete the question. Note that you are permitted to enter the hardcoded number "2" when calculating averages.) Gross profit ratio: Return on assets: AveragetotalassetsNetincome= Profit margin: NetsalesNetincome= Asset turnover: Net sales NetincomeAveragetotalassets= Averagestockholdersequity= \#DIV/O! Return on equity: times Earnings per share: \begin{tabular}{c|c} Net income & = \\ \cline { 1 - 1 } Average shares oustanding & = \\ Stock price & = \end{tabular} Price-earnings ratio: ** Dividends on preferred stock, if reported, would be subtracted in the numerator