Financial Modeling with Advanced Valuation Training

Course Objectives

To enable the participants to build on their existing excel knowledge and acquire advanced financial modeling techniques
To enable the participants to gain acumen, expertise, and in-depth knowledge on various methods of valuation.
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?

Commerce graduate
MBA students
Financial and Business analysts
Financial controllers, managers, and modelers
Chief Financial Officers
Risk Managers
Chartered Accountants
Corporate treasury managers
Middle office staff
General Managers
Fund Managers
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 the 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?

Familiarity with Excel - functions, and tools
Understanding basic accounting concepts
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

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.

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.

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

Historical Analysis - 1

Learning Objectives - In this module, you will learn how to perform the historical performance of a company.

Topics- Return on invested capital.

Historical Analysis - 2

Learning Objectives - In this module, you will learn how to forecast the performance of a company.

Topics - Forecasting and Porter's 5 forces model.

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.

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.

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, Dealmaking, Methods of payment, Types of corporate restructuring, Reasons for restructuring, Examples and case study.

How do I contact myTectra for Corporate Training?

Would you like to reach us for the training for your team? Please fill the below form. We will get back to as soon as possible.

Will I get placement assistance?

myTectra is providing 100% placement assistance on our key courses. We help you with the career counselling, Exams on Key courses, Mock Interviews and Technical Interviews Tips.

Landing an interview proves that you have the job-specific skills for the position, but how do your interview skills stack up? Also, Soft skills are often the most important factor in showing you're the best candidate for the job.

Hence we are conducting FREE TRAINING on Soft-Skills worth Rs-25, 000 to all myTectra students which will help you to attend the interviews with more confidence.

Can I attend a demo session before enrollment?

Yes. We arrange a free demo for all the courses either in the Classroom or Live-Online demo. Please fill the demo request form below to schedule a free demo.

What if I miss a class?

You will never miss a lecture at myTectra. You can choose either of the two options:

Classroom Training:

If you miss one or few classes we can give a backup class based on trainer and your convenient time.
In case if you miss many classes, we can reschedule your class with upcoming batches or other running batches based on how many courses topics you have completed so far.

Live-Online Training:

View the recorded session of the class available in your LMS.
You can attend the missed session, in any other live batch.

What if I have more queries?

Just give us a CALL at +918047112411 OR email at support@mytectra.com

What are the payment options?

Payments can be made using any of the following options and a receipt of the same will be issued to you automatically via email for both classroom training and Online training.

Visa Debit/Credit Card
American Express and Diners Club Card
Master Card
PayPal
Net Banking/Wire Transfer
UPI Payment such as Google Pay, PhonePe, Paytm
Cash/Cheque/DD ( Not for Online Training )

Where do the classes take place?

For Individual:

Classroom Training - Bangalore

Live-Online Training - Globally

For Corporates:

Classroom Training - We deliver classroom training for corporate in more than 20 countries. Send us an Enquiry Now!

Online Training - Globally

* All of the classes are conducted live online. They are interactive sessions that enable you to ask questions and participate in discussions during class time. We do, however, provide recordings of each session you attend for your future reference.

Who are the Trainers?

Our Trainer’s are chosen not only for their knowledge and expertise but also for their real-time experience in the respective courses.

How do contact for support queries after I enrolled for this course?

Your access to the Support Team is for a lifetime and will be available 24/7. The team will help you in resolving queries, during and after the course.

You can send an email to support@mytectra.com or submit the below form to create a ticket.

100+ Popular IT Courses to Learn.

15+ Categories. 500+ IT Courses to Learn.

Leadership Program

100+ Popular IT Courses to Learn.

15+ Categories. 500+ IT Courses to Learn.

Leadership Program

Financial Modeling with Advanced Valuation Training

About Program

Curriculum

Reviews

Faqs

Ask Us

About Program

Success Factors:

Curriculum

Faqs

Ask Us

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

Ask for Free Demo Now!

Yes, I want a demo!

Drop us a line