BUS 5110 Unit 7 Excel Calculation Advanced

Fashion Forward Dream Designs
Profit margin ratio 5.46% 3.94%
Return on Assets 4.92% 4.81%
Current Ratio 1.11 1.40
Quick Ratio 0.98 1.21
AR Turnover Ratio 11.43 16.46
Average Collection
31.94 22.18
Period
Inventory Turnover
12.90 15.66
Ratio
Average Sales Period 28.29 23.30
Debt to Equity Ratio 0.96 0.77

Fashion Forward Dream Designs
Profit margin ratio 10.93%
Return on Assets 11.70%
Current Ratio 1.11
Quick Ratio 0.89
AR Turnover Ratio 10.57
Average Collection
34.53
Period
Inventory Turnover
8.87
Ratio
Average Sales Period 41.14
Debt to Equity Ratio 2.17

21476
46677