Credit Modeling Project # 1 – Cipla

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

191

 17h 53m | 153 Videos | 77645 Views |   Expert| English[Auto-generated]

Credit Rating Modeling Pharma Training:

Credit rating is determining the ability of an organization to fulfill their financial obligations such as debt. In order to reach this stage of credit rating one needs to have knowledge of financial modeling. Financial Modeling is simple words is projecting the future financials of a company.

This internship course of credit rating modeling on Cipla would aid the participants to learn how to develop a financial model using Excel right from scratch by preparing various schedules such as the debt schedule, revenue build up sheet, working capital schedule, debt schedule etc. it would also focus on Credit Analysis, Credit assessments of various sectors, credit report writing techniques, Sovereign bond rating, Securitization and Standard and Poors rating methodologies.

Target Audience Credit Rating Modeling Pharma Training:

• Students pursuing their MBA/BBA (Finance)
• Students can undertake this as their Summer/Winter internship projects
• Students/Professionals who want to learn Financial Modeling and make a career as an Equity Research Analyst, Credit analyst etc.

Credit Modeling Course Highlights

• Excel proficiency for analyst

Excel is the most widely used spreadsheet tool today. It offers various benefits such as making your tasks simple, quicker and presentable. Hence it is essential prerequisite for any analyst to know excel tools and functions and this is what this module would provide its participant with.

In order to seamlessly combine some complex formulas and to know how to use which formula for which occasion, one needs to learn advanced excel formulas such as the what if analysis, pivot tables, important excel tools such as the data validation, random numbers, subtotal function, creating advanced charts such as the range charts, funding graph, two axis graph, scenario graphs etc.

• Financial Modeling using Excel

This section of the course would focus on core financial modeling which starts with the basics and assumptions in financial modeling, historical analysis and then forecasting each financial statement step wise. The required preparation of schedules with the correct linkages has been explained in detail on a live company.

• Credit Research

After we have successfully completed the projection of financials the next step would be learning about the credit analysis which helps understand its meaning, international credit rating symbols, credit ratios, credit assessment of various sectors, sample financial models in excel have been provided and preparing the credit report at the end.