Financial Modelling

Financial Modelling

About This Course

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.

Career Advancement Areas

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.

What You Will Learn

  • 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

Instructions

Prerequisites
Students should have hands-on experience with Microsoft Excel and a brief idea about Finance, Balance Sheets, and Cash Flow Models.
Duration
4 Days
Who Should Register?
  • 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

Overview

Delphi Training Center
Course Type:
Training Course
Study Mode:
Classroom
Location:
Delphi Star Training Centre, Dubai
Fees:
3,500 AED
Certification:
Course Completion Certificate
Date:
21/04/17


Your information is 100% Secure and will be delivered directly to the school.