Avatar

The Shop of Vendor Andrei Okhlopkov

Hello and thank you for stopping by my page!I am sharing tips and advice in the areas of:- Financial modeling - Business Analytics - Sensitivity Analysis - Statistics in Excel - Charts and Dashboards - VBA programming - General Excel mattersContact me if you need more help than what you found here.

A traditional sensitivity analysis involves testing a limited number of scenarios (e.g. base, upside and downside). The Monte Carlo method…

The abilities of data tables stretch far beyond conventional one- or two-dimensional tables. In the attached files I have collected…

Add to wish list
Purchase Excluding 7.7% tax

This publication contains a set of very practical tools to describe, analyze, and forecast a company’s sales, profitability and portfolio…

Add to wish list
$20.00 – Purchase Excluding 7.7% tax

Many businesses are affected by seasonal demand changes. They cause their revenues, expenses, and resource requirements change through the year.…

Add to wish list
$25.00 – Purchase Excluding 7.7% tax

Virtually every company develops its annual budgets. The budgets are compiled before the beginning of the financial year of a…

Add to wish list
$20.00 – Purchase Excluding 7.7% tax

In this publication, I discuss how to analyze inventory: balance movements, days inventory outstanding, turnover, seasonality, aging, planning orders.

Add to wish list
$20.00 – Purchase Excluding 7.7% tax

A template illustrating various setups of profit distribution between the JV partners. Includes a carried interest waterfall.

Add to wish list
$30.00 – Purchase Excluding 7.7% tax

This set of tools, methods and techniques will help you calculate and depict variances. A special focus is made on…

Add to wish list
$39.00 – Purchase Excluding 7.7% tax