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 professionally-designed chart which can show data in three measurements

Add to wish list
Excluding 8.1% tax

This is a professional financial model which performs a thorough…

Add to wish list
Excluding 8.1% tax

A smart visual tool which walks you from sales revenues…

Add to wish list
Excluding 8.1% tax

An easy to use tool to calculate future funding requirements…

Add to wish list
Excluding 8.1% tax

A chart to create a project schedule and to monitor…

Add to wish list

A professional model for real estate construction (build – hold…

Add to wish list
Excluding 8.1% tax

A professional model for real estate acquisition (buy – hold…

Add to wish list
Excluding 8.1% tax

A professional model for residential property acquisition, renovation and short-term…

Add to wish list
Excluding 8.1% tax

A professional model for retail property construction (build – hold…

Add to wish list
Excluding 8.1% tax

A professional model for retail property acquisition (buy – hold…

Add to wish list
Excluding 8.1% tax

A professional model for residential property construction (build & sell)

Add to wish list
Excluding 8.1% tax

A professional model for residential property construction (build – hold…

Add to wish list
Excluding 8.1% tax

A professional model for warehouse (industrial building) acquisition (buy –…

Add to wish list
Excluding 8.1% tax

A professional model for warehouse (industrial building) construction (build –…

Add to wish list
Excluding 8.1% tax

A professional model for office construction

Add to wish list
Excluding 8.1% tax

A professional model for office acquisition

Add to wish list
Excluding 8.1% tax

A professional model for hotel construction

Add to wish list
Excluding 8.1% tax

A professional model for hotel acquisition

Add to wish list
Excluding 8.1% tax

Analysis of existing and prospective tenants and their lease conditions…

Add to wish list
Excluding 8.1% tax

A fundamental and professional budget / business plan

Add to wish list
Excluding 8.1% tax

A fundamental and professional budget / business plan

Add to wish list
Excluding 8.1% tax

A fundamental and professional budget / business plan

Add to wish list
Excluding 8.1% tax

A fundamental and professional budget / business plan

Add to wish list
Excluding 8.1% tax

A professional template to budget marketing, advertising and promotion expenses

Add to wish list
Excluding 8.1% tax

A flexible tool to calculate loan balances and accrued interest

Add to wish list
Excluding 8.1% tax

Average rating:

Core principles of building financial models

Add to wish list

A professional template to budget investing cashflow, fixed asset book…

Add to wish list
Excluding 8.1% tax

A professional template to budget payroll expenses

Add to wish list
Excluding 8.1% tax

A professional template to budget travel expenses

Add to wish list
Excluding 8.1% tax

A collection of tools to perform employee analysis and visualize…

Add to wish list
Excluding 8.1% tax

An Excel utility to draw indifference curves for two inputs…

Add to wish list
Excluding 8.1% tax

This post contains examples of connecting Excel to Outlook programmatically.…

Add to wish list
Excluding 8.1% tax

A template to perform cost-volume-profit (CVP, or breakeven) analysis

Add to wish list

A collection of elegant charts and dashboards depicting variances

Add to wish list
Excluding 8.1% tax

Professional financial modeling and business analysis services

  •  x 
  •  x 
  •  x 
Add to wish list
Excluding 8.1% tax

This publication explains how to add interactivity to your models…

Add to wish list

Average rating:

A suite of best practices to perform financial and commercial…

Add to wish list
Excluding 8.1% tax

Determines optimal and acceptable price points, plots demand curves, estimates…

Add to wish list
Excluding 8.1% tax

A stacking plan is a two-dimensional chart displaying the arrangement…

Add to wish list
Excluding 8.1% tax

A cap table for up to five investment rounds and…

Add to wish list
Excluding 8.1% tax

Explains array formulas and shows how they can be used…

Add to wish list

In this post I have collected a handful of techniques…

Add to wish list

Excel has a powerful set of tools to perform statistical…

Add to wish list

Every business needs to know how the prices of its…

Add to wish list
Excluding 8.1% tax

Creating professionally designed magazine-quality charts in Excel.

Add to wish list
Excluding 8.1% tax

This is downloadable for FREE! Traditional sensitivity analysis involves testing…

Add to wish list

This publication explains advanced methods of using data tables for…

Add to wish list
Excluding 8.1% tax

This publication contains a set of very practical tools to…

Add to wish list
Excluding 8.1% tax