Goal Seek - Any Cell

Goal Seek on any cell, including formula cells.

Applications

Investment

  • Find the exit EBITDA needed for a target IRR.
  • Back-solve formula-driven inputs, not just hard-codes.

Credit

  • Find the debt size that gives a target DSCR.
  • Solve for the margin at a covenant limit.

Valuation

  • Find the WACC implied by a given price.
  • Back-solve the growth rate implied by a market value.
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.
Learn the basics in 5 minutes with our Quick Start Guide. To make the most of Fontics, check out our Tips & Tricks.