Scribd
Upload
10 views6 pages

Stell Authority India Limited Financial Overview

Stell Authority of India Limited's stock price fluctuated between Rs. 169.9 to Rs. 273.95 from 2013 to 2019, while dividends paid were stable at Rs. 2 per share except in 2017-18 when it was Rs. 0.8. The average annual return over 5 years was 1.628% with a standard deviation of 33.073%, implying future returns could range from -31.44% to 34.70%.

Uploaded by

vipul tuteja
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
10 views6 pages

Stell Authority India Limited Financial Overview

Stell Authority of India Limited's stock price fluctuated between Rs. 169.9 to Rs. 273.95 from 2013 to 2019, while dividends paid were stable at Rs. 2 per share except in 2017-18 when it was Rs. 0.8. The average annual return over 5 years was 1.628% with a standard deviation of 33.073%, implying future returns could range from -31.44% to 34.70%.

Uploaded by

vipul tuteja
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Stell Authority of india limited

1 Market end share price


Price Dividend DIVIDEND(%)

2013-14 242.8 2 100


2014-15 179 2 100
2015-16 169.9 2 100
2016-17 266.85 2 100
2017-18 273.95 0.8 40
2018-19 218.55 2 100

Historical Return

2013-14 0.000
2014-15 -26.277
2015-16 -5.084
2016-17 57.063
2017-18 2.661
2018-19 -20.223

Average Mean 1.628

Historical Return Standard Deviation

Risk Free Rate (182 days) 5.14


0.0514
Beta 1.94
Cost of Equity By CAPM Method

Expected Rate of return E (r)

1 Year E (r)

Years Price Dividend Dividend %


2012-13 289.2 2 100
2013-14 242.8 2 100
2014-15 179 2 100
2015-16 169.9 2 100
2016-17 266.85 2 100
2017-18 273.95 0.8 40
2018-19 218.55 2 100
average growth change

Expected value of share in 2019-18

D0 100% of 218.55 218.55

D1 D0*(1+g) 257.889

P0 D1/(COST OF Equity - G) 38.5532652981877

years 2019
4 finance cost 739.94
long term borrowing 1999.89

cost of debt 0.369990349469


cost of equity 6.869161034879
cost of capital 7.239151384348
YOY Return Average Annual Return

1.62808215071041 5 Years
-26.277
-5.084
57.063
2.661
-20.223

Mean + σ
Mean - σ
33.073

Risk Free Rate + Beta * ( Market return - Risk free Rate)

6.86916103487926

%change in dividend

0
0
0
0
-60
150
18
0.18
Holding Period (5 Years)
-9.98764415157
Average Annual Return
-1.99752883031

Maximum Return (1.628+33.073) 34.70102961822


Minimum Return (1.628-33.073) -31.4448653168

year return yoy

2014 18182.73
2015 18467.02 1.563516589643
2016 19186.7 3.897109549889
2017 20352.45 6.075823356804
2018 22198.5 9.070406756926
2019 24318.4 9.549744352096

average 6.031320121072
% of 218.55

23.86
6.56
30.42

You might also like