A conventional data table is a one- or two-dimensional table showing the results of a calculation (model outputs) at various model input values inserted into the headings of rows and/or columns of the data table.

In this file I will introduce a non-conventional way of using data tables which allows to extend a traditional sensitivity analysis. This method relies on the ability of data tables to evaluate a model many times at various input assumptions.

Reviews Add a review
No reviews yet

More From Andrei Okhlopkov

Browse our top rated business templates. See All
financial model templates dashboard How to change scenarios or inputs from any worksheet
A typical model consists of several worksheets - Inputs, Revenues, Opex, Capex etc. Imagine as well your model has three…
financial model templates dashboard Monte Carlo analysis without macros
The Monte Carlo method tests a large number (several hundreds or thousands) of "scenarios" in which the inputs are random…
Analysing data in Excel
In this post I have collected a handful of techniques for working with data in Excel: looking up values, matching…
financial model templates dashboard Sensitivity analysis - advanced methods of using data tables (full version)
This is a full version of my data table publication which explains how to:   - link several data tables…
financial model templates dashboard Guiding Principles of Financial Modelling
The file explains the general principles of building financial models, gives a comprehensive example of a demo financial model and…