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 Chart Showing Three Dimensions of Data
A professionally-designed chart which can show data in three measurements
Complete Private Equity (LBO) Financial Model
This is a professional financial model which performs a thorough…
Income Statement and Cash Flow Bridge Chart
A smart visual tool which walks you from sales revenues…
Real Estate Development Financial Model
A professional model for real estate construction (build – hold…
Real Estate Acquisition Financial Model
A professional model for real estate acquisition (buy – hold…
Short-term Rental (Airbnb) Financial Model
A professional model for residential property acquisition, renovation and short-term…
Retail Property Development Financial Model
A professional model for retail property construction (build – hold…
Retail Property Acquisition Financial Model
A professional model for retail property acquisition (buy – hold…
Residential “Build & Sell” Financial Model
A professional model for residential property construction (build & sell)
Residential “Build-Hold-Sell” Financial Model
A professional model for residential property construction (build – hold…
Warehouse Acquisition Financial Model
A professional model for warehouse (industrial building) acquisition (buy –…
Warehouse Development Financial Model
A professional model for warehouse (industrial building) construction (build –…
Rent Roll Analysis Excel Template
Analysis of existing and prospective tenants and their lease conditions…
Complete Three-Statement Monthly Budget with Scenarios
A fundamental and professional budget / business plan
Complete Three-Statement Quarterly Budget with Scenarios
A fundamental and professional budget / business plan
Marketing Budget Excel Template
A professional template to budget marketing, advertising and promotion expenses
Analyzing Sensitivities with Indifference Curves
An Excel utility to draw indifference curves for two inputs…
Controlling Outlook From Excel
This post contains examples of connecting Excel to Outlook programmatically.…
Cost-Volume-Profit (Breakeven) Analysis
A template to perform cost-volume-profit (CVP, or breakeven) analysis
Custom Financial Modeling Services – Andrei
Professional financial modeling and business analysis services
Form Controls and Other Interactive Tools in Excel
This publication explains how to add interactivity to your models…
Van Westendorp’s Pricing Method
Determines optimal and acceptable price points, plots demand curves, estimates…
Descriptive Statistics for Grouped (Weighted) Data
Excel has a powerful set of tools to perform statistical…
Monte Carlo Analysis in Excel without Macros
This is downloadable for FREE! Traditional sensitivity analysis involves testing…
Unlocking Full Potential Of Excel Data Tables
This publication explains advanced methods of using data tables for…
Analyzing Sales and Product Performance Tracking
This publication contains a set of very practical tools to…