Based on the attached balanced sheet and income statement, Computate the ratios and complete the table below Ratio Analysis 2021 Est. 2020 2019 Industry Average Liquidity Ratios Current Ratio (times) 4.2 Quick Ratio (times) 2.1 Asset Management Ratios Average sales/day 9 Inventory Turnover Ratio (times) 9 Days Sales Outstanding (days) 36 Fixed Assets Turnover Ratio (times) 3 Total Asset Turnover Ratio 1.8 Debt Management Ratios Total Debt to Total Assets (%) 40 Times Interest Earned (times) 6 Debt to Equity Ratio (%) 1 Profitability Ratios Profit Margin on Sales (%) 8 Earning Power (%) 17.2 Return on Total Assets (%) 12 Return on Common Equity (%) 25 Market Value Ratios Price/Earnings Ratio Price/Earnings Ratio (times) 12.5 Price/Cash Flow Ratio (times) 6.8 Market /Book Value Ratio (times) 1.7
Based on the attached balanced sheet and income statement,
Computate the ratios and complete the table below
Ratio Analysis |
2021 Est. |
2020 |
2019 |
Industry Average |
Liquidity Ratios |
|
|
|
|
Current Ratio (times) |
|
|
|
4.2 |
Quick Ratio (times) |
|
|
|
2.1 |
|
|
|
|
|
Asset Management Ratios |
|
|
|
|
Average sales/day |
|
|
|
9 |
Inventory Turnover Ratio (times) |
|
|
|
9 |
Days Sales Outstanding (days) |
|
|
|
36 |
Fixed Assets Turnover Ratio (times) |
|
|
|
3 |
Total Asset Turnover Ratio |
|
|
|
1.8 |
|
|
|
|
|
Debt Management Ratios |
|
|
|
|
Total Debt to Total Assets (%) |
|
|
|
40 |
Times Interest Earned (times) |
|
|
|
6 |
Debt to Equity Ratio (%) |
|
|
|
1 |
|
|
|
|
|
Profitability Ratios |
|
|
|
|
Profit Margin on Sales (%) |
|
|
|
8 |
Earning Power (%) |
|
|
|
17.2 |
|
|
|
|
12 |
|
|
|
|
25 |
|
|
|
|
|
Market Value Ratios Price/Earnings Ratio |
|
|
|
|
Price/Earnings Ratio (times) |
|
|
|
12.5 |
Price/Cash Flow Ratio (times) |
|
|
|
6.8 |
Market /Book Value Ratio (times) |
|
|
|
1.7 |
Step by step
Solved in 4 steps