Last version published: 19/04/2020 08:23
Publication number: ELQ-68158-3
View all versions & Certificate
Guiding principles of Financial Modelling
The publication explains the general principles of building financial models with practical examples
Andrei Okhlopkov offers you this Best Practice for free!
download for free
Add to bookmarks
To provide general guidance as to how financial models and other types of reports should be developed
Almost all financial modelling and analysis situations
4.6 / 5 (74 votes)
Write a review
- Usefull tips & tricks
- Good summary!
People using this Best Practice also downloaded
Unlocking Full Potential of Excel Data Tables (Part 2)This is a sequel to my 'Unlocking Full Potential of Excel Data Tables (Part 1)' publication774add_shopping_cart
Profit Distribution ModelA template illustrating various setups of profit distribution between the JV partners with a carried interest waterfall149add_shopping_cart$30.00by Andrei Okhlopkov
VBA Interface Collection (full version)A set of Excel VBA macros aimed at enhancing user interface118add_shopping_cart
Controlling Outlook from Excel (full version)Explains how to programmatically link Excel to Outlook120add_shopping_cart
Analyzing Sales and Product PerformanceA set of practical tools to describe, analyze and forecast a company’s sales, profitability and portfolio performance754add_shopping_cart
Sensitivity analysis Excel Model with indifference curves (unlocked)An Excel utility (unlocked) to draw indifference curves for two inputs in a financial model229add_shopping_cart$10.00by Andrei Okhlopkov
Charts and Dashboards in Excel (full version)Explains the basics of designing professional charts in Excel with practical examples (full version)259add_shopping_cart
A Chart Showing Three Dimensions of DataA professionally-designed chart which can show data in three measurements23add_shopping_cart$5.00by Andrei Okhlopkov
Horizontal Waterfall ChartA smart and efficient chart with detailed step-by-step instructions21add_shopping_cart$7.00by Andrei Okhlopkov
Form Controls and Other Interactive Tools in ExcelAn overview of form controls, ActiveX controls and hyperlinks used in financial models.1,853add_shopping_cart
Dates and Timelines in Excel Financial ModelsFinancial models use dates and timelines very extensively, so it is important to become familiar with relevant functions1,541add_shopping_cart
Unlocking Full Potential of Excel Data Tables (Part 1)This publication explains an advanced method of using data tables for sensitivity analysis in financial models5,452add_shopping_cart
Any questions on Guiding Principles Of Financial Modelling?
The user community and author are here to help. Go ahead!