Week 1 case study 1

Outcome Alignment

Program Outcome

Course Outcome

Don't use plagiarized sources. Get Your Custom Essay on
Need an answer from similar question? You have just landed to the most confidential, trustful essay writing service to order the paper from.
Just from $11/Page
Order Now
  1. Students will apply best practices to solve managerial issues.

Students will apply corporate financial management concepts

Task Description and Instructions


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.


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.