Financial Modeling & Valuation Online
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 Live Online / Self Paced sessions 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
CFI’s Financial Modeling & Valuation Program is a top-tier global certification program that prioritizes genuine financial analysis, modeling, valuation, and presentation abilities. It involves a financial analyst’s whole skill set. The Financial Modeling & Valuation course is designed to provide students with knowledge of the industry, practical learning experience, and confidence, helping you to stand out from the crowd and preparing you to become a world-class financial analyst.
A competent financial professional in today’s world is someone who can handle vast amounts of numerical data, make the data coherent, and make it valuable to senior management in their decision-making process. Students will learn how to build effective, resilient, and adaptable financial models to report and analyze historical data, generate future predictions, and present consolidated financial statements, key financial ratios, and outputs in a logical, concise, and efficient manner in this curriculum. In addition, the curriculum provides proper application of these skills through the use of cases that were specifically designed to demonstrate alternative methods of calculating certain financial parameters.
What do Financial Modeling and Valuation Analysts do?
These analysts gather accounting data in order to determine all factors of what is required to make sound financial judgments. They do so by looking at a company’s previous financial records in order to forecast the anticipated consequences of future commercial operations.
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
Lavil Virmani
Financial Analyst – Renewable Energy
Abhinav Bhatt
ESG Consultant
Shivani Chorat
MDP Associate
Karan Srivastava
MDP Associate
Nikhi Dethe
ESG Consultant
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]