Project - Financial 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 three years. Also within this workbook you will find worksheets for comparative income statements and comparative balance sheets. Using the trial balances and 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. 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 and 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 should be writtin in Word and it should follow normal business memo conventions. There is not a length requirement, however you will be graded upon the substance of your analysis.
Attachment:- Assignment File.rar