Financial Analyst Program
Kickstart your finance career in investment banking and corporate finance. This program covers excel modeling, financial statements projection, ratio analysis, Discounted Cash Flow (DCF) valuation, Comparable Company Analysis (CCA), Merger models, and presentation pitch books.
Program Highlights
Target Audience
Commerce Graduates, MBA Finance students, CA candidates, and professionals transitioning to financial roles.
Prerequisites
Basic interest in corporate business models. Accounting knowledge is helpful, but covered from scratch.
Job Roles & Careers
Financial Analyst, Equity Research Associate, Investment Banking Analyst, Corporate Finance Executive.
Salary Outlook
₹5 LPA - ₹11 LPA
Detailed Course Syllabus
- Financial formula combinations (INDEX, MATCH, OFFSET, XLOOKUP)
- Creating dynamic charts, dashboards, data tables, and sensitivity layouts
- Excel keyboard shortcuts and structure best practices
- Deep dive into Income Statement, Balance Sheet, Cash Flow Statement
- Interlinking the 3 financial statements in Excel
- Historical analysis: Horizontal, vertical, and profitability/liquidity ratios
- Revenue forecasting methods (unit-based, growth models)
- Cost structures forecasting, working capital projections
- Depreciation schedules, debt schedules, and tax forecasting
- Discounted Cash Flow (DCF) modeling: Free Cash Flow (FCFF/FCFE), WACC, Terminal Value
- Relative Valuation: Comparable Company Analysis (Trading multiples: EV/EBITDA, P/E)
- Precedent Transaction analysis
- Designing equity research presentation slides
- Accretion/Dilution analysis overview
- Preparation for core finance interview panels
Batches & Timings
Weekday Batch
Monday - Friday (10:00 AM - 12:00 PM)
Weekend Batch
Saturday & Sunday (9:00 AM - 1:00 PM)
Career Benefits & Outcomes
Building detailed financial projection spreadsheets of real companies from scratch
Techniques in valuation models (DCF, multiples, LBO basics)
Industry-experienced trainers (Chartered Accountants / CFA Charterholders)
Step-by-step guidance in compiling equity research reports
MNC financial services interview preparation and placement assistance
Quick Summary
- Duration: 3 Months
- Format: Classroom & Online
- Placement Support: 100% Assistance
- Batch: Weekday / Weekend
- Live Projects: Valuation Projects
Quick Enquiry
Have questions? Ask our academic counselors.