OBJECTIVES
To provide an effective management approach to improve performance in the following areas:
- Decision Making in Finance
- Quantitative Techniques
- Appraisal and Project Investment Skills
- Portfolio Allocation
With the help of the contemporary approaches available to finance managers with specific reference to using EXCEL spreadsheets.
PROGRAMME CONTENTS
- Understanding Excel
- Use of Functions such as Goal Seek, Sort, Filter, etc.
- Spreadsheets for Designing Financial Loans and Repayment Schedule
- Use of Functions such as PMT, Loan Schedule, etc.
- Financial Modelling for Project Appraisal
- Use of Functions like Net Present Value (NPV), Internal Rate of Return (IRR), etc.
- Forecasting Techniques
- Use of Functions such as Goal Seek, Sort, Filter etc
- Use of Spreadsheets in Quantitative Techniques
- Use of Functions such as Countif, Mean, Mode, etc.
- Use of Spreadsheets in Quantitative Techniques
TARGET AUDIENCE
Managers and Executives working with Banks, Financial Services, AMC, Hedge Funds, Mutual Funds, Investment Banking, Brokerage Houses, Financial Market Intermediaries, Research Analyst, Portfolio Managers, Risk Managers, Accountants, Project Managers, Managers and Executives in the finance department of manufacturing firms & IT firms. The programme is particularly focused at managers who wish to obtain an insight into use of spreadsheets.
NOTE
Prior understanding of spreadsheets and Excel is not a pre-requisite and the programme would start with the basics of spreadsheet modeling.
DURATION & TIMINGS
2 days
9.30 am to 5.30 pm
FEES
Rs. 12000.00+ 10.30% (Service Tax and Education Cess) per participant Inclusive of tuition fees, study material, refreshments, lunch and participation certificate.
PROGRAMME COORDINATOR
Md. Nadeem Alam
For further details regarding registration, contact:
E-mail: training@bseindia.com
Phone: 022-22721126 / 27,022-22721233 / 34
Ext: 8813, 8246, 8464,8175,8303
Fax: 22723250
