Financial Modeling Trainings
Click here to skip the story and buy the Financial Modeling Training
What is Financial Modeling?
The objective of the training is to help the candidates to prepare Integrated Financial Models to enable decision making in areas like, Corporate Finance, Equity Valuation, Credit Analysis/Appraisal, Investment banking, Project Appraisal, M&A, etc.
What Topics are Covered?
The course contents for Module I are,
| Module I Topics: | |||
| Understanding and creating a financial model template | Excel Skills – Shortcuts, Formulas and cross referencing | Historical financial statement modeling (P&L and B/S) | Calculating growth drivers |
| Building the asset and depreciation schedule | Building debt & interest schedule | Building cash flow statement | Building interest on excess cash and cash revolver |
| Building ratios for analysis | Updating integrated model for valuation using DCF and Comps | Sensitivity/Scenario Analysis | Modeling other Accounting concepts - Revenue Recognition, Deferred tax etc |
| Project Finance Modeling covering Infrastructure sector | Merger & Acquisitions Analysis | Buy | |
The course contents for Module II are,
| Module II Topics: | |||
| Introduction to VBA | Writing & Recording Macros | Working with Cells & Ranges | Writing Iteration loops in Excel |
| Monte Carlo Simulation | Advanced Scenario Analysis using Macros | Incell Charts using sparklines | Form Controls & Active-x Controls on Excel |
| User Excel Forms | Advanced Functions for Financial Modeling | Building Flexible Models Using Offset Function | Revenue buildup Using Index - Match function |
| Using Indirect function for consolidation | Calculating Synergies using Excel Solver | Implementing Loss Carried Forward | Application of Array functions |
| Advanced Charting Techniques | Waterfall Model, Football field, Dupont Analysis | Creating a complete dashboard | Buy |
Course Highlights
- Module 1: 30 Hrs - 6 days of comprehensive training
- Module 2: 20 Hrs - 4 days of comprehensive training
- Practicing Faculty with investment banking experience
- Pristine has conducted Financial Modeling Trainings for leading organizations namely JP Morgan Chase, E&Y, ING Vyasa, HSBC, BOA Continuum, IDBI, STCI, Accenture, IITB, Bits Pilani, IIM C, FMS, Mizuho Bank etc
- Case Study based learning
- Certification of Participation for all the Candidates
- Excellence certificate to candidates based on their performance
- 24x7 Online Access*
- To Course Material (Presentations, Explanations, Models, Notes)
- Forums to interact with faculty & fellow students
- *Access is valid for 1 Year.
- Early Bird Discount of 5 % on registering 10 days prior to launch of the course
- Group Discount of 10% for 3 people
- Group Discount of 20% for 5 or more
| Module I - INR 12000 | Module II - INR 10000 | Both - INR 18000 |
| Buy | Buy | Buy |
Financial Modeling Training Schedule
| City | Dates | Venue | Contact |
|---|---|---|---|
| Mumbai | Jan 21st | Khar Education Society, Khar West | Maitri |
| Hyderabad | March 17th | Pasha College of Engineering, Banjara Hills | Dikshu |
| Delhi | Jan 14th | 104, Arunachal Bhawan, Barakhama Road, Connaught Place | Sanjay |
| Pune | March 24th | SCDL 1065 B,Gokhale Cross Road, Model Colony | Dikshu |
| Bangalore | Feb 18th | RNIS, No.506,S 501,5th Floor,Manipal Centre,Rear Wing,North Block, Dickenson Road, | Sandeep |
| Chennai | Jan 7th | Pristine T.Nagar, Near GRT Grand Hotel | Sandeep |
Download our Models
Register here for Free Models
Contact Details
Free Seminars
Testimonials
I would like to take this opportunity to express my appreciation for the Pristine Financial modeling training. The content of this course is industry relevant and has been designed to equip the participants with tools that are required to build basic as well as complex financial models. Even though I didn’t have any prior knowledge of excel; I could easily keep at pace with the class because of their excellent teaching methodology and expert faculty. I would recommend it to those who wants to learn the basics of excel as well as gain knowledge on different sectors of an economy. From my experience, I can tell that learning what they teach at Pristine gives you an edge over your peers and in the job market.
Mohsin Khan, MumbaiBusiness school education does prepare students with fundamentals and concepts specially related to finance as it a much pursued field. However, the limited background of students necessitates the role of Pristine in bridging the gap between capabilities and aspirations. To understand what can be learnt in a few hours of interaction with Pristine, I think one has to go through the session. Nuances such as shortcuts that help one to navigate and master MS Excel and critical financial concepts such as cash flow calculations and depreciation amounts are all covered in a lucid flow. The entire session goes through as a case, so one actually does the numbers and when the balance sheet balances in the end, the Zen is achieved. Thank you Pristine for busting the myth of finance and financial modeling. Looking forward to more!
Nipun Rastogi, MBA Student, Class of 2012, Indian School of Business