Andrei OkhlopkovAssociate Director, Private Equity Follow 232
- views 48k
- users 2.7k
- reviews 550
- Downloadable Best Practices 39
Andrei Okhlopkov
Associate Director, Private Equity
Discuss with Andrei Okhlopkov!
Follow 232
BioHello and thank you for stopping by my Channel!Here you will find tips and advice in the areas of:- Financial modeling- Business Analytics- Sensitivity Analysis- Statistics in Excel- Charts and Dashboards- VBA programming- Excel fundamentalsContact me if you need more help than what you found here. Please also let me know if you have a particular request or if there is anything specific you would like to read about.
Tags
Social
Categories
Sensitivity Analysis
Financial Modeling
Budgeting Excel
KPI Dashboards
Pricing
Startup Cap Tables
Excel
Excel VBA
Variance Analysis
Scenario Analysis
Human Resources
Statistical
Financial Forecasting Models
Inventory Management
Real Estate Financials
Due Diligence
Break-Even Analysis
Monte Carlo Simulation
Debt Schedule
Waterfall Charts
Private Equity
Unlocking Full Potential of Excel Data Tables (Part 2)
This is a sequel to my 'Unlocking Full Potential of Excel Data Tables (Part 1)' publication1,258Discussadd_shopping_cart$15.00Inventory Analysis and Management
Inventory balance movements, days inventory outstanding (DIO), turnover, seasonality, aging analysis, planning orders6653add_shopping_cart$25.00Van Westendorp’s Pricing Method
Determines optimal and acceptable price points, plots demand curves, estimates revenue maximisation points361Discussadd_shopping_cart$12.00Price-Volume-Mix Analysis
A comprehensive full-scope model to analyse revenue and profit changes1,586Discussadd_shopping_cart$50.00Measuring and Modeling Seasonality
A set of very practical tools to analyse seasonal fluctuations343Discussadd_shopping_cart$25.00Cost-Volume-Profit (Breakeven) Analysis
A template to perform cost-volume-profit (CVP, or breakeven) analysis621Discussadd_shopping_cartfreeDescriptive statistics for grouped (weighted) data
Calculating key statistics measures (average, median, standard deviation, skewness etc.) for grouped or weighted data1,403Discussadd_shopping_cartfreeStartup Cap Table
Multiple round cap table with investor returns709Discussadd_shopping_cartfreeMonte Carlo Analysis (without macros) Excel Model
This post explains how to run full Monte Carlo analysis in Excel without macros4,5064add_shopping_cartfreeUnlocking Full Potential of Excel Data Tables (Part 1)
This publication explains an advanced method of using data tables for sensitivity analysis in financial models7,078Discussadd_shopping_cartfreeArray Formulas in Excel
Explains array formulas and shows how they can be used in financial analysis3,815Discussadd_shopping_cartfreeAnalysing data in Excel
A set of techniques for working with data in Excel2,260Discussadd_shopping_cartfreeAnalyzing Sales and Product Performance
Tools to analyse sales, portfolio performance, seasonal variations, price-volume-mix factors1,133Discussadd_shopping_cart$19.00Guiding principles of Financial Modelling
The publication explains the general principles of building financial models with practical examples5,054Discussadd_shopping_cartfreeCharts and Dashboards in Excel (short version)
Explains the basics of building professional quality charts in Excel991Discussadd_shopping_cartfreeControlling Outlook from Excel (short version)
Connecting Excel to Outlook programmatically1,356Discussadd_shopping_cartfreeSensitivity analysis Excel Model with indifference curves
An Excel utility to draw indifference curves for two inputs in a financial model2,0821add_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,938Discussadd_shopping_cartfreeForm Controls and Other Interactive Tools in Excel
An overview of form controls, ActiveX controls and hyperlinks used in financial models.2,5432add_shopping_cartfreeVBA Interface Collection (demo version)
A set of Excel VBA macros aimed at enhancing user interface963Discussadd_shopping_cartfreeCapex Budget
A professional template to budget investing cashflow, fixed asset book values and depreciation321Discussadd_shopping_cart$20.00Loan Schedule
A flexible tool to calculate loan balances and accrued interest271Discussadd_shopping_cart$10.00Profit Distribution and Carried Interest Waterfall
A template illustrating various setups of profit distribution between the JV partners with a carried interest waterfall1,2502add_shopping_cart$30.00Due Diligence Tools and Methods
A suite of best practices to perform financial and commercial due diligence652Discussadd_shopping_cart$150.00Cap Table with Derivative Instruments, Investor Returns and Charts
Advanced multiple round startup cap table99Discussadd_shopping_cart$35.00Stacking Plan
Stacking plan of an office building241Discussadd_shopping_cart$9.00“Budget-versus-Actual” Charts
A collection of elegant charts and dashboards depicting variances790Discussadd_shopping_cart$25.00Interim Budgeting (Reforecasting)
Tools to depict the mid-year status, estimate if the outlook looks reasonable and assess the accuracy of past forecasts325Discussadd_shopping_cart$20.00Cap Table with Investor Returns and Charts
Cap table with 5 investment rounds for up to 10 investors405Discussadd_shopping_cart$25.00Sensitivity analysis Excel Model with indifference curves (unlocked)
An Excel utility (unlocked) to draw indifference curves for two inputs in a financial model411Discussadd_shopping_cart$15.00Horizontal Waterfall Chart
A smart and efficient chart with detailed step-by-step instructions287Discussadd_shopping_cart$7.00Price Position Analysis
Methods and tools to analyze product price positioning against the competition415Discussadd_shopping_cart$15.00Controlling Outlook from Excel (full version)
Connecting Excel to Outlook programmatically319Discussadd_shopping_cart$25.00HR Analytics and Dashboard
A collection of tools to perform employee analysis and visualize the results211Discussadd_shopping_cart$25.00Charts and Dashboards in Excel (full version)
Explains the basics of designing professional charts in Excel with practical examples (full version)376Discussadd_shopping_cart$20.00VBA Interface Collection (full version)
A set of Excel VBA macros aimed at enhancing user interface271Discussadd_shopping_cart$25.00Payroll Budget
A professional template to budget payroll expenses232Discussadd_shopping_cart$20.00A Chart Showing Three Dimensions of Data
A professionally-designed chart which can show data in three measurements83Discussadd_shopping_cart$5.00Travel Budget
A professional template to budget travel expenses81Discussadd_shopping_cart$15.00
Eloquens Member