Developers for Training and Consultancy Financial Modeling for Investment Analysis Developers for Training and Consultancy
Price: AED 1,183

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.


  • 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? 
  Updated on 15 May, 2019

About 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.   See all Developers for Training and Consultancy courses

Enquire about this course

You may add more courses here,
your list will be saved.

Rate this page