Project Lending and Financial Modeling

Project Lending and Financial Modeling

Program Objectives:

To enable participants to:

  • Seek business opportunities in long term lending
  • Assist borrowers in formulating projects
  • Conduct project feasibility studies
  • Structure project finance deals and participate in loan syndication (especially for infrastructure projects)
  • Use excel based macros for financial modeling
  • Effectively monitor projects during implementation

Program Contents:

  • Capital budgeting techniques
  • Identification of incremental cash flows
  • Cost of capital
  • Technical feasibility of projects
  • Commercial viability – demand/supply analysis, marketing strategies
  • Financial feasibility – estimating project cost, means of finance, financial projections and important financial ratios
  • Project finance modeling –developing excel based macros for projection and analysis of cash flows
  • Project risk analysis
  • Managerial aspects
  • Environmental impact analysis
  • Financing infrastructure projects
  • Monitoring project implementation
  • Exercise and case studies


The program involves development of excel based macros for project finance modeling and risk analysis. Hence the participants are expected to bring their own laptops

Target Group :

Those working in corporate, commercial and infrastructure project lending. Those working in credit risk management and internal audit will also find the program useful

Duration: 4 Days

Trainers: Dr Satish Shinde Mr. Vijay Waghmare