Financial Modelling in Excel 2-Refining the Model Beyond Core Financials (In-House)

Key Learning Aims:

Project the firm’s statement of cash flows based on income statement and balance sheet data
• Incorporate new share issuance and share buybacks into the financial model to refine it further
• Project the firm’s debt schedule and determine the firm’s future funding requirements
• Assess the impact of assumed changes in fundamentals on the firm’s earnings per share (EPS)
• Complete a projected financial statement model that integrates the projected income statement, balance sheet and cash flow statement
• Test the financial model to see if it is robust

This Program is Recommended For:

• Investment Banking
• Corporate Finance
• Corporate Banking
• Equity Research

Program Duration : 4 Hours

SIDC CPE Points: 10 points

Course Instructor

Kah-Teck Wong Author