Lesson ProgressPhase 5 of 6
Phase 5Assessment
Assessment: Goal Seek: Hit Your Profit Target
Verify Goal Seek mechanics and interpret results.
📊 Phase 5: Assessment
The Investor Meeting
Technical Verification & Business InterpretationSarah is in the investor meeting. They have three questions, and she needs you to answer them using her Goal Seek workbook.
Investor Questions
Technical Mastery (50%)
- Correct Set Cell / By Changing Cell selection
- Goal Seek dialog box mechanics
- Troubleshooting failed Goal Seek runs
- Multiple scenario testing
Strategic Judgment (50%)
- Interpreting results in business context
- Identifying realistic vs. unrealistic prices
- Connecting pricing to market positioning
- Communicating findings to investors
Goal Seek Technical Assessment
Prove you can set up and run Goal Seek correctly.
1. In the Goal Seek dialog, what does 'Set Cell' refer to?
2. Sarah wants to know what volume she needs to hit $20,000 profit at $1,350 price. Which cell goes in 'By Changing Cell'?
3. If Goal Seek returns an error saying it cannot find a solution, what should you check first?
4. A student runs Goal Seek and the Price changes to $50,000. Why is this likely wrong?
0 of 4 questions answered
Investor Prep: Scenario Document
Re-open your Goal Seek CVP workbook. Use it to create a one-page "Investor Prep" document answering these three questions:
- Break-Even Price: What is the lowest price Sarah can charge and still make at least $0 profit at 25 projects?
- Target Price: What price gives Sarah $15,000 profit at 25 projects? (Round to a natural price point.)
- Growth Scenario: If Sarah wants $25,000 profit and can handle 35 projects, what should she charge?
For each answer, include the exact Goal Seek settings you used and a one-sentence business recommendation. This document will be your artifact for Phase 5.
Almost Ready for Prime Time
In the Closing phase, we'll reflect on how Goal Seek changes Sarah's ability to prepare for investor meetings. Next lesson, we'll add Data Tables to map multiple scenarios at once.