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.
At the end of the training program, the participant should be able to:
1 Identifying the purpose and mode of use of the model
2 Designing the Analysis worksheet
3 Planning the logic flow and the interface of the worksheets
4 What causes models to be slow
5 Actions to speed up models that are slow
1 Valuation
2 Transaction structuring
3 Statistical probability
4 Data manipulation
1 Purpose of Financial Models
2 Central Role of the Analysis Worksheet
3 Functionality of the Analysis Worksheet
4 Identifying properly built models
5 Performs sensitivity analysis, scenario analysis, and break-even analysis
1 Grouping worksheets
2 Establishing a master timeline
3 Deploying the timeline across all worksheets
4 Creating flags and masks
5 Data validation
6 Using Excel features and formulas
1 Revenue: Volume and pricing drivers
2 Operating Costs
3 Depreciation
4 Generic valuation models
5 Common Errors in Valuation Models
1 Sensitivity analysis
2 Breakeven analysis
3 Scenario Analysis
1 Importance of model accuracy
2 Model review process
3 The recommended layout in structured finance models
4 Shortcuts for assessing a model's architecture
5 Use of audit software
6 Tracing the logic flow
1 Common errors in calculating IRRs and NPVs
2 Defects of the IRR function
3 Limitations of XIRR in corporate and project finance models
4 Risks associated with the MIRR function
5 Practical 3: Implementing IRR calculation
6 Practical 4: Implementing NPV calculation
1 Overview of various financing structures and their modeling techniques
2 Accurate interest expense modelling
3 Practical 5: Annuity-based financing model
4 Practical 6: Straightline amortization model
5 5. Practical 7: Sculpting amortization to DSCR
6 Practical 8: Inserting cash sweeps
7 Practical 9: Sculpting to LLCR
1 Operating leverage
2 Importance of cost structure in volatility
3 Types of Cost Structures
4 Key Cost Item Properties
5 Module 10: Volatility Modelling
1 Review of key elements in project financing
2 Project Finance Model Layout
3 The Construction Worksheet
1 Cost overruns
2 Delays
3 Variation orders
4 Staged payments
5 Maintenance and refurbishment cycle
6 Liquidated damages
7 Performance bonds
8 Retentions
9 Multiple tranche drawdowns
10 Interest during construction
1 The Structure and Implementation of Private Equity Funds
2 The Typical Financing Structures
3 3. Practical 11 – implementing a cashflow waterfall
1 10-Stage Analytical Process in Acquisitions
2 Debt Capacity Calculations
3 Managing Volatility and Scenarios
4 Cashflow vs. Financial Statements
5 Pricing Models: Common errors and appropriate comparators
6 Pro Forma Consolidation
7 7. Practical 12: Implementing debt capacity calculations
1 Rapid debugging tips for completed models
2 Developing models with multiple timelines
3 Managing currency exposures and risks
4 Implementing scenarios
5 Building dynamic graphs
Not Available
Names of the training programs that are integrated (enriched) with the training program:
Names of the training programs that after the training program:
Add Comment