business analysis -MTAR Technologies.xlsx

	A	B	C	D	E	F	G	H	I	J	K
1	COMPANY NAME	MTAR TECHNOLOGIES LTD

2	LATEST VERSION	2.10
3	CURRENT VERSION	2.10
4
5	META
6	Number of shares	3.08
7	Face Value	10
8	Current Price	2188.15
9	Market Capitalization	6730.66
10
11
12
13
14
15	PROFIT & LOSS
16	Report Date	Mar-12	Mar-13	Mar-14	Mar-15	Mar-16	Mar-17	Mar-18	Mar-19	Mar-20	Mar-21
17	Sales	99.9	95.45	105.03	80.89	81.48	100.68	156.62	183.67	213.77	246.43
18	Raw Material Cost							65.98	65.53	87.26	101.75
19	Change in Inventory							9.05	2.97	15.09	21.6
20	Power and Fuel							6.33	6.47	7.24	6.71
21	Other Mfr. Exp							10.76	11.31	14.8	14.64
22	Employee Cost							44.61	43.51	51.63	53.04
23	Selling and admin							3.87	4.9	7.43	6.53
24	Other Expenses	84.96	75.64	85.77	79.01	70.82	112.76	2.24	1.2	2.54	2.27
25	Other Income	2.9	0.74	1.73	3.26	0.8	0.78	0.94	3.53	4.37	1.31
26	Depreciation	8.42	9.43	9.54	4.81	5.3	5	11.21	11.23	12.05	12.56
27	Interest	6.44	9.38	8.57	7.58	6.7	5.35	4.46	4.46	4.75	7
28	Profit before tax	2.98	1.74	2.88	-7.25	-0.54	-21.65	17.15	41.56	45.53	64.84
29	Tax	0.25	1.4	1.07	-2.63	-0.72	-6.59	11.73	2.35	14.22	18.77
30	Net profit	2.73	0.34	1.81	-4.62	0.18	-15.06	5.42	39.2	31.32	46.08
31	Dividend Amount								8.46	13.38	18.46
32
33
34
35
36
37
38
39
40	Quarters
41	Report Date				Mar-20	Jun-20	Sep-20	Dec-20	Mar-21	Jun-21	Sep-21
42	Sales				61.6	48.74	73.29	55.24	69.16	54.03	91.3
43	Expenses				47.08	37.3	49.21	37.72	39.1	39.55	61.86
44	Other Income				3.23	0.41	0.17	0.14	0.59	2.59	2.57
45	Depreciation				2.95	2.97	3.1	3.26	3.23	3.34	3.52
46	Interest				2.03	1.48	1.39	1.97	2.17	1.18	1.39
47	Profit before tax				12.77	7.4	19.76	12.43	25.25	12.55	27.1
48	Tax				3.9	2.08	5.87	3.58	7.23	3.84	8.05
49	Net profit				8.87	5.32	13.89	8.86	18.01	8.71	19.06
50	Operating Profit				14.52	11.44	24.08	17.52	30.06	14.48	29.44
51
52
53
54
55	BALANCE SHEET
56	Report Date	Mar-12	Mar-13	Mar-14	Mar-15	Mar-16	Mar-17	Mar-18	Mar-19	Mar-20	Mar-21
57	Equity Share Capital	28.21	28.21	28.21	28.21	28.21	28.21	28.21	28.21	26.76	30.76
58	Reserves	206.75	207.09	185.25	180.5	180.62	165.56	177.31	206.77	198.32	446
59	Borrowings	53.64	58.54	43.69	48.76	25.61	29.12	19.79	28.73	29.13	16.98
60	Other Liabilities	84.49	98.2	72.84	48.04	38.32	71.18	55.72	41.45	92.06	92.58
61	Total	373.09	392.04	329.99	305.51	272.76	294.07	281.03	305.16	346.27	586.32
62	Net Block	162.03	159.31	151.35	145.4	145.78	148.24	152.23	162.19	155.1	167.06
63	Capital Work in Progress	15.36	8.17	7.43	7.75	7.75	7.75	1.84	5.62	11.73	10.52
64	Investments	25.25	25.25	0.01	0.01	0.01	0.01	0.01	0.01	0.02	0.02
65	Other Assets	170.45	199.31	171.2	152.35	119.22	138.07	126.95	137.34	179.42	408.72
66	Total	373.09	392.04	329.99	305.51	272.76	294.07	281.03	305.16	346.27	586.32
67	Receivables	17.73	15.78	16.25	15.63	19.61	38.66	48.97	50.42	61.64	77.28
68	Inventory	41.53	56.63	51.21	52.55	36.74	31.52	41.93	41.07	75.46	102.54
69	Cash & Bank	9.6	5.61	6.09	2.91	6.94	9.77	9.08	10.77	23.24	190.9
70	No. of Equity Shares	28213886	28213886	28213886	28213886	28214132	28214132	28214132	28214132	26759591	30759591
71	New Bonus Shares
72	Face value	10	10	10	10	10	10	10	10	10	10
73	Share holders fund	234.96	235.30	213.46	208.71	208.83	193.77	205.52	234.98	225.08	476.76
74	Total liablities	138.13	156.74	116.53	96.80	63.93	100.30	75.51	70.18	121.19	109.56
75
76
77
78
79
80	CASH FLOW:
81	Report Date	Mar-12	Mar-13	Mar-14	Mar-15	Mar-16	Mar-17	Mar-18	Mar-19	Mar-20	Mar-21
82	Cash from Operating Activity							14.42	42.11	56.19	8.62
83	Cash from Investing Activity							-1.33	-32.92	-12.06	-22.01
84	Cash from Financing Activity							-13.79	-7.49	-41.35	180.14
85	Net Cash Flow							-0.7	1.7	2.78	166.74
86
87
88
89
90	PRICE:										1023.7
91
92	DERIVED:
93	Adjusted Equity Shares in Cr	2.82	2.82	2.82	2.82	2.82	2.82	2.82	2.82	2.68	3.08
94
95
96
97
98
99
100