Tag Archives: Scenario

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 Data Tables, Sensitivity, Technique | Leave a comment

Search
Auditing Best Practices Conditional Format Controls Data Tables Data Validation Depreciation Error Handling Errors Excel Function Excel Functionality Find Find & Replace Format Formula Go to Input Model Model Structure OFFSET Options Pivot Tables R1C1 RAND Reference Style Scenario Sensitivity Settings Shortcuts Tables Technique Tips Trigger Tutorial Visualization
WP Cumulus Flash tag cloud by Roy Tanck and Luke Morton requires Flash Player 9 or better.
RSS updates
- All posts
- All comments
Email updates

Enter your email address:
Share this blog
Recent Posts
Recent Comments
Blogroll
Links
- ModelCom
Meta
The Financial Modeler

Tag Archives: Scenario

Powerful Sensitivity Tables

Search

RSS updates

Email updates

Share this blog

Recent Posts

Recent Comments

Blogroll

Links

Meta

The Financial Modeler