- For those who want an idea what this is all about, free introductions to the subject are available at http://www.everythingaboutinvestment.com/2012/03/learn-financial-modelling-for-free-in.html and www.edupristine.com/ca/free-30-day-course/ to get a flavour of the subject. A series of blogposts(thoda marketing material here too) at http://chandoo.org/wp/2010/07/21/financial-modeling-introduction/ will also give a good flavour of the same.
- If you are doing this just from interest/learning purpose, then the above links should give you enough insight on what to Google for. If you have a basic knowledge of Excel and advanced finance awareness, then self study should be enough. Otherwise check in your local bookstore for financial modelling Books like http://www.flipkart.com/mastering-financial-modelling-microsoft-excel-2nd/p/itmdytsuehfdcpbx are an option, or else check on Amazon for the top rated books.
- If you still want training, then the options include Edu-Pristine, IMS Pro School etc
- Interestingly, Indian institutions like Educorporate Bridge offer limited online access for just 90days to their courses online, but on MMOC sites like www.udemy.com, they offer lifetime access with 30 days money back guarantee. Just compare https://www.udemy.com/financial-modeling-using-excel/ and https://www.educorporatebridge.com/online-training/project-finance#tabs-2 Maybe they trust foreign users more or are just forced to do so, but it is strange.
- Once you feel you have rockstart financial modelling skills, then consider entering the global championship http://www.modeloff.com
Saturday, June 1, 2013
How to learn financial modeling in India using Excel
I thought a specific post of this nature is relevant to many Indian readers, given that even many top Bschools do not specifically teach this in their post graduate programs -XLRI being a notable exception which has a financial modelling elective, and even ISB where the Finance club arranges financial modelling sessions at a nominal price for those interested. While Bschools do have a MDP(Management Development Program, the question is how qualified are the faculty to teach this subject being a blend of art(spreadsheet design) and science(finance, Excel). Those who have done financial modelling themselves on the job and/or taught it to new joinees, are imho, the best ones to teach this subject. If you are lucky enough to have experienced an analyst training program in an investment bank/PE etc, then you would have got in person training and don't need this post, but most people are not that lucky. From my survey online, even distance learning/fully online financial modelling programs start around Rs 12,000, with classroom coaching going upto Rs 20,000-25,000. It is ironic that we may shell out upto Rs 10lakhs for a Tier II Bschool, but hesitate to pay 1%-1.5% of that for top class training material. Anyways, I suggest the following steps