What If - Break Even
Run goal seek to find the input value that makes the output break even.
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.
Notes
Input Cell references can be any cell in Excel (i.e. including cells with formulas).
Output
Excel Chart: Output chart of the break-even analysis.
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.