Spot Light

Training Calendar

Guest Sessions

Day/Date Topic Speakers Time Access Details
Saturday,
17 Oct 2020
Alternative Approach to Credit Risk Analysis Swapnil Pawar,
Founder ASQI
1:00pm - 2:00pm
Saturday,
24 Oct 2020
Building a Wealth Management Business Shiv Gupta,
Founder & CEO,
Sanctum Wealth Managemen
1:00pm - 2:00pm

Financial Modeling (CIFM)

Date Topic Coverage Faculty Time Access Details
Monday,
12 Oct 2020
Introduction and overview

-Trainer and trainee introduction

-Overview of financial model

-Setting expectations

-Methodology: Interactive discussion with participants

Mr. Viswanathan 7:00pm - 9:00pm Join Zoom Meeting
https://zoom.us/j/98746749954
Meeting ID- 987 4674 9954
Passcode- 354730
Wednesday,
14 Oct 2020
Basic mathematics for financial modeling

-Understanding different types of data

-Understanding different types of variables

-Working with averages, growth rates, proportions, and basis points

Mr. Viswanathan 7:00pm - 9:00pm Join Zoom Meeting:
https://zoom.us/j/97357431594
Meeting ID: 973 5743 1594
Passcode: 301703
Monday,
19 Oct 2020
MS Excel best practices

-Structuring workbook and worksheets

-Naming worksheets

-Delineating between input cells and formula cells

-Working with colour codes

-Working with relative reference vs absolute reference

-Working with range names and tables

Mr. Viswanathan 7:00pm - 9:00pm Join Zoom Meeting-
https://zoom.us/j/96659091784
Meeting ID- 966 5909 1784
Passcode- 321566
Wednesday,
21 Oct 2020
Financial statement analysis for financial modeling

-Role of ratio analysis in financial modeling

-Time series analysis for financial modeling

-Calculating ratios and growth rates

-Limitations of textbook ratios and alternatives

Mr. Viswanathan 7:00pm - 9:00pm Join Zoom Meeting-
https://zoom.us/j/95432450273
Meeting ID- 954 3245 0273
Passcode- 509410
Monday,
26 Oct 2020
Planning a financial model

-Understanding the business model

-Identifying variables and relationship

-Developing model structure using reverse flow charging

-Understanding data dimensions and model architecture

Mr. Viswanathan 7:00pm - 9:00pm Join Zoom Meeting-
https://zoom.us/j/96592564653
Meeting ID- 965 9256 4653
Passcode- 146376
Wednesday,
28 Oct 2020
Revenue modeling

-Understanding the role of business constraints in revenue modeling

-Various levels of revenue modeling

-Demand side modeling

-Production/supply side modeling

-Top-down approach to financial models

Mr. Viswanathan 7:00pm - 9:00pm Join Zoom Meeting-
https://zoom.us/j/95808185348
Meeting ID- 958 0818 5348
Passcode- 963434
Monday,
2 Nov 2020
Modeling operating expenses

-Understanding expense categorisation in India and the resulting challenges in modeling

-Modeling operating expenses

-Modeling changes in inventory

Mr. Viswanathan 7:00pm - 9:00pm Join Zoom Meeting-
https://zoom.us/j/93304000748
Meeting ID- 933 0400 0748
Passcode- 394555
Wednesday,
7 Nov 2020
Advanced mathematics for financial modeling

-Understanding numerical series (arithmetic progression and geometric progression)

-Basic time value of money

-Advanced time value of money concept

-Using numerical series and TVM concepts in financial modeling

Mr. Viswanathan 7:00pm - 9:00pm Join Zoom Meeting
https://zoom.us/j/91993999542
Monday,
9 Nov 2020
Advanced MS Excel functions and features

-Working with Boolean values

-Working with IF statements

-Advanced numerical functions and lookup functions

-Financial function in MS Excel

Mr. Viswanathan 7:00pm - 9:00pm Join Zoom Meeting-
https://zoom.us/j/92320051834
Meeting ID- 923 2005 1834
Passcode- 494245
Wednesday,
14 Nov 2020
Depreciation and Fixed Asset schedule

-Understanding a fixed asset schedule

-Comparison between SLM and WDV method for calculating depreciation

