info@ciansacademy.com +91 9818955001

Advanced Financial Modeling (Investment Banking Course)

Duration: 60 Hours Fees: INR 22,000 + GST* Weekday Batch Starts: Oct 30, 2017 Weekend Batch Starts: Dates will be announced soon

22,000 Enroll Now

KEY FEATURES


  • Learn to build financial models like experts
  • 100% placement support
  • Certificate of Completion
  • CA/CFA Faculty
  • Guidance on important interview questions
  • Small batch size for focused attention

COURSE DESCRIPTION


Financial modeling is a black box for individuals pursuing a career in investment banking, private equity, and equity research. These industries constantly engage with MS Excel models to assess the potential of any deal or returns from a project. They rely on models to estimate future growth, calculate the current valuation, and identify trends that may impact their investment decisions. Cians Analytics – our parent firm – works with leading investment banks across the globe, and we believe sound financial modeling skills are indispensable. It is a three-legged stool based on:
  1. Accounting and valuation concepts
  2. Proficiency in MS Excel
  3. Structure and design of models, which keep evolving based on industry best practices
The investment banking course has been prepared to equip participants with comprehensive knowledge on equity valuation, deal analysis, and business valuation as done by investment bankers. This will provide a strong foundation to build industry-specific models that are often demanded as one advances in his/her career. After completion of the course, students will be able to build comprehensive financial models from scratch and use them to aid myriad decisions, including investing, financing, and dividend (just like analysts do in the investment banking space). Our past students have been placed in companies such as Fidelity, BlackRock, KPMG, MCube, Axis Bank, EY, Finvista, and REquity. Many have also been absorbed internally at Cians Analytics.
The program is divided into six modules:
  1. Accounting and Valuation
  2. Advanced MS Excel
  3. Advanced Financial Modeling
  4. Project Finance Overview
  5. Leverage Buyout Overview
  6. Financial Modeling Mock Test
  1. Read and analyze income statement, balance sheet, and cash flow statement
  2. Work on MS Excel and use efficient formula construction
  3. Use advanced MS Excel functions to build dynamic templates
  4. Build a comprehensive financial model from scratch
  5. Identify revenue drivers and cost drivers using operating metrics
  6. Build a bottom-up and top-down revenue projections
  7. Audit and fix circularity problems, iterations, and other reconciliation errors
  8. Source information from public filings and capture historical data
  9. Explicate the techniques, elements, and approaches of forecasting
  10. Apply the concept of discounted cash flow using FCFF and FCFE
  11. Calculate equity valuation multiples
  12. Build asset and debt schedules
  13. Plug the revolver facility in the cash flow statement to cover any deficit caused by an increase in the working capital
  14. Interlink the three statements to reconcile numbers and match the balance sheet
  15. Perform discounted cash flow analysis for valuing the theoretical price of any company
  16. Perform scenario and sensitivity analyses
  17. Perform ratio analyses and understand the different ratios and their interpretation & relevance
  18. Understand and perform trading/transaction comparable analysis
  19. Understand and walk through a simple LBO model (very popular in investment banking)
  20. Understand and build a project finance model to analyze feasibility
  21. Build a simple dashboard to capture the output
  • CA, MBA, and CFA aspirants/candidates who want to pursue a career in finance
  • Undergraduates who want to bridge the gap between theory and practice, and learn about the work streams of a research desk
  • Working professionals who need to build or read end-to-end valuation models to make recommendations or write reports
  • Professionals who want to switch career to finance or students who want to get a head start before taking up a job
  • Completion certificate (highly valued as Cians Analytics is a trusted name in investment banking)
  • 100% assured interview for the position of an Analyst at Cians Analytics (after clearing the financial modeling test)
  • Internship opportunity as per company requirements
  • Guidance on important interview questions asked frequently by recruiters in top banks and investment management firms
  • Personalized attention in a maximum batch size of 10 students (our motto is quality teaching)
  • Click on the “Enroll Now” button and complete the payment via CC Avenues payment gateway
  • In case of any query, please write to us at info@ciansacademy.com or call us at 9818-955-001
  • You an also send any query by filling Contact Us Form
  • Program Fee: INR 22,000 plus GST
  • Early Bird Discount: Available
  • Group Discount: Available

CIANS ACADEMY


  • Cians Academy is the training vertical of Cians Analytics (based out in Gurgaon)
  • The courses are especially relevant for people who want to work in the financial services industry or become conversant with financial analysis
  • Our students have been placed in many reputed finance companies apart from getting absorbed in Cians Analytics as an Analyst

CIANS ANALYTICS


  • Cians Analytics is a financial research and consulting firm that works primarily with global private equity firms, hedge funds, and investment banks
  • The range of work at Cians Analytics includes studies focused on analyzing and valuing companies using best financial modelling practices, helping with due diligence and various other analyses

