Templates by Andrei Okhlopkov

This is an attempt to list and explain the key concepts of developing financial models (also applicable to any other…

In this post I have collected a handful of techniques for working with data in Excel: looking up values, matching…

Very few people think of Excel as being able to produce professional-quality business charts. But this is true - Excel…

A traditional sensitivity analysis involves testing a limited number of scenarios (e.g. base, upside and downside). Each scenario is a…

My publication on this obscure to the many yet a useful and powerful feature of Excel shows how array formulas…

Data tables are a powerful tool to analyze sensitivities in Excel financial models. A conventional data table is a one-…

Indifference curves depict sensitivity of an output to the two inputs. Each curve corresponds to a fixed output amount and…

This is an overview of check boxes, option buttons, drop-down lists and similar fancy things commonly referred to as Form…

In this post we will look at: a) Extending or shortening time schedules b) Modelling interest expense c) Planning orders,…

Most startups are initially financed by their founders. They contribute relatively small amounts of money for the company to make…

Excel has a powerful set of tools to perform statistical analysis, but they apply only to ungrouped data. As an…

Cost-Volume-Profit analysis is one of the fundamental types of analysis which deals with product profitability. It classifies the costs into…

This template describes real-world mechanisms of distributing profits between project participants. It starts with modeling a distribution to a preferred…

A prospective investor is concerned about the target’s: 1. Quality of earnings 2. Adequacy of working capital 3. Unrecorded or…

This file contains magazine-quality charts in Excel to illustrate variances between budgeted and actual figures.  Professionally designed charts in business…

Most startups are initially financed by their founders. They contribute relatively small amounts of money for the company to make…