Credit Modeling Project # 3 – Dabur

In this course you will learn about Credit Modeling for FMCG Sector Company. The company that we will be analyzing will be Dabur. We will use the financial modeling in excel technique to forecast the future financials of the Dabur.

183

 17h 37m | 153 Videos | 78590 Views |   Intermediate| English[Auto-generated]

 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!!