HOT LINE:

+919019191856

+1 (201) 720-5410 (USA)

My Cart

0

Financial Modeling with Advanced Valuation Techniques

Quality
Price
Value
1 Review(s)

Training Mode: Class Room / Live Online


myTectra the Market Leader in Financial Modeling with Advanced Valuation Techniques Training in Bangalore

myTectra offers Financial Modeling with Advanced Valuation Techniques training in Bangalore using Class Room. myTectra offers Live Online Financial Modeling with Advanced Valuation Techniques Training Globally.

 

Course Objectives
1. To enable the participants build on their existing excel knowledge and acquire advanced financial modeling techniques
2. To enable the participants to gain acumen, expertise and in-depth knowledge on various methods of valuation.
3. To empower the participants with the technical skills as well as analytical and decision-making discretion in any finance job.
Who should go for this Course?
1. Commerce graduate
2. MBA students
3. Financial and Business analysts
4. Financial controllers, managers and modellers
5. Chief Financial Officers
6. Risk Managers
7. Chartered Accountants
8. Corporate treasury managers
9. Middle office staff
10. General Managers
11. Fund Managers
12. PE Fund Managers
After completing the course participant should be able to demonstrate robust theoretical knowledge and sound practical approach to financial modeling.
Why learn Financial Modeling?
Financial Modeling & Advanced valuation enables professionals to handle finance models by applying advanced level tools and applications of Excel. Financial Modeling is the task of building a model representing financial asset and performance of a business. Financial Modeling skills are must for finance and non-finance professionals especially for almost all mid-senior management professionals worldwide. The added skills gained through Excel training helps these professionals to gain an in-depth understanding of financial modeling techniques to succeed in today's demanding environment.
What are the pre-requisites for this Course?
1. Familiarity with Excel - functions and tools
2. Understanding basic accounting concepts
3. Basic knowledge of valuation, project finance, return concepts
Which Case-Studies will be a part of the Course?
Project1: (i) Create a DCF model for a real company

1. Excel Features and Techniques
Learning Objectives -This is a pre-requisite to financial modeling. In this, you will understand basics to advanced usage of excel for various forms of financial analysis.
Topics - Excel Shortcuts, Excel formulae, Usage of names to make formulas easier, Data Sorting, Excel formatting, Data Formats, Lines and Borders, Colours and Patterns, Excel functions, Excel charts, Dynamic Graphs, Conditional Formatting, Linking worksheets, Data Validation, Controls Macros, Combo Boxes and buttons, User Forms and controls, Data Tables, sensitivity analysis, goal seek, and running macros.
2. Financial Statement & Analysis
Learning Objectives - In this module, you will learn understand how to analyze financial statements.
Topics - Profit and Loss Account, Balance Sheet, Financial Ratios, Cash flow statement, Identify the information contained in the three main financial statements.
3. Cost of Capital
Learning Objectives - In this module, you will learn how to calculate cost of capital of a company.
Topics - CAPM, Growth Models, WACC
4. Historical Analysis - 1
Learning Objectives - In this module, you will learn how to perform historical performance of a company.
Topics- Return on invested capital.
5. Historical Analysis - 2
Learning Objectives - In this module, you will learn how to forecast performance of a company.
Topics - Forecasting and Porter's 5 forces model.
6. DCF Modeling
Learning Objectives - In this module, you will perform a detailed discounted flow model of a company.
Topics- Free Cash Flow to Firm (FCFF) Model, Discounted Cash Flow (DCF) Model, Dividend Discount Model, Earnings Growth Model, FCFF vs FCFE, Create a DCF model for a company.
7. Relative Valuation & Private Company Valuation
Learning Objectives - In this module, you will understand relative valuation methods and private company valuation.
Topics- Enterprise multiples, Price multiple.
8. Mergers, Acquisitions and Corporate Restructuring Analysis - 1
Learning Objectives - In this module, you will build your understanding of M&A deals.
Topics- General M & A dynamics, Types of Mergers, Acquirer and acquired, Forms of Acquisition, Motives for M&A, Friendly/Hostile M&A, Defense tactics, Regulations, Valuation methods, Deal making, Methods of payment, Types of corporate restructuring, Reasons for restructuring, Examples and case study.

To Learn Live Online Financial Modeling with Advanced Valuation Techniques Training Globally and Financial Modeling with Advanced Valuation Techniques in Bangalore using Class Room, ENROLL TODAY at myTectra.


Customer Reviews

1 Item(s)

per page
Best institution Review by Nikhil
Price
Quality
Value
mytectra learning solution provides good faculties and training facilitites for the students.

1 Item(s)

per page

Only registered users can write reviews. Please, log in or register

brand
myTectra Stands for Quality Training and provides training using Experienced professionals on the Respective Technologies and who has a good teaching expertise.


We're here to help you. Drop Us a Query !


  

WHY DO YOU AWAIT FOR FIXED SCHEDULES ? CHOOSE MYTECTRA LEARN AT YOUR CONVENIENT TIME

myTectra flexible batch schedules enables you to start your class at your convenient date and time.


1. All the enrolled candidates must start the class by any date within 30 days from the date of enrollment.
2. Maximum of 3 Days will be taken by myTectra to schedule the batches from the date of schedule request from the candidate.
3. Individual Focus - Maximum 5 candidates allowed per batches
4. The candidate can request any one of the batch time slot from the below list
Batch Type Time Slab Hours/Day Time Zone Days
Regular Morning 6.30 AM - 9.30 AM Anytime Maximum 2 Hrs IST Monday-to-Friday
Regular Evening 6.30 PM - 9.30 PM Anytime Maximum 2 Hrs IST Monday-to-Friday
Week End 6.30 AM - 9.30 PM Anytime Maximum 3 Hrs IST Saturday,Sunday
Fast Track-Morning 6.30 AM - 9.30 AM Anytime Maximum 2 Hrs IST Monday-to-Saturday
Fast Track-Evening 6.30 PM - 9.30 PM Anytime Maximum 2 Hrs IST Monday-to-Saturday
Customized Batch Customized Timing Customized Hrs IST Customized Days

Note : We can schedule your batch anytime on Saturday and Sunday between 6.30 AM 9.30 PM at your convenient time


Do you have any questions ? please call us on +919019191856 or email to [email protected]