info@ciansacademy.com +91 9818955001

Financial Modeling Course (Foundation)

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

15,000 Enroll Now

KEY FEATURES


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

COURSE DESCRIPTION


Financial modeling is a necessary skillset for individuals pursuing a career in private equity, investment banking, and equity research. These industries constantly engage with excel models to assess the potential of any deal or returns from a project. They rely on models to estimate the future growth, calculate the current valuation, and identify any trend that may impact their investment decisions. Here’s where financial modeling course comes in. Having liaised and worked with global financial institutions, we believe financial modeling 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
Our past students have been placed in companies such as Fidelity, KPMG, BlackRock, Axis Bank, EY, Finvista, and REquity. Many have also been absorbed internally in Cians Analytics.
After completing the course, students will be able to address the following questions:
  1. Read and analyze financial statements
  2. Source information for building a comprehensive valuation model
  3. Understand the basic techniques of equity valuation
  4. Learn useful MS Excel functions and shortcuts referred to in building financial models
  5. Capture historical numbers from company filings
  6. Identify revenue drivers of any company
  7. Build a bottom-up revenue model
  8. Understand a top-down revenue model
  9. Build a fully integrated three-step financial model
  10. Build asset and debt schedules
  11. Plug the revolver facility in the cash flow statement to cover any deficit caused by an increase in the working capital
  12. Interlink the three financial statements to reconcile numbers and match the balance sheet
  13. Perform a DCF analysis for valuing the theoretical price of any company
  14. Perform scenario and sensitivity analyses
  15. Perform ratio analyses and understand the different ratios and their interpretation
  16. Understand the process for identifying peer set of a company to conduct a relative valuation
  17. Understanding valuation using transaction comparables
  18. Performing Football Field Analysis
The program is divided into three modules:
  1. Financial Accounting and Valuation
  2. MS Excel
  3. Financial Modeling
  • 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 financial arena)
  • 100% assured interview for the position of Analyst at Cians Analytics (after clearing the financial modeling test)
  • Internship opportunity as per requirement (after clearing the financial modeling test)
  • Guidance on important interview questions asked frequently in finance jobs
  • 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 9818955001
  • You an also send any query by filling Contact Us Form

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 modeling 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 the three financial statements
  3. Importance of equity valuation
  4. Techniques of equity valuation – DCF, Trading & Transaction Comparables
  5. Sum of the Parts Method (SOTP Analysis)

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.

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 revenue and top-down approaches
  4. Building cost buildup
  5. Projecting 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. Inter-linkage of 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

Placements


  • BlackRock
  • EY
  • Fidelity
  • KPMG
  • Cians Analytics
  • Finvista
  • Axis Bank
  • MCube
  • REquty
  • ICICI Bank
  • PWC
  • Others

Batch Dates


  • Weekday: Oct 30– Nov 3, 2017 (Monday–Friday)
  • Weekend: Dates will be announced soon
  • 5-day classroom training spread over 30 hours
  • Class Timings: 10.30 AM–5.00 PM
  • Fees is INR 15,000 + GST
  • Location: 556, Tower B2, 5th Floor, Spaze iTech Park, Sector 49, Gurgaon, Haryana, 122018