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
Hotel Acquisition Financial Model
348
0
This is a detailed, well-structured and transparent cash flow model for an acquisition of a hotel. The model includes the…
Hotel Development Financial Model
361
1
This is a detailed, well-structured and transparent cash flow model for the development of a hotel. The model includes the…
Rent Roll Analysis and Stacking Plan
1,939
2
I. RENT ROLLA rent roll is a table listing the tenants of a real estate asset, showing how much area…
Complete Three-Statement Quarterly Budget
2,015
1
This is a comprehensive set of templates which will help you build your budgets. The templates are built based on…
Complete Three-Statement Quarterly Budget with Scenarios
1,741
4
This is a comprehensive set of templates which will help you build your budgets. The templates are built based on…
Complete Three-Statement Monthly Budget
1,691
0
This is a comprehensive set of templates which will help you build your budgets. The templates are built based on…
See All