Lesson ProgressPhase 5 of 6
Phase 5Assessment
Assessment: Data Tables: Sensitivity Analysis
Verify Data Table mechanics and interpret pricing risk.
📊 Phase 5: Assessment
The Sensitivity Audit
Testing Your "What-If" AnalysisYour Sensitivity Matrix is a powerful tool, but is it trustworthy? In this assessment, we'll verify your Data Table setup and test your ability to interpret sensitivity results for business decisions.
Assessment Metrics
Technical (50%)
- Correct column input cell reference (Price)
- Correct row input cell reference (Volume)
- One-variable table calculates correctly
- Two-variable matrix calculates correctly
- No #VALUE! errors
Interpretation (50%)
- Identifies best-case scenario
- Identifies break-even zone
- Explains pricing risk to investors
- Connects results to CVP logic
Data Table Mastery Assessment
Prove you can build and interpret sensitivity analysis.
1. Sarah wants to create a Data Table that shows profit at prices $1,000, $1,100, $1,200, $1,300, $1,400. Where should she place these price values relative to the profit formula?
2. When setting up a two-variable Data Table, the 'Row Input Cell' should reference:
3. After creating a Data Table, Sarah tries to delete just one cell in the results. What happens?
4. Looking at the two-variable matrix, Sarah notices some cells are negative (losses) and others are positive (profits). This helps her communicate:
0 of 4 questions answered
90-Second Investor Pitch
With your Data Table open, pretend an investor asks: "What's the range of outcomes I should expect?"
- Reference your two-variable matrix to identify the profit range (lowest to highest).
- Name the price/volume combination that maximizes profit and state the amount.
- Identify the break-even boundary: at 20 units, what is the minimum price to avoid a loss?
Write these points in a brief script or voice memo. This connects the technical work to persuasive communication.
Next: Building the Dashboard
In Lesson 7 (Project Rehearsal), you'll integrate all your CVP work into a polished workbook. The Data Tables you built today will feed directly into the dashboard you'll create in Lesson 6.