SRI VENKATESWARA HALLOW BRICKS
PROP : RAMAVATH VENKATESWARLU
TEEKYA THANDA ROAD, VENKATADRIPALEM, MIRYALGUDA, NALGONDA DIST.,
Name of the Unit/ Industry : Sri Venkateswara Cement Hallow Bricks
Name of the Proprietor : Ramavath Venkateswarlu
Teekya Thanda Road, Venkatadripalem Miryalaguda,
Nalgonda Dist.,
Type of the Unit : Hallow Bricks
Name & Communication Address : Sri Venkateswara Cement Hallow Bricks
Teekya Thanda Road, Venkatadripalem Miryalaguda
Nalgonda Dist.
Category : ST Category
Constitution : Proprietory Concern
Amount Rs. Amount Rs. Amount Rs.
COST OF PROJECT :
(1). LAND 0 0
(2). CIVIL WORKS - SHED & BUILDING
- Civil Construction 500000
- Platform 500000 1000000
(3). MACHINERY & EQUIPMENT 995000 995000
- Hallow Brick Mfg. machine
(4). ELECTRICITY & FITTINGS 55000 55000
(5). CEMENT & OTHER RAW MATERIALS 450000 450000
- Cement, Stone Chips, Ash etc.
Sub Total 2500000
TOTAL COST OF PROJECT : 2500000
MEANCE OF FINANCE :
(1). PROMOTER'S AND OWNERS CONTRIBUTION
- Ramavath Venkateswarlu 200000
R/o. Venkatadripalem, Miryalguda
Sub Total 200000
(2). PROPOSED LOAN
- Term Loan by Bank, 2300000
Sub Total 2300000
TOTAL MEANCE OF FINANCE : 2500000
yalaguda,
alaguda
SRI VENKATESWARA HALLOW BRICKS
TEEKYA THANDA ROAD, VENKATADRIPALEM, MIRYALGUDA, NALGONDA DIST.,
PROJECTED PROFIT & LOSS ACCOUNT
PARTICULARS Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7
INCOME :
Gross Sales/Receipts 3372870 3878801 4460621 5129714 5899171 6784046 7801653
Closing Stock 505931 581820 669093 769457 884876 1017607 1170248
NET INCOME 3878801 4460621 5129714 5899171 6784046 7801653 8971901
EXPENDITURE :
Opening Stock 0 505931 581820 669093 769457 884876 1017607
Raw Material Consumption 2545870 2542580 3015470 3587123 4125191 4789252 5507640
Salaries & Wages 240000 288000 345600 414720 497664 597197 666636
Power & Fuel 36250 43500 52200 62640 75168 90202 108242
Freight & Carriage 56870 68244 81893 98271 117926 141511 169813
Miscellaneous Expenses 21653 25984 31180 37416 44900 53880 64656
Repairs & Maintanance Expens 16980 20376 24451 29341 35210 42252 50702
Gen. Insurance 9800 11760 14112 16934 20321 24386 29263
Selling & Admn. Expenses 31500 37800 45360 54432 65318 78382 94058
Depreciation 148250 128513 111486 96788 84092 73119 63627
TOTAL 3107173 3672687 4303572 5066759 5835247 6775054 7772243
Profit Before Interest & Tax 771628 787934 826142 832411 948799 1026599 1199658
Interest on Term Loan 251291 213217 174948 136427 97907 59386 20865
Interest on Working Capital Lo 0 0 0 0 0 0 0
Profit Before Tax (PBT) 520336 574717 651194 695984 850892 967213 1178792
Provision for Taxes 0 0 0 0 0 0 0
PROFIT AFTER TAX (PAT) 520336 574717 651194 695984 850892 967213 1178792
668586 703230 762679 792772 934984
G.P 40% 36% 34% 32% 32% 31% 31%
15.43% 14.82% 14.60% 13.57% 14.42% 14.26% 15.11%
SRI VENKATESWARA HALLOW BRICKS
TEEKYA THANDA ROAD, VENKATADRIPALEM, MIRYALGUDA, NALGONDA DIST.,
PROJECTED BALANCE SHEET
PARTICULARS Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7
LIABILITIES :
Capital A/c 200000 200000 200000 200000 200000 200000 200000
2. Reserves & Surplus 0 320336 595054 946247 1392231 1893123 2610336
Add: Net Profit 520336 574717 651194 695984 850892 967213 1178792
Less: Drawings 200000 300000 300000 250000 350000 250000 300000
Total 320336 595054 946247 1392231 1893123 2610336 3489129
3. Term Loan by Bank 2145660 1791660 1433328 1074996 716664 358332 0
5. Provision for Taxes 0 0 0 0 0 0 0
6. Working Capital Loan 105300 105300 105300 105300 105300 105300 105300
7. Sundry Creditors 45870 55044 66053 79263 95116 114139 136967
8. Govt Grant 0 0 0 0 0 0 0
TOTAL LIABILITIES : 2817166 2747058 2750928 2851790 3010203 3388108 3931396
ASSETS :
1. Machinery 600000 510000 433500 368475 313204 266223 226290
( - ) Depr. @ 15% 90000 76500 65025 55271 46981 39933 33943
510000 433500 368475 313204 266223 226290 192346
2. Electrical Fitting 55000 46750 39738 33777 28710 24404 20743
( - ) Depr. @ 10% 8250 7013 5961 5067 4307 3661 3111
46750 39738 33777 28710 24404 20743 17632
3. Civil Works 500000 450000 405000 364500 328050 295245 265721
( - ) Depr. @ 10% 50000 45000 40500 36450 32805 29525 26572
450000 405000 364500 328050 295245 265721 239148
Net Block 1006750 878238 766752 669964 585872 512753 449126
2. CURRENT ASSETS :
Cash in Hand & Bank 569086 680200 819983 976969 1184156 1493047 1887421
Sundry Debtors 485400 356800 245100 185400 105300 114700 174600
Closing Stock 505931 581820 669093 769457 884876 1017607 1170248
Bank Deposit 250000 250000 250000 250000 250000 250000 250000
0
TOTAL ASSETS : 2817166 2747058 2750928 2851790 3010203 3388108 3931396
2817166 2747058 2750928 2851790 3010203 3388108 3931396
0 0 0 0 0 0 0
SRI VENKATESWARA HALLOW BRICKS
TEEKYA THANDA ROAD, VENKATADRIPALEM, MIRYALGUDA, NALGONDA DIST.,
DEBT SERVICE COVERAGE RATIO :
PARTICULARS Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 TOTAL
Cash accruals :
Profit after Tax 520336 574717 651194 695984 850892 967213 1178792 5439129
Depreciation 148250 128513 111486 96788 84092 73119 63627 705874
Interest on Term Loan 251291 213217 174948 136427 97907 59386 20865 954042
Interest on [Link] 0 0 0 0 0 0 0 0
Total 919878 916446 937627 929199 1032891 1099718 1263285 7099044
Repayment Obligation:
Interest on Term Loan 251291 213217 174948 136427 97907 59386 20865 954042
Interest on [Link] 0 0 0 0 0 0 0 0
Repayment of Term Loan 354340 354000 358332 358332 358332 358332 358332 2500000
Total : 605631 567217 533280 494759 456239 417718 379197 3454042
DSCR 1.52 1.62 1.76 1.88 2.26 2.63 3.33
Min. DSCR 1.52
Max. DSCR 3.33
Avg. DSCR 2.14
SRI VENKATESWARA HALLOW BRICKS
TEEKYA THANDA ROAD, VENKATADRIPALEM, MIRYALGUDA, NALGONDA DIST.,
RATIO ANALYSIS OF THE PROJECT
Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7
1. DEBT EQUITY RATIO :
Total Long Term + [Link] 2145660 1791660 1433328 1074996 716664 358332 0
Total Capital Employed 200000 200000 200000 200000 200000 200000 200000
10.73 8.96 7.17 5.37 3.58 1.79 0.00
[Link] PROFIT TO RECEIPTS
Net Profit 520336 574717 651194 695984 850892 967213 1178792
Gross Receipts 3372870 3878801 4460621 5129714 5899171 6784046 7801653
15.43 14.82 14.60 13.57 14.42 14.26 15.11
3. TOTAL INTEREST TO RECEIPTS
Total Interest 251291 213217 174948 136427 97907 59386 20865
Gross Receipts 3372870 3878801 4460621 5129714 5899171 6784046 7801653
7.45 5.50 3.92 2.66 1.66 0.88 0.27
4. TOTAL LONG TERM LOANS TO
GROSS RECEIPTS
Total Long Term Debts 2145660 1791660 1433328 1074996 716664 358332 0
Gross Receipts 3372870 3878801 4460621 5129714 5899171 6784046 7801653
0.64 0.46 0.32 0.21 0.12 0.05 0.00
5. Current Assets
Current Liabilites
Current Assets 1810416 1868820 1984176 2181826 2424331 2875354 3482269
Current Liabilites 505510 514344 529685 542895 558748 577771 600599
3.58 3.63 3.75 4.02 4.34 4.98 5.80
INTEREST CHART
SRI VENKATESWARA HALLOW BRICKS
TEEKYA THANDA ROAD, VENKATADRIPALEM, MIRYALGUDA, NALGONDA DIST.,
Statement of Term Loann Repayment and Interest Calculations :
( Repayment in Years (84 Monthly Installments) @ 10.75% p.a. Interest Rate )
INSTALLMENT OPENING CLOSING TOTAL TO BE
YEAR NO. BALANCE INSTALLMENT BALANCE INTEREST PAID
1st 1 2500000 29530 2470470 22396 51926
2 2470470 29530 2440940 22131 51661
3 2440940 29528 2411412 21867 51395
4 2411412 29528 2381884 21602 51130
5 2381884 29528 2352356 21338 50866
6 2352356 29528 2322828 21073 50601
7 2322828 29528 2293300 20809 50337
8 2293300 29528 2263772 20544 50072
9 2263772 29528 2234244 20280 49808
10 2234244 29528 2204716 20015 49543
11 2204716 29528 2175188 19751 49279
12 2175188 29528 2145660 19486 49014
Total 354340 251291 605631
2nd 1 2145660 29500 2116160 19222 48722
2 2116160 29500 2086660 18957 48457
3 2086660 29500 2057160 18693 48193
4 2057160 29500 2027660 18429 47929
5 2027660 29500 1998160 18164 47664
6 1998160 29500 1968660 17900 47400
7 1968660 29500 1939160 17636 47136
8 1939160 29500 1909660 17372 46872
9 1909660 29500 1880160 17107 46607
10 1880160 29500 1850660 16843 46343
11 1850660 29500 1821160 16579 46079
12 1821160 29500 1791660 16315 45815
Total 354000 213217 567217
3rd 1 1791660 29861 1761799 16050 45911
2 1761799 29861 1731938 15783 45644
3 1731938 29861 1702077 15515 45376
4 1702077 29861 1672216 15248 45109
5 1672216 29861 1642355 14980 44841
6 1642355 29861 1612494 14713 44574
7 1612494 29861 1582633 14445 44306
8 1582633 29861 1552772 14178 44039
9 1552772 29861 1522911 13910 43771
10 1522911 29861 1493050 13643 43504
11 1493050 29861 1463189 13375 43236
12 1463189 29861 1433328 13108 42969
Total 358332 174948 533280
4th 1 1433328 29861 1403467 12840 42701
2 1403467 29861 1373606 12573 42434
3 1373606 29861 1343745 12305 42166
4 1343745 29861 1313884 12038 41899
5 1313884 29861 1284023 11770 41631
6 1284023 29861 1254162 11503 41364
7 1254162 29861 1224301 11235 41096
8 1224301 29861 1194440 10968 40829
9 1194440 29861 1164579 10700 40561
10 1164579 29861 1134718 10433 40294
11 1134718 29861 1104857 10165 40026
12 1104857 29861 1074996 9898 39759
Total 358332 136427 494759
5th 1 1074996 29861 1045135 9630 39491
2 1045135 29861 1015274 9363 39224
3 1015274 29861 985413 9095 38956
4 985413 29861 955552 8828 38689
5 955552 29861 925691 8560 38421
6 925691 29861 895830 8293 38154
7 895830 29861 865969 8025 37886
8 865969 29861 836108 7758 37619
9 836108 29861 806247 7490 37351
10 806247 29861 776386 7223 37084
11 776386 29861 746525 6955 36816
12 746525 29861 716664 6688 36549
Total 358332 97907 456239
6th 1 716664 29861 686803 6420 36281
2 686803 29861 656942 6153 36014
3 656942 29861 627081 5885 35746
4 627081 29861 597220 5618 35479
5 597220 29861 567359 5350 35211
6 567359 29861 537498 5083 34944
7 537498 29861 507637 4815 34676
8 507637 29861 477776 4548 34409
9 477776 29861 447915 4280 34141
10 447915 29861 418054 4013 33874
11 418054 29861 388193 3745 33606
12 388193 29861 358332 3478 33339
Total 358332 59386 417718
29861
7th 1 358332 29861 328471 3210 33071
2 328471 29861 298610 2943 32804
3 298610 29861 268749 2675 32536
4 268749 29861 238888 2408 32269
5 238888 29861 209027 2140 32001
6 209027 29861 179166 1873 31734
7 179166 29861 149305 1605 31466
8 149305 29861 119444 1338 31199
9 119444 29861 89583 1070 30931
10 89583 29861 59722 803 30664
11 59722 29861 29861 535 30396
12 29861 29861 0 268 30129
Total 358332 20865 379197
Grand Total : 2500000 954042 3454042
29762 8958.3333
8307.7792
1.7142857