Financial Modeling Training Courses

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
• Develop critical thinking and analytical skills required to excel in the field of Investment Banking, Equity research and Commercial banking.
• Understand Financial modeling techniques

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 excelfunctions 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

Course Content	Resources	Financial Modeling Training Highlights
Excel & Advanced Excel	83 Excel, 63 Videos, 29 PDFs	Financial Modeling course starts with gaining Excel proficiency, Sensitivity Analysis, Macros, Graphs & Charts, Formatting, Excel Short Cuts.
VBAs & Macros	56 Videos	Create Time saver shortcuts using Macros & Automate your regular mundane tasks.
Online Financial Modeling Training Using Excel	2 Excel, 28 Videos	Financial Modeling training involves building a step-by-step advanced financial model, Concept of circularity, Understand the Key Linkages of IS, BS and CF, Arriving at DCF Valuations.
Online Financial Modeling Training – Paint Sector	6 Excel, 34 Videos	In this Financial Modeling course, learn how to read the Annual Reports of Asian Paints, understand the footnotes and prepare Integrated financial model of Asian Paints.
Financial Modeling Training –IT Sector	4 Excel, 26 Videos, 3 PDFs	In this Financial Modeling course, Learn how to read the Annual Reports of Google Inc, understand the footnotes and prepare Integrated financial model of Google Inc.
Financial Modeling Training –Education Sector	4 Excel,47 Videos, 4 PDFs	In this Financial Modeling course, Learn to build a excel based financial model of Management Institute and a School , Provides an overview of K-12 segment and overall Education sector.
Report Writing Techniques	2 Excel,19 Videos, 15 PDFs	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

Historical data

• Sources of information
• Presentation of historical data
• Analysis of historical data

Projection Schedules

• Revenues, Costs
• Fixed asset, capital expenditure and depreciation schedule
• Amortization 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
• Interest schedule

Income statement drivers

• Revenues, Costs
• Operating expenses
• Other income statement items
• Income taxes
• Equity income

Balance sheet drivers – assets

• Working capital
• 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
• Equity

Balancing the balance sheet

• Calculating cash flow from operations
• Calculating cash flow from investing activities
• Calculating cash from financing activities