- Sensitivity Analysis
- Sensitivity - Custom Percents
Sensitivity - Custom Percents
Flex each input by your own percent changes (±10%, ±20%, ±50%).
Applications
Investment
- Run standard ±10% and ±20% flexes on returns.
- Apply the same flex to every input for a like-for-like view.
Credit
- Apply standard lender haircuts to revenue and costs.
- Show DSCR and leverage under each haircut.
Valuation
- Flex key value drivers by set percentages to bracket value.
- Show valuation ranges for an IC or board paper.
- 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.
- Input Percent Changes
- The percent changes to test 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.