
Last version published: 06/01/2021 15:12
Publication number: ELQ-68158-4
View all versions & Certificate

Guiding principles of Financial Modelling
The publication explains the general principles of building financial models with practical examples
Further information
To provide general guidance as to how financial models and other types of reports should be developed
Almost all financial modelling and analysis situations
n/a
Reviews
4.7 / 5 (103 votes)- 78%
- 15%
- 5%
- 2%
- 1%
Write a review
People using this Best Practice also downloaded
More Best Practices from Andrei Okhlopkov
Unlocking Full Potential of Excel Data Tables (Part 2)
This is a sequel to my 'Unlocking Full Potential of Excel Data Tables (Part 1)' publication1,048Discussadd_shopping_cart$15.00by Andrei Okhlopkov
Profit Distribution and Carried Interest Waterfall
A template illustrating various setups of profit distribution between the JV partners with a carried interest waterfall5942add_shopping_cart$30.00by Andrei Okhlopkov
Price-Volume-Mix Analysis
Tools and methods to calculate and depict price-volume-mix effects and other variances558Discussadd_shopping_cart$39.00by Andrei Okhlopkov
Inventory Analysis and Management
Inventory balance movements, days inventory outstanding (DIO), turnover, seasonality, aging analysis, planning orders262Discussadd_shopping_cart$20.00by Andrei Okhlopkov
Due Diligence Tools and Methods
A suite of best practices to perform financial and commercial due diligence390Discussadd_shopping_cart$100.00by Andrei Okhlopkov
Analyzing Sales and Product Performance
Tools to analyse sales, portfolio performance, seasonal variations, price-volume-mix factors998Discussadd_shopping_cart$19.00by Andrei Okhlopkov
Horizontal Waterfall Chart
A smart and efficient chart with detailed step-by-step instructions90Discussadd_shopping_cart$7.00by Andrei Okhlopkov
Cap Table with Investor Returns and Charts
Cap table with 5 investment rounds for up to 10 investors143Discussadd_shopping_cart$25.00by Andrei Okhlopkov
Controlling Outlook from Excel (full version)
Explains how to programmatically link Excel to Outlook181Discussadd_shopping_cart$15.00by Andrei Okhlopkov
Interim Budgeting (Reforecasting)
Tools to depict the mid-year status, estimate if the outlook looks reasonable and assess the accuracy of past forecasts264Discussadd_shopping_cart$20.00by Andrei Okhlopkov
Van Westendorp’s Pricing Method
Determines optimal and acceptable price points, plots demand curves, estimates revenue maximisation points157Discussadd_shopping_cart$12.00by Andrei Okhlopkov
Charts and Dashboards in Excel (full version)
Explains the basics of designing professional charts in Excel with practical examples (full version)315Discussadd_shopping_cart$20.00by Andrei Okhlopkov
Any questions on Guiding Principles Of Financial Modelling?
The user community and author are here to help. Go ahead!