Learn how to apply a managed model development process:

• Define the aims of a financial model
• Incorporate stakeholders’ requirements into financial models
• Find out why it is essential to follow a defined model development process
• Understand the six stages of model development
• Define model outputs and design a summary dashboard

Use best-practice standards in your financial models:

• Find out what ‘best practice’ is and why it is important
• Learn the 10 golden rules for best practice modelling

Learn professional and efficient model construction set-up:

• Learn file management and naming conventions
• Understand custom number and date formats, conditional formatting, and how to save styles
• Modify the colour palette and integrate corporate colours
• Develop a template sheet and timeline
• Schedule events using timing flags
• Integrate financial statements
• Implement model checks

Develop and manage operations calculations:

• Develop operations calculations, considerations and logic structure
• Apply indexations and escalations
• Model working capital and the cash flow implications
• Use control accounts for accurate and efficient model construction

Create flexible CAPEX profiles:

• Create flexible construction profiles, including the development of S-curves
• Learn how to manage finances during construction
• Analyse the impacts of delays, overspends and phasing changes
• Understand how to model depreciation efficiently

Efficient modelling of debt facilities and ratios:

• Refinance a construction debt facility
• Model debt facilities – interest and multiple principal payment mechanisms
• Model flexible timing, interest only periods, commitment fees
• Understand the theory and modelling of debt coverage ratios (DCRs)
• Understand modelling reserve accounts and lockups

Considerations and modelling for tax:

• Understand the pitfalls and complexities of modelling tax
• Handle timing differences using deferred tax assets and liabilities
• Model carried-forward tax losses

Scenario and sensitivity development and management:

• Learn how to develop a scenario manager
• Define and run sensitivity tests
• Use data tables to assist with multi-scenario and sensitivity presentation

Ensure quality, reduce errors and manage risk:

• Learn quality control techniques, including final testing and peer review
• Manage handover and issuing models to third parties
• Learn about including disclaimers in models

Methodologies, techniques and application of valuation:

• Receive an introduction to the CAPM model and assessment of business risks
• Get an overview of corporate and assets valuation methodologies
• Determine discounts rates and WACC
• Use P/E, EV/EBITDA multiples for valuation and understand their benefits and drawbacks

Options for investment appraisal analysis and their application:

• Calculate project and equity values, internal rates of return (IRR), yields and payback periods
• Learn the Excel functions for investment analysis and the functions’ potential pitfalls