Tata Steel Limited (TATASTEEL.NS) Simple Excess Return Model - Discounting Cash Flows
TATASTEEL.NS
Tata Steel Limited
TATASTEEL.NS (NSE)

Estimated Value

INR

Market Price INR

* Values are not guaranteed, please do your own
research before making investment decisions.

Simple Excess Return Model

Used to estimate the value of companies that have reached maturity and earn stable excess returns with little to no high growth chance. Excess Return models are better suited to calculate the intrinsic value of a financial company than an enterprise valuation model (such as the Discounted Free Cash Flow Model).

See our GitHub Documentation

Interactive Assumptions

Discount Rate

Discount Rate

Discount Rate = Cost of Equity = Risk Free Rate + Beta * Market Premium

The cost of equity is the theoretical rate of return that an equity investment should generate. It is calculated using the CAPM formula.

Read More

↳ Beta

Beta

Beta is a value that measures the price fluctuations (volatility) of a stock with respect to fluctuations in the overall stock market.

↳ Risk Free Rate

Risk-Free Rate

The risk-free rate represents the interest an investor would expect from an absolutely risk-free investment over a specified period of time. By default, it is equal to the current yield of the U.S. 10 Year Treasury Bond.

↳ Market Premium

Market Premium

Market risk premium represents the excess returns over the risk-free rate that investors expect for taking on the incremental risks connected to the equities market.

Return On Equity

Return on Equity

Return On Equity (ROE) is used to estimate the Earnings Per Share (EPS) expressed as a percentage of Book Value.

Growth In Perpetuity

Growth in Perpetuity

The rate at which the company's free cash flow is assumed to grow in perpetuity. By default, this is equal to the yield of the U.S. 10 Year Treasury Bond.

Historical Years

Historical Years

The number of historical years used to calculate averages for historical data.

Results

Estimated Value 84.72 INR
Book value of equity invested 76.22 INR
Next year's estimated book value 74.86 INR
Present value of future excess returns 8.5 INR
Excess Return per share 0.63 INR
Cost of Equity (the discount rate) 9.91%
Average historical Return on Equity 10.77%
Average historical Payout Ratio 23.06%
Payout Ratio used 76.79%
Risk Free Rate of the 10 Year U.S. Treasury Note 4.18%

Historical and Forecasted Data

Monetary values in INR

Monetary values in INR

amounts except #

2025
Mar 31
LTM
Jan 14
2026
Mar 31
2027
Mar 31
2028
Mar 31
2029
Mar 31
2030
Mar 31
Beginning Book Value 75.02 73.03 73.03 74.86 76.73 78.65 80.61
Ending Book Value 73.03 76.22 74.86 76.73 78.65 80.61 82.63
EPS 2.74 5.46 7.87 8.06 8.26 8.47 8.68
Return on Equity 3.72% 7.47% 10.77% 10.77% 10.77% 10.77% 10.77%
Dividend per Share 3.6 3.6 6.04 6.19 6.35 6.5 6.67
Retained Earnings -0.86 1.86 1.83 1.87 1.92 1.97 2.02
Equity Cost per Share 7.43 7.24 7.24 7.42 7.6 7.79 7.99
Cost of Equity 9.91% 9.91% 9.91% 9.91% 9.91% 9.91% 9.91%
Excess Return -4.69 -1.78 0.63 0.645 0.661 0.678 0.695

Monetary values in INR

amounts except #

Average LTM
Jan 14
2025
Mar 31
2024
Mar 31
2023
Mar 31
2022
Mar 31
2021
Mar 31
2020
Mar 31
2019
Mar 31
2018
Mar 31
2017
Mar 31
2016
Mar 31
Net Income 75,255 68,069 34,205 -44,374 87,604 401,539 74,902 15,565 102,183 134,343 -42,408 -3,828
Total Equity 765,347 949,473 911,696 920,358 1,030,821 1,144,430 742,388 735,763 689,251 608,706 378,193 307,738
Return on Equity 10.77% 7.47% 3.72% -4.3% 7.66% 54.09% 10.18% 2.26% 16.79% 35.52% -13.78% -1.14%
Dividends Paid to Common Shareholders 29,801 44,845 44,941 44,166 43,956 61,615 30,204 11,583 15,057 11,583 11,038 8,826
Payout Ratio 23.06% 65.93% 131.4% -99.45% 50.21% 15.34% 39.18% 84.03% 14.74% 7.7% -26.47% -28.97%
Shares Outstanding 11,954 12,457 12,484 12,268 12,210 12,081 12,081 11,583 11,583 11,583 11,583 11,583
EPS 6.19 5.46 2.74 -3.62 7.17 33.24 6.38 1.19 8.82 12.98 -3.6 -2.63
Dividend per Share 2.46 3.6 3.6 3.6 3.6 5.1 2.5 1 1.3 1 0.953 0.762
Book Value 63.61 76.22 73.03 75.02 84.42 94.73 61.45 63.52 59.51 52.55 32.65 26.57
discounting cash flows home logo

Discounting Cash Flows

Are you finding our services helpful? Review us on trustpilot logo Trustpilot
Have a question? Contact us
Want to become our sponsor?
Check out our Affiliate Program