pgd_ctm project final worksheet
TRANSCRIPT
-
8/18/2019 PGD_CTM Project Final Worksheet
1/215
1
2
3
45
6
1
Sr. No.
-
8/18/2019 PGD_CTM Project Final Worksheet
2/215
3
!
"
-
8/18/2019 PGD_CTM Project Final Worksheet
3/215
-
8/18/2019 PGD_CTM Project Final Worksheet
4/215
-
8/18/2019 PGD_CTM Project Final Worksheet
5/215
7.1 Project Financials at a Glance
PROJECT FINANCIALS AT A GLANC
Rupees (in lakhs)
Cost of the project
Means of Finance
Total
Det! "#uit$ Ratio
%et &resent 'alue&rotailit$ n*e+ (&)
nternal Rate of Return
7.3 DETAILS OF COST OF PROJECT
PROJECT COST CO#PONENT
LAND $ SITE DE%ELOP#ENT
1, -an* (inclu*in. re.istration)
2, Cost of le/ellin. 0 site *e/elopent
pproach 0 internal roa*s Fencin. Cul/erts ates etc,
&'ILDING $ CI%IL (OR)S
1, Drains an* seers inclu*in. euent treatent pit &lant uil*in.-aorator$ uil*in. 7& processin. e#uipent uil*in.s
&ro*ucts 8tora.e 8he* &a/e* $ar* etc,
2, Foun*ation for Reactor Fractionator Coolin. toer Copressor
9ther iscellaneous pups etc,
4, Chine$ foun*ation inclu*in. chine$ ith refractor$ linin. 8itch$ar*
"#uit$! &rooters
Det! -on. Ter -oan
3, u+iliar$ coolin. toer Miscellaneous foun*ations for con/e$ors 7& preparationfoun*ation DM ater plant foun*ation etc,
-
8/18/2019 PGD_CTM Project Final Worksheet
6/215
ci/il foun*ation Ra ater reser/oir *inistration :uil*in. enerator
8he* 8tores Technician roo Canteen 0 /ehicle 8he* &a/eent
reener$ *e/elopent
PLANT $ #AC*INER+
inclu*in. instruentation an* control
Fans &ups 'al/es specialities &ipin. an* u+iliaries
inclu*in. control 0 instruentation alternator control
rela$ an* eterin. panels etc,
3, 9ther &0M! Coolin. toer construction 7& han*lin. s$ste for fee*in.
8tora.e pit Char han*lin. s$ste ;i.h pressure stea pipin. 'al/es an* supports
u+iliar$ 0 lo pressure stea pipin. 7ater treatent plant Tanka.es for &ro*ucts st ir con*itionin. for control roo ir copressors 0 copresse* air s$ste
DC8 ase* instruentation s$ste for the plant an* instruentation Misc, &ups 'e
4, -i.htin. for 7& processin. plant &lant counication s$ste
9ther electrical an* echanical +tures
ENGINEERING
Detaile* en.ineerin. fees for ci/il echanical an* electrical ork
#ISCELLANEO'S FI,ED ASSETS
1, Transportation /ehicles
2, Furniture coputers counication s$ste canteen facilities 9
-
8/18/2019 PGD_CTM Project Final Worksheet
7/215
a. aw material stock is 3 months of the ale 6alue
". &n 7aterial stock is 1 week of the ale 6alue
c. inished Product tock is 1 month of forecast sales for ne8t 9uarter d. Credit to customer is 1 month of ale 6alue
e. Credit from supplier is 2 months of aw 7aterial price
. )epreciation has "een counted "oth "y )6 and '7 as per Companies Act 1;$-.
;. Corporate Ta8 ate is taken as 32.%$+.
10. or orkin Capital, the assumptions made are:
-
8/18/2019 PGD_CTM Project Final Worksheet
8/215
-
8/18/2019 PGD_CTM Project Final Worksheet
9/215
Sr. No.
Rupees (in lakhs) 1
1===
4==
6=== 3
1=== !
2!=1 "
216>,1 87
(@) 9
:
COST 4in La56s
3.! Aear 2=14B15
Ra Material 8tock =,=
".18
n Material 8tock =,=
Finishe* &ro*uct 8tock =,=Cre*it to custoer =,=
Cre*it fro supplier =,=
%et 7orkin. Capital =,=
nterest o/er 7orkin. Capi =,=
-
8/18/2019 PGD_CTM Project Final Worksheet
10/215
Aear1
2=14B15
5"==6
1
&ercent 8hare (@) =
'olue of &ro*uction (T&) =
8ales Re/enue (Rupees) =
!".:!
1"
7aste &lastics Market&otential (T&)
'olue of Consuption(T&)
-
8/18/2019 PGD_CTM Project Final Worksheet
11/215
-
8/18/2019 PGD_CTM Project Final Worksheet
12/215
-
8/18/2019 PGD_CTM Project Final Worksheet
13/215
7. ESTI#ATED PROJECT COST
R2ees 4in la56s
PROJECT COST CO#PONENT COST 4in la56s
-an* an* 8ite De/elopent 46,>
:uil*in. an* Ci/il 7orks =,=
6,
36,
&lant an* Machiner$ 42=,=
"n.ineerin. E1,E
Miscellaneous Fi+e* ssets 3=,=
Contin.encies >=,=&reoperati/e "+penses 15=,=
&reliinar$ an* Capital ssue Relate* "+penses 23,>
Mar.in Mone$ 53,2
TOTAL PROJECT COST
2=15B16 2=16B1
22>,1 242,3
1>,2 1E,4
=,= 6=,6=,= 6,=
4=,= 42,5
2=6,3 355,>
2>,E 4E,>
2a,Factor$2,
-
8/18/2019 PGD_CTM Project Final Worksheet
14/215
2 3
2=15B16 2=16B1
55===== 6=5====
= =,=5
3===
= 24==
= E12,3
-
8/18/2019 PGD_CTM Project Final Worksheet
15/215
-
8/18/2019 PGD_CTM Project Final Worksheet
16/215
-
8/18/2019 PGD_CTM Project Final Worksheet
17/215
Sr. No.
CONTRI&'TION 4?
4,6> E3,6 1
=
6, 135,3333
3,6 3,33333
42,== >4= 3
E,1E 1>3,33 !
3,== 6= "
>,== 16= 815,== 3== 7
2,3> 4,56 9
5,321=6,4
:
1==,==2===
7.8 (OR)ING CAPITAL STATE#EN
Rupees (in -akhs)
2=1B1> 2=1>B1E 2=1EB2=
256,6 2=,> 2>5,1
2=,5 21, 22,>
64,1 6, 1,3>=,> >5,5 E=,3
45,= 4,5 5=,=
3,= 3E>,2 41E,4
52,> 55,> 5>,
7." #AR)ET DETAILS
-
8/18/2019 PGD_CTM Project Final Worksheet
18/215
4 5 6
2=1B1> 2=1>B1E 2=1EB2=
6655=== 32=5== >=5255=
=,=5 =,=5 =,=4
31>,5 335 3562,5
255= 2== 2>5=
E6E,3 1=26,3 1=>3,3
-
8/18/2019 PGD_CTM Project Final Worksheet
19/215
-
8/18/2019 PGD_CTM Project Final Worksheet
20/215
-
8/18/2019 PGD_CTM Project Final Worksheet
21/215
7.
PROJECT COST CO#PONENT COST 4in la56s1
-an* an* 8ite De/elopent 46,> 1=,==
:uil*in. an* Ci/il 7orks =,=
2a, Factor$ :uil*in. 6, ,==
2, %on Factor$ :uil*in. 36, 4,==
&lant an* Machiner$ 42=,=
"n.ineerin. E1,E
Miscellaneous Fi+e* ssets 3=,=
Contin.encies >=,=&reoperati/e "+penses 15=,=
&reliinar$ an* Capital ssue Relate* "+penses 23,>
Mar.in Mone$ 53,2
&rooters 1 21,==
Ter -oan
&ulic shares
Total 1=== 21
nterest on Ter -oan12@
2=2=B21 2=21B22 2=22B23
2>5,1 2>5,1 2>5,1
22,> 22,> 22,>
1,3 1,3 1,3E5,= E5,= E5,=
5=,= 5=,= 5=,=
424,2 424,2 424,2
5E,4 5E,4 5E,4
-
8/18/2019 PGD_CTM Project Final Worksheet
22/215
> E
2=2=B21 2=21B22 2=22B23
>>5>=5 E435>5,5 1=1E44
=,=4 =,=4 =,=3
35= 35= 35=
3=== 3=== 3===
114=,3 114=,3 114=,3
-
8/18/2019 PGD_CTM Project Final Worksheet
23/215
-
8/18/2019 PGD_CTM Project Final Worksheet
24/215
-
8/18/2019 PGD_CTM Project Final Worksheet
25/215
Esti0ation o< E-en=it2re =2rin erio= o< constr2ction> ! 0ont6s/
3 ! " 8
16,> 2=
1= > 1= 12 14
6 1= 4,6 > 4
>= >= 6= 4=
1= 12 6 6 >
E,6 6 > 1=> 1= 1= 12
42,>= 14,6=
116,6 1=4 >>
42,> 14,6 116,6 1=4 >>
E,32> ,2> 5,2>
6=5
2=23B24 2=24B25 2=25B26 Aear
2>5,1 2>5,1 2>5,1 @ Capacit$ GtiliHation
22,> 22,> 22,> ctual capacit$ (T&)
1,3 1,3 1,3 aste plastics (Rs)E5,= E5,= E5,= catal$st (Rs)
5=,= 5=,= 5=,= utilities (Rs)
424,2 424,2 424,2 Ra aterials an* Gtilities (>5@)
5E,4 5E,4 5E,4 &acka.in. (3@)
8alaries an* 7a.es (@)
Factor$ 9/erhea*s (5@)
-
8/18/2019 PGD_CTM Project Final Worksheet
26/215
1= 11 12 Total Cost o< Pro=2ction 4Rs
2=23B24 2=24B25 2=25B26 *ninistrati/e e+penses (Rs)
11>E3> 12E6>12 ??? 8ales e+penses (Rs)
=,=3 =,=3 =,=3 Gross Cost o< Pro=2ction 4Rs
35= 35= 35=
3=== 3=== 3===
114=,3 114=,3 114=,3
8ales Re/enue
'ariale C9&
7orkin. Capital nterest
Fi+e* Capital nterest
Cash 8urplus
+ear
FI,ED COSTS
nterest
8alar$ an* 7a.es
Depreciation
Factor$ 9/erhea*s an* *in e+penses
TOTAL
%ARIA&LE COSTS
Ra aterials an* Gtilities
&acka.in. "+penses
8ales e+penses
TOTAL
Total Sales Reen2e o< Pro=2cts
:reak "/en #uantit$ sales(Ton)
:reak "/en Capacit$ (@)
E-en=it2re =2rin
E-en=it2re =2rin
-
8/18/2019 PGD_CTM Project Final Worksheet
27/215
I
(ACC4
+ear
1
2
34
5
6
>
E
1=
Total
7.
+ear
2=14B15
2=15B16
2=16B1
2=1B1>
2=1>B1E
2=1EB2=
2=2=B212=21B22
2=22B23
2=23B24
2=24B25
2=25B26
TOTAL
+ear2=14B15
2=15B16
2=16B1
2=1B1>
2=1>B1E
2=1EB2=
2=2=B21
2=21B22
-
8/18/2019 PGD_CTM Project Final Worksheet
28/215
2=22B23
2=23B24
2=24B25
2=25B26
-
8/18/2019 PGD_CTM Project Final Worksheet
29/215
ont6s ri=
ont6s
7 9 : 1
6
4= 3= 3= 25
1= 1= 12 >
> 6,5 6,5
12 1= 13,4 111= 14 16 1>
> 2 ,E 6>,5
> 2 ,E 6>,5
3,E 2,>> 2,33 1,3
211,4
7.11
Caacit@> 3 TP
1 2 3 4
>= >5 E= E5
24== 255= 2== 2>5=
24=,= 255,= 2=,= 2>5,=3,= 3,2 3,4 3,6
12,> 13,6 14,4 15,2
255,> 21,> 2>,> 3=3,>
E,= E,6 1=,2 1=,
21,1 22,4 23, 25,=
15,= 16,= 16,E 1,E
-
8/18/2019 PGD_CTM Project Final Worksheet
30/215
3.: 31:.9 339.8 3"7.!
21,1 22,4 23, 25,=
24,1 25,6 2,1 2>,6
3!8.1 387.7 39:.3 !11.
1 2 3 4
=,= =,= E12,3 E6E,3
=,= =,= 2>>,E 3=,=
=,= 2>,E 4E,> 52,>
36,5 36,5 33,1 2>,5
B36,5 B65,4 54=,4 5>1,=
7
1 3 !
36,5 36,5 33,1 2>,5
21,1 22,4 23, 25,=
3,> 3,> 3,> 3,>
36,1 3>,4 4=,6 42,E
131." 13".1 13".3 13!.3
255,> 21,> 2>,> 3=3,>
E,= E,6 1=,2 1=,
24,1 25,6 2,1 2>,6
99.: 37. 3". 3!3.1
E12,3 E6E,3 1=26,3 1=>3,3
211=,= 2=3E,E 1E2>, 1>13,
=,= 6>,= 64,3 6=,5
7.1! DISCO'NTED PROFIT FLO(
R2ees4in la5
@ear 1 4I1 246,>
+ear 4I 253,2
-
8/18/2019 PGD_CTM Project Final Worksheet
31/215
"!:.38
.
(ACC5 415n
566,2 =,2 1,2= 41,>
6=1,6 =,2 1,44 41,>
63,= =,2 1,3 36>,662,3 =,2 2,= 324,2
=, =,2 2,4E 2>4,4
=, =,2 2,EE 23,=
=, =,2 3,5> 1E,5
=, =,2 4,3= 164,6
=, =,2 5,16 13,2
=, =,2 6,1E 114,3
873." 717."
1" DE&T SER%ICE CO%ERAGE RATIO 4DSCRR'PEES 4in La56s
SL# Dereciation
= 0 36,54 =
= = 36,54 =
4=5,E 3,>1 33,11 1>,5
4=6,16 3,>1 2>,55 1>,5
414,24 3,>1 23,E> 1>,5
432,=6 3,>1 1E,41 1>,5
45=,> 3,>1 14,>4 1>,5446,52 3,>1 1=,2> 1>,5
444,2E 3,>1 5,1 1>,5
442,E3 3,>1 1,14 1>,5
441,E= 3,>1 =,== 1>,5
441,1= 3,>1 =,== 1>,5
!3".98 379.1! 1.11 197."
7.18 Fina
R2
8ales ross Cost of &ro*uction ross &rot 9peratin. &rot= = = =
= = = =
E12,3 346,1 566,2 51>,3
E6E,3 36, 6=1,6 52E,4
1=26,3 3>E,3 63,= 54E,3
1=>3,3 411,= 62,3 5>1,>
114=,3 432,6 =, 614,2
114=,3 432,6 =, 611,2
GrossProt
Present %al2e4P%
Prota
-
8/18/2019 PGD_CTM Project Final Worksheet
32/215
114=,3 432,6 =, 61=,5
114=,3 432,6 =, 61=,5
114=,3 432,6 =, 61=,5
114=,3 432,6 =, 61=,5
-
8/18/2019 PGD_CTM Project Final Worksheet
33/215
11 1
laks
46,>
=,=
6,=
36,6
2= 15 42=,=
5 4,E E1,E
6 3 3=,=
>=,=3= 22 15=,=
15 >,> 23,>
53,253,2
211,4
6=5,=
>3,6 1== 1>3,6
>3,6 1== 1===,=
32,4
GROSS COST OF PROD'CTION
o< Petrole20 Pro=2cts/ R2ees 4in La56s
5 6
1== 1== 1==
3=== 3=== 3===
3==,= 3==,= 3==,=3,> 3,> 3,>
16,= 16,= 16,=
31E,> 31E,> 31E,>
11,3 11,3 11,3
26,3 26,3 26,3
1>,> 1>,> 1>,>
-
8/18/2019 PGD_CTM Project Final Worksheet
34/215
378. 378. 378.
26,3 26,3 26,3
3=,1 3=,1 3=,1
!3.8 !3.8 !3.8
,12 C8; F-97 8TT"M"
Rupees (in -akhs)
5 6
1=26,3 1=>3,3 114=,3
325,= 343,1 361,1
55,> 5>, 5E,4
24,= 1E,4 14,>
621,6 662,1 =5,=
.13 &REA) E%EN ANAL+SIS
R2ees 4in la56s
" 8 7
24,= 1E,4 14,>
26,3 26,3 26,3
3,> 3,> 3,>
45,1 45,1 45,1
133.3 19.7 1!.1
31E,> 31E,> 31E,>
11,3 11,3 11,3
3=,1 3=,1 3=,1
381.1 381.1 381.1
114=,3 114=,3 114=,3
11=,3 1651, 15E3,1
5,= 55,1 53,1
NAL+SIS TEC*NIB'ES
s
Ret2rn on E2it@ 4r 3?
DeHt4D 1."
-
8/18/2019 PGD_CTM Project Final Worksheet
35/215
E2it@4E 1
Interest Rate4i 1?
Io
54E,36
54E,36
54E,3654E,36
54E,36
54E,36
54E,36
54E,36
54E,36
54E,36
"!:.38 189.1 !.:
DSCR
1
1
E,1E
E,EE
11,14
12,>2
14,EE1,=4
1E,E4
24,23
25,5>
25,54
17.!7
ncial Projections
es 4in La56s
&rot :efore ta+ Corporate ta+ ot after ta+ (&= = =
= = =
463,1 15=,3 4=5,>
4E6,3 161,= 4=6,2
532,> 12,E 414,2
5,> 1>,5 432,1
61E,> 2=1,1 45=,E
624,= 2=2,5 446,5
Net Present%al2e 4NP%
ProtaHilit@In=e- 4PI
-
8/18/2019 PGD_CTM Project Final Worksheet
36/215
62>,> 2=4,1 444,3
633,= 2=5,4 442,E
636,2 2=6,5 441,E
63>, 2=,2 441,1
-
8/18/2019 PGD_CTM Project Final Worksheet
37/215
7.: ALLOT#ENT O
Rupees(in
&R9I"CT C98T C9M&9%"%T &roject Cost
-an* an* 8ite De/elopent 4>,==
:uil*in. an* Ci/il 7orks
Factor$ :uil*in. 65,==
%on Factor$ :uil*in. 35,==
&lant an* Machiner$ 5==,==
Miscellaneous Fi+e* ssets 35,==
Total 893.
Contin.encies >5,==&reoperati/e "+penses 155,==
Total !.
&reliinar$ an* Capital ssue Relate* "+penses 22,==
Mar.in Mone$ 55,==
Total 77.
T9T-&R9I"CT C98T 1.
total 1===,==
> E
1== 1==
3=== 3===
3==,= 3==,=3,> 3,>
16,= 16,=
31E,> 31E,>
11,3 11,3
26,3 26,3
1>,> 1>,>
-
8/18/2019 PGD_CTM Project Final Worksheet
38/215
378. 378.
26,3 26,3
3=,1 3=,1
!3.8 !3.8
T
> E
114=,3 114=,3
361,1 361,1
5E,4 5E,4
1=,3 5,
=E,5 14,1
9 :
1=,3 5,
26,3 26,3
3,> 3,>
45,1 45,1
11:.8 11".
31E,> 31E,>
11,3 11,3
3=,1 3=,1
381.1 381.1
114=,3 114=,3
1534,4 145,>
51,1 4E,2
-
8/18/2019 PGD_CTM Project Final Worksheet
39/215
IRR
9."
&rot for *i/i*en* %et cash ccurals= =
= =
36>,= 4=5,>
36>,3 4=6,2
36,4 414,2
3E4,2 432,1
413,1 45=,E
4=>, 446,5
-
8/18/2019 PGD_CTM Project Final Worksheet
40/215
4=6,5 444,3
4=5,1 442,E
4=4,1 441,E
4=3,3 441,1
-
8/18/2019 PGD_CTM Project Final Worksheet
41/215
PROJECT COST
lakhs)
Cost llocation Cost llocation
4,>= 46,>= 16,16 62,E6
6,5= 6,6 21,>E >E,56
3,5= 36,6 11,E 4>,45
5=,== 511,> 16>,3 6>=,24
3,5= 3=,== 11,E 41,E
8:3. 3. :3.
>,5= >=,==15,5= 15=,==
23=,==
2,2= 23,>= 23,>=
5,5= 53,2= 53,2=
,==
1. 1===,== 1.
=,=46>
1=
1==
3===
3==,=3,>
16,=
31E,>
11,3
26,3
1>,>
ContriH2tion toroject cost in
?
Reise= cost
-
8/18/2019 PGD_CTM Project Final Worksheet
42/215
378.
26,3
3=,1
!3.8
1= 11 12
114=,3 114=,3 114=,3
361,1 361,1 361,1
5E,4 5E,4 5E,4
1,1 =,= =,=
1>, 1E,> 1E,>
1
1,1
26,3
3,>
45,1
11.!
31E,>
11,3
3=,1
381.1
114=,3
141,2
4,2
-
8/18/2019 PGD_CTM Project Final Worksheet
43/215
-
8/18/2019 PGD_CTM Project Final Worksheet
44/215
-
8/18/2019 PGD_CTM Project Final Worksheet
45/215
=,=46>
=
=,=6666666
=,=36666666
=,511>
=,=3
=,6E3==33333
=,=>=,15
=,23
=,=23>
=,=532
=,=
1
=
=
-
8/18/2019 PGD_CTM Project Final Worksheet
46/215
-
8/18/2019 PGD_CTM Project Final Worksheet
47/215
-
8/18/2019 PGD_CTM Project Final Worksheet
48/215
-
8/18/2019 PGD_CTM Project Final Worksheet
49/215
7.1 STRA
R2ees 4in la56s Factor@ &2il=in 43.3!?
+ear
'n
62,E6 >E,56
1 = >6,5 2,EE
= >3,5> 2,EE
3 = >=,5E 2,EE
! = ,5E 2,EE
" = 4,6= 2,EE
8 = 1,61 2,EE
7 = 6>,62 2,EE
9 = 65,63 2,EE
: = 62,64 2,EE
1= 5E,65 2,EE
Lan= an= Site
D8-M
-
8/18/2019 PGD_CTM Project Final Worksheet
50/215
-
8/18/2019 PGD_CTM Project Final Worksheet
51/215
-
8/18/2019 PGD_CTM Project Final Worksheet
52/215
-
8/18/2019 PGD_CTM Project Final Worksheet
53/215
G*T LINE #ET*OD DEPRECIATION STATE#ENT
Non Factor@ &2il=in 41.83? Plant an= #ac6iner@ 41.3!? #FA 4
'n 'n 'n
4>,45 6>=,24 41,E
4,66 =,E 6=E,E= =,34 4=,3E
46,> =,E 53E,5 =,34 3E,==
46,=> =,E 46E,23 =,34 3,6=
45,2E =,E 3E>,>E =,34 36,21
44,5= =,E 32>,56 =,34 34,>1
43,1 =,E 25>,22 =,34 33,42
42,E2 =,E 1>,>> =,34 32,=242,13 =,E 11,55 =,34 3=,62
41,34 =,E 4,21 =,34 2E,23
4=,55 =,E B23,13 =,34 2,>3
D8-M
D8-M
-
8/18/2019 PGD_CTM Project Final Worksheet
54/215
-
8/18/2019 PGD_CTM Project Final Worksheet
55/215
-
8/18/2019 PGD_CTM Project Final Worksheet
56/215
-
8/18/2019 PGD_CTM Project Final Worksheet
57/215
3.3! ?
1=====
+ear
= =
1,4= 5,51 551364,1 1
1,4= 5,51 551364,1
1,4= 5,51 551364,1 3
1,4= 5,51 551364,1 !
1,4= 5,51 551364,1 "
1,4= 5,51 551364,1 8
1,4= 5,51 551364,17
1,4= 5,51 551364,1 9
1,4= 5,51 551364,1 :
1,4= 5,51551364,1
1
SL#Dereciation
R2ees
D8-M
-
8/18/2019 PGD_CTM Project Final Worksheet
58/215
-
8/18/2019 PGD_CTM Project Final Worksheet
59/215
-
8/18/2019 PGD_CTM Project Final Worksheet
60/215
-
8/18/2019 PGD_CTM Project Final Worksheet
61/215
7.1 (RITTEN DO(N %AL'E #ET*OD DEPRE
Factor@ &2il=in 41? Non Factor@ &2il=in 4"?
'n 'n
62,E6 >E,56 4>,45
= >=,6= >,E6 46,=3 2,42
= 2,54 >,=6 43,3 2,3=
= 65,2E ,25 41,54 2,1E
= 5>,6 6,53 3E,46 2,=>
= 52,>> 5,>> 3,4E 1,E
= 4,6= 5,2E 35,62 1,>
= 42,>4 4,6 33,>3 1,>= 3>,55 4,2> 32,14 1,6E
= 34,= 3,>6 3=,54 1,61
= 31,23 3,4 2E,=1 1,53
Lan= an= Site
D7D'
D7D'
-
8/18/2019 PGD_CTM Project Final Worksheet
62/215
-
8/18/2019 PGD_CTM Project Final Worksheet
63/215
-
8/18/2019 PGD_CTM Project Final Worksheet
64/215
-
8/18/2019 PGD_CTM Project Final Worksheet
65/215
IATION STATE#ENT
Plant an= #ac6iner@ 4"? #FA 41? (D% Dereciation
'n 'n 1=====
6>=,24 41,E =,== =
51=,1> 1=,=6 3,61 4,1> 1>5,62 1>5615=
3>2,64 12,55 33,>5 3,6 141,6 14166>,5
2>6,E> E5,66 3=,46 3,3> 1=>,4> 1=>4>44=,625
215,23 1,4 2,42 3,=5 >3,4= >33E646,>43>
161,42 53,>1 24,6> 2,4 64,4= 643EE=6,166
121,= 4=,36 22,21 2,4 4E,EE 4EE>66=,562
E=,>= 3=,2 1E,EE 2,22 3E,=3 3E=2>26,4==6>,1= 22,= 1,EE 2,== 3=,6 3=6442,165
51,=> 1,=3 16,1E 1,>= 24,2E 242>652,513
3>,31 12, 14,5 1,62 1E,3>1E3>444,E=6
3,>125
D7D'
D7D'
-
8/18/2019 PGD_CTM Project Final Worksheet
66/215
-
8/18/2019 PGD_CTM Project Final Worksheet
67/215
-
8/18/2019 PGD_CTM Project Final Worksheet
68/215
-
8/18/2019 PGD_CTM Project Final Worksheet
69/215
7.9 LOAN REPA+#ENT SC*ED'
Rupees (in lakhs)
Rate of nterest
Repa$ent &erio*
Moratoriu &erio*
Ter -oan 6=5 "Jecti/e nterest Rate
R2ees 4in la56s
Kuarter Kuarter
Aear &rincipal (Rs) nterest (Rs) &rincipal (Rs)
1 6=5 36,>4 1 6=5
2 6=5 36,>4 2 6=53 56,1E 34,54 3 52E,3>
4 4E1,56 2E,E4 4 453,5
5 415,E4 25,33 5 3>,13
6 34=,31 2=,3 6 3=2,5=
264,6E 16,12 226,>>
> 1>E,=6 11,51 > 151,25
E 113,44 6,E1 E 5,63
1= 3,>1 2,3= 1= =,==
Total Interest
1=2
(inlakhs)
Aear
-
8/18/2019 PGD_CTM Project Final Worksheet
70/215
-
8/18/2019 PGD_CTM Project Final Worksheet
71/215
-
8/18/2019 PGD_CTM Project Final Worksheet
72/215
-
8/18/2019 PGD_CTM Project Final Worksheet
73/215
LE 7.1 Derecia
Co0onent
12@
Factor$ :uil*in.
1= $ears %on Factor$ :uil*in.
2 $ears &lant an* Machiner$
6,=E@ for half $earl$ installents MF
1=====
nterest (Rs) Financial "+penses (Rs)
36,>4 3,6E 36>E==
36,>4 3,6E 36>E==32,24 66,> 66>=65,625
2,63 5,5 556E53,125
23,=3 4>,364>35>4=,625
1>,42 3E,153E142>,125
13,>2 2E,E4 2EE3615,625
E,21 2=,3 2=25=3,125
4,61 11,51 11513E=,625
=,== 2,3= 23=2>,125
!3.71 423115
-
8/18/2019 PGD_CTM Project Final Worksheet
74/215
-
8/18/2019 PGD_CTM Project Final Worksheet
75/215
-
8/18/2019 PGD_CTM Project Final Worksheet
76/215
-
8/18/2019 PGD_CTM Project Final Worksheet
77/215
ion Rate
SL# ? (D% ?
3,34 1=,==
1,63 5,==
1=,34 25,==
3,34 1=,==
-
8/18/2019 PGD_CTM Project Final Worksheet
78/215
-
8/18/2019 PGD_CTM Project Final Worksheet
79/215
-
8/18/2019 PGD_CTM Project Final Worksheet
80/215
-
8/18/2019 PGD_CTM Project Final Worksheet
81/215
+ear
@ Capacit$ GtiliHation
ctual capacit$ (T&)
aste tire (Rs)
catal$st (Rs)
utilities (Rs)
Ra aterials an* Gtilities (>5@)
&acka.in. (3@)
8alaries an* 7a.es (@)
Factor$ 9/erhea*s (5@)
Total Cost o< Pro=2ction 4Rs
*ninistrati/e e+penses
8ales e+penses
Gross Cost o< Pro=2ction 4Rs
oil
c
steel
tar
Total Sales Reen2e o< Pro=2cts 4Rs
Gross Prot 4Rs
Financial "+penses
551364,1 8-M Depreciation
551364,1 7D' Depreciation
551364,1 Oeratin Prot
551364,1 Prot &e
-
8/18/2019 PGD_CTM Project Final Worksheet
82/215
2 36>E== 8alar$ an* 7a.es
3 66>=66 Depreciation
4 556E53 Factor$ 9/erhea*s an* *in e+penses
5 4>35>41 TOTAL
6 3E142> %ARIA&LE COSTS
2EE3616 Ra aterials an* Gtilities
> 2=25=3 &acka.in. "+penses
E 11513E1 8ales e+penses
1= 23=2>,13 TOTAL
11 423115 ctual capacit$ (T&)
1=== Total 8ales Re/enue of &ro*ucts (Rs)
&rea5 Een 2antit@ sales4Ton
&rea5 Een Caacit@ 4?
FI,ED COSTS 4RsTon
%ARIA&LE COSTS 4RsTon
Total 8ales Re/enue of &ro*ucts (RsLTon)
&rea5 Een 2antit@ sales4Ton
&rea5 Een Caacit@ 4?
= Total cost
8ales Re/enue
'ariale C9&
7orkin. Capital nterest
Fi+e* Capital nterest
Cash 8urplus
Total Sales Reen2e o< Pro=2cts 4Rs
aste tire 4Rs
Aear
Ra Material 8tockn Material 8tock
Finishe* &ro*uct 8tock
Cre*it to custoer
Cre*it fro supplier
%et 7orkin. Capital
nterest o/er 7orkin. Capital (14@)
Aear
i k i l ( )
-
8/18/2019 PGD_CTM Project Final Worksheet
83/215
&ercent 8hare (@)
'olue of Consuption (T&)
'olue of &ro*uction (T&) (ain pro*ucts)
8ales Re/enue (Rupees)
E-en=it2re =2rin @
E-en=it2re =2rin +
I
(ACC45
+ear
1
2
3
4
5
6
>
E
1=
Total
Rupees
Aear
nterest o/er Ter -oan (12@)
nterest o/er 7orkin. Capital (14@)
Financial "+penses
E-en=it2re =2rin @
E-en=it2re =2rin +
I
(ACC45
+ear
-
8/18/2019 PGD_CTM Project Final Worksheet
84/215
1
2
3
4
5
6
>
E
1=
Total
+ear
1
2
3
4
5
6
>
E
1=
Total
-
8/18/2019 PGD_CTM Project Final Worksheet
85/215
GROSS COST OF PROD'
Caacit@> 3 TPA o< Petrole2
1 3 !
6= 65 = 5
1>== 1E5= 21== 225=
1=>===== 11===== 126===== 135=====
1152== 124>== 1344== 144===
324=== 351=== 3>=== 4=5===
113: 117"9 1311! 1!!:
3E66,64=5>> 42E34,1164=5E 462E=,5>>2352E4 4E5>4,=5>>2352E
E255>1,164=6 1==212,E41164 1=E>44,=5>>235 1156E6,4=5>>24
66112E,41164 16223,52E41165 131,64=5>>24 >26411,64=5>>3
13"99.3"3 1!3!!7."993"3 1"!83".:!1178" 18"93".:!1178
E255>1,164=6 1==212,E41164 1=E>44,=5>>235 1156E6,4=5>>24
1=5>=,=5>>24 1145E5,64=5>>2 12341=>,2352E412 132225>,>2352E41
1"":78.!78 18!731!1.178!78 177!3".993": 1:7!7."993"3
22>=>E64,=5>>
23>5==== 25>35== 2>25=== 2E>125==
(or5in Res2lts 4Rs
144===== 156===== 16>===== 1>======
E45==== 1=235== 11=25=== 11>125==
22=== 3==3=== 3234=== 3465===
EE==== 1=25== 1155=== 1235==
781 ::13 31! 3!"1"
1!83.":! 13!3:9"9.93":! 1!!738:!.1178!71 1""7":.!1178!7
32=== =562= 1=513=,>=E 11334,==2
551364,1 551364,1 551364,1 551364,1
1>5615= 14166>,5 1=>4>44=,625 >33E646,>435
!"78":.!:!1 "1997!.73":!1 89171::.98!78 79!7:1.3:78!7
K8!978.!78 K1!3"!9.878!7": 3"1.8938!78 7"!"9."881!7
=,3245 =,3245 =,3245 =,3245
B21=3644,3E=6 B464>62,=45514= 11422E,>1=>434 22>E1>>,=2E61
1!19889.7 131::1.97 13893." 131!:87.39
66313=4,1 56436, 564E1E,4= 55536=3,2>
=,=E1334135 =,65EE55=435 =,66131414E =,65524>36E
141>266,55EE> 131EE1==,2=E=>E1 132262>2,>364>E4 131=4E66,24>446=,44E2E>25E1 =,44E2E>25E1 =,44E2E>25E1 =,44E2E>25E1
.1 .13 .1! .18
=,21414EE6 =,24516E=E6 =,3224>65E =,3=EE2E664
=,6=>E253> =,62436611 =,625652=1=3 =,61EE1331=3
= 2=6312E= 355>1=3>,5E35 3=1EE=,3125
9.88"!3 9.:7"8388:8 :.387!19 9.97:89":33
&REA) E%EN ANAL+SIS
R2ees
1 3 !
36>E== 36>E== 66>=65 625 556E53 125
-
8/18/2019 PGD_CTM Project Final Worksheet
86/215
E255>1,164=6 1>312,E411641 1E>44,=5>>2353 211E6,4=5>>235
551364,1 551364,1 551364,1 551364,1
15>61=,5>>235 11>E36,4=5>>24 1>51162,352E411> 1E>33>>,2352E412
17!3""".98!7 189:13."1178!7 1879!38.79393" 1""3891.:399!
1123E2== 1215>== 131124== 14=4E===
3E66,64=5>> 42E34,1164=5E 462E=,5>>2352E4 4E5>4,=5>>2352E1=5>=,=5>>24 1145E5,64=5>>2 12341=>,2352E412 132225>,>2352E41
18:389!.7": 137"1!:1.78!7": 1!9::9.93":! 1"9871".993":
1>== 1E5= 21== 225=
2612=== 2EE13=== 32214=== 34515===
1,1 1,=4 =,E4 =,>3
6= 65 = 5
E6>4,5 >62,14 51,64 6>E=,53
=52,=5 =52,=5 =52,=5 =52,=5
1534=,== 1534=,== 1534=,== 1534=,==
1,1 1,=4 =,E4 =,>3
=,=3E =,=35 =,=31 =,=2>
3=12624=,5=5E 3=544=5,264=6 31=>35,6=352E 313=>,>132353
CAS* FLO( S
R2e
2=15B16 2=16B1 2=1B1> 2=1B1>
= = 2612=== 2EE13===
= = 126E36>4,=5>>24 13514E1,64=5E
= E133,6 14415E=,15 1554546,
36>E== 36>E== 66>=65,625 556E53,125
B36>E== B>16=633,6 6E>65E,51E1165 >>5===>,41=2E412
2612=== 2EE13=== 32214===
1=>===== 11===== 126=====
(OR)ING CAPIT
Rupe
2=14B15 2=15B16 2=16B1 2=1B1>
= 6E=3=== 4>25= >=535=== 55224= 5E>26= 6442>=
= = 1>6E562,5 2=1335
= = 23=1=== 24E25=
= 1>===== 1E5==== 21=====
= 565524= 1=2E=2,5 111=3E=5
= E133,6 14415E=,15 1554546,
1 2 3 4
2=14B15 2=15B16 2=16B1 2=1B1>
5====== >5==== E6=5==== E655===
-
8/18/2019 PGD_CTM Project Final Worksheet
87/215
= = =,==2 =,=2=
1>== 1E5=
= = 135= 1462,5
= = 2612=== 2EE13===
DISCO'NTED PROFIT FLO( ANAL+SIS TEC*NIB'ESR2ees4in la56s
ar 1 4I1 2==,5
ar 4I 24=,2
!9.9
.
Gross Prot (ACC5 415n Present %al2e
124=6=23,52E41 =,2 1,16 1=6,E4>4>=1>
1343E>5>,>2353 =,2 1,44 E3,332352E412
14436E4,1165 =,2 1,2 >4,14E3>44=4E
155=52E,4116 =,2 2,=6 5,2E26>E>E1
16541364,=5>> =,2 2,4 66,E6E=>>>1
1552== =,2 2,E6 5E,356565
1>6=E=35,2E412 =,2 3,54 52,56>E63111
1E642>=,5>>24 =,2 4,24 46,32524E23
2=66=5,>>235 =,2 5,=> 4=,=216E33>
2=66=5,>>235 =,2 6,=E 33,E51>E>===6
18:"!9:99.3" 65E,6=344>=>5
Financial E
2=14B15 2=15B16 2=16B1 2=1B1>
====== = =
= E133,6 14415E=,15 1554546,
= E133,6 14415E=,15 1554546,
======
DISCO'NTED PROFIT FLO( ANAL+SIS TEC*NIB'ES
R2ees4in la56s
ar 1 4I1 246,>
ar 4I 253,2
"!:.38
.
Gross Prot (ACC5 415n Present %al2e 4P%
-
8/18/2019 PGD_CTM Project Final Worksheet
88/215
566,2 =,2 1,2= 41,>
6=1,6 =,2 1,44 41,>
63,= =,2 1,3 36>,6
62,3 =,2 2,= 324,2
=, =,2 2,4E 2>4,4
=, =,2 2,EE 23,=
=, =,2 3,5> 1E,5=, =,2 4,3= 164,6
=, =,2 5,16 13,2
=, =,2 6,1E 114,3
873." 717."
Gross Prot (ACC5 415n Present %al2e
=,= =,2 1,2 =,=
=,= =,2 1,4 =,=
=,= =,2 1, =,=
=,= =,2 2,1 =,=
=,= =,2 2,5 =,=
=,= =,2 3,= =,=
=,= =,2 3,6 =,=
=,= =,2 4,3 =,=
=,= =,2 5,2 =,=
=,= =,2 6,2 =,=
=,1 .
-
8/18/2019 PGD_CTM Project Final Worksheet
89/215
TION
0 Pro=2cts
" 8 7 9
>= >5 E= E5
24== 255= 2== 2>5=
144===== 153===== 162===== 11=====
1536== 1632== 12>== 1>24==
432=== 45E=== 4>6=== 513===
1!:9"8 1": 189"99 177:"!
52>E=3,52E41165 561E6= 5E5=16,4=5>>235 62>=2,E411>
12341=>,2352E412 131124= 13>>31,64=5>> 14655=3,52E4
>>15=5,>>2352E41 E366== EE16E4,1164=5E 1=46>>,2353
1783117.8!7"99 1973 1:93399.3":!1 :3"78!.71
12341=>,2352E412 131124= 13>>31,64=5>> 14655=3,52E4
141=4=E,411641 14E>56= 15>61=,5>>2352E 164>61,165
7!83".:!1178 1"!19 99:8!.7"99 !781:.!1
31>===== 33>5== 355=== 3625==
1E2===== 2=4===== 216===== 22>=====
126===== 133>5== 1415=== 14E625==
36E6=== 3E2=== 415>=== 43>E===
132==== 14=25== 14>5=== 1565==
38918 3:117 !1!19 !371:
18"!138!.7"99! 17"7" 198:3".:!119 1:8!97.":
12161,1E5 12E>6=,3>> 13>1=3,5>1 146346,4
551364,1 551364,1 551364,1 551364,1
643EE=6,165625 4EE>66=,562 3E=2>26,4==2266 3=6442,165
9989393.!1993" :9:3:7"."1 1:1:"87.813119 11:!"1":.71
::7:9!1.33!31:9" 1!!887: 1!"891".313:" 18!:91.8"
=,3245 =,3245 =,3245 =,3245
323>45>,512E>6E 4=3>E4,3515 4235=,13>21> 5331236,EE5
131919:. 13!83:.8 137!3"91."! 1!18"98.9
562EE24,E= 5>55=2>,16 61E221,44 6613E22,2
=,65E=6444EE =,6=31E613 =,6>1E= =,=>264341
131>12>>,33>>311 134=63E1,5E 13435>=,>52=664 141652>6,111=,44E2E>25E1 =,44E2E>25E1 =,44E2E>25E1 =,44E2E>25E1
.17 .19 .1: .
=,41E5=256E =,46>=21544 =,516535>3E =,565=5=12>4
=,6235236=44 =,63411>1E3 =,65=1221163 =,6===332
3E>22E42,=3125 41E43>E3,5 4241E=34,35 4241E=34,35
9.!":88197 9.7837!3: 7.8"31:83: 7."!198"
" 8 7 9
4>35>4= 625 3E142> 125 2EE3615 625 2=25=3 125
-
8/18/2019 PGD_CTM Project Final Worksheet
90/215
2261=>,2352E411> 24=24= 25431,64=5>>2 26>5=3,52E41
551364,1 551364,1 551364,1 551364,1
2115614,1164=6 224>4= 23>==65,>>2352E4 25122E1,64
1!79:7.77:!1 13:"!17.3 1317:!17.37": 1!!88."
s
14E>56== 15E222== 16>5>>== 1E54==
52>E=3,52E41165 561E6= 5E5=16,4=5>>235 62>=2,E411>141=4=E,411641 14E>56= 15>61=,5>>2352E 164>61,165
18:!:1.:!1178" 17:97 1:!"7."99! :933!.1
24== 255= 2== 2>5=
36>16=== 3E11=== 4141>=== 431E===
=,4 =,66 =,5E =,53
>= >5 E= E5
613,=5 542,22 4>>1,2 4352,51
=52,=5 =52,=5 =52,=5 =52,=5
1534=,== 1534=,== 1534=,== 1534=,==
=,4 =,66 =,5E =,53
=,=25 =,=22 =,=2= =,=1>
31653>4=,=1E116 31E36>E2,225 3221EE44,43=>>24 325=2EE6,63
ATE#ENT
s
2=1>B1E 2=1EB2= 2=2=B21 2=21B22
32214=== 34515=== 36>16=== 3E11===
14>=E2E>,>2352E4 15>61=5,>>2 16E24E12,E41165 1E>22=
1665=3,25 1>=45E,> 1>E3416,35 2==632,E
4>35>4=,625 3E142>,125 2EE3615,625 2=25=3,125
1=E=135,3=14=6 12E52=6,1E3 15==4=55,=>3>235 1=554=3,E5
34515=== 36>16=== 3E11=== 4141>===
135===== 144===== 153===== 162=====
L STATE#ENT
s
2=1>B1E 2=1EB2= 2=2=B21 2=21B22
>62>5= E2=4=== EE25= 1=3545==6E=3== 3632= >234= >2>36=
2151>,5 23=1=== 2444>12,5 25>>625
26>45== 2>625= 3=6>=== 325E5=
225==== 24===== 255==== 2=====
11E1=3,5 1215= 135244=2,5 14331235
1665=3,25 1>=45E,> 1>E3416,35 2==632,E
#AR)ET DETAILS
5 6 >
2=1>B1E 2=1EB2= 2=2=B21 2=21B22
32=5== >=5255= >>5>=5 E435>5 5
-
8/18/2019 PGD_CTM Project Final Worksheet
91/215
=,=2E =,=2> =,=2 =,=26
21== 225= 24== 255=
155 16>,5 1>== 1E12,5
32214=== 34515=== 36>16=== 3E11===
Ret2rn on E2it@ 4r 3?
DeHt4D 1."
E2it@4E 1
Interest Rate4i 1?
Io IRR
4>= B33,=515213 =,222>=E33=6
4>= B3>6,66641 =,1E44424=2
4>= B3E5,>5=6156 =,15311215
4>= B4=4,2=31 =,156>31>1=4
4>= B413,=3=E121 =,13E51>E331
4>= B42=,6243243 =,1236EE3243
4>= B42,4321=3 =,1=E51645=6
4>= B433,6245 =,=E65156
4>= B43E,2E>231 =,=>4E62=1E
4>= B446,=4>1=2 =,==3312=>
!9 K!1!.3:88 .137!17!!89 6,56
1=====
enses
2=1>B1E 2=1EB2= 2=2=B21 2=21B22
= = = =
1665=3,25 1>=45E,> 1>E3416,35 2==632,E
1665=3,25 1>=45E,> 1>E3416,35 2==632,E
Ret2rn on E2it@ 4r 3?
DeHt4D 1."
E2it@4E 1
Interest Rate4i 1?
Io IRR
Net Present%al2e
ProtaHilit@ In=e-4PI
Net Present%al2e 4NP%
ProtaHilit@ In=e-4PI
-
8/18/2019 PGD_CTM Project Final Worksheet
92/215
54E,36
54E,36
54E,36
54E,36
54E,36
54E,36
54E,3654E,36
54E,36
54E,36
"!:.38 189.1 !.: 9."
Io IRR
=,=
=,=
=,=
=,=
=,=
=,=
=,=
=,=
=,=
=,=
=,= . !.: 2>,5
Net Present%al2e
ProtaHilit@ In=e-4PI
-
8/18/2019 PGD_CTM Project Final Worksheet
93/215
&articulars
: 1 11 7aste &lastics
1== 1== 1== Catal$st
3=== 3=== 3=== Gtilities
1>====== 1>====== 1>======
1E2=== 1E2=== 1E2===
54==== 54==== 54==== &articulars
1973 1973 1973 7aste &lastics
66112E,4116 66112E,4116 66112E,41165 Catal$st
1542635,2E41 1542635,2E41 1542635,2E412 Gtilities
11=1>>2,352E 11=1>>2,352E 11=1>>2,352E4
378!7.8 378!7.8 378!7.":
1542635,2E41 1542635,2E41 1542635,2E412 1
163=11,64 163=11,64 163=11,641 &articulars
"3!3:!.1 "3!3:!.1 "3!3:!.119 7aste tire
Catal$st
3E5==== 3E5==== 3E5==== Gtilities
24====== 24====== 24======
155==== 155==== 155==== 3
462==== 462==== 462==== &articulars
165==== 165==== 165==== 7aste tire
!8 !8 !8 Catal$st
8787".99 8787".99 8787".99 Gtilities
1545>E,E6 162>33,16 164>63,>6 164>63,>6
551364,1 551364,1 551364,1
242>652,513 1E3>444,E=6 1E3>,444E=66
1:77"1.9 1:8"9.8 1:8!77.:
19:3!83.! 19"7"!7.9 "::3."77
=,3245 =,3245 =,3245
5>132>,>41 6=226,3262 6655463,1=>>
1!8"797.! 1!!981!8.! 139"8379.31
=EE422,E4 6E34>2,3= 63=5=14,21
=,3253E3521 =,243=31E> =,6E2>1>E156
1465=>6,3=E 144>6145,62 13>563,61>=,44E2E>25E1 =,44E2E>25E1 =,44E2E>25E1
.1 .1 .1
=,61356441>E =,613144>54 =,613=>425>
=,6E3=362>3E =,6>524>13E =,65545>1E>
4241E=34,35 4241E=34,35 4241E=34,35
8.9979:787" 8.9979:787" 8.9979:787"1
: 1 11
11513E= 625 23=2> 125 423115
-
8/18/2019 PGD_CTM Project Final Worksheet
94/215
2>2635,2E412 2>2635,2E412 3=36=E,4116
551364,1 551364,1 551364,1
264451,641 264451,641 216>5=44,=5E
118::7.87 1797:".17 1426434=,11>
1>32=== 1>32=== 3432===
66112E,4116 66112E,4116 12112E,41165163=11,64 163=11,64 323=11,64=6
11"81!1.19 11"81!1.19
3=== 3=== 3==
46=2==== 46=2==== 5>=2===
=,4 =,43
1== 1==
3>6,64 356E,6=
=52,=5 =52,=5
1534=,== 1534=,==
=,4 =,43
=,=16 =,=14
32>6=4>,>43 31>64E36,343
2=22B23 2=23B24 2=24B25 2=25B26
4141>=== 431E=== 46=2==== 46=2====
1E=4=52,=5E 2==E>334,11> 21156141,165 21156141,165
211E32E,45 22322>6 225E131 225E131
11513E=,625 23=2>,125 = =
1E1=652,>66 2115>1=1,5 226=42,>235 226=42,>235
431E=== 46=2==== 46=2==== 46=2====
11===== 1>====== 1>====== 1>======
2=22B23 2=23B24 2=24B25 2=25B26
1=E2E5= 115=5=== 115=5=== 115=5===>43>= E2=4== E2=4== E2=4==
23243,5 2>625= 2>625= 2>625=
34515== 364325= 3>35=== 3>35===
2>5==== 3====== 3====== 3======
1513>=6,5 15E44E== 1613665= 1613665=
211E32E,45 22322>6 225E131 225E131
E 1= 11 12
2=22B23 2=23B24 2=24B25 2=25B26
1=1E44 =5 11>E3> 455 12E6>12 3==5 142655>3 5
-
8/18/2019 PGD_CTM Project Final Worksheet
95/215
=,=25 =,=24 =,=23 =,=21
2== 2>5= 3=== 3===
2=25 213,5 225= 225=
4141>=== 431E=== 46=2==== 46=2====
"+pen*iture *urin. 1st Aear (1) 246,>
"+pen*iture *urin. 2n* Aear (2) 253,2
5==
= 544,424
=,152
=,E2
2=22B23 2=23B24 2=24B25 2=25B26
= = = =
211E32E,45 22322>6 225E131 225E131
211E32E,45 22322>6 225E131 225E131
-
8/18/2019 PGD_CTM Project Final Worksheet
96/215
=,E32
1,5515=2666
-
8/18/2019 PGD_CTM Project Final Worksheet
97/215
1 TPD o< Petrole20 Pro=2cts
Consuption (T) Rate (Rs,LT) Cost (Rs,)
1,25 1==== 125==
=,==1 3===== 3==
=,3 >=== 24==
1 TPD o< Petrole20 Pro=2cts
Consuption (T) Rate (Rs,LT) Cost (Rs,)
1 6=== 6===
=,===4 16==== 64
=,=6 3=== 1>=
6244
TPA o< Petrole20 Pro=2cts/ or5in Da@s@ear3
Consuption (T) Rate (Rs,LT) Cost (Rs,)
15= E=== 135====
=,6 16==== E6===
E= 3=== 2====
116===
TPA o< Petrole20 Pro=2cts/ or5in Da@s@ear3
Consuption (T) Rate (Rs,LT) Cost (Rs,)
3=== 6=== 1>======
1,2 16==== 1E2===
1>= 3=== 54====
222=== 1>32===
=,4 4======
=,35
=,14
=,11
=,6
=,==4
1>32===
Aear 1 FI,ED COSTS
nterest 3654=== 3654===
-
8/18/2019 PGD_CTM Project Final Worksheet
98/215
8alar$ an* 7a.es 21=65>>,2353 223>25=
Depreciation 3>14=3,4 3>14=3,4
Factor$ 9/erhea*s an* *in e+penses 36112E4,116 3>3===
TOTAL 131"39".7" 13"18"3.!
%ARIA&LE COSTS
Ra aterials an* Gtilities 255>==== 21>5=
&acka.in. "+penses E=2>23,52E41 E5E25=8ales e+penses 24=52E,411> 255>===
TOTAL 99:3".:! 38:8
ctual capacit$ (T&) 1>= 1E5
Total 8ales Re/enue of &ro*ucts (Rs) E122=== E6E2>6>,5
&rea5 Een 2antit@ sales4Ton =,21 =,2=
&rea5 Een Caacit@ 4? 6 6,5
FI,ED COSTS 4RsTon 3=3,>1 6E2>5,4=
%ARIA&LE COSTS 4RsTon 16=5=1,E6 15415,3>
Total 8ales Re/enue of &ro*ucts (RsLTon) 5=6>16,6 4E==,1E
&rea5 Een 2antit@ sales4Ton 211=,=4 2=3E,>>
&rea5 Een Caacit@ 4? =,=== 6,EE6
FI,ED COSTS
nterest 36,5 36,5
8alar$ an* 7a.es 21,1 22,4
Depreciation 3,> 3,>
Factor$ 9/erhea*s an* *in e+penses 36,1 3>,4
TOTAL 131,5 135,1
%ARIA&LE COSTS
Ra aterials an* Gtilities 255,> 21,>
&acka.in. "+penses E,= E,6
8ales e+penses 24,1 25,6
TOTAL 2>>,E 3=,=
Total 8ales Re/enue of &ro*ucts (Rs) E12,2 E6E,2>6>5
13 INDIA2=25B26 2=14
156E2141 E 2=15
-
8/18/2019 PGD_CTM Project Final Worksheet
99/215
=,=1E 2=16
3=== 2=1
225= 2=1>
114=335= 2=1E
2=2=
2=21
2=22
2=23
2=24
2=25
2=26
2=2
-
8/18/2019 PGD_CTM Project Final Worksheet
100/215
-
8/18/2019 PGD_CTM Project Final Worksheet
101/215
#ass Halance oer s@ste0 +ear
INP'T 1
1 T 7aste &lastics 2
O'TP'T 3
=,1 T Caron Char 4
=,1 T ;$*rocaron as 5
=,1 T asoline 6
=,46 T Diesel
=,1 T Fuel 9ils >
t. conersion to Petrole20 Pr E
1=
1" TPA o< Petrole20 Pro=2cts/ or5in Da@s@ear3
&articulars &ro*uction (T) Rate (Rs,LT) Cost (Rs,)
asoline 31>,5 !3 13====
Diesel >62,5 !1" 35E35=
Fuel 9ils 31>,5 " 11>5
Caron Char 1>,5 1" 2>125=
63,5
125
1>====== 63,5
1E2=== 35
54====
13 TPA o< Petrole20 Pro=2cts/ or5in Da@s@ear3
&articulars &ro*uction (T) Rate (Rs,LT) Cost (Rs,)
24====== oil 12== 24======
155==== c 1=5= 1" 155====
462==== steel 42= 11 462====
165==== tar 33= " 165====
3=== 46=2====
35==== 35 16,66666666 ""888.8887
26==== 26 14,2>5142>6
12==== 12 26,1E=461E1>== >==== > 15,151515152
>1 2,2E4322E4
&REA) E%EN ANAL+SIS
R2ees
3 ! " 8 7
331143 5 2>546> 5 23EE3 5 1E411> 5 14>443 5
-
8/18/2019 PGD_CTM Project Final Worksheet
102/215
236EE11,64=5E 25=153,52E4 2633235,2E41165 2633235,2E41 2633235,2E41
3>14=3,4 3>14=3,4 3>14=3,4 3>14=3,4 3>14=3,4
4=62=5,>>2353 42>>411,64 451411,64=5>>2 451411,641 451411,641
13""!"9."!71 13!878.1: 13388:3.9!119 198::!3.9! 1!131:3.9!
2>5== 3=3625= 31E5=== 31E5=== 31E5===
1=1566,4=5>>2 1=21=2,E412 112>52E,411641 112>52E,411> 112>52E,411>2=>4=,5>>2353 2>5>E41,165 3==E411,64=5>> 3==E411,64 3==E411,64
3"18!7."99 3!37:!.1 3811:!1.178!7 3811:!1.19 3811:!1.19
21= 225 24= 255 2=
1=263=35 1=>332=62,5 114=335= 114=335= 114=335=
=,1E =,1> =,1 =,1 =,16
,5 > >,5 E
644=6,E5 5E61,45 5552,>E 5=4=,3 45E4,E
1546E,5 15246,>6 15=4=,5E 14161E,3> 13351,63
4>>16,= 4>145,>3 4514=,63 441E1,1> 42234,22
1E2>,66 1>13,3 11=,2E 1651,6 15E3,=5
64,2>E 6=,45> 5,=1= 55,=56 53,1=2
33,1 2>,5 24,= 1E,4 14,>
23, 25,= 26,3 26,3 26,3
3,> 3,> 3,> 3,> 3,>
4=,6 42,E 45,1 45,1 45,1
135,3 134,3 133,3 12>, 124,1
2>,> 3=3,> 31E,> 31E,> 31E,>
1=,2 1=, 11,3 11,3 11,3
2,1 2>,6 3=,1 3=,1 3=,1
325,= 343,1 361,1 361,1 361,1
1=26,3=35 1=>3,32=625 114=,335 114=,335 114=,335
&lastics MMT& 1=@ 7& MMT& 7& (MT&)12,5 1,25 5 5======
13 5 1 35 5 5 55=====
-
8/18/2019 PGD_CTM Project Final Worksheet
103/215
15,125 1,5125 6,=5 6=5====
16,635 1,6635 6,655 6655===
1>,3=125 1,>3=125 ,32=5 32=5==
2=,13135 2,=13135 >,=5255 >=5255=
22,1445125 2,21445125 >,>5>=5 >>5>=5
24,35>E635 2,435>E635 E,435>55 E435>5,5
26,E4>6=125 2,6E4>6=125 1=,1E44=5 1=1E44,=5
2E,44346135 2,E4434613> 11,>E3>455 11>E3>,455
32,421>=513 3,2421>=51 12,E6>123==5 12E6>12,3=1
35,663E5>>264 3,5663E5>>26 14,2655>353=6 142655>3,531
3E,23=354=E 3,E23=354=E 15,6E2141>>36 156E2141,>>4
43,1533E=1EE 4,31533E=1> 1,261356=2 1261356,=2
-
8/18/2019 PGD_CTM Project Final Worksheet
104/215
-
8/18/2019 PGD_CTM Project Final Worksheet
105/215
Cororate ta- rate 4?
33,66 +ear
33,66 ctual capacit$ (T&)
33,66 ross Cost of &ro*uction (Rs)
33,EE oil (Rs Lton)
33,EE C: (RsLton)
33,EE steel (RsL ton)
33,EE tar(RsLton)
32,44
32,45
32,45
8lt
"lt
"lt
1.")
!lt
35
1"5
3)
9 : 1
1=26> 5 5=E3 5 1141> 5
-
8/18/2019 PGD_CTM Project Final Worksheet
106/215
2633235,2E41165 2633235 2633235,2E41165
3>14=3,4 3>14=3 3>14=3,4
451411,64=5>>2 451411> 451411,64=5>>2
11:"8!!3.9!1178" 1E7 11!:!3.9!1178"
31E5=== 31E5=== 31E5===
112>52E,411641 112>52E 112>52E,4116413==E411,64=5>> 3==E412 3==E411,64=5>>
3811:!1.178!78 !E7 3811:!1.178!78
2>5 3== 3==
114=335= 1,1"==> 114=335=
=,15 =,15 =,14
E,5 1= 1=
41E52,43 3>332,31 36>=E,>1
12612,= ??? 12=36,4
4==11>,42 ??? 3>=112,5=
1534,44 145,>2 141,2=
51,14> 4E,1E4 4,24=
1=,3 5, 1,1
26,3 26,3 26,3
3,> 3,> 3,>
45,1 45,1 45,1
11E,6 115,= 11=,4
31E,> 31E,> 31E,>
11,3 11,3 11,3
3=,1 3=,1 3=,1
361,1 361,1 361,1
114=,335 114=,33> 114=,335
+ear
FI,ED COSTS
nterest
8alar$ an* 7a.es
Depreciation
Factor$ 9/erhea*s an* *in e+penses
TOTAL
%ARIA&LE COSTS
Ra aterials an* Gtilities
&acka.in. "+penses8ales e+penses
TOTAL
-
8/18/2019 PGD_CTM Project Final Worksheet
107/215
Total Sales Reen2e o< Pro=2cts
:reak "/en #uantit$ sales(Ton)
:reak "/en Capacit$ (@)
-
8/18/2019 PGD_CTM Project Final Worksheet
108/215
-
8/18/2019 PGD_CTM Project Final Worksheet
109/215
Gross Cost o< Pro=2ction o< Pro=2cts
1 3 ! " 8
1>== 1E5= 21== 225= 24== 255=
152=5E6,41 1643141 14=3=5,>> 1E==4=,5>> 2=24635,2E4 21541>==
2>2=,>2 2>2=,>2 2>2=,>2 2>2=,>2 2>2=,>2 2>2=,>2
246>,22 246>,22 246>,22 246>,22 246>,22 246>,22
E>,2E E>,2E E>,2E E>,2E E>,2E E>,2E
5,3 5,3 5,3 5,3 5,3 5,3
-
8/18/2019 PGD_CTM Project Final Worksheet
110/215
3==
&REA) E%EN ANAL+SIS
R2ees 4in la56s1 3 ! " 8
36,5 36,5 33,1 2>,5 24,= 1E,4
21,1 22,4 23, 25,= 26,3 26,3
3,> 3,> 3,> 3,> 3,> 3,>
36,1 3>,4 4=,6 42,E 45,1 45,1
131." 13".1 13".3 13!.3 133.3 19.7
255,> 21,> 2>,> 3=3,> 31E,> 31E,>
E,= E,6 1=,2 1=, 11,3 11,324,1 25,6 2,1 2>,6 3=,1 3=,1
99 : 37 3" 3!3 1 381 1 381 1
-
8/18/2019 PGD_CTM Project Final Worksheet
111/215
E12,3 E6E,3 1=26,3 1=>3,3 114=,3 114=,3
211=,= 2=3E,E 1E2>, 1>13, 11=,3 1651,
=,= 6>,= 64,3 6=,5 5,= 55,1
-
8/18/2019 PGD_CTM Project Final Worksheet
112/215
-
8/18/2019 PGD_CTM Project Final Worksheet
113/215
7 9 : 1
2== 2>5= 3=== 3===
22>=>E64,=6 24=612E,412 253432E4,116 253432E4,1
2>2=,>2 2>2=,>2 2>2=,>2 2>2=,>2
246>,22 246>,22 246>,22 246>,22
E>,2E E>,2E E>,2E E>,2E
5,3 5,3 5,3 5,3
-
8/18/2019 PGD_CTM Project Final Worksheet
114/215
7 9 : 1
14,> 1=,3 5, 1,1
26,3 26,3 26,3 26,3
3,> 3,> 3,> 3,>
45,1 45,1 45,1 45,1
1!.1 11:.8 11". 11.!
31E,> 31E,> 31E,> 31E,>
11,3 11,3 11,3 11,33=,1 3=,1 3=,1 3=,1
381 1 381 1 381 1 381 1
-
8/18/2019 PGD_CTM Project Final Worksheet
115/215
114=,3 114=,3 114=,3 114=,3
15E3,1 1534,4 145,> 141,2
53,1 51,1 4E,2 4,2
-
8/18/2019 PGD_CTM Project Final Worksheet
116/215
-
8/18/2019 PGD_CTM Project Final Worksheet
117/215
+ear Prot a 141,>3
2=1>B1E 131,EE
2=1EB2= 132,26
2=2=B21 131,=5
2=21B22 131,>1
2=22B23 134,=6
2=23B24 13,44
2=24B25 141,65
2=25B26 146,51
2=26B2 144,>6
TOTAL 1373.!7
-
8/18/2019 PGD_CTM Project Final Worksheet
118/215
-
8/18/2019 PGD_CTM Project Final Worksheet
119/215
-
8/18/2019 PGD_CTM Project Final Worksheet
120/215
-
8/18/2019 PGD_CTM Project Final Worksheet
121/215
DE&T SER%ICE CO%ERAGE RATIO 4DSCR
R'PEES 4in La56s
SL# Dereciation Interest on Ter0 Loan
0 3,6E
= 3,6>E
5,51 66,>
5,51 5,5
5,51 4>,36
5,51 3E,15
5,51 2E,E4
5,51 2=,3
5,51 11,51
5,51 2,3=
5,51 =,==
5,51 =,==
7"".1! !3.71
-
8/18/2019 PGD_CTM Project Final Worksheet
122/215
-
8/18/2019 PGD_CTM Project Final Worksheet
123/215
-
8/18/2019 PGD_CTM Project Final Worksheet
124/215
-
8/18/2019 PGD_CTM Project Final Worksheet
125/215
Princial Rea@0ent DSCR
= 1
= 1
3,>1 2,2
3,>1 2,>
3,>1 2,E
3,>1 3,1E
3,>1 3,5=
3,>1 3,E3
3,>1 4,55
3,>1 5,4
3,>1 5,>
3,>1 5,>3
379.13 !.9
-
8/18/2019 PGD_CTM Project Final Worksheet
126/215
-
8/18/2019 PGD_CTM Project Final Worksheet
127/215
-
8/18/2019 PGD_CTM Project Final Worksheet
128/215
-
8/18/2019 PGD_CTM Project Final Worksheet
129/215
+ear &ro*uction (T&)
2=15B16 =
2=16B1 =
2=1B1> 1>==
2=1>B1E 1E5=
2=1EB2= 21==
2=2=B21 225=
2=21B22 24==
2=22B23 255=
2=23B24 2==
2=24B25 2>5=
2=25B26 3===
2=26B2 3===
3===
+ear &ro*uction (T&)
2=14B15 =
2=15B16 =
2=16B1 1>==
2=1B1> 1E5=
2=1>B1E 21==
2=1EB2= 225=
2=2=B21 24==
2=21B22 255=
2=22B23 2==
2=23B24 2>5=
2=24B25 3===
2=25B26 3===
1=====
34>12===
313===
4=614===43515===
46416===
4E31===
5221>===
5511E===
5>=2====
5>=2====
5>=2===
-
8/18/2019 PGD_CTM Project Final Worksheet
130/215
Aear 2=14B15
Ra Material 8tock =,=
n Material 8tock =,=
Finishe* &ro*uct 8tock =,=
Cre*it to custoer =,=
Cre*it fro supplier =,=
%et 7orkin. Capital =,=
nterest o/er 7orkin. Capital (14@) =,=
Aear 1
2=14B15
7aste &lastics Market &otential (T&) 5======
&ercent 8hare (@) =
'olue of Consuption (T&)
'olue of &ro*uction (T&) =
8ales Re/enue (Rupees) =
-
8/18/2019 PGD_CTM Project Final Worksheet
131/215
-
8/18/2019 PGD_CTM Project Final Worksheet
132/215
-
8/18/2019 PGD_CTM Project Final Worksheet
133/215
Financial
R2es
Capacit$ GtiliHation (@) 8ales ross Cost of &ro*uction
= = =
= = =
6= 34>,1 152,1
65 3,1 164,
= 4=6,1 1,4
5 435,2 1E=,1
>= 464,2 2=2,
>5 4E3,2 215,4
E= 522,2 22>,1
E5 551,2 24=,>
1== 5>=,2 253,4
1== 5>=,2 253,4
Financial
R2es
Capacit$ GtiliHation (@) 8ales ross Cost of &ro*uction
= = =
= = =
6= E122=== 346=>235,2E4116
>5 E6E2>6>,5 36125=
E= 1=263=35 3>E34264,=5>>24
E5 1=>332=62,5 41=E2E,41164
1== 114=335= 4326=2E4,11641
1== 114=335= 4326=2E4,11641
1== 114=335= 4326=2E4,11641
1== 114=335= 4326=2E4,11641
1== 114=335= 4326=2E4,11641
1== 114=335= 4326=2E4,11641
1>==
1E5= 152=5E6,4=5>>2
21==225= 152=5E6,4=5>>2
24== 1643141,164=6
255= 14=3=5,>>2352E
2== 1E==4=,5>>2353
2>5= 2=24635,2E4116
3=== 21541>==
3=== 22>=>E64,=5>>24
3=== 24=612E,41164
253432E4,11641
253432E4,11641253432E4,11641
-
8/18/2019 PGD_CTM Project Final Worksheet
134/215
(OR)I
2=15B16 2=16B1 2=1B1>
22>,1 242,3 256,6
1>,2 1E,4 2=,5
=,= 6=,6 64,1
=,= 6,= >=,>
4=,= 42,5 45,=
2=6,3 355,> 3,=
2>,E 4E,> 52,>
2 3 4
2=15B16 2=16B1 2=1B1>
55===== 6=5==== 6655===
= =,=5 =,=5
3=== 31>,5
= 24== 255=
= E12,3 E6E,3
-
8/18/2019 PGD_CTM Project Final Worksheet
135/215
-
8/18/2019 PGD_CTM Project Final Worksheet
136/215
-
8/18/2019 PGD_CTM Project Final Worksheet
137/215
Projections
4in La56s
ross &rot 9peratin. &rot &rot :efore ta+ Corporate ta+
= = = =
= = = =
1E6,1 11,3 ,2 2,3
212,4 12E,> 63, 2=,
22>, 152,2 11E,2 3>,
245,1 16>,4 16=,5 52,1
261,4 1>4, 1E5,> 63,5
2,> 2==,E 226,5 3,5
2E4,1 21,2 253, >2,3
31=,4 233,5 2>,3 E=,3
326,> 24E, 3==,E E,
326,> 24E,6 3=5,> EE,2
Projections
4in La56s
ross &rot 9peratin. &rot &rot :efore ta+ Corporate ta+
= = = =
= = = =
5661>64,=5>>2 51>26461,3=5>>2 46314364,=5>>2 15=2E=11,34=5>>
6=1543,5 52E3E253,5 4E62>=1,E 161=4513,6655
636E611=,2E411> 54E33361,4E=EE3 532>4E3=,64=EE3 12E=E5E,EE3==21
6234>3,=>>235 5>151=1,=444>5 5>31>,6=6E>5 1>5=644,3>466
=3455,>>2353 61416>4=,5EE> 61E63=,3>2353 2=111311,45535
=3455,>>2353 6111EE=,35353 624=1=5,352==E 2=24E143,11=2
=3455,>>2353 61=533>,66E>53 62>>31>5,654451 2=4=55E3,44>6E5
=3455,>>2353 61=533>,66E>53 633=136>,3E6523 2=5412E4,=44616
=3455,>>2353 61=533>,66E>53 63621=E,6=56 2=645=4=,3>44=E6
=3455,>>2353 61=533>,66E>53 63>6635,=54>E 2=2463>,=5314
1643141,1641 14=3=5,>>2353 1E==4=,5>>235 2=24635,2E4116
152,=5E64=5E
164,3141164
1,4=3=5>>235
1E=,=4=5>>24
2=2,46352E412
215,41>
22>,=>E64=5>>
24=,612E4116
253,432E41165
253,432E41165253,432E41165
-
8/18/2019 PGD_CTM Project Final Worksheet
138/215
G CAPITAL STATE#ENT
Rupees (in -akhs)
2=1>B1E 2=1EB2= 2=2=B21 2=21B22
2=,> 2>5,1 2>5,1 2>5,1
21, 22,> 22,> 22,>
6, 1,3 1,3 1,3
>5,5 E=,3 E5,= E5,=
4,5 5=,= 5=,= 5=,=
3E>,2 41E,4 424,2 424,2
55,> 5>, 5E,4 5E,4
AR)ET DETAILS
5 6 >
2=1>B1E 2=1EB2= 2=2=B21 2=21B22
32=5== >=5255= >>5>=5 E435>5,5
=,=5 =,=4 =,=4 =,=4
335 3562,5 35= 35=
2== 2>5= 3=== 3===
1=26,3 1=>3,3 114=,3 114=,3
-
8/18/2019 PGD_CTM Project Final Worksheet
139/215
-
8/18/2019 PGD_CTM Project Final Worksheet
140/215
-
8/18/2019 PGD_CTM Project Final Worksheet
141/215
&rot after ta+ (&T) &rot for *i/i*en* %et cash ccurals
= = =
= = =
1E=,5 114,E 1E=,5
1>4, 1=E,2 1>4,
1>E,= 113,5 1>E,=
1E1,> 116,3 1E1,>
1E6, 121,1 1E6,
2=3,= 12,5 2=3,=
21=,4 134,E 21=,4
21>, 143,1 21>,
22,6 152,1 22,6
225,E 15=,4 225,E
&rot after ta+ (&T) &rot for *i/i*en* %et cash ccurals
= = =
= = =
4=5>>53,35>>235 36E44E,E5>>235 4=5>>51,32E>>=E
4=616143,13345 36>343E,3345 4=616141,1=2642>
41423>=4,>EEE=5 36424=1,4EEE=5 41423>=2,>26>==3
432=5>6=,=66=1>6 3E424456,666=1>6 432=5>5,E=5256
45=>6E32,2524=44 413=552>,>524=44 45=>6E2E,EE>=5>
4465216,646626 4=>=64,246626 44652165,414=16
4442E1E,324E>35 4=64E3,E24E>35 4442E1E5,1=35236
442E34E,=251>13 4=512=E3,6251>13 442E34E4,>1=5=65
441>E5=,6>54434 4=4=>34,2>54434 441>E4>,45E55E
4411=152,36453>E 4=32>4>,E6453>E 4411=15=,15E=313
21541>== 22>=>E64,=5>>24 24=612E,41164 253432E4,11>
-
8/18/2019 PGD_CTM Project Final Worksheet
142/215
2=22B23 2=23B24 2=24B25 2=25B26
2>5,1 2>5,1 2>5,1 2>5,1
22,> 22,> 22,> 22,>
1,3 1,3 1,3 1,3
E5,= E5,= E5,= E5,=
5=,= 5=,= 5=,= 5=,=
424,2 424,2 424,2 424,2
5E,4 5E,4 5E,4 5E,4
E 1= 11 12
2=22B23 2=23B24 2=24B25 2=25B26
1=1E44,=5 11>E3>,455 12E6>12,3==5 142655>3,5
=,=3 =,=3 =,=3 =,=3
35= 35= 35= 35=
3=== 3=== 3=== 3===
114=,3 114=,3 114=,3 114=,3
-
8/18/2019 PGD_CTM Project Final Worksheet
143/215
-
8/18/2019 PGD_CTM Project Final Worksheet
144/215
-
8/18/2019 PGD_CTM Project Final Worksheet
145/215
+ear 8ales ross Cost of &ro*uction
2=14B15 = =
2=15B16 = =
2=16B1 E12,3 346,1
2=1B1> E6E,3 36,
2=1>B1E 1=26,3 3>E,3
2=1EB2= 1=>3,3 411,=
2=2=B21 114=,3 432,6
2=21B22 114=,3 432,6
2=22B23 114=,3 432,6
2=23B24 114=,3 432,6
2=24B25 114=,3 432,6
2=25B26 114=,3 432,6
1 2
8ales Re/enue =,= =,=
'ariale C9& =,= =,=
7orkin. Capital nterest =,= 2>,E
Fi+e* Capital nterest 36,5 36,5
Cash 8urplus B36,5 B65,4
3266=5,>>2352E
253432E4,11641 253432E4,12 24E6=4,E22352E
325=EE=3,54463
21E623,213352
1=54E463,1=>>13
21E623>,311416
14411=14,211416
-
8/18/2019 PGD_CTM Project Final Worksheet
146/215
-
8/18/2019 PGD_CTM Project Final Worksheet
147/215
-
8/18/2019 PGD_CTM Project Final Worksheet
148/215
-
8/18/2019 PGD_CTM Project Final Worksheet
149/215
Financial Projections
R2es 4in La56s
ross &rot 9peratin. &rot &rot :efore ta+ Corporate ta+
= = = =
= = = =
566,2 51>,3 463,1 15=,3
6=1,6 52E,4 4E6,3 161,=
63,= 54E,3 532,> 12,E
62,3 5>1,> 5,> 1>,5
=, 614,2 61E,> 2=1,1
=, 611,2 624,= 2=2,5
=, 61=,5 62>,> 2=4,1
=, 61=,5 633,= 2=5,4
=, 61=,5 636,2 2=6,5
=, 61=,5 63>, 2=,2
C8; F-97 8TT"M"%T
Rupees (in -akhs)
3 4 5 6
E12,3 E6E,3 1=26,3 1=>3,3
2>>,E 3=,= 325,= 343,1
4E,> 52,> 55,> 5>,
33,1 2>,5 24,= 1E,4
54=,4 5>1,= 621,6 662,1
-
8/18/2019 PGD_CTM Project Final Worksheet
150/215
-
8/18/2019 PGD_CTM Project Final Worksheet
151/215
-
8/18/2019 PGD_CTM Project Final Worksheet
152/215
-
8/18/2019 PGD_CTM Project Final Worksheet
153/215
&rot after ta+ (&T) &rot for *i/i*en* %et cash ccurals
= = =
= = =
4=5,> 36>,= 4=5,>
4=6,2 36>,3 4=6,2
414,2 36,4 414,2
432,1 3E4,2 432,1
45=,E 413,1 45=,E
446,5 4=>, 446,5
444,3 4=6,5 444,3
442,E 4=5,1 442,E
441,E 4=4,1 441,E
441,1 4=3,3 441,1
> E 1=
114=,3 114=,3 114=,3 114=,3
361,1 361,1 361,1 361,1
5E,4 5E,4 5E,4 5E,4
14,> 1=,3 5, 1,1
=5,= =E,5 14,1 1>,
-
8/18/2019 PGD_CTM Project Final Worksheet
154/215
-
8/18/2019 PGD_CTM Project Final Worksheet
155/215
-
8/18/2019 PGD_CTM Project Final Worksheet
156/215
-
8/18/2019 PGD_CTM Project Final Worksheet
157/215
11 12
114=,3 114=,3
361,1 361,1
5E,4 5E,4
=,= =,=
1E,> 1E,>
-
8/18/2019 PGD_CTM Project Final Worksheet
158/215
-
8/18/2019 PGD_CTM Project Final Worksheet
159/215
-
8/18/2019 PGD_CTM Project Final Worksheet
160/215
-
8/18/2019 PGD_CTM Project Final Worksheet
161/215
R988 C98T 9F &R9DGCT9%
Capacit$! 3=== T& of &etroleu &ro*ucts
Aear 1 2
@ Capacit$ GtiliHation >= >5
ctual capacit$ (T&) 24== 255=
aste plastics (Rs) 24====== 255=====
catal$st (Rs) 3===== 31>5=
utilities (Rs) 12>==== 136====
Ra aterials an* Gtilities (>5@) 255>==== 21>5=
&acka.in. (3@) E=2>23,52E411 E5E25=
8alaries an* 7a.es (@) 21=65>>,2352E41 223>25=
Factor$ 9/erhea*s (5@) 15=4=5,>>2353 15E>5=
Total Cost of &ro*uction (Rs) 3==E411,64=5E 31E5===
*ninistrati/e e+penses 21=65>>,2352E41 223>25=
8ales e+penses 24=52E,41164 255>===
ross Cost of &ro*uction (Rs) 346=>235,2E411> 36125=
aste plastics (Rs) 24= 255
catal$st (Rs) 3 3,1>5
utilities (Rs) 12,> 13,6
Ra aterials an* Gtilities (>5@) 255,> 21,>5
&acka.in. (3@) E,=2>2352E41 E,5E25
8alaries an* 7a.es (@) 21,=65>>2352E 22,3>25
Factor$ 9/erhea*s (5@) 15,=4=5>>235 15,E>5
Total Cost of &ro*uction (Rs) 3==,E41164=6 31E,5
*ninistrati/e e+penses 21,=65>>2352E 22,3>25
8ales e+penses 24,=52E4116 25,5>
ross Cost of &ro*uction (Rs) 346,=>2352E412 36,125
-
8/18/2019 PGD_CTM Project Final Worksheet
162/215
-
8/18/2019 PGD_CTM Project Final Worksheet
163/215
-
8/18/2019 PGD_CTM Project Final Worksheet
164/215
-
8/18/2019 PGD_CTM Project Final Worksheet
165/215
3 4 5 6 > E 1=
E= E5 1== 1== 1== 1== 1== 1==
2== 2>5= 3=== 3=== 3=== 3=== 3=== 3===
2====== 2>5===== 3======= 3======= 3======= 3======= 3======= 3=======
335== 35625= 35=== 35=== 35=== 35=== 35=== 35===
144==== 152==== 16===== 16===== 16===== 16===== 16===== 16=====
2>5== 3=3625= 31E5=== 31E5=== 31E5=== 31E5=== 31E5=== 31E5===
1=1566 1=21=3 112>52E 112>52E 112>52E 112>52E 112>52E 112>52E
236EE12 25=154 2633235 2633235 2633235 2633235 2633235 2633235
16E2E4 1>6>3> 1>>=>>2 1>>=>>2 1>>=>>2 1>>=>>2 1>>=>>2 1>>=>>2
33>55>>2 353665 36164 36164 36164 36164 36164 36164
236EE12 25=154 2633235 2633235 2633235 2633235 2633235 2633235
2=>41 2>5>E41 3==E412 3==E412 3==E412 3==E412 3==E412 3==E412
3>E34265 41=E2E 4326=2E4 4326=2E4 4326=2E4 4326=2E4 4326=2E4 4326=2E4
2= 2>5 3== 3== 3== 3== 3== 3==
3,35 3,5625 3,5 3,5 3,5 3,5 3,5 3,5
14,4 15,2 16 16 16 16 16 16
2>,5 3=3,625 31E,5 31E,5 31E,5 31E,5 31E,5 31E,5
1=,1566 1=,21=3 11,2>52E 11,2>52E 11,2>52E 11,2>52E 11,2>52E 11,2>52E
23,6EE12 25,=154 26,33235 26,33235 26,33235 26,33235 26,33235 26,33235
16,E2E4 1,>6>3> 1>,>=>>2 1>,>=>>2 1>,>=>>2 1>,>=>>2 1>,>=>>2 1>,>=>>2
33>,55>> 35,366 36,165 36,165 36,165 36,165 36,165 36,165
23,6EE12 25,=154 26,33235 26,33235 26,33235 26,33235 26,33235 26,33235
2,=>41 2>,5>E41 3=,=E412 3=,=E412 3=,=E412 3=,=E412 3=,=E412 3=,=E412
3>E,3426 41=,E2> 432,6=2E 432,6=2E 432,6=2E 432,6=2E 432,6=2E 432,6=2E
-
8/18/2019 PGD_CTM Project Final Worksheet
166/215
-
8/18/2019 PGD_CTM Project Final Worksheet
167/215
-
8/18/2019 PGD_CTM Project Final Worksheet
168/215
-
8/18/2019 PGD_CTM Project Final Worksheet
169/215
Caacit@> 3
11 Aear 1
1== @ Capacit$ GtiliHation >=
3=== ctual capacit$ (T&) 24==
3======= aste plastics (Rs) 24=,=
35=== catal$st (Rs) 3,=
16===== utilities (Rs) 12,>
31E5=== Ra aterials an* Gtilities (>5@) 255,>
112>52E &acka.in. (3@) E,=
2633235 8alaries an* 7a.es (@) 21,1
1>>=>>2 Factor$ 9/erhea*s (5@) 15,=
36164 Total Cost o< Pro=2ction 4Rs 3.:
2633235 *ninistrati/e e+penses (Rs) 21,1
3==E412 8ales e+penses (Rs) 24,1
4326=2E4 Gross Cost o< Pro=2ction 4Rs 3!8.1
3==
3,5
16
31E,5
11,2>52E
26,33235
1>,>=>>2
36,165
26,33235
3=,=E412
432,6=2E
-
8/18/2019 PGD_CTM Project Final Worksheet
170/215
-
8/18/2019 PGD_CTM Project Final Worksheet
171/215
-
8/18/2019 PGD_CTM Project Final Worksheet
172/215
-
8/18/2019 PGD_CTM Project Final Worksheet
173/215
-
8/18/2019 PGD_CTM Project Final Worksheet
174/215
-
8/18/2019 PGD_CTM Project Final Worksheet
175/215
-
8/18/2019 PGD_CTM Project Final Worksheet
176/215
-
8/18/2019 PGD_CTM Project Final Worksheet
177/215
1=
1==
3===
3==,=
3,>
16,=
31E,>
11,3
26,3
1>,>
378.
26,3
3=,1
!3.8
-
8/18/2019 PGD_CTM Project Final Worksheet
178/215
-
8/18/2019 PGD_CTM Project Final Worksheet
179/215
-
8/18/2019 PGD_CTM Project Final Worksheet
180/215
-
8/18/2019 PGD_CTM Project Final Worksheet
181/215
ross &rot (Rs)Financial "+pense
8-M Depreciation
7D' Depreciatio
9peratin. &rot
&rot :efore ta+
Corporate ta+ rate
Corporate ta+
&rot after ta+ (&
&rot for *i/i*en*
Di/i*en*
%et cash ccurals
prot ar.in
Return on n/est
1=====
-
8/18/2019 PGD_CTM Project Final Worksheet
182/215
-
8/18/2019 PGD_CTM Project Final Worksheet
183/215
1E6=6=23,52E411> 2123E>5>,>2353 22>36E4,1 245=52E,411632=== =562= 1=513=,> 11334,==2
551364,1 551364,1 551364,1 551364,1
1>5615= 14166>,5 1=>4>44=,6 >33E646,>435
11265E,42E411> 12E>2>4,2353 15211EE,2 16>42E1,3=E6
123,52E41163 636451,32352E 11E2=122,6>36 16=545=>,566=1
=,3245 =,3245 =,3245 =,3245
23255,26=2E411 2=6623,E544>5 3>6>=E,>1=>4 52=E6>>,=2E62
1E=4626>,26E116 1>46>===,>6E=4 1>E==4>3,4E> 1E1>446,3>==E
114E4E=4,16E116 1=E16636,6E=4 1134E11E,3E> 116331=3,2>==E
=,E523134135 =,E234===435 =,E45=2414E =,E5E22336E
1E=4626,316>=42 1>46EEE,E4564 1>E==4>2,552> 1E1>4466,42=>
=,5631E24> =,5631E24> =,5631E24> =,5631E24>
=,1E6=6=2353 =,2123E>5>>2 =,22>36E412 =,245=52E41
ross &rot (Rs) Financial "+pense8-M Depreciatio7D' Depreciatio
1E6=6=23,52E411> 32=== 551364,1 1>5615=2123E>5>,>2352E4 =562= 551364,1 14166>,5
22>36E4,1 1=513=,> 551364,1 1=>4>44=,6
245=52E,41164 11334,==2 551364,1 >33E646,>435
26141364,=5>>24 12161,1E5 551364,1 643EE=6,16563
252== 12E>6=,3>> 551364,1 4EE>66=,56234
2E4=E=35,2E4116 13>1=3,5>1 551364,1 3E=2>26,4==23
31=42>=,5>>2353 146346,4 551364,1 3=6442,16566>
3266=5,>>2352E 1545>E,E6 551364,1 242>652,512E6E
3266=5,>>2352E 162>33,16 551364,1 1E3>444,E=663
3266=5,>>2352E 164>63,>6 551364,1 1E3>,444E=663
1E6,=6 3,2 5,51 1>5,62
212,4= ,=6 5,51 141,6
22>,4 1,=5 5,51 1=>,4>
245,=> 1,13 5,51 >3,4=
261,41 1,22 5,51 64,4=
2,5 1,3= 5,51 4E,EE
-
8/18/2019 PGD_CTM Project Final Worksheet
184/215
2E4,=E 1,3> 5,51 3E,=3
31=,43 1,46 5,51 3=,6
326, 1,55 5,51 24,2E
326, 1,63 5,51 1E,3>
326, 1,65 5,51 =,=2
= = = =
-
8/18/2019 PGD_CTM Project Final Worksheet
185/215
26141364,1 252== 2E4=E=35 31=42>=,6 3266=5,>> 3266=5,E12161,1E5 12E>6=,3>> 13>1=3,5> 146346,4 1545>E,E6 162>33,16
551364,1 551364,1 551364,1 551364,1 551364,1 551364,1
643EE=6,1 4EE>66=,56 3E=2>26 3=6442,1 242>652,513 1E3>444,E1
1>46>3>3,41 2==E3E5,5 211E56> 2334515E, 24E=51,>2 24E625=>,6
1E5E>41,33 226466E 2536>1=5 2>2E=>1,6 3==E3463,4 3=5542,>
=,3245 =,3245 =,3245 =,3245 =,3245 =,3245
635365>,513 34>>4,35 >231E5= E=3=536,EE E6532>,>4 EE2126,33
1E666=>E 2=2E64E2,3 21=3>E>2 21>65E>6,> 2256> 225E2146,4
1211424,E 124512>,2 134>61 14314622, 152=5422,E4 15=4=>2,3
1,= 1,=14>2461 1,=51E4E1 1,=E32EE34 1,13>3E352 1,12E6=32
1E666=>>,= 2=2E64E1,2 21=3>E>= 21>65E>5, 2256>5,E 225E2145,3
=,6 =,5631E2 =,5631E3 =,5631E2 =,5631E25 =,5631E2
=,3 =,252 =,2E4=E=4 =,31=42>1 =,3266=5E =,3266=6
9peratin. &ro &rot :efore Corporate ta &rot after ta &rot for *i/
11265E,43 123,52E =,3245 23255,26 1E=4626>,2 114E4E=4,212E>2>4,2 636451,32 =,3245 2=6623,E5 1>46>===,> 1=E16636,>
15211EE,2 11E2=122, =,3245 3>6>=E,>1 1>E==4>3,5 1134E11E,4
16>42E1,31 16=545=>,6 =,3245 52=E6>>,=3 1E1>446,3> 116331=3,3
1>46>3>3,41 1E5E>41,3 =,3245 635365>,51 1E666=>E 1211424,E
2==E3E5,51 226466E =,3245 34>>4,35 2=2E64E2,26 124512>,2
211E56,61 2536>1=5,3 =,3245 >231E5=,1 21=3>E>1,54 134>61,4
2334515E,1 2>2E=>1,6 =,3245 E=3=536,EE 21>65E>6,>2 14314622,
24E=51,>2 3==E3463,4 =,3245 E6532>,> 2256> 152=5422,E
24E625=>,62 3=5542,> =,3245 EE2126,33 225E2146,4 15=4=>2,3
24E6=4,E2 325=EE=3,6 =,3245 1=54E463, 21E623>,31 14411=14,2
11,2> ,1 =,== 2,33 1E=,46 114,E5
12E,>3 63,6 =,== 2=,66 1>4,6> 1=E,1
152,1 11E,2= =,== 3>,6> 1>E,== 113,4E
16>,43 16=,55 =,== 52,1= 1E1,>4 116,33
1>4,6> 1E5,>= =,== 63,54 1E6,66 121,15
2==,E4 226,4 =,== 3,4E 2=2,E6 12,45
Corporate ta+rate
-
8/18/2019 PGD_CTM Project Final Worksheet
186/215
-
8/18/2019 PGD_CTM Project Final Worksheet
187/215
3266=5,>>2352E164>63,>6
551364,1
1E3>,444E=663
24E6=4,E22352E
325=EE=3,54463
=,3245
1=54E463,1=>>13
21E623>,311416
14411=14,211416
1,=E>11>E156
21E623,213352
=,5631E24>
=,3266=5>>
Di/i*en* %et cash ccurals prot ar.in Return on n/est
=,E523134135 1E=4626,316>=42 =,5631E24> =,1E6=6=2353=,E234===435 1>46EEE,E456441 =,5631E24> =,2123E>5>>2
=,E45=2414E 1>E==4>2,552E4 =,5631E24> =,22>36E412
=,E5E22336E 1E1>4466,42=>6E6 =,5631E24> =,245=52E41
1,= 1E666=>>,= =,6 =,3
1,=14>24613 2=2E64E1,2456>> =,5631E24> =,252
1,=51E4E= 21=3>E>=,4>2E64 =,5631E24> =,2E4=E=352E
1,=E32EE341 21>65E>5,25E5> =,5631E24> =,31=42>=5E
1,13>3E3521 2256>5,E=344 =,5631E24> =,3266=5>>
1,12E6=31E> 225E2145,266555 =,5631E24> =,3266=5>>
1,=E>11>E156 21E623,213352 =,5631E24> =,3266=5>>
=,== 1E=,46 =,== =,==
=,== 1>4,6> =,== =,==
=,== 1>E,== =,== =,==
=,== 1E1,>4 =,== =,==
=,== 1E6,66 =,== =,==
=,== 2=2,E6 =,== =,==
-
8/18/2019 PGD_CTM Project Final Worksheet
188/215
=,== 21=,3E =,== =,==
=,== 21>,66 =,== =,==
=,== 22,5 =,== =,==
=,== 225,E2 =,== =,==
=,== 21E,62 =,== =,==
= =,== =,== =,==
-
8/18/2019 PGD_CTM Project Final Worksheet
189/215
ent (R9)
-
8/18/2019 PGD_CTM Project Final Worksheet
190/215
-
8/18/2019 PGD_CTM Project Final Worksheet
191/215
1=====
/ol F"D C98T8 'R:-" sales tot total cost
1>== E6>4,5325> =52,=4 34>12=== 1E7 1E71E5= >62,135134 =52,=4 313=== !E7 1432441
21== 51,636564 =52,=4 4=614=== !E7 15426353
225= 6>E=,5253=3 =52,=4 43515=== !E7 1652>235
24== 613,=52E4E =52,=4 46416=== "E7 163=11>
255= 542,2244=2 =52,=4 4E31=== "E7 1>32===
2== 4>>1,2656E3 =52,=4 5221>=== "E7 1E>33>>2
2>5= 4352,513165 =52,=4 5511E=== 8E7 2=E3565
3=== 3>6,635>>E =52,=4 5>=2==== 8E7 22=364
3=== 1=52,4=22 =52,=4 5>=2==== 8E7 22=364
3=== 22=364
= = = =
= E6>4,53 =52,=4 = 132,225E
= >62,135 =52,=4 = 143,244
1>== 51,63 =52,=4 34>,12 154,2635
1E5= 6>E=,525 =52,=4 3,13 165,2>24
21== 613,=53 =52,=4 4=6,14 16,3=12
225= 542,224 =52,=4 435,15 1>,32
24== 4>>1,266 =52,=4 464,16 1E>,33>>
255= 4352,513 =52,=4 4E3,1 2=E,356
2== 3>6,636 =52,=4 522,1> 22=,365
2>5= 1=52,4 =52,=4 551,1E 22=,365
3=== = 5>=,2 22=,365
3=== 5>=,2
=
-
8/18/2019 PGD_CTM Project Final Worksheet
192/215
15426353 1652>235 163=11> 1>32=== 1E>33>>2 2=E3565 22=364 22=364
-
8/18/2019 PGD_CTM Project Final Worksheet
193/215
22=364
-
8/18/2019 PGD_CTM Project Final Worksheet
194/215
1=====
Capacit$! 3=== T& of &etroleu &ro*ucts
Aear 1 2 3
@ Capacit$ GtiliHation 6= 65 =
ctual capacit$ (T&) 1>== 1E5= 21==aste tire (Rs) 1=>===== 11===== 126=====
catal$st (Rs) 1152== 124>== 1344==
utilities (Rs) 324=== 351=== 3>===
Ra aterials an* Gtilities (>5 1123E2== 1215>== 131124==
&acka.in. (3@) 3E66,6 42E34,1 462E=,6
8alaries an* 7a.es (@) E255>1,2 1==213 1=E>45
Factor$ 9/erhea*s (5@) 66112E,4 16223,5 131,6
Total Cost of &ro*uction (Rs) 132225>> 1432441 15426353
*ninistrati/e e+penses E255>1,2 1==213 1=E>45
8ales e+penses 1=5>= 1145E5> 12341=>ross Cost of &ro*uction (Rs) 152=5E6 1643141 14=3=6
1=>,= 11,= 126,=
1,2 1,2 1,3
3,2 3,5 3,>
112,4 121,> 131,1
4,= 4,3 4,6
E,3 1=,= 1=,>
6,6 ,2 ,
132,2 143,2 154,3
E,3 1=,= 1=,>
1=,6 11,5 12,3
152,1 164, 1,4
= = =
-
8/18/2019 PGD_CTM Project Final Worksheet
195/215
4 5 6 > E 1= 11
5 >= >5 E= E5 1== 1== 1==
225= 24== 255= 2== 2>5= 3=== 3=== 3===135===== 144===== 153===== 162===== 11===== 1>====== 1>====== 1>======
144=== 1536== 1632== 12>== 1>24== 1E2=== 1E2=== 1E2===
4=5=== 432=== 45E=== 4>6=== 513=== 54==== 54==== 54====
14=4E=== 14E>56== 15E222== 16>5>>== 1E54== 1>32=== 1>32=== 1>32===
4E5>4,1 52>E=3,5 561E6= 5E5=16,5 62>=2,E 66112E,4 66112E,4 66112E,4
1156E6 12341=> 131124= 13>>32 14655=4 1542635 1542635 1542635
>26411,> >>15=5,E E366== EE16E4,1 1=46>> 11=1>>2 11=1>>2 11=1>>2
1652>235 163=11> 1>32=== 1E>33>>2 2=E3565 22=364 22=364 22=364
1156E6 12341=> 131124= 13>>32 14655=4 1542635 1542635 1542635
132225E 141=4=E 14E>56= 15>611 164>61 163=12 163=12 163=121E==41 2=24635 21541>== 22>=>E65 24=612E 253432E4 253432E4 253432E4
135,= 144,= 153,= 162,= 11,= 1>=,= 1>=,= 1>=,=
1,4 1,5 1,6 1, 1,> 1,E 1,E 1,E
4,1 4,3 4,6 4,E 5,1 5,4 5,4 5,4
14=,5 14E,E 15E,2 16>,6 1>,= 1>,3 1>,3 1>,3
5,= 5,3 5,6 6,= 6,3 6,6 6,6 6,6
11,6 12,3 13,1 13,E 14, 15,4 15,4 15,4
>,3 >,> E,4 E,E 1=,5 11,= 11,= 11,=
165,3 16,3 1>,3 1E>,3 2=E,4 22=,4 22=,4 22=,4
11,6 12,3 13,1 13,E 14, 15,4 15,4 15,4
13,2 14,1 15,= 15,E 16, 1,6 1,6 1,6
1E=,1 2=2, 215,4 22>,1 24=,> 253,4 253,4 253,4
= = = = = = = =
-
8/18/2019 PGD_CTM Project Final Worksheet
196/215
79RN% C&T- 8TT"M"%T
Rupees
Aear 2=14B15Ra Material 8tock =
n Material 8tock =
Finishe* &ro*uct 8tock =
Cre*it to custoer =
Cre*it fro supplier =
%et 7orkin. Capital =
nterest o/er 7orkin. Capita =
=,=
=,==,=
=,=
=,=
=,=
=,=
=,=
5======,= >5====,=
=,= =,=
=,= =,=
=,= =,=
=,= =,=
= =
-
8/18/2019 PGD_CTM Project Final Worksheet
197/215
1=====
2=15B16 2=16B1 2=1B1> 2=1>B1E>=3=== E42>25= 1=1535== 1=>>5=
6E624= 5426= >122>= >=3==
= 235=62,5 253>35 21E6>,5
= 2E=1=== 31425= 33>45==
1>===== 1E5==== 21===== 225====
5EE24= 134E=52,5 14546E=5 156=323,5
1=63>E3,6 1>>>6>=,15 2=36566, 21>4453,25
>,= E4,3 1=1,5 1=>,>
,= ,5 >,1 >,=,= 23,6 25,4 2,2
=,= 2E,= 31,4 33,>
1>,= 1E,5 21,= 22,5
6,= 134,E 145,5 156,=
1=,6 1>,E 2=,4 21,>
=,= =,= =,= =,=
E6=5====,= E655===,= 32=5==,= >=5255=,=
=,= =,= =,= =,=
1>==,= 1E5=,= 21==,= 225=,=
135=,= 1462,5 155,= 16>,5
2612===,= 2EE13===,= 32214===,= 34515===,=
26,12 2EE,13 322,14 345,15
-
8/18/2019 PGD_CTM Project Final Worksheet
198/215
2=1EB2= 2=2=B21 2=21B22 2=22B23116=4=== 1232E25= 13=545== 13E5=
E2>32= E>634= 1=4436= 11=23>=
2E=1=== 3=>2312,5 3263625 3444E3,5
362625= 3>6>=== 41=E5= 43515==
24===== 255==== 2===== 2>5====
1665E5= 115E=2,5 1>2235 1E>2>56,5
233233E,> 24>=226,35 262>112,E 25EEE,45
116,= 123,3 13=,5 13,>
E,3 E,E 1=,4 11,=2E,= 3=,> 32,6 34,4
36,3 3>, 41,1 43,5
24,= 25,5 2,= 2>,5
166,6 1,2 1>, 1E>,3
23,3 24,> 26,3 2,>
=,= =,= =,= =,=
>>5>=5,= E435>5,5 1=1E44,1 11>E3>,5
=,= =,= =,= =,=
24==,= 255=,= 2==,= 2>5=,=
1>==,= 1E12,5 2=25,= 213,5
36>16===,= 3E11===,= 4141>===,= 431E===,=
36>,16 3E1,1 414,1> 43,1E
-
8/18/2019 PGD_CTM Project Final Worksheet
199/215
2=23B24 2=24B25 2=25B26145=5=== 145=5=== 145=5===
116=4== 116=4== 116=4==
362625= 362625= 362625=
45E325= 4>35=== 4>35===
3====== 3====== 3======
2=>>4E== 2112665= 2112665=
2E23>>6 2E531 2E531
145,1 145,1 145,1
11,6 11,6 11,636,3 36,3 36,3
45,E 4>,4 4>,4
3=,= 3=,= 3=,=
2=>,> 211,3 211,3
2E,2 2E,6 2E,6
=,= =,= =,=
12E6>12,3 142655>3,5 156E2141,E
=,= =,= =,=
3===,= 3===,= 3===,=
225=,= 225=,= 225=,=
46=2====,= 46=2====,= 114=335=,=
46=,2 46=,2 114=,335
-
8/18/2019 PGD_CTM Project Final Worksheet
200/215
D8C9G%T"D &R9FT F-97 %-A88 T"C;%KG"8
Rupees(in lakhs)
"+pen*iture *urin. $ear 1 (1) 15=,5
"+pen*iture *urin. Aear 2 (2) 24=,2
= 42=,>7CC(k) =,2
Aear ross &rot 7CCOk (1k)Pn
1 1E6,=6=2352E41 =,2 1,16
2 212,3E>5>>2353 =,2 1,44
3 22>,36E41165 =,2 1,2
4 245,=52E4116 =,2 2,=6
5 261,41364=5>> =,2 2,4
6 2,52 =,2 2,E6
2E4,=E=352E41