Programme Objective

Participants will gain practical skills in building and analyzing financial models specific to project finance as well as a better understanding of financial projections and risk, which support more informed decision-making. 

Programme Outline

Welcome and introduction to project finance modelling   

• Key characteristics and differences from corporate finance 
• Importance and applications in project finance 
• Typical structures and stakeholders 
• Model structure and essential components. 

Setting up the financial model 

• Basic components of financial models  
• Model layout and design principles 
• Input sheets: Assumptions, inflation rates, and exchange rates 
• Hands-on exercise: Creating the basic skeleton of the model 

Revenue and cost projections  

• Estimating project revenues and operating expenses 
• Capital expenditures and project timelines 
• Hands-on exercise: Inputting revenue and cost projections 

Financing structure  

• Debt and equity financing basics 
• Loan amortization schedules and interest rates 
• Hands-on exercise: Structuring the financing 

Building financial statements  

• Integrating income statement, balance sheet, and cash flow statement 
• Depreciation and working capital management 
• Hands-on exercise: Completing financial statements 

Risk analysis and scenario planning  

• Identifying and modeling key variables 
• Sensitivity and scenario analysis techniques 
• Hands-on exercise: Conducting scenario analysis 

Model validation and reporting  

• Importance of model validation and techniques 

Summary of key learnings  

• Open floor for participant questions and discussion 
• Feedback collection and workshop closure 

Software Installation and Laptop

As this class places strong emphasis on the hands-on experience, you will be working with data for the majority of the time in the class. To optimize the learning experience, it is mandatory for all participants to be equipped with a laptop, pre-installed with Microsoft Excel 2010, 2013, 2016 (full licence) or any latest version.

(If you are using your work laptop, please contact your IT Support to arrange for installation if it is not pre-installed with Microsoft Excel)

Learning Outcomes  

• Setting up the financial model 
• Revenue and cost projections modelling  
• Financing structure modelling  
• Building financial statements 

Intended For

• Financial analysts and corporate finance professionals
• Infrastructure project managers
• Public sector professionals
• Accountants and auditors
• Engineering and technical professionals
• Accountancy students

Competency Mapping

Others = 4.00 Hours

Programme Facilitator(s)