 Mumbai, October 21 2008
Hi Everyone, We are launching a 6 module (24 man hours) program titled "Company Valuation and Advanced Financial Modeling using Excel and VBA." Classes will meet on Saturday's and/ or Sunday's at Mumbai/ New Delhi/ Bangalore. The program is designed to enable the participants to develop advanced modeling skills using Excel and VBA. This program will act as an excellent complement to your existing qualifications such as an MBA or progress towards the CFA designation since it enables you to gain the practical skills that employers are looking for but which are missing from mainstream educational programs such as the MBA degree. The curriculum below outlines in more detail the contents of the course but in summary it is a practitioner's perspective on advanced financial modeling. Thanks!
Methodology:
The course will take a hands-on approach to modeling. Participants will need to bring their laptop's so they can practice as they learn and continue to build on the classroom learning at home. Batch size will be limited to about 10 students so as to maximize interaction and facilitate learning.
Curriculum/ Schedule:
Module # |
Topic |
Details |
1 |
Fundamentals of Statistics and Quantitative Methods |
Basic statistics, probability distribution functions, regression analysis, matrix algebra |
2 |
Excel – Advanced Techniques and introduction to VBA |
Advanced functions, data analysis
Basics of VBA programming |
| 3 |
Fundamentals of Financial Statements Analysis and Corporate Finance |
Interpreting and normalizing financial statements, elements of corporate finance relating to modeling |
4 |
Stock valuation |
Relative valuations, earning's surprise modeling, DCF modeling, FCFF, EVA |
5 |
Portfolio optimization |
Basic Portfolio Optimization with (and without) Short Sales. |
6 |
Comprehensive review/ Examination |
Review of all major topics/ Comprehensive exam and graduation |
Class schedule:
Classes will be held during the weekend.
Mumbai batch: Classes will be held at PN Singh Center for HRD, Santa Cruz (East), Mumbai
New Delhi batch: Classes will be held at YWCA, Ashoka Road, New Delhi
Bangalore batch: Classes will be held at 102, Eden Park, Vittal Mallya Road, Bangalore 560 001
Course Fees:
Rs. 28,000 (including service tax) per person for the 6 module program.
Note: We also offer a more comprehensive Financial Modeling program that covers Equity modeling, Fixed Income Modeling, Options Modeling and Portfolio Optimization. The price for that program is Rs. 75,000 per person and it is spread across 20 days.
Special Discounts:
1) Students registering one month prior to start date will receive a special 10% discount
2) Students registering in groups of 3 or more (and paying the fees together) also receive a special discount of 10%
Registration/ Fee Payment:
- India Students: You may register online from our website. Please click the below link:
- ONLINE PAYMENT/ REGISTRATION
- Alternately you may mail a DD in favor of Ace3Levels Financial Learning Pvt. Ltd. payable at Mumbai to our Mumbai (Andheri East) office address along with your name, email, telephone number, city and mention that you are interested in the Advanced Financial Modeling Workshop program.
Faculty:
Lead faculty for the program is Kris Bindumadhavan, CFA. Kris holds a B.E. Degree and an MBA in addition to receiving the CFA charter from the CFA Institute, USA. He has extensive financial analysis and modeling experience (spread across 8 years) with Capital One, a Top Ten US bank. He has also won awards for teaching excellence. Kris will be supported by a team of professionals with hands-on experience in the field.
Additional Information:
- For questions and other details/ clarifications please email: or call (91) 9833191904
|
