Overview

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
Loan Schedule
313
3
This template will help you calculate loan and interest balances, accrued interest at any point in time on loans granted or issued.…
Capex Budget
527
1
 Any company which uses fixed assets in its operations needs to know:   Investment cash flow related to new fixed…
Payroll Budget
783
1
Payroll expenses and employee costs in general form an important and material part of a company’s budget. This template built on the highest…
Travel Budget
706
0
Travel expenses make up an important and material part of a company’s budget. This template built on the highest professional financial modeling…
HR Analytics and Dashboard
1,405
0
This publication contains a set of tools to perform employee analysis and communicate key statistics in a concise, efficient and…
Startup Cap Table
2,179
187
Most startups are initially financed by their founders. They contribute relatively small amounts of money for the company to make…
See All