Andrei OkhlopkovAssociate Director, Private Equity
- views 2.2k
- users 264
- reviews 46
- tools 12
Andrei Okhlopkov
Associate Director, Private Equity
Discuss with Andrei Okhlopkov!
Follow 23
BioExperienced corporate finance and investment professional. A dedicated expert in financial modelling, spreadsheets, dashboards and visual. Professional VBA developer.
TagsSocial
Monte Carlo Analysis (without macros) Excel Model
This post explains how to run full Monte Carlo in Excel without macros245DiscussfreeAnalysing data in Excel
A set of techniques for working with data in Excel58DiscussfreeDescriptive statistics for grouped (weighted) data
Calculating key statistics measures (average, median, standard deviation, skewness etc.) for grouped or weighted data30DiscussfreeSensitivity Analysis Excel Model - using Data Tables (short version)
The model explains how to show models outputs under different scenarios simultaneously.465DiscussfreeDates and Timelines in Excel Financial Models
The tool shows how to work with dates & timelines in financial modelling.594DiscussfreeSensitivity analysis Excel Model with indifference curves
An Excel utility to draw indifference curves for two inputs in a financial model1031freeGuiding principles of Financial Modelling
The file explains the general principles of building financial models and will give a few practical examples.109DiscussfreeHow to change model scenarios or inputs from any worksheet
The attached techniques show how to change inputs and scenarios from any sheet of the financial model without macros.1792freeSensitivity Analysis Excel Model - using Data Tables (full version)
This is an extended version of my 'Analysing sensitivities with data tables' file with significant enhancements116Discuss$15.00Sensitivity analysis Excel Model with indifference curves (unlocked)
An Excel utility (unlocked) to draw indifference curves for two inputs in a financial model28Discuss$10.00Variance Analysis & Portfolio Statistics Calculation Excel Template
A template to analyse variances between two scenarios (e.g. budget vs. actual) and calculate key portfolio statistics290Discuss$12.00How to create a macro state (on/off) indicator
Explains how to add an indicator to Excel VBA files showing whether the file was opened with macros enabled or disabled.30Discussfree
