Business Decision Models and Scenario Analysis Training Course
Spreadsheet-based decision models, decision trees and scenario tests that help finance analysts and managers compare investment, pricing and capacity options.
This 1-week course has 50 dates from November 2026 to November 2027 in 24 cities and live online. The next session runs 23 – 27 November 2026 in Dar es Salaam. Fees per participant run from 3,300 £ (Amman) to 7,900 £ (New York) in a classroom, and from 1,900 £ live online.
See dates and book Download brochure (PDF) Training for your team
- Duration
- 1 Week
- Next start
- Dar es Salaam
- Scheduled dates
- 50
- Classroom cities
- 24
- Classroom fee from
- 3,300 £
- Online fee from
- 1,900 £
When and where does this course run?
Showing 1–20 of 50 dates
November 2026
December 2026
January 2027
February 2027
March 2027
April 2027
Can’t find a suitable date? Tell us what you need.
What does this course cover?
Business Decision Models and Scenario Analysis is a 1-week training course for finance analysts and business managers who turn spreadsheet data into a decision model pack for investment, pricing and capacity choices. Volatile input costs, shorter planning cycles and boards that expect options rather than single forecasts make structured decision models a core skill for finance teams. Jupiter Prime Training runs this course on business decision models.
Why Business Decision Models Matter Now
Three forces shape business decision models today: faster swings in demand and input prices, executive committees that ask for ranges instead of point estimates, and spreadsheet estates that have grown without clear structure or audit trails. An organisation that models choices well can compare capital projects, price changes and capacity moves on a consistent basis and explain the risk behind each. One that models badly approves projects on optimistic single cases and discovers the downside late. The course rests on decision analysis, expected value reasoning, discounted cash flow and structured spreadsheet modelling practice.
Who Gains Most from Business Decision Models
- Financial analysts responsible for building investment cases and appraisal spreadsheets
- Business managers who choose between pricing, sourcing and capacity options
- Planning and budgeting staff who prepare forecasts and what-if comparisons for executives
- Commercial analysts who estimate the profit effect of price and volume changes
- Project controllers who track the financial case behind approved initiatives
Finance business partnering groups gain most when several members attend together, because they leave with a shared model layout and a common way of presenting options.
Business Decision Models Capabilities
Participants move from loose spreadsheets to models that separate inputs, logic and outputs and show how each assumption drives the answer.
- Design a decision model with clear input, calculation and output sheets — model reviewers and auditors
- Build decision trees with probabilities and payoffs for staged choices — capital approval committees
- Calculate net present value and payback for competing proposals — investment decisions
- Test assumptions with tornado charts and data tables — budget holders weighing risk
- Compare base, upside and downside scenarios on one dashboard — executive sponsors
- Communicate a recommendation with its key drivers and limits — senior management
Key Business Decision Models Terms
- Decision tree — a diagram of choices, chance events, probabilities and payoffs used to compare the expected value of options.
- Expected value — the probability-weighted average outcome of an option across all its possible results.
- Sensitivity analysis — changing one input at a time to see how strongly it moves the model result.
- Scenario analysis — changing a coherent set of inputs together to describe a possible future state.
- Net present value — the sum of future cash flows discounted to today minus the initial investment.
- Break-even point — the volume or price at which revenue exactly covers fixed and variable costs.
Business Decision Models Day by Day
Day 1: Framing Decisions for Modelling
- Decision Framing Canvas — Defining The Choice, Options And Criteria
- Influence Diagrams — Mapping Drivers Behind Revenue And Cost Outcomes
- Model Layout Standards — Separating Inputs, Calculations And Outputs Clearly
- Assumption Registers — Recording Sources And Owners Of Each Input
- Stakeholder Question Mapping — Matching Model Outputs To Approver Needs
Day 2: Valuing Options and Cash Flows
- Discounted Cash Flow Logic — Comparing Projects With Different Timing
- Net Present Value And Internal Rate Of Return — Ranking Capital Proposals
- Payback And Discounted Payback — Judging Liquidity Exposure Of Investments
- Incremental Cash Flow Rules — Excluding Sunk And Allocated Costs
- Pricing And Volume Models — Estimating Margin Effect Of Price Moves
Day 3: Modelling Uncertainty and Risk
- Decision Trees With Probabilities — Valuing Staged Expansion Or Abandonment
- Expected Value And Regret Tables — Choosing Under Uncertain Demand
- One-Way Data Tables — Measuring Single Driver Influence On Results
- Tornado Charts — Ranking Inputs That Deserve Further Investigation
- Break-Even And Capacity Thresholds — Setting Plant Or Staffing Trigger Points
Day 4: Building Scenarios for Management
- Scenario Design Matrix — Combining Drivers Into Coherent Future States
- Scenario Switch Controls — Running Base, Upside And Downside Cases
- Goal Seek And Solver Basics — Finding Required Prices Or Volumes
- Model Integrity Checks — Catching Broken Links And Hard-Coded Figures
- Decision Dashboards — Presenting Options And Ranges On One Page
Day 5: Practising the Decision Model Pack
- Capital Project Case — Applying Cash Flow And Tree Methods
- Pricing Choice Case — Applying Sensitivity And Break-Even Tests
- Peer Model Review — Applying Integrity Checks To Colleague Files
- Recommendation Memo Structure — Linking Drivers, Risks And Proposed Action
- Decision Model Pack — Assembling Model, Scenarios And Recommendation
Applying Business Decision Models After the Course
- Rebuild one live investment or pricing spreadsheet using the input, calculation and output layout with an assumption register.
- Run a tornado chart and three scenarios on a pending proposal and present the ranges to its approver.
Business Decision Models Questions (FAQ)
What are business decision models and why do they matter now?
Business decision models are structured spreadsheets and diagrams that compare options by value and risk. They matter now because executives expect ranges and scenarios, not single forecasts, before they commit capital or change prices.
Which roles gain most from business decision models training?
Financial analysts, planning staff and business managers gain most. They prepare or approve investment, pricing and capacity proposals and need models that show which assumptions drive each answer.
How does business decision models training differ from a financial modelling course?
It focuses on choosing between options under uncertainty. A general financial modelling course builds three-statement forecasts, while this one centres on decision trees, sensitivity tests and scenario comparison for specific choices.
What do you bring back from business decision models training?
You bring back a decision model pack. It holds a structured model, tested scenarios and a short recommendation memo that you can adapt to the next proposal your organisation must decide.
Business Decision Models: The Way Forward
The decision model pack gives finance and business managers a repeatable way to frame a choice, value its options and show the risk around each. Its first use is usually a pending capital or pricing proposal. Approvers read the scenarios and memo; analysts maintain the model. After that first use, revisit which assumptions proved most uncertain and refine the register.
Find more Accounting, Financial Reporting & Budgeting Courses by city
Questions about dates, fees and booking
When does this course next run?
The next session runs 23 – 27 November 2026 in Dar es Salaam. It is one of 50 dates scheduled up to November 2027.
Where is this course held?
In a classroom in 24 cities: Dar es Salaam, Amsterdam, Geneva, Barcelona, Milan, Munich, New York, Doha, and more. It is also scheduled as live online sessions.
Can I attend this course online?
Yes. 2 dates are scheduled as live online sessions; the next runs 31 January – 4 February 2027, from 1,900 £ per participant.
How long is the course?
1 Week. Each date shows its start and end dates.
How much does the course cost?
Fees per participant run from 3,300 £ (Amman) to 7,900 £ (New York) in a classroom, and from 1,900 £ live online. Each date shows its own fee.
Is there a brochure for this course?
How do I book a place?
Choose a date above and select Register, or send us an enquiry.
Can this course be run for our team?
Yes. Tell us the number of participants and your preferred dates and city through our training request form.