Sensitivity Chart Creator for Microsoft Excel for Windows

The first step in creating sensitivity charts is to first create an Excel workbook. This workbook can be as complex or as simple as you need. The above sensitivity chart was created using a workbook that modeled a proposed investment in a new product manufacturing facility. It consisted of a set of input cells for shipments, variable cost, and other key variables. From these values, key output cells such as Net Present Value and return on investment are calculated.