Scenarios - Custom Percents
Add custom input percent changes and evaluate the impact on output.
Input Parameters/Data
Input Variable(s): Input driver(s) of the model. For each item, add Name and Reference (cell reference of its value).
Output Variable: Output of interest (e.g. Valuation, Profit, NPV, IRR etc.). Add Name and Reference.
Input Percent Changes: Custom input percent changes for the scenario analysis.
Notes
Input Cell references can be any cell in Excel (i.e. including cells with formulas).
Custom input percent changes are sorted automatically from smallest to largest.
Output
Excel Chart: Output chart of the scenario analysis to visualize the changes in input(s) and the corresponding output.
Data: Output data used for the chart(s).
Learn the basics in 5 minutes with our Quick start guide. To make the most of Fontics, check out our Tips & tricks.