Andrei OkhlopkovAssociate Director, Private Equity Follow 69
- views 8.3k
- users 718
- reviews 135
- Best Practices 15
Andrei Okhlopkov
Associate Director, Private Equity
Discuss with Andrei Okhlopkov!
Follow 69
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
Predictive statistics in financial modelling
In this publication I will demonstrate a few techniques of using statistics for making better forecasts in financial mod259Discussadd_shopping_cartfreeSensitivity Analysis Excel Model - using Data Tables (short version)
The model explains how to show models outputs under different scenarios simultaneously.2,421Discussadd_shopping_cartfreeAnalysing data in Excel
A set of techniques for working with data in Excel1,344Discussadd_shopping_cartfreeMonte Carlo Analysis (without macros) Excel Model
This post explains how to run full Monte Carlo in Excel without macros5672add_shopping_cartfreeGuiding principles of Financial Modelling
The file explains the general principles of building financial models with a few practical examples.840Discussadd_shopping_cartfreeDescriptive statistics for grouped (weighted) data
Calculating key statistics measures (average, median, standard deviation, skewness etc.) for grouped or weighted data77Discussadd_shopping_cartfreeCharts and Dashboards in Excel (short version)
Explains the basics of building professional quality charts in Excel308Discussadd_shopping_cartfreeHow 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.2672add_shopping_cartfreeSensitivity analysis Excel Model with indifference curves
An Excel utility to draw indifference curves for two inputs in a financial model2491add_shopping_cartfreeDates and Timelines in Excel Financial Models
Financial models use dates and timelines very extensively, so it is important to become familiar with relevant functions1,150Discussadd_shopping_cartfreeSensitivity Analysis Excel Model - using Data Tables (full version)
This is an extended version of my 'Analysing sensitivities with data tables' file with significant enhancements323Discussadd_shopping_cart$15.00Sensitivity analysis Excel Model with indifference curves (unlocked)
An Excel utility (unlocked) to draw indifference curves for two inputs in a financial model57Discussadd_shopping_cart$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 statistics381Discussadd_shopping_cart$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.48Discussadd_shopping_cartfreeCharts and Dashboards in Excel (full version)
Explains the basics of designing professional charts in Excel with practical examples (full version)49Discussadd_shopping_cart$25.00
Eloquens Member