-Challenges in SLM modeling and alternatives

-Modeling capex

Mr. Viswanathan 7:00pm - 9:00pm Join Zoom Meeting-
https://zoom.us/j/96294957525
Meeting ID- 962 9495 7525
Passcode- 794774
Monday,
16 Nov 2020
Modeling debt and interest

-Structure of debt schedule

-Modeling debt when limited information is available

-Modeling debt when maturity dates are debt available

Mr. Viswanathan 7:00pm - 9:00pm Join Zoom Meeting-
https://zoom.us/j/94017153641
Meeting ID- 940 1715 3641
Passcode- 353791
Wednesday,
21 Nov 2020
Modeling other P&L line items

-Modeling taxes

-Modeling minority interest and income from associates

-Modeling EPS and DPS

Mr. Viswanathan 7:00pm - 9:00pm Join Zoom Meeting-
https://zoom.us/j/99193470827
Meeting ID- 991 9347 0827
Passcode- 108404
Monday,
23 Nov 2020
Modeling balance sheet

-Balance sheet line items in India and resulting challenges

-Identifying balance sheet items into (i) Fictitious asset/liability (ii) Financial assets/(liability) (iv) Operating assets and liabilities

-Modeling working capital line items

- Modeling provisions including provision for employee benefits

-Modeling equity

Mr. Viswanathan 7:00pm - 9:00pm Join Zoom Meeting-
https://zoom.us/j/95774056536
Meeting ID- 957 7405 6536
Passcode- 943474
Wednesday,
25 Nov 2020
Modeling cash flow statement

-Reorganising cash flow line items

-Modeling cash flow statement under indirect method

-Cash sweep statement: Alternate approach to cash flow statement

-Algebraic approach to handling circular reference in cash sweep statement

Mr. Viswanathan 7:00pm - 9:00pm Join Zoom Meeting-
https://zoom.us/j/99591145199
Meeting ID- 995 9114 5199
Passcode- 262984
Monday,
30 Nov 2020
DCF Valuationt

-Overview of three stage DCF model

-Factors affecting number of stages and tenure of each stage

-Projecting out years (second stage)

-Critical check lists for estimations and projections in DCF

-Calculating cost of capital

-Calculating present values and value of equity shares

-Sensitivity analysis of DCF valuation using data table

Mr. Viswanathan 7:00pm - 9:00pm Join Zoom Meeting-
https://zoom.us/j/97101330896
Meeting ID- 971 0133 0896
Passcode- 997870
Wednesday,
2 Dec 2021
Open house Mr. Viswanathan 7:00pm - 9:00pm Join Zoom Meeting-
https://zoom.us/j/94646960849
Meeting ID- 946 4696 0849
Passcode- 450887

Financial Report Writing

Day/Date Topic Coverage Faculty Time Access Details
Thursday,
15 Oct 2020
Components of an argument

-Understand the various parts of an analytical report such as assertion, premise and conclusion

-Know the significance of presenting the various components in a structured manner to be able to persuade the reader

-Presenting the various components for deductive arguments and inductive arguments

Mr. Viswanathan 7:00pm - 9:00pm Join Zoom Meeting-
https://zoom.us/j/96417161184
Meeting ID- 964 1716 1184
Passcode- 494474
Thursday,
22 Oct 2020
Top-down vs Bottom-up approach

-Understanding pyramid structure and power writing

-Presenting deductive vs inductive arguments

-Knowing the difference between top-down vs Bottom-up approach and when to use what

-Presenting an idea using top-down pyramid

-Presenting an idea using bottom-up pyramid

Mr. Viswanathan 7:00pm - 9:00pm Join Zoom Meeting-
https://zoom.us/j/97841031641
Meeting ID- 978 4103 1641
Passcode- 761576
Thursday,
29 Oct 2020
Gaining the reader’s attention

-Beginning with clear, concise and persuasive opening

-Using bread crumbs to retain the reader’s attention

-Using flags and sign posts

-Ending with powerful conclusion

Mr. Viswanathan 7:00pm - 9:00pm Join Zoom Meeting-
https://zoom.us/j/98177136608
Meeting ID- 981 7713 6608
Passcode- 461195
Thursday,
5 Nov 2020
Enabling skim through of documents

-Writing effective paragraph/slide headings

