INTRODUCTION
Course Description:
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 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.
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
Benefits of online course:
- High Quality Content
- Learn Anywhere Anytime & at Your Pace
- 24X7 Customer Support
- Complete Student Support Throughout The Program
- Course Completion Certificate
- Lifetime course access
For any query feel free to call
Mob - +918587999769/9818826705
CURRICULUM
Modeling modeling
This course is going to take care of all excel 2010 functions and formulas in a comprehensive manner with lots of examples and case studies. To make you understand the importance of Excel 2010 in our day to day life, the course starts with a case study and how that case study is being taken completely on an excel spread sheet. You will learn everything from data entry to calculations to formula, formatting, if, sum if, graphs and charts, sorts, pivot table, freeze and split etc. We will also give you lots of shortcuts in excel to make your life easier. This Excel 2010 course is ideal for Students, MBA’s, BBA’s, Gradates & Post- graduates, Working Professionals from HR, Marketing, Sales and Operation etc., Entrepreneurs, Prospective Finance Analyst, Market Analyst, Research Analyst, Investment Banker.
Learn to use advanced Excel Tools. This module will include the tools like, Auto Filter, Data Filter, Sort, Pivot Tables, Conditional Formatting, Scroll bars, Data validation, List and Combo Boxes and many others. Learn Advanced Formulas in excel. This module will include advanced formulae, What if Analysis, special cases in Graphs, Analyst Research
- Financial Modeling- Paint Sector:
It helps in making conclusions such as how the revenue would be, is the company making any capital expenditure, analyzing the capital structure and finally looking how much cash it is left with. All this can be effectively done using financial models. In this Financial Modeling – Asian Paints Course, you will learn about:
- Scenario of Paint Sector
- Calculation of Reserves, Capex, revenue, Costs, equity etc
- Financials and Valuations Analysis of Paint Sector
- Financial Modeling- IT Sector:
It includes application of financial modeling and valuation on an IT company ie Google Inc. For the keen learners or Equity analyst of IT sector. By doing this course the student will get practical experience of how the industry is performing, how it is contributing towards the growth of economy and what future it has.
- Financial Modeling- Education Sector:
- These tutorials on Financial Modeling education sector would provide an overview of the K-12 segment and overall education sector.
- It would also help you create Excel based Financial Model of K-12 school and a management institute and do valuation analysis on the same.
