Mastering Sensitivity Analysis & Scenario Planning for Smarter Business Decisions and Widening the View of Your Company's Future
This course will give you insights into how sensitivity analysis and scenario planning can improve your company's decisions. You'll also discover tools to obtain and communicate insights from this analysis.
Sensitivity analysis involves varying model inputs to assess their impact on the outputs. This helps identify the model inputs that have the greatest impact on outputs, such as profit, improving decision efficiency and effectiveness. It also provides a clearer picture of the company's full range of potential outcomes.
Scenario planning involves modifying multiple assumptions from the base case or current conditions to explore different projections. It allows outcomes to reflect the correlation between multiple assumptions, which may amplify their impact exponentially compared to changing a single assumption. Scenarios can identify opportunities the company should prepare for or risks it needs to mitigate.
You'll learn tools like bookending and tornado diagrams to develop and present sensitivity analyses. Many people anticipate an overly narrow range of potential outcomes, leaving them unaware of many positive and negative possibilities. You'll discover techniques to enhance the accuracy of estimates for the most likely outcome and the full range of potential outcomes.
Founder of CFO Perspective
Rob Stephens is the Founder of CFO Perspective, which provides continuing education courses for CPAs and financial management courses for business advisors and staff. He has been quoted in Forbes, U.S. News and World Report, Bloomberg Businessweek, and many other news sources. He is also the author of Key Performance Indicators and KPI Dashboards. Rob has a 30-year career that includes serving as a CFO, Director of Operations, and SVP of Finance. Rob is an adjunct instructor for the MBA program at Gonzaga University. Rob holds a Masters of Science in Personal Financial Planning and a Graduate Certificate in Financial Therapy from Kansas State University. He received a B.A. in Business Administration from the University of Washington.
This portal is provided as a training and development resource for City of Markham employees. Every course is delivered by a qualified subject matter expert or learning organization, is quantifiable in hours, and is verifiable — you receive a documented certificate of completion for every course you finish, stored on LearnFormula indefinitely.
If you hold a professional designation (for example in engineering, accounting, human resources, or law), courses may be counted as professionally relevant, verifiable learning activities toward your continuing professional development. Individual practitioners are responsible for confirming that an activity meets the requirements of their professional body. For questions about the City of Markham's training and development policies, please speak with your people leader or Human Resources.
