Last version published: 05/03/2019 17:02
Publication number: ELQ-46892-2
View all versions & Certificate
Sensitivity Analysis Excel Model - using Data Tables (short version)
The model explains how to show models outputs under different scenarios simultaneously.
Andrei Okhlopkov offers you this business tool for free!
download for free
Add to bookmarks
The tool allows to see the outcomes of a financial models simultaneously under several scenarios
Financial models with multiple scenarios
- Works well
People using this tool also downloaded
Sensitivity Analysis Excel Model - using Data Tables (full version)This is an extended version of my 'Analysing sensitivities with data tables' file with significant enhancements50$15.00 by Andrei Okhlopkov
Sensitivity analysis Excel Model with indifference curves (unlocked)An Excel utility (unlocked) to draw indifference curves for two inputs in a financial modelNew!$10.00 by Andrei Okhlopkov
Monte Carlo Analysis (without macros) Excel ModelThis post explains how to run full Monte Carlo in Excel without macros64
How to change model scenarios or inputs from any worksheetThe attached techniques show how to change inputs and scenarios from any sheet of the financial model without macros.83
Dates and Timelines in Excel Financial ModelsThe tool shows how to work with dates & timelines in financial modelling.45
Guiding principles of Financial ModellingThe file explains the general principles of building financial models and will give a few practical examples.37
Sensitivity analysis Excel Model with indifference curvesAn Excel utility to draw indifference curves for two inputs in a financial modelNew!
Descriptive statistics for grouped (weighted) dataCalculating key statistics measures (average, median, standard deviation, skewness etc.) for grouped or weighted dataNew!
Any questions on Sensitivity Analysis Excel Model - Using Data Tables (short Version)?
The user community and author are here to help. Go ahead!