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

COURSE STARTING ON 20 AUGUST

Project Finance Modelling 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-90040-89006

COURSE - KEY BENEFITS

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!

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!

MEET THE INSTRUCTORS

Dibyanshu is a Chartered Financial Analyst and holds MBA in Finance from one of the leading management institutes in India – the IIM, Ranchi. Dibyanshu has a knack for finance and quantitative analysis and has cleared all CFA levels in his first attempt.

Dibyanshu has more than 5 years of work experience. As a Manager, investment Research at one of the largest investment research firms, Dibyanshu has worked with scores of financial institutions and private equity firms in the Middle East and Africa region.

Dibyanshu has extensive experience building financial feasibility and project finance models and is a master of MS Excel.

Dibyanshu has trained more than 200+ professionals on Project Finance Modelling, Advance Excel Techniques For Financial Modelling and CFA preparation.

Ati has nearly 14 years of experience in investment research and business strategy. As Head of Investment Research (IR) at Aranca, a leading global research firm, Ati worked with scores of financial institutions. During his 11+ years’ stint at Aranca, Ati was instrumental in growing the IR team 8-fold and has represented Aranca in various print and digital media platforms. Ati is also working as consultant to various start-ups to help them refine their business plan and run financial feasibility of establishing and running a business.

Ati Ranjan founded MyAbhyaas in 2016 with an aim to arming students and professionals with practical know-how to make them competitive and employable. Ati is a firm believer in knowledge as the key enabler and is working on democratizing learning leveraging technology and the power of Internet.

During his stint in Aranca, Ati has personally trained 700+ analysts on core investment research capabilities, including identification of value drivers, financial projections, DCF and relative valuation, investment note storyboarding etc.

Ati is an MBA in Finance and holds B.A. Hons degree in Economics. Ati Is a certified trainer (Train The Trainer Certification) from Dale Carnegie, USA

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-9004089006
Email: info@myabhyaas.com


Follow Us!

Learn on the Go!



top
© 2016-17 MyAbhyaas Education Services Private Limited.
MyAbhyaas Newsletter
Join over 10,000 fellow professionals who receive free email updates!

SUBSCRIBE 
We hate spam as much as you! Unsubscribe anytime!
close-link