skinny.

Latest / ModeLoop: Financial Modelling in Excel

P2E16: Goal Seek and Solver in Excel - Work Backwards to the Answer You Need

Goal Seek and Solver in Excel let your financial model work backwards from the answer you need: the breakeven price, the bid tariff that hits the hurdle IRR, or the maximum debt a project can carry. We use both on real project finance, M&A and FP&A problems.

In this episode:

Goal Seek step by step: breakeven price, bid pricing, maximum purchase price, covenant headroom

Goal Seek rules: formula-driven targets, hard-coded inputs, precision and starting points

Solver for debt sizing: maximise senior debt subject to DSCR, gearing and tenor constraints

Choosing GRG Nonlinear, Simplex LP or…

Log in to save or queue this episode.

The skinny

The skinny isn't ready yet — notes appear once the transcript is processed.