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
103
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
107
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
163
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
359
33
A conventional data table is a one- or two-dimensional table showing the results of a calculation (model outputs) at various…
financial model templates dashboard Guiding Principles of Financial Modelling
338
44
The file explains the general principles of building financial models, gives a comprehensive example of a demo financial model and…