Ratio Analysis Based on the Income Statement and Balance Sheet, complete the table below. Then comment on the liquidity, profitability, leverage, asset management and market value. Analysis of Financial Data (Table with ratios) 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
Ratio Analysis
Based on the Income Statement and
Then comment on the liquidity, profitability, leverage, asset management and market value.
Analysis of Financial Data (Table with ratios)
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 3 steps









