Show your answer and formulas in excel
Beginning accounts receivable Ending accounts receivable Beginning assets Ending assets Gross sales Returns and allowances Cost of goods sold 2021 $25,750 $26,800 $24.965 $15.975 $56,100 $3,800 $30.250 2020 2019 $23,500 $19,750 $25,750 $23.500 $26.750 $24.965 $24.965| $26,750 $54,7891 $52.800 $3.200 $3.500 $27.800 $28.750 For each ratio you need to provide the following: Purpose Ratio formula (clearly labeled) Ratio calculated (clearly labeled) Discuss trend Compare with industry numbers You will lose points if any of the five are left off. MAKE SURE YOU PROVIDE THE FORMULA, STATE THE PURPOSE AND DISCUSS WHAT YOUR NUMBERS MEAN. DO NOT JUST SAY . INCREASING OR DECREASING -- WHAT DOES THE TREND MEAN???? Please use the shaded boxes for you answers. If you have a long answer, just keep typing, (15 Points - 3 points each) Provide the following information for the accounts receivable turnover ratio for each year and answer all the questions, Purpose Ratio formula (clearly labeled) The Ratios Round your answers into a reader friendly no more than two decimals. 2021 2020 2019 Industry 2.56 2.45 2.31 Your Company Discuss trend Compare with industry numbers (15 Points - 3 points each) Provide the following information for the total asset turnover ratio for all three years based on numbers above. Purpose Ratio formula (clearly labeled) The Ratios Round your answers into a reader friendly no more than two decimals. 2021 2020 2019 Industry 2.03 2.04 2.03 Your Company Discuss trend Compare with industry numbers Beginning accounts receivable Ending accounts receivable Beginning assets Ending assets Gross sales Returns and allowances Cost of goods sold 2021 $25,750 $26,800 $24.965 $15.975 $56,100 $3,800 $30.250 2020 2019 $23,500 $19,750 $25,750 $23.500 $26.750 $24.965 $24.965| $26,750 $54,7891 $52.800 $3.200 $3.500 $27.800 $28.750 For each ratio you need to provide the following: Purpose Ratio formula (clearly labeled) Ratio calculated (clearly labeled) Discuss trend Compare with industry numbers You will lose points if any of the five are left off. MAKE SURE YOU PROVIDE THE FORMULA, STATE THE PURPOSE AND DISCUSS WHAT YOUR NUMBERS MEAN. DO NOT JUST SAY . INCREASING OR DECREASING -- WHAT DOES THE TREND MEAN???? Please use the shaded boxes for you answers. If you have a long answer, just keep typing, (15 Points - 3 points each) Provide the following information for the accounts receivable turnover ratio for each year and answer all the questions, Purpose Ratio formula (clearly labeled) The Ratios Round your answers into a reader friendly no more than two decimals. 2021 2020 2019 Industry 2.56 2.45 2.31 Your Company Discuss trend Compare with industry numbers (15 Points - 3 points each) Provide the following information for the total asset turnover ratio for all three years based on numbers above. Purpose Ratio formula (clearly labeled) The Ratios Round your answers into a reader friendly no more than two decimals. 2021 2020 2019 Industry 2.03 2.04 2.03 Your Company Discuss trend Compare with industry numbers
