Learning Goal: I’m working on a finance question and need the explanation and answer to help me learn.

Just need report. Excel part is already done. I will provide completed excel sheet after selecting the tutor

Part A and B are completed. Just do part C

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

C) 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 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. The report should be 4 to 5 pages excluding title and reference page