Duration: 05 Days (15 Hours)
Medium: English
Course Fee: Rs. 15000
The Certificate Program in Financial Modeling equips participants with the skills and knowledge required to create advanced financial models that can be used for decision-making, forecasting, and valuation in a corporate finance context. This intensive five-day program will provide participants with a comprehensive understanding of financial modeling principles and practical applications.
Learning Outcomes:
On successful completion of this course, the learner should be able to:
✅ Understand the fundamental concepts of financial Modeling and its importance in corporate finance.
✅Build robust financial models for budgeting, forecasting, and valuation purposes.
✅Apply best practices in spreadsheet design and organization to create efficient and error-free models.
✅Perform sensitivity analysis and scenario planning to assess the impact of various variables on financial outcomes.
✅Analyze historical financial data and use it to inform future projections.
✅Value companies and investments using various financial Modeling techniques.
✅Interpret and communicate the results of financial models effectively to support decision-making.
✅Develop a strong foundation for advanced financial Modeling in areas such as mergers and acquisitions, project finance, and risk analysis.
Entry requirements:
✅ Finance/Accounting undergraduates
✅ Finance/Accounting professionals
Entry recommendations:
To be prepared for this course, we recommend that you have:
✅A strong foundation in finance/accounting
✅Mathematics and Excel skills
| Day | Course Title | |
|
Day-1 |
Introduction to business valuation
· Absolute valuation methods · Comparative valuation methods · Calculating Free Cash Flow to Firm (FCFF) using historical financial statements. Introduction to financial Modeling · The need for forecasting financial statements. · Uses of Financial Modeling · Financial Modeling using MS Excel – An Example · Evaluating various business models (For example, for S&P 20 companies in Sri Lanka excl. financial services/insurance sectors) and identifying revenue and cost drivers |
|
|
Day-2 |
· Hard coding historical financials (Income statement, Balance sheet, and Cash flow statement)
· Re-stating historical financial statements for non-recurring and non-operating items |
|
|
Day-3 |
· Inserting revenue and cost drivers for historicals
· Creating various schedules and forecasting financial statements |
|
|
Day-4 |
· Inserting revenue and cost drivers for historicals
· Crating various schedules and forecasting financial statements – |
|
|
Day-5 |
· Estimating cost of capital
· Building the DCF model · Financial ratio analysis |
Teaching/Learning Methods
Teaching will be mainly by way of lectures.
Assessment Structure
| projects/quizzes/presentations/case studies) | 100% |
