III-READ ALL INSTRUCTIONS ncial Statement Analysis a. Within this workbook there is a worksheet labeled "Adjusted Trial Balances". Within that worksheet you will find fully completed trial balances for 5 years. Also within this workbook you will find worksheets for comparative income statements and comparative balance sheets. Using the trial balances or comparative financial statements you need to calculate a variety of ratios. You will find the required ratios in the worksheet labeled "Ratios Historical". Complete all the required ratios AND analysis (see Ratios Historical worksheet). You MUST use formulas and/or linking to compute your ratios. You cannot simply hard key the answers. You must reference the appropriate data from the trial balances or comparative financial statements. b. After completing all of your ratio calcualtions, analyze the results in comparison to prior years and industry averages. Write a business memo explaining your findings. Your memo must be writtin in Word and follow normal business memo conventions-use word memo templates for this. There is not a length requirement, however you will be graded upon the substance of your analysis. 0 13 Instructions Adjusted Trial Balances : is comparative BS Comparative Ratios Historical ; O Type here to search 2 III-READ ALL INSTRUCTIONS ncial Statement Analysis a. Within this workbook there is a worksheet labeled "Adjusted Trial Balances". Within that worksheet you will find fully completed trial balances for 5 years. Also within this workbook you will find worksheets for comparative income statements and comparative balance sheets. Using the trial balances or comparative financial statements you need to calculate a variety of ratios. You will find the required ratios in the worksheet labeled "Ratios Historical". Complete all the required ratios AND analysis (see Ratios Historical worksheet). You MUST use formulas and/or linking to compute your ratios. You cannot simply hard key the answers. You must reference the appropriate data from the trial balances or comparative financial statements. b. After completing all of your ratio calcualtions, analyze the results in comparison to prior years and industry averages. Write a business memo explaining your findings. Your memo must be writtin in Word and follow normal business memo conventions-use word memo templates for this. There is not a length requirement, however you will be graded upon the substance of your analysis. 0 13 Instructions Adjusted Trial Balances : is comparative BS Comparative Ratios Historical ; O Type here to search 2