Certified Financial Modeling & Valuation Professional (FMVP) In Gurgaon
- Immersive Financial Modeling and Valuation Analysis Program
- Accreditation from BSE Institute Ltd New
- AI / ChatGPT in MS Excel Curriculum New
- Soft Skills: CV Preparation & Mock Interviews
- Project Work & Certificate
- 100% Placements Assistance
- Weekend and Weekday Batches
Welcome to CFI’s Financial Modeling and Valuation Course in Gurgaon!
Are you ready to take your finance skills to the next level?
CFI’s comprehensive Financial Modeling and Valuation Course in Gurgaon offers you the perfect blend of financial concepts and practical case studies, equipping you with the tools necessary to excel in the world of finance.
Why Choose Our Course:
- Experienced Instructors: Learn from industry experts with decades of experience in financial modeling and valuation.
- Interactive Learning Environment: Engage in interactive sessions, discussions, and Q&A sessions to clarify concepts and address queries.
- Practical Application: Develop practical skills through real-world case studies and projects, ensuring you’re well-prepared for the demands of the finance industry.
- Networking Opportunities: Connect with fellow participants, industry professionals, and faculty to expand your professional network.
- Career Advancement: Enhance your resume and career prospects with valuable skills highly sought after by employers in the finance sector.
- 100% Placement Support: CFI offers 100% placement assistance (in Gurgaon and PAN India) to those who complete our Financial Modeling and Valuation Program.
Our Alumni Works At
Target Audience
Our training is open to ambitious candidates who come from a range of backgrounds and will typically be
Graduates
Post-Graduates
CA/CFA/ACCAs
Finance Professionals
Investment Professionals
Training Approach
01
Classroom
Training
02
Capstone
Project
03
Resume &
Interview Prep
04
Final
Placement
Financial Modeling and Valuation Analysis Curriculum Highlights
- Using AI and ChatGPT in MS Excel- New
- 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
- Database and Logical Functions
- Reference and Lookup Functions
- Financial Function
- What if Analysis (Goal Seek, Scenarios, Data Table)
- Pivot Table and Pivot Chart Reports
- Dashboard Creation and Visualization
- VBA Macro Basics
- 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
- Project Finance – Case Study
- Real Estate Modeling – Overview
- Understanding NOI, Cap rate, CoCR, Debt Amortization, among others
- Real Estate Modeling – Case Study
- 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
- Candidate will have to sit for Mock Interview and clear the rounds to become eligible for placements
Financial Modeling & Valuation - Course Fee
Classroom / Live Online | Self-Paced | |
---|---|---|
INR 37000 | 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.