Sensitivity Chart Creator for Microsoft Excel

Create sensitivity charts with Microsoft Excel.
Download

Sensitivity Chart Creator for Microsoft Excel Ranking & Summary

Advertisement

  • Rating:
  • License:
  • Purchase
  • Price:
  • $49.95
  • Publisher Name:
  • Add-Ins
  • Publisher web site:
  • http://www.add-ins.com/
  • Operating Systems:
  • Windows 7, Windows Vista, Windows XP

Sensitivity Chart Creator for Microsoft Excel Tags


Sensitivity Chart Creator for Microsoft Excel Description

From Add-Ins: These charts are also know as tornado charts due to their appearance. They show the sensitivity of key output variables, in this case Net Present Value, to key input cells (shipments, variable cost, to volume growth). If the chart is like the above, with the main then it is called a tornado chart. If it is rotated 90 degrees, it is called a fishbone chart. 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.


Sensitivity Chart Creator for Microsoft Excel Related Software