Andrei OkhlopkovAssociate Director, Private Equity
- views 1.1k
- users 150
- reviews 35
- tools 11
Andrei Okhlopkov
Associate Director, Private Equity
Discuss with Andrei Okhlopkov!
Follow 16
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 macros114DiscussfreeHow 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.1242freeAnalysing data in Excel
A set of techniques for working with data in Excel31DiscussfreeDescriptive statistics for grouped (weighted) data
Calculating key statistics measures (average, median, standard deviation, skewness etc.) for grouped or weighted data16DiscussfreeSensitivity Analysis Excel Model - using Data Tables (short version)
The model explains how to show models outputs under different scenarios simultaneously.326DiscussfreeDates and Timelines in Excel Financial Models
The tool shows how to work with dates & timelines in financial modelling.69DiscussfreeSensitivity analysis Excel Model with indifference curves
An Excel utility to draw indifference curves for two inputs in a financial model541freeGuiding principles of Financial Modelling
The file explains the general principles of building financial models and will give a few practical examples.64DiscussfreeSensitivity Analysis Excel Model - using Data Tables (full version)
This is an extended version of my 'Analysing sensitivities with data tables' file with significant enhancements90Discuss$15.00Sensitivity analysis Excel Model with indifference curves (unlocked)
An Excel utility (unlocked) to draw indifference curves for two inputs in a financial model19Discuss$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 statistics239Discuss$12.00
