This week's module is about financial ratios and your assignment summarizes much of what you should have learned in the module. Please use Excel for question #3, you can answer the first two in Excel as well, just use a new tab. 1. What is and describe the "five question approach" to using financial ratios. (15pts) 2. What is llquidity, and what is the rationale for its measurement? (15pts) 3. The financial statements and industry norms are shown below for Easton, Inc.: (70pts) a. Compute the 7 financial ratios for Easton for 2020 and 2021 and compare against the industry norms (better/worse). (42pts, 6pts per ratio) b. How liquid is the firm? (7pts) c. Are its managers generating an adequate operating profit on the firm's assets? (7pts) d. How is the firm financing its assets? (7pts) e. Are its managers generating a good return on equity? (7pts) 20% of sales are cash sales, with the remaining 80% being credit sales Be sure to do both the calculations AND the comments. Confine both calculations and comments to the seven ratios for which you are responsible. You can use Text Boxes to show your comments. Please be sure to carefully read Part A, it asks you compare both years to the industry norms. Your calculations should be done in Excel and you should use Excel formulas to do your calculations. Spreadsheets are a prerequisite for this course so you should be able to do this. Use help screens if you have forgotten. I must see your work when you calculate each ratio and the Excel formulas are "your work". Note that you will get full credit only if you use the functionality of Excel to the max: if you can use cell references, do that rather than reentering data; use Excel formulas rather than calculating longhand, etc. This week's module is about financial ratios and your assignment summarizes much of what you should have learned in the module. Please use Excel for question #3, you can answer the first two in Excel as well, just use a new tab. 1. What is and describe the "five question approach" to using financial ratios. (15pts) 2. What is llquidity, and what is the rationale for its measurement? (15pts) 3. The financial statements and industry norms are shown below for Easton, Inc.: (70pts) a. Compute the 7 financial ratios for Easton for 2020 and 2021 and compare against the industry norms (better/worse). (42pts, 6pts per ratio) b. How liquid is the firm? (7pts) c. Are its managers generating an adequate operating profit on the firm's assets? (7pts) d. How is the firm financing its assets? (7pts) e. Are its managers generating a good return on equity? (7pts) 20% of sales are cash sales, with the remaining 80% being credit sales Be sure to do both the calculations AND the comments. Confine both calculations and comments to the seven ratios for which you are responsible. You can use Text Boxes to show your comments. Please be sure to carefully read Part A, it asks you compare both years to the industry norms. Your calculations should be done in Excel and you should use Excel formulas to do your calculations. Spreadsheets are a prerequisite for this course so you should be able to do this. Use help screens if you have forgotten. I must see your work when you calculate each ratio and the Excel formulas are "your work". Note that you will get full credit only if you use the functionality of Excel to the max: if you can use cell references, do that rather than reentering data; use Excel formulas rather than calculating longhand, etc