Contact
Request a demo

Financial Modeling for Public-Private Partnerships. Basic-Intermediate Level

Industry-Specific
Digital Skills

Project Management

Duration

40 hours

PRESENTATION

In today's dynamic economic environment, public-private partnerships have emerged as an essential pillar for the development of innovative projects, especially in emerging sectors such as renewable energy. The course "Financial Modeling for Public-Private Partnerships: Basic-Intermediate Level" offers you a unique opportunity to delve into the world of financial modeling. You'll learn everything from the fundamentals 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 help you understand the key steps 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.

Objectives

– Understand the fundamentals of financial modeling and its practical application.

– Identify and analyze financial statements to evaluate investments.

– Use Excel functions and tools for financial modeling.

– Apply basic modeling concepts to photovoltaic projects.

– Understand the structure and contracts involved in project finance.

– Assess debt levels and manage cash flow for projects.

– Create basic financial models for public-private partnership projects.

Syllabus

TEACHING UNIT 1. INTRODUCTION TO MODELING Introduction to Modeling Introduction to Financial Mathematics Financial Statements Analyzing an Investment Financial Statements – Supplementary Exercises TEACHING UNIT 2. BASIC CONCEPTS OF FINANCIAL FORMULATION Rules for constructing formulas Excel. Most common functions in financial modeling Excel. Most common tools in financial modeling Excel. Explanation of macros Shortcuts (Keyboard Shortcuts) TEACHING UNIT 3. CONCEPTS FOR FINANCIAL MODELING. CASE STUDY: PHOTOVOLTAIC PARK Basic Concepts of Financial Modeling Main stages in building a financial economic model Financial Modeling Case Study: Photovoltaic Solar Farm – Creation Guide Financial Modeling Case Study: Photovoltaic Solar Farm – Solution I Financial Modeling Case Study: Photovoltaic Solar Farm – Solution II TEACHING UNIT 4. INTRODUCTION TO PROJECT FINANCE Brief Explanation and Introduction to Project Finance Non-Recourse Financing Key Contracts for These Projects Cash Flow for Debt Service Debt Sizing
Request for Information

Related MOOCs

Course

Workplace Risk Prevention, Ergonomics, and Mental Health

The Course on Workplace Risk Prevention, Ergonomics, and Mental Health addresses the growing need to ensure environments...
Read more
Course

Digital Disconnection and Legal Compliance in the Workplace

In the age of remote work, hyperconnectivity has put companies under the scrutiny of the Labor Inspectorate....
Read more
Course

The Right to Digital Disconnection, Health, and Work Ethics

In a world of global digitization, hyperconnectivity has gone from being an advantage to becoming a challenge...
Read more

Are the Educa PHAROS courses eligible for credit?

Many courses can be credited toward the master's programs at Structuralia.
Specialized Courses Catalog

Facts about our area

+ 1.483

Hours

+88.999

Minutes

264

Courses

Educa PHAROS is a next-generation training model that places a company’s human capital at the forefront. Through a platform that adapts to each company’s corporate identity and offers a total of more than 900 courses, it provides tailored training for each organization. The unlimited flat-rate plan provides each company with the number of courses that best suits its needs, as well as the ability to determine which employees will have access.
Scroll to Top