Financial Modelling in Excel 3-Discounted Cash Flow Valuation Model

Key Learning Aims:

• Create a discounted cash flow (DCF) valuation model using a methodical process
• Project free cash flows using data from projected financial statements
• Estimate the terminal value for a business using the Gordon Growth Model and Exit Multiple method
• Value the firm and its equity securities using the discounted cash flow (DCF) valuation financial model
• Sensitize the value of the firm’s shares for changes in fundamentals such as growth and the cost of capital
• Evaluate the valuation obtained via the DCF valuation model

This Program is Recommended For:

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

Program Duration: 3 Hours

SIDC CPE Points: 10 points

Program Prerequisites: Completion of Financial Modelling in Excel 1-DCF Valuation and Projecting Core Financials AND Financial Modelling in Excel 2-Refining the Model Beyond Core Financials.

Note: This Program is part 3 of a 4 part series. Learners are highly encouraged to attend all 4 parts of the Program

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.