Tornado Chart Sensitivity Analysis: Free Scenario Comparison Tool (2026)

A tornado chart sensitivity analysis tool compares alternative outcomes against a reference case. It ranks the differences so the widest drivers appear most important visually. This page uses cumulative cash flow and break-even occupancy scenarios from the supplied rental-property stress test. The result helps users decide where deeper model review should begin. It does not replace the underlying financial model or independently verify its assumptions.

The arithmetic is based on the numbers entered into the form and is calculated in the browser. The chart accurately ranks those entered differences from the selected baseline. It cannot determine whether the source values are correct, current, or appropriate for a lending decision. Accuracy therefore depends on the quality of the scenario data and the model behind it. The supplied example reflects the figures stated for the 10-year rental-property dashboard.

The tool is useful for analysts, finance and accounting teams, investors, lenders, operations teams, and researchers reviewing scenario-based forecasts. It is also suitable for anyone who needs to explain model exposure without presenting every worksheet detail. Rental-property reviewers can use it to compare cash-flow pressure and occupancy resilience. Teams working with other financial models can replace the example values with their own results. Users should still involve the appropriate subject-matter reviewer before acting on the output.

You need a baseline 10-year cash-flow result and alternative cash-flow results for a rate-shock and stagflation or operating-pressure case. You also need the corresponding break-even occupancy percentages for the three cases. The example starts with €28.8K, -€17.7K, and -€24.4K in cumulative cash flow. It also starts with 64.3%, 71.4%, and 73.6% occupancy values. You can overwrite every input before running the analysis.

Start with the widest bar because it represents the largest difference from the baseline among the supplied cases. Then trace that scenario back to the assumptions, source documents, and debt-service calculations that produced it. In the provided project, the rate-shock and stagflation cases both indicate materially weaker coverage than baseline, while stagflation has the highest listed peak break-even occupancy at 73.6%. Use the output to prioritize questions rather than to make an unsupported decision. A reviewable audit trail and the original model remain necessary for final conclusions.