Mastering The Power Of Sensitivity Tools In Financial Modeling

certification logo19700       

Live Webinar | CEU Approved

  • 90 minutes

What if our projections are incorrect? How much variation can we live with when making decisions involving significant amounts of time, money and other resources? How can we express the degree of variation in the expected results in current operations and future projects? How well do we quantify upside potential AND the downside risk in our decision making? We are constantly re-evaluating our actions. How do we know, upfront and with certainty, we will be able to weather decision gone bad? Financial modeling and forecasting from reasoned logic, realistic ranges for our significant variables and proper application of sensitivity testing should provide us with the answers to these questions.

Join this session with our expert Miles Hutchinson where he will show you how to unlock the power of scroll bars and spinners, goal seeks, one and two-input data tables and scenario manager in your models.

Session Highlights:

  • Learn “Best Practices” - Top 20 guidelines of effective model design, development, and delivery

  • Apply Scroll Bars and Spinners to individual cells and flex them over their relevant ranges with the touch of your mouse

  • Use Goal Seek to discover how much a single variable must move to reach the desired outcome

  • Use Data Tables with one or two-inputs to deliver an array of outcomes from your model in just seconds

  • Use Scenario Manager to store selected groupings of inputs and resulting outcomes

  • Use Scenario Manager to consolidate all ”versions” of your model into one file

  • Use the built-in Scenario Summary report to compare your Scenarios side-by-side, automatically!

  • Expand your skills in financial modeling to a level you never dreamed of in just 90 minutes!

  • Bonus – download a copy of the demo model.  Receive the answer key to our demonstration!  Repeat the lessons at your own pace after the webinar is ended with full instructions provided for each tool

Why you should attend:

Join our expert for 90 minutes to learn how to put the powerful sensitivity tools of Microsoft Excel to work in your models. Learn the top 20 best practices of solid model design, development, and delivery.

Who should attend:

  • CFOs

  • Controllers

  • Investment Analysts

  • Financial Analysts

  • Business Analysts

  • Forecasting & Planning

  • M&A Specialists (Mergers & Acquisitions)

  • Risk Managers

  • Strategic Planners

  • Capital Expenditure Planners

  • Cost Accountants

  • Managerial Accountants

Advanced Preparation: None

Program Level: Intermediate

Prerequisites: None

Field of Study: Accounting & Finance

You may ask your Question directly to our expert during the Q&A session.

** You can buy On-Demand and view it at your convenience.

Miles  Hutchinson

Miles Hutchinson

Mr. Hutchinson is an accomplished businessman, business consultant and course leader specializing in finance, accounting and taxation. He excels at sharing these complex topics in a crystal clear manner. He is also proficient in sales & use taxation, payroll taxation, public speaking, problem solving, negotiating, time management, computer applications, technical documentation and facilitation.

As a Chartered Global Management Accountant, Miles has amassed a multi-disciplined approach to client consulting over the past 40 years. With increasing responsibilities in jobs ranging from independent financial auditor with PriceWaterhouseCoopers to Chief Financial Officer of a one billion-dollar real estate development company, Miles brings a seasoned, diverse and creative viewpoint to your situation and draws on that experience to bring you the best solution. He has facilitated customized public and onsite business consulting/training sessions and presented over 2500 presentations on a myriad of business topics. He has designed, developed, implemented and monitored complete business systems conversion and documentation projects. Miles will help you debunk the chaos and organize your thoughts and quickly gain clarity with your most difficult challenges.

No Reviews Found

Edupliance is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: more information regarding administrative policies such as complaint and refund, please contact our offices at 844- 810-1151. 
PLEASE NOTE: To receive credit through the NASBA for this program you MUST attend the Live program in its entirety and complete the required progress checks.

Our registration number is 138832.

Number of CPE Credits Awarded for This Course: 1.5 (Accounting - 0.5, Finance - 1.0)
Delivery Method: Group Internet Based

Want to attend in a Group? Call 844-810-1151 and Save upto 50%

Share this course with a friend

We Also Recommend

Finance Banking & Taxation

Form 1065 and 1120s: Updates for 2019

CEU Approved | Pre Recorded
90 minutes

Finance Banking & Taxation

Implementing the New Lease Accounting Standards

CEU Approved | Pre Recorded
90 minutes


Get Notified about News, Webinars, Community & More