A firm has $$21,318$ in outstanding checks that have not cleared the bank. The firm also has $$10,750$ in deposits that have been recorded

by the firm but not by the bank. The current available balance is $$8,407.$ What is the status of the net float?

EXCEL FORMULAS ONLY PLEASE. YOU MUST USE EXCEL FORMULAS TO GET A THUMBS UP$.$ You have determined that your average collection time is $10\mathrm{.}1$ days. It takes your firm $4\mathrm{.}5$ days to prepare and mail out all the monthly

statements to your customers who all pay promptly upon receipt. On average, the mail time between your firm and your customers is $3\mathrm{.}4$ days,

and customer checks take an average of $2$ days to clear the bank. How long, on average, is it taking your firm to process the payments

from customers?