Please solve, show work and what funtion to put into Excel. Example, Gross margin percentage $=($F$7/$F$9).$

FIND:

Acid$-$test ratio $($rounded two decimal places$)$

Accounts recievable turnover $($rounded two decimals$)$

Average collection period $($round nearest whole day$)$

Inventory turnover ratio $($rounded two decimals$)$

Average sales period $($rounded to the nearest whole day$)$

Debt$-$to$-$equity ratio $($rounded two decimals$)$

time interest earned $($round two decimals$)$

Book value per share $($round two decimals$)$

Earnings per share $($rounded two decimals$)$

Dividend payout ratio $($rounded three decimals$)$

Dividend yield ratio $($rounded three decimals$)$

price$-$earnings ratio $($rounded two decimal$)$