About The Event

Overview of the Programme

Finance is a dynamic area. In today’s computerized worldit is an inevitable situation for practitioners, academiciansand research scholars to understand spreadsheet techniquesas a core skill to understand the dynamics of finance moreeffectively. The objective of this programme is to applyFinance Methods on Excel and to assist the participants inbuilding more powerful and robust spreadsheet applicationsin developing Financial Models. Financial Modeling coversa wide area from simple” sheets to add up expenses” to“sophisticated risk modeling for projects.” This programmeon Financial Modeling covers standard financial modelsin the areas of corporate finance, financial statementsimulation, portfolio problems.


  • To enable Research Scholars, teaching faculty (fromany discipline of social sciences), corporate executivesand researchers’ use of excel in model building.
  • To develop a fair understanding on the use of excel insubjects like corporate finance, security analysis andportfolio management, financial management, wealthmanagement etc.,
  • To make participants familiar with various functionsof excel in financial modeling.
  • To understand the use of computer software (MSExcel, SPSS) in data analysis.

Course Content

Day 1 will focus on the need for modeling as a generalsubject and as a specific one in finance, use of statisticstools in financial modeling, financial statement modeling,and basics of corporate valuation.

Day 2 will focus on valuation and valuation related aspects,techniques of capital investment decisions, and assessment 
of weighted average cost of capital, sensitivity analysis,modeling for security analysis and portfolio management.

Value Addition

  • Demonstration of statistical techniques through popular software tools.
  • Hands on experience in using excel for model building.


Participants should have an inclination towards learningexcel and for usage in their class room activities as well asin their research work.

Course Delivery

Every participant will be provided a laptop loaded with all programme  material.  Majority of the programme discussions will be in the form of workshop model. Inaddition to this the pedagogy also includes lectures,demonstrations, practical, relevant examples and discussions. Clear and concise explanations will be providedin each case for the implementation of the models usingExcel.

Who should attend?

  • Research scholars
  • Academicians
  • Practitioners working in any functional area interestedin excel usage.

Invite friends

Contact Us

Page Views : 1132

Venue Map