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!

Who Should Attend

• Financial Officers
• FP&A (Financial Planning & Analysis)
• Financial Analysts
• Controllers
• CFOs
• Staff with roles and responsibilities in financial forecasting and analysis departments.