Financial Modelling Course

financial modelling course

Financial modelling is always required as a core skills for various profiles including Investment Banking, Equity Research, Credit Research, Project Finance, Portfolio Management, Financial Planning & Analysis etc. Boost your skills by ACLM Financial Modelling Course to get into these profiles easily or be a successful investor. The course is available online as well as offline mode. Financial Modelling Course can be taken by any simple graduate, post graduate degree in finance field or an MBA finance. The Financial Modelling Course can also be opted by any working professionals, investors and entrepreneurs.

ABOUT FINANCIAL MODELLING COURSE

Our Financial Modelling course covers:

  • Learn advanced excel, preparing financial statements and analyzing complex data. You may learn tools for financial modelling pertaining to project finance and equities
  • Hands on use case studies, which ensure the right track from the start of the course
  • Concept building on Accounts and Finance at par with CFA and accounting Level 1.
  • In depth training on VBA – Macro, Forms, & crystal reports for the daily report updates. 
  • Practice, Assignment, Notes as a collection for 100+ on Investment Banking, Equity Research, Credit Research, Project Finance, FP&A, etc

AISECT Academy Certification
Joint certification from ACLM & AISECT Academy of Finance

Learning by doing:
Focuses on practical application of the finance concepts. Want to explore other courses too?

Learn from industry experts:
Faculties from top institutes with rich industry experience

Skills for core finance:
Learn the most important skills for Investment Finance profiles

SYLLABUS FOR FINANCIAL MODELLING COURSE

Excel Proficiency

› Formatting of Excel Sheets
› Basic and Advance Functions
› Advanced Modeling Techniques
› Data Filter and Sort
› Charts and Graphs
› Table formula and Scenario building
› Pivot tables

Financial Reporting and Analysis ( including Ratios)

Introduction to Financial Statement Analysis
› Financial Reporting Mechanics
› Understanding Income Statement, Balance Sheet, Cash Flow Statement
› Financial Analysis Techniques
› Financial Statement Application
› Du point Analysis
› Peer to peer analysis

Corporate Finance

› Time value of money
› Capital Budgeting
› Cost of capital

Project Finance Modelling

› Why Project evaluations
› Construction & development phase
› Forecasting revenue and cost drivers
› Forecasting assets and debt schedules
› Life of project; decision making

Equity Research – Modelling

› Analysis of historical financial statements
› Identifying and forecasting revenue and cost drivers
› Forecasting the three Financial Statements
› Forecasting assets, debt and other schedules
› Valuation based on DCF and relative valuation

advance excel course

Welcome to ACLM. Registration open for Advanced Excel, VBA, SQL & MIS + FREE Tableau. Register now.

X