011-47519207

+91-9873140018

hr@slaconsultantsindia.com

Follow Us


Most Updated Practical Training With Interview Guarantee(PG Available)@ +91-9999491895

CORPORATE FINANCE TRAINING (MODELING & EQUITY)

IT jobs are waiting. What are you waiting for?

SLA Consultants India, has been steadily rising as a corporate training & development leader to take care of all client’s & learners needs in a comprehensive framework. We have maintained consistency and stability in providing quality training & interviews since inception and this is all what makes us stand a name in the industry. Utmost professionalism in covering up for client’s training & development requirement with improbable methodologies in analyzing quality of training & development and timely assessment are some of our tools that we adopt in encouraging our proficiency in delivering quality services.

Programme Highlights

Certification

Industry acceptable certification for all training which help fresher/Experienced to up-skill at corporate.

Experienced Faculty

Only Working Professions/Sr. Consultant/CA/CS/Best Freelancer with 10-15+ years deliver training.

Placement Assistance

After completion of 70% training our dedicated placement team arrange interview till placement.

Lab Facility

Practical Training help to gain exposure like corporate level with technical test series.

Workshop Sessions

Real time projects & best case study makes SLA workshop very unique and lively for learners.

Admin Support

For Learner's, Our admin team fresh batch schedule/re-scheduling classes/arrange doubt classes.

CORPORATE FINANCE TRAINING (MODELING & EQUITY)

Course Duration: 120 – 135 Hours

SLA Consultants CORPORATE FINANCE TRAINING (MODELING & EQUITY) Training Review & Delivery Method:

Web / Desktop Base.
Instructor-Led Classroom Sessions.
Presentations/Demonstration/Practicals of concepts.
Handouts/Assignments/Real-time Exposure to work on Clients.

NOTE: Classes Are Also Available On Module Basis

Why learn Financial Analyst

PROGRAMME DETAILS

programme modules

Advanced Excel

Lookup & Reference Functions:-VLookup, HLookup, Index, Match, Offset, Indirect, Address, Column, Columns, Row, Rows, Choose, Arrays Concept In Lookup Formula’sSum, Sumif, Sumifs, Count, Counta, Countblank, Countif, Countifs, Average, Averagea, Averageif, Averageifs, Subtotal, Aggregate, Rand, Randbetween, Roundup, Rounddown, Round, Sumproduct.

Text Functions & Data Validation:- Char, Clean, Code, Concatenate, Find, Search, Substitute, Replace, Len, Right, Left, Mid, Lower, Upper, Proper, Text, Trim, Value Date, Day, Month, Year, Edate, Eomonth, Networkdays, Workday, Weeknum, Weekday, Hour, Minute, Second, Now, Today, Time.

Logical Functions:-And, Or, If, Iferror, Not, Nested If, Isna, Isblank, Iserr, Iseven, Isodd, Islogical, Isytext, Max, Min

Data Management:- Data Collection Method With Data Quality, Collaboration & Security Like Share Your Workbook On Share Drive With Quality

Analysis:- Single/Multidimensional Analysis, Like Three Dimensional (3D) Tables Sensitive Analysis Like Data Table, Manual What-If Analysis, Threshold Values, Goal Seek, One-Variable Data Table,

Advanced Chart, Graph & Dashboard:- Advanced Chart Technique, How To Make Dynamic Charts, Bar Charts, Pie Charts, Scatter Chart, Line Chart, Column Chart, Speedometer Chart, Gantt Chart, Two-Variable Data Table

Advanced Filter, Validation & Pivot Table:- Filters (Basic, Advanced, Conditional), Sort (Ascending, Descending, Cell/Font Color), Conditional Formatting, Data Validation, Group & Ungroup, Data Split. Pivot Table and Charts, Import and Export Data, Protect/Unprotect Sheets/Workbooks, Worksheet Formatting and Print Display.

Advanced Dashboard & VBA / Macros Programming Objective
  • To Define KPIs (Key performance Indicator), Customer Service Dashboards or Project Management Dashboard (Gantt  Chart)
  • Dashboard Reports Based on Tables and Number or Charts/Graphs or Both.
Introduction to Programming Introduction to logical thinking flowcharts & algorithms:
  • Define Objective, Start & End Points; Identifying Solution & Breaking it Into Sequential Steps Writing a
  • Step-by-Step Instructions, Flowcharts, Process Flow Diagrams. Excel Macros – an Introduction
Complete Review of the VBA Language (Subs, Functions, Variables, Arrays, Loops, Logic…etc.)
  • Excel Macro Language Review (VBA) Including Variables, Data Types, Constants, Arrays, Operators, Expressions, Loops, Logic Decisions And Calling
  • Overview Of Commanding Excel Using VBA Including A Discussion Of Objects, Properties And Methods
  • The Power of Macros – What, When, How to use Macros. Introduction to Object Oriented Programming
  • Objects, Its Functions, Methods and Properties Introduction to Events
  • Details of Events, How & When to use of Events, Preparing to ‘Macro’ Visual Basic Editor (VBE) – Developer Tab, Security
  • Introduction to the VBE, Properties window, Project Explorer, Password Protection of Code How to use the VBE – Features, Options, Intelligence Technology
  • Debugging Mode, Bookmarks, Breakpoints, Watch Window, Immediate Window and Locals Window Inbuilt VBE Help Feature – Tips and Tricks
  • Form Controls vs. ActiveX Controls Getting into the Code
  • Message Box and Input Box Working with Data in Excel through VBA
  • Data Types, Constants and Variables
  • Different type of data type; How and When to use Variables to Store Information.
  • For-Next, For-Each, Do-While, Do until, Do Loop Decision-Making and Code Branching
  • If-Then-Else, Select-Case, And/or Nested Conditions
  • What is user’s Defined Functions? How to create & use them.
  • Use of Arrays in VBA programming with one dimensional, two dimensional or multi-dimensional analysis
Excel VBA Power Programming For VBA Macros
Overview of Using User forms To Create Business Wizards
  • Working with User Forms & User Forms Events like List box, Combo box, Option Buttons, Check box, Text box, Labels, Command button, Toggle button.
  • How to create dynamic dashboard on user form with different controls
  • How to link various user form with each other to create a complete interface between user and system
Connection between Excel VBA & other platforms
Testing and Debugging Your Code
Effective Error Handling
Automation Development Reports & Live Projects
Financial Modeling
A. Workshops
  • Simple exercise/model in excel
  • Flags to make the Model Flexible
  • Understanding Business Model And Creating a Financial Model Template
  • Identification of Business Drivers and Modeling
    • Implementing simple business modeling case in Excel
B. Modeling
  • Project cost and its typical components
  • Modeling Assumptions for Future projections
  • Capital Expenditure phasing and modeling
  • Infusion of debt and equity
  • Modeling financial projections
  • Implementing Interest During Construction
    • Creating macros and Breaking Circular Loops
  • Term Loan Modeling – Debt schedule – Monthly, Quarterly and annual schedules
  • Modeling the Depreciation Schedule – Book and Income Tax Depreciation
  • Modeling Working Capital Tax Modeling
  • Adjusting accumulated losses
  • Modeling MAT and MAT credit
  • Modeling Dividend / Retained Earning Schedule
  • Custom formatting for checks and balances
C. Valutation & Decision
  • Creating and Modeling financial statements from the various schedules
    • P&L
    • Cash flow statement
    • Balance Sheet
  • Analysis – (Case Study)
    • Performing sensitivity/scenario analysis
    • Performing Ratio Analysis
    • Conducting Covenant Testing
    • Assessment of debt serviceability – DSCR
    • Calculating Returns
    • Project IRR
    • Equity IRR
    • Performing Valuation using DCF (FCFF and Enterprise Value)
D. Project Finance
  • Understanding the Project Finance Mode
  • Characteristics of Project Finance
  • Risk and contractual arrangement to Mitigate Risk
  • Understanding the Escrow Arrangement
  • Cash Flow Waterfall model
  • Basics of Public Private Partnership (PPP) framework
E. Workshops
  • Creating a financial model from scratch>
  • Making modeling assumptions
  • Modeling all schedules
  • Creating all financial statements
  • Calculating viability & returns
Equity Research
A. Objectives
  • To give you the capacity to understand the theory and apply, in real world situations, the techniques that has been developed in equity research
  • To give you the big picture of equity research so that you can understand how things fit together.
  • To show you that equity research is fun.
B. Approach: Prepare Equity Research Model (base)
  • Prepare a blank excel sheet with separate Income Statement, Balance Sheet and Cash Flows and use neat formats
  • Populate the historical financial statements and do the necessary adjustment for non-recurring items (one-time expenses or gains).
  • Perform the Fundamental Analysis (Ratio Analysis) for historical years (vertical analysis, horizontal analysis and trend analysis and calculate ROEs using DuPont).
Module – 4.1 Prepare Equity Research Financial Model
Module – 4.2 Valuations
Module – 4.3 Calculate Target Price
Please find the course and fee details. Classes & Course can be designed/customize as per request
Fee According to Module:-
Course Module     Course Duration   Current Fee
Module 1- 5 120 – 135 Hours 39,500/-
Module 1- 3 90 – 100  Hours 27,500/-
Module 3 – 4 80 – 85  Hours 30,500/-
Module 1,2 & 4 90 – 100  Hours 27,500/-
   Note:        Service Tax Applicable on all Course Module
DOWNLOAD BROCHURE

Testimonials

FAQ

For Freshers

I am text block. Click edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

For Professionals

I am text block. Click edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

For Business Owner

I am text block. Click edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

For Freshers

I am text block. Click edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

For Professionals

I am text block. Click edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

For Business Owner

I am text block. Click edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

Latest Blogs

    No posts were found.

Get In Touch