Applied Finance Program (AFP) - 6 Month
Specialize in Core Financial Analysis, Strategy, Data Analytics & AI
- Merger & Acquisition (M&A), Pitchbook, Fund Raising
- Company Profiles, Industry Analysis
- Equity Research Report Writing
- Interview Soft Skills and CV Building
- AI / ChatGPT in MS Excel Curriculum New
Program Journey
The Applied Finance Program (AFP) is designed as a structured, three-stage journey combining
FMVP
Financial Modeling & Valuation Program
Learn the Language of
Finance: MS Excel &
PowerPoint
Every finance career begins
with Excel and PowerPoint.
These are the core tools
used by Investment
Bankers, Equity
Researchers, Corporate
Finance teams, and Analysts
worldwide.
In FMVP, you learn to build
financial models from
scratch and understand
how companies actually
work.
CIBRA
Certified Investment Banking & Research Analyst
Certified Investment
Banking & Research Analyst
Develop Core Specialization
in Investment Banking,
Equity Research, and Deal
Analysis
Once you learn financial
modeling, the next step is
learning how capital
markets, investment banks,
and institutional investors
actually evaluate companies
and execute deals.
AFP
Applied Finance Program (Finance + Data Analytics)
Become a Modern Finance +
Data Professional
The finance industry is
evolving. Today’s analysts
don’t just work with
Excel—they work with large
datasets, real-time
dashboards, and automated
systems.
AFP introduces the data
analytics tools that
transform finance
professionals into highimpact decision-makers.
What You Will Learn
Financial Analysis & Modeling
- Advanced Excel for financial data structuring, analysis, and scenario modeling
- 3-Statement Financial Modeling (Income Statement, Balance Sheet, Cash Flow)
- Financial forecasting of revenues, costs, and profitability
- Ratio analysis including DU Pont framework
- Discounted Cash Flow (DCF) valuation
- Comparable Company & Transaction Analysis
- Project finance and real estate valuation basics
- PowerPoint for finance: pitch decks, analyst reports, and presentations
Investment Banking & Strategy
- Industry analysis, benchmarking, and competitive positioning
- Equity capital markets: IPO process and valuation frameworks
- Investment evaluation and return analysis
- Debt capital markets and credit risk assessment
- Mergers & Acquisitions (M&A) and accretion/dilution modeling
- Leveraged Buyout (LBO) modeling and IRR calculations
- Private equity investment analysis and value creation strategies
- Understanding how institutional investors evaluate companies and deals
Data Analytics
- Excel for data analysis including advanced formulas and pivot tables
- Power BI for building real-time financial dashboards and KPI tracking
- SQL for extracting and analyzing large financial datasets
- Python for financial automation and advanced data analysis
- Market data analysis and performance tracking
- Financial forecasting using data-driven techniques
- Risk and portfolio analysis using Python
- Working with enterprise financial systems and databases
Learning Experience
Case Study Approach
Learn through real-world financial scenarios and practical applications.
Passionate Educators
Industry experts with hands-on experience guide you throughout the program.
Individual Attention
Personalized support to ensure clarity and strong concept building.
Capstone Projects
Work on end-to-end projects to apply everything you learn in real scenarios.
100% Placement Assistance
Dedicated support for resume building, interview prep, and job opportunities.
Soft Skills Development
Enhance communication, presentation, and professional skills.
Career Outcomes
Complete Financial Analyst with AI & Data Analytics Capabilities
Become a modern finance professional equipped with end-to-end financial analysis, advanced modeling skills, and the ability to leverage data analytics and AI tools to drive smarter business decisions.
Financial Expertise
Strong foundation in financial modeling, valuation, and business analysis.
Data-Driven Decision Making
Ability to analyze large datasets and generate actionable insights.
AI & Automation Skills
Use modern tools like Python and automation techniques to improve efficiency.
Industry-Ready Profile
Prepared for roles across investment banking, corporate finance, and analytics.
Accreditation / Partnerships
Success Stories
Energy
Research
Research
Research
Research
Our Alumni Works At
Program Details
Duration
5–6 Months
Program Fees
₹1,18,000
This program is designed as a complete career pathway combining finance, investment analysis, and data analytics skills.
CIBRA Program Curriculum
- 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
- Types of Capital
- Basic Model – Case Study
- 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
- Revenue Model Discussion for Various Industries
- Cost of Equity Modeling
- Cost of Debt Modeling
- WACC Calculation Best Practices
- Time Value of Money Basics
- 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, RSUs and Convertibles for Dilution
- Concept of Calendarisation and Last Twelve Months
- CACS Discussions
- Interpreting Output Sheet
- 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
- Control Premium Calculation
- Difference between Trading & Transaction Comps
- Interpreting Output
- 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 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
- Creation of Deep-dive Company Profile
- Discussion on live case
- Sector Models – i.e., Retail, Auto, E-Commerce, FMCG, among others
- Statistics Models/li>
- Interest rates and Economics
- Tricky concepts – Levered / Unlevered (Beta, Cash Flow, IRR), TSM, Shares Out vs Weighted Avg Shares
- Doubts and Reference Materials
- Introduction to Industry Analysis
- Swot Analysis
- Competitive Benchmarking and Charts Creation
- Sector Index Creation
- Price Chart Creation and Rebasing
- Merger v/s Acquisitions
- Types of Mergers
- Motives behind M&A
- Synergies & Bootstrapping
- Accretion / Dilution Modeling
- Debt Capital Markets (DCM) Overview
- Types of Debt Raise
- Credit Analysis Matrix
- 5 Cs of Credit Analysis
- Debt Covenants
- Ability to pay analysis and Capitalization Table
- Discussion on live case
- ECM Overview, IPO & Global Markets
- Types of Investment Strategies (Active vs. Passive)
- Nifty Index, Asset Allocation & Mutual Funds
- Private Equity Overview
- Private Equity – Understanding & Modeling KPIs
- Introduction to LBO use cases
- LBO Overview and Terminologies
- Past Transactions
- Discussion on live LBO case
- Introduction to Power BI
- Power BI – Desktop Installation
- Power BI Fundmentals
- Dashboard Creation and Visualization – Case Study
- Introduction to Python & Installation
- Python Fundamentals
- Assignments
- Do’s and Don’ts of Interviews Process
- CV Edits and LinkedIn Profile Building
How will the CIBRA program help candidates?
The CIBRA program helps you become a complete Investment Banking and Research Analyst and you will be able to perform:
- Investment Banking Research
- Equity Analysis and Research
- Financial Advisory
- Credit Analysis
- Project Finance Modeling
- Financial Analysis
Certificate in Investment Banking & Research - Course Fee
| Classroom / Live Online | Self-Paced | |
|---|---|---|
| INR 50000 | INR 30000 | |
| Classroom / Live Zoom | Yes | – |
| Class Recording | Yes | Yes |
| Detailed Study Material | Yes | Yes |
| Case Studies | Yes | Yes |
| Capstone Project | Yes | Yes |
| App Access (iOS & Android) | Yes | Yes |
| 100% Placement Support* | Yes | Yes |
| CV & Interview Prep | Yes | Yes |
| Live Doubts Sessions | Yes | – |
| CFI "AI-Coach" | Yes | Yes |
| WhatsApp Group | Yes | – |
| Email Support | Yes | – |
| BUY NOW | BUY NOW |
Students Speak
Frequently Asked Questions (FAQs)
The CIBRA course is aspecializedprofessional program designed to build practical skills in financial modeling, company valuation, MS Excel, forecasting, investment banking, equity analysis, credit analysis, financial statement analysis, industry research, and investment banking fundamentals. It prepares candidates for real-world roles in finance.
The CIBRA course is ideal for:
- Graduates and postgraduates interested in finance careers
- Finance professionals seeking advanced modeling skills
- CA / CFA / ACCA candidates enhancing practical competency
- Aspiring investment bankers, equity research analysts, and financial analysts.
You will gain hands-on skills in:
- Advanced MS Excel (including AI/ChatGPT tools)
- Financial statement analysis
- Building 3-statement financial models
- Valuation methods (DCF, comparables, transactions)
- Project Finance Modeling
- Real Estate Modeling
- Pitch and Profile
- Sector Models, Statistics and Economics Basics
- Scenario planning and revenue modelling
- Capstone project and modeling tools used in real finance roles
- Industry and sector analysis
- Equity Capital Markets and Investments
- Debt capital markets, credit analysis and appraisal
- Cash flow and debt service modeling
- M&A Accretion Dilution Modeling
- LBO and Private Equity Modeling
- Power BI Dashboard and Python basics
The program includes:
- Live classroom or online sessions
- Practical assignments and case studies
- Soft skills and interview preparation
- Placement support after course completion
The duration for live course is 3-3.5 months and self paced depends on the candidate daily commitment towards the program.
No prior professional experience is required. The course is structured to take learners from fundamentals to job-ready credit and risk analysis skills, making it suitable for beginners and career switchers.
On successful completion of training, projects, and evaluations, candidates receive certificate in Financial Modeling & Valuation Professional (FMVP) and Certified Investment Banking Research Analyst (CIBRA) certificate from Corporate Finance Institute (CFI Education).
After completing CIBRA, you can target roles such as:
- Financial Analyst
- Investment Banking Analyst
- Equity Research Analyst
- FP&A (Financial Planning & Analysis) Specialist
- Corporate Finance Associate
Business and Strategy Analyst These skills are in demand in corporate finance, consulting, banking, and investment firms.
Yes — CIBRA includes 100% placement support for candidates who complete the program, assignments, and interview preparation. The placement team assists with CV building, mock interviews, and access to job opportunities.
Yes — placement assistance is performance-linked. A placement fee of 5% of your annual fixed CTC is charged only if you are successfully placed through CFI Education and accept the job offer. There is no upfront placement cost.
Yes — placement support for CIBRA is PAN India. Candidates from different cities and regions can access opportunities through CFI Education’s recruitment network, subject to role availability and candidate suitability.
According to the official course details:
- Classroom / Live Online: ~₹50,000
- Self-Paced Learning: ~₹30,000
These prices include training, project work, study materials, case studies, and placement support)
Absolutely. The CIBRA curriculum includes real-world cases
Yes — depending on the chosen mode:
- Live sessions: Live classes, class recordings and study materials, placement assistance
- Self-Paced: Class recordings and study materials, placement assistance
Yes — the focus on practical skills, real modeling exercises, valuation techniques, and placement support makes it suitable for professionals from non-finance backgrounds seeking to break into finance roles.
To register for the CIBRA course:
- Visit the official CFI Education website and open the CIBRA course page. https://cfieducation.in/investment-banking-program/
- Review the course details, syllabus, fees, and mode of delivery (classroom or online).
- Click “Enroll Now” or “Buy Now” (depending on your selected mode).
- Complete the registration form with your name, contact details, and academic/professional background.
- Choose your payment method and pay the course fee online.
- Once payment is confirmed, you’ll be contacted and receive a confirmation email with access details, class schedule, and further onboarding instructions.
- Alternatively, you can also connect with the institute’s admissions counsellors via phone or email and they will share payment cum registration link. Visit www.cfieducation.in for counsellors via phone or email
You may also contact the admissions team for personalized guidance before enrolling.
This is not just another Program.