A minute for your Feedback please

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
  1. 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. 
  2. 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. 
  3. If you still want training, then the options include Edu-Pristine, IMS Pro School etc
  4. 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.
  5. Once you feel you have rockstart financial modelling skills, then consider entering the global championship http://www.modeloff.com

20 comments:

abc said...

Hi I want to do a financial modeling course. I am confused between IMS Proschool and Edupristine.I want to learn this topic in great details. I would be helpful if you could provide me some insight about the course.

abc said...

Hi I want to do a financial modeling course. I am confused between IMS Proschool and Edupristine.I want to learn this topic in great details. I would be helpful if you could provide me some insight about the course.

Anandh Sundar said...

No idea about IMS Proschool, look at your budget/requirements location, and then decide. Some people may not learn well from e-learning, so thats a factor for you to consider while choosing classroom vs online.

Mohamed Abdullah said...

Hi... I'm also confused between both. Edupristine conducts classroom sessions in Chennai but not imsproschool... For online course you've to be more focused and disciplined and given my work situation, spending time online would not be really a right option. The cost is almost double the online (ims) for a classroom programme (pristine)... Any suggestions on this would be appreciated... And also any reviews about both the options would be grateful

Mohamed Abdullah said...

Hi... I'm also confused between both. Edupristine conducts classroom sessions in Chennai but not imsproschool... For online course you've to be more focused and disciplined and given my work situation, spending time online would not be really a right option. The cost is almost double the online (ims) for a classroom programme (pristine)... Any suggestions on this would be appreciated... And also any reviews about both the options would be grateful

Anandh Sundar said...

Hi Mohamed, sorry for the late response, you may wish to check out educorporatebridge programs on www.udemy.com, they have a promotion running-any course for just $20 till 25th Aug 2013.I've not attended any classroom courses, but I've found the edupristine modelling course to be useful online. And if work is hectic, then you can still spend time on weekends imho.

darshan lokhande said...

Hi Aanand,i ma confused about financial modeling pgm from ims or edupristine...which one you prefer?

Zain Khan said...
This comment has been removed by the author.
Zain Khan said...

if you are looking to learn the topic in great details, Like I wanted to, then you must skip both IMS and Pristine both are useless. They follow case study based training. And after training they place you in companies at entry level jobs that are useless.

J P Financial and investment services has started providing training in Financial Modeling. They offer the most comprehensive program start with theoretical concept building then advance excel and finally go for financial modeling. i did here fee is expensive but worth it and i also got to do live valuation project with www.jpfis.com you can compare curriculam of all tee and decide http://www.jpfis.com/JPFIS/TRAIN/JPFIS_TRAIN.pdf

JPFIS also provides students whopping 40% discount

Manisha said...

If you are looking for various choices - then I guess you could also check out this course http://www.dezyre.com/Financial-Modelling/1

Also if in case you are looking for some advanced financial modeling then this course would be helpful http://www.dezyre.com/Advanced-Financial-Modelling-using-Excel/23

All these courses are taught by Investment Bankers :)

Finance Mela said...

There are many institutes who provides financial modeling course in metro cities. I have heard of Imarticus Learning Institute who provides comprehensive financial modeling course in the areas of Financial Markets, Entrepreneurship, Business Analytics and Personal Development.

For more information visit - http://imarticus.org/

RRB Advisors said...

RRB Advisors is a corporate financial consultancy firm engaged in providing insightful, transparent and value creative financial analytics solutions to Global Research Firms, SMEs and Startups. For more information visit our website:- financial modeling

ashishenigma said...

The professional course like financial modeling in Banking has become easier as you can learn from CF Institute.

Financial modeling course

Unknown said...

Hi,
Could you please advise which institution I should select for financial modelling ? Imarticus/Ims proschool/JPfis..pl plea advise..

eFinancial Models said...

Its really very useful blog. thanks for shearing with us.

excel financial model template
hospital financial model xls
Mining Valuation Model

Unknown said...

I learn financial analytics with Talentedge.
Talentedge is one of the best course marketplace that helps you to get trained on financial analytics.

Unknown said...

I would like to introduce one of the best financial analytics course by XLRI. This seems to be the best financial analytics course that helps you to make you strong in financial analytics using excel, R and Python.

christy said...

you can learn financial by means of consulting a professional. but the self-financial planning without experience will bring us a failure and loss in investment. So professional’s advisor is required before any indulging in any investment.
Best financial advisors in Chennai

Fullstack said...

Financial Modelling is versatile and Straightforward process, which has full of satisfaction for business. Our financial experts give you answer of every question and help to grow your business rapidly and fast.

CFI Education said...

I enjoyed reading your article. Please make more interesting topics like this on. I'll come back for more. Financial Modeling Course In India