Fontics | Multi-Input Goal Seek to a Target in Excel

Multi-Input - Custom Target

Find how several inputs must move together to hit an output value you set.

Applications

Investment

Find the mix of input changes needed to hit a target IRR.
Work out what the plan must deliver for a target exit value.

Credit

Find the mix of changes that restores DSCR to covenant level.
Solve for a target leverage across several levers.

Valuation

Find the input changes needed to reach a target EV.
Bridge the gap between your value and the asking price.

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.
Output Settings - Direction: Increase or decrease the output.
Output Settings - Change By: The output value to solve for.
Output Settings - Scenarios: Toggle on to also run a 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.