-Using margin texts in word based reports

-Using pictographs

-Making charts and table easy to understand/interpret

Mr. Viswanathan 7:00pm - 9:00pm Join Zoom Meeting-
https://zoom.us/j/91935579142
Meeting ID- 919 3557 9142
Passcode- 505935
Other key attributes of good writing

-Unity of idea

-Bringing variety using different sentence structures

-Maintaining coherence of idea

Mr. Viswanathan 7:00pm - 9:00pm Join Zoom Meeting-
https://zoom.us/j/91935579142
Meeting ID- 919 3557 9142
Passcode- 505935
Thursday,
12 Nov 2020
Common grammatical mistakes

-Eight rules of comma

-Rules of capitalization

-Using other punctuations such as semi-colon, colon, em-dash and en-dash

Mr. Viswanathan 7:00pm - 9:00pm Join Zoom Meeting-
https://zoom.us/j/93211788827

Meeting ID- 932 1178 8827
Passcode- 594846

Credit Research Analyst (CCRA)

Day/Date Topic Coverage Faculty Time Access Details
Tuesday,
13 Oct 2020
Financial Statement Analysis Mr. Abhijit Chatterjee 7:00pm - 9:00pm Join Zoom Meeting-
https://zoom.us/j/93707674839
Meeting ID- 937 0767 4839
Friday,
16 Oct 2020
Credit Specific Analysis – Banker’s and Analyst Perspective Mr. Abhijit Chatterjee 7:00pm - 9:00pm Join Zoom Meeting-
https://zoom.us/j/93871257713
Meeting ID- 938 7125 7713
Tuesday,
20 Oct 2020
Understanding of Loans and Bonds Mr. Abhijit Chatterjee 7:00pm - 9:00pm Join Zoom Meeting-
https://zoom.us/j/92948051643
Meeting ID- 929 4805 1643
Friday,
23 Oct 2020
Credit Rating- Internal & External (Part 1) Mr. Abhijit Chatterjee 7:00pm - 9:00pm Join Zoom Meeting-
https://zoom.us/j/92395379126
Meeting ID- 923 9537 9126
Tuesday,
27 Oct 2020
Credit Rating- Internal & External (Part 2) Mr. Abhijit Chatterjee 7:00pm - 9:00pm Join Zoom Meeting-
https://zoom.us/j/96424143759
Meeting ID- 964 2414 3759
Friday,
30 Oct 2020
Credit Strategy & Portfolio Management (Part 1) Mr. Abhijit Chatterjee 7:00pm - 9:00pm Join Zoom Meeting-
https://zoom.us/j/93225418588
Meeting ID: 932 2541 8588
Tuesday,
3 Nov 2020
Credit Strategy & Portfolio Management (Part 2) Mr. Abhijit Chatterjee 7:00pm - 9:00pm Join Zoom Meeting-
https://zoom.us/j/95318051465
Meeting ID: 953 1805 1465
Friday,
6 Nov 2020
Credit Monitoring, NPA Management, Enhancement and Securitization (Part 1) Mr. Abhijit Chatterjee 7:00pm - 9:00pm Join Zoom Meeting-
https://zoom.us/j/95563931857
Meeting ID: 955 6393 1857
Tuesday,
10 Nov 2020
Credit Monitoring, NPA Management, Enhancement and Securitization (Part 2) Mr. Abhijit Chatterjee 7:00pm - 9:00pm Join Zoom Meeting-
https://zoom.us/j/94107109670
Meeting ID: 941 0710 9670
Friday,
13 Nov 2020
Credit Risk Models and Regulations (Part 1) Mr. Abhijit Chatterjee 7:00pm - 9:00pm Join Zoom Meeting-
https://zoom.us/j/97856958494
Meeting ID: 978 5695 8494
Tuesday,
17 Nov 2020
Credit Risk Models and Regulations (Part 2) Mr. Abhijit Chatterjee 7:00pm - 9:00pm Join Zoom Meeting-
https://zoom.us/j/95751939312
Meeting ID: 957 5193 9312
Friday,
20 Nov 2020
Understanding and analysis of Corporate Banking Facilities and other financing forms Mr. Abhijit Chatterjee 7:00pm - 9:00pm Join Zoom Meeting-
https://zoom.us/j/97934140033
Meeting ID: 979 3414 0033

