Course details
This program offers the opportunity to learn how to develop a unique blend of practical skills in Financial Modeling using Excel to improve your financial projections, analysis, and financial reporting skills in addition to learning how to build a risk analysis model and modeling for business valuations along with relevant simulation and sensitivity analysis techniques.
Who should attend?
This hands-on course is designed for Bankers; Credit Officers; Investment Bankers; Business Valuation consultants; Financial and Risk Analysts; Security and Investment Analysts; Financial Advisors, Corporate Analysts and; Treasury Analysts; Finance Managers and Controllers; Strategy Directors and Managers; Financial Planning and Budgeting Managers; and Project Managers.
Pre-requisites
- Financial Background
- Basic EXCEL Skills
Program Outline
Introduction to Financial Modelling
EXCEL modelling - Basics
Essential EXCEL Methods
Building the Financial Statements; Income Statement (IS), Balance Sheet (BS) and Statement of Cash Flows (SCF)
- Ratio analysis - IS, BS and SCF
- Financial Projections - building up a viable model
- Sensitivity and Scenario Analysis - How to develop?
- Time Value of Money concepts
- Discount rate - How to calculate? What to consider?
- How to build financial models for fixed income products such as Treasury bills, Treasury bonds.)
- Statistical Probability models (Monte Carlo) - what is there?
- Valuation Models: Discounted Cash Flow (DCF) model & Dividends Discount Model (DDM)
- Terminal (residual) value and application of multiples
- What are the most common multiples to rely on?
Job roles this course is suitable for:
Credit Officers , Investment Bankers , Business Valuation Consultants , Financial & Risk Analysts , Security & Investment Analysts , Financial Advisors , Corporate Analysts , Treasury Analysts , Finance Managers & Controllers , Project ManagersAbout Developers for Training and Consultancy
Developers for Training and Consultancy (DTC) is a regional HUB for Corporate Finance, Risk Management, Control, Audit, Compliance and Governance since 2008. DTC served the most demanding clients in all sectors in Egypt and the region including, CIB, QNB, ADIB, Egyptian Stock Exchange, Gulf Investment Corporation, Kharafi Group, HSBC, USAID, GSK, Pfizer, Orange, Hafil, Americana, FLSmidth and others.
DTC is licensed by the renowned International Academy of Business and Financial Management (IABFM™) and registered consultancy firm with the European Bank for Reconstruction and Development. DTC is not only well known for its unmatched monthly public training calendar but also for its unique tailor made training and consultancy solutions to match each client’s exact needs.
DTC offers the most prestigious professional certificates such as the CAMS, Certified Compliance Officer, Certified Valuation Analyst, Certified Operational Risk Professional, Certifiied Enterprise Risk Manager, Financial Risk Manager, Accredited Small & Medium Enterprises Consultant, Islamic Finance Qualification, Certified Information System Auditor and others, in addition to its international professional live events and conferences.
Enquire about this course
You may add more courses here,
your list will be saved.
