Templates by Andrei Okhlopkov

1 to 16 of 17 Results
Guiding Principles of Financial Modelling Guiding Principles of Financial Modelling
(0)
3,117
415
This is an attempt to list and explain the key concepts of developing financial models (also applicable to any other…
Monte Carlo analysis without macros Monte Carlo analysis without macros
(0)
2,425
329
A traditional sensitivity analysis involves testing a limited number of scenarios (e.g. base, upside and downside). Each scenario is a…
Charts and Dashboards in Excel (short version) Charts and Dashboards in Excel (short version)
(0)
2,416
332
Very few people think of Excel as being able to produce professional-quality business charts. But this is true - Excel…
Unlocking Full Potential of Excel Data Tables (Part 1) Unlocking Full Potential of Excel Data Tables (Part 1)
(0)
2,470
321
Data tables is a powerful tool to analyze sensitivities in Excel financial models. A conventional data table is a one-…
Analysing data in Excel Analysing data in Excel
(0)
3,294
304
In this post I have collected a handful of techniques for working with data in Excel: looking up values, matching…
Form Controls and Other Interactive Tools Form Controls and Other Interactive Tools
(0)
2,353
258
This is an overview of check boxes, option buttons, drop-down lists and similar fancy things commonly referred to as Form…
Analysing sensitivities with indifference curves Analysing sensitivities with indifference curves
(0)
1,906
240
Indifference curves depict sensitivity of an output to the two inputs. Each curve corresponds to a fixed output amount and…
Dates and Timelines in Excel Dates and Timelines in Excel
(0)
1,921
182
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)
1,000
83
Excel has a powerful set of tools to perform statistical analysis, but they apply only to ungrouped data. As an…
Charts and Dashboards in Excel (full version) Charts and Dashboards in Excel (full version)
(0)
2,185
5
Very few people think of Excel as being able to produce professional-quality business charts. But this is true - Excel…
Unlocking Full Potential of Excel Data Tables (Part 2) Unlocking Full Potential of Excel Data Tables (Part 2)
(0)
2,556
3
This is the second part of my publication explaining an advanced and little-known method of using data tables for sensitivity…
Analyzing Sales and Product Performance Analyzing Sales and Product Performance
(0)
2,649
2
This publication contains a set of very practical tools to describe, analyze and forecast a company’s sales, profitability and portfolio…
Price-Volume-Mix Analysis Price-Volume-Mix Analysis
(0)
172
1
This set of tools, methods and techniques will help you calculate and depict variances. A special focus is made on…
Interim Budgeting (Reforecasting) Interim Budgeting (Reforecasting)
(0)
565
1
Virtually every company develops its annual budgets. The budgets are compiled before the beginning of the financial year of a…
Analysing sensitivities with indifference curves (unlocked) Analysing sensitivities with indifference curves (unlocked)
(0)
2,076
1
This is an unlocked version of the same utility published on my page. In this version you can access and…
Measuring and Modelling Seasonality Measuring and Modelling Seasonality
(0)
301
0
Many businesses are affected by seasonal demand changes. They cause their revenues, expenses and resource requirements change through the year.…