Scenarios - Preset Steps

Set each driver to rise, fall or hold, then move them together in preset steps.

Applications

Investment

  • Step key drivers up or down together to see how returns move.
  • Find how far a combined downside can go before IRR falls short.

Credit

  • Ramp rates up and revenue down together to stress DSCR.
  • See at which step a combined downside breaches covenants.

Valuation

  • See how value moves as key drivers shift together.
  • Bracket value with a combined ramp across several drivers.
Input Variable(s)
The drivers to move. For each, add a name, a cell reference and a direction: increase, decrease or hold.
Output Variables
The results to track, such as valuation, profit, NPV or IRR. Add a name and cell reference for each.
Individual Scenario Analysis
Toggle on to also run a separate 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.