Capstone · Week 11
Sensitivity & Risk
Build a scenario dashboard (best, base, worst) and a tornado chart that ranks the top drivers of cash flow or profit.
Judged using the capstone Rubrics.
What to include
Clarity for decisions
- Scenario inputs and a summary table.
- Tornado chart ranking at least five drivers.
- Short note: what you would change and why.
- Link back to the integrated statements.
Excel Requirements
Scenario Manager and tornado chart workflow
- Define three scenarios (best, base, worst) for key inputs (price, volume, cost, etc.).
- Use Scenario Manager or separate input blocks to generate a summary.
- Create a tornado chart by measuring the change in profit or cash for each driver.
- Rank drivers by impact; label the chart clearly.
Quality Checks
Useful, honest risk view
- Scenarios actually change the linked statements; results make sense.
- Tornado bars are scaled from the same base and use the same metric.
- Takeaways are practical: what to watch, and what to adjust first.
Submission
What to turn in
- Excel file with scenarios and a tornado chart.
- Short paragraph (5–7 sentences) on the top three drivers and your response plan.