60.1K
Verified Solution
Link Copied!
can you conduct a time-trend analysis and compare each ratio over the five years ?
Did the liquidity, leverage, asset utilization, and profitability improve or deteriorate over time?
A B D E F G I H I 1 2 Current Ratio 3 Quick Ratio 2016 2017 2018 2019 2020 3.891467848 3.6361686 3.0814478 2.9730566 3.3578486 2.546571458 2.6267095 2.1705674 2.0125976 2.3507768 5 Total Debt Ratio 0.214699979 0.2533519 0.2864027 0.369132 0.353878 5 7 Inventory turnover -2.59570653 -2.852295 -2.713501 -2.519618 -2.29577 3 Recivables Turnover -3.79616576 -3.579827 -3.150945 -3.127212 -2.820795 -0.59024 -0.597782 -0.520812 -0.450426 0 Total Asset turnover -0.62897898 1 2 Profit margin -15.67% 3 Return on asset 10% 4 Return on equity 13% -8.60% - 19.42% 12% 16% 5% -22% 11% 18% -8% 4% 7% 6% 5
Answer & Explanation
Solved by verified expert
