21/06/2006
Date :
Sensitivity Analysis Statement
Rs in one hundred thousands
Draft for HighTech Engineering Industries
81, Mittal Towar, Nariman Point, Mumbai
Year No ———— >
2003-04
2004-05
2005-06
2006-07
2002-03
Sales
Varying at 5 %
Sales
383.75
595.38
692.08
862.06
1014.15
Sales with 5% Variation
402.94
625.14
726.68
905.16
1064.86
Normal Gross Profit
121.05
197.11
221.41
286.13
355.62
GPT at Sales with 5% Variation
140.24
226.88
256.01
329.24
406.33
Normal GPR
0.45
0.47
0.46
0.47
0.50
GPR at Sales with 5% Variation
0.49
0.51
0.49
0.51
0.53
Normal Net Profit
41.33
91.21
103.42
140.69
180.02
NP at Sales with 5% Variation
60.52
120.98
138.03
183.79
230.73
Normal NPR
0.15
0.22
0.21
0.23
0.25
NPR at Sales with 5% Variation
0.21
0.27
0.27
0.28
0.30
Normal Cash Balance
40.22
49.14
106.61
173.23
278.95
Cash B/s at Sales with 5% Variation
53.65
69.98
130.84
203.40
314.44
Normal DSCR
1.33
2.25
2.70
3.68
4.85
DSCR at Sales with 5% Variation
1.55
2.67
3.27
4.50
5.97
Varying at -5 %
Sales
383.75
595.38
692.08
862.06
1014.15
Sales with -5% Variation
364.56
565.61
657.47
818.96
963.44
Normal Gross Profit
121.05
197.11
221.41
286.13
355.62
GPT at Sales with -5% Variation
101.87
167.34
186.80
243.03
304.92
Normal GPR
0.45
0.47
0.46
0.47
0.50
GPR at Sales with -5% Variation
0.41
0.43
0.42
0.43
0.46
Normal Net Profit
41.33
91.21
103.42
140.69
180.02
NP at Sales with -5% Variation
22.14
61.44
68.82
97.59
129.31
Normal NPR
0.15
0.22
0.21
0.23
0.25
NPR at Sales with -5% Variation
0.09
0.16
0.15
0.17
0.20
Normal Cash Balance
40.22
49.14
106.61
173.23
278.95
Cash B/s at Sales with -5% Variation
26.79
28.30
82.39
143.06
243.45
Normal DSCR
1.33
2.25
2.70
3.68
4.85
DSCR at Sales with -5% Variation
1.11
1.84
2.13
2.85
3.73
Raw Materials
Varying at 2 %
Raw Materials
108.34
139.04
170.89
209.33
232.03
Raw Materials with 2% Variation
110.51
141.82
174.31
213.51
236.67
Normal Gross Profit
121.05
197.11
221.41
286.13
355.62
GPT at Raw Materials with 2% Variation
118.89
194.33
217.99
281.95
350.98
Normal GPR
0.45
0.47
0.46
0.47
0.50
GPR at Raw Materials with 2% Variation
0.44
0.47
0.45
0.47
0.49
Normal Net Profit
41.33
91.21
103.42
140.69
180.02
NP at Raw Materials with 2% Variation
39.16
88.43
100.01
136.50
175.38
Normal NPR
0.15
0.22
0.21
0.23
0.25
NPR at Raw Materials with 2% Variation
0.15
0.21
0.21
0.23
0.25
Normal Cash Balance
40.22
49.14
106.61
173.23
278.95
Cash B/s at Raw Materials with 2%
38.70
47.19
104.22
170.30
275.70
Normal DSCR
1.33
2.25
2.70
3.68
4.85
DSCR at Raw Materials with 2%
1.31
2.21
2.64
3.60
4.75
Varying at 5 %
Raw Materials
108.34
139.04
170.89
209.33
232.03
Raw Materials with 5% Variation
113.76
145.99
179.43
219.79
243.63
Normal Gross Profit
121.05
197.11
221.41
286.13
355.62
GPT at Raw Materials with 5% Variation
115.64
190.16
212.86
275.67
344.02
Normal GPR
0.45
0.47
0.46
0.47
0.50
GPR at Raw Materials with 5% Variation
0.43
0.46
0.44
0.46
0.48
Normal Net Profit
41.33
91.21
103.42
140.69
180.02
NP at Raw Materials with 5% Variation
35.91
84.26
94.88
130.22
168.42
Page No.
1
Sensitivity Analysis Statement