My Profile
Active Members
TodayLast 7 Days
more...
Awards & Gifts
Online Exams
Fresher Jobs
Our fresher job section is exclusively for fresh graduates! Find jobs for freshers in major Indian
cities including Bangalore, Chennai, Hyderabad, Pune or Kochi
Resources
Find educational articles, blogs, discussion threads and other resources.
Colleges
Find details about any college in India or search for courses.
Paid Surveys
|
Financial Models using Spreadsheets
Posted Date: 12 Apr 2008 Resource Type: News/Announcements Category: Short term courses
|
Posted By: Bala Member Level: Diamond
Rating:  Points: 3
|
|
|
Indian Institute of Management Bangalore
Executive Education Programme
Financial Models using Spreadsheets
Programme Directors: Ishwar Murthy and Rajluxmi V. Murthy
Venue: IIMB Campus
Dates: 15 - 18 Dec. 2008
Objectives
This course is primarily designed for financial analysts, accountants and consultants who need to use the spreadsheet to analyse financial data. The purpose of this course is to expose the participant to the power and versatility of the spreadsheet in implementing popular financial decision models. The objective of this course is to impart the following important skills to potential “analysts”:
How to use the power of the spreadsheet to perform their day-to-day analysis effectively and efficiently.
How to use basic modelling tools such as optimization and what-if analysis to make better-informed decisions.
Introduce tools that model and analyze risk in such contemporary problems as valuation of new product introduction, immunizing against interest rate risk and futures.
Introduce the participant to some contemporary derivative models such as options and futures and show how to implement them on the spreadsheet.
Contents
The first part of the course will introduce some of the most useful EXCEL functions that help handle and manipulate data efficiently. Here, functions such as COUNTIF, SUMIF, VLOOKUP, GOAL SEEK, DATA TABLES and PIVOT TABLES will be introduced in the context of specific business problems.
In the second part, Monte-Carlo simulation will be introduced as a tool to model uncertainty. Some typical applications covered will be:
Given uncertainty in the demand, product development cost and variable costs, is it worthwhile introducing a given new product into the market?
How to mitigate interest rate risk?
What stock trading strategies are most useful under different market conditions?
How to value various real options decisions, such as option to “bail-out” of a business, option to liquidate assets, valuation of R&D projects.
In the third part, how to identify the “best” decision using optimisation modelling and sensitivity analysis will be covered. Some typical questions that optimisation modeling seeks to answer are:
How to optimally allocate a company’s financial resources so as to manage cash flow requirements in the future?
How to construct a portfolio of bonds that will meet future liability payments at minimum costs?
How to construct portfolios of stocks taking into account risk and return?
In the last part, contemporary topics such as how to model stock price movement, options pricing suing binomial lattices will be covered.
Participant Profile:
This programme is designed to benefit people who actually take decisions and those who provide analytical support to the decision maker. The former comprises all mid to senior level executives, while the latter includes consultants and financial analysts.
Programme Directors
Ishwar Murthy is a Professor in the area of Quantitative Methods and Information Systems. His research interests are in Discrete and Stochastic Optimization and their applications in telecommunications and routing problems. He has numerous publications in leading journals such as Management Science, Operations Research, Naval Research Logistics, Networks and INFORMS Journal on Computing.
He holds a B. Tech in Mechanical Engineering from IIT Kanpur and a M.B.A. from Northeast Louisiana University. He obtained his PhD in Operations Research from Texas A&M University. Prior to joining IIM Bangalore, he was a tenured faculty member at Louisiana State University. He has also served as a visiting faculty at the Indian Institute of Management, Ahmedabad, Krannert Graduate School of Management at Purdue University, and The Chinese University of Hong Kong, Hong Kong.
Rajluxmi V. Murthy is an Associate Professor in the area of Quantitative Methods and Information Systems. Her research interests are in the field of Optimisation and Simulation, especially in their application in logistics management and the transportation and service industries.
She holds a M.Sc. from the University of Roorkee and an M.S. in Applied Mathematics from the Florida State University. Her doctorate in Operations Research is from the Southern Methodist University, Dallas, USA.
Dr. Rajluxmi has several publications to her credit. She worked as a Systems Analyst with MCI Telecommunications, Dallas, Texas, U.S.A., and helped build decision support systems for the management of the company’s telecommunication network. She was a consultant to GTE at Dallas and an Adjunct Faculty at the Southern Methodist University.
CERTIFICATE OF PARTICIPATION
A certificate of participation will be awarded to the participants by IIMB
Programme Details
Programme Dates
15 – 18 Dec. 2008
Non Residential fees
41,000/-
Residential fees
53,000/-
Registration
Duly completed nominations in the enclosed form along with a crossed demand draft drawn in favour of the "Indian Institute of Management Bangalore", may please be sent to:
The Chief Programme Officer
Indian Institute of Management Bangalore
Bannerghatta Road, Bangalore 560 076
Phone : 080 – 26993742/3264/3475
Fax : 080 - 26584004/26584050
E-mail : edp@iimb.ernet.in
Website : http://www.iimb.ernet.in
For more details, visit http://www.iimb.ernet.in
|
Responses
|
No responses found. Be the first to respond and make money from revenue sharing program.
|
|
|