94 Excel sheets, that makes Stock Picking Easier

[Vidhit Agarwal]

Hi

 

We understand that every money manager strives to deliver spectacular performance as delivered by legendary investors like Benjamin Graham, Warren Buffett, Peter Lynch and Philip Fisher etc., by following their wisdom and concepts developed and followed by them.

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

 

P&L 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	Loss on FX Transaction	Excel Data
10	Other Exp	Excel Data
11	Other Income	Excel Data
12	PBIDT	Excel Data
13	Depreciation	Excel Data
14	PBIT	Excel Data
15	Interest	Excel Data
16	PBT	Excel Data
17	Total Tax	Excel Data
18	Net Profit	Excel Data
19	Adjusted Profit	Excel Data
20	Pref Dividend	Excel Data
21	Equity Dividend	Excel Data
22	Dividend Tax	Excel Data
Balancesheet Items
23	Shareholder's Funds	Excel Data
24	Face Value (Rs)	Excel Data
25	Outstanding Shares (Mn)	Excel Data
26	Equity Paid-up (Rs Mn)	Excel Data
27	Book Value / share (Unadj) (Rs)	Excel Data
28	Book Value / share (Adjusted) (Rs)	Excel Data
29	Minority Interest (BS)	Excel Data
30	Debt	Excel Data
31	Net Debt	Excel Data
32	Net Fixed Assets	Excel Data
33	Gross Block	Excel Data
34	Capital Work in Progress	Excel Data
35	Investments	Excel Data
36	Net Current Assets	Excel Data
37	Current Assets	Excel Data
38	Inventories	Excel Data
39	Sundry Debtors	Excel Data
40	Cash	Excel Data
41	Loans & Adv.	Excel Data
42	Current Liab & Prov	Excel Data
43	Current Liabilities	Excel Data
44	Provisions	Excel Data
45	Contingent Liabilities	Excel Data
Cashflow Items
46	Cash Flow from Operations	Excel Data
47	Cash from Investing	Excel Data
48	Invest. in Fixed Assets	Excel Data
49	Acquisition	Excel Data
50	Other Investments	Excel Data
51	Free Cash Flow	Excel Data
52	Cash from Financing	Excel Data
53	Equity Raised/Repaid	Excel Data
54	Debt Raised/Repaid	Excel Data
55	Dividend Paid	Excel Data
56	Interest Paid	Excel Data
57	Net Change in Cash	Excel Data
58	Cash at the End of the Year	Excel Data
Growth Rates
59	Net Sales YoY(%)	Excel Data
60	Operating Profit YoY(%)	Excel Data
61	Other Income YoY(%)	Excel Data
62	PBIDT YoY(%)	Excel Data
63	Depreciation YoY(%)	Excel Data
64	Interest YoY(%)	Excel Data
65	Net Profit YoY(%)	Excel Data
66	Adjusted Profit YoY(%)	Excel Data
67	EPS (Adj) Growth (%)	Excel Data
68	Book Value(Adj) Growth (%)	Excel Data
Margin & Return Ratios
69	OPM (%)	Excel Data
70	NPM (%)	Excel Data
71	ROCE (%)	Excel Data
72	ROE (%)	Excel Data
73	Asset Turnover(x)	Excel Data
74	Leverage Factor(x)	Excel Data
Debt Profile
75	Total Debt to Equity (x)	Excel Data
76	Net Debt to Equity (x)	Excel Data
77	Interest Cover (x)	Excel Data
Valuation Ratios
78	P/E(x) (at Year End)	Excel Data
79	P/BV(x) (at Year End)	Excel Data
80	Divi. Yield (%) (at Year End)	Excel Data
81	EV/Sales(x) (at Year End)	Excel Data
82	EV/PBIDT(x) (at Year End)	Excel Data
83	EV/PBIT(x) (at Year End)	Excel Data
Stock Market Related Data
84	Price (Unadju) (Rs) (at Year End)	Excel Data
85	Price (Adju) (Rs) (at Year End)	Excel Data
86	Mkt Cap (Rs Mn) (at Year end)	Excel Data
87	EV (Rs Mn) (at Year End)	Excel Data
Share Holding Pattern
88	Promoters (%)	Excel Data
89	FII (%)	Excel Data
90	MF (%)	Excel Data
91	BFSI etc(%)	Excel Data
92	Public etc(%)	Excel Data
93	Prom's Pledge (%) of Total	Excel Data
94	Prom.'s Pledge (%) of Prom Hold	Excel Data