Credit Modeling Project # 6 - Educomp

This is a complete application based live project wherein you would get to learn about the credit rating modeling of education sector company Educomp. It includes tutorials on understanding the basic and advanced excel functions required by credit analysts, financial modeling lessons. At the end of this comprehensive training you would created a credit model of Educomp on your own.

215

 17h 46m | 153 Videos | 86953 Views |   All Levels| English[Auto-generated]

 Credit rating  Modeling Education Sector  Training

You must be knowing how the financial models are the key elements in most business decisions. Financial modeling forms an integral part of analysis in case of credit rating, project finance, Mergers and acquisitions, investment banking and mush more. Financial modeling helps in evaluating and analyzing business risks.
So after knowing all the importance of financial modeling, do you want to know how the model is prepared? Edu CBA brings you the course on Credit rating modeling of Educomp. Through this course learn all the niti-grities of preparing a financial model. We are here to offer you a practical application which is the current industry requirement. Furthermore this course is based on the financial modeling of a live company like Educomp. Creating such a financial model you will get insights into the working of Educomp as well as the education sector. You can undertake this project as part of your college internship also. You will be provided with a Certificate upon the course completion.

Target audience

• MBA students
• Commerce graduates
• Students who want to undertake internship in finance
• Students or professionals who want to enhance their knowledge of Financial modeling

Course Highlights

• Basic excel 

Through this module you will learn various excel functions like IF, COUNTIF, charts and graphs, excel shortcuts, freeze and split, sorts and filters etc.

• Advanced Excel

In this module you get to explore the advanced  Excel functions like whatif analysis, names and dynamic range, Auditing and Trouble Shooting formulas, advanced charts and much more.

• Financial Modeling using excel

Through this course on financial modeling learn about horizontal and vertical analysis. Learn to carry out ratio analysis of educomp. Also learn to carry out projects and forecasting of the financial statement of educomp. Prepare the working capital schedule, depreciation schedule, shareholder’s equity schedule etc. You will also get access to advanced financial modeling templates.

• Credit research

Understand what is credit analysis in detail. Study the credit assessments for banks, manufacturing companies, construction sector, real estate sector etc. Also learn about the credit report techniques and credit rating methodologies.

Back to top ▴