This is a case study to help you understand the

This is a case study to help you understand the financial statements and learn how to work with financial data in excel. You will use the following scenario:

Jenny Cochran, a graduate of The University of Tennessee with 4 years of experience as an equities analyst, was recently brought in as assistant to the chairman of the board of Computron Industries, a manufacturer of computer components.

During the previous year, Computron had doubled its plant capacity, opened new sales offices outside its home territory, and launched an expensive advertising campaign. Cochran was assigned to evaluate the impact of the changes. She began by gathering financial statements and other data.

Instructions

Download and complete this Excel worksheet Download Download and complete this Excel worksheetfor the case study and submit as an .xlsx or .xls file.

Please use Excel functions to show your answers so that your instructor can see your calculation details for full credit.