Best way to learn Financial modeling

Steps to follow in Financial Modelling

Steps to follow in Financial Modelling

What are the general steps in a Financial Modelling process?

A standard financial model will include Historical financial statements, Historical analysis, assumptions, working schedule for projection of Revenue, expense, depreciation & amortization, tax, basic & diluted EPS, working capital, capital expense, shares & equity, debt & cash flow statement.

Most of the time when you are working in the company, you will only update new data in the model. Financials Models are once prepared and they are used regularly when the company provides new data in every quarter or when a company comes out with new corporate action like stock split, acquisition, huge borrowing or share issues, bonus and any other action which has significant impact on the cash flows or equity structure.

General Steps in financial modelling:

  1. Understand the objective of Financial Model.
  2. Understand the business of company, revenue drives and projection parameters
  3. Collect3 to 5 years historical financial statements from Annual report of company
  4. Clean the historical financial statements from non-recurring items and prepare a non-GAAP or pro forma financial statement before you do the historical analysis
  5. Based on company specific drivers and projection parameters, perform historical analysis for each item of Income statement, Balance sheet and cash flow statement.
  6. Based on management guidelines, historical analysis, research reports, market consensus and your objective and knowledge about the business take your assumptions for all items of IS, BS, CFS and SOCE.
  7. Based on assumptions & schedules, prepare a robust dynamic integrated Financial statement model of the company.
  8. Perform ratio analysis to test the strength and weakness of company health
  9. Financial model will take its final shape after scenario analysis. We have to test the changes in the results if our assumptions goes wrong.

 

The accuracy of Financial model will depend on the accuracy of assumptions. If assumptions are wrong then financial model will also give you incorrect cash flows, profits and asset & liabilities.

 

So accuracy of assumptions will depend on your knowledge of Business and availability of information and source of those information like research reports and databases and software like Thomson research and Bloomberg.

Financial model can be prepared in just 2 hours or it can take several weeks. It will depend on the

scale of business and availability of information about the company.

180 total views, 3 views today

Related Post

×
Get Free Excel, VBA & Financial Modelling Videos