347 647 9001+1 714 797 8196Request a Call
Call Me

Financial Modeling for Tata Steel FPO

January 12, 2011
, , , , ,

Tata Steel, the seventh-largest player in the global steel industry,is attempting to take advantage of strong domestic demand from user industries by expanding its capacities here.

In India, the total steel output grew by 7.4% year-on-year during the first eleven months of the calendar year 2010,which is the fastest in BRIC countries, according to the global industry body. This pace of growth is expected to continue over the next few years. To part finance the expansion plan, Tata Steel is coming out with its FPO aggregating nearly 3,385 crores, which has generated enormous interest in the investor community (both retail and institutional).

This model is for our individual investors. Many potential investors want a financial model in MS Excel© which can help them in a thorough analysis of the company. Creating such models have always been a time-taking and daunting exercise.

Pristine has created an integrated valuation model based on publically available information. It is available as an open-source model for any user. Kindly note that this model is meant for informational purposes only.

The complete structure of the model and formulas, linkages etc. have been kept open to allow for any modification on the part of the user.

Pristine conducts extensive trainings for financial modeling in MS Excel©. These trainings are targeted towards investors/ professionals who are looking for a career in finance (Investment Banking, PE, Broking, Equity Research, etc.). At the completion of the trainings, the participants should be able to create models like these.

You can download the model -Tata Steel FPO Financial Model (updated model).

Instructions -

  • Right click on the link provided and select "Save Link As"
  • Save the file in your desired folder
  • The file is a .zip archive, you will have to extract the excel sheet using a program like 7-zip/Winzip/Winrar


About the Author

Anil Bains has developed end-to-end financial models for Real Estate, FMCG, Power, Roads and Telecom Sector and released them as Open Source. He has extensive experience in the financial services, analytics and training domain. Apart from making Financial Modeling simple and accessible for the masses, Anil loves playing volleyball and has a mean spike.


Global Association of Risk Professionals, Inc. (GARP®) does not endorse, promote, review or warrant the accuracy of the products or services offered by EduPristine for FRM® related information, nor does it endorse any pass rates claimed by the provider. Further, GARP® is not responsible for any fees or costs paid by the user to EduPristine nor is GARP® responsible for any fees or costs of any person or entity providing any services to EduPristine Study Program. FRM®, GARP® and Global Association of Risk Professionals®, are trademarks owned by the Global Association of Risk Professionals, Inc

CFA Institute does not endorse, promote, or warrant the accuracy or quality of the products or services offered by EduPristine. CFA Institute, CFA®, Claritas® and Chartered Financial Analyst® are trademarks owned by CFA Institute.

Utmost care has been taken to ensure that there is no copyright violation or infringement in any of our content. Still, in case you feel that there is any copyright violation of any kind please send a mail to and we will rectify it.

Popular Blogs: Whatsapp Revenue Model | CFA vs CPA | CMA vs CPA | ACCA vs CPA | CFA vs FRM

Post ID = 6011