The Case 2 Assignment focuses on the analytical assessment of the firm

The Case 2 Assignment focuses on the analytical assessment of the firm. Download the Case 2 Assignment PDF and the XLS file you need to work on this project.

Analytical assessment within case group:

2. 1. Expected Scenario (All years available):
      1. Construct yearly Income Statement for the project
      2. Identify the yearly operating after-tax cash flows (OCF) for this project
      3. What is the initial investment?
      4. Identify terminal cash flow for this project.
      5. Perform NPV and IRR calculations for this project and provide results of decision rules (label answers clearly in worksheet).
   2. Optimistic Scenario (Year 1 only):
      1. Identify Revenue, Year 1 only
      2. Identify Raw material cost, Year 1 only
      3. Identify initial investment cost, Year 0
   3. Write a summary (200 – 300 words) of your recommendation to the firm’s senior management on whether the firm should (not) invest in this project. Include financial reasons and broader, strategic rationale for your recommendations while incorporating the two scenarios. (Note: I stop reading and grading after the 300th)
   4. Submit Case 2 assignment using excel file, Case 2 template.