Financial Modeling & Valuation In Gurgaon
- Immersive Financial Modeling and Valuation Analysis Program
- Classroom / Live Online + Self Paced
- Soft Skills: CV Preparation & Mock Interviews
- Certificate of Completion
- 100% Placements Assistance
- Course Pricing: INR 35,000
Our Alumni Works At
Target Audience
Our training is open to ambitious candidates who come from a range of backgrounds and will typically be
MBA
Engineers
CA /ACCA / CPAs
CFA
Graduates / Post-Graduates
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
Our training program is blend of Classroom Sessions followed by Project Work and Soft Skill training. Upon Successful completion of all 3 Milestones, candidates become eligible for 4 Milestone that is Placement, and provided support for CV building and Interviews.
01
Classroom
Training
100 hours of intensive classroom training spanning over ~2.5 months, with cases, quiz, & assessments.
02
Capstone
Project
100 hours of intensive classroom training spanning over ~2.5 months, with cases, quiz, & assessments.
03
Soft Skill
Training
100 hours of intensive classroom training spanning over ~2.5 months, with cases, quiz, & assessments.
04
CV Building, Interviews
& Placement
100 hours of intensive classroom training spanning over ~2.5 months, with cases, quiz, & assessments.
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.
- 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
- 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
- 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
- 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
- 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
- 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/li>
- Concept of Calendarisation and Last Twelve Months
- Interpreting Results
- 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
- Sources and Uses of Funds
- IRR, Modified IRR, NPV, Profitability Index and Discounted Payback Period
- Case Discussion on Project Finance
- Use of Financial Models in Pitchbook
- Flow of M&A / Restructuring Transaction
- Introduction to company profile – best practices to follow
- Discussion on live case
- 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.
- Do’s and Don’ts of Interviews Process
- CV Edits and LinkedIn Profile Building
Financial Modeling & Valuation - Course Fee
| 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 |
100% Placement Support*
CFI Education provides placement assistance to all the candidates who complete our in-house Financial Modeling or Investment banking programs. Apart from technical classroom training, we prepare candidates for soft skills, and conduct mock interviews. Once they feel confident, they can start applying for various job opportunities provided by our dedicated placement team. The placement process is usually start at 8th week of the training program.
We charge a placement fee of 5% of annual fixed ctc. This fee is applicable only when candidates is selected through our placement team efforts and accepts the job offer. Contact our team to know more about how CFI Education can help you launch your career in core finance domain.
Success Stories
Lavil Virmani
Financial Analyst – Renewable
Energy
Energy
Infinia Energy Solutions LLP
Abhinav Bhatt
ESG Consultant
SG Analytics
Shivani Chorat
MDP Associate
Morningstar
Karan Srivastava
MDP Associate
Morningstar
Nikhi Dethe
ESG Consultant
SG Analystics
Sonali Thombe
Research Associate- Business
Research
Research
Fuld Consulting & Analytics
Private Ltd.
Private Ltd.
Nisha Yadav
Business Analyst
Evalueserve
Samiksha Adulkar
Research Analyst
Adyaant
Fiza Khan
Research Associate- Business
Research
Research
Fuld Consulting & Analytics
Charu Agarwal
Research Associate- Business
Research
Research
Fuld Consulting & Analytics
Nikhi Dethe
ESG Consultant
SG Analystics
Netraj Kore
Research Associate- Business
Research
Research
Visible Apha
Students Speak
"CFI Education is a Good coaching institute for CFA Exam preparation. I passed two levels of the Cfa exam in consecutive attempts and giving level 3 in 2019. I will suggest joining CFI Education Institute if you want to prepare for the CFA Exam."
"Great guidance and explanation of concepts that make it very easy to understand difficult topics. Have done CFA Level 2 and 3 coachings from CFI Education & cleared both levels in the first attempt. Highly recommended for CFA coaching."
"The examples/case studies used to explain the concepts was extremely relevant. Highly recommended to those looking for Financial Modelling, Investment Banking and CFA Prep Classes."
"I had a great learning experience with CFI Education that enabled me to get through CFA Level 1 exam. The institute provides highly qualified faculties for teaching different sections of the curriculum. Nice teaching methodology adopted."
"Very effective faculty for Financial modeling and prep for CFA level 1. Helped me in clearing both and helped me landing into relevant job... Owner is pretty experienced and humble guy, keeps you motivated for career plan."
"CFI Education is a great institute for you to learn financial modelling and valuation. The teachers are very cooperative and clear all doubts,even after completing the course Sandeep Sir always helps with the doubts. Placement Assistant is also very good. It's highly recommend if one wants to learn and want placement assistance also."
"CFI institute is a good place to learn financial modeling, all the teachers are very supportive and helpful. Teachers give attention to each and every student in the class. Even after class teachers are ready to clear doubts. Placement support is excellent here, special thanks to Sandeep sir for all his guidance and support."
"Great going CFI. Fantastic course and great teachers. Thanks Sandip to you and your team. The course is excellent and extremely useful! keep it up!"
"My daughter, Nain, took a number of classes with Sandeep. She found him to extremely helpful, accessible and knowledgeable. I don't generally write reviews but I think on this occasion, it is essential to recognize an instructor who selflessly found extra time in their busy day to help support a student. My deep appreciation for Sandeep and the Institute for hiring such talented and capable faculty."
"I would recommend CFI to every aspirants who is looking to get trained in finacial modelling and valuation. They have the best faculty. After completion of training they'll placed you with the best organization as well. I have made the bestest decision"
"CFI Institute is one of the finest institutes to get the basics right in financial modeling and valuation. The program integrates a good mix of advanced excel, financial accounting, and valuation methodology. All the topics like the Three-statement model, DCF valuation, Trading comps, and Transaction comps are very well covered. This curriculum is certainly a "Yes" for all the new joiners who are striving for their place in the financial modeling and investment banking area. Faculty act as a mentor who will advise Do's and Don'ts at each step starting from the program to the Interview process."
"Highly recommended to those looking for Financial Modelling and valuation course .Student support and placement assistance is a plus . Faculty is responsive to the queries.The examples / case studies used to explain the concepts was extremely relevant.Even after finishing the course I have access to the institute for career help, interviews etc."
"Faculty is very informative and helpful. With the help of their guidance I cleared interview for investment banking profile. Totally recommended to joiners."
"Go for it. Being a person who's miles away from any financial topic, it really made a difference. The faculties were super supportive, and as I needed a bit more guide than other do, it was perfect. They even conducted multiple doubt sessions. And before each class, we had a review for 30 minutes, and then we'd go with new topics. So, being a person from Engineering background who just wanted to explore the finance- it never hurts to learn something new, I'd recommended the CFI team 100%."
Certification
