Outcome Alignment
Program Outcome
Course Outcome
- Students will apply best practices to solve managerial issues.
Students will apply corporate financial management concepts
Task Description and Instructions
Overview
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 for 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.