Templates by Andrei Okhlopkov

1 to 16 of 33 Results
Guiding Principles of Financial Modelling Guiding Principles of Financial Modelling
(0)
8,168
1196
This is an attempt to list and explain the key concepts of developing financial models (also applicable to any other…
Charts and Dashboards in Excel (short version) Charts and Dashboards in Excel (short version)
(0)
7,871
796
Very few people think of Excel as being able to produce professional-quality business charts. But this is true - Excel…
Analysing data in Excel Analysing data in Excel
(0)
8,784
800
In this post I have collected a handful of techniques for working with data in Excel: looking up values, matching…
Monte Carlo analysis without macros Monte Carlo analysis without macros
(0)
7,874
762
A traditional sensitivity analysis involves testing a limited number of scenarios (e.g. base, upside and downside). Each scenario is a…
Unlocking Full Potential of Excel Data Tables (Part 1) Unlocking Full Potential of Excel Data Tables (Part 1)
(0)
7,358
694
Data tables is a powerful tool to analyze sensitivities in Excel financial models. A conventional data table is a one-…
Array Formulas in Excel Array Formulas in Excel
(0)
4,150
581
My publication on this obscure to the many yet a useful and powerful feature of Excel shows how array formulas…
Analysing sensitivities with indifference curves Analysing sensitivities with indifference curves
(0)
6,321
559
Indifference curves depict sensitivity of an output to the two inputs. Each curve corresponds to a fixed output amount and…
Form Controls and Other Interactive Tools Form Controls and Other Interactive Tools
(0)
7,013
533
This is an overview of check boxes, option buttons, drop-down lists and similar fancy things commonly referred to as Form…
Dates and Timelines in Excel Dates and Timelines in Excel
(0)
6,042
438
In this post we will look at: a) Extending or shortening time schedules b) Modelling interest expense c) Planning orders,…
Descriptive statistics for grouped (weighted) data Descriptive statistics for grouped (weighted) data
(0)
5,561
270
Excel has a powerful set of tools to perform statistical analysis, but they apply only to ungrouped data. As an…
Startup Cap Table Startup Cap Table
(0)
2,530
202
Most startups are initially financed by their founders. They contribute relatively small amounts of money for the company to make…
Cost-Volume-Profit (Breakeven) Analysis Cost-Volume-Profit (Breakeven) Analysis
(0)
2,728
195
Cost-Volume-Profit analysis is one of the fundamental types of analysis which deals with product profitability. It classifies the costs into…
Profit Distribution and Carried Interest Waterfall Profit Distribution and Carried Interest Waterfall
(0)
6,450
29
This template describes real-world mechanisms of distributing profits between project participants. It starts with modeling a distribution to a preferred…
“Budget-versus-Actual” Charts “Budget-versus-Actual” Charts
(0)
2,435
12
This file contains magazine-quality charts in Excel to illustrate variances between budgeted and actual figures.  Professionally designed charts in business…
Due Diligence Tools and Methods Due Diligence Tools and Methods
(0)
3,219
11
A prospective investor is concerned about the target’s: 1. Quality of earnings 2. Adequacy of working capital 3. Unrecorded or…
Charts and Dashboards in Excel (full version) Charts and Dashboards in Excel (full version)
(0)
7,120
9
Very few people think of Excel as being able to produce professional-quality business charts. But this is true - Excel…