Download - Project Ginning Factory
-
7/31/2019 Project Ginning Factory
1/28
S.NO: PARTICULARS AMOUNT
1 LAND (2.4 ACRES) 6.00
2 MACHINERY 86.00
3 PRELIMINARY AND PRE-OPERATIVE EXPENSES 4.00
4 BUILDING 110.00
206.00
MEANS OF FINANCE
S.NO: PARTICULARS AMOUNT
1 PROMOTER'S CONTRIBUTION 56.00
2 TERM LOAN- CANARA BANK 100.00
3 WORKING CAPITAL - CANARA BANK 50.00
TOTAL 206.00
S.NO: PARTICULARS AMT/%
1 PROMOTERS' CONTRIBUTION 0.27
PROJECT PARAMETERS
COST OF THE PROJECT
-
7/31/2019 Project Ginning Factory
2/28
REPAYMENT
CC LOAN MONTHLY INTEREST TERM LOAN 2010- JAN
RATE OF INTEREST
TL 14%
CC 13.25%
-
7/31/2019 Project Ginning Factory
3/28
Particulars 1ST YEAR 2nd YEAR 3rd YEAR 4th YEAR 5th YEAR 6th YEAR 7th YEAR
2009-10 2010-11 2011-12 2012-13 2013-14 2014-15 2015-16
Installed Capacity (Qtls) 42000 42000 42000 42000 42000 42000 42000
Production per year (Qtls) 29000 31400 33310 35650 36300 37750 38500
Operating Capacity (Percentage) 69 75 79 85 86 90 92
INCOME
A
Sales
Lint 60648000 73055850 80736831 89273347 95411073 103646352 109937973
Seeds 19627920 23029272 25529799 29182485 31058320 33771132 36372590
Closing Stock
Kappas 2600000 3003000 3869775 4664454 5529066 6633947 6963697
Lint 3135907 4587407 5715920 7175571 8360920 9196884 10092358
Seeds 483929 659983 952811 1044088 1202795 1453345 1613155
Total of A 86495757 104335512 116805136 131339945 141562174 154701659 164979773
B
Opening Stock
Kappas 2600000 3003000 3869775 4664454 5529066 6633947
Lint 3135907 4587407 5715920 7175571 8360920 9196884
Seeds 483929 659983 952811 1044088 1202795 1453345
Purchases
Kappas 78000000 85995000 96199740 107884301 115320518 126044986 134051174
Labour Charges 800000 840000 882000 926100 972405 1021025 1072077
Hamali 500000 525000 551250 578813 607753 638141 670048
Power Charges 400000 420000 441000 463050 486203 510513 536038
Cotton Ginning Factory
PROJECTED PROFITABILITY STATEMENT
-
7/31/2019 Project Ginning Factory
4/28
Total of B 79700000 93999837 106324380 120390770 130270991 143307445 153613512
Gross Profit ( A-B ) 6795757 10335675 10480757 10949175 11291182 11394214 11366262
Total of C 6795757 10335675 10480757 10949175 11291182 11394214 11366262D
Indirect Expenditure
Administrative Expenses 450000 461250 472781 484601 496716 509134 521862
Electricle & Factory Maintenance 75000 76875 78797 80767 82786 84856 86977
Machinery Maintenance 150000 153750 157594 161534 165572 169711 173954
Fees & Reg Charges 20000 20500 21013 21538 22076 22628 23194
Transportation 850000 871250 893031 915357 938241 961697 985739
Diesel For DG 30000 30750 31519 32307 33114 33942 34791
Insurance 100000 102500 105063 107689 110381 113141 115969
Insurance for Staff 35000 35875 36772 37691 38633 39599 40589
Miscellaneous 30000 30750 31519 32307 33114 33942 34791Postage 5000 5125 5253 5384 5519 5657 5798
Printing & Stationery 10000 10250 10506 10769 11038 11314 11597
Professional Tax 2500 2500 2500 2500 2500 2500 2500
Audit & Other Fee 20000 20500 21013 21538 22076 22628 23194
Salary 300000 307500 315188 323067 331144 339422 347908
Telephone Charges 50000 51250 52531 53845 55191 56570 57985
Interest on Term Loan 1395833 1258334 1058335 858336 658337 458338 258339
Interest on CC loan 762500 762500 762500 762500 762500 762500 762500
Depreciation 1267815 1077642 915996 778597 661807 562536 478156
Total of D 6795757 10335675 10480757 10949175 11291182 11394214 11366262
Net Profit (C-D) Before Tax 1242109 5056574 5508847 6258849 6860435 7204097 7400418
Provision For Income Tax 413995 1685356 1836099 2086074 2286583 2401126 2466559
Profit after Tax 828114 3371218 3672748 4172775 4573852 4802971 4933859
-
7/31/2019 Project Ginning Factory
5/28
Liabilities 1ST YEAR 2nd YEAR 3rd YEAR 4th YEAR 5th YEAR 6th YEAR 7th YEAR
2009-10 2010-11 2011-12 2012-13 2013-14 2014-15 2015-16
Capital 2,963,746.00 7,726,482 10,900,203 14,495,689 17,853,632 21,300,403 23,945,733
Bank Loan TL 9,642,859 8,214,295 6,785,731 5,357,167 3,928,603 2,500,039 1,071,475
Bank Loan CC 5,000,000 5,000,000 5,000,000 5,000,000 5,000,000 5,000,000 5,000,000
Sundry Creditors 6,500,000 7,166,250 8,016,645 8,990,358 9,610,043 10,503,749 11,170,931
Other Liabilities 500,000 700,000 900,000 1,100,000 1,300,000 1,500,000 1,700,000
Total 24,606,605 28,807,027 31,602,579 34,943,214 37,692,278 40,804,191 42,888,139
Assets
Fixed Assets 7,784,283 6,706,641 5,790,645 5,012,048 4,350,241 3,787,705 3,309,549
Investments
Current Assets
Cash in Hand 25,000 25,000 25,000 25,000 25,000 25,000 25,000
Cash at Bank 30,000 30,000 30,000 30,000 30,000 30,000 30,000
Closing Stock
Kappas 2,600,000 3,003,000 3,869,775 4,664,454 5,529,066 6,633,947 6,963,697
Lint 3,135,907 4,587,407 5,715,920 7,175,571 8,360,920 9,196,884 10,092,358
Seeds 483,929 659,983 952,811 1,044,088 1,202,795 1,453,345 1,613,155
Sundry Debtors 10,034,490 12,010,640 13,283,329 14,806,979 15,808,674 17,177,185 18,288,820
Other Current Assets
Income Tax Advance 413,995 1,685,356 1,836,099 2,086,074 2,286,583 2,401,126 2,466,559
Deposits 99,000 99,000 99,000 99,000 99,000 99,000 99,000
Loans & Advances
Total 24,606,605 28,807,027 31,602,579 34,943,214 37,692,279 40,804,191 42,888,139
COTTON GINNING FACTORY
Projected Balance Sheet
-
7/31/2019 Project Ginning Factory
6/28
Valuation of closing stock
Kappas Qty Rate Total Qty Rate Total Qty Rate Total Qty Rate To
Op.Stock 1350 2866.5 3869775 1550 3009.33 4664453.75 1750 3159.466 5529065.938 2000 3316.973
Add:Purchases 35850 3009.33 107884301.3 36500 3159.466 115320518.1 38000 3316.973 126044985.9 38500 3481.849
Less :Closing Stock 1550 3009.33 4664453.75 1750 3159.466 5529065.938 2000 3316.973 6633946.625 2000 3481.849
Raw Materials Consumed 35650 107089622.5 36300 114455905.9 37750 124940105.2 38500
Add :Direct Expenses
Power 463,050.00 486,202.50 510,510.13
Hamali 578,812.50 607,752.63 638,137.63
Labour 926,100.00 972,405.00 1,021,020.25 1
Cost of Production 35650 109057585 36300 116522266.1 37750 127109773.2 38500Consumption T\F to Lint 11764.5 11979 12457.5 12705
Consumption T\F to Seeds 23386.4 23812.8 24764 25256
Lint Qty Rate Total Qty Rate Total Qty Rate Total Qty Rate To
Op.Stock 750 7621.23 5715920.422 900 7972.86 7175570.612 1000 8360.92 8360920.047 1050 8758.94
Add: T/F from Kappas 11764.5 11979 12457.5 12705
Less: Sales 11615 7686 89273347.34 11879 8031.911 95411072.51 12408 8353.188 103646351.7 12655 8687.315
Closing Stock 900 7972.86 7175570.612 1000 8360.92 8360920.047 1050 8758.94 9196883.74 1100 9174.87
Seeds Qty Rate Total Qty Rate Total Qty Rate Total Qty Rate ToOp.Stock 1550 614.72 952811.0992 1600 652.56 1044088.38 1750 687.31 1202794.65 2000 726.67
Add: T/F from Kappas 23386.4 23812.8 24764 25256
Less: Sales 23336 1250.535 29182484.76 23663 1312.527 31058320.49 24514 1377.626 33771132.04 25156 1445.881
Closing Stock 1600 652.56 1044088.38 1750 687.31 1202794.649 2000 726.67 1453344.92 2100 768.17
2012-13 2013-2014 2014-2015 2015-2016
2012-13 2013-2014 2014-2015 2015-2016
2012-13 2013-2014 2014-2015 2015-2016
-
7/31/2019 Project Ginning Factory
7/28
-
7/31/2019 Project Ginning Factory
8/28
Year Particulars Qtls Particulars Qtls Particulars Qtls
2009-2010 Kappas Lint Seeds
OP. Stock Nil OP. Stock Nil OP. Stock Nil
Purchases 30000 Purchases Nil Purchases Nil
Total 30000 From Ginning 9570 From Ginning 19024Less: CL 1000 Sales 9120 Sales 18174
Ginning 29000 Cl. Stock 450 Cl. Stock 850
2010-2011 Kappas Lint Seeds
OP. Stock 1000 OP. Stock 450 OP. Stock 850
Purchases 31500 Purchases Nil Purchases Nil
Total 32500 From Ginning 10362 From Ginning 20598
Less: CL 1100 Sales 10182 Sales 20308
Ginning 31400 Cl. Stock 630 Cl. Stock 1140
2011-2012 Kappas Lint Seeds
OP. Stock 1100 OP. Stock 630 OP. Stock 1140
Purchases 33560 Purchases Nil Purchases Nil
Total 34660 From Ginning 10992 From Ginning 21851
Less: CL 1350 Sales 10872 Sales 21441
Ginning 33310 Cl. Stock 750 Cl. Stock 1550
2012-2013 Kappas Lint Seeds
OP. Stock 1350 OP. Stock 750 OP. Stock 1550
Purchases 35850 Purchases Nil Purchases Nil
Total 37200 From Ginning 11765 From Ginning 23386
Less: CL 1550 Sales 11615 Sales 23336
Ginning 35650 Cl. Stock 900 Cl. Stock 1600
2013-2014 Kappas Lint Seeds
OP. Stock 1550 OP. Stock 900 OP. Stock 1600
Purchases 36500 Purchases Nil Purchases Nil
Total 38050 From Ginning 11979 From Ginning 23813
Less: CL 1750 Sales 11879 Sales 23663
Ginning 36300 Cl. Stock 1000 Cl. Stock 1750
2014-2015 Kappas Lint Seeds
OP. Stock 1750 OP. Stock 1000 OP. Stock 1750
Purchases 38000 Purchases Nil Purchases Nil
Total 39750 From Ginning 12458 From Ginning 24764
Less: CL 2000 Sales 12408 Sales 24514
Ginning 37750 Cl. Stock 1050 Cl. Stock 2000
2015-2016 Kappas Lint Seeds
OP Stock 2000 OP Stock 1050 OP Stock 2000
Quantitative Statement
-
7/31/2019 Project Ginning Factory
9/28
PARTICULARS 2009-10 2010-2011 2011-2012 2012-2013 2013-2014 2014-2015 2015-2016
Profit After Tax 828,114 3,371,218 3,672,748 4,172,775 4,573,852 4,802,971 4,933,859Add: Depreciation 1,267,815 1,077,642 915,996 778,597 661,807 562,536 478,156
Interest on Term Loan 1,395,833 1,258,334 1,058,335 858,336 658,337 458,338 258,339
Funds from Operations 3,491,762 5,707,194 5,647,080 5,809,708 5,893,997 5,823,846 5,670,354
Repayment of TermLoan 357,141 1,428,564 1,428,564 1,428,564 1,428,564 1,428,564 1,428,564
Interest on Term Loans 1,395,833 1,258,334 1,058,335 858,336 658,337 458,338 258,339
Total Debt obligation 1,752,974 2,686,898 2,486,899 2,286,900 2,086,901 1,886,902 1,686,903
Yearwise DSCR (in times) 1.99 2.12 2.27 2.54 2.82 3.09 3.36
AVERAGE DSCR :- 2.60
DSCR CALCULATION
-
7/31/2019 Project Ginning Factory
10/28
YEAR PARTICULARS OPENING WDV RATE DEPRECIATION CLOSING WDV
2009-10 Bajaj Auto Feeder 2229029 15% 334,354 1,894,675
Electrick Motors 206,755 15% 31,013 175,742
Electrick Weigh Bridge 1,016,873 15% 152,531 864,342
Cotton Balling Press 2,000,000 15% 300,000 1,700,000
Ginning Kanwar 310,000 15% 46,500 263,500
Kirloskar DG Sets 160 KVA 925,557 15% 138,834 786,723
Equipments 1,763,884 15% 264,583 1,499,301
Land 600,000 600,000
Total 9,052,098 1,267,815 7,784,283
YEAR PARTICULARS OPENING WDV RATE DEPRECIATION CLOSING WDV
2010-11 Bajaj Auto Feeder 1,894,675 15% 284,201 1,610,473
Electrick Motors 175,742 15% 26,361 149,380
Electrick Weigh Bridge 864,342 15% 129,651 734,691
Cotton Balling Press 1,700,000 15% 255,000 1,445,000
Ginning Kanwar 263,500 15% 39,525 223,975
Kirloskar DG Sets 160 KVA 786,723 15% 118,009 668,715
Equipments 1,499,301 15% 224,895 1,274,406
Land 600,000 600,000
Total 7,784,283 1,077,642 6,706,641
COTTON GINNING FACTORY
DEPRECIATION SCHEDULE
-
7/31/2019 Project Ginning Factory
11/28
YEAR PARTICULARS OPENING WDV RATE DEPRECIATION CLOSING WDV
2011-12 Bajaj Auto Feeder 1,610,473 15% 241,571 1,368,902
Electrick Motors 149,380 15% 22,407 126,973
Electrick Weigh Bridge 734,691 15% 110,204 624,487
Cotton Balling Press 1,445,000 15% 216,750 1,228,250
Ginning Kanwar 223,975 15% 33,596 190,379
Kirloskar DG Sets 160 KVA 668,715 15% 100,307 568,408
Equipments 1,274,406 15% 191,161 1,083,245
Land 600,000 600,000
Total 6,706,641 915,996 5,790,645
YEAR PARTICULARS OPENING WDV RATE DEPRECIATION CLOSING WDV
2012-13 Bajaj Auto Feeder 1,368,902 15% 205,335 1,163,567
Electrick Motors 126,973 15% 19,046 107,927
Electrick Weigh Bridge 624,487 15% 93,673 530,814
Cotton Balling Press 1,228,250 15% 184,238 1,044,013
Ginning Kanwar 190,379 15% 28,557 161,822
Kirloskar DG Sets 160 KVA 568,408 15% 85,261 483,147
Equipments 1,083,245 15% 162,487 920,758
Land 600,000 600,000
-
7/31/2019 Project Ginning Factory
12/28
Total 5,790,645 778,597 5,012,048
-
7/31/2019 Project Ginning Factory
13/28
YEAR PARTICULARS OPENING WDV RATE DEPRECIATION CLOSING WDV
2013-14 Bajaj Auto Feeder 1,163,567 15% 174,535 989,032
Electrick Motors 107,927 15% 16,189 91,738
Electrick Weigh Bridge 530,814 15% 79,622 451,192
Cotton Balling Press 1,044,013 15% 156,602 887,411
Ginning Kanwar 161,822 15% 24,273 137,549
Kirloskar DG Sets 160 KVA 483,147 15% 72,472 410,675
Equipments 920,758 15% 138,114 782,645
Land 600,000 600,000
Total 5,012,048 661,807 4,350,241
YEAR PARTICULARS OPENING WDV RATE DEPRECIATION CLOSING WDV
2014-15 Bajaj Auto Feeder 989,032 15% 148,355 840,677
Electrick Motors 91,738 15% 13,761 77,978
Electrick Weigh Bridge 451,192 15% 67,679 383,513
Cotton Balling Press 887,411 15% 133,112 754,299
Ginning Kanwar 137,549 15% 20,632 116,916
Kirloskar DG Sets 160 KVA 410,675 15% 61,601 349,073
Equipments 782,645 15% 117,397 665,248
Land 600,000 600,000
Total 4,350,241 562,536 3,787,705
-
7/31/2019 Project Ginning Factory
14/28
YEAR PARTICULARS OPENING WDV RATE DEPRECIATION CLOSING WDV
2015-16 Bajaj Auto Feeder 840,677 15% 126,102 714,576
Electrick Motors 77,978 15% 11,697 66,281
Electrick Weigh Bridge 383,513 15% 57,527 325,986
Cotton Balling Press 754,299 15% 113,145 641,154
Ginning Kanwar 116,916 15% 17,537 99,379
Kirloskar DG Sets 160 KVA 349,073 15% 52,361 296,712
Equipments 665,248 15% 99,787 565,461
Land 600,000 600,000Total 3,787,705 478,156 3,309,549
-
7/31/2019 Project Ginning Factory
15/28
-
7/31/2019 Project Ginning Factory
16/28
-
7/31/2019 Project Ginning Factory
17/28
-
7/31/2019 Project Ginning Factory
18/28
-
7/31/2019 Project Ginning Factory
19/28
-
7/31/2019 Project Ginning Factory
20/28
Rate of Interest 14.00%
Months Opening Principle Interest Installment
1 10,000,000.00 116,666.67 116,666.67
2 10,000,000.00 116,666.67 116,666.67
3 10,000,000.00 116,666.67 116,666.67
4 10,000,000.00 116,666.67 116,666.67
5 10,000,000.00 116,666.67 116,666.67
6 10,000,000.00 116,666.67 116,666.67
7 10,000,000.00 116,666.67 116,666.67
8 10,000,000.00 116,666.67 116,666.67
9 10,000,000.00 116,666.67 116,666.67
10 10,000,000.00 119,047.00 116,666.67 235,713.6711 9,880,953.00 119,047.00 115,277.79 234,324.79
12 9,761,906.00 119,047.00 113,888.90 232,935.90
TOTAL 357,141.00 1,395,833.36 1,752,974.36
Rate of Interest 14.00%
Months Opening Principle Interest Installment
13 9,642,859.00 119,047.00 112,500.02 231,547.02
14 9,523,812.00 119,047.00 111,111.14 230,158.14
15 9,404,765.00 119,047.00 109,722.26 228,769.26
16 9,285,718.00 119,047.00 108,333.38 227,380.38
17 9,166,671.00 119,047.00 106,944.50 225,991.50
18 9,047,624.00 119,047.00 105,555.61 224,602.61
19 8,928,577.00 119,047.00 104,166.73 223,213.73
COTTON GINNING FACTORY
1st YEAR
2nd YEAR
TERM LOAN REPAYMENT SCHEDULE
-
7/31/2019 Project Ginning Factory
21/28
Rate of Interest 14.00%
Months Opening Principle Interest Installment, , . , . , . , .
26 8,095,248.00 119,047.00 94,444.56 213,491.56
27 7,976,201.00 119,047.00 93,055.68 212,102.68
28 7,857,154.00 119,047.00 91,666.80 210,713.80
29 7,738,107.00 119,047.00 90,277.92 209,324.92
30 7,619,060.00 119,047.00 88,889.03 207,936.03
31 7,500,013.00 119,047.00 87,500.15 206,547.15
32 7,380,966.00 119,047.00 86,111.27 205,158.27
33 7,261,919.00 119,047.00 84,722.39 203,769.39
34 7,142,872.00 119,047.00 83,333.51 202,380.51
35 7,023,825.00 119,047.00 81,944.63 200,991.63
36 6,904,778.00 119,047.00 80,555.74 199,602.74
TOTAL 1,428,564.00 1,058,335.11 2,486,899.11
Rate of Interest 14.00%
Months Opening Principle Interest Installment37 6,785,731.00 119,047.00 79,166.86 198,213.86
38 6,666,684.00 119,047.00 77,777.98 196,824.98
39 6,547,637.00 119,047.00 76,389.10 195,436.10
40 6,428,590.00 119,047.00 75,000.22 194,047.22
41 6,309,543.00 119,047.00 73,611.34 192,658.34
42 6,190,496.00 119,047.00 72,222.45 191,269.45
43 6,071,449.00 119,047.00 70,833.57 189,880.57
44 5,952,402.00 119,047.00 69,444.69 188,491.69
45 5,833,355.00 119,047.00 68,055.81 187,102.81
46 5,714,308.00 119,047.00 66,666.93 185,713.93
47 5,595,261.00 119,047.00 65,278.05 184,325.0548 5,476,214.00 119,047.00 63,889.16 182,936.16
TOTAL 1,428,564.00 858,336.15 2,286,900.15
4th YEAR
3rd YEAR
-
7/31/2019 Project Ginning Factory
22/28
Rate of Interest 14.00%
Months Opening Principle Interest Installment
49 5,357,167.00 119,047.00 62,500.28 181,547.28
50 5,238,120.00 119,047.00 61,111.40 180,158.4051 5,119,073.00 119,047.00 59,722.52 178,769.52
52 5,000,026.00 119,047.00 58,333.64 177,380.64
53 4,880,979.00 119,047.00 56,944.76 175,991.76
54 4,761,932.00 119,047.00 55,555.87 174,602.87
55 4,642,885.00 119,047.00 54,166.99 173,213.99
56 4,523,838.00 119,047.00 52,778.11 171,825.1157 4,404,791.00 119,047.00 51,389.23 170,436.23
58 4,285,744.00 119,047.00 50,000.35 169,047.35
59 4,166,697.00 119,047.00 48,611.47 167,658.47
60 4,047,650.00 119,047.00 47,222.58 166,269.58
TOTAL 1,428,564.00 658,337.19 2,086,901.19
Rate of Interest 14.00%
Months Opening Principle Interest Installment
61 3,928,603.00 119,047.00 45,833.70 164,880.70
62 3,809,556.00 119,047.00 44,444.82 163,491.82
63 3,690,509.00 119,047.00 43,055.94 162,102.94
64 3,571,462.00 119,047.00 41,667.06 160,714.06
65 3,452,415.00 119,047.00 40,278.18 159,325.18
66 3,333,368.00 119,047.00 38,889.29 157,936.29
67 3,214,321.00 119,047.00 37,500.41 156,547.41
68 3,095,274.00 119,047.00 36,111.53 155,158.53
69 2,976,227.00 119,047.00 34,722.65 153,769.65
70 2,857,180.00 119,047.00 33,333.77 152,380.77
71 2,738,133.00 119,047.00 31,944.89 150,991.89
72 2,619,086.00 119,047.00 30,556.00 149,603.00
5th YEAR
6th YEAR
78 1 904 804 00 119 047 00 22 222 71 141 269 71
-
7/31/2019 Project Ginning Factory
23/28
78 1,904,804.00 119,047.00 22,222.71 141,269.71
79 1,785,757.00 119,047.00 20,833.83 139,880.83
80 1,666,710.00 119,047.00 19,444.95 138,491.95
81 1,547,663.00 119,047.00 18,056.07 137,103.07
82 1,428,616.00 119,047.00 16,667.19 135,714.19
83 1,309,569.00 119,047.00 15,278.31 134,325.31
84 1,190,522.00 119,047.00 13,889.42 132,936.42
TOTAL 1,428,564.00 258,339.27 1,686,903.27
Rate of Interest 14.00%
Months Opening Principle Interest Installment
85 1,071,475.00 119,047.00 12,500.54 131,547.54
86 952,428.00 119,047.00 11,111.66 130,158.66
87 833,381.00 119,047.00 9,722.78 128,769.78
88 714,334.00 119,047.00 8,333.90 127,380.90
89 595,287.00 119,047.00 6,945.02 125,992.02
90 476,240.00 119,047.00 5,556.13 124,603.13
91 357,193.00 119,047.00 4,167.25 123,214.25
92 238,146.00 119,047.00 2,778.37 121,825.37
93 119,099.00 119,099.00 1,389.49 120,488.49
TOTAL 1,071,475.00 62,505.14 1,133,980.14
8th YEAR
-
7/31/2019 Project Ginning Factory
24/28
Balance
10,000,000.00
10,000,000.00
10,000,000.00
10,000,000.0010,000,000.00
10,000,000.00
10,000,000.00
10,000,000.00
10,000,000.00
9,880,953.009,761,906.00
9,642,859.00
Balance
9,523,812.00
9,404,765.00
9,285,718.00
9,166,671.00
9,047,624.00
8,928,577.00
8,809,530.00
-
7/31/2019 Project Ginning Factory
25/28
Balance, , .
7,976,201.00
7,857,154.00
7,738,107.00
7,619,060.00
7,500,013.00
7,380,966.00
7,261,919.00
7,142,872.00
7,023,825.00
6,904,778.00
6,785,731.00
Balance6,666,684.00
6,547,637.00
6,428,590.00
6,309,543.00
6,190,496.006,071,449.00
5,952,402.00
5,833,355.00
5,714,308.00
5,595,261.00
5,476,214.005,357,167.00
-
7/31/2019 Project Ginning Factory
26/28
Balance
5,238,120.00
5,119,073.005,000,026.00
4,880,979.00
4,761,932.00
4,642,885.00
4,523,838.00
4,404,791.004,285,744.00
4,166,697.00
4,047,650.00
3,928,603.00
Balance
3,809,556.00
3,690,509.00
3,571,462.00
3,452,415.00
3,333,368.00
3,214,321.00
3,095,274.00
2,976,227.00
2,857,180.00
2,738,133.00
2,619,086.00
2,500,039.00
1,785,757.00
-
7/31/2019 Project Ginning Factory
27/28
, ,
1,666,710.00
1,547,663.00
1,428,616.00
1,309,569.00
1,190,522.00
1,071,475.00
Balance
952,428.00
833,381.00
714,334.00
595,287.00
476,240.00
357,193.00
238,146.00
119,099.00
-
-
7/31/2019 Project Ginning Factory
28/28
2009-10 2010-11 2011-12 2012-13 2013-14 2014-15 2015-16
Particulars Amount Amount Amount Amount Amount Amount Amount
Current Assets :-
Cash and bank balances 55000 55000 55000 55000 55000 55000 55000
Receivables 10034490 12010640 13283329 14806979 15808674 17177185 18288820
Closing Stock 6219837 8250390 10538507 12884113 15092781 17284175 18669210
1Total current Assets 1 16309327 20316030 23876835 27746092 30956455 34516361 37013030
Current Liabilities :- 2 7000000 7866250 8916645 10090358 10910043 12003749 12870931
Working Capital Gap 3-- (1-2 ) 9309327 12449780 14960190 17655733 20046412 22512612 24142099
25% of CA 4 4077332 5079007 5969209 6936523 7739114 8629090 9253258
MPBF :- (3-4) 5231995 7370772 8990981 10719210 12307298 13883522 14888842
COTTON GINNING FACTORY
CALCULATION OF MAXIMUM PERMISSABLE BANK FINANCE