Identify Stocks

We expect that following EXCEL SHEETS which contains financials of most of the listed companies, should help people in identifying the stocks.

Profit & Loss Account Items
1 Net_Sales Excel Data
2 Operating_Costs Excel Data
3 Tot_Raw_Material Excel Data
4 Other_Mfg_Exp Excel Data
5 Employee Excel Data
6 Power Excel Data
7 S&D Excel Data
8 Operating_Profit Excel Data
9 Other_Income Excel Data
10 PBIDT Excel Data
11 Depreciation Excel Data
12 PBIT Excel Data
13 Interest Excel Data
14 PBT Excel Data
15 Total_Tax Excel Data
16 Net_Profit Excel Data
17 Adjusted_Profit Excel Data
18 Pref_Dividend_(Rs_Mn) Excel Data
19 Equity_Dividend_(Rs_Mn) Excel Data
20 Dividend_Tax Excel Data
21 EPS_(Unadj)_(Rs) Excel Data
22 EPS_(Adjusted)_(Rs) Excel Data
23 Equity_Dividend_(Pct) Excel Data
24 DPS_(Unadj)_(Rs) Excel Data
25 DPS_(Adjusted)_(Rs) Excel Data
26 Dividend_Payout_(Pct) Excel Data
Balancesheet Items
27 Face_Value_(Rs) Excel Data
28 Outstanding_Shares_(Mn) Excel Data
29 Equity_Paid-up_(Rs_Mn) Excel Data
30 Shareholders’s_Funds Excel Data
31 Book_Value_(Unadj)_(Rs) Excel Data
32 Book_Value_(Adjusted)_(Rs) Excel Data
33 Debt Excel Data
34 Net_Debt Excel Data
35 Net_Fixed_Assets Excel Data
36 Gross_Block Excel Data
37 Investments Excel Data
38 Net_Current_Assets Excel Data
39 Current_Assets Excel Data
40 Inventories Excel Data
41 Sundry_Debtors Excel Data
42 Cash Excel Data
43 Loans_&_Adv Excel Data
44 Current_Liab_&_Prov Excel Data
45 Current_Liabilities Excel Data
46 Provisions Excel Data
47 Total_Assets Excel Data
48 Contingent_Liabilities Excel Data
49 Mkt_Cap_(Rs_Mn)_(at_Year_end) Excel Data
50 Enterprise_Value_(EV)_(Rs_Mn)_(at_Year_End) Excel Data
Growth Rates
51 Net_Sales_YoY(Pct) Excel Data
52 Other_Income_YoY(Pct) Excel Data
53 PBIDT_YoY(Pct) Excel Data
54 PBIT_YoY(Pct) Excel Data
55 Net_Profit_YoY(Pct) Excel Data
56 Adjusted_Profit_YoY(Pct) Excel Data
57 EPS_(Adj)_Growth_(Pct) Excel Data
58 Interest_YoY(Pct) Excel Data
59 Book_Value_(Adj)_Growth_(Pct) Excel Data
Margin Ratios
60 OPM_(Pct) Excel Data
61 NPM_(Pct) Excel Data
62 Tax_Rate_(Pct) Excel Data
63 RM_cost_(Pct)_of_Sales Excel Data
64 Other_Mfg_Exp_(Pct)_of_Sales Excel Data
65 Employee_Cost_(Pct)_of_Sales Excel Data
66 Power_Cost_(Pct)_of_Sales Excel Data
67 S&D_Cost_(Pct)_of_Sales Excel Data
Return Ratios and Efficiency
68 ROCE_(Pct) Excel Data
69 ROE_(Pct) Excel Data
70 Total_Debt_to_Equity_(x) Excel Data
71 Net_Debt_to_Equity_(x) Excel Data
72 Interest_Cover_(x) Excel Data
73 Asset_turnover_(x) Excel Data
74 Leverage_factor_(x) Excel Data
75 Receivable_days Excel Data
76 Payable_days Excel Data
Year end Prices & Valuations
77 Price_(Adju)_(Rs) Excel Data
78 Price_(Unadju)_(Rs) Excel Data
79 P__E_(x)_(at_Year_end) Excel Data
80 P__BV_(x)_(at_Year_end) Excel Data
81 Divi_Yield_(Pct)_(at_Year_End) Excel Data
82 EV__Sales_(x)_(at_Year_end) Excel Data
83 EV__PBDIT_(x)_(at_Year_end) Excel Data
84 EV__PBIT_(x)_(at_Year_end) Excel Data
Cashflow Items
85 Cash_flow_from_Operations Excel Data
86 Cash_from_Investing Excel Data
87 Invest_in_Fixed_Assets Excel Data
88 Invest_in_Group_Companies Excel Data
89 Invest_in_Subsidiaries Excel Data
90 Loan_to_Subsidiaries Excel Data
91 Acquisition Excel Data
92 Other_Investments Excel Data
93 Int__Divi_Income_etc Excel Data
94 Free_Cash_Flow Excel Data
95 Cash_from_Financing Excel Data
96 Equity_Raised__Repaid Excel Data
97 Debt_Raised__Repaid Excel Data
98 Dividend_Paid Excel Data
99 Interest_Paid Excel Data
Quarterly Shareholding Pattern
100 Promoters_(Pct) Excel Data
101 FII_(Pct) Excel Data
102 MF_(Pct) Excel Data
103 BFSI_etc_(Pct) Excel Data
104 Public_etc_(Pct) Excel Data
105 Pledge_(Pct) Excel Data
106 Promoter’s_Pledge_(Pct) Excel Data
107 Qtrly_Outstanding_Shares_(Mn) Excel Data
108 Mkt_Cap_(Rs_Mn)_(at_Qtr_end) Excel Data
109 Qtrly_Price_(Adju)_(Rs) Excel Data
110 Qtrly_Price_(Unadju)_(Rs) Excel Data
Broad Quarterly Numbers
111 Qtrly_Net_Sales Excel Data
112 Qtrly_PBIDT Excel Data
113 Qtrly_Adjusted_Profit Excel Data
114 Quarter_EPS_(Adj_for_Bonus,_Split) Excel Data
115 TTM_EPS_(Adj_for_Bonus,_Split) Excel Data
116 Qtrly_Net_Sales_YoY(Pct) Excel Data
117 Qtrly_PBIDT_YoY(Pct) Excel Data
118 Qtrly_Adjusted_Profit_YoY(Pct) Excel Data
119 Qtrly_OPM_(Pct) Excel Data
120 Qtrly_NPM_(Pct) Excel Data
121 PE_(TTM) Excel Data

One thought on “Identify Stocks

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s