Alternative Investment Manager (AIM)

Day/Date Topic Coverage Faculty Time Access Details
Saturday,
10 Oct 2020
AIF Regulations Ms. Sharda Balaji Managing Partner, Novojuris 11:00am - 12:00pm
Saturday,
17 Oct 2020
Portfolio allocation in AIF – how different is this ballgame? Apurva Sahijwani (Axis Private Wealth)
Satinder Agarwal (Seguro Wealth, Dubai)
11:00am - 12:00pm
Saturday,
24 Oct 2020
Regulations & Compliance in AIFs TBC 11:00am - 12:00pm

Portfolio Management (CPM)

Day/Date Topic Coverage Faculty Time Access Details
To Be Confirmed Objectives of Investment Decisions To Be Confirmed 1:00pm - 3:00pm Join Zoom Meeting-
https://zoom.us/j/92066050079
Meeting ID: 920 6605 0079
To Be Confirmed Financial Markets To Be Confirmed 1:00pm - 3:00pm
To Be Confirmed Financial Analysis and Valuation To Be Confirmed 1:00pm - 3:00pm
To Be Confirmed Modern Portfolio theory 1:00pm - 3:00pm
To Be Confirmed Investment Management To Be Confirmed 1:00pm - 3:00pm

VBA for MS Excel (MS Excel Macro)

Day/Date Topic Coverage Faculty Time
To Be Confirmed Introduction and Overview

- Overview of VBA

- Understanding the VBA environment

- Understanding VBA libraries

- Overview of object, properties and methods

- Understanding subroutines and functions

Mr. Viswanathan To Be Confirmed
To Be Confirmed Input, processing, and storage

- Input commands in MS Excel

- Storing input data in MS Excel or name manager

- Processing data in VBA

- Use of MS Excel functions in VBA

- Storing calculated results in MS Excel

Mr. Viswanathan To Be Confirmed
To Be Confirmed Logical functions

- If.. Then.. Else construct

- Select Case construct

Mr. Viswanathan To Be Confirmed
To Be Confirmed Loops

- For Next construct

- Do Loop Construct

- While Wend construct

Mr. Viswanathan To Be Confirmed
To Be Confirmed Working with code snippets

- Generating code snippets using record macro feature

- Obtaining code snippets online

Mr. Viswanathan To Be Confirmed
To Be Confirmed Creating a complete subroutine

- Identifying the steps

- Identifying conditional steps

- Generating codes

- Modifying codes to suit the need

- External resources helpful for coding

Mr. Viswanathan To Be Confirmed
To Be Confirmed Creating functions

- Understanding the concept of functions

- Private and public functions

- Calling additional functions and sub-routines

- Creating and function to work with MS Excel

Mr. Viswanathan To Be Confirmed
To Be Confirmed Creating and working with user forms

- - Introduction to ActiveX controls

- Various ActiveX controls button

- Reading values in ActiveX control and accepting input using the same

- Adding elements to ActiveX controls manually and automatically

- Hiding and showing ActiveX controls

Mr. Viswanathan To Be Confirmed

Financial Mathematics For Analysis

Day/Date Topic Coverage Faculty Time
To Be Confirmed Introduction to time value of money

- Simple interest vs compound interest

-Understanding present values and future values

-Calculating present value, future value, rate and number of periods

-MS Excel functions for calculating PV, FV, Rate, NPer

Mr. Viswanathan To Be Confirmed
To Be Confirmed Role of time value of money in asset valuation

- Fundamental equation of value

-Real world valuation vs risk neutral valuation

-Role of spot rates in asset valuation

-Valuation of bond with (i) yield to maturity (ii) with spot rates

-Working with forward rates

Mr. Viswanathan To Be Confirmed
To Be Confirmed Working with annuity

-Introduction to annuity

-Mathematical formula for calculating annuity

-MS Excel function to calculate annuity

-Calculating annuity when there are uncertainties

-Modeling growth annuity

Mr. Viswanathan To Be Confirmed
To Be Confirmed Overview of application of time value of money is financial reporting

-Lease accounting

-Investment and debt accounting under IFRS 9 / IndAS 109

-Impairment of assets

