SAHARA DRINKING WATER
COST OF THE PROJECT TOTAL A B C D E F chilling plant packing plant 2 No Lab R.O System other Assets Working Capital Margin 2.60 2.40 6.00 11.00 2.00 0.62
(Rs. in Lacs) Term loan MARGIN 2.20 1.80 0.00 0.00 0.00 96.00 0.40 0.60 6.00 11.00 2.00 0.62
TOTAL
24.62
100.00
20.62
MEANS OF FINANCE A B FI TERM LOAN PROMOTERS CAPITAL 100.00 20.62
TOTAL
24.62
ESTIMATE OF COST OF PRODUCTION & PROFITABILITY PARTICULARS Year 1. Gross Receipts i. Sale of packet bags ii Sale of water Cans iii Sale of chilled Cans 0.90 0.12 0.13 10.80 4.32 5.40 11.34 4.54 5.40 11.91 4.76 5.40 12.50 5.00 5.40 13.13 5.25 5.40 I 2010 II 2011 III 2012 (Rs. in Lacs) IV V 2013 2014 VI 2015
2. total receipts 3. Cost of Sales i. Power & Fuel iii. Wages iv. Repairs & Maintenance v. Depreciation Total 4. Selling, General and Administrative expenses 5 VAT 6. Sub Total ( 3 +4+5) 7. Operating Profit Before Interest (2-5) 8. Interest On term loan On Cash credit 8. Operating Profit after Interest ( 6-7 ) 9. Less: Non Operating Exp. 10. Profit Before Tax (8 - 9 ) 11. Provision for Taxes 12. Net Profit ( 10- 11 ) 15. Drawings 16. Retained Profit
1.15
20.52
21.28
22.07
22.90
23.78
0.11 0.17 0.03 0.82 1.14 0.11
2.05 5.13 0.62 3.57 11.37 5.13
2.13 5.32 0.64 3.03 11.12 5.32
2.21 5.52 0.66 2.58 10.97 5.52
2.29 5.73 0.69 2.19 10.90 5.73
2.38 5.94 0.71 1.86 10.90 5.94
1.26 -0.11 3.30 3.13 0.17 -3.41 0.00 -3.41 -3.41 0.00 -3.41
16.50 4.02 11.59 11.07 0.52 -7.57 0.00 -7.57 -7.57 0.00 -7.57
16.44 4.84 8.96 8.44 0.52 -4.12 0.00 -4.12 -4.12 2.00 -6.12
16.48 5.59 6.33 5.81 0.52 -0.74 0.00 -0.74 -0.74 3.00 -3.74
16.62 6.28 3.70 3.18 0.52 2.58 0.00 2.58 2.58 4.00 -1.42
16.84 6.93 1.18 0.66 0.52 5.76 0.00 5.76 5.76 5.00 0.76
As the promotor is in the status of individual and the income is less then the basic examption limits no provision for tax is calculated
CASH FLOW STATEMENT PARTICULARS Year A INFLOW a Net Profit with interest addedback but after depreciation b Increase in Share Capital c Depreciation d Increase in Long-term Loans e Increase In cash credit TOTAL "A" B OUTFLOW a Drawings b Increase in Current Assets c Increase in deposits Repayment of long-term loans d Interest e Taxes g Increase infixed assets TOTAL "B" C Opening Balance D Net Surplus (A - B) E Closing Balance
I 2010
II 2011
III 2012
IV 2013
V 2014
VI 2015
-0.11
4.02
4.84
5.59
6.28
6.93
20.62 0.82 100.00 4.00 125.33
0.00 3.57 0.00 0.00 7.59
0.00 3.03 0.00 0.00 7.87
0.00 2.58 0.00 0.00 8.17
0.00 2.19 0.00 0.00 8.47
0.00 1.86 0.00 0.00 8.80
0.00 2.82 0.00 0.00 3.30 0.00 24.62 30.73 0.00 94.59 94.59
0.00 6.98 0.00 21.05 11.59 0.00 0.00 39.63 94.59 -32.03 62.56
2.00 1.63 0.00 21.05 8.96 0.00 0.00 33.64 62.56 -25.77 36.79
3.00 0.36 0.00 21.05 6.33 0.00 0.00 30.74 36.79 -22.58 14.21
4.00 0.38 0.00 21.05 3.70 0.00 0.00 29.13 14.21 -20.65 -6.44
5.00 0.39 0.00 15.79 1.18 0.00 0.00 22.36 -6.44 -13.56 -20.01
PARTICULARS Year LIABILITIES: Share Capital Retained Earnings Term Loan Cash Credit
I 2010
II 2011
III 2012
IV 2013
V 2014
VI 2015
20.62 -3.41 100.00 4.00
20.62 -10.98 78.95 4.00
20.62 -17.11 57.89 4.00
20.62 -20.85 36.84 4.00
20.62 -22.27 15.79 4.00
20.62 -21.51 0.00 4.00
TOTAL
121.21
92.58
65.41
40.61
18.14
3.11
ASSETS: Fixed Assets Less: Depreciation Net Fixed Assets Stock Water Cans Water packets bags Packing Material receivables Empty cans Cash and Bank Balances
24.62 0.82 23.79
23.79 3.57 20.23
20.23 3.03 17.19
17.19 2.58 14.61
14.61 2.19 12.42
12.42 1.86 10.56
0.05 0.03 0.36 0.38 2.00 94.59
0.57 0.57 3.24 3.42 2.00 62.56
0.89 0.59 3.40 3.55 3.00 36.79
0.92 0.61 3.57 3.68 3.00 14.21
0.95 0.64 3.75 3.82 3.00 -6.44
0.99 0.66 3.94 3.96 3.00 -20.01
TOTAL
121.21
92.58
65.41
40.61
18.14
3.11
PARTICULARS Year GROSS D.S.C.R. STATEMENT Net Profit After Tax Depreciation Interest on Term Loan
0.00 I 2010
0.00 II 2011
0.00 III 2012
0.00 IV 2013
0.00 V 2014
0.00 VI 2015
-3.41 0.82 3.13
-7.57 3.57 11.07
-4.12 3.03 8.44
-0.74 2.58 5.81
2.58 2.19 3.18
5.76 1.86 0.66
Total Cover
0.54
7.07
7.35
7.65
7.95
8.28
Repayment of Term Loan Interest on Term Loan
0.00 3.30
21.05 11.59
21.05 8.96
21.05 6.33
21.05 3.70
15.79 1.18
SERVICE Total Service Gross D.S.C.R. Ratio Average D.S.C.R. Ratio
3.30 0.16 0.20
32.65 0.22
30.02 0.24
27.38 0.28
24.75 0.32
16.97 0.49
PARTICULARS Year NET D.S.C.R. STATEMENT Net Profit After Tax Depreciation
I 2010
II 2011
III 2012
IV 2013
V 2014
VI 2015
-3.41 0.82
-7.57 3.57
-4.12 3.03
-0.74 2.58
2.58 2.19
5.76 1.86
Total Cover Service Repayment of Term Loan
-2.59
-4.00
-1.09
1.83
4.77
7.62
0.00
21.05
21.05
21.05
21.05
15.79
Total Service Net D.S.C.R. Ratio Average D.S.C.R. Ratio
0.00 0.00 0.01
21.05 -0.19
21.05 -0.05
21.05 0.09
21.05 0.23
15.79 0.48
A)
ASSUMPTION MADE IN COST OF PRODUCTION & PROFITABILITY STATEMENT The installed capacity of the unit is estimated at 306000 Ltrs based on 340 working days in a year on Three shift basis The operating capacity is assumed at 75%, 75%, 75%,75%,85% and 95% for 1st, 2nd,3rd,4th and 5th year Wages and salaries are based on actual manpower requirement.
B)
C)
D)
Repairs and maintenance has been provided at Rs.0.11 lakhs from the first year and the provision is Progressively made accordngly Administration expnses is assusmed as 1% of sales in first year and 2% of the sales from second year
F)
G) H)
Selling expenses are assumed at 1% of Gross sales in first yer and 3% from second year Interest per annum is reckoned as follows : On term loan @ 11.25.00%
I)
Depreciation has been calculated on W.D.V method on the following basis Nature of the asset Building Plant & Machinery Lab Equipment Other fixed Assets. Depreciation as per IT act 10% 15% 15% 10%
Assumptions & working
YEAR sale of water packets bags Rate Per Bag Receipts from bag sales Sale Water Cans Rate Per can Receipts fromcans Sale Chilled Water Cans Rate Per can Receipts from cans Total receipts
2010 2000 45 0.90 1000 12 0.12 500.00 25 0.13 1.15
2011 24000 45 10.80 36000 12 4.32 21600 25 5.40 20.52
2012 25200 45 11.34 37800 12 4.54 21600 25 5.40 21.28
2013 26460 45 11.91 39690 12 4.76 21600 25 5.40 22.07
2014 27783 45 12.50 41675 12 5 21600 25 5.40 22.90
2015 29172 45 13.13 43758 12 5.25 21600 25 5.40 23.78
a year
ovision is
CALCULATION OF INTEREST ON TERM LOAN Total Loan Rate of Interest Total Repayment period Moratorium Net Repayment period 100.00 lacs 12.5 60 months 3 months 57 months
S.No.
Opening Balance
Repayment
Closing Balance
Interest 12.50%
(Rs. In Lacs) Total Total InterestRepayment
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58
100.00 100.00 100.00 100.00 98.25 96.49 94.74 92.98 91.23 89.47 87.72 85.96 84.21 82.46 80.70 78.95 77.19 75.44 73.68 71.93 70.18 68.42 66.67 64.91 63.16 61.40 59.65 57.89 56.14 54.39 52.63 50.88 49.12 47.37 45.61 43.86 42.11 40.35 38.60 36.84 35.09 33.33 31.58 29.82 28.07 26.32 24.56 22.81 21.05 19.30 17.54 15.79 14.04 12.28 10.53 8.77 7.02 5.26
0.00 0.00 0.00 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75
100.00 100.00 100.00 98.25 96.49 94.74 92.98 91.23 89.47 87.72 85.96 84.21 82.46 80.70 78.95 77.19 75.44 73.68 71.93 70.18 68.42 66.67 64.91 63.16 61.40 59.65 57.89 56.14 54.39 52.63 50.88 49.12 47.37 45.61 43.86 42.11 40.35 38.60 36.84 35.09 33.33 31.58 29.82 28.07 26.32 24.56 22.81 21.05 19.30 17.54 15.79 14.04 12.28 10.53 8.77 7.02 5.26 3.51
1.04 1.04 1.04 1.02 1.01 0.99 0.97 0.95 0.93 0.91 0.90 0.88 0.86 0.84 0.82 0.80 0.79 0.77 0.75 0.73 0.71 0.69 0.68 0.66 0.64 0.62 0.60 0.58 0.57 0.55 0.53 0.51 0.49 0.48 0.46 0.44 0.42 0.40 0.38 0.37 0.35 0.33 0.31 0.29 0.27 0.26 0.24 0.22 0.20 0.18 0.16 0.15 0.13 0.11 0.09 0.07 0.05 0.04
3.13
11.07
8.44
5.81
3.18
January Feb March April May June July August Sep Oct Nov Dec January Feb 21.05 March April May June July August Sep Oct Nov Dec January Feb 21.05 March April May June July August Sep Oct Nov Dec January Feb 21.05 March April May June July August Sep Oct Nov Dec January Feb 21.05 March April may june july August Sep oct
2010
2011
2012
2013
2014
59 60
3.51 1.75
1.75 1.75
1.75 0.00
0.02 0.00
nov 0.66
15.79 dec
I
II
III
IV
V
VI
(A) POWER & FUEL:
Energy Charges
units per unit
3060.00 3.75
0.11
0.14
0.18
0.22
0.28
0.35
Wages Wages are based on production. production 25 25 75 25 75 25 75 25 75 25 75 #REF!
Rs 1.50 per meter Produced 37.5 how ever it is assumed that rate per meter will be inceased to 3from 2011
DEPRECIATION GROSS BLOCK Land Buildings Plant & Machinery Electrical Equipment Motors Other fixed Assets
2.60 2.40 6.00 11.00 2.00 0.00 24.00
2.60 2.40 6.00 11.00 2.00 0.00 0.00 24.00
2.60 2.40 6.00 11.00 2.00 0.00 0.00 24.00
2.60 2.40 6.00 11.00 2.00 0.00 0.00 24.00
2.60 2.40 6.00 11.00 2.00 0.00 0.00 24.00
2.60 2.40 6.00 11.00 2.00 0.00 24.00
OPENING W.D.V Land Buildings Plant & Machinery Electrical Equipment Motors Other fixed Assets
2.60 2.40 6.00 11.00 2.00 0.00 0.00 24.00 0.00 0.12
2.60 2.28 5.70 10.45 1.90 0.00 0.00 22.93 0.00 0.23
2.60 2.05 4.85 8.88 1.62 0.00 0.00 19.99 0.00 0.21
2.60 1.85 4.12 7.55 1.37 0.00 0.00 17.49 0.00 0.18
2.60 1.66 3.50 6.42 1.17 0.00 0.00 15.35 0.00 0.17
2.60 1.50 2.98 5.45 0.99 0.00 0.00 13.52
Depreciation: Land Buildings ( 10%)
0.15
Plant & Machinery ( 15%) Electrical Equipment (15%) Motors(15%) Other fixed Assets (10%)
0.30 0.55 0.10 0.00 0.00 1.07
0.86 1.57 0.29 0.00 0.00 2.94
0.73 1.33 0.24 0.00 0.00 2.51
0.62 1.13 0.21 0.00 0.00 2.14
0.53 0.96 0.18 0.00 0.00 1.83
0.45 0.82 0.15 0.00 0.00 1.56
SELLING, GENERAL & ADMINISTRATIVE EXP. Salaries Other Admin. Expesnes Selling Expenses 24000.00 0.25 0.00 24000.25 96000.00 0.50 0.00 96000.50 96000.00 1.00 0.00 96001.00 96000.00 2.00 0.00 96002.00 96000.00 4.00 0.00 96004.00 96000.00 8.00 0.00 96008.00
FINANCE CHARGES: Interest on FI Loan Total Interest Raw Materials: Plastic Gitti Plastic Dana 0.80 0.20
0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
0.66 0.66
16000.00 5000.00 21000.00
864000.00 252000.00 1116000.00
907200.00 264600.00 1171800.00
952560.00 277830.00 1230390.00
1000188.00 291721.50 1291909.50
1050197.40 306307.58 1356504.98
.80 kg of gitti and .20 kg of dana is required to manufacture 1metre of HDFE pipe Gitti is 20 per KG How ever it is assumed that rawmaterial cost will increase by RS 10 from year 2010-11 Dana is 25 per KG INCOME TAX CALCULATIONS Net Profit -3.41 0.00 -7.57 -4.12 -0.74 2.58 5.76
Loss of previous year
-3.41
0.0000000
Net Taxable Income
-3.41
-10.98
-4.12
-0.74
2.58
5.76
Provision For Tax
-
1.12
6.25
7.02
7.76
8.46
0.00 0.00 0.00 0.00
5.76 1.86 0.00
7.62
7.62
0.46 0.00 0.00 0.00 0.00 0.00 0.46
ASSESSMENT OF WORKING CAPITAL: Particulars Days I 2010 II 2011 III 2012 IV 2013
(Rs. In Lacs) V 2014
Empty Cans Finished Goods Bills Receivables Packing materials 15 90 120
2.00 0.08 0.38 0.36
2.00 1.14 3.42 3.24
3.00 1.48 3.55 3.40
3.00 1.53 3.68 3.57
3.00 1.59 3.82 3.75
Working Capital Gap Margin Money
2.46 0.62 1.85
6.56 1.64 4.92
8.02 2.01 6.02
8.21 2.05 6.16
8.41 2.10 6.31
Applied
4.00
4.00
4.00
4.00
4.00
As packing material is pre printed so the same is stocked required for 2 months
Empty Cans are refilling cans there fore the same as to be replaced every year year 2010 operationa will be carried for 3 months as unit is setup in the month of january
Cash Inflow
I 2011 -3.41 0.82 0.00 -2.59
II 2012 -7.57 3.57 0.00 -4.00
III 2013 -6.12 3.03 0.00 -3.09
IV 2014 -3.74 2.58 0.00 -1.17
(Rs. In Lacs) V 2015 -1.42 2.19 0.00 0.77
VI 2016 0.76 1.86 0.00 2.62
PAT Depreciation Pre-Op. Exp. TOTAL
Year Capital Outlay 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 -24.62 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Benefits
Net Discount Benefits Factor 20% -24.62 -2.59 -4.00 -3.09 -1.17 0.77 2.62 2.62 2.62 2.62 2.62 2.62 2.62 2.62 2.62 2.62 1.00 0.83 0.69 0.58 0.48 0.40 0.33 0.28 0.23 0.19 0.16 0.13 0.11 0.09 0.08 0.06
Present Value -24.62 -2.16 -2.78 -1.79 -0.56 0.31 0.88 0.73 0.61 0.51 0.42 0.35 0.29 0.24 0.20 0.17
DF 57% 1.00 0.64 0.41 0.26 0.16 0.10 0.07 0.04 0.03 0.02 0.01 0.01 0.00 0.00 0.00 0.00
Present Value -24.62 -1.65 -1.62 -0.80 -0.19 0.08 0.17 0.11 0.07 0.05 0.03 0.02 0.01 0.01 0.00 0.00
0.00 -2.59 -4.00 -3.09 -1.17 0.77 2.62 2.62 2.62 2.62 2.62 2.62 2.62 2.62 2.62 2.62
TOTAL Internal Rate of Return -2.77%
-27.18
-28.32
SENSITIVITY ANALYSIS
PARAMETER NORMAL 5% INCREASE IN R.M. 5% DECREASE IN REVENUE
DSCR BEP( %) IRR(%)
2.24 40.63 26.60
1.82 49.67 20.98
1.64 54.32 18.33
The unit is able to sustain 5% increase in rawmaterial prices, or 5% decrease in rev
REVENUE
es, or 5% decrease in revenue
doc_301999940.xls
COST OF THE PROJECT TOTAL A B C D E F chilling plant packing plant 2 No Lab R.O System other Assets Working Capital Margin 2.60 2.40 6.00 11.00 2.00 0.62
(Rs. in Lacs) Term loan MARGIN 2.20 1.80 0.00 0.00 0.00 96.00 0.40 0.60 6.00 11.00 2.00 0.62
TOTAL
24.62
100.00
20.62
MEANS OF FINANCE A B FI TERM LOAN PROMOTERS CAPITAL 100.00 20.62
TOTAL
24.62
ESTIMATE OF COST OF PRODUCTION & PROFITABILITY PARTICULARS Year 1. Gross Receipts i. Sale of packet bags ii Sale of water Cans iii Sale of chilled Cans 0.90 0.12 0.13 10.80 4.32 5.40 11.34 4.54 5.40 11.91 4.76 5.40 12.50 5.00 5.40 13.13 5.25 5.40 I 2010 II 2011 III 2012 (Rs. in Lacs) IV V 2013 2014 VI 2015
2. total receipts 3. Cost of Sales i. Power & Fuel iii. Wages iv. Repairs & Maintenance v. Depreciation Total 4. Selling, General and Administrative expenses 5 VAT 6. Sub Total ( 3 +4+5) 7. Operating Profit Before Interest (2-5) 8. Interest On term loan On Cash credit 8. Operating Profit after Interest ( 6-7 ) 9. Less: Non Operating Exp. 10. Profit Before Tax (8 - 9 ) 11. Provision for Taxes 12. Net Profit ( 10- 11 ) 15. Drawings 16. Retained Profit
1.15
20.52
21.28
22.07
22.90
23.78
0.11 0.17 0.03 0.82 1.14 0.11
2.05 5.13 0.62 3.57 11.37 5.13
2.13 5.32 0.64 3.03 11.12 5.32
2.21 5.52 0.66 2.58 10.97 5.52
2.29 5.73 0.69 2.19 10.90 5.73
2.38 5.94 0.71 1.86 10.90 5.94
1.26 -0.11 3.30 3.13 0.17 -3.41 0.00 -3.41 -3.41 0.00 -3.41
16.50 4.02 11.59 11.07 0.52 -7.57 0.00 -7.57 -7.57 0.00 -7.57
16.44 4.84 8.96 8.44 0.52 -4.12 0.00 -4.12 -4.12 2.00 -6.12
16.48 5.59 6.33 5.81 0.52 -0.74 0.00 -0.74 -0.74 3.00 -3.74
16.62 6.28 3.70 3.18 0.52 2.58 0.00 2.58 2.58 4.00 -1.42
16.84 6.93 1.18 0.66 0.52 5.76 0.00 5.76 5.76 5.00 0.76
As the promotor is in the status of individual and the income is less then the basic examption limits no provision for tax is calculated
CASH FLOW STATEMENT PARTICULARS Year A INFLOW a Net Profit with interest addedback but after depreciation b Increase in Share Capital c Depreciation d Increase in Long-term Loans e Increase In cash credit TOTAL "A" B OUTFLOW a Drawings b Increase in Current Assets c Increase in deposits Repayment of long-term loans d Interest e Taxes g Increase infixed assets TOTAL "B" C Opening Balance D Net Surplus (A - B) E Closing Balance
I 2010
II 2011
III 2012
IV 2013
V 2014
VI 2015
-0.11
4.02
4.84
5.59
6.28
6.93
20.62 0.82 100.00 4.00 125.33
0.00 3.57 0.00 0.00 7.59
0.00 3.03 0.00 0.00 7.87
0.00 2.58 0.00 0.00 8.17
0.00 2.19 0.00 0.00 8.47
0.00 1.86 0.00 0.00 8.80
0.00 2.82 0.00 0.00 3.30 0.00 24.62 30.73 0.00 94.59 94.59
0.00 6.98 0.00 21.05 11.59 0.00 0.00 39.63 94.59 -32.03 62.56
2.00 1.63 0.00 21.05 8.96 0.00 0.00 33.64 62.56 -25.77 36.79
3.00 0.36 0.00 21.05 6.33 0.00 0.00 30.74 36.79 -22.58 14.21
4.00 0.38 0.00 21.05 3.70 0.00 0.00 29.13 14.21 -20.65 -6.44
5.00 0.39 0.00 15.79 1.18 0.00 0.00 22.36 -6.44 -13.56 -20.01
PARTICULARS Year LIABILITIES: Share Capital Retained Earnings Term Loan Cash Credit
I 2010
II 2011
III 2012
IV 2013
V 2014
VI 2015
20.62 -3.41 100.00 4.00
20.62 -10.98 78.95 4.00
20.62 -17.11 57.89 4.00
20.62 -20.85 36.84 4.00
20.62 -22.27 15.79 4.00
20.62 -21.51 0.00 4.00
TOTAL
121.21
92.58
65.41
40.61
18.14
3.11
ASSETS: Fixed Assets Less: Depreciation Net Fixed Assets Stock Water Cans Water packets bags Packing Material receivables Empty cans Cash and Bank Balances
24.62 0.82 23.79
23.79 3.57 20.23
20.23 3.03 17.19
17.19 2.58 14.61
14.61 2.19 12.42
12.42 1.86 10.56
0.05 0.03 0.36 0.38 2.00 94.59
0.57 0.57 3.24 3.42 2.00 62.56
0.89 0.59 3.40 3.55 3.00 36.79
0.92 0.61 3.57 3.68 3.00 14.21
0.95 0.64 3.75 3.82 3.00 -6.44
0.99 0.66 3.94 3.96 3.00 -20.01
TOTAL
121.21
92.58
65.41
40.61
18.14
3.11
PARTICULARS Year GROSS D.S.C.R. STATEMENT Net Profit After Tax Depreciation Interest on Term Loan
0.00 I 2010
0.00 II 2011
0.00 III 2012
0.00 IV 2013
0.00 V 2014
0.00 VI 2015
-3.41 0.82 3.13
-7.57 3.57 11.07
-4.12 3.03 8.44
-0.74 2.58 5.81
2.58 2.19 3.18
5.76 1.86 0.66
Total Cover
0.54
7.07
7.35
7.65
7.95
8.28
Repayment of Term Loan Interest on Term Loan
0.00 3.30
21.05 11.59
21.05 8.96
21.05 6.33
21.05 3.70
15.79 1.18
SERVICE Total Service Gross D.S.C.R. Ratio Average D.S.C.R. Ratio
3.30 0.16 0.20
32.65 0.22
30.02 0.24
27.38 0.28
24.75 0.32
16.97 0.49
PARTICULARS Year NET D.S.C.R. STATEMENT Net Profit After Tax Depreciation
I 2010
II 2011
III 2012
IV 2013
V 2014
VI 2015
-3.41 0.82
-7.57 3.57
-4.12 3.03
-0.74 2.58
2.58 2.19
5.76 1.86
Total Cover Service Repayment of Term Loan
-2.59
-4.00
-1.09
1.83
4.77
7.62
0.00
21.05
21.05
21.05
21.05
15.79
Total Service Net D.S.C.R. Ratio Average D.S.C.R. Ratio
0.00 0.00 0.01
21.05 -0.19
21.05 -0.05
21.05 0.09
21.05 0.23
15.79 0.48
A)
ASSUMPTION MADE IN COST OF PRODUCTION & PROFITABILITY STATEMENT The installed capacity of the unit is estimated at 306000 Ltrs based on 340 working days in a year on Three shift basis The operating capacity is assumed at 75%, 75%, 75%,75%,85% and 95% for 1st, 2nd,3rd,4th and 5th year Wages and salaries are based on actual manpower requirement.
B)
C)
D)
Repairs and maintenance has been provided at Rs.0.11 lakhs from the first year and the provision is Progressively made accordngly Administration expnses is assusmed as 1% of sales in first year and 2% of the sales from second year
F)
G) H)
Selling expenses are assumed at 1% of Gross sales in first yer and 3% from second year Interest per annum is reckoned as follows : On term loan @ 11.25.00%
I)
Depreciation has been calculated on W.D.V method on the following basis Nature of the asset Building Plant & Machinery Lab Equipment Other fixed Assets. Depreciation as per IT act 10% 15% 15% 10%
Assumptions & working
YEAR sale of water packets bags Rate Per Bag Receipts from bag sales Sale Water Cans Rate Per can Receipts fromcans Sale Chilled Water Cans Rate Per can Receipts from cans Total receipts
2010 2000 45 0.90 1000 12 0.12 500.00 25 0.13 1.15
2011 24000 45 10.80 36000 12 4.32 21600 25 5.40 20.52
2012 25200 45 11.34 37800 12 4.54 21600 25 5.40 21.28
2013 26460 45 11.91 39690 12 4.76 21600 25 5.40 22.07
2014 27783 45 12.50 41675 12 5 21600 25 5.40 22.90
2015 29172 45 13.13 43758 12 5.25 21600 25 5.40 23.78
a year
ovision is
CALCULATION OF INTEREST ON TERM LOAN Total Loan Rate of Interest Total Repayment period Moratorium Net Repayment period 100.00 lacs 12.5 60 months 3 months 57 months
S.No.
Opening Balance
Repayment
Closing Balance
Interest 12.50%
(Rs. In Lacs) Total Total InterestRepayment
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58
100.00 100.00 100.00 100.00 98.25 96.49 94.74 92.98 91.23 89.47 87.72 85.96 84.21 82.46 80.70 78.95 77.19 75.44 73.68 71.93 70.18 68.42 66.67 64.91 63.16 61.40 59.65 57.89 56.14 54.39 52.63 50.88 49.12 47.37 45.61 43.86 42.11 40.35 38.60 36.84 35.09 33.33 31.58 29.82 28.07 26.32 24.56 22.81 21.05 19.30 17.54 15.79 14.04 12.28 10.53 8.77 7.02 5.26
0.00 0.00 0.00 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75
100.00 100.00 100.00 98.25 96.49 94.74 92.98 91.23 89.47 87.72 85.96 84.21 82.46 80.70 78.95 77.19 75.44 73.68 71.93 70.18 68.42 66.67 64.91 63.16 61.40 59.65 57.89 56.14 54.39 52.63 50.88 49.12 47.37 45.61 43.86 42.11 40.35 38.60 36.84 35.09 33.33 31.58 29.82 28.07 26.32 24.56 22.81 21.05 19.30 17.54 15.79 14.04 12.28 10.53 8.77 7.02 5.26 3.51
1.04 1.04 1.04 1.02 1.01 0.99 0.97 0.95 0.93 0.91 0.90 0.88 0.86 0.84 0.82 0.80 0.79 0.77 0.75 0.73 0.71 0.69 0.68 0.66 0.64 0.62 0.60 0.58 0.57 0.55 0.53 0.51 0.49 0.48 0.46 0.44 0.42 0.40 0.38 0.37 0.35 0.33 0.31 0.29 0.27 0.26 0.24 0.22 0.20 0.18 0.16 0.15 0.13 0.11 0.09 0.07 0.05 0.04
3.13
11.07
8.44
5.81
3.18
January Feb March April May June July August Sep Oct Nov Dec January Feb 21.05 March April May June July August Sep Oct Nov Dec January Feb 21.05 March April May June July August Sep Oct Nov Dec January Feb 21.05 March April May June July August Sep Oct Nov Dec January Feb 21.05 March April may june july August Sep oct
2010
2011
2012
2013
2014
59 60
3.51 1.75
1.75 1.75
1.75 0.00
0.02 0.00
nov 0.66
15.79 dec
I
II
III
IV
V
VI
(A) POWER & FUEL:
Energy Charges
units per unit
3060.00 3.75
0.11
0.14
0.18
0.22
0.28
0.35
Wages Wages are based on production. production 25 25 75 25 75 25 75 25 75 25 75 #REF!
Rs 1.50 per meter Produced 37.5 how ever it is assumed that rate per meter will be inceased to 3from 2011
DEPRECIATION GROSS BLOCK Land Buildings Plant & Machinery Electrical Equipment Motors Other fixed Assets
2.60 2.40 6.00 11.00 2.00 0.00 24.00
2.60 2.40 6.00 11.00 2.00 0.00 0.00 24.00
2.60 2.40 6.00 11.00 2.00 0.00 0.00 24.00
2.60 2.40 6.00 11.00 2.00 0.00 0.00 24.00
2.60 2.40 6.00 11.00 2.00 0.00 0.00 24.00
2.60 2.40 6.00 11.00 2.00 0.00 24.00
OPENING W.D.V Land Buildings Plant & Machinery Electrical Equipment Motors Other fixed Assets
2.60 2.40 6.00 11.00 2.00 0.00 0.00 24.00 0.00 0.12
2.60 2.28 5.70 10.45 1.90 0.00 0.00 22.93 0.00 0.23
2.60 2.05 4.85 8.88 1.62 0.00 0.00 19.99 0.00 0.21
2.60 1.85 4.12 7.55 1.37 0.00 0.00 17.49 0.00 0.18
2.60 1.66 3.50 6.42 1.17 0.00 0.00 15.35 0.00 0.17
2.60 1.50 2.98 5.45 0.99 0.00 0.00 13.52
Depreciation: Land Buildings ( 10%)
0.15
Plant & Machinery ( 15%) Electrical Equipment (15%) Motors(15%) Other fixed Assets (10%)
0.30 0.55 0.10 0.00 0.00 1.07
0.86 1.57 0.29 0.00 0.00 2.94
0.73 1.33 0.24 0.00 0.00 2.51
0.62 1.13 0.21 0.00 0.00 2.14
0.53 0.96 0.18 0.00 0.00 1.83
0.45 0.82 0.15 0.00 0.00 1.56
SELLING, GENERAL & ADMINISTRATIVE EXP. Salaries Other Admin. Expesnes Selling Expenses 24000.00 0.25 0.00 24000.25 96000.00 0.50 0.00 96000.50 96000.00 1.00 0.00 96001.00 96000.00 2.00 0.00 96002.00 96000.00 4.00 0.00 96004.00 96000.00 8.00 0.00 96008.00
FINANCE CHARGES: Interest on FI Loan Total Interest Raw Materials: Plastic Gitti Plastic Dana 0.80 0.20
0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
0.66 0.66
16000.00 5000.00 21000.00
864000.00 252000.00 1116000.00
907200.00 264600.00 1171800.00
952560.00 277830.00 1230390.00
1000188.00 291721.50 1291909.50
1050197.40 306307.58 1356504.98
.80 kg of gitti and .20 kg of dana is required to manufacture 1metre of HDFE pipe Gitti is 20 per KG How ever it is assumed that rawmaterial cost will increase by RS 10 from year 2010-11 Dana is 25 per KG INCOME TAX CALCULATIONS Net Profit -3.41 0.00 -7.57 -4.12 -0.74 2.58 5.76
Loss of previous year
-3.41
0.0000000
Net Taxable Income
-3.41
-10.98
-4.12
-0.74
2.58
5.76
Provision For Tax
-
1.12
6.25
7.02
7.76
8.46
0.00 0.00 0.00 0.00
5.76 1.86 0.00
7.62
7.62
0.46 0.00 0.00 0.00 0.00 0.00 0.46
ASSESSMENT OF WORKING CAPITAL: Particulars Days I 2010 II 2011 III 2012 IV 2013
(Rs. In Lacs) V 2014
Empty Cans Finished Goods Bills Receivables Packing materials 15 90 120
2.00 0.08 0.38 0.36
2.00 1.14 3.42 3.24
3.00 1.48 3.55 3.40
3.00 1.53 3.68 3.57
3.00 1.59 3.82 3.75
Working Capital Gap Margin Money
2.46 0.62 1.85
6.56 1.64 4.92
8.02 2.01 6.02
8.21 2.05 6.16
8.41 2.10 6.31
Applied
4.00
4.00
4.00
4.00
4.00
As packing material is pre printed so the same is stocked required for 2 months
Empty Cans are refilling cans there fore the same as to be replaced every year year 2010 operationa will be carried for 3 months as unit is setup in the month of january
Cash Inflow
I 2011 -3.41 0.82 0.00 -2.59
II 2012 -7.57 3.57 0.00 -4.00
III 2013 -6.12 3.03 0.00 -3.09
IV 2014 -3.74 2.58 0.00 -1.17
(Rs. In Lacs) V 2015 -1.42 2.19 0.00 0.77
VI 2016 0.76 1.86 0.00 2.62
PAT Depreciation Pre-Op. Exp. TOTAL
Year Capital Outlay 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 -24.62 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Benefits
Net Discount Benefits Factor 20% -24.62 -2.59 -4.00 -3.09 -1.17 0.77 2.62 2.62 2.62 2.62 2.62 2.62 2.62 2.62 2.62 2.62 1.00 0.83 0.69 0.58 0.48 0.40 0.33 0.28 0.23 0.19 0.16 0.13 0.11 0.09 0.08 0.06
Present Value -24.62 -2.16 -2.78 -1.79 -0.56 0.31 0.88 0.73 0.61 0.51 0.42 0.35 0.29 0.24 0.20 0.17
DF 57% 1.00 0.64 0.41 0.26 0.16 0.10 0.07 0.04 0.03 0.02 0.01 0.01 0.00 0.00 0.00 0.00
Present Value -24.62 -1.65 -1.62 -0.80 -0.19 0.08 0.17 0.11 0.07 0.05 0.03 0.02 0.01 0.01 0.00 0.00
0.00 -2.59 -4.00 -3.09 -1.17 0.77 2.62 2.62 2.62 2.62 2.62 2.62 2.62 2.62 2.62 2.62
TOTAL Internal Rate of Return -2.77%
-27.18
-28.32
SENSITIVITY ANALYSIS
PARAMETER NORMAL 5% INCREASE IN R.M. 5% DECREASE IN REVENUE
DSCR BEP( %) IRR(%)
2.24 40.63 26.60
1.82 49.67 20.98
1.64 54.32 18.33
The unit is able to sustain 5% increase in rawmaterial prices, or 5% decrease in rev
REVENUE
es, or 5% decrease in revenue
doc_301999940.xls