Course Overview
Course on Credit Rating Modeling – FMCG
This course is designed in such a manner so that anyone can understand financial modeling. This course includes an overview on the Credit Research of Dabur. It’s very important to understand role of credit rating agencies like S &P, Moody’s and also understand how they give rating to the companies. This course will provide you detail insights into Credit research and financial Modeling.
The Following skills are required for Credit modeling –
- Knowledge of Microsoft Excel
- Knowledge of Accounting
- Financial Modeling
- Report Writing
- Securitization
Target Audience
- Any student with a graduation degree (Engineers, Science graduates, commerce students, Arts students)
- CFA and FRM Candidates
- MBA (Finance)
- Charted Accountants (CA)
- Finance professionals
- Employees in Analytical firms
Course Highlights
Basic Excel and Advanced Excel
Gain Excel proficiency required for financial analyst through this module. This module covers various basic and advanced excel functions like:
Basic Excel
- Excel Formulas
- Percentages Absolute References
- Conditional Formatting
- IF Function
- COUNTIF and SUMIF
- Pivot Tables
- Freeze and Split
- Excel Shortcuts
- Many more!
Advanced Excel
- WhatIf Analysis
- Arrays
- Names and Dynamic Range
- Advanced Charts
- Important Excel Tools
- Many more!
Credit Rating Modeling
Financial Modeling includes professionally forecasting future financial statements like Income Statements, Balance Sheets & Cash Flows. Build a step-by-step advanced financial model‚ Concept of circularity‚ Understand the Key Linkages of IS‚ BS and CF and many more. This module emphasis on:
- Financial statement Analysis
- Projections of financial statements
Credit Research
This module gives in depth knowledge about credit analysis. Credit Modeling process evaluates an applicant’s loan request or a corporation’s debt issue in order to determine the possibility that the borrower will live up to his obligations. Learn how Rating companies rate corporate debt. It involve following:
- Accounting Analysis a Credit Approach
- Credit Assessment Banks NBFCs
- Credit Assessment of various sector Companies
- Sample Financial Models for Credit Analysis
- Report writing techniques
- Sovereign Bond Rating
- Securitization
- And much more!!