Credit Modeling Project # 8 - Wonderla

A course for all those who want to learn about Credit Rating Modeling. This course covers major topics like: Basic & Advanced excel, Financial Modeling, Credit Research.

133

 17h 37m | 153 Videos | 88208 Views |   Expert| English[Auto-generated]

Credit Rating Modeling Amusement Park  Courses Training

In this course you will be projecting the financials of the company i.e. Income statement, balance sheet and Cash flow statement for the future 5 years. This will be done by preparing different schedules in excel like revenue-build up, cost sheet, Working capital management, Depreciation schedule etc of Wonderla.

The course material is quite easy and hence anyone can understand financial modeling. This course includes an overview on the Credit Research of Wonderla which operates in the Amusement Park sector of India.

For credit modeling various skills are required. Hence we are going to provide you with the training material for various different modules. The Following skills are required for Credit modeling which will be made available to you.

• Knowledge of Excel
• Knowledge of Accounting
• Financial Modeling
• Report Writing

Target Audience of credit rating modeling

• Engineers, Science graduates, commerce students
• CFA and FRM Candidates
• MBA candidates
• Charted Accountants
• Finance professionals
• Students keen on learning Credit Modeling
• Employees in Analytical firms

• Expertise in Basic Excel and Advanced Excel

This module on Microsoft Excel covers various basic and advanced excel functions like:

In Basic Excel functions covered are:

• Excel Formulas
• Percentages Absolute References
• Conditional Formatting
• IF Function

• COUNTIF and SUMIF
• Pivot Tables
• Freeze and Split
• Excel Shortcuts
• Many more!

In Advanced Excel, Functions covered are:

• What If Analysis
• Arrays
• Names and Dynamic Range
• Advanced Charts
• Important Excel Tools
• Many more!

• Credit Rating Modeling 

This module focuses on the complete training for projections of the financial statements of Wonderla and hence you will learn to forecast financial statements like Income Statements, Balance Sheets & Cash Flows. This module emphasis on:

• Financial statement  Analysis
• Projections  of financial statements
• Concept of circularity
• Understand the Key Linkages of IS‚ BS and CF

• Credit Research

Our module on Credit Research gives in depth knowledge about credit analysis. Credit modeling process evaluates an applicant’s or a Company’s debt issue in order to determine the possibility that the borrower will live up to his obligations. Here you will get an idea of how the Rating companies rate corporate debt. You will learn the following concepts through this module:

• 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