Practice the Goal Seek workflow in a safe simulator.
"I want to make sure I understand the three boxes before I touch my workbook," Sarah said. "If I mess up the Set Cell vs. By Changing Cell, I could get a completely wrong answer and not even know it."
Before we run Goal Seek on the real CVP workbook, you'll practice the exact workflow in this simulator. Think of it as a flight simulator for Excel— safe to make mistakes here, and you'll learn exactly what each box does.
"The investor wants to know: what price gives us $15,000 profit if we serve 25 projects?"
The Setup
Fill in the Goal Seek dialog box fields below to tell Excel how to solve this problem.
- Excel reads your Profit formula
- It adjusts the Price cell up or down to get closer to $15,000
- It repeats this in tiny steps until it hits exactly (or close to) your target
- The Price cell updates to show the answer
This takes Excel less than a second. Try doing that by hand for 50 different scenarios!
Notice what just happened: we told Excel the result we wanted, and it found the input we needed.
- Forward Math: Price × Volume − Costs = Profit (you know inputs, find result)
- Goal Seek: Profit = Target, solve for Price (you know result, find input)
- The Business Value: Investors ask "what do we need to charge?"—Goal Seek answers instantly.
Discussion Prompt (3 minutes):
Share with a partner:
- What business decision would require you to "work backward" like Goal Seek?
- Why is it faster to use Goal Seek than to guess-and-check prices manually?
- What could go wrong if you put the wrong cell in "By Changing Cell"?
Ready for the Real Workbook
In Independent Practice, you'll build the CVP model from scratch in Excel and run Goal Seek to answer Sarah's investor question.