Calculate the Discounted Cash Flows (DCF) for 10-years and derive the Net Present Value using the uncertain input variables.

Discounted Cash Flow Modelling and Sensitivity and Risk Analysis

For the purpose of this coursework, you are required to do the following:

1. Calculate the Discounted Cash Flows (DCF) for 10-years and derive the Net Present Value using the uncertain input variables. (5 Marks)

2. Perform a single simulation of 10,000 iterations for the NPV model and determine the probability of getting a negative (zero) NPV at 95% Confidence Interval (2 Marks)

3. Perform sensitivity analysis for the NPV output to determine the variable with the largest impact on NPV (Biggest Driver of NPV) using the following:

a) Change in Output. (2 Marks)

b) Regression Coefficient. (2 Marks)

c) Correlation Coefficient. (2 Marks)

2

d) Contribution to Variance. (2 Marks)

Total (15 Marks)

Write a Report to your COO to communicate the findings from your analyses. The report should describe the purpose and result of your analyses