$1)$ Prepare a spreadsheet similar to the one provided. This spreadsheet calculates the PW of the project $($and the $\%$ change$)$ when both nickel prices and cobalt prices change $(+$ or $-)0,5,10$ and $15\%.$Smilarly, your spreadsheet should calculate the PW and $\%$ change when cobalt and nickel prices are varied by the same percentages. i$.$e $(+$ or $-)0,15\%$ and $30\%.$ Note that this means you do not have the interest rate variations in your model. Just vary Nickel and Cobalt prices!

$2)$ Draw conclusions from your spreadsheet on the sensitivity of the project to simultaneous movement of these prices in the same AND opposite directions.

Baseline assumptions:

Investment of $$50M,$$$200M,$$$200M$ over $3$ years

$14,000$ tons annual Nickel production

$2,000$ tons annual Cobalt production

$$6$ per pound Nickel price

$$16\mathrm{.}5$ per pound Cobalt price

$$3\mathrm{.}10$ per pound production costs $($either metal$)$

$10$ years of production, no salvage value

$$5$ million annual costs

End $2019$ is time zero

$20\%$ annual interest rate.