Login

Register

Create an Account
Retrieve Password
Back to login/register

PROJECT FINANCE MODELLING

MASTER THE ART & SCIENCE OF PROJECT FEASIBILITY ASSESSMENT & MODELLING

PROJECT FINANCE MODELLING

Instructors With 25+ Years Of Experience in Global Investment Banking & Research

Instructors Have Personally Trained 1,000+ Analysts

Develop One Live Model During The Workshop

Access To Instructor For 1 Month After Course Completion

CALL NOW: +91-96195-02101

Project Finance Modelling (M-CPFA® – MyAbhyaas Certified Project Finance Analyst) Program by MyAbhyaas Academy will provide participants with a deep understanding of how to build financial model on infrastructure projects and evaluate the financial feasibility of such project. This program will educate participants on theories; concepts and analytical frameworks related to project finance PPP transactions and will provide step-by-step approach on building financial models related with project finance transactions.

The program will use a unique blend of modules on concepts and real world know-how to act as a practitioner’s guide to anyone who is going to be involved in project finance modelling and financial decision-making. Our course is designed to encourage students to develop critical thinking abilities that will help them understand the economic, financial and strategic underpinning of different project finance deals.

KEY LEARNING FROM THIS PROGRAM

1. Understanding infrastructure projects and PPP transactions
2. Understanding the revenue, cost forecasting mechanism and financial statement structure
3. Understanding the financial mechanism and sources of funds in PPP transactions
4. Developing basic VBA model optimization macro code
5. Building, modifying and/or understanding financial models related with transactions
6. Evaluating financial feasibility and modelling techniques
7. Improved skills about planning, researching and communicating ideas

KNOW MORE / DOWNLOAD BROCHURE

Call Us: +91-96195-02101

COURSE - KEY BENEFITS

LEADING INSTRUCTORS

Learn from Instructors with 25+ years of combined experience in project finance and business feasibility studies; Instructors have trained 1,000+ participants across 20+ countries

20+ TOPICS

To provide a detailed practical approach to project feasibility analysis, financial projections and project finance modelling through a unique blend of modules on key concepts and real world know-how! Know Art & Science of project finance decision making.

5 CASE STUDIES

To help participants understand various drivers of value creation and run a fundamental and objective analysis on a project; Also designed to encourage students to develop critical thinking abilities in working with project feasibility and investment decisions

LEARNING TO APPLICATION

Apply all the learning from this program to develop financial model and feasibility assessment on a selected project under the guidance of the Instructors; Do-It-Yourself so that you develop practical know-how!

LIVE INTERACTIVE CLASSES

Participate in 32 hours of instructor-led live training; fully interactive with two-way live communication; Designated forums to facilitate interaction and knowledge sharing among participants; Participate in this program from your PC/mobile with HD video live streaming

1-MONTH FREE ACCESS

To the instructors – to help you clear doubts and refine your approach to analysis, forecasting and valuing infrastructure projects and improve your decision making abilities!

COURSE CURRICULUM

SESSION 01. INTRODUCTION TO PROJECT FINANCE

Course introduction and what’s-in-it for students!

Understanding the project finance key concepts (PPP/PFI transactions)

Understanding parties involved in project financing

Understanding the project finance structure and analysis framework

SESSION 02. KEY DIMENSIONS IN DEVELOPING PROJECT FINANCE TRANSACTIONS

Understanding key revenue streams and certainty thereof

Understanding Financial Ratios and Financial Covenants

Understanding Lender Protection, Step-In, Direct Agreement and Taking Security

Understanding termination compensation

SESSION 03. PROJECT DEVELOPMENT CYCLE & TYPES OF FINANCIAL MODELS

Understanding the project development cycle – Pre-Funding and Post-Funding

Understanding the Financial Close model

Understanding the Operational model

SESSION 04 – 05. EXCEL TOOLS FOR PROJECT FINANCE MODELLING (4 HRS)

Introduction to If function and Nested If’s

VLOOKUP and HLOOKUP

Index and Match

Data Validation

Conditional Formatting

Goal Seek

Data Tables and Sensitivity Analysis

NPV and IRR

SESSION 06-07. CALCULATION OF REVENUE, COSTS & WORKING CAPITAL

Modelling the basic revenue stream

Evaluating the demand risk for projects

Operational and maintenance expenses including fixed and variable items

Modelling Accounts receivables and Accounts payables

SESSION 08. FINANCIAL STATEMENT ANALYSIS – CASH FLOWS WATERFALL

Developing the cash flow waterfall (a.k.a. payments cascade)

Calculating period-by-period cover ratio (the heart of most structured finance transactions)

Debt servicing analysis

SESSION 09. FINANCING MECHANISM IN PPP PROJECTS

Understanding a typical capital structure and key sources of funding

Sources of Funding – Equity Contributions

Sources of Funding – debt structure (Senior debt and Subordinate debt)

SESSION 10: SOURCES OF FUNDS – DEBT IN DETAIL

Modelling fees – financing fees; arrangement fees, agency fee, commitment fees

Interest payment schedule

Analysing and modelling repayments method; Bullet, Linear, Annuity, Sculpted and Cash sweep

SESSION 11-12. MODEL OPTIMIZATION

Calculating the funding requirement of the project

Understanding the reason for circularity issue in funding structure and how to solve it

Understanding how to fully optimize the funding requirements

Creating a C+P model optimization VBA macro to fully optimize the model funding requirement

SESSION 13. DIVIDEND & BALANCES

Understanding how to calculate dividend paid to shareholders

Calculating balances; Retained earnings and Retained cash balances

SESSION 14. FINANCIAL RATIOS & FINANCIAL COVENANTS

Learn the importance of credit ratios and their purposes in analysis Ratios

Calculating CFADS during the debt service period

DSCR – current period & minimum DSCR, backward & forward, average ratios

Calculating Returns – Project IRR / Equity IRR / NPV etc.

SESSION 15. SENSITIVITY & SCENARIO ANALYSIS

Performing the sensitivity on key business and valuation drivers

Building different scenarios

FINAL ONLINE EXAMINATION

A set of 30 multiple choice questions; examination duration 60 minutes

CAPSTONE PROJECT

All the learning in this course will be evaluated through a “Capstone Project” where student will apply all the learning from M-CPFA program to come up with a project finance model on a selected infrastructure project.

CERTIFICATION 

PARTICIPANTS' FEEDBACK

Kartik Sabharwal

"This course is highly recommended to anyone who is looking out for guidance on how to approach evaluation of any infrastructure project. Using the step-by-step guide from MyAbhyaas, I have become a better professional with faster growth in my organization."

Manager, L&T Infra Debt Fund Limited

2016-09-15T18:56:00+00:00

Manager, L&T Infra Debt Fund Limited

"This course is highly recommended to anyone who is looking out for guidance on how to approach evaluation of any infrastructure project. Using the step-by-step guide from MyAbhyaas, I have become a better professional with faster growth in my organization."

Contact Us

Phone: +91-96195-02101
Email: info@myabhyaas.com


Follow Us!

Learn on the Go!



top
© 2016-18 MyAbhyaas Education Services Private Limited.