Untitled spreadsheet

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S
1	(INR Crores/10 Millions)			RUCHI SOYA INDUSTRIES LTD								Dec-16	<< Latest available quarterly results
2	Narration	Mar-07	Mar-08	Mar-09	Mar-10	Mar-11	Mar-12	Mar-13	Mar-14	Mar-15	Mar-16	Last 4 Quarters	Total 10 Yrs (2007-16)	Growth Trends:	10Yr	7Yr	5Yr	3Yr	TTM
3	Sales	8,555	10,908	11,921	13,411	16,627	25,996	26,146	24,381	28,308	27,735	23,210		Sales Growth	14%	13%	11%	2%	-16%
4	Operating Profit	227	297	64	358	543	715	656	560	582	-186	-408		OPM	2%	2%	2%	2%	0%
5	Operating Profit Margin (OPM%)	3%	3%	1%	3%	3%	3%	3%	2%	2%	0%	0%		PAT Growth	-227%	#####	-233%	-255%	23%
6	Other Income	140	220	360	195	136	227	338	231	169	73	148		Avg. PE	20.6	22.9	26.7	29.8	-0.8
7	Interest	145	189	188	181	253	574	537	577	522	696	797
8	Profit before tax (PBT)	156	254	151	272	306	228	304	50	81	-959	-1,213
9	Tax%	36%	37%	38%	37%	30%	46%	22%	73%	24%	8%	11%
10	Net profit after tax (PAT)	101	159	93	172	213	122	236	13	61	-879	-1,079	293	CMP	25
11	Net Profit Margin (NPM%)	1%	1%	1%	1%	1%	0%	1%	0%	0%	-3%	-5%		P/E	-0.8
12	Cash from Operating Activity (CFO)	-86	113	633	186	-190	904	-2,028	3,451	-508	-612		1,863	P/B	0.7
13	Capex (NFA+WIP change+Dep)		198	298	712	380	438	265	111	-11	20		2,411	P/E*P/B	-0.5
14	Total Debt (D)	1,470	1,560	1,721	2,346	3,461	4,897	5,718	2,933	3,644	4,929	FCF	-548	Div Yield	0.00%
15	Cash + Investments (CI +NCI)	714	661	1,097	1,698	1,445	2,610	3,233	713	806	375	Total Div 10 Yrs	93	Market Cap	837
16												Cash+Investments	375
17	Free Cash Flow ( FCF)*	-86	-85	335	-525	-570	466	-2,294	3,340	-497	-632		-548
18	Self-Sustainable Growth Rate (SSGR)				4%	3%	3%	2%	-2%	-3%	-15%			200	Total Retained Earnings (RE) in 10 Yrs (A)
19	PBT/Avg. NFA (<10%,>25%)		23%	12%	17%	15%	10%	13%	2%	3%	-41%	FCF/CFO	-29%	-384	Total increase in Mcap in 10 yrs (B)
20	ROE on Avg Equity (<7%,>25%)		17%	9%	11%	11%	6%	10%	1%	3%	-52%	SG to Capex	0.11	-1.92	Value created per INR of RE (B/A)
21	ROCE (EBIT on Avg CE/TA) (<10%,>35%)		9%	6%	7%	7%	7%	6%	5%	5%	-2%
22	Incremental ROE 3Yr Rolling				22%	14%	7%	14%	-37%	-18%	-386%
23														0	Closing share price on March 31, 10 years back
24	Net Fixed Asset Turnover (High is better)		9.76	9.49	8.14	8.18	11.69	10.84	9.8	11.61	11.83
25	Receivables days (Low is better)		31	32	30	38	37	51	66	68	83
26	Inventory Turnover (High is better)		7	7	9	8	8	7	7	9	10			4
27	Net Fixed Assets (NFA)	1,058	1,178	1,335	1,961	2,103	2,345	2,480	2,496	2,381	2,309			16
28	Capital Work in Progress (CWIP)	20	23	79	64	182	237	213	143	100	42			-20
29	Share Capital	36	38	38	53	67	67	67	67	67	67
30	Dividend Paid (Div) Without DDT	9	9	11	16	17	11	11	5	5	-			Div Growth	-100%	#####	-100%	-100%
31	Dividend Payout (Div/PAT)	9%	6%	12%	9%	8%	9%	5%	40%	9%	0%
32	Retained Earnings (RE=PAT-Div)	92	150	82	157	197	112	226	8	56	-879
33	Price to earning	12.1	10.7	5.7	17.7	16.3	24.6	9.6	85.9	23.7	-
34	Mcap	1,221	1,702	531	3,061	3,471	3,003	2,276	1,153	1,443	999	837
35	Cash + Investments (CI +NCI)	714	661	1,097	1,698	1,445	2,610	3,233	713	806	375	375
36	Total Debt (D)	1,470	1,560	1,721	2,346	3,461	4,897	5,718	2,933	3,644	4,929			Debt	14%	16%	7%	-5%
37	Total Equity (E)	843	1,039	1,117	1,886	2,147	2,198	2,357	2,329	2,199	1,195			Book Value	4%	1%	-11%	-20%
38	Debt to Equity ratio (D/E)	1.7	1.5	1.5	1.2	1.6	2.2	2.4	1.3	1.7	4.1
39	Cost of funds	12.00%
40	Interest outgo (Rs. Cr.)		182	197	244	348	501	637	519	395	514
41	Interest Coverage (OP/Int. Out)		1.6	0.3	1.5	1.6	1.4	1	1.1	1.5	-0.4
42	Price	66.95	90.14	28.12	116.42	104.38	90.08	68.15	34.51	43.2	29.91					s
43	FCF/Share*	-23.57	-4.509241641	17.763	-19.985	-17.141	13.98	-68.688	99.99508	-14.8808	-18.9308
44	Price / FCF*	-1	-1.058851169	0.0839	-0.2216	0	0.1933	-0.0297	0.010331	-0.0869	-0.04729
45		Mar-07	Mar-08	Mar-09	Mar-10	Mar-11	Mar-12	Mar-13	Mar-14	Mar-15	Mar-16		Total 10 Yrs (2007-16)
46	Cash from Operating Activity (CFO)	-86	113	633	186	-190	904	-2,028	3,451	-508	-612		1,863
47	Cash from Investing Activity (CFI)	-93	-175	-181	-356	-196	-267	-45	19	23	2		-1,268
48	Cash from Financing Activity (CFF)	261	-31	-16	656	554	885	378	-3,421	453	622		341
49	Net Cash Flow (CFO+CFI+CFF)	83	-92	436	487	168	1,521	-1,695	49	-32	12		937
50	Cash & Eq. at the end of year	671	579	1,015	1,501	1,257	2,399	2,950	379	524	146
51	Capital Expenditure Ratio(CFO/Capex)*		0.570852447	2.1269	0.262	-0.4989	2.0652	-7.6429	31.12264	46.98612	-30.2336		45	Avg. CER	4.47583
52	Earning Quality(OCF/NP)*	-0.8538	0.711172518	6.7851	1.0812	-0.8898	7.3877	-8.5849	257.1677	-8.33612	0.696745		255	Avg. EQ	25.5165
53	Total Retained Earnings (RE) in 10 Yrs (A)	200
54	Total increase in Mcap in 10 yrs (B)	-384
55	Value created per INR of RE (B/A)	-1.92									Source: Screener
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100