Andrei OkhlopkovAssociate Director, Private Equity
- views 4.2k
- users 466
- reviews 82
- Best Practices 12
Andrei Okhlopkov
Associate Director, Private Equity
Discuss with Andrei Okhlopkov!
Follow 47
Hire Me!
I have recently passed my 20-year milestone in financial modelling and analysis. Being passionate about building all sorts of models, analytics and VBA applications, I also enjoy sharing my knowledge (a part of which is presented here, in the attached files).If you need more help than what you found here, I can:- advise you on specific aspects of financial modelling- build models, forecasts or analytics for you from scratch- coach you on various modelling, Excel and VBA matters
TagsSocial
Analysing data in Excel
A set of techniques for working with data in Excel121DiscussfreeDescriptive statistics for grouped (weighted) data
Calculating key statistics measures (average, median, standard deviation, skewness etc.) for grouped or weighted data47DiscussfreeGuiding principles of Financial Modelling
The file explains the general principles of building financial models with a few practical examples.751DiscussfreeMonte Carlo Analysis (without macros) Excel Model
This post explains how to run full Monte Carlo in Excel without macros4042freeSensitivity Analysis Excel Model - using Data Tables (short version)
The model explains how to show models outputs under different scenarios simultaneously.1,166DiscussfreeSensitivity analysis Excel Model with indifference curves
An Excel utility to draw indifference curves for two inputs in a financial model1691freeHow 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.2252freeDates and Timelines in Excel Financial Models
The tool shows how to work with dates & timelines in financial modelling.703DiscussfreeSensitivity Analysis Excel Model - using Data Tables (full version)
This is an extended version of my 'Analysing sensitivities with data tables' file with significant enhancements215Discuss$15.00Sensitivity analysis Excel Model with indifference curves (unlocked)
An Excel utility (unlocked) to draw indifference curves for two inputs in a financial model38Discuss$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 statistics319Discuss$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.38Discussfree
