Project Financial Modelling Masterclass

The programme

Programme overview

The Project Financial Modelling interactive and comprehensive Masterclass explores PPP, project finance, relevant financial modelling and PPP project management and utilises case studies and exercises to illustrate the theory in practice. Further topics covered include how to make a PPP project work; how to model the role of debt, debt covenants, cash waterfalls, inter-creditor relations, restructuring and rescheduling of debt; how to model risk and the role of equity and its potential rewards.

Delegates will gain a detailed understanding of project management, as well as a thorough background as to how project finance and PPP works, both from the strategic perspective of Government and from the standpoint of the numerous other participants, especially banks and the sponsors who are responsible for delivering the projects. With private finance increasingly being mobilised to deliver infrastructure projects in South Africa and the region, this Masterclass meets a real need. On completing the five-day Project Financial Modelling Masterclass, you will have built a fully functional financial model covering the period from the beginning of construction through to the end of the project’s operating period.

Who should attend

Who is this programme for?

• Chief Financial Officers and Finance Managers
• Project Officers and Project Managers
• Accountants and Business Managers
• Bank Relationship Managers and SME Officers
• Heads of Treasury and Chief Risk Officers
• Risk Managers and Auditors
• Professionals Who Need to Build, Modify, and Understand Financial Models Associated with Project Finance and Other Infrastructure-Related Transactions (Including PPP / PFI Projects)

Learning outcomes

What you will learn

• Understand how to put together a Project Finance transaction including the documentation required
• Apply analytical strategies to assess the degree of risk and benefits of specific project financing
• Read and understand project finance models built using best practice modelling standards, including how AI-assisted modelling tools are increasingly used to accelerate model construction and review
• Create a dynamic, 3-financial statement model from a zero-balance sheet position
• Apply your knowledge and understanding to the process of optimising a model to meet the requirements of key stakeholders in the project
• Develop a checklist with take-aways for immediate application at your institution

Explore the programme

Detailed programme outline

• What is Project Finance?
• How does Project Finance create value?
• Project evaluation
• Stages in the deal
• Industry players in Project Finance
• Role of government in Project Finance
• The growing role of green and sustainable infrastructure financing, including renewable energy and climate-resilient project structures, in the African project finance landscape
• Sources of funding, including green bonds and sustainability-linked financing instruments increasingly used in infrastructure projects
• Bank lending
• Project Finance Documentation
• Due diligence assessment and Risk
• Analysing Risks
• Introduction to the Case Study
• How to build a financial model
• Modelling standards
• Excel shortcut tricks
• AI-assisted modelling tools now used by project finance practitioners to accelerate model construction and support model review, alongside traditional Excel-based skills
• Recap on common modelling functions
• Increasing modelling productivity
• Timeline development
• Construction costs
• Construction funding
• Financing fees
• Revenue and operating costs
• Taxes
• Working capital
• CAPEX
• Debt financing
• Equity
• Dividends
• Cover ratios
• Debt sculpting
• Debt service reserve account
• Maintenance reserve account
• Revolver
• Shareholder loans
• Macros to break circularities
• NPV
• IRR
• Scenario Analysis
• Equity First Funding Method
• Debt Sizing Macros
• DSRA Macros
• Scenario Analysis automation

Learning approach

How you will learn

Our diverse instructional approaches ensure effective learning:

– Lectures & Presentations: Engage with expert-driven, stimulating content.– Course Material: Access well-crafted supporting resources.– Group Work: Collaborate on discussions and case studies for practical insights.– Workshops & Role-Play: Participate in immersive, scenario-based activities.– Practical Application: Focus on applying theoretical knowledge in real situations.– Post-Training Support: Receive extensive support after training for skill implementation.

Discuss your requirements

Dates, duration & arrangements

Contact Ratomac to confirm dates, duration, delivery format, entry requirements and any applicable assessment or certification before booking.