Excelsior - Vision to Excel

11/11/2018

11/11/2018

Excelsior, is offering discount packages on all its Data Analytics, Risk Modelling and Financial Modelling products.
www.excelsiors.in to check
WhatsApp 9780564549 to get details

03/11/2018

Training on Analytics for Finance @ WNS 30th Oct 2018- 1st Nov 2018
WNS is the leading Global process management company listed at NYSE.

17/06/2018

Join our Workshop on Business Forecasting using Excel, R & Python starting 30th June 2018.
Topics covered include
1. Basic Statistics
2. REGRESSION
3. Time Series Modelling
4. Machine Learning
The model will be first developed in excel and same result will be achieved using R and Python. For details contact 9780564549

11/06/2018

In the future in office, there is electricity, there is water and there is DATA. If you want to make machines smart, the machine must drink Data's
Join our Data analytics Workshop starting 30 June 2018. Contact 9780564549

10/06/2018

I am starting a series of blogs on IFRS9 'Expected Loss Provisioning'. In the next few days I will discuss how to model Expected Loss as per New accounting norms.
I will be using Simple Excel spreadsheets for discussions. If anyone has any questions, feel free to contact at 9780564549

Question 1 Why Expected Loss Provisions are required -
1 Pricing (Int. rates) is biased, int. rates are biased and driven by strategic concerns
2. Earlier RBI Provisions - Prescriptive guidelines for identification + provisioning
New Expected Loss Provisions - Currently Impaired + Credit that may impair in future
3. Eg 1. Suppose a loan is given to Telecom company, now there is some problems with 4G licence which will cause huge losses to company.
So Expected Loss Provisions - are they forward looking?
Eg 2. Suppose loan is given to Tata Steel, now Tata is sexpected to face huge problems because of Steel dumping
So again are my provisions - considering loss due to theses macro economic factors.
Current Provisioning is a) not Bank Specific b) no prescribed basis (just to meet regulatory objectives like promoting a certain loan)
Provisioning is required to smoothen out profits of Bank in long term rather than balance sheet taking a hit because of sudden losses

Question 2 For Which Instruments are provisions required
Provisions are not applicable to Financial assets measured at FVTPL
FVTPL - No ECL because losses are already going in PnL
Not FVTPL - ECL

Question 3 How to calculate Provisions ?
Step 1 Check whether ECL provisioning applies to the Co. & Instrument or not? Doubt
Companies Companies on whom Ind AS applies - Have to do ECL Provisioning eg. Bank following Standardized approach + Ind AS applicable
Companies adopted IRB approach - Have to do ECL Provisioning whether Ind AS followed or not
Why ? To Compare Provisions already held vs Estimated ECL Provisions
Instruments No FVTPL - ECL

Step 2 Identify the approach with which ECL provisioning needs to be done eg for Banks & FI - General approach , for NBFC - Specific approach, For Trade & Contract receivables etc.
Step 3 Define a strict criteria for identifying an asset as Stage 1 or Stage 2 or Stage 3 because calculations of ECL depends on it.
What are these stages ?
Stage 1 - Performing Asset - Low Credit Risk
What is 'low' - Depends on banks definition of low eg rating AA ++, PD

20/12/2017

Excelsior is now ready to provide around 2500 Excel sheets in the following space
1.Monte Carlo Simulation
2. Credit scoring
3. Credit derivatives
4. Mortgage backed securities
5. Market Risk Modelling
6. Credit Risk Modelling
7. Operational Risk modelling
8. Econometrics
9. Basel including FRTB
10. Project Financing
11. Financial Modelling
12. Actuarial modelling
13. 404A valuation

21/05/2017

We are Conducted Workshop on advanced excel for finance on 16th, 17th and 18th June. For More info visit Excelsiors.in

01/01/2017

If anyone is free and want to intern with SSEI for next 6mths, please contact us at 9780564549. The work would include writing research papers, creating excel models and developing softwares etc.

01/01/2017

Going to CFA Institute 70th Annual Conference, Philadephia, USA in May 2018 with Sanjay Saraf. Feeling motivated !!

16/11/2016

24/09/2016

Move beyond theoretical concepts to actual business valuation. Equip yourself with the advanced tools in Excel to become efficient and differentiate yourself. Join 4 day Financial Modelling workshop (2 weekend) on Advanced Excel and Business Valuation by Karan Aggarwal Sir.Time 9am to 6pm on Oct 15-16 & Oct 22-23 @ SSEI Elgin Centre. Contact 9046266784...