9 PRINCIPLES MULTIBAG
CMP STOCK SELECTION
₹ 182.28 FINANCIALS
MIDCAP SHANPSHOTS
Company Name TATA STEEL
Current Price (INR) ₹ 182.28
Multibagger List
No. of Shares (crores) 1248
Income Statement Market Cap (crores) ₹ 227,512
(Yearly) TTM Net Profit (crores) ₹ -4,437
Income Statement
(Quarterly) P/E Ratio (51.3x)
Balance Sheet TTM Operating Profit Mar 9.61%
Latest FY ROAE -5.03%
Cash Flow Statement
Latest FY ROACE 3.47%
Ratio Analysis Debt to Equity Ratio 0.95x
Free Cash Flows (FCF) ₹ 5,083
Debt to FCF 5,083.1x
VERSION
PLES MULTIBAGGER
2.100
OCK SELECTION
TATA STEEL LTD
₹ 182.28 9 PRINCIPLES
1248 CHECKLIST
Revenue Growth > 10% i YES 👌
₹ 227,512 Net Profit Growth > 12% No 👎
₹ -4,437 P/E Ratio < 20x YES 👌
(51.3x) ROE Ratio > 15% NO 👎
9.61% ROCE Ratio > 14% NO 👎
-5.03% Market Cap MIDCAP 😓
3.47% Debt to Equity Ratio < 1 YES 👌
0.95x Operating cash Flow in 5 Positive 👌
₹ 5,083 Free Cash Flow in 5 Year Positive 👌
5,083.1x
iNCOM
COMPANY NAME
INR (in crores) ###
Sales ###
Operating Profit 3,409
Multibagger List
Other Income 5,994
Income Statement EBITDA 9,403
Interest ###
(Yearly)
Income Statement Depreciation ###
(Quarterly) Profit before tax (PBT) ###
Balance Sheet Tax ###
Profit after tax (PAT) / Net Prof ###
Cash Flow Statement
Adjusted Equity Shares (in crores) 1,126.6
Ratio Analysis
Price 30
Operating Profit Margin (OPM) 2.4%
Net Profit Margin (NPM) % n/m
Tax Payout % ###
Dividend Payout % ###
Interest Coverage Ratio (x) 0.7x
Earnings Per Share (EPS) (3.5)
PE Ratio (x) (8.6x)
Common Sizing Expenses
Year >> ###
Sales 100%
Raw material Expenses 39%
Change in Inventory 1%
Power and Fuel Cost 5%
Other Mfr. Exp 15%
Employee Cost 15%
Selling and Admin Expenses 11%
Other Expenses 11%
Operating Profit Margin (OPM) 2.4%
iNCOME sTATEMENT (yEARLY)
TATA STEEL LTD
### Mar-17 Mar-18 Mar-19 ### ### ### ### Mar-24
### 112,299 123,249 157,669 ### ### ### ### ###
(625) 13,144 21,433 29,318 17,463 30,504 63,490 32,300 22,248
10,346 (3,789) 10,898 1,524 ### 180 1,300 1,569 ###
9,721 9,355 32,332 30,843 14,579 30,684 64,790 33,869 16,243
### (5,072) (5,455) (7,660) ### ### ### ### ###
### (5,673) (5,742) (7,342) ### ### ### ### ###
193 (1,391) 21,135 15,841 ### 13,844 50,227 18,235 ###
(690) (2,778) (3,392) (6,718) 2,568 ### ### ### ###
(497) (4,169) 17,743 9,122 1,174 8,190 41,749 8,075 ###
1,126.6 1,126.6 1,126.5 1,126.5 1,126.5 1,196.6 1,221.3 1,222.2 1,248.4
30 46 57 52 27 81 131 105 156
n/m 11.7% 17.4% 18.6% 12.5% 19.5% 26.0% 13.3% 9.7%
n/m n/m 14.4% 5.8% 0.8% 5.2% 17.1% 3.3% n/m
### ### 16.1% 42.4% n/m 40.8% 16.9% 55.7% ###
### ### 8.5% 14.6% 73.6% 40.0% 15.5% 50.2% ###
1.0x 0.7x 4.9x 3.1x 0.8x 2.8x 10.2x 3.9x 0.8x
(0.4) (3.7) 15.8 8.1 1.0 6.8 34.2 6.6 (3.9)
(69.0x) (12.4x) 3.6x 6.4x 25.9x 11.9x 3.8x 15.8x ###
### Mar-17 Mar-18 Mar-19 ### ### ### ### Mar-24
100% 100% 100% 100% 100% 100% 100% 100% 100%
38% 39% 37% 39% 42% 35% 37% 48% 43%
2% (4%) 0% (0%) (0%) 1% (3%) (1%) 2%
5% 5% 4% 3% 4% 4% 3% 4% 0%
16% 14% 14% 13% 15% 13% 12% 15% 0%
17% 15% 14% 12% 13% 13% 10% 9% 11%
13% 12% 12% 11% 11% 11% 11% 10% 0%
10% 7% 2% 4% 3% 4% 4% 2% 35%
### 11.7% 17.4% 18.6% 12.5% 19.5% 26.0% 13.3% 9.7%
VERSION
2.100
TREND ANALYSIS
TTM 9 YEARS 5 YEARS 3 YEARS
229,171 9% 10% (2%)
22,035 ### 5% (29%)
### 16% (267%)
6% 2% (37%)
(1,147) ### (4%) (128%) 0.89 1.16
0.82 1.07
(4,437) 29% (233%) (149%)
1,248.4
20% 42% 6%
9.6%
n/m
(3.6) 28% (230%) (149%)
1.51548452
2.29669332
Mar-18 FY17
Mar-19 FY18
Mar-20 FY19
Mar-21 FY20
Mar-22 FY21
Mar-23 FY22
Mar-24 FY23
Mar-19 FY18
Mar-20 FY19
Mar-21 FY20
Mar-22 FY21
Mar-23 FY22
Mar-24 FY23
iNCOME sTA
COMPANY NAME >>
INR (in crores) Dec-21
Sales 60,783
Operating Profit 15,894
Multibagger List Other Income 48
EBITDA 15,942
Income Statement Interest ###
(Yearly)
Income Statement Depreciation ###
(Quarterly) Profit before tax (PBT) 12,166
Balance Sheet Tax ###
Profit after tax (PAT) / Net Pro 9,598
Cash Flow
Statement
Ratio Analysis
Operating Profit Margin (OPM 26.1%
Net Profit Margin (NPM) % 15.8%
Tax Payout % 21.1%
Interest Coverage Ratio (x) 8.9x
iNCOME sTATEMENT (QUARTELY)
TATA STEEL LTD
### ### ### Dec-22 Mar-23 ### ### ### Mar-24
69,324 63,430 59,878 57,084 62,962 59,490 55,682 55,312 58,687
15,030 14,973 6,060 4,048 7,219 4,903 4,268 6,264 6,601
177 388 412 491 277 1,190 ### (33) (382)
### ### 6,472 4,539 7,497 6,093 ### 6,231 6,219
### ### ### (1,768) (1,794) ### ### ### ###
### ### ### (2,368) (2,382) ### ### ### ###
### ### 2,605 403 3,321 1,855 ### 1,928 1,809
### ### ### (2,905) (1,755) ### 228 ### ###
9,835 7,714 1,297 ### 1,566 525 ### 522 555
21.7% 23.6% 10.1% 7.1% 11.5% 8.2% 7.7% 11.3% 11.2%
14.2% 12.2% 2.2% n/m 2.5% 0.9% n/m 0.9% 0.9%
17.1% 35.2% 50.2% ### 52.8% 71.7% n/m 72.9% 69.3%
11.8x 10.8x 2.7x 1.2x 2.9x 2.0x ### 2.0x 2.0x
VERSION 2.100
TREND ANALYSIS
QoQ (Sequential)QoQ (Yearly)
6% (7%)
5% (9%)
1062% (238%)
(0%) (17%)
(6%) (46%)
6% (65%)
Sep-22 2Q21 Sep-23 2Q23
Dec-22 3Q22 Dec-22 3Q22
Mar-23 4Q22 Mar-23 4Q22
Jun-23 1Q23 Jun-23 1Q23
Sep-23 2Q23 Sep-23 2Q23
Mar-24 4Q23 Mar-24 4Q23
Balance Sheet
COMPANY NAM TATA STEEL LTD
INR (in crores) 42094 42460
Equity Share C 971.41 970.24
Reserves 30378 42762.31
Borrowings 80701.29 81986.93
Other Liabilitie 47058.6 51164.51
Total Liabilitie 159109.3 176883.99
Fixed Assets ( 68100.33 72199.76
Capital Work i 28678.12 35996.09
Investments 3455.05 10713.71
Other Assets 58875.8 57974.43
Total Assets 159109.3 176883.99
Receivables 13309.87 12066.22
Inventory 25149.91 20013.33
Cash & Bank 8749.94 6186.34
Working Capita 11817.2 6809.92
Capital Emplo 112050.7 125719.48
Total Equity 31349.41 43732.55
Net Fixed Asset Turnover 1.45352323
Receivables Days 45.41900792
Inventory Turnover 4.515385521
Debt To Equity 2.574252275 1.874734723
Return on average Equity (R -0.01324126
Return on average Capital E 0.037130644
Common Size Balance Sheet
Year 42094 42460
Equity Share C 0.0061053 0.005485177
Reserves 0.190925358 0.241753423
Borrowings 0.507206618 0.463506788
Other Liabilitie 0.295762724 0.289254613
Total Liabilitie 1 1
Fixed Assets ( 0.428009739 0.408175777
Capital Work i 0.180241633 0.20350112
Investments 0.021714947 0.060569133
Other Assets 0.370033681 0.32775397
Total Assets 1 1
Other items as % of Total Assets
Receivables 0.08365237 0.068215444
Page 16
Balance Sheet
Inventory 0.158066876 0.113143818
Cash & Bank 0.054993266 0.034973996
Page 17
Balance Sheet
42825 43190 43555 43921 44286 44651 45016
970.24 1144.95 1144.94 1144.95 1197.61 1221.21 1221.24
36849.08 59725.67 67780.14 72431.35 73041.16 113221.83 101860.86
83014.49 92127.08 100802.91 116328.2 88501.41 75561.35 84893.05
51613.56 55724.44 63045.45 59244.62 81169.01 92417.28 97420.63
172447.37 208722.14 232773.44 249149.12 243909.19 282421.67 285395.78
92006.55 96104.89 124441.91 134550.66 135775.18 133287.83 146621.46
15784.13 16614.41 18641.21 19496.83 19007.4 22045.55 31213.02
12457.12 17899.47 5738.17 6285.18 10681.93 13139.85 8410.31
52199.57 78103.37 83952.15 88816.45 78444.68 113948.44 99150.99
172447.37 208722.14 232773.44 249149.12 243909.19 282421.67 285395.78
11586.82 12415.52 11811 7884.91 9539.84 12246.43 8257.24
24803.82 28331.04 31656.1 31068.72 33276.38 48824.39 54415.33
4921.05 7937.85 3341.37 8054.72 5782.18 15898.93 13357.26
586.01 22378.93 20906.7 29571.83 -2724.33 21531.16 1730.36
120833.81 152997.7 169727.99 189904.5 162740.18 190004.39 187975.15
37819.32 60870.62 68925.08 73576.3 74238.77 114443.04 103082.1
1.367784466 1.310383568 1.42980075 1.079696224 1.156339179 1.813398059 1.738796808
38.43902132 35.54125845 28.04191173 25.70869474 20.34635503 16.29778571 15.37652933
5.011448519 4.639103971 5.256759699 4.458096492 4.85799789 5.942920389 4.714322937
2.195028626 1.513490088 1.462499717 1.581055313 1.192118485 0.660252908 0.823547929
-0.10223113 0.359567145 0.140561975 0.016472121 0.1108113 0.442536777 0.07424751
0.029864862 0.194206284 0.145638855 0.03413874 0.121654465 0.315747284 0.129815598
42825 43190 43555 43921 44286 44651 45016
0.005626296 0.005485523 0.004918688 0.004595441 0.004910065 0.004324066 0.00427911
0.21368305 0.286149184 0.291185025 0.290714854 0.299460467 0.400896397 0.356910884
0.481390293 0.441386237 0.433051597 0.46690191 0.362845738 0.26754799 0.297457271
0.29930036 0.266979056 0.270844689 0.237787796 0.33278373 0.327231547 0.341352735
1 1 1 1 1 1 1
0.533534086 0.460444158 0.53460528 0.540040679 0.55666283 0.471946186 0.513747821
0.091530129 0.079600612 0.080083063 0.078253658 0.077928183 0.078058989 0.10936749
0.072237228 0.085757409 0.024651309 0.025226579 0.043794701 0.046525644 0.029468936
0.302698557 0.374197821 0.360660349 0.356479084 0.321614286 0.403469181 0.347415754
1 1 1 1 1 1 1
0.067190471 0.059483484 0.050740325 0.031647352 0.039112261 0.043362218 0.028932593
Page 18
Balance Sheet
0.143834145 0.135735672 0.135995327 0.124699297 0.136429382 0.172877634 0.190666204
0.028536533 0.038030704 0.014354602 0.032328912 0.023706282 0.056295007 0.046802584
Page 19
Balance Sheet
TREND ANALYSIS
45382 9 5 3
1247.44 1140.313333 1206.49 1229.963333
90788.32 73162.30222 90268.704 101957.0033
87082.12 90033.06 90473.226 82512.17333
94305.62 71789.45778 84911.432 94714.51
273423.5 236125.1333 266859.852 280413.65
149799.72 120531.9956 140006.97 143236.3367
33370.19 23574.31444 25026.598 28876.25333
6257.57 10175.92333 8954.968 9269.243333
83996.02 81842.9 92871.316 99031.81667
273423.5 236125.1333 266859.852 280413.65
6263.53 10230.16778 8838.39 8922.4
49157.51 35727.40222 43348.466 50799.07667
8677.72 8239.713333 10354.162 12644.63667
-10309.6 10053.44222 7959.884 4317.306667
179117.88 164335.6756 181948.42 185699.14
92035.76 74302.61556 91475.194 103186.9667
1.546251047 1.432885926 1.466896264 1.699481971
11.56360564 26.30379665 17.85859409 14.41264023
4.42530648 4.869037989 4.879728838 5.027516602
0.946177008 1.360989422 1.040630329 0.809992615
-0.05032456 0.108711097 0.11874863 0.155486576
0.034653505 0.115872249 0.127201918 0.160072129
23121.16 19897.26
45382
0.0045623
0.332042857
0.31848806
0.344906784
1
0.547867027
0.122045801
0.022885999
0.307201173
1
0.022907797
Page 20
Balance Sheet
0.179785242
0.031737287
Page 21
Balance Sheet
43190 FY17
43555 FY18 43555
43921 FY19 43921
44286 FY20 44286
44651 FY21 44651
45016 FY22 45016
45382 FY23 45382
Page 22
Balance Sheet
FY18
FY19
FY20
FY21
FY22
FY23
Page 23
Cashflow Statement
COMPANY NATATA STEEL LTD
INR (in crores) 42094
Cash from Oper 11879.77
Cash from Inves -9021.13
Cash from Fina -2617.19
Net Cash Flow 241.45
Cash & Equival 8749.94
Profit After Ta -3955.5
Cash from Oper 11879.77
CFO/PAT (atle -3.00335482
CAPEX
Free Cash Flows (FCF)
Re-investment (Capex/CFO)
FCF/CFO
9
Cash from Oper22944.35444
CAPEX 17382.98
% Capex 0.757614691
FCF (Weighted)
Page 24
Cashflow Statement
ATA STEEL LTD
42460 42825 43190 43555 43921 44286 44651
11455.35 10824.36 8023.39 25335.95 20168.72 44326.68 44380.99
-8794.31 -9489.65 -11730.31 -29176.45 -14012.06 -9437.27 -10905.02
-4729.12 -2579.36 6639.94 -672.7 -1694.62 -37089.67 -23401.09
-2068.08 -1244.65 2933.02 -4513.2 4462.04 -2200.26 10074.88
6186.34 4921.05 7937.85 3341.37 8054.72 5782.18 15898.93
-497.09 -4168.57 17742.83 9122.17 1173.65 8189.79 41749.32
11455.35 10824.36 8023.39 25335.95 20168.72 44326.68 44380.99
-23.0448209 -2.59666025 0.452204637 2.777403841 17.18461211 5.412431821 1.063035039
16723.75 5267.71 10670.32 37705.65 19405.1 9968.73 9651.67
-5268.4 5556.65 -2646.93 -12369.7 763.62 34357.95 34729.32
1.45990738 0.486653252 1.3299017 1.488227203 0.9621384 0.224892322 0.217473067
5 3
30172.028 28788.24667
17215.878 18901.85333
0.570590681 0.656582304
4945.353333
Page 25
Cashflow Statement
TREND ANALYSIS
45016 45382 TOTAL 9 5 3
21683.08 20300.67 218378.96 0.065642013 0.001305051 -0.22950269
-18179.45 -14251.44 -134997.09
-6980.69 -11096.99 -84221.49
-3477.06 -5047.76 -839.62
13357.26 8677.72
8075.35 -4909.61 72522.34 0.289770505 -1.88346585 -1.4899283
21683.08 20300.67 218378.96 0.065642013 -0.04334656 -0.22950269
2.685094764 -4.13488444 3.011195723
31836.3 15217.59
-10153.22 5083.08 50052.37 -1.99602909 0.460999038 -0.47300048
1.468255432 0.749610235
0.242385309
Page 26
Cashflow Statement
43190 FY17 43190
43555 FY18 43555
43921 FY19 43921
44286 FY20 44286
44651 FY21 44651
45016 FY22 45016
45382 FY23 45382
Page 27
Cashflow Statement
FY17
FY18
FY19
FY20
FY21
FY22
FY23
Page 28
COMPANY NAME
INR (in crores)
Operating Profit Margin (OPM) %
Net Profit Margin (NPM) %
Tax Payout %
Multibagger List Dividend Payout %
Interest Coverage Ratio (x)
Income Statement Earnings Per Share (EPS)
(Yearly) PE Ratio (x)
Income Statement
(Quarterly)
Net Fixed Asset Turnover
Balance Sheet Receivables Days
Inventory Turnover
Cash Flow
Debt To Equity
Statement
Return on average Equity (RoAE)
Ratio Analysis
Return on average Capital Employed
CFO/PAT (atleast 80%)
rATIO aNALYSIS
TATA STEEL LTD
Mar-15 Mar-16 Mar-17 Mar-18 Mar-19 Mar-20 Mar-21
2.4% n/m 11.7% 17.4% 18.6% 12.5% 19.5%
n/m n/m n/m 14.4% 5.8% 0.8% 5.2%
(185.0%) 357.7% ### 16.1% 42.4% n/m 40.8%
(19.8%) ### ### 8.5% 14.6% 73.6% 40.0%
0.7x 1.0x 0.7x 4.9x 3.1x 0.8x 2.8x
(3.51) (0.44) (3.70) 15.75 8.10 1.04 6.84
(8.6x) (69.0x) (12.4x) 3.6x 6.4x 25.9x 11.9x
1.5x 1.4x 1.3x 1.4x 1.1x 1.2x
45 38 36 28 26 20
4.5x 5.0x 4.6x 5.3x 4.5x 4.9x
2.6x 1.9x 2.2x 1.5x 1.5x 1.6x 1.2x
y (RoAE) (1.3%) ### 36.0% 14.1% 1.6% 11.1%
al Employed 3.7% 3.0% 19.4% 14.6% 3.4% 12.2%
(300%) ### (260%) 45% 278% 1718% 541%
AVG 5
ROCE 11.9%
ROE 12.7%
VERSION 2.100
Mar-22 Mar-23 Mar-24 TTM
26.0% 13.3% 9.7% 9.6%
17.1% 3.3% n/m n/m
16.9% 55.7% (328.0%)
15.5% 50.2% (101.2%)
10.2x 3.9x 0.8x
34.18 6.61 (3.93)
3.8x 15.8x (39.6x)
1.8x 1.7x 1.5x
16 15 12
5.9x 4.7x 4.4x
0.7x 0.8x 0.9x
44.3% 7.4% (5.0%)
31.6% 13.0% 3.5%
106% 269% (413%)
Mar-22 FY21 FY21 Mar-22 FY21
Mar-23 FY22 FY22 Mar-23 FY22
Mar-24 FY23 FY23 Mar-24 FY23
Data Sheet
COMPANY TATA STEEL LTD
LATEST VE 2.10 PLEASE DO NOT MAKE ANY CHANGES TO THIS SHEET
CURRENT V 2.10
META
Number of 1,248.14
Face Value 1.00
Current Pri 182.28
Market Capi ###
PROFIT & LOSS
Report Dat ### ### ### ### ### ###
Sales ### ### ### ### ### ###
Raw Materia ### ### ### ### ### ###
Change in -1,122.18 -1,925.19 4,538.13 -99.31 96.71 565.24
Power and 6,845.38 4,993.89 5,220.83 4,440.43 5,316.56 5,319.92
Other Mfr. ### ### ### ### ### ###
Employee C ### ### ### ### ### ###
Selling and ### ### ### ### ### ###
Other Expe ### ### 7,806.38 2,681.96 5,843.58 4,193.58
Other Inco 5,994.38 ### -3,789.11 ### 1,524.31 -2,883.63
Depreciatio 5,943.60 5,306.35 5,672.88 5,741.70 7,341.83 8,440.73
Interest 4,847.75 4,221.41 5,072.20 5,454.74 7,660.10 7,533.46
Profit befor -1,388.09 192.87 -1,390.56 ### ### -1,394.76
Tax 2,567.41 689.96 2,778.01 3,392.33 6,718.43 -2,568.41
Net profit -3,925.52 -382.78 -4,240.80 ### ### 1,556.54
Dividend A 777.13 776.19 970.24 1,144.95 1,488.42 1,144.95
Quarters
Report Dat ### ### ### ### ### ###
Sales ### ### ### ### ### ###
Expenses ### ### ### ### ### ###
Other Inco 48.49 177.26 388.36 411.69 491.43 277.38
Depreciatio 2,244.09 2,243.39 2,236.79 2,347.82 2,368.38 2,382.21
Interest 1,532.49 1,098.51 1,218.11 1,519.07 1,767.92 1,793.60
Profit befor ### ### ### 2,605.12 402.97 3,320.77
Tax 2,567.42 2,029.85 4,192.26 1,308.06 2,904.92 1,754.53
Net profit 9,572.67 9,756.20 7,764.96 1,514.42 -2,223.84 1,704.86
Page 33
Data Sheet
Operating P ### ### ### 6,060.32 4,047.84 7,219.20
BALANCE SHEET
Report Dat ### ### ### ### ### ###
Equity Shar 971.41 970.24 970.24 1,144.95 1,144.94 1,144.95
Reserves ### ### ### ### ### ###
Borrowings ### ### ### ### ### ###
Other Liabil ### ### ### ### ### ###
Total ### ### ### ### ### ###
Net Block ### ### ### ### ### ###
Capital Wor ### ### ### ### ### ###
Investment 3,455.05 ### ### ### 5,738.17 6,285.18
Other Asset ### ### ### ### ### ###
Total ### ### ### ### ### ###
Receivables ### ### ### ### ### 7,884.91
Inventory ### ### ### ### ### ###
Cash & Ban 8,749.94 6,186.34 4,921.05 7,937.85 3,341.37 8,054.72
No. of Equi ### ### ### ### ### ###
New Bonus Shares
Face value 10.00 10.00 10.00 10.00 10.00 10.00
CASH FLOW:
Report Dat ### ### ### ### ### ###
Cash from O ### ### ### 8,023.39 ### ###
Cash from I -9,021.13 -8,794.31 -9,489.65 ### ### ###
Cash from F-2,617.19 -4,729.12 -2,579.36 6,639.94 -672.70 -1,694.62
Net Cash F 241.45 -2,068.08 -1,244.65 2,933.02 -4,513.20 4,462.04
PRICE: 30.18 30.46 45.99 57.11 52.10 26.96
DERIVED:
Adjusted Eq 1,126.62 1,126.62 1,126.62 1,126.48 1,126.49 1,126.49
Page 34
Data Sheet
ANY CHANGES TO THIS SHEET
### ### ### ###
### ### ### ###
### ### ### ###
-1,516.77 7,597.87 3,358.89 -4,409.35
5,788.48 8,028.29 9,526.91
### ### ###
### ### ### ###
### ### ###
5,483.63 9,418.36 3,769.15 ###
179.78 1,299.99 1,568.86 -6,005.23
9,233.64 9,100.87 9,335.20 9,882.16
7,606.71 5,462.20 6,298.70 7,507.57
### ### ### -1,147.04
5,653.90 8,477.55 ### 3,762.57
7,490.22 ### 8,760.40 -4,437.44
2,994.02 6,228.17 4,396.46 4,490.78
### ### ### ###
### ### ### ###
### ### ### ###
1,190.24 -6,567.77 -32.84 -381.56
2,412.32 2,479.85 2,422.04 2,567.95
1,825.15 1,959.39 1,880.78 1,842.25
1,855.37 -6,739.19 1,927.91 1,808.87
1,330.52 -228.03 1,405.77 1,254.31
633.95 -6,196.24 513.37 611.48
Page 35
Data Sheet
4,902.60 4,267.82 6,263.57 6,600.63
### ### ### ###
1,197.61 1,221.21 1,221.24 1,247.44
### ### ### ###
### ### ### ###
### ### ### ###
### ### ### ###
### ### ### ###
### ### ### ###
### ### 8,410.31 6,257.57
### ### ### ###
### ### ### ###
9,539.84 ### 8,257.24 6,263.53
### ### ### ###
5,782.18 ### ### 8,677.72
### ### ###
10.00 10.00 1.00 1.00
### ### ### ###
### ### ### ###
-9,437.27 ### ### ###
### ### -6,980.69 ###
-2,200.26 ### -3,477.06 -5,047.76
81.19 130.72 104.50 155.85
1,196.59 1,221.30 1,222.15 1,248.35
Page 36
How to use it?
OVERVIEW
You can customize this workbook as you want.
You can add custom formating, add conditional formating, add your own formulas… do ANYTHING.
Please don't edit the "Data Sheet" only.
After customization, you can upload this back on Screener.
Upload on: [Link]
Download your customized workbooks now onwards.
Now whenever you will "Export to excel" from Screener, it will export your customized file.
TESTING:
This is a testing feature currently.
You can report any formula errors on the worksheet at: [Link]@[Link]
… do ANYTHING.
[Link]
Money Loves Speed Excel Analysis - Versio
2.100
HOW TO USE THIS SPREADSHEET
Step 1 - This spreadsheet works only on [Link]. The first step is to create a free account here
[Link]
Step 2 - After creating your account, while you are logged in to [Link] website, visit this page
[Link] - and upload this excel file.
Step 3 - Visit the home page of [Link] and choose a company of your choice. Once you do that, you wi
details of your chosen company. Scroll down and come to the first financial statement table called "Quarterly
Results" and click on "View Consolidated". Now, all data you see for this company will be consolidated.
Step 4 - Scroll back to the top of the page, and you will see a button "Export to Excel" on the right side. Clic
button and the company's financial data will be exported in an excel file in the exact format as "Investors De
Stock Valuation Excel Ver. 2.0". Now onwards, any excel you export for any company on [Link] will be
downloaded in this very format.
Step 5 - Email me your love and testimonial for helping you with this excel. :-)
READ THESE INSTRUCTIONS BEFORE YOU START
1. DON’T change anything on "Data Sheet" tab - this is dynamic template based
which company data we need is being pulled through [Link] upload
2. If you see data is not flowing when you download excel from [Link], just
on "Enable Editing" on the top of your excel workbook
Data Sheet underlying data is from [Link]
IMPORTANT INSTRUCTIONS
1. Ensure that the company whose data you are downloading has numbers at least starting from FY08 (Marc
This is because if, for instance, the company has financials starting from, say, FY10, you will see incorrect da
FY08 and FY09 (which will be of Ambuja Cement on whose financials I have created this Analysis sheet forma
2. All financial data of your chosen company will be automatically updated in the sheet you download, excep
and Bank" (Balance Sheet sheet) and Capex (Cash Flow sheet) figures, which you must update manually from
company's annual reports. Don’t forget to make these changes as these numbers are key inputs in a few Intr
Value calculations.
3. You may update the sheet and add your own analysis, formulae etc. and then upload again to [Link]
using the Step 2 mentioned above. But DON'T touch the sheet titled "Data Sheet" because this will cause err
your future downloads.
4. DON’T touch any cell except the black ones, where you are required to update the numbers manually from
Reports (just Cash and Capex numbers) or where you may change the growth assumptions etc.
4. I have added Comments and Instructions wherever necessary so as to explain the concepts. Read those ca
before working on the sheet.
5. This sheet is not a replacement of the work required to read annual reports as part of the analysis process
please do that along with working on this sheet. You may sometime find some discrepancy in numbers (thou
but you will know this only when you read annual reports.
6. I could not find a bug/errors in this spreadsheet, but if you notice some, please email me at -
connectl@[Link] and I will try to fix the same and update the sheet
7. I will keep on updating the sheet from time to time and will update the same on the website. I invite you t
your feedback and thoughts on the sheet so that we can make it better together.
8. This excel won't work for banking and financial services companies.