compute the following in excel using the information provided: 3 year profit margin ratio, three-year return on asset ratio, three-year return on equity, Three-year counts, receivable, turnover, three year average collection., Three-year, fix asset, turnover, three-year, quick ratio, three years debt to total asset ratio, three year times interest earned, two year growth rate plus EPS, two year growth rate in sales

LAMAR SWIMWEAR Selected Industry Ratios GrowthinsalesProfitmarginReturnonassets(investment)ReturnonequityReceivablesturnoverAveragecollectionperiodInventoryturnoverFixedassetturnoverTotalassetturnoverCurrentratioQuickratioDebttototalassetsTimesinterestearnedFixedchargecoverageGrowhinEPS20X17.71%7.94%14.31%9.02X39.9days4.24X1.60X1.05X1.96X1.37X43.47%6.50X4.70X20X210.00%7.82%8.86%15.26%9.31X4.86X5.10X1.64X1.10X2.25X1.41X43.11%5.99X4.69X20X312.00%7.96%8.95%16.01%38.7days5.11X1.75X1.12X2.40X1.38X44.10%4.73X13.30% LAMAR SWIMWEAR Selected Industry Ratios GrowthinsalesProfitmarginReturnonassets(investment)ReturnonequityReceivablesturnoverAveragecollectionperiodInventoryturnoverFixedassetturnoverTotalassetturnoverCurrentratioQuickratioDebttototalassetsTimesinterestearnedFixedchargecoverageGrowhinEPS20X17.71%7.94%14.31%9.02X39.9days4.24X1.60X1.05X1.96X1.37X43.47%6.50X4.70X20X210.00%7.82%8.86%15.26%9.31X4.86X5.10X1.64X1.10X2.25X1.41X43.11%5.99X4.69X20X312.00%7.96%8.95%16.01%38.7days5.11X1.75X1.12X2.40X1.38X44.10%4.73X13.30%