-Accounting for employment obigations

Mr. Viswanathan To Be Confirmed
To Be Confirmed Advanced MS Excel to crunch complex numerical series problems

- Creating a consolidated debt schedule when there are several debts taken at different times at different rates and different tenure

- Creating a consolidated depreciation schedule when there are different asset purchased at different dates with different life and salvage value

-Creating debt repayment schedule based for a series of debt

Mr. Viswanathan To Be Confirmed

Finance for Entrepreneurs

Day/Date Topic Coverage Faculty Time
To Be Confirmed Introduction to Finance

-Introduction to Financial Statements

- Key Items, Interpretation

Mr. Himanshu Arora To Be Confirmed
To Be Confirmed Types of Businesses

- Sources of Funds (Types of loans- Short/Long Term)

- Investment opportunities (Short term/Long Term)

Mr. Himanshu Arora To Be Confirmed
To Be Confirmed Key Financial Ratios

- Key Financial Ratios to understand the competition

Mr. Himanshu Arora To Be Confirmed
To Be Confirmed Time Value of Money

- Introduction to FV, PV and other terms.

- Understanding the Economy

- Role of Government in businesses & Recent Govet schemes for Small - Businesses

Mr. Himanshu Arora To Be Confirmed

Array
(
    [SERVER_SOFTWARE] => Apache
    [REQUEST_URI] => /member-dashboard/member-training-calendar/
    [USER] => exqualifi
    [HOME] => /home/exqualifi
    [FCGI_ROLE] => RESPONDER
    [REDIRECT_UNIQUE_ID] => X5F0hWGz@nSVm3@dVXGfzwAAApE
    [REDIRECT_SCRIPT_URL] => /member-dashboard/member-training-calendar/
    [REDIRECT_SCRIPT_URI] => https://exqualifi.com/member-dashboard/member-training-calendar/
    [REDIRECT_HTTPS] => on
    [REDIRECT_SSL_TLS_SNI] => exqualifi.com
    [REDIRECT_STATUS] => 200
    [UNIQUE_ID] => X5F0hWGz@nSVm3@dVXGfzwAAApE
    [SCRIPT_URL] => /member-dashboard/member-training-calendar/
    [SCRIPT_URI] => https://exqualifi.com/member-dashboard/member-training-calendar/
    [HTTPS] => on
    [SSL_TLS_SNI] => exqualifi.com
    [proxy-nokeepalive] => 1
    [HTTP_USER_AGENT] => CCBot/2.0 (https://commoncrawl.org/faq/)
    [HTTP_ACCEPT] => text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
    [HTTP_ACCEPT_LANGUAGE] => en-US,en;q=0.5
    [HTTP_ACCEPT_ENCODING] => br,gzip
    [HTTP_HOST] => exqualifi.com
    [HTTP_CONNECTION] => Keep-Alive
    [HTTP_X_HTTPS] => 1
    [PATH] => /usr/local/jdk/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/usr/local/bin:/usr/X11R6/bin:/root/bin:/opt/bin
    [SERVER_SIGNATURE] => 
    [SERVER_NAME] => exqualifi.com
    [SERVER_ADDR] => 88.99.98.147
    [SERVER_PORT] => 443
    [REMOTE_ADDR] => 35.172.236.135
    [DOCUMENT_ROOT] => /home/exqualifi/public_html
    [REQUEST_SCHEME] => https
    [CONTEXT_PREFIX] => 
    [CONTEXT_DOCUMENT_ROOT] => /home/exqualifi/public_html
    [SERVER_ADMIN] => webmaster@exqualifi.com
    [SCRIPT_FILENAME] => /home/exqualifi/public_html/index.php
    [REMOTE_PORT] => 56542
    [REDIRECT_URL] => /member-dashboard/member-training-calendar/
    [GATEWAY_INTERFACE] => CGI/1.1
    [SERVER_PROTOCOL] => HTTP/1.1
    [REQUEST_METHOD] => GET
    [QUERY_STRING] => 
    [SCRIPT_NAME] => /index.php
    [PHP_SELF] => /index.php
    [REQUEST_TIME_FLOAT] => 1603368069.11
    [REQUEST_TIME] => 1603368069
    [argv] => Array
        (
        )

    [argc] => 0
)