Templates by Andrei Okhlopkov

1 to 7 of 7 Results
Guiding Principles of Financial Modelling
(0)
366
52
The file explains the general principles of building financial models, gives a comprehensive example of a demo financial model and…
Sensitivity analysis - advanced methods of using data tables
(0)
382
42
A conventional data table is a one- or two-dimensional table showing the results of a calculation (model outputs) at various…
Analysing data in Excel
(0)
229
28
In this post I have collected a handful of techniques for working with data in Excel: looking up values, matching…
How to change scenarios or inputs from any worksheet
(0)
167
27
A typical model consists of several worksheets - Inputs, Revenues, Opex, Capex etc. Imagine as well your model has three…
Monte Carlo analysis without macros
(0)
173
20
The Monte Carlo method tests a large number (several hundreds or thousands) of "scenarios" in which the inputs are random…
Sensitivity analysis - advanced methods of using data tables (full version)
(0)
354
1
This is a full version of my data table publication which explains how to:   - link several data tables…
Variance Analysis & Portfolio Statistics Variance Analysis & Portfolio Statistics
(0)
33
0
The attached template provides the basis for product portfolio analysis. The template performs the following types of analysis: - key…