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
Just need report. Excel part is already done. I will provide completed excel she
By admin