Excel Online Structured Activity: Balance Sheet Analysis

Consider the following financial data for J$.$ White Industries:

Total assets turnover: $1\mathrm{.}8$

Gross profit margin on sales: $($Sales $-$ Cost of goods sold$)/$Sales $=25\%$

Total liabilities$-$to$-$assets ratio: $45\%$

Quick ratio: $1\mathrm{.}05$

Days sales outstanding $($based on $365-$day year$)$: $29$ days

Inventory turnover ratio: $4\mathrm{.}0$

The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below.