FINANCE project

PART 1 – COMPUTATIONS IN EXCEL a) Compute the following for each project: i. The change in Net Working Capital (ΔNWC). [] ii. The Free Cash Flows (FCF). [] iii. The Net Present Value (NPV) with and without the terminal value. [] iv. The Internal Rate of Return (IRR). [] v. The Payback Period (PP) and the Discounted Payback Period (DPP). [] vi. The Profitability Index (PI). [] b) Perform sensitivity analysis for each project to gain insights about the impact of using a different discount rate and a different terminal value growth rate on each project’s NPV. This should be based on the different values for these rates provided in the accompanying Excel. [] PART 2 – RECOMMENDATION () Based on the investment analysis you performed write a report with your advice to Emily Harris. To this end, initially summarize the different results obtained, including those from the 2 sensitivity analysis, and discuss and justify your recommendation []. Then, highlight any issues with the analysis that she should be aware of; this should be in terms of the advantages and disadvantages of the different methods employed . Finally, discuss any qualitative considerations that she may wish to factor in her final decision . Remember to include appropriate references and pay attention to the report’s presentation. This should not exceed 2 pages