please explain each step in detail. explain the formulas where ever it is required. Calculate on excel or manually.

Big City Carl, a local politician, is pushing a new dock and pier system at the river to attract new commerce to the city. A committee appointed by the mayor (an opponent of Carl) has developed the following estimates. With a MARR of 6% and a project life of 10 years, perform a sensitivity analysis on the data using. PW as the assessment metric. For each input, consider deviation of 10%, 5%, 0%,5%,10% from the base case. a. For each deviation of each input, calculate PW and show the result as a table similar to Table 12.2 below. (10 points) b. Show the sensitivity graph. (10 points) c. Which input has the biggest impact on the PW? (5 point) Big City Carl, a local politician, is pushing a new dock and pier system at the river to attract new commerce to the city. A committee appointed by the mayor (an opponent of Carl) has developed the following estimates. With a MARR of 6% and a project life of 10 years, perform a sensitivity analysis on the data using. PW as the assessment metric. For each input, consider deviation of 10%, 5%, 0%,5%,10% from the base case. a. For each deviation of each input, calculate PW and show the result as a table similar to Table 12.2 below. (10 points) b. Show the sensitivity graph. (10 points) c. Which input has the biggest impact on the PW? (5 point)