Forecasting with Excel's Powerful Sensitivity Tools

1
Forecasting with Excel's Powerful Sensitivity
Tools

• Miles Hutchinson

2
Description

• Financial Modeling is based on
  the idea that forecasts are subject to variation
  and this variation should be tested and
  communicated as an aide to effective to decision
  making. Attend this briefing on Excel to unleash
  its powerful sensitivity tools. Get the full
  power out of your financial models. Improve the
  design of your models to take advantage of these
  tools in just 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 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, up front and with
  certainty, we will be able to weather a 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. 

3
Learn best practices for designing
efficient forecasting models. Learn how to apply
scroll bars, goal seek, data tables, and scenario
manager to your models in just 90 minutes.
Experienced CPA and financial analyst, Miles
Hutchinson will demonstrate these tools for you
using Microsoft Excel TM. He will provide
practical instructions and guidance for applying
them and identify the key cautions to help you
avoid potential misfires. 

• Why Should you Attend

4
20 rules of effective model
design.Applying Scroll Bars to individual cells
to flex them over their relative ranges with the
touch of your mouse.Using Goal Seek to discover
how much a single variable must move to reach a
desired outcome.Using Data Tables with one or
two-inputs to deliver an array of outcomes from
your model in just seconds.Using 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 standard Scenario Summary to
compare your Scenarios 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 along and the answer key
to our demonstration!

• Objectives of the Presentation

5
Reach us on
www.onlinecompliancepanel.com
Our links