Accounting week 3 ( team part 2)

profiledhoskins69
TeamRatios.xlsx

Ratio Summary

Apple Microsoft Oracle Cisco The table should be completed from the individual ratio sheets prepared
by each team member.
Current ratio 1.35266942 2.48 3.083174787 3.0345865207 The completed summary should be copied into the paper so the reader
Current cash debt coverage ratio 0.82 0.16 0.68 0.53 can see the information the team is analyzing to makes its recommendations.
Inventory Turnover Ratio 1.35 3.87 times 147.38 12.55
Receivables Turnover ratio 13.23 1.18 times 7.06 8.73
Debt to Total Assets ratio 60.13% 0.70 59.82% 49.05%
Times Interest Earned Ratio $ 35.77 10.05 times $ (7.35) $ 15.27
Return on Common stockholders' equity ratio 103.71% 7.34% 18.30% 14.81%
Return on Assets ratio 9.79% 2.44% 4.89% 5.04%
Profit Margin Ratio 21.19% 23.57% 24.74% 20.02%
Price Earnings Ratio 18.6 30.59 times 9.87 17.85