Financial Modeling | Risk Analysis Course in Delhi

Financial Modeling And Risk Analysis Course

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.

Description
Curriculum
Eligibility & Duration
Scholarship

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

Dual specialization in Banking & Financial Markets
Highly experienced faculties from reputed banks
Practical lessons in Business communication and Personality Development
Regular interaction with the industry experts
Training on Advance Excel

Module - 1
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?
Nomination facilities in Banks
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

Duration - 2 months
Eligibility: Graduation/ Final year appearing
Course Fee: Rs 25,000/-
Mode Of Class : Classes will be held on weekdays ( Monday, Wednesday and Friday)

Mode Of Payment : Cash/ Demand Draft /Cheques /Bank Deposit )