support@edupristine.com1800 200 5835Request a Call
Call Me

Partners

BSE Logo

Financial Modeling Course in Kolkata

KOLKATA CLASSROOM PROGRAM

Unlike most of the other businesses, all finance professionals have to continuously work with large amount of numbers. Almost everyone uses MS Excel to create financial models to analyse and project financial statements. A mastery over financial modeling will give all the professionals an edge over others as they can do their work faster and with more accuracy.

ABOUT FINANCIAL MODELING

Number crunching is one the most important aspects of any job in the world of finance. Unlike other businesses, professionals in the finance industry have to work with large amounts of numbers. There is thus a need for people who have a good knowledge of MS Excel to create financial projections, analyze competition and markets and make financial models. A mastery over Excel is actually a way to excel in the finance world, as it ensures accuracy, speed and can give you that edge over your peers.

The EduPristine Financial Modeling course will teach you the basic of MS Excel all the way to creating successful Financial Models. By the end of the course, you will be able to independently build models that are robust and provide dynamic projections that can be used to thoroughly analyze a company from multiple standpoints: operations, investment, financing and valuation.

EXCEL IN THE FINANCIAL WORLD

The course will enable you to-

  • Value and analyze Firms, IPOs and FPOs in Financial Modeling.
  • Investments in nascent stages can be valued with accuracy with hands on Financial Modeling for eg. Private Equity/ Venture Capital Investing
  • Build your own financial models

THE IDEAL CANDIDATE FOR FINANCIAL MODELING

This Financial Modeling Course in Kolkata is suitable for students and professionals related to Investment, Equity Research, Credit, Project, Mergers & Acquisition, Corporate Finance, Critical Thinking and analytical skills. It is also ideal for CA, CFA Program candidates, FRM, MBA Finance, B TECH and Commerce Graduates who want a career in any of the above profiles.

Financial Modeling is also a suitable choice for those in non-finance related careers such as in the preparation of Business Plan, working on Excel, decision making and mapping theory to practical.

CAREER BENEFITS

Financial Models constructed in Financial Modeling help in decision making and business modeling for firms and check the viability of projects. You learn techniques to value and analyze Firms, IPOs and FPOs in Financial Modeling. Investments in nascent stages can be valued with accuracy with hands on Financial Modeling for eg. Private Equity/ Venture Capital Investing. Commercial Banks use Financial Modeling for disbursing loans for the projects; Project Management uses it for performance tracking of on-going projects. Financial Modeling concepts can be applied to any industry. Individuals who hold an MBA and also possess knowledge of Financial Modeling have an advantageous edge over others.

PRE-REQUISITES

Students should have hands-on experience with Excel and a brief idea about Finance, Balance Sheets and Cash Flow Models.

BATCH DATES

Course Date Address Phone
(Toll Free)
Enroll
Financial Modeling 25th Feb Camac Street, Kolkata - 700016 18002005835 Buy

Financial Modeling Course Topics

  • Understanding And Creating A Financial Model Template
  • Learning referencing (usage of $)Frame work in Excel
  • Learning Custom formatting in Excel
  • Excel Skills - Shortcuts, Formulas, Array Function and Pivot Tables
  • Implementing simple business modeling case in Excel
  • Simple exercise/models in excel
  • Data Collection and Data Structuring
  • Preliminary Scrutiny of the Data and Information
  • Understand the Business Model and Operating Model
  • Modeling the Historical Statement
  • Business Drivers Identification and Modeling
  • Modeling Assumptions for Future Action
  • Modeling Revenue Build-up - projecting the future revenues
  • Modeling Cost Build-up - projecting the future cost
  • Modeling the Asset Schedule
  • Modeling the Depreciation Schedule - Book and Income Tax Depreciation
  • Working Capital & Term Loan Modeling - Debt Infusion
  • Tax Modeling
  • Modeling MAT and MAT credit
  • Modeling Impact of Accumulated Losses, Current Tax and Deferred Tax on Tax Payble
  • Equity Modeling - Equity Infusion
  • Modeling Paid Up Capital and Share Premium Account
  • Modeling Retained Earning Schedule
  • Modeling the projected P/L and BS
  • Modeling the projected Cash Flow Statement
  • Conducting Covenant Testing
  • Performing Ratio Analysis
  • WACC and Cost of Equity Analysis
  • Performing Valuation using DCF (FCFF & Enterprise Value) and Comparable analysis (Relative Valuation)
  • Performing sensitivity/scenario analysis
  • Understanding the Project Finance Model
  • Characteristics of Project Finance
  • Risk and contractual arrangement to Mitigate Risk
  • Understanding the Escrow Arrangement
  • Incorporating Date, logical functions and flags to make the Model Flexible
  • Incorporating Delays in the Model
  • Cash Flow Waterfall model - Modeling Payoffs to Investors using Goal Seek
  • Implementing Interest During Construction and Breaking Circular Loops
  • Meaning and categories of M&A
  • Merger motivations
  • Forms of payment in a Merger Deal
  • Hostile Vs Friendly offer
  • Evaluating a Merger Bid
  • Merger Analysis - Key Drivers and Inputs
  • Accretion/Dilution Analysis
  • Merger Plan - Ownership Vs Deal Price
  • Modeling a financing plan
  • Performing sensitivity analysis on Acquirer's EPS
  • Performing Contribution Analysis
  • Estimating value of a Merger Transaction
  • Discounted Cashflow Analysis
  • Comparable Company Analysis
  • Comparable Transaction Analysis
  • Data Collection from Public Sources
  • Understanding the Business Profile of the Company
  • Modeling Revenue & Expenses Drivers
  • Modeling Income Statement
  • Modeling Implied EBITDA
  • Balance Sheet Projections
  • Cash Flow Statement Projection
  • Performing Valuation And Sensitivity Analysis
  • Calculating Enterprise value and Implied Market capitalization
  • Introduction to Macros & Advanced Application Building in Excel
  • Key Concepts in Macros
  • Macros as recorded Robots!
  • Form Controls and Active X controls
  • Implementing user forms in Excel Macros
  • Linking forms to excel cells
  • Building flexible Charts in Excel
  • Understanding VBA - Sub & Functions
  • Understanding the Relevant Language Constructs
  • IDC Implementation using Macros
  • Breaking Circular Loops using Macro
  • Monte Carlo Simulation
  • Basics of Debugging VBA Code
  • Building Primary & Secondary Axis in a Chart
  • Radar Charts - Showing the progress of Commercial Property Development
  • Waterfall Charts - Showing Funding Breakup for Renewable Energy project
  • Football Field - Showing Valuation Summary using Different Parameters
  • Gantt Chart - Tracking the status of an Ongoing Project
  • Named Ranges
  • Index Match
  • Array Functions
  • Building Scenarios using Offset Functions
  • Creating growing models & Index functions
  • Usage of Indirect Functions
  • Usage of Goal Seek and Solver Functions

Sample Preview of our material: Quantitative Methods && Causes of Deadweight Loss

LinkedIn , Groupon Models et al.

VENUE: KOLKATA

Edupristine, Camac Street, Kolkata - 700016.

ABOUT KOLKATA

Kolkata, known historically in English as Calcutta, is the capital of the Indian state of West Bengal. Located on the east bank of the Hooghly river, it is the principal commercial, cultural, and educational centre of East India, while the Port of Kolkata is India's oldest operating port as well as its sole major riverine port. As of 2011, the city had 4.5 million residents; the urban agglomeration, which comprises the city and its suburbs, was home to approximately 14.1 million, making it the third-most populous metropolitan area in India. As of 2008, its economic output as measured by gross domestic product ranked third among South Asian cities, behind Mumbai and Delhi.

testimonials

Financial Modeling course is very comprehensive, covering a wide range of aspects of finance industry. It gave me a good exposure to Financial Modeling and practical exposure of valuation specially DCF and Relative Valuation technique. All the faculty members have relevant industry experience and are very helpful. I take this opportunity to thank the faculties and the management of EduPristine for honing my Excel and Valuation skills, which helped me to get placed in Dion Global Solutions Pvt. Ltd. as Research Analyst.

I would like to take this opportunity to express my heartfelt thanks to team EduPristine for giving me the opportunity to work in ONICRA. It was really a very wonderful experience of interview in ONICRA as the atmosphere was friendly and i was quite comfortable.

related links


For Corporate Enquiries
Contact
corporate@edupristine.com
SUBMIT A QUERY
Popular Courses
Disclaimer

Global Association of Risk Professionals, Inc. (GARP®) does not endorse, promote, review or warrant the accuracy of the products or services offered by EduPristine for FRM® related information, nor does it endorse any pass rates claimed by the provider. Further, GARP® is not responsible for any fees or costs paid by the user to EduPristine nor is GARP® responsible for any fees or costs of any person or entity providing any services to EduPristine Study Program. FRM®, GARP® and Global Association of Risk Professionals®, are trademarks owned by the Global Association of Risk Professionals, Inc

CFA® Institute does not endorse, promote, or warrant the accuracy or quality of the products or services offered by EduPristine. CFA® Institute, CFA® Program, CFA® Institute Investment Foundations and Chartered Financial Analyst® are trademarks owned by CFA® Institute.

Utmost care has been taken to ensure that there is no copyright violation or infringement in any of our content. Still, in case you feel that there is any copyright violation of any kind please send a mail to abuse@edupristine.com and we will rectify it.

dm_classroom_courses_offering.php Post ID = 98987