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).