Case 5.2 Avnet Comprehensive Analysis Case Using the Financial Statement Analysis Template (a) Open the financial statement analysis template that you have been using in the prior chapters. Link to the Ratios" and the "Growth Rate Analysis" by clicking on the tabs at the bottom of the template. All of the ratios should be automati- cally calculated for you, assuming you have input all required data from prior chapters. Print these pages (b) Using all of your data and calculations for Avnet from prior chapters, write a comprehensive analysis of the company, Use the below as a guide for your analysis: 1- Establish objectives of the analysis 2- Study the industry in which the firm operates 3- Assess quality of management of the firm 4- Evalutate financial statements Tools: Common size statements, key financial ratios, trend analysis Major areas: Short term liquidity, operating efficiency, capital structure and long-term solvency, profitability 5- Summarize findings based on analysis and reach conclusions about the firm Relevant to the established objectives Case 5.2 Avnet Comprehensive Analysis Case Using the Financial Statement Analysis Template (a) Open the financial statement analysis template that you have been using in the prior chapters. Link to the Ratios" and the "Growth Rate Analysis" by clicking on the tabs at the bottom of the template. All of the ratios should be automati- cally calculated for you, assuming you have input all required data from prior chapters. Print these pages (b) Using all of your data and calculations for Avnet from prior chapters, write a comprehensive analysis of the company, Use the below as a guide for your analysis: 1- Establish objectives of the analysis 2- Study the industry in which the firm operates 3- Assess quality of management of the firm 4- Evalutate financial statements Tools: Common size statements, key financial ratios, trend analysis Major areas: Short term liquidity, operating efficiency, capital structure and long-term solvency, profitability 5- Summarize findings based on analysis and reach conclusions about the firm Relevant to the established objectives