ROCE-Calculator-Excel-Template-excel.xlsx

	A	B	D	E	F	G
1	Earning Before Interest & Tax (EBIT)				350000
2	Capital Employed (CE)				1200000
3
4	Return On Capital Employed (ROCE)				29,17%
5
6	Formulas to calculate EBIT		Formulas to calculate Capital employed
7
8	Earnings before Interest and Tax		Capital Employed
9	Net Sales	1000000	Total Assets			1500000
10	COGS	400000	Current Liabilities			300000
11	Business Expenses	250000	CE			1200000
12	EBIT	350000
13
14	Earnings before Interest and Tax		Capital Employed
15	EBITDA	500000	Fixed Asset			1000000
16	Depreciation	150000	Working Capital			200000
17	EBIT	350000	CE			1200000
18
19	Earnings before Interest and Tax		Capital Employed
20	Net Profit	200000	Long Term Borrowings			300000
21	Interest	50000	Short Term Borrowings			200000
22	Taxes	100000	Share Capital			100000
23	EBIT	350000	Reserves and Surplus			600000
24			CE			1200000
25
26	Earnings before Interest and Tax		Capital Employed
27	Profit Before Tax	300000	Fixed Asset			1000000
28	Interest	50000	Current Asset			500000
29	EBIT	350000	Current Liabilities			300000
30			CE			1200000
31
32	5 Year Analysis Of ROCE
33		2018	2019	2020	2021	2022
34	Net Profit	70	100	120	150	140
35	Interest	40	50	55	30	35
36	Taxes	30	50	54	70	50
37	EBIT	140	200	229	250	225
38
39	Total Assets	1000	1050	1100	1200	1250
40	Current Liabilities	400	300	350	330	250
41	CE	600	750	750	870	1000
42
43	ROCE	23,3%	26,7%	30,5%	28,7%	22,5%
44
45
46
47
48
49
50
51
52
53
54
55
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