Calculate AFN if HMS ratios equaled industry averages for the following:

Growth rate, operating costs$/$sales$,$ cash$/$sales$,$ receivables$/$sales$,$ inventories$/$sales$,$

FA$/$Sales$,$ and Payables and accruals$/$sales$.($If AFN is negative, a special dividend will

be paid with the excess funds.$)$ Use the values in the data sheet $($posted on Canvas$)$ in

cells F$90$:F$99.$ Copy these values to G$90$:G$99.$ Save the values from cells G$145$:G$160$ to

F$145$:F$160$