myTectra the Market Leader in Financial Modeling with Advanced Valuation Techniques Training in Bangalore
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.
|myTectra Stands for Quality Training and provides training using Experienced professionals on the Respective Technologies and who has a good teaching expertise.
|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]