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.

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.

Syllabus:

• 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