Tornado Analysis

Rank the inputs that move your output most in an auto-sorted tornado chart.

Applications

Investment

  • Rank the assumptions that move IRR the most.
  • Focus diligence on the inputs that matter.

Credit

  • Rank the drivers of DSCR, leverage or interest cover.
  • Show which risks need the closest monitoring.

Valuation

  • Rank the inputs that drive enterprise value.
  • Show which assumptions to defend in a valuation review.
Input Variable(s)
The model drivers to flex. Add a name and cell reference for each.
Output Variable
The result to track, such as valuation, profit, NPV or IRR. Add a name and cell reference.
Output Settings - Sensitivity %
The percent change applied to each input, up and down.
Output Settings - Scenarios
Toggle on to also run a scenario analysis for each input.
Learn the basics in 5 minutes with our Quick Start Guide. To make the most of Fontics, check out our Tips & Tricks.