Request a Call Back
The answer to your doubts is just a click away! Simply fill in your details in the form, and we will get in touch with you shortly.
KPME Project Finance Modeling
What does the Project Finance Modeling Program Cover?
Develop a project finance model and analyze financing proposals at our two-day program. Starting from scratch, the delegates will develop a fully integrated and flexible project finance model, forecast project cash flows and key KPIs using advanced excel tools and best practices in financial modeling.
Learning Objectives
Apply advanced excel tools in project feasibility modeling
Develop EPC (Engineering, Procurement, and Construction), CapEx (Capital Expenditures) and funding schedule using timing flags
Build a project's flexible debt repayment schedule for various sources of financing
Model key financial drivers used to evaluate a project finance transaction
Perform scenario and sensitivity analysis in a project finance model
Program Agenda
Introduction to the Project Finance Model
Grasp advanced Excel tools in Project Finance modeling
Explore the differences between project finance and traditional finance
Understand the life-cycle of a project finance transaction and model
Developing the model
Timing and Debt Structure
Input sheet and its assumptions
Build a flexible timing structure using timing flags
EPC and CapEx schedule
Revenue, operational and maintenance expenditures
Debt modeling
Forecasting
Forecast cash flow available for debt servicing (CFADS)
Forecast debt repayment and interest schedule (For different types of debt structures)
Interest during construction & controlling circular referencing
Repayment waterfall
Reserve accounts, cash sweeps
Modeling for Key Model outputs
DSCR (Debt Coverage Ratio), LLCR (Loan Life Coverage Ratio) and PLCR (Project Life Cover Ratio)
NPV (Net Present Value) and IRR (Internal Rate of Return) for different sponsors and investors in the project
DSRA (Debt Service Reserve Account)
Scenario and Sensitivity Analysis
Perform one or two variable data table sensitivity analysis for key project inputs
Perform scenario analysis by changing multiple project inputs and evaluate the impact on key model outputs
Our Expert Trainers
Rahul Sonthalia
AFM, CFA, CMA
Rahul has more than 13 years of experience in the area of investment banking, equity research, macro-economic research, and training. He has been teaching financial modeling and investment banking courses in UK, Singapore, and the MENA region.
He has delivered advanced financial modeling related programs for Sovereign wealth funds and banks in the GCC and for large asset management companies in the UK and Singapore. He was a guest speaker on “Best Practices in Financial Modeling” at the Modeloff Global World Financial Modeling championship in London.
Shanin Thomas
CFA
Shanin has over 10 years of work experience in equity research, portfolio management, investment banking, and financial modeling. He was a partner at Esta Capital, a boutique investment research and advisory firm. He also previously worked in JPMorgan’s Investment Banking Division in Mumbai and New York offices covering North American banks and asset management companies.
He has over 6 years of experience in CFA training and corporate training on programs such as Financial modeling, finance for non-finance, business valuation, equity research, value investing, and derivatives.
Upcoming Dates
| Course Title | Term | Location | Start Date | End Date | Price* | |
|---|---|---|---|---|---|---|