News Details

Value Added Course on “Financial Modelling” for MBA – Finance Students

03-Jun-2020
Value Added Course on “Financial Modelling” for MBA – Finance Students

Students of MBA–Finance specialisation are currently undergoing a value added course on “Financial Modelling”. This has become a must in the tool kit of MBAs specializing in Finance. This module helps students to learn building spreadsheet models for both valuations as well as risk management and help students to develop core skills for financial analysis.
The training is facilitated by Prof. Ratan Gupta, Director at Knowledge Varsity, Bengaluru. He has more than 15 years of experience as a financial consultant in companies like Goldman Sachs, Headstrong capital markets, Geometric software and from past 8 years, he is serving as Director at Knowledge Varsity. Prof. Ratan Gupta, pursued Engineering from IIT, Kharagpur, and obtained professional degree as Chartered Financial Analyst. He also has a degree in Financial Risk Management from Global Association of Risk Professionals (GARP).
Topics covered under the course:
• Corporate Valuation (overview)
• Financial Modelling (overview)
• Analysis of historical data
• Understanding financial statements
• Proforma financial statement building
• Cash flow estimation
• Beta estimation
• Capital structure estimation
• Cost of capital estimation
• Introduction to Portfolio Modelling
• Efficient Portfolio
• Value at Risk(VAR)
• Cost and Break-even analysis
• Taxation
Delivered using hands-on case study based approach, students will learn how to perform valuation of real companies listed on NSE.

Back to News