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

 Please show excel formulas. Thanks 5. See the below table for

Please show excel formulas.

Thanks

5. 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 shee 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 outstandinge 41.79 37.94 32 Fixed assets turnoverb 9.84 11.89 13.0 Total assets turnoverb 1.81 2.18 2.6 Profitability Return on assets 3.00% 4.7696 9.196 Return on equity 12.2296 11.4796 18.2% Profit margin .4396 2.84% 3.596 Debt Management Debt-to-assets ratio 64.8196 49.81% 50.0% Market Value PIE ratio 3.43 5.65 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. c Calculation is based on a 365-day year

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!