This is a online course is to gain comprehensive practical understanding of Financial Modeling. The aim is to learn essential concepts to prepare a financial model from scratch. The tutorials will help you learn about basic and advanced excel lessons, VBA Macros, Financial Modeling using Excel and sector specific financial modeling such as Paint, IT and Education sector.
25h 59m | 226 Videos | 26920 Views | All Levels
Online Financial Modeling Training
The aim of this Financial Modeling Course is to make you understand the financial statement of a company doing an analysis on the same and projecting the future financials of a company.
This Financial Modeling Training has been designed in such a manner that it would help you build a step-by-step advanced financial model‚ Concept of circularity‚ Understand the Key Linkages of Income statement, Balance sheet and Cash flow statement.
You would get the opportunity to learn Excel proficiency that is required by the analyst and Financial Modeling of different sectors such as the Paint sector, IT sector and Education sector in this Financial Modeling Training.
The following are the benefits of undertaking this Financial Modeling Training:
Learn decision making involved in financial viability of a company
Financial Modeling Training is a comprehensive course for Investment Bankers and Equity Research Analysts. This course starts from the basics of forecasting i.e. Financial Modeling, covers financial modeling best practices and builds a model from scratch. The HD video tutorials have been optimized for user’s self paced learning.
Who should attend Online Financial Modeling Training?
This Financial Modeling Course is most suitable for people in Investment Banking, Equity research, Business planning & strategy, Private management, or commercial banking
People pursuing CA, CFA Program, FRM, MBA Finance can take up this Financial Modeling Course.
Ideal for candidates with any graduation field who want a career in finance
Major topics included in this course includes;
Introduction- This is an introductory section to understand the objective of the course
Excel for Financial Modeling- This section deals with understanding the excel functions and tools to prepare an effective financial model
Financial Modeling- This section deals with understanding the procedure to prepare a financial model right from scratch
Asian Paints case study- This section is for you to understand the projections of financial statements with the help of Asian paints company.
The aim of this course is to make you understand the financial statement of a company doing an analysis on the same and projecting the future financials of a company.
The tutorials have been designed in such a manner that it would help you build a step-by-step advanced financial model‚ Concept of circularity‚ Understand the Key Linkages of Income statement, Balance sheet.
Course Highlights of Online Financial Modeling Training
Tips and Techniques to write professional Research Reports like Result Update, Initiation Report, Thematic Report, etc.
Major Topics covered in this Financial Modeling Course:
Introduction to financial modeling Training
Why financial model are used?
General structure and model design
Sources of information
Presentation of historical data
Analysis of historical data
Fixed asset, capital expenditure and depreciation schedule
Working capital and change in working capital schedule
Shareholders’ equity schedule
Shares outstanding schedule
Other long-term items schedule
Debt and debt repayment schedule
Income statement drivers
Other income statement items
Balance sheet drivers – assets
Cash and cash equivalents
Accounts receivables, Inventories
Fixed assets (PPE, depreciation and net fixed assets)
Balance sheet drivers – liabilities
Short term debt, Accounts payable
Deferred taxes, accrued liabilities and other current Liabilities
Balancing the balance sheet
Calculating cash flow from operations
Calculating cash flow from investing activities
Calculating cash from financing activities
Where do our learners come from?
Professionals from around the world have benefited from eduCBA’s Online Financial Modeling Training courses. Some of the top places that our learners come from include New York, Dubai, San Francisco, Bay Area, New Jersey, Houston, Seattle, Toronto, London, Berlin, UAE, Chicago, UK, Hong Kong, Singapore, Australia, New Zealand, India, Bangalore, New Delhi, Mumbai, Pune, Kolkata, Hyderabad and Gurgaon among many.