Overview

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.

Share
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
98
18
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
106
10
The Monte Carlo method tests a large number (several hundreds or thousands) of "scenarios" in which the inputs are random…
Analysing data in Excel
162
22
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)
334
1
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
328
42
The file explains the general principles of building financial models, gives a comprehensive example of a demo financial model and…