Question: Please show excel formulas See the below table for the Dog Voices Corporation (DVC): a) Pick any three (3) ratios and explain on the strengths

Please show excel formulas
See the below table for the Dog Voices Corporation (DVC): a) Pick any three (3) ratios and explain on the strengths and weaknesses of its performance from 2020 to 2021. Type out the answers in the Excel answer sheet. b) Then, pick any three (3) other ratios, and compare DVC in 2021 to the industry. Ratio Analysis 2021 2020 Industry Avga Liquidity Current ratio 2.33 2.11 2.7 Acid-Test Ratio 0.85 0.69 1.36 Asset Management Inventory turnoverb 5.74 4.47 7.0 Days sales outstanding 41.79 37.94 32 Fixed assets turnover 9.84 11.89 13.0 Total assets turnoverb 1.81 2.18 2.6 Profitability Return on assets 3.00% 4.76% 9.1% Return on equity 12.22% 11.47% 18.2% Profit margin .43% 2.64% 3.5% Debt Management Debt-to-assets ratio 64.81% 49.81% 50.0% Market Value P/E ratio 3.43 6.0 Price/cash flow ratio 1.60 2.16 3.5 a Industry average ratios have been constant for the past 4 years. b Based on year-end balance sheet figures. Calculation is based on a 365-day year. 5.65
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
