Andrei OkhlopkovAssociate Director, Private Equity Follow 244
- views 54k
- users 2.9k
- reviews 580
- Downloadable Best Practices 47
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,489Discussadd_shopping_cart$15.00Inventory Analysis and Management
Inventory balance movements, days inventory outstanding (DIO), turnover, seasonality, aging analysis, planning orders8653add_shopping_cart$25.00Van Westendorp’s Pricing Method
Determines optimal and acceptable price points, plots demand curves, estimates revenue maximisation points545Discussadd_shopping_cart$12.00Price-Volume-Mix Analysis
A comprehensive full-scope model to analyse revenue and profit changes1,947Discussadd_shopping_cart$50.00Measuring and Modeling Seasonality
A set of very practical tools to analyse seasonal fluctuations393Discussadd_shopping_cart$25.00VBA Interface Collection (full version)
A set of Excel VBA macros aimed at enhancing user interface320Discussadd_shopping_cart$25.00Payroll Budget
A professional template to budget payroll expenses301Discussadd_shopping_cart$20.00Descriptive statistics for grouped (weighted) data
Calculating key statistics measures (average, median, standard deviation, skewness etc.) for grouped or weighted data1,519Discussadd_shopping_cartfreeCost-Volume-Profit (Breakeven) Analysis
A template to perform cost-volume-profit (CVP, or breakeven) analysis733Discussadd_shopping_cartfreeMonte Carlo Analysis (without macros) Excel Model
This post explains how to run full Monte Carlo analysis in Excel without macros4,8134add_shopping_cartfreeArray Formulas in Excel
Explains array formulas and shows how they can be used in financial analysis3,894Discussadd_shopping_cartfreeStartup Cap Table
Multiple round cap table with investor returns951Discussadd_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 models8,003Discussadd_shopping_cartfreeAnalysing data in Excel
A set of techniques for working with data in Excel2,356Discussadd_shopping_cartfreeAnalyzing Sales and Product Performance
Tools to analyse sales, portfolio performance, seasonal variations, price-volume-mix factors1,237Discussadd_shopping_cart$19.00Charts and Dashboards in Excel (short version)
Explains the basics of building professional quality charts in Excel1,041Discussadd_shopping_cartfree
