Refine Your Search
...
...
This three-day Financial Modelling course equips participants with advanced skills in building and analyzing financial models, emphasizing best practices. It begins with the 8 principles of modelling best practice, covering topics like consistent timelines, formulae, circular references, and macros. The curriculum includes sessions on Model Design and Planning, exploring model types, valuation, transaction structuring, and data manipulation. Participants will engage in practical exercises, constructing models, handling complex calculations like IRR and NPV, and conducting scenario analyses. This course is essential for professionals seeking to enhance their financial modelling and decision-making skills.
This three-day Financial Modelling course equips participants with advanced skills in building and analyzing financial models, emphasizing best practices. It begins with the 8 principles of modelling best practice, covering topics like consistent timelines, formulae, circular references, and macros. The curriculum includes sessions on Model Design and Planning, exploring model types, valuation, transaction structuring, and data manipulation. Participants will engage in practical exercises, constructing models, handling complex calculations like IRR and NPV, and conducting scenario analyses. This course is essential for professionals seeking to enhance their financial modelling and decision-making skills.
Banking
Capital Market
Insurance
Financing
Banking Operations
Accounting and Finance
Not Exist
Other
Other
Purchase Program
( 0)Available
To preview individual and groups discount policy, Click Here
This provides you with the opportunity to select the available times that suit you best for participation in our program. These times represent slots during which we are ready to welcome you and provide assistance and guidance.
In Class Training-Online Training
Identifying the purpose and mode of use of the model
Designing the Analysis worksheet
Planning the logic flow and the interface of the worksheets
What causes models to be slow
Actions to speed up models that are slow
In Class Training-Online Training
Valuation
Transaction structuring
Statistical probability
Data manipulation
In Class Training-Online Training
Purpose of Financial Models
Central Role of the Analysis Worksheet
Functionality of the Analysis Worksheet
Identifying properly built models
Performs sensitivity analysis, scenario analysis, and break-even analysis
In Class Training-Online Training
Grouping worksheets
Establishing a master timeline
Deploying the timeline across all worksheets
Creating flags and masks
Data validation
Using Excel features and formulas
In Class Training-Online Training
Revenue: Volume and pricing drivers
Operating Costs
Depreciation
Generic valuation models
Common Errors in Valuation Models
In Class Training-Online Training
Sensitivity analysis
Breakeven analysis
Scenario Analysis
In Class Training-Online Training
Importance of model accuracy
Model review process
The recommended layout in structured finance models
Shortcuts for assessing a model's architecture
Use of audit software
Tracing the logic flow
In Class Training-Online Training
Common errors in calculating IRRs and NPVs
Defects of the IRR function
Limitations of XIRR in corporate and project finance models
Risks associated with the MIRR function
Practical 3: Implementing IRR calculation
Practical 4: Implementing NPV calculation
In Class Training-Online Training
Overview of various financing structures and their modeling techniques
Accurate interest expense modelling
Practical 5: Annuity-based financing model
Practical 6: Straightline amortization model
5. Practical 7: Sculpting amortization to DSCR
Practical 8: Inserting cash sweeps
Practical 9: Sculpting to LLCR
In Class Training-Online Training
Operating leverage
Importance of cost structure in volatility
Types of Cost Structures
Key Cost Item Properties
Module 10: Volatility Modelling
In Class Training-Online Training
Review of key elements in project financing
Project Finance Model Layout
The Construction Worksheet
In Class Training-Online Training
Cost overruns
Delays
Variation orders
Staged payments
Maintenance and refurbishment cycle
Liquidated damages
Performance bonds
Retentions
Multiple tranche drawdowns
Interest during construction
In Class Training-Online Training
In Class Training-Online Training
The Structure and Implementation of Private Equity Funds
The Typical Financing Structures
3. Practical 11 – implementing a cashflow waterfall
In Class Training-Online Training
10-Stage Analytical Process in Acquisitions
Debt Capacity Calculations
Managing Volatility and Scenarios
Cashflow vs. Financial Statements
Pricing Models: Common errors and appropriate comparators
Pro Forma Consolidation
7. Practical 12: Implementing debt capacity calculations
In Class Training-Online Training
Rapid debugging tips for completed models
Developing models with multiple timelines
Managing currency exposures and risks
Implementing scenarios
Building dynamic graphs
Recognize the eight principles of best practices in financial modelling to enhance professional competencies in the financial sector
Acquire skills in designing analytical worksheets, planning logical data flows, and interfaces to improve flexibility and efficiently handle variable inputs
Precisely analyse various types of financial models
Effectively apply practical skills in preparing and constructing financial models
Conduct sensitivity analysis, scenarios, and perform break-even analysis to
