Financial Forecasting Using Excel’s Powerful Sensitivity Tools
Duration: 90 minutes
Speaker: Miles Hutchinson
Webinar Description
Financial analysis is an area of opportunity and risk. Analysis should incorporate tests of sensitivity to changes in key variables using the most advanced tools available. Typical financial models do not effectively utilize these tools. This shortcoming exposes an analyst to blind spots in the analysis. Any business person conducting financial analysis should obtain and become proficient with the more sophisticated “what if” analysis tools of the trade.
In just 90 minutes, experienced CGMA and financial analyst, Miles Hutchinson, will demonstrate these powerful sensitivity tools for you using Microsoft Excel™. He will provide practical instructions and guidance for applying these modeling techniques and identify the key cautions to help you avoid potential misfires.
Agenda
-
22 rules of effective model design
-
Applying Scroll Bars to individual cells to flex them over their relative ranges with the touch of your mouse
-
Use Goal Seek to discover how much a single variable must move to reach a desired outcome
-
Use Dynamic 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 automatically compare your Scenarios
-
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, complete with instructions for each of these tools!
Logistics
- 90 minutes (Travel Free) delivered over the Internet.
Unlimited listeners per connection - bring the entire department.
Q&A session with the expert.
Special Feature: If you register for this webinar and cannot attend, you will be able to access a one-time instant replay without charge for up to 90 days after the date of the webinar.
This event will be presented live with a PowerPoint presentation to be viewed on your computer. You may listen to the audio of the webinar by telephone or through your computer. The PowerPoint slides will be provided shortly before the event. Once you register, you will receive an email which is your receipt and which includes your instructions for dialing in and logging on. You will also receive an email reminder 24 hours before the webinar.
What is a webinar?
A webinar is a live Internet based seminar. Webinars are a way for participants in many different locations to see and hear a presentation and view PowerPoint slides. You can also have your colleagues attend the webinar using one connection.
What kind of equipment do I need?
You will need a computer with an Internet connection (high speed service such as DSL or cable works best) and a telephone. You may listen to the webinar through your computer speakers, in which case you will not need to use a telephone connection. Internet access is not required for phone-only participants, but you will not be able to see the speaker’s slides.
How can I share the webinar with my colleagues who may not be able to attend the event?
CDs of each program will be available for sale and can be shared with your business associates.
Can I get a copy of the PowerPoint slides used in the webinar?
The PowerPoint slides will be available on the materials page link in the confirmation email that will be sent to you no later than the morning of the day a webinar is presented.
How do I ask a question during the webinar? Will my question be answered during the presentation?
A question and answer session will be scheduled at the end of each webinar. You can then ask a question by typing it into the question box that will be provided to you duringthe webinar. You may also ask a question through the telephone connection. As many questions as possible will be answered during the Question and Answer period.