Financial Modelling course

Key Information

After doing MBA in finance or working as Finance professional in any organization you should know financial modeling which is used for business, in fact making a financial model is not difficult, but sometime company owner wants a perfect model which can be sometime complicated. There is no perfect model in financial modeling, some time even a simple model is better than a complicated model. As a financial consultant you should know during the merger and acquisition process, the appraisal need financial model to review the prospect of the company, there are few points one should remember while making a financial model for the company. Set the assumption of revenue, growth , expense, inflation, interest etc. Make profit and loss model, begin with sales assumption and fill up the expenses, raw material expenses or cost of goods sold, general expenses, interest and taxes etc. Set a balance sheet which is linked with your profit &Loss account, you can make balance sheet model by multiplying recent balance sheet with assumption. Make a cash flow statement after balance sheet it will be easy to make cash flow statement, calculate the cash flow or cash outflow from different balance sheet and income statement. As a financial consultant you can make the sensitivity of your model, set the scenario into bad, normal and good . Finally check links of balance sheet, income statement, and cash flow statements for simple financial model.

At IPA we have designed financial modeling course, this course has been designed keeping in view the practical aspects and problems faced by financial consultants under various practical situations. Financial modeling classes are held on weekends for working MBA finance students. During the financial modeling course we discuss various financial modeling pattern using advance excel formulas and their applications. After doing MBA in finance or working as Finance professional in any organization you should know financial modeling which is used for business, in fact making a financial model is not difficult, but sometime company owner wants a perfect model which can be sometime complicated. There is no perfect model in financial modeling, some time even a simple model is better than a complicated model. As a financial consultant you should know during the merger and acquisition process, the appraisal need financial model to review the prospect of the company, there are few points one should remember while making a financial model for the company. Set the assumption of revenue, growth , expense, inflation, interest etc. Make profit and loss model, begin with sales assumption and fill up the expenses, raw material expenses or cost of goods sold, general expenses, interest and taxes etc.

Who Can Join ?

  • Students after 12thGraudates
  • MBA ( HR)
  • Working professionals
  • MIS Executives
  • MIS Personals
  • Freelancers
  • 12th pass students (Commerce & non-commerce)
  • Any graduate (Arts, Commerce & Science)
  • Working persons
  • Pursuing CA, CPT, CS,

 

Back to Top