Tag Archives: Data Tables

Powerful Sensitivity Tables

By Sebastien Labonne | Published: August 21, 2009
In my previous post, I showed you how to do sensitivity analysis with Excel’s data tables. However the functionality allow us to do sensitivity on 2 variables only. Today I’m following up with a way to overcome this limitation. As an example, an investment might be sensitive to many variables (e.g. lauch dates, set-up costs, marginal [...]
Posted in Model Techniques | Also tagged , , | Leave a comment

Discovering Sensitivity Tables

By Sebastien Labonne | Published: August 13, 2009
Excel has a built-in functionality for sensitivity analysis, hidden under the unclear name of “Data tables” (“tables” in Excel 97-2003). Two options are available in using these “Data tables”: Evaluate the impact of one variable on one or more resulting elements (with 2 possible layouts) Evaluate the impact of two variable on one resulting elements In my next post, [...]
Posted in Excel Functionality, Model Techniques | Also tagged , , | 2 Comments

  • Email updates

    Enter your email address:

  • Share this blog

    Bookmark and Share

  • Recent Posts

  • Recent Comments

  • Meta

  • RSS The Financial Modeler

SEO Powered by Platinum SEO from Techblissonline