Financial Modelling Course
Financial Modelling Course & Certifications
Course Overview
ACLM Institute of Professional Studies presents a 03-month, intermediate-level Financial Modelling Course designed around Excel proficiency, financial reporting and analysis, corporate finance, project finance modelling, and equity research modelling. The course is available in Online / Offline mode for learners in India and international markets. Offline training is available in Greater Noida West, Greater Noida, Noida, Gaziabad, and Delhi NCR. The programme includes instructor-led and online one-on-one training, ACLM notes, assignments, projects, and practical modelling exercises.
Why Learn This Course?
Financial modelling brings together spreadsheet proficiency, financial statement analysis, corporate finance concepts, forecasting, scenario building, and valuation. This course helps learners develop a structured approach to building and interpreting financial models for project evaluation and equity research applications. Practical assignments and ACLM-provided notes support progressive learning from Excel fundamentals to integrated financial forecasting and valuation.
What You Will Learn
- Format and organise professional Excel worksheets for financial analysis.
- Use basic and advanced Excel functions, filters, sorting, charts, graphs, table formulas, scenario tools, and pivot tables.
- Understand the mechanics and purpose of the income statement, balance sheet, and cash flow statement.
- Apply financial analysis techniques, ratio analysis, DuPont analysis, and peer-to-peer analysis.
- Use time value of money, capital budgeting, and cost of capital concepts in corporate finance analysis.
- Understand the construction and development phase of a project finance model.
- Forecast project revenue, cost drivers, assets, debt schedules, and project life assumptions.
- Analyse historical financial statements for equity research modelling.
- Forecast revenue and cost drivers and build projected three-statement financial models.
- Apply DCF and relative valuation approaches to support equity research analysis.
Skills You Will Gain
- Professional Excel worksheet formatting and model organisation
- Application of basic and advanced Excel functions
- Data filtering, sorting, charts, graphs, table formulas, scenarios, and pivot tables
- Financial statement interpretation and ratio-based analysis
- DuPont and peer-to-peer analysis
- Time value of money and capital budgeting analysis
- Cost of capital analysis
- Project revenue, cost, asset, and debt forecasting
- Integrated forecasting of the income statement, balance sheet, and cash flow statement
- DCF and relative valuation modelling
- Structured financial modelling using assignments and practical projects
Who Should Join?
The course is intended for students and working professionals who want to develop practical skills in Excel-based financial modelling, financial statement analysis, project finance modelling, and equity research modelling.
Prerequisites
Basic knowledge of Programming is required. Familiarity with general finance or accounting concepts may be helpful, but the course is structured to introduce the relevant financial reporting and analysis concepts progressively.
Training Methodology
The programme uses instructor-led training and online one-on-one learning. Sessions combine concept explanation, guided Excel practice, financial statement analysis, forecasting exercises, scenario building, valuation applications, ACLM notes, and assignments. Learning progresses from Excel proficiency to integrated project finance and equity research modelling.
Detailed Course Syllabus
| Module | Topics / Lessons |
|---|---|
| Excel Proficiency for Financial Modelling Build the spreadsheet foundation required for clear, consistent, and analysis-ready financial models. |
|
| Financial Reporting and Analysis Understand financial reporting mechanics and apply structured techniques to interpret and compare financial statements. |
|
| Corporate Finance Fundamentals Apply core corporate finance concepts that support investment analysis, financial decisions, and model assumptions. |
|
| Project Finance Modelling Develop a project-focused modelling framework covering project evaluation, development phases, forecasting, schedules, and decision-making. |
|
| Equity Research Modelling and Valuation Build an equity research-oriented model from historical analysis through forecasting and valuation. |
|
Practical Projects
- Excel Financial Analysis Workbook — Create a structured Excel workbook using professional formatting, functions, data filters, sorting, charts, graphs, table formulas, scenarios, and pivot tables. The exercise develops spreadsheet organisation and analysis discipline. Tools: Microsoft Excel and ACLM notes
- Financial Statement Analysis Assignment — Analyse an income statement, balance sheet, and cash flow statement using financial reporting mechanics, ratios, DuPont analysis, and peer-to-peer comparison techniques. Tools: Microsoft Excel and ACLM-provided assignment
- Project Finance Model — Build a project finance model covering the construction and development phase, revenue and cost drivers, asset and debt schedules, project life, and decision-making analysis. Tools: Microsoft Excel and ACLM-provided project assignment
- Equity Research Forecast and Valuation Model — Review historical financial statements, identify revenue and cost drivers, forecast the three financial statements and supporting schedules, and apply DCF and relative valuation methods. Tools: Microsoft Excel, ACLM notes, and practical assignment
Career Opportunities
The skills covered are relevant to modelling-oriented work and analytical responsibilities in areas such as investment banking, equity research, credit research, project finance, portfolio management, and financial planning and analysis. The course develops practical capabilities in Excel, financial analysis, forecasting, and valuation; employment or placement outcomes are not guaranteed.
Certification
Learners who complete the programme receive an ACLM certificate of Participation, subject to the applicable ACLM course requirements.
Frequently Asked Questions
What is the duration of the ACLM Financial Modelling Course?
The course duration is 03 Months.
What training modes are available?
The course is available in Online / Offline mode. Online learning is available for India and international markets. Offline training locations are Greater Noida West, Greater Noida, Noida, Gaziabad, and Delhi NCR.
Who can join this course?
The course is designed for students and working professionals at an intermediate level.
What are the prerequisites?
Basic knowledge of Programming is required.
Does the course include practical work?
Yes. The programme includes projects and assignments by ACLM, along with ACLM notes and guided practical exercises covering Excel, financial analysis, project finance modelling, and equity research modelling.
Which topics are covered in the course?
The course covers Excel proficiency, financial reporting and analysis, financial ratios, DuPont analysis, peer-to-peer analysis, corporate finance, project finance modelling, equity research modelling, DCF, and relative valuation.
Is the course recorded?
No. The supplied course details specify that the course is not recorded.
Is certification available?
Yes. ACLM provides a certificate of Participation, subject to the applicable ACLM course requirements.
What is the course fee?
The listed fee is INR 25,000.
Ready to Start Learning?
Contact ACLM Institute of Professional Studies for course guidance, demo scheduling and registration.
Want the complete syllabus?
Get the detailed module-wise ACLM syllabus in PDF after mobile verification.