COURSE CONTENT

OVERVIEW OF ACCOUNTING & VALUATION

  1. Overview of the income statement, balance sheet, and cash flow statement
  2. Overview of accounting adjustments, such as working capital changes, deferred revenue, and DTA/DTL, and their impact on income statement, balance sheet, and cash flow statement
  3. Importance of equity valuation
  4. Techniques of equity valuation – DCF and Trading & Transaction Comparables
  5. Sum of the parts method (SOTP Analysis)

It is advisable to register early to read the pre-course handbook on these topics before coming to the first class. The pre-course handbook will be sent via email as soon as the registration is complete.

BASIC MS EXCEL

  1. Basic layout and shortcuts of MS Excel
  2. Basic and conditional formatting
  3. Basic Charting – line & bar charts, pie charts, combo charts, etc.
  4. Pivot tables
  5. More than 30 Basic MS Excel functions, such as logical functions and reference functions, that are widely used in client work
  6. Goal seek and revolver

EQUITY VALUATION MODEL

  1. Overview of a listed company and the sector used for the case study
  2. Data sourcing and creating historical income statement and balance sheet
  3. Forecasting revenues using bottom-up and top-down revenue approaches
  4. Building cost buildup
  5. Projecting of financial statements
  6. Building an asset schedule
  7. Building a debt schedule

EQUITY VALUATION MODEL

  1. Projecting interest expense and dealing with the circular referencing error
  2. Revolver adjustment
  3. Interlinking debt and asset schedule with projected statements
  4. Understanding common mistakes that happen during the linking process

EQUITY VALUATION MODEL

  1. Performing DCF analyses using the FCFF approach
  2. Performing sensitivity analyses (single- and two-variable tables)
  3. Performing ratio analyses
  4. Valuation using trading comparables
  5. Valuation using transaction comparables
  6. Football field analysis

ADVANCED MS EXCEL

  1. Advanced functions, including Match/Index, Offset, Indirect, String, Date, and Array
  2. Understand niche functions, such as Networkdays.Intl, Yield, Transpose, Forecast and Trend, Text, Mod, Db, Sln, Ipmt and Ppmt, Find, Len, Left, Right, Mid, and Mirr
  3. Regression analysis
  4. Advanced charting, including Waterfall, Dynamic, and Gantt charts
  5. Building switches to incorporate different scenarios

ADVANCED FINANCIAL MODELING

  1. Overview of Beta and its calculation
  2. Performing sensitivity analysis using 3D tables
  3. Circular error check and correction
  4. Auditing and methods to correct balance sheet differences
  5. What are investment banks and what do they do
  6. Pitch books
  7. Mock Financial Modeling Test (2 hours) and its analysis to identify any weaknesses

LBO MODEL

  1. Overview of the global LBO market, know-how, and characteristics of an LBO target
  2. Understanding the template to analyze an LBO
  3. Building Sources and Uses table
  4. Allocating goodwill based on purchase price

LBO MODEL

  1. Creating pro-forma balance sheet to adjust for deal assumptions
  2. Incorporating flexibility for different debt tranches
  3. Applying adjustments for cash sweep
  4. Performing an LBO analysis using a case study

PROJECT FINANCE MODEL OVERVIEW

  1. Overview of the project finance model
  2. Understanding the template to analyze project feasibility
  3. Building escrow adjustments, including Cash Reserve Escrow Account and DSRA
  4. Incorporating adjustments for project phasing and government subsidy (if applicable)
  5. Building Cash Waterfall to gauge cash flows from the project
  6. Building Waterfall Distribution to gauge payoffs to investors
  7. Building a robust dashboard to capture the output

Our aim is to ensure that upon completion of the course, the candidate comes out well-versed with the right skill set to build robust valuation models. The investment banking course covers all the core points that a financial analyst must know in a short span of time by weeding out all the unnecessary and irrelevant topics that elongate course duration and charge higher fee (as done by other institutes in Delhi/NCR providing investment banking courses).

Placements


All students will have an 100% interview at Cians Analytics for the position of Analyst. Our alumni have also been placed in the other prominent finance companies such as:
  • BlackRock
  • EY
  • Fidelity
  • KPMG
  • Genpact
  • Finvista
  • Axis Bank
  • MCube
  • REquty
  • ICICI Bank
  • PWC
  • RocSearch

Batch Dates


  • Weekday:  Oct 30– Nov 10, 2017 (Monday–Friday)
  • Weekend: Will be announced soon
  • Class timings: 10.30 AM–5.00 PM
  • 10 day course
  • Location: 556, Tower B2, Fifth Floor, Spaze iTech Park, Sector 49, Gurgaon, Haryana, 122018
  • Delhi, Noida, and Faridabad residents can also use Shuttl App that provides AC Chartered buses to our office