Financial Modeling & Valuation In Gurgaon
Our Alumni Works At
Target Audience
Our training is open to ambitious candidates who come from a range of backgrounds and will typically be
Speak to our Counselor to know if you are good fit for the program at +91-9354266554 or Mail Us at [email protected]
Training Approach
CFI Education program for Financial Modeling & Valuation is blend of Classroom Sessions for Gurgaon candidates followed by Project Work and Soft Skill training.
Upon Successful completion of all 3 Milestones, candidates become eligible for Placements, and provided support for CV building and Interviews.
Classroom
Training
100 hours of intensive classroom training spanning over ~2.5 months, with cases, quiz, & assessments.
Capstone
Project
Candidates undergoes a month long project work post classroom sessions for building domain expertise.
Soft Skill
Training
Candidates undergoes soft skills development which helps them in cracking interviews.
CV Building, Interviews
& Placement
Have a dedicated team of placement who work towards, CV building and scheduling interviews.
Financial Modeling and Valuation Analysis Curriculum Highlights
Our Financial Modeling & Valuation course in Gurgaon focuses on the development of Excel skills, financial statement analysis, project finance, and equity modeling. It is taught using case study methodology, which ensures that students are job-ready from the start. Students can brush up on accounting and finance concepts in the first couple of classes. We prepare you for careers in investment banking, equity research, credit research, project finance, financial planning and analysis, and other fields.
CFI’s Financial Modeling & Valuation Program certification is a top-tier global certification program that highlights real-world financial analysis, modeling, valuation, and presentation skills. It covers all of a financial analyst’s skills.
Our Financial Modeling and Valuation certification program in Gurgaon is required for those seeking greater opportunities in their finance careers. This is what differentiates an average financial analyst or investment banker from a world-class financial analyst or investment banker, and employers are well aware of this. This certification program does not need you to wait until you have graduated from college to begin. In fact, taking it while you’re a student can be just as useful. Finding the top financial modeling classes in Gurgaon can help you ace your exam while staying on pace with the rest of your academics. That’s why we’re here: to relieve some of your stress by laying out the greatest solutions currently accessible to you.
MS Excel Training – Basic to Advance Excel
- Keyboard Accelerators and Shortcuts
- Create and Customize the Excel List
- Data entry with Auto Fill Feature
- Working with Advance Cut, Copy, Paste Command
- Use of Find and Replace
- Using Paste Special
- Sorting and Filtering
- Advance Formatting
- Mathematical Functions
- Text Functions
- Statistical Functions
- Date & Time Functions
- Array Functions
- Reference and Lookup Functions
- Financial Function
- Pivot Table and Pivot Chart Reports
- Dashboard and Excel Macros Introduction
MS PowerPoint Skills
- Most used chart creation including Bar, Stacked, Line, Pie, Waterfall, Football Field etc
- PPT training for writing, formatting and alignment
- Best practices and shortcuts for pitch creation, overview slides, chart pasting
Financial Statements Analysis
- Introduction to Financial Statements
- Understanding Income Statement, Balance Sheet and Cash Flow and Key Line Items
- Reading, Skipping and Skimming Annual Report
- Understanding Management Discussion & Analysis (MD&A)
- Ratio Analysis and Interpretation
- DuPont Analysis
Business and Financial Modeling
- Modeling for 3 Financial Statements
- Revenue and Cost Modeling
- Building Supporting Schedule including Depreciation, Working Capital, Debt, Equity, Asset Schedules etc
- Building Scenarios (Base, Best, Worst Cases)
- Maintaining, Updating and Model Adjustments for Corporate Actions (CACS)
- Keeping the Model Dynamic
DCF Valuation
- Cost of Equity Modeling
- Cost of Debt Modeling
- WACC Calculation Best Practices
- Cash Flow Modeling (FCFF / FCFE) and Terminal Value Calculation
- Approaches to DCF Valuation
- Football Field Analysis and Discussion
Comparable Company Analysis
- Introduction to Comparable Companies Analysis
- Select the Universe of Comparable Companies
- Locate the Necessary Financial Information
- Spread Key Statistics, Ratios, and Trading Multiples
- Determine Valuation using Comparable Companies
- Adjustment / Normalization of EBIT, EBITDA and Net Income
- Adjustments of Options, Warrants and Restricted Stock Units for Dilution
- Concept of Calendarisation and Last Twelve Months
- Interpreting Results
Comparable Transaction Analysis
- Introduction to Precedent Transactions Analysis
- Select the Universe of Comparable Acquisitions
- Locate the Necessary Deal-Related and Financial Information
- Spread Key Statistics, Ratios, and Transaction Multiples
- Benchmark the Comparable Acquisitions
- Determine Valuation using Comparable Acquisitions
- Normalization of EBIT, EBITDA and Net Income
- Interpreting Results
Introduction to Project Finance
- Introduction to Project Finance
- Sources and Uses of Funds
- IRR, Modified IRR, NPV, Profitability Index and Discounted Payback Period
- Case Discussion on Project Finance
Company Profile and Pitchbook
- Use of Financial Models in Pitchbook
- Flow of M&A / Restructuring Transaction
- Introduction to company profile – best practices to follow
- Discussion on live case
Capstone Project
- Post Classroom Sessions, candidates are asked to complete an integrated project covering all the training aspects of program. The project helps candidates get the hold of the concepts and make them aware about best practices.
Soft Skills Training and CV Building
- Do’s and Don’ts of Interviews Process
- CV Edits and LinkedIn Profile Building
Financial Modeling & Valuation - Course Fees
| Classroom / Live Online | Self-Paced | |
|---|---|---|
| INR 35000 | INR 25000 | |
| Classroom / Live Zoom | Yes | – |
| Class Recordings | Yes | Yes |
| Detailed Study Material | Yes | Yes |
| Case Studies | Yes | Yes |
| Capstone Project | Yes | Yes |
| App Access (Android) | Yes | Yes |
| 100% Placement Support | Yes | Yes |
| CV & Interview Prep | Yes | Yes |
| Live Doubts Sessions | Yes | – |
| Whatsapp Group | Yes | – |
| Email Support | Yes | – |
| BUY NOW | BUY NOW |
Success Stories
Shivani Chorat
MDP Associate
Karan Srivastava
MDP Associate
Nikhi Dethe
ESG Consultant
Sonali Thombe
Research Associate- Business Research
Nisha Yadav
Business Analyst
Students Speak
Jay Veer
Pankaj Gupta
Amit Rajpal
Akshay Goyal
Chems Arora
Venus Saini
Shalu Kaushik
Shayak Upadhyay
Ashok Garg
Swati Gupta
Akash Rawat
Pooja Jindal
Priyanka Behl
Anuraag Roy
Certifications
+91-9354266554 or mail us at [email protected]