This is an attempt to list and explain the key concepts of developing financial models (also applicable to any other kinds of reports, budgets or forecasts). I am demonstrating how to structure a model, setup the timeline, format cells by their purpose, make scenarios, create checks and controls, use flags. The underlying Excel file contains a comprehensive demo model showing the most common working sheets (capex, funding, working capital, economic assumptions) and explaining how the income statement, balance sheet and cash flow statement are built and tied together.


The booklet and the Excel file also give specific examples which cause complexities to many analysts (circular calculations, proper demonstration of variances, calculating IRR and NPV with a few zero cashflow periods in the beginning etc.)


This publication is a work-in-constant-progress. Help me make it better – send me word what else you think I should add.

Reviews Add a review
No reviews yet

More From Andrei Okhlopkov

Browse our top rated business templates. See All
Price-Volume-Mix Analysis
This set of tools, methods and techniques will help you calculate and depict variances. A special focus is made on…
Measuring and Modelling Seasonality
Many businesses are affected by seasonal demand changes. They cause their revenues, expenses and resource requirements change through the year.…
Interim Budgeting (Reforecasting)
Virtually every company develops its annual budgets. The budgets are compiled before the beginning of the financial year of a…
Profit Distribution and Carried Interest Waterfall
This template describes real-world mechanisms of distributing profits between project participants. It starts with modeling a distribution to a preferred…
Descriptive statistics for grouped (weighted) data
Excel has a powerful set of tools to perform statistical analysis, but they apply only to ungrouped data. As an…
Dates and Timelines in Excel
In this post we will look at: a) Extending or shortening time schedules b) Modelling interest expense c) Planning orders,…
See All