In today’s dynamic economic climate, public-private partnerships are emerging as a key pillar for the development of innovative projects, particularly in emerging sectors such as renewable energy. The course ‘Financial Modelling for Public-Private Partnerships: Basic to Intermediate Level’ offers you a unique opportunity to delve into the world of financial modelling. You’ll learn everything from the basics of financial mathematics to creating formulas in Excel, all through practical case studies such as the development of a solar photovoltaic farm. This approach will enable you to understand the key stages involved in building an economic and financial model, as well as the principles of project finance. The growing demand for skilled professionals in this field, combined with the flexibility of online learning, makes this course a strategic investment in your professional future.
Financial Modelling for Public-Private Partnerships. Basic to intermediate level
Project Management
40 hours
Introduction
Objectives
- To understand the fundamentals of financial modelling and its practical application.
- Identify and analyse financial statements to evaluate investments.
- Use Excel functions and tools for financial modelling.
- Apply basic modelling concepts to photovoltaic projects.
- To understand the structure and contracts involved in project finance.
- Assessing debt levels and managing cash flow in projects.
- Create basic financial models for public-private partnership projects.
Table of Contents
TEACHING UNIT 1. INTRODUCTION TO MODELLING
Introduction to Modelling
An Introduction to Financial Mathematics
Financial statements
Analysing an investment
Financial statements – Supplementary financial years
TEACHING UNIT 2. BASIC CONCEPTS OF FINANCIAL MODELLING
Rules for constructing formulae
Excel: The most commonly used functions in financial modelling
Excel. The most commonly used tools in financial modelling
Excel. Explanation of macros
Shortcuts (keyboard shortcuts)
TEACHING UNIT 3. CONCEPTS FOR FINANCIAL MODELLING. CASE STUDY: PHOTOVOLTAIC PARK
Basic concepts of financial modelling
Key stages in the development of a financial economic model
Financial modelling case study: Photovoltaic solar park – Guide to setting up
Financial modelling case study: Photovoltaic solar park – Solution I
Financial modelling case study: Photovoltaic solar park – Solution II
TEACHING UNIT 4. INTRODUCTION TO PROJECT FINANCE
A brief explanation and introduction to project finance
Non-recourse financing
Main contracts for these projects
Cash flow for debt servicing
Debt levels