+1 (218) 451-4151
glass
pen
clip
papers
heaphones

Week 1 case study 1

Week 1 case study 1

Outcome Alignment

Program Outcome

Course Outcome

  1. 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.