Math for Business Operations

Applied Accounting with Excel

Lesson ProgressPhase 6 of 6
Phase 6Closing
Closing: Data Tables: Sensitivity Analysis

Reflect on sensitivity analysis and prepare for integration.

🎯 Phase 6: Closing
Sensitivity Analysis Mastery: You Can Answer "What-If"
Professional What-If Analysis Milestone Reached

Congratulations! You've officially mastered Data Tables. You can now show investors the full range of outcomes—not just one scenario, but every possibility at once. That's the difference between a guess and a strategy.

Professional Skills Gained

Technical Skills:

  • One-variable Data Table setup
  • Two-variable Data Table (matrix) setup
  • Column vs. Row input cell logic
  • Array formula behavior

Strategic Skills:

  • Full-range scenario analysis
  • Pricing risk identification
  • Break-even zone communication
  • Investor-ready matrix presentation
CAP Framework Reflection
Learning Reflection
Reflect on your learning journey and growth in the CAP framework
0/3 Complete
🦁COURAGE
Presenting a sensitivity matrix to investors requires confidence—you're showing them every possible outcome. How does having this full 'What-If' analysis help you feel more courageous during a presentation?
0 characters
🌊ADAPTABILITY
Your sensitivity matrix must adapt to different investor questions. Reflect on a moment when you had to explain what the matrix showed about pricing risk. What did you learn?
0 characters
⚡PERSISTENCE
We built two types of Data Tables today. Describe one specific challenge you faced and how you resolved it. Why is this skill important for the final project?
0 characters
Progress: 0/3 reflections completed
Next: Integration Dashboard

You've built the engine (CVP model), the sniper (Goal Seek), and the sensitivity matrix (Data Tables). In Lesson 7 (Project Rehearsal), you'll integrate everything into a polished, investor-ready workbook.

Unit Final Milestone:

Carry your CVP model, Goal Seek analysis, and sensitivity tables into a polished pricing workbook that is ready for QA, rehearsal, and presentation.

Final Perspective

"Sarah," Michael Chen said at the end of the rehearsal, "most founders can tell me one price point. You can tell me every price point and show me exactly where the risk lives. That's what strategic pricing looks like."

Previous: Assessment
Lesson OverviewComplete Lesson
Phase Navigation
HookIntroductionGuided PracticeIndependent PracticeAssessmentClosing