One Week Short Term Course

On

APPLICATIONS OF SOFTWARE FOR FINANCIAL MODELING & VALUATION

February 10-14, 2018

ABOUT THE COURSE

In todays competitive world, career in finance largely rests on the accumulation of analytical skills related to financial modeling apart from the customary degree. Financial Modeling is the task of building a model representing financial asset and performance of a business. Financial Modeling has become the most important skill-set for the aspiring finance professionals. Financial modeling using software helps finance and commerce professionals to analyze the big data with greater efficiency and accuracy. The best of the global financial institutions like Investment Banks, Hedge Funds, etc. hire people having strong computable skills on large data to draw inferences about devising new investment strategies, structuring new financial instruments, understating of risk return dynamics, security valuation, etc. This course is designed specifically to meet these exact needs.

The course on Applications of Software for Financial Modeling & Valuation is aimed at equipping candidates with practical skills in the field of investment finance, equity research, business advisory and many other areas of finance. The course is primarily designed to familiarize candidates with application of MS-Excel in financial modeling and Security Valuation. The course would be very useful for PG students to carry out the empirical work into their PG dissertations. The Program includes classroom teaching and practical exercises on Software.

COURSE OBJECTIVES

To educate participants about fundamentals of financial modeling

To train participants about risk-return analysis of securities and portfolios

To help participants in identification of undervalued and overvalued securities in financial markets.

To equip participants in handling the financial modeling techniques using MS-Excel

COURSE CONTENTS

Introduction to Financial Modeling

Understanding big data of finance

Decision Making Criterias- NPV, IRR, Profitability analysis

Calculating Cost of Capital

Financial Ratio Analysis

Equity Valuation using DDM, DCF, Relative Valuation, Residual Valuation

Equity Valuation using Regression Based Models

Bond Valuations

Financial Leverage Measurement

Risk Measurement

Risk-return Analysis

Portfolio Construction

Selecting Efficient Portfolios

CAPM Estimation, Factor Models

Financial Markets: Sensex and Nifty

Introductory Financial Econometrics

The Program would cover above mentioned topics through hands on practice on software- MS-Excel and SPSS.

COURSE OUTCOMES

The course participants would be able to:

Analyze the performance of any business using financial statements

Construct the efficient portfolios

Identify the undervalued/overvalued securities of financial markets

Empirically estimate the CAPM and other factor models

WHO SHOULD ATTEND

UG/PG Students interested in Business/Financial Analytics

Research Scholars

Faculty Members, Industry Personnel

IMPORTANT DATES

Last date of registration: 07-02-2018

Announcement of Selection: 08-02-2018

Preference shall remain to PG students.

REGISTRATION FEES

Category	Amount (Rs)
UG Students	500
PG Students	1000
Research Scholars	1500
Faculty Members	2000
Industry Personnel	5000

ABOUT THE INSTITUTE

National Institute of Technology Kurukshetra as a premier institute of the country, has emerged as a center of higher education and research. The academic programs of the Institute cover a wide range of science, social science and engineering disciplines. The Institute offers seven UG, PG, and Ph. D. programs in above mentioned disciplines. NIT Kurukshetra has good infrastructural and research facilities in emerging areas. The faculty of the Institute has academic exposure of repute international institutions and notable achievements in technology development, patents, high quality research output, consultancy and professional awards/recognitions.

PATRON

Padam Shree Dr. Satish Kumar

Director, NIT Kurukshetra

COURSE CONVENER

Dr. Sarika Jain, Department of Computer Applications

COORDINATORS

Dr. Ashwani, Department of Humanities and Social Sciences

Dr. Naveen Kumar, Department of Mathematics

National Institute of Technology Kurukshetra-136119 INDIA

For any query Contact at:

Dr. Ashwani, Assistant Professor, Economics, M: 8901422745

Dr. Naveen Kumar, Assistant Professor, Mathematics, M: 9997876560

REGISTRATION FORM

NAME:

DESIGNATION:

ORGANISATION:

ADDRESS FOR CORRESPONDENCE:

HIGHEST EDUCATIONAL QUALIFICATION:

E-MAIL ID:

CONTACT INFO:

MODE OF PAYMENT (DD):

DD*

DD NO: DATE:

AMOUNT: BANK:

Signature

*In favor of Director, National Institute of Technology, Kurukshetra payable at Kurukshetra

Please send the filled registration form and scanned copy of bank DD to e-mail: stcafmv@gmail.com