Financial Modeling and Risk Analysis Course

Duration: 2 Months
Total Time : 60 hours
Mode of Class : Classes will be held on weekdays ( Monday, Wednesday and Friday)
Eligibility: Undergraduate/ Graduate/ Post Graduate.
Prospectus fees: Rs 25,000/-


In today's world of extensive data where decisions are highly quantitative based financial modelling has become an indispensable tool. Financial modelling is the art of building a model using excel to depict financial statements and investment analysis. During the course, you will learn to create your own financial model.This program will help you realize or augment a career in the fields of Investment Banking, Equity Research, Project Finance, Corporate Finance and Credit Rating among others. During the course, you will learn to create your own financial model.

Technical Analysis Institutes in Delhi, Share Market institutes in Delhi, Equity Market institutes in Delhi, Diploma in Stock Market, Best Stock Market Institutes in Delhi

Module1: Introduction to Financial Modeling and Spreadsheet Essentials

 Introduction to Financial Modeling
• Strengths and weaknesses of spreadsheets
• Golden rules of spreadsheet design
• Do we make the most of modeling?

 Spreadsheet essentials
• Lookup and reference functions
• NPV and IRR functions
• Data tables
• IF function
• Excel Skils - Shortcuts, Formulas, Array Function and Pivot Tables
• Simple exercise/models in excel

Module 2: Integrated financial modeling I (Data, cost and revenues)

 Data Collection and Data Structuring
 Preliminary Scrutiny of the Data and Information
 Understand the Business Model and Operating Model
 Modeling the Historical Statement
 Business Drivers Identification and Modeling
 Modeling Assumptions for Future Action
• Modeling Revenue Build-up - projecting the future revenues
• Modeling Cost Build-up - projecting the future cost
• Modeling the Asset Schedule



Module 3: Integrated financial modeling (Financial statement analysis)

 Equity Modeling - Equity Infusion
 Modeling Paid Up Capital and Share Premium Account
 Modeling Retained Earning Schedule
 Modeling the projected P/L and BS
 Modeling the projected Cash Flow Statement
 Performing Ratio Analysis
 WACC and Cost of Equity Analysis
 Performing Valuation using DCF (FCFF & Enterprise Value) and Comparable analysis (Relative Valuation)
 Performing sensitivity/scenario analysis

Module 4: Measuring Risk

 Estimating betas with regression analysis
 Using daily, weekly, and monthly data
 Performing Sharpe, Treynor, Jenson Analysis
 Testing market efficiency
• With regression analysis
• With pivot tables