Financial Modelling

حول هذه الدورة

Financial Modeling is a Course for all those professionals who work in the finance sector, dealing with huge numbers is a part of their day-to-day job. It is therefore important for such professionals to have expertise in MS Excel so that they can use it for analysing competitors, making financial projections and preparing financial models. It enables us to analyse a wide range of business parameters and arrive at optimal business solutions. If you have excellent working knowledge of MS Excel, you can assure yourself of speed as well as accuracy.
Our Financial Modelling course will teach you the basic of Microsoft Excel all the way to creating successful Financial Models. By the end of the course, you will be able to independently build models that are robust and provide dynamic projections that can be used to thoroughly analyze a company from multiple standpoints: operations, investment, financing and valuation.
Our four-day course with two modules is all you need to start building your own financial models. The first module is Equity Evaluations and the second module being advanced Excel. So you can make a model firstly, and then understand how to use that model for various purposes like projections, evaluations etc.

مناطق تحسين مسيرتك المهنية

Commercial Banks are using Financial Modelling for disbursing loans for the projects; Project Managers are using it for performance tracking of on-going projects.
Financial Modelling concepts can be applied to any industry. Individuals who hold an MBA and possess knowledge of Financial Modelling have an advantageous edge over others.

ما الذي سوف تتعلمه؟

  • Financial Modelling Principles: Excel as a tool for financial modelling
  • Building financial models best practices
  • Modelling growth drivers, depreciation, cost drivers, asset & debt schedules
  • Valuation Principles: Projecting cash flow statement
  • Circular references and handling them
  • Financial ratio analysis
  • Valuation using DCF & Comps
  • Scenario analysis and Building valuation dashboards
  • Q & A
  • Advanced Functions, Tools and Chartings:
  • Techniques
  • Advanced Tools in Excel for Auditing Financial Models
  • Mastering Financial Functions
  • Advanced Charting Techniques in Excel
  • Using Macros & VBA for Financial Modelling:
  • Understanding Macros & VBA for Financial Modelling
  • Implementing Monte Carlo Simulation
  • Advanced Charting Techniques in Excel
  • Q & A

التعليمات

المتطلبات الأساسية
Students should have hands-on experience with Microsoft Excel and a brief idea about Finance, Balance Sheets, and Cash Flow Models.
المدة
4 Days
من يتعين عليه التسجيل؟
  • This program is suitable for students and professionals related to:
  • Investment
  • Equity Research
  • Credit
  • Project
  • Mergers & Acquisition
  • Corporate Finance
  • Critical Thinking and analytical skills. It is also ideal for CA
  • CFA Program candidates
  • FRM
  • MBA Finance
  • B TECH
  • Commerce

لمحة عامة

Delphi Training Center
نوع الدرس:
دورة تدريبية
نمط الدراسة:
قاعة دراسية
المكان:
Delphi Star Training Centre, Dubai
التكاليف:
3,500 درهم إماراتي
الشهادة:
Course Completion Certificate
التاريخ:
21/04/17


سيتم الحفاظ على سرية معلوماتك وإرسالها مباشرة إلى الكلية.