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…
The skinny
The skinny isn't ready yet — notes appear once the transcript is processed.