course bg
EduPristine>Blog>Financial Modeling for Tata Steel FPO

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 Author

avatar EduPristine

Trusted by Fortune 500 Companies and 10,000 Students from 40+ countries across the globe, it is one of the leading International Training providers for Finance Certifications like FRM®, CFA®, PRM®, Business Analytics, HR Analytics, Financial Modeling, and Operational Risk Modeling. EduPristine has conducted more than 500,000 man-hours of quality training in finance.

Comments

Interested in this topic?

Our counsellors will get in touch with you with more information about this topic.

* Mandatory Field

`````````````````````````````````````````````````` Post ID = 6011