Go Back   2023-2024 StudyChaCha > StudyChaCha Discussion Forum > General Topics

Old April 30th, 2016, 06:22 PM
Super Moderator
Join Date: Nov 2011
Default Re: Short Term Courses in Finance in Delhi

The All India Management Association (AIMA) was created as an apex body of professional management with active support of the Government of India and Industry in 1957.

AIMA is a group- a body to pool management thoughts in the country, a forum to develop a national managerial ethos, an organisation to facilitate the furtherance of the management profession in the country.

Financial & Valuation modeling program involves the fundamental theories and practices of valuation analysis, strategy analysis, prospective analysis, DCF modeling, trading comparables and transaction comparables.

Duration: Four Months

Session Commences: January, May and September


-Graduation (10+2+3) in any discipline from a recognized University / 3-year Diploma in any discipline if equivalent to graduation.

-Students in the final year of a degree course may provisionally register for the program.

-Students doing other professional courses like MBA, MFS, CA, CS, ICWA can do this course concurrently.

Program Fee & Study Material
-Rs. 28,000/- payable at the beginning of the Program (a service tax of 14.5% would be applicable).
-Books would be provided.

Course Outline

Session 1

Introduction to Excel and Financial Modeling
-Introduction to Excel
-Overview of Financial Modeling
-Types and Purpose of financial models
-Navigate Worksheets and Workbooks
-Name Manager

Exploring Excel as a Tool for Financial Modeling
-Excel Functions
-Mathematical Functions
-Statistical Functions
-Financial Functions
-Logical Functions
-Lookups & Reference Functions
-Text Functions
-Date & Information Functions

Session 2

Advanced analysis techniques
-Working named ranges
-Working with Charts
-Data Validation
-Conditional Formatting
-Pivot Tables
-Auto & Advance Filter
-Grouping & Ungrouping
-Sheet Protection
-What if Analysis

Session 3

Financial Statement Analysis
Understanding the Financial Statements and its interlinking:
-Income Statement
-Balance Sheet
-Cash Flow Statement
-Ratio Analysis
Liquidity Ratio
Profitability Ratio
Solvency Ratio
Leverage Ratio
Activity/Turnover Ratio
-Basic and Diluted EPS
-ROE and DUPONT Analysis
-Case study on Ratio Analysis

Session 4

Introduction to Valuation
-Need to value companies
-Difference between price and value
-Different terms of value
Market value
Intrinsic value
-Valuation Techniques
Absolute Valuation
-Free Cash flow to Firm (FCFF)
-Free Cash flow to Equity (FCFE)
-Cost of Equity (Ke)
-Cost of Debt (Kd)
-Cost of Capital (WACC)
Relative Valuation
-Equity based Multiples: P/E, P/BV, P/S & PEG
-Firm based Multiples: EV/EBITDA, EV/EBIT & EV/Sales

Session 5 & 6

Making a complete fully integrated DCF Modeling Spreadsheet
-Understanding and creating a financial model template
-Calculating Growth Drivers and Future Assumptions
-Revenue Build-Up - Projecting the Future Revenues
-Cost Build-Up - Projecting the Future Cost
-Modeling historical & projected financial statements - P&L and B/S
-Building cash flow statement
-Asset and Depreciation Schedule
-Debt and Interest Schedule
-Building an integrated model for valuation using DCF
-Sensitivity/Scenario Analysis
-Incorporating other accounting details like revenue recognition , deferred taxes etc.

Session 7

Trading Comparables
-Introduction to Trading Comps
-EV Calculation
-Discussing various CACS Adjustments
-Income Statement Normalization
-Concept of LTM or TTM
-Trading Multiples analysis - EV/EBITDA, EV/EBIT, EV/Sales
-Case Study on Trading Comps

Session 8

Transaction Comparables
-Introduction to Transaction Comps
-Understanding Deal Considerations
-Introduction to Transaction Template
-Private and Public Transaction Comp
-Transaction Multiples analysis - EV/EBITDA, EV/EBIT, EV/Sales
-Case Study on Transaction Comps

Session 9

Investment Banking (IB)
-Introduction to IB
-Pitch Books
-Company Profiling
-Case Study on Company Profiling

Session 10 & 11

Project Finance Modeling
-Types of funding
Equity funding sources – cost, pros and cons
Debt funding sources – cost, pros and cons
-Characteristics of project finance
-Risks & Mitigants
-Contractual arrangements to mitigate risk
-Developing a fully integrated project finance modeling spreadsheet
-Interest during construction
-Escrow arrangement
-Cash flow waterfall
-Feasibility Analysis
-Scenario Building
-Project IRR, Equity IRR,NPV Profiling

Session 12 & 13

Advanced Excel using VBA Programming
-VBA macros introduction
-Introduction to VB editor
-Recording macros
-Personal Macro workbook
-Declaring variables
-Interactive macros
-Decision Making
-Looping (Do Loop, For loop)
-The excel object model
-The range object
-The worksheet object
-The workbook object
-User defined functions
-Create events
-Protecting macros

Session 14
Final Assessment and PPT

Session 15
Mock Interview
Feedback and Career Counselling Session

Contact Detail:
All India Management Association

Management House
14, Institutional Area, Lodhi Road, New Delhi 110003, India

011 - 24645100 / 011 - 24617354 / 011 - 43128100
Fax: 011- 24626689
Answered By StudyChaCha Member
Reply With Quote

Reply to this Question / Ask Another Question
Your Username: Click here to log in


All times are GMT +6. The time now is 02:14 PM.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2023, vBulletin Solutions Inc.
Search Engine Friendly URLs by vBSEO 3.6.0 PL2

1 2 3 4 5 6 7 8