Course Overview
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.