Scenarios - Custom Values
Add custom input values 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 Values: Custom input values for the scenario analysis.
Notes
Input Cell references can be any cell in Excel (i.e. including cells with formulas).
Custom input values 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.