How does changing the weighted average cost of capital influence results?Does the company have any control over its WACC?

Download the following Excel file with the information to complete the case study:

Using the information above, please answer the following questions:

Capital Budgeting

1) Create a sensitivity analysis, a scenario analysis or a Monte Carlo Simulation for the capital budgeting project. Plot the results. What do you notice?
2) Is wealth being generated by the company with this project over a period of 5 years (Hint: calculate the NPV using equal cash flows for years 1 – 4 (same sales and costs for 4 years) and adjusting the final cash flow with the change in NOWC)?
3)How would you improve the outcome, looking at either scenario analysis or sensitivity analysis (Hint: changing the most sensitive driver only a little bit will still have a big impact).
4) How does changing the weighted average cost of capital influence results? Does the company have any control over its WACC?