Don't be afraid to create new variables to keep your formulas short and more readable. They are particularly useful when you have multiple inputs in a formula that can easily combined.

With revenue and production costs created, we can now calculate our project cashflows and the estimated return on initial investment.

Tornado charts are a great way of finding out which which parameters most affect our output. However, they are difficult to build and require substantial data analysis.

In this lesson, we'll finish building our chart and identify some valuable insights that the chart provides.

Some charts, such as the Tornado, won't update when we change a control panel input. As a safety mechanism, we'll build in warnings that tell us when our chart data has not updated.

Our second model iteration will calculate the tax shield provided by plant depreciation and subtract the final taxes paid from operating cashflows.

Multiple scenarios should always be considered when evaluating high-risk projects. In the next two lessons, we'll add optimistic and pessimistic scenarios to our output panel.