Financial Modeling Course

FINANCIAL MODELING COURSE 4.5/5
4834 reviews

Certification 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.

Financial Modeling Course

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.

WHAT IS FINANCIAL MODELING?

Financial Modeling is one of the most fundamental and widely sought after skills in the finance industry. It is the art of building a model to depict financial statements and investment analysis using MS Excel. This helps arrive at optimal business solutions by analyzing various parameters. At the end of the course,You will be able to do the task of building a model depicting financial statements/business model, which helps in decision making.

Learn Financial Modeling with us in the classroom environment with hands on experience. The first module is Equity Evaluations and the second module teaches advanced Excel. So you can make a model firstly, and then understand how to use that model for various purposes like projections, evaluations etc.

FINANCIAL MODELING COURSE TOPICS

Topic What I will Learn
Excel Tips 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
Topic What I will Learn
Case Study FMCG 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
Topic What I will Learn
Introduction to Project Finance 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
Topic What I will Learn
M&A I & II 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
Topic What I will Learn
Accenture Case Study 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
Topic What I will Learn
Macros I 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
Topic What I will Learn
Macros II 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
Topic What I will Learn
Charting 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
Topic What I will Learn
Advance Function 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 Course Material:

Quantitative Methods & Causes of Deadweight Loss

THE IDEAL CANDIDATE FOR FINANCIAL MODELING

This financial modeling course 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 course 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

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.

COURSE HIGHLIGHTS

Extensive Classroom Training

14 days (70 hrs.) Get trained by topic experts with interactive learning.

Excel Workbooks

Create models following a step-by-step approach devised by professionals. These workbooks have been specially designed to ensure you incorporate best industry practices of financial modeling.

Live Webinar

14 days Online Lectures with Recordings for all the topics.

Comprehensive study notes

Topic wise study material is provided in the form of presentations

Certification

EduPristine's Financial Modeling Course, Certified by BSE Institute Ltd.

Doubt Solving By Experts

Write to us and get your doubts solved by our experts within 2 business days. You can also initiate a discussion by posting it on active forums.

FINANCIAL MODELING COURSE BATCH DATES AND VENUE

Bangalore
Batch Starts From:6th Aug


Asha Plaza, Second Floor, #607, 80 Feet Pheripheral Road, Koramangala IV Block, Bangalore – 560095

Chennai
Batch Starts From:26th March.


Redsun Softech PVT. LTD, Temple Tower, 672, Anna Salai, Nandanam, Chennai, Tamil Nadu 600035

Delhi
Batch Starts From:29th July


EduPristine, #44,2nd Floor Regal Complex, Outer Circle, Connaught Place

Hyderabad
Batch Starts From:19th Mar


Hotel Kens, Road No.3, Sri Nagar Colony, Banjara hills

Pune
Batch Starts From: 19th Aug


Semat Institute of Excellence, 2nd floor tandle heights above moolchand sweets, senapati bapat road Pune Landmark - Opp. WS Bakers

Kolkata
Batch Starts From:9th Sept


Saltlake city Behind City Center - 1,
Kolkata -700064

Mumbai
Batch Starts From:TBD


3rd Floor, Khar Education Soc; S V Road, Near Khar Police Station, Khar West 400052

Mumbai (Dadar)
Batch Starts From:23rd Sept


L J Education & Training Centre, Next to Lazree Saree Shop, Behind Punjab National Bank, N C Kelkar Road, Dadar West 400028

Mumbai (Thane)
Batch Starts From:3rd Sept


Ritesh Tutorials, 408, Panchali Shopping Centre, Opp Nagrik Shop, Thane West

Mumbai (Borivali)
Batch Starts From:22nd July


L.N. college, Plot No. 89, Suman Education Society Campus, H.D. Gaonkar Vidya Sankul, Near General Kariappa Bridge, Rajendra Nagar, Borivali East, Mumbai, Maharashtra 400066

Mumbai (Andheri)
Batch Starts From:20th Aug


7th Floor, 702, Raaj Chamber, Old Nagardas Road, Next to Andheri subway, Andheri East Mumbai 400069

Online
24th June


Financial Modeling Training Highlights

Course Fees

33000

14 days Classroom Training (70 hrs)

Webinar Video Recordings for each topics

Downloadable Financial Models for Various Companies

Day wise Topic Access Materials & Downloadable Financial Models

Module-I: Financial Modeling using MS Excel

Case Studies Sessions

Module-II: Advance Financial Modeling

Access for Downloading Many Sample Models

Access Step by Step Model Templets

Study Notes: Downloadable Complete Course Material

Domain Specific MS Excel Workbook and Practice

Lecture Handout

Certificate of Participation / Excellcence

24 * 7 Access to Online Materials

Discussion Forum

Buy

FAQs

I am a rookie with MS Excel. Will it be difficult to learn Financial Modeling?

Absolutely not. You can create a financial model using only a pen and paper or calculator. Financial models existed even before we were introduced to Microsoft. Having said that, building financial models using MS Excel is an advantage.

90% of professionals use MS Excel. It is fast, accurate, easy to use and modular. Almost everybody in the corporate world communicates using MS Excel, and so there will be an unsaid expectation for you also to be sound in its knowledge.

This should not worry you. Our course on Financial Modeling will help you learn the nuances of making a financial model in a very basic step-by-step manner. By the end of the course you will be confident to make models for any company. To get acquainted to financial modeling, check out our downloads on models for LinkedIn, Zynga and GroupOn to see the power of MS Excel for Financial Modeling.

TESTIMONIALS

It provide great financial exposure to young graduated who are interested in making their career in finance. Highly qualified teachers and very supportive staff.


I must appreciate the whole team of edupristine to launch such a good course on Financial Modelling, as this is the need of the day where more and more complex business scenarios needs to be modelled in MS excel for better decision making.

SUBMIT A QUERY
Popular Courses
Disclaimer

GARP does not endorse, promote, review or warrant the accuracy of the products or services offered by EduPristine of GARP Exam related information, nor does it endorse any pass rates that may be claimed by the Exam Prep 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. ERP®, 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.php Post ID = 100910