Project Finance Modelling in Excel 2: Modelling the Project’s Financial Statements and Investment Analysis

Key Learning Aims:

• Project the Income Statement, Balance Sheet and Cash Flow Waterfall for the Project
• Compare and contrast the Cash Flow Waterfall with the Cash Flow Statement
• Discuss the concepts of Equity Net Present Value (NPV), Equity Internal Rate of Return (IRR) and Debt Service Coverage Ratio (DSCR)
• Evaluate the Project from Sponsor’s and Lender’s perspectives using Equity NPV, Equity IRR and DSCR
• Sensitize the financial model for changes in operating and financing assumptions
• Illustrate how changes in capital structure would impact the Equity NPV, Equity IRR and DSCR

Prerequisite: Learners should have completed the “Project Finance Modelling in Excel 1: Documenting Assumptions and Building Key Schedules” Program.

This Program is Recommended For:

• Investment Banking Professionals
• Debt Capital Market Professionals
• Credit Analysts
• Buy- and Sell-Side Analysts
• Finance Professionals in a Corporation
• New Entrants to Capital Markets/Finance

Program Duration: 4 Hours

SIDC CPE Points: 10 Points

Download the program brochure here.

Course Instructor

Kah-Teck Wong Facilitator

Kah Teck has more than a decade of capital markets experience. He was a portfolio strategist in CIMB Investment Bank and AmInvestment Bank where he was responsible for spearheading investment advisory and product development initiatives and also played an active role in evaluating numerous plain vanilla and hybrid fund raising options. He has also worked for the Securities Commission in research and formulating capital market development policies.

Now the Managing Director and Principal Trainer for FMTCS Sdn Bhd, Kah Teck passionately shares his knowledge and experience with professionals in many of Malaysia’s leading financial institutions and government-linked institutions. His trainees frequently credit him with the ability to make finance interesting and demystify complex finance concepts. 

Kah Teck graduated summa cum laude with a dual degree in finance and economics from the University of Pennsylvania’s Wharton School and School of Arts and Sciences, and holds an MBA (with Honors) from the Booth School of Business, University of Chicago. He is also a Chartered Financial Analyst (CFA) charterholder. Kah Teck was also awarded the ASEAN scholarship to pursue pre-university studies in Singapore. 

His teaching and research interests are in corporate finance, derivatives, securities valuation, financial risk management, financial modelling and financial analysis.