Professional Program In Financial Modeling Using Analytics

Name: Professional Program In Financial Modeling Using Analytics
Availability: InStock

by CQS Academy Claim Listing

Financial modeling is a key skill for making large and complex financial decisions. It is used widely across investment banking, equity/credit research and sales.

Contact the Institutes

Fill this form

Duration

Please Enquire

Course Details

Financial modeling is a key skill for making large and complex financial decisions. It is used widely across investment banking, equity/credit research and sales.

What You Learn:

Specialized knowledge
Problem Solving
Cost of capital and uses Essential economics
Investment banking operations

Who Should Do This Course?

Anyone interested in finance
Want to work in Finance sector

Course Curriculum:

Module 1 Problem Solving in Excel
- Problem identification & solving approach
- Descriptive statistics
- Excel basics
- Excel functions & Financial Math
- Excel visualization
- Storytelling with data
- Learning Outcome
  - Know what types of business problems can emerge
  - › Break-down a problem to component parts
  - › Collect data and describe the problem
  - › Compute and present a solution
Module 2 Financial Statement Analysis
- Introduction to FSA
- Income statements
- Balance sheet
- Cash ?ow
- Ratio analysis
- Learning Outcomes
  - Attribute transactions
  - Create an Income statement, a Balance Sheet and a Cash Flow statement
  - Calculate ratios from Financial Statements
  - Interpret ratios
Module 3 Corporate Finance
- Time Value of Money and IRR
- Cost of Capital
- Sources and used of Capital
- Build your first model
- Learning Outcomes
  - Understand what metrics are required to take financial decisions
  - Evaluate a financial opportunity
  - Make a project finance model
Module 4 Equity Modeling
- Introduction to valuation
- Souring historical data
- Forecasting costs and revenues
- Forecasting BS and CFS
- DCF & Relative valuation
Module 5 – Risk Management
- Risk management practices
- Compliance and regulatory reporting
- Clearing process
- Settlement process
- Investor grievances and arbitration
- Other services provided by brokers
Module 6 Power BI
- Business Intelligence (BI) Concepts
- Microsoft Power BI (MSPBI) Introduction
- Connecting Power BI with Different Data Sources
- Power Query for Data Transformation
- Data Modelling in Power BI
- Reports in Power BI
- Reports & Visualization Types in Power BI
- Dashboards in Power BI
Module 7 R program
- R Introduction
- R Basics
- R Statements
- R Loops
- R Functions
- R Data Structures
- R Functions
- R Advance
- Data Interfaces
- Data Visualization
- R Regression
- R Statistics

CQS Training (P) Ltd is a Pioneer in Skill and Talent development Training in NCR founded by renowned lawyer and Industrialist Late Mr. S.P. Bhatia in 1993.

The First Institute was established in 1993 with a state of is ART Facility in a 15,000 sqft area. It was inaugurated by former President Late Mr. Giani Zail Singh in a Pioneer Location of West Delhi.

Today after 30 years CQS Academy Janakpuri has become synonymous with quality education, holistic training, and a one-stop career solution in West Delhi. In new age career training in IT, BFSI, DM, GD, Test Prep, CUET, Corporate, and Executive Training.

Our Mission:

To make students industry ready and professionally efficient by bridging the skill gap between Industry and the students We have set a benchmark for providing our quality & reliable Services to the Candidates and working together to achieve their aims and objectives and take the initiative for continuous improvements and value addition.

View Detailed Profile

Delhi Branch

B-1/624, Block B1, Delhi
Gurgaon Branch

Plot No. 96, Udyog Vihar, Phase -1, Gurgaon

Professional Program In Financial Modeling Using Analytics

Contact the Institutes

Advertisement

Duration

Course Details

Delhi Branch

Gurgaon Branch

Courses

Quick Links