Using the following information from the vertical, horizontal and ratio analysis answering the following questions:

a. What trends are present relating to your company's sales, cost of goods sold, and operating expenses over the period studied?b. What explanations can you identify for the trends you identified in 2(a)?

c. Compare your vertical financial statement analysis in 2021 to 2020. What trends are present relating to your company's vertical financial statement analysis?

d. What explanations can you identify for the trends you identified in 2(c)?

e. What trends are present in your ratio analysis?

f. What explanations can you identify for the trends you identified in 2(e)?

g. Compare your ratio analysis to the retail industry ratios provided on Canvas. How does your company compare to the overall retail industry? What explanations exist for your company's differences?

h. If you had the opportunity to request additional information from your company to inform your analysis, what information would you request from them?

Transcribed Image Text:

Ratio Analysis For years 2021, 2020, and 2019 From Walmart data Ratio Analysis Other Tied calculations 2021 2020 2019 Gross Profit Margin 0.24 0.24 0.24 Gross profit Figure: 2021 $134,918 2020 $125,321 2019 $125,028 Net Profit Margin 0.02 0.03 0.01 Return on Assets 0.05 0.06 0.03 Return on Equity 0.17 0.20 0.09 Long Term Debt/Equity 0.51 0.59 0.60 Debt/Equity 2.04 2.08 1.93 Total Liabilities Figure: $ 164,965.00 $ 154,943.00 $ 139,661.00 Debt/Assets 0.65 0.66 0.64 Current Ratio 0.97 0.79 0.80 Quick Ratio 0.52 0.42 0.37 Quick Asset Figure: $47,855 $32,316 $28,827 Asset Turnover 2.27 2.28 2.41 Average Total Assets Figure: $ 244,495.50 $ 227,895.00 $ 211,908.50 Inventory Turnover Receivables Turnover 9.40 8.90 8.75 86.76 82.74 85.79 Average Inventory Figure: Average Recievable Figure: $ 44,692.00 $ 44,352.00 $ 44,026.00 $ 6,400.00 $ 6,283.50 $ 5,948.50 Ratios TO compare-Retail Industry Level Ratio Data (Median) 2015 2016 2017 2018 2019 2020 2021 Gross Profit Margin 0.34 0.34 0.34 0.34 0.33 0.3 0.35 Net Profit Margin 0.02 0.02 0.02 0.03 0.02 0.02 0.04 Return on Assets 0.15 0.14 0.13 0.13 0.1 0.1 0.14 Return on Equity 0.11 0.1 0.09 0.11 0.1 0.1 0.23 Long Term Debt/Equity 0.31 0.35 0.35 0.39 1 1.12 0.94 Debt/Equity 1.13 1.23 1.31 1.43 1.99 2.25 1.85 Debt/Assets 0.6 0.61 0.61 0.6 0.69 0.72 0.67 Current Ratio 1.61 1.57 1.57 1.61 1.36 1.37 1.46 Quick Ratio 0.68 0.59 0.52 0.49 0.45 0.6 0.72 Asset Turnover 1.97 2 1.94 2 1.54 1.41 1.5 Inventory Turnover 4.71 4.33 4.25 4.33 4.33 4.42 5.25 Receivables Turnover 54.72 55.05 48.42 53.86 48.24 47.52 43.98 Ratio Analysis For years 2021, 2020, and 2019 From Walmart data Ratio Analysis Other Tied calculations 2021 2020 2019 Gross Profit Margin 0.24 0.24 0.24 Gross profit Figure: 2021 $134,918 2020 $125,321 2019 $125,028 Net Profit Margin 0.02 0.03 0.01 Return on Assets 0.05 0.06 0.03 Return on Equity 0.17 0.20 0.09 Long Term Debt/Equity 0.51 0.59 0.60 Debt/Equity 2.04 2.08 1.93 Total Liabilities Figure: $ 164,965.00 $ 154,943.00 $ 139,661.00 Debt/Assets 0.65 0.66 0.64 Current Ratio 0.97 0.79 0.80 Quick Ratio 0.52 0.42 0.37 Quick Asset Figure: $47,855 $32,316 $28,827 Asset Turnover 2.27 2.28 2.41 Average Total Assets Figure: $ 244,495.50 $ 227,895.00 $ 211,908.50 Inventory Turnover Receivables Turnover 9.40 8.90 8.75 86.76 82.74 85.79 Average Inventory Figure: Average Recievable Figure: $ 44,692.00 $ 44,352.00 $ 44,026.00 $ 6,400.00 $ 6,283.50 $ 5,948.50 Ratios TO compare-Retail Industry Level Ratio Data (Median) 2015 2016 2017 2018 2019 2020 2021 Gross Profit Margin 0.34 0.34 0.34 0.34 0.33 0.3 0.35 Net Profit Margin 0.02 0.02 0.02 0.03 0.02 0.02 0.04 Return on Assets 0.15 0.14 0.13 0.13 0.1 0.1 0.14 Return on Equity 0.11 0.1 0.09 0.11 0.1 0.1 0.23 Long Term Debt/Equity 0.31 0.35 0.35 0.39 1 1.12 0.94 Debt/Equity 1.13 1.23 1.31 1.43 1.99 2.25 1.85 Debt/Assets 0.6 0.61 0.61 0.6 0.69 0.72 0.67 Current Ratio 1.61 1.57 1.57 1.61 1.36 1.37 1.46 Quick Ratio 0.68 0.59 0.52 0.49 0.45 0.6 0.72 Asset Turnover 1.97 2 1.94 2 1.54 1.41 1.5 Inventory Turnover 4.71 4.33 4.25 4.33 4.33 4.42 5.25 Receivables Turnover 54.72 55.05 48.42 53.86 48.24 47.52 43.98