Authorization
Partnership with IIM Indore Equiti Club and Acadcom for certification and test.
Topics Covered
| Module I:Valuation Modeling |
| Understanding Integrated Financial Models |
| Scenario Analysis |
| Excel Efficiency – Shortcuts and formulae |
| Cash and Interest Revolver |
| Building Historical Financial Statements |
| Ratio Analysis |
| Projecting Financial Statements |
| Valuation – DCF and Comps |
| Module I:Merger & Acquisition (M&A) Analysis |
| Building Merger Inputs |
| Stock and Cash Mix Deal |
| Contribution Analysis |
| Accretion and Dilution |
| Download Sample Model – iGate-Patni |
| Module I:Project Finance Modeling |
| Understanding Date functions |
| Modeling Cash flow waterfall |
| Modelling Delays in Projects |
| Circular references and modelling IDC |
| Module II:Macros for Financial Modeling |
| Writing & Recording Macros |
| Working with cells and ranges in VB |
| Using Excel Form Controls for flexible GUI |
| Case study - Breaking circular loops |
| Understanding VBE |
| Case study - Monte Carlo Simulation |
| Module II:Advanced Functions for Financial Modelling |
| Using advanced functions like Offset, Index |
| Modeling using Named Ranges |
| Advanced lookups using Index and Match |
| Modeling synergies using Solver |
| Download case on Offset for scenarios |
| Module II:Advanced Charting and Dashboarding Techniques |
| Creating flexible charts |
| Creating waterfall chart |
| Creating dashboard using charts |
| Creating football field |
| Download Charts - Linkedin |
Pedagogy
- Duration
- Module 1: 30 Hrs (6 days) of comprehensive training
- Module 2: 20 Hrs (4 days) of comprehensive training
- Hands-on Case Study (Real Life) based learning
- Participants create financial model from scratch
- Step by Step Instruction on Creating the model
- Practicing Faculty (Investment Bankers, PE background) hand holds the participants
- Timing
- Saturday: 2pm to 7pm
- Sunday: 10am to 3pm
Materials Offered
- Access to Step by Step Model Templates
- Access to Real Life Templates for financial models
- 24x7 Online Access* to Course Material (Unlocked Excel Models, Presentations, etc.)
- Forums to interact with faculty & fellow students
- Certificate of Participation for all the Candidates
- Evaluation Based Certificate of Excellence in Collaboration with IIM Indore Finance Club and Acad Com
- * Access is valid for 1 Year
Venue
| Location | Date | Venue | Contact | Phone |
|---|---|---|---|---|
| Mumbai | May 12th | Khar Education Society, Khar West | Maitri | +91 9930865533 |
| Delhi | Feb 5th | Arunachal Bhawan, Barakhama Rd | Sanjay | +91 9560214422 |
| Pune | Feb 19th | SCDL 1065, Gokhale Cross Road | Mukesh | +91 9823059445 |
| Bangalore | Feb 5th | Manipal Centre, Dickenson Road | Sandeep | +91 8800766337 |
| Hyderabad | Feb 26th | Pasha CoE, Banajara Hills | Irfan | +91 8800135333 |
| Chennai | May 26th | T.Nagar, Near GRT Grand Hotel | Sandeep | +91 8800766337 |
| Online | - N/A - | Online | Dikshu | +91 8800959911 |
Why Pristine?
- Pristine is a leader in Financial modelling training having trained 2000+ participants across sectors (FMCG, Infrastructure, Real Estate, Oil and Gas, Internet Startups) and geographies (40+ countries).
- Conducted serves a list of reputed corporate clients such as JP Morgan, Bank of America, Mizuho Bank, E&Y and B-schools such as IIM C, IIM I, NUS Singapore, FMS in the area of financial modelling.
- Pristine is also a leader in finance Certifications trainings such as CFA (registered with CFA Institute), FRM (Registered with GARP) and PRM (Registered with PRMIA).
- Pristine Prides itself to provide "Value for Money Training courses" that respect the time commitment of professionals.
FAQs
Q. Who is the target audience?
A. This program is suitable for people in Investment banking, Project management, Equity research, Business planning &strategy, Private equity funds or commercial banking. It is also ideal for CA, CFA, FRM, MBA Finance, B .TECH and Commerce Graduates who want a career in any of the above profiles.
- Fees: INR 18000
- 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 participants
Testimonials
 | ||
 |
K Gangadhara Rao Accounts Officer George Institute for Global Health |
|
| This is Best Financial Modeling training for small Scale to Large Scale Industries irrespective of Product, services, Builders, Dealers, Franchises etc. | ||
 |
Sabrina Kloehn Strategic Financial Planning & Analysis |
|
| Love building the integrated model from scratch. It is helpful to see and hear another person's perspective on the approach to an integrated model. It is also very helpful to reach out to the faculty at any time. | ||
|
Jim Moran |
|
| I find the approach and the models very practical to my everyday work. I enjoy the fact that I can work at my own pace. | ||
 | ||