• • Accounting Concepts
  • Financial Statement (Income Statement, Balance Sheet, Cash Flow Statement)
  • Notes To Accounts
  • Cause & Effect Analysis
  • Understanding Financial Transactions
  • Ratio Analysis
  • Reverse Ratio
  • Working Capital Analysis
  • Business Drivers Concept
  • Corporate Documentation
  • Management Analysis And Discussion
  • Management Evaluation
    
    

– Financial Analysts’ work starts with understanding the financial statements/financial scenario.
– Understanding financial statements includes understanding the business drivers, the business environment, and identifying different line items.
– Analyzing the company becomes easy when one starts understanding the people running the company and their management challenges and successes.
– One must understand and visualize the relationship and flow between the Income Statement, Balance Sheet, and Cash Flow Statement.
– In the end, a proficient analyst not only identifies the event but also decodes the cause-and-effect of the particular event.

• • Basic Excel
  • Advance Excel
  • Functions & Formulas
  • Vlookup & Hlookup
  • Dates, Rates & Percentages
  • Vba (Visual Basic Analysis)
  • Data Validation
  • Data Visualisation
  • Layout Visualization 
  • Naming & Referencing
  • Goal Seek
  • Data Table
  • Pivot Tables
  • Conditional Formatting
  • Conditions & Filters
  • Sorting & Slicing
  • Scenario Analysis
  • Sensitivity Analysis
  • Dynamic Charts And Graphs
  • Football Field Analysis
  • Waterfall Chart 
  • Error Checking
    
    

– Excel is one of the tools used by financial analysts extensively.
– Several areas where Excel is used aggressively are Equity Research, Investment Banking, Private Equity, and profiles like Financial Modeling, Business Valuation, Financial Planning & Analysis, Forecasting, Budgeting, and many more.
– In this module, you will learn functions and formulas to make everyday life easier.
– Utilize keyboard shortcuts to save time and be more efficient.
– Develop better analysis and presentation using tables, bars, graphs, and charts.
– Excel (Basic, Intermediate, and Advanced) will serve as a foundation for your career in FINANCE.

• • Business Environment Analysis
  • Business Environment Component
  • Environment Scanning
  • Micro And Macro Environment
  • Industry Analysis
  • Understanding Variables For Industry Analysis
  • Pest Analysis
  • Competitor Analysis
  • Porter’s 5 Force Model Analysis
  • Key Success Factors
  • Business Or Project Viability/Feasibility Analysis
  • Competitive Advantage
  • Segmentation
  • Blue Ocean Strategy
  • Red Ocean Strategy
  • Business Life Cycle
  • Industry And Business Research
  • Swot Analysis
    
    

– Industry, Business, and Environment analysis helps in identifying the factors that are affecting and influencing any businesses or ventures.
– This module will develop cause-and-effect reasoning in a broader sense and will also help to develop the connection between external and internal factors.
– This module is designed in a way that will lead to problem-identification and solving skills.
– To execute any project related to Equity Research, Business Valuation, Fund Raising, and many more, the first step is always to understand the business and its environment.
– By acknowledging all the factors, analysts can arrive at a more accurate conclusion.
– This module will also introduce you to the concepts, types, uses, and importance of strategy.
– You will learn and explore different models to explore Internal, External, Micro, Macro, Competitive Advantage, and Strategies.
– You will also learn how to do systematic end-to-end industry research and how to draft the same in a report.

• • Time Value Of Money (TVM)
  • Net Present Value (NPV)
  • Terminal Period
  • Terminal Value
  • Capital Structure
  • Operating Leverage (OL)
  • Financial Leverage (FL)
  • Capital Budgeting
  • Capital Asset Pricing Model (CAPM)
  • Compounding & Discounting
  • Compounded Annual Growth Rate (CAGR)
  • Payback Period
  • Break-Even Analysis
  • Simple Moving Average
  • Exponential Moving Average
  • Simple Linear Regression
  • Multiple Linear Regression
    
    

– Base concepts are always the building blocks of complex concepts.
– This module will revisit a few of the key finance concepts necessary to help you with further modules, valuation, and projects (internship).
– In this module, you will explore these topics through applications rather than only theoretical understanding.
– You will also understand and practice various forecasting techniques which will be helpful in financial modeling.

• • Theoretical Concepts And Framework
  • 3 Statement Financial Model (IS, BS, CFS)
  • Discounted Cash Flow Statement
  • Scenario Analysis Application
  • Sensitivity Analysis Application
  • Project Budgeting
  • Future Forecast
  • Decision Making
  • Business Drivers
  • Beginner-Level Case For Financial Modeling
  • Intermediate-Level Case For Financial Modeling
  • Advanced-Level Case For Financial Modeling
  • 4+ Financial Modeling Cases

– Financial Modeling is a process of expressing a certain set of numbers logically and coherently. These numbers are interconnected by Excel-based formulas and functions to generate the desired output.
– Financial modeling can be used to address various problem statements. A few of the major ones include building a dynamic 3-Statement Model, Forecasting Business Cash Flow, Capital Budgeting, Performance Analysis, and Determine Business/Project/Product Feasibility.
– In this module, you will discover the concept and thought process behind building a better financial model. You will also look at different financial models.
– Build dynamic 3-statement models. Learn how to connect and structure a multi-year 3-statement model.
– Building financial models from scratch, and with the help of basic information.
– Learn financial modeling with the help of real business cases ranging from Beginner level, Intermediate level, and Advanced level.
– 4+ financial model cases with templates, including industry-specific financial modeling.
– Build scenario and sensitivity analysis to enhance the robustness of the financial model.

• • Bias In Valuation (Theory)
  • Uncertainty In Valuation (Theory)
  • Discounted Cash Flow (DCF) Methodology
  • Free Cash Flow (FCF)
  • Free Cash Flow To Firm (FCFF)
  • Free Cash Flow To Equity (FCFE)
  • Business Drivers Revisit
  • Financial Projection
  • Weighted Average Cost Of Capital (WACC)
  • Cost Of Capital
  • Cost Of Debt
  • Cost Of Equity
  • Net Present Value Revisit
  • Terminal Value Revisit
  • Sensitivity Analysis Revisit
  • Relative Valuation
  • Trading Comps
  • Transaction Comps
  • Enterprise Value
  • Market Cap

     

– Valuation is always a tricky subject. The concept of valuation is a combination of art and science, as has been said many times before.
– Science takes care of the quantitative portion, which can explain the numbers. Art, on the other hand, deals with the qualitative side of things, such as analysis, forecasting, and assumptions. These cannot be easily justified unless backed up by research and reasoning.
– In this Module our focus will be to develop the cognitive capacity to think in the most accurate manner, to arrive at a better and more logical valuation.
– We will cover the Valuation framework and theoretical concepts.
– A brief discussion of different valuation methodologies and understanding the appropriate method for the scenario.
– Pros and cons of different valuation methods.
– Connect the valuation concepts with Equity Research and other Investment strategies.
– And finally, you will perform valuation with the help of all the formulas and techniques that you have learned in the previous 5 modules.

• • Types Of Equity Research Report
  • Buy-Side Research
  • Sell-Side Research
  • Standard Content Of An Equity Research Report
  • Standard Format Of An Equity Research Report

     

– The equity research report is the last step in the equity analysis and valuation process.
– The report includes information, analysis, and most importantly, the analyst’s opinion.
– Reports can be sell-side or buy-side reports. And each category of reports contains multiple versions of reports.
– The saying holds that “one may be knowledgeable but if they cannot convey this message to others, no one will be able to benefit from their knowledge”. In this context, Equity Research Reports provide equity analysts with the opportunity to convey their understanding of certain securities to relevant stakeholders.
– You will learn about and explore Equity Research Reports in this module.
– You will get introduced to different Equity Research templates and learn how to draft a high quality report.

• • Corporate Governance
  • Business Ethics
  • Mergers & Acquisitions
  • Cost Management
    
    

– It is always advisable to learn from real-world challenges and problems. There is a great deal of knowledge about the challenges businesses face.
– Through this module, we are bringing business learnings from across the horizons, so that one can grow as an analyst.
– Case studies will develop skills such as Problem identification, Problem-solving, Teamwork, Time management, Presentation and many more.