Balance Sheet Analysis \begin{tabular}{|l|r|r|} \hline Total assets turnover & 2.30 & \\ \hline Gross profit margin on sales & 25.00% & \\ \hline Total liabilities-to-assets ratio & 45.00% & \\ \hline Quick ratio & 1.05 & \\ \hline Days sales outstanding & 30.50 & \\ \hline Inventory turnover ratio & 4.00 & \\ \hline Total assets & $400,000 & \\ \hline Long-term debt & 50,000 & \\ \hline Retained earnings & 100,000 & \\ \hline Number of days in year & 365 & \\ \hline & & \\ \hline Financial Statements & & \\ \hline Partial Income: & & Formulas \\ \hline Sales & & \\ \hline Cost of good sold & & #N/A \\ \hline & & #N/A \\ \hline Balance Sheet: & & \\ \hline Cash & & \\ \hline Accounts receivable & & \\ \hline Inventories & & #N/A \\ \hline Fixed assets & & \\ \hline Total assets & & #N/A \\ \hline & & \\ \hline Accounts payable & & \\ \hline Long-term debt & & \\ \hline Common stock & & \\ \hline Retained earnings & & \\ \hline Total liabilities and equity & & \\ \hline & & \\ \hline \hline \end{tabular} Consider the following financial data for J. White Industries: Total assets turnover: 2.3 Gross profit margin on sales: (Sales - Cost of goods sold) / Sales =25% Total liabilities-to-assets ratio: 45% Quick ratio: 1.05 Days sales outstanding (based on 365-day year): 30.5 days Inventory turnover ratio: 4.0 The data has been collected in the Microsoft Excel Online file below. Open Open spreadsheet