Goal Seek by Hand: Bisection Table vs the Algebraic Solution
This lesson is part of the course
In this lesson
You find the units that hit a target EBIT of $250,000 twice: with a 16-step bisection table (what Goal Seek does) and with one line of algebra.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Input-Driven Models: Inputs vs Calculations Locked
- Scenario Selector: Base, Best and Worst with CHOOSE and INDEX Locked
- One-Variable Data Table, Built with Formulas Locked
- Two-Variable Data Table with Mixed References Locked
- Goal Seek by Hand: Bisection Table vs the Algebraic Solution Locked
- Break-Even and Target Profit: Solve Instead of Seek Locked
- Tornado Sensitivity: Which Driver Moves Profit Most? Locked
- Monte-Carlo-Style Scenarios: Expected Value and the Chance of a Loss Locked