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
More related courses
Your questions answered
Why choose Educa.Pro?
Educa.Pro enables organisations to centralise training management, personalise learning and gain clear insights into the impact of training programmes. Thanks to its AI-powered technology, organisations can optimise their learning strategies, enhance talent development and make data-driven decisions.
Can the courses be taken at your own pace?
Yes. Most of the courses on Educa.Pro are self-paced and on-demand, allowing users to progress at their own pace without missing out on progress tracking or assessments, which makes it easier to fit them around work or study commitments.
What levels of security and compliance does the platform offer?
Educa.Pro complies with security standards designed to protect user and organisational data. Furthermore, it supports the traceability of certifications, digital signatures and the management of assessments, thereby ensuring regulatory and legal compliance in both educational and corporate environments.
What support and guidance does Educa.Pro offer?
The Educa.Pro team offers comprehensive support throughout implementation, roll-out and adoption, ensuring that organisations get the most out of the platform and achieve measurable results from day one.