Financial Modeling Certification

Key Features of the course
25 hours of instructor led training + additional 15 hours of videos
Batch limited to a maximum of 10 students
Lifetime access to e-learning courseware
Excel Templates for practice
Industry Sector specific documents
Training from industry expert
Get exposed to industry case studies and live examples
Application oriented learning – Apply what you have learnt in theory in your MBA, CFA course
Actual hands on test
Support while model creation
Career assistance by interacting with the Industry practitioners
Learn Excel shortcuts, Tips and Tricks

Topics Covered

Everything is done on excel period
Learn basic and advanced Excel skills
Understanding different company filings and financial statements
Creating a financial model template
Constructing and projecting a financial model
Revenues drivers
Cost drivers
Debt and interest expenses schedule
Fixed Assets Schedule
Key financial statements – Linkages of Income statement, Balance sheet and cash flow statement
Ratio analysis
Company Valuation
Relative valuation – P/E, P/B, EV/EBITDA, EV/Sales models
Absolute valuation – FCFF, FCFE models
Scenario analysis
Sensitivity analysis

Who should attend

MBA Students, Professionals looking to switch career to equity research, project valuation, equity valuation. CFA students who want to get practical exposure.

Pre-requisites

None. However, students would be given excel videos before the class to get basic idea about excel.

What you need to bring

Laptop, pen and copy.

Key Takeaways

Access to step by step model template
Basic study material for financial modeling and tip sheet for excel shortcuts
Selected videos covering
Basic and Advanced Excel
Financial Reporting
Industry Analysis
Doubt clearing session through
Email – Assured response within 48 hours
Phone/Online – Schedule a 30 min meeting to go through your financial model