PRITIKA AUTOCAST PVT. LTD. (NEW PROJECT) PROJECT) Break even point % of installed capacity
A.
PRODUCTION DURING DURING THE YEAR (Quantity) % utilisation of installed capacity
B.
2
Sal es Inde Indege geno nous us Sale Sales s inclu includi ding ng all all Mi sc. Re R eceipts Export Sales
3
Less exci se
4
Net Sales
1
1st Year Actuals 31.03.10 N.A
2nd 3rd Year Year Provisional Projected 31.03.11 31.03.12 N.A N.A
4th Year Projected 31.03.13 N.A
5th Year Projected 31.03.14 N.A
6th Year Projected 31.03.15 N.A
7th Year Projected 31.03.16 N.A
8th Year Projected 31.03.17 N.A
2867.00
4413.58
6000.00
10000.00
12000.00
12500.00
12500.00
12500.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
2867.00
4413.58
6000.00
10000.00
12000.00
12500.00
12500.00
12500.00
1243.80
2413.58
3346.80
6302.00
7406.40
7568.75
7707.50
7356.25
Cost of Production
C. 1
Raw Material Consumed
2
Power & Fuel
296.62
480.91
653.77
1089.61
1307.54
1362.02
1362.02
1362.02
3
Di rect Labour
196.04
233.00
244.65
256.88
269.73
283.21
297.37
312.24
4
Consumable Stores
224.75
224.03
246.43
271.08
298.18
328.00
360.80
396.88
5
Repairs & mai ntenance
9.98
18.13
21.76
26.11
31.33
37.59
45.11
54.14
6
Other Manufacturing Exp.
226.31
175.05
192.56
211.81
232.99
256.29
281.92
310.11
7
Depreci ation/Development
109.14
141.68
182.26
182.26
182.26
180.55
179.43
161.43
2306.64
3686.38
4888.22
8339.75
9728.43
10016.42
10234.16
9953.07
TOTAL COST OF PRODUCTION 8
Add opening stock in process
231.57
261.38
401.27
495.52
845.40
986.17
1015.36
1261.75
9
Dedu Deduct ct clo closin sing g stoc stock k in pro proce cess ss and and process and finished goods
261.38
401.27
495.52
845.40
986.17
1015.36
1261.75
1227.09
2276.83
3546.49
4793.97
7989.87
9587.66
9987.22
9987.77
9987.73
590.17
867.09
1206.03
2010.13
2412.34
2512.78
2512.23
2512.27
20.58
19.65
20.10
20.10
20.10
20.10
20.10
20.10
484.64
680.46
941.97
1448.53
1701.97
1763.50
1761.83
1743.88
16.90
15.42
15.70
14.49
14.18
14.11
14.09
13.95
D.
Cost of Sales
E.
Gross Profit (B-D) G.P.Rati o
PRITIKA AUTOCAST PVT. LTD. (NEW PROJECT) PROJECT) 1st Year Actuals 31.03.10 F. Interest on 1. Term Loan
2nd 3rd Year Year Provisional Projected 31.03.11 31.03.12
4th Year Projected 31.03.13
5th Year Projected 31.03.14
6th Year Projected 31.03.15
7th Year Projected 31.03.16
8th Year Projected 31.03.17
108.54
138.58
234.72
215.78
174.94
124.22
74.65
27.72
2. W orking Capi tal
60.29
91.49
143.75
237.50
281.25
312.50
312.50
312.50
3. Other Loans, i f any
18.62
45.90
32.22
17.45
3.01
0.00
0.00
0.00
G.
Sel ling, General & admn. Expe.
214.67
328.31
446.32
743.86
892.64
929.83
929.83
929.83
H.
PROFIT BEFORE TAXATION E-(F+
188.05
262.81
349.02
795.53
1060.50
1146.23
1195.25
1242.23
I.
Provision for Taxes/Taxes written bac
35.13
52.00
69.80
159.11
212.10
229.25
239.05
248.45
j.
Net Profit (H-I)
152.92
210.81
279.22
636.43
848.40
916.98
956.20
993.78
K.
Depreci ation added back
109.14
141.68
182.26
182.26
182.26
180.55
179.43
161.43
L.
Net Cash Accruals
262.06
352.49
461.48
818.69
1030.66
1097.53
1135.63
1155.21
M.
Deffered Tax Liabi lity/Assets (+/-) Deffered Tax Liabi lity of previous year
41.31 0.00
20.90 0.00
0.16 0.00
10.51 0.00
18.94 0.00
25.35 0.00
30.89 0.00
29.32 0.00
N.. N..
Repa Repaym ymen entt Oblig Obligat atio ions ns 1. Towards Term Loan 2. Towards other l oans, if any
116.27 2.38
60.06 2.22
127.63 107.64
275.44 119.66
401.35 72.33
390.64 0.00
390.16 0.00
233.61 0.00
TOTAL RE REPAYMENTS
118.65
62.28
235.27
395.10
473.68
390.64
390.16
233.61
152.92 127.16 109.14 389.22 118.65 127.16 245.81 1.58
210.81 184.48 141.68 536.97 62.28 184.48 246.76 2.18
279.22 266.94 182.26 728.41 235.27 266.94 502.21 1.45
636.43 233.23 182.26 1051.92 395.10 233.23 628.33 1.67
848.40 177.95 182.26 1208.62 473.68 177.95 651.63 1.85
916.98 124.22 180.55 1221.75 390.64 124.22 514.86 2.37
956.20 74.65 179.43 1210.28 390.16 74.65 464.81 2.60
993.78 27.72 161.43 1182.93 233.61 27.72 261.33 4.53
Debt Service Coverage ratio Net Profit Add back Interest Add back Depreciation Total Repayment of Term Loan Payment of Interest on term Loan Total DSCR
PRITIKA AUTOCAST PVT. LTD. (NEW PROJECT) FUND FLOW STATEMENT 1st Year Actuals 31.03.10
2nd 3rd Year Year Provisional Projected 31.03.11 31.03.12
4th Year Projected 31.03.13
5th Year Projected 31.03.14
6th Year Projected 31.03.15
7th Year Projected 31.03.16
8th Year Projected 31.03.17
SOURCES OF FUNDS Cash Accruals (viz. Net Profit before Taxation (item H of Annexure III to which shall be added interest (item F of Annexure III)
375.50
538.78
759.71
1266.27
1519.71
1582.95
1582.40
1582.45
Increase in share capital Equity/preference/Share App. Money
100.00
0.00
100.00
0.00
0.00
0.00
0.00
0.00
Depreciation
109.14
141.68
182.26
182.26
182.26
180.55
179.43
161.43
Debentures.
47.69
180.11
560.00
0.00
0.00
0.00
0.00
0.00
Increase in Current Liabili ties.
79.17
245.64
10.94
523.67
262.14
57.10
41.68
-38.36
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Increase in Unsecured Loans and Deposit
157.62
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Increase in Bank Borrowings for Working Capital
178.12
339.57
226.77
750.00
350.00
250.00
0.00
0.00
Misc. Exp. W/Off
0.07
0.07
0.07
0.07
0.07
0.07
0.07
0.04
10. Others (Specify)
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
1047.31
1445.85
1839.75
2722.27
2314.18
2070.67
1803.58
1705.55
A. 1.
2.
3. 4.
5.
6.
7.
8.
9.
Increase in Long Term Loans/
Decrease in Unsecured Loans and deposits
TOTAL SOURCES (A)
PRITIKA AUTOCAST PVT. LTD. (NEW PROJECT) 1st Year Actuals 31.03.10 DESPOSITION OF FUNDS B. 1. Preliminary and Preoperative Expenses 0.00
2nd 3rd Year Year Provisional Projected 31.03.11 31.03.12
4th Year Projected 31.03.13
5th Year Projected 31.03.14
6th Year Projected 31.03.15
7th Year Projected 31.03.16
8th Year Projected 31.03.17
0.00
0.00
0.00
0.00
0.00
0.00
0.00
531.62
197.89
743.42
0.00
0.00
0.00
0.00
0.00
2.88 -18.63 299.30
252.78 264.39 234.09
386.96 73.47 -25.00
774.80 821.92 100.00
874.42 164.38 100.00
278.76 246.58 400.00
305.47 0.00 500.00
199.92 0.00 600.00
Decrease in long term loans/debentures
0.00
0.00
127.63
275.44
401.35
390.64
390.16
233.61
Decrease in Deffered Payment facilities/unsecured loans
0.00
130.32
107.64
119.66
72.33
0.00
0.00
0.00
6.
Increase in Investments
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
7.
Interest
187.45
275.97
410.69
470.73
459.20
436.72
387.15
340.22
8.
Taxation
35.13
52.00
69.80
159.11
212.10
229.25
239.05
248.45
9.
Dividend
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
2.
Increase in Capital Expenditure
3.
Increase in current assets i Inventories ii Debtors iii Others
4.
5.
10. Other Expenses (Specify) TOTAL DISPOSITION (B) C.
Opening Balance
D.
Net Surplus (A+B)
E.
Closing Balance
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
1037.75
1407.44
1894.61
2721.66
2283.78
1981.94
1821.83
1622.20
17.15
26.71
65.12
10.26
10.88
41.27
130.00
111.75
9.56
38.41
-54.85
0.61
30.39
88.73
-18.25
83.35
26.71
65.12
10.26
10.88
41.27
130.00
111.75
195.10
PRITIKA AUTOCAST PVT. LTD. (NEW PROJECT) BALANCE SHEET 1st Year Actuals 31.03.10 A. LIABILITIES
2nd 3rd Year Year Provisional Projected 31.03.11 31.03.12
4th Year Projected 31.03.13
5th Year Projected 31.03.14
6th Year Projected 31.03.15
7th Year Projected 31.03.16
8th Year Projected 31.03.17
1.
Equity Share Capital
534.11
534.11
634.11
634.11
634.11
634.11
634.11
634.11
2.
Reserve and Surplus
92.50
282.41
561.47
1187.38
2016.85
2908.47
3833.79
4798.24
3.
Term Loans 1107.12
1287.23
1719.60
1444.16
1042.81
652.17
262.01
28.40
Bank Borrowings for - Working Capital
583.66
923.23
1150.00
1900.00
2250.00
2500.00
2500.00
2500.00
5.
Unsecured Loans
443.66
313.34
205.70
86.04
13.71
13.71
13.71
13.71
6.
Other Liabilities
601.09
846.73
857.67
1381.35
1643.49
1700.59
1742.28
1703.91
149.50 3511.64
170.40 4357.45
170.56 5299.11
181.06 6814.11
200.01 7800.97
225.36 8634.42
256.25 9242.14
285.57 9963.94
TL from Banks 4.
7
Deffered Tax Liability/Assets (+/-) TOTAL LIABILITIES
B.
ASSETS
1.
Gross Block
2449.94
2647.83
3391.25
3391.25
3391.25
3391.25
3391.25
3391.25
2.
Depreciation
273.78
415.46
597.72
779.98
962.24
1142.79
1322.22
1483.65
3.
Net Block
2176.16
2232.37
2793.53
2611.27
2429.01
2248.46
2069.03
1907.60
4.
Investment
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
5.
Current Assets
1308.31
2059.57
2494.99
4191.71
5330.51
6255.85
7061.32
7861.24
6.
Cash & Bank Balances
26.71
65.12
10.26
10.88
41.27
130.00
111.75
195.10
7.
Misc. Exp. not W/Off
0.46
0.39
0.32
0.25
0.18
0.11
0.04
0.00
TOTAL ASSETS
3511.64 0.00 0.00
4357.45 0.00 0.00
5299.11 0.00 0.00
6814.11 0.00
7800.97 0.00
8634.42 0.00
9242.14 0.00
9963.94 0.00
Borrower's Name: PRITIKA AUTOCAST PVT. LTD. Financial Position ESTIMATED ESTIMATED
2009-10
2010-11
ESTIMATED
2011-12
ESTIMATED
ESTIMATED
ESTIMATED
2012-13
2012-13
2012-13
1
Current Assets
1335.48
2125.08
2505.58
4202.84
5371.96
6385.96
2
Current Liabilities
1184.75
1769.96
2007.67
3281.35
3893.49
4200.59
3
Contribution to working capital (1-2)
150.73
355.12
497.90
921.49
1478.47
2185.36
4
Net fixed assets
2176.16
2232.37
2793.53
2611.27
2429.01
2248.46
5
Term liabilities
1107.12
1287.23
1719.60
1444.16
1042.81
652.17
6
Contribution to fixed capital (4-5)
1069.04
945.14
1073.93
1167.11
1386.20
1596.29
7
Funds invested in business (3+6)
1219.77
1300.26
1571.83
2088.60
2864.67
3781.65
8
Funds invested outside business/in group companies/ non-current assets/investment in shares etc. and intangible Assets Funds borrowed from group companies, directors, friends family members Intangible assets (like goodwill, patents etc.)
0.00
0.00
0.00
0.00
0.00
0.00
443.66
313.34
205.70
86.04
13.71
13.71
0.00
0.00
0.00
0.00
0.00
0.00
776.11
986.92
1366.13
2002.56
2850.96
3767.94
2867.00
4413.58
6000.00
10000.00
12000.00
12500.00
2276.83 590.17 188.05 0.00
3546.49 867.09 262.81 0.00
4793.97 1206.03 349.02 0.00
7989.87 2010.13 795.53 0.00
9587.66 2412.34 1060.50 0.00
9987.22 2512.78 1146.23 0.00
109.14 297.19 0.00 35.13 262.06
141.68 404.49 0.00 52.00 352.49
182.26 531.28 0.00 69.80 461.48
182.26 977.79 0.00 159.11 818.69
182.26 1242.76 0.00 212.10 1030.66
180.55 1326.78 0.00 229.25 1097.53
9
10
11
Tangible Net Worth (7+8-9-10)
12
Net Sales (excl. other incomes) Cost of sales Gross Profit (12-13) Net Profit (Before tax) Provision for Development Rebate/Investment Allowance Reserve. Depreciation for the year Cash profits (15+16+17) Dividends payable/paid Provision for Taxation Funds retained in business (18-19-20)
13 14 15 16
17 18 19 20 21
Borrower's Name: PRITIKA AUTOCAST PVT. LTD. ESTIMATED ESTIMATED
Current ratio Debt-Equity ratio Gross Profit/Net sales Net profit to Tangible Net worth Inventory to Net sales Receivables to Gross sales Debt service coverage ratio (in case of Term loans/DPG only)
2009-10 1.13 1.58 20.58 19.70 46 62 1.58
2010-11 1.20 1.96 19.65 21.36 51 62 2.18
ESTIMATE D
E STIMATED
ESTIMATED
2011-12 1.25 2.05 20.10 20.44 37 46 1.45
2012-13 1.28 1.75 20.10 31.78 27 30 1.67
2012-13 1.38 1.24 20.10 29.76 42 50 1.85
E STIMATED
2012-13 1.52 0.89 20.10 24.34 47 53 2.37
OPERATING STATEMENT Borrower's Name: PRITIKA AUTOCAST PVT. LTD. As per profit and loss account for the year ending
Annexure -E
ESTIMATED ESTIMATED
1 2 3 4 a)
b) c) d) e) f) g)
ESTIMATED
ESTIMATED
ESTIMATED
ESTIMATED
2009-10 2867.00 0.00 2867.00
2010-11 4413.58 0.00 4413.58
2011-12 6000.00 0.00 6000.00
2012-13 10000.00 0.00 10000.00
2012-13 12000.00 0.00 12000.00
2012-13 12500.00 0.00 12500.00
1243.80 224.75 296.62 196.04 9.98 226.31
2413.58 224.03 480.91 233.00 18.13 175.05
3346.80 246.43 653.77 244.65 21.76 192.56
6302.00 271.08 1089.61 256.88 26.11 211.81
7406.40 298.18 1307.54 269.73 31.33 232.99
7568.75 328.00 1362.02 283.21 37.59 256.29
109.14 2306.64
141.68 3686.38
182.26 4888.22
182.26 8339.75
182.26 9728.43
180.55 10016.42
Sub total Deduct: Closing stock-in-process (Cost of production) Sub total Add: Opening stocks of finished good Sub total
2306.64
3686.38
4888.22
8339.75
9728.43
10016.42
2306.64 231.57 2538.21
3686.38 261.38 3947.76
4888.22 401.27 5289.49
8339.75 495.52 8835.27
9728.43 845.40 10573.83
10016.42 986.17 11002.59
Deduct: Closing stock of finished goo (Total cost of sales) Sub total
261.38
401.27
495.52
845.40
986.17
1015.36
2276.83
3546.49
4793.97
7989.87
9587.66
9987.22
590.17 187.45 214.67
867.09 275.97 328.31
1206.03 410.69 446.32
2010.13 470.73 743.86
2412.34 459.20 892.64
2512.78 436.72 929.83
402.12
604.28
857.01
1214.60
1351.84
1366.55
188.05
262.81
349.02
795.53
1060.50
1146.23
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.00
0.00
0.00
0.00
188.05 0.00
262.81 0.00
349.02 0.00
795.53 0.00
1060.50 0.00
1146.23 0.00
35.13 152.92
52.00 210.81
69.80 279.22
159.11 636.43
212.10 848.40
229.25 916.98
Gross sales Less Excise duty Net sales Cost of sales Raw materials (incl. stores) -imported -indigenous Other spares Power & Fuel Direct labour Rapair and maintenance Other Manufacturing expenses/ research & Development Costs. Depreciation Sub total
5 Gross Profit (3-4) 6 Interest 7 Selling, General & admin. expenses Sub total 8 Operating profit 5-(6+7) 9 Other Income/Expenses Add: Income Deduct: expenses Sub total 10 Profit before tax/loss (8+9) Less: Provision for Development Rebate/Investment Allowance Less: Provision for Taxes Net Profit
Borrower's Name: PRITIKA AUTOCAST PVT. LTD. ANALYSIS OF BALANCE SHEET ESTIMATED ESTIMATED
2009-10 Current Liabilities : 1 Short-term borrowings from Banks a) from Canara Bank b) from other Banks Sub-total (A) 2 Short term borrowings from other 3 Deposits (maturing in one year) 4 Sundry Creditors(Trade) 5 Unsecured loans 6 Advances/progress payments/from customers/deposit from dealers 7 Interest and others charges accured, but not due for payment 8 Provision for taxation 9 Dividend payable 10 Other statutory liabilities(due in one year) 11 Instalments of term loans/ deferred payment credits/ debentures/redeemable preference shares (due in one year) 12 Other current liabilities and Provisions (due in one year) Sub-total (B) 13 Total Current Liabilities (A+B)
2010-11
ESTIMATED
2011-12
ESTIMATED
ESTIMATED
ESTIMATED
2012-13
2012-13
2012-13
583.66 0.00
923.23 0.00
1150.00 0.00
1900.00 0.00
2250.00 0.00
2500.00 0.00
583.66
923.23
1150.00
1900.00
2250.00
2500.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
500.23 0.00 3.42
691.12 0.00 9.24
691.12 0.00 9.24
689.11 0.00 0.00
1080.51 0.00 0.00
1266.51 0.00 0.00
39.81
58.07
58.07
85.43
127.58
149.82
0.00 0.00 50.37
0.00 0.00 53.71
0.00 0.00 53.71
0.00 0.00 69.80
0.00 0.00 159.11
0.00 0.00 212.10
0.00
0.00
127.63
275.44
401.35
390.64
7.25
34.58
34.58
13.32
14.15
15.05
601.08 1184.74
846.72 1769.95
974.35 2124.35
1133.10 3033.10
1782.69 4032.69
2034.12 4534.12
Borrower's Name: PRITIKA AUTOCAST PVT Annexure-F ANALYSIS OF BALANCE SHEET
(contd.)
ESTIMATED ESTIMATED
ESTIMATED
ESTIMATED
ESTIMATED
ESTIMATED
2012-13
2012-13
2012-13
2009-10
2010-11
2011-12
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
1107.12
1287.23
1591.97
1168.72
641.46
261.53
443.66
313.34
205.70
86.04
13.71
13.71
17 Deferred payment credits
0.00
0.00
0.00
0.00
0.00
0.00
18 Term Deposits (repayable after one year)
0.00
0.00
0.00
0.00
0.00
0.00
19 Other Term liabilities
0.00
0.00
0.00
0.00
0.00
0.00
20 Total Terms liabilities (total of items 14 to 19)
1550.78
1600.57
1797.67
1254.76
655.17
275.24
21 Total outside liability (13+20)
2735.52
3370.52
3922.02
4287.86
4687.86
4809.36
534.11
534.11
634.11
634.11
634.11
634.11
23 Preference Share Capital (maturing after 12 years)
0.00
0.00
0.00
0.00
0.00
0.00
24 General reserve
0.00
0.00
0.00
0.00
0.00
0.00
25 Development rebate reserve/ investment allowance
0.00
0.00
0.00
0.00
0.00
0.00
149.50
170.40
170.56
181.06
200.01
225.36
92.50
282.41
561.47
1187.38
2016.85
2908.47
776.11
986.92
1366.13
2002.56
2850.96
3767.94
3511.63
4357.44
5288.15
6290.42
7538.82
8577.30
Term Liabilities: 14 Debentures (not maturing in one year) 15 Redeemable preference shares (maturing after one but before 12 year) 16 Term loans (repayables after one year) 16a
Borrowings from gr. Company, Directors, friends, relatives
Net Worth 22 Ordinary Share Capital
26 Other reserves (Deffered Tax Liability) (excl. provisions) 27 Surplus (+) or Deficit (-) in P&L Account 28 Net Worth (total of 22 to 27) 29 Total Liabilities (21+28)
Borrower's Name: PRITIKA AUTOCAST PVT. LTD. ANALYSIS OF BALANCE SHEET
Annexure-F
ESTIMATED ESTIMATED
2009-10 Current Assets: 30 Cash and Bank Balances
2010-11
(contd.) ESTIMATED
2011-12
(contd.)
(contd.)
ESTIMATED
ESTIMATED
ESTIMATED
2012-13
2012-13
2012-13
26.71
65.12
10.26
10.88
41.27
130.00
32 (a) Receivables other than deferred and export receivables (due in one year)
484.06
748.45
748.45
821.92
1643.84
1808.22
b) Export receivables
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
84.74
187.43
187.43
229.23
517.97
608.75
261.38
401.27
401.27
401.77
685.46
799.60
0.00
0.00
0.00
93.75
159.94
186.57
11.93
22.15
22.15
20.25
22.28
24.51
31 Investments: (other than long term investments (eg) sinking fund, gratuity fund etc.) a) b)
33
34
Govt. and other trustee securities FDs in banks
Instalments of deferred receivables(due within one year) Inventory a) Raw materials-Imp. (incl. stores)-Ind. b) Stocks-in-process c) Finished goods d) Other consumables spares
35
Advance to supplier of raw materials and stores/ spares consumables
0.00
0.00
0.00
0.00
0.00
0.00
36
Advance payment of taxes
0.00
0.00
0.00
0.00
0.00
0.00
37
Other current assets
466.20
700.27
755.12
927.46
1131.83
1814.14
38
Total current Assets (Total of items 30 to 37)
1335.02
2124.69
2124.69
2505.26
4202.59
5371.78
Borrower's Name: PRITIKA AUTOCAST PVT ANALYSIS OF BALANCE SHEET
Annexure-F ESTIMATED ESTIMATED
2009-10
2010-11
(contd.) ESTIMATED
2011-12
(contd.)
(contd.)
ESTIMATED
ESTIMATED
ESTIMATED
2012-13
2012-13
2012-13
Fixed Assets: 39
Gross block Land,(building, machinery, construction in progress etc.)
40
Depreciation to date
41
Net block (39-40)
2449.94
2647.83
3391.25
3391.25
3391.25
3391.25
273.78
415.46
597.72
779.98
962.24
1142.79
2176.16
2232.37
2793.53
2611.27
2429.01
2248.46
0.00
0.00
0.00
0.00
0.00
0.00
Other Non-Current Assets. 42
Investments/block debts/ advances/deposits which are not current assets: a) i ) Investments in subsidiary companies/affiliates etc. ii) Others b)
Advances to suppliers of capital goods, spares and contractors for capital expenditure
c)
Deffered receivables maturing beyond one year
d) Others 43
Non consumables stores and spares
44
Other miscellaneous assets incl. dues from Directors
45
Total other non-current assets (42+43+44)
0.00
0.00
0.00
0.00
0.00
0.00
46
Intangible assets (patents,goodwill preliminary and formation Exp. bad/doubtful debts not provided for etc.)
0.00
0.00
0.00
0.00
0.00
0.00
47
Total Assets (38+41+45+46)
3511.18
4357.06
4918.22
5116.53
6631.60
7620.24
48
Tangible net worth (28-46)
776.11
986.92
1366.13
2002.56
2850.96
3767.94
49
Net working capital (38-13)
150.28
354.74
0.34
-527.85
169.90
837.66
Borrower's Name: PRITIKA AUTOCAST PVT. LTD. FUNDS FLOW STATEMENT ESTIMATED ESTIMATED
2009-10
2010-11
ESTIMATED
2011-12
ESTIMATED
ESTIMATED
ESTIMATED
2012-13
2012-13
2012-13
Sources : Profit before tax Add: Depreciation Gross funds generated Less: Taxes pay/payable Less: Dividends paid/payable Add : Preliminary written off A : Sub-total : Net fund generated Increase in : a) Capital b) TL/Deb/Def payment c) Public Deposit d) Other terms liabilities
188.05 109.14 297.19 35.13 0.00 0.07
262.81 141.68 404.49 52.00 0.00 0.07
349.02 182.26 531.28 69.80 0.00 0.07
795.53 182.26 977.79 159.11 0.00 0.07
1060.50 182.26 1242.76 212.10 0.00 0.07
1146.23 180.55 1326.78 229.25 0.00 0.07
262.13
352.56
461.55
818.76
1030.73
1097.60
100.00 47.69
0.00 180.11
100.00 560.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
147.69
180.11
660.00
0.00
0.00
0.00
178.12
339.57
226.77
750.00
350.00
250.00
79.17
245.64
10.94
523.67
262.14
57.10
257.29
585.21
237.71
1273.67
612.14
307.10
667.11
1117.88
1359.26
2092.43
1642.87
1404.70
531.62
197.89
743.42
0.00
0.00
0.00
0.00
0.00
127.63
275.44
401.35
390.64
0.00 0.00
130.32 0.00
107.64 0.00
119.66 0.00
72.33 0.00
0.00 0.00
0.00
0.00
0.00
0.00
0.00
0.00
531.62
328.21
978.69
395.10
473.68
390.64
Decrease in : a) Fixed Assets b) Inter-Corpn. Investment and Advance c) Other non-current assets B: Sub total Increase in short term bank borrowing Increase in other current liabilities Decrease in Inventory Decrease in Receivables Decrease in other current assets C: Sub-total Total funds available (A+B+C) Uses : Increase in Fixed Assets Decrease in : a) T L/Deb./Def/ payment b) Public Deposit c) Capital d) Other terms liabilities Increase in inter-Corpn. Investments and advances increase in other noncurrent assets D. Sub Total
Borrower's Name: PRITIKA AUTOCAST PVT. LTD. FUNDS FLOW STATEMENT ESTIMATED ESTIMATED
ESTIMATED
ESTIMATED
ESTIMATED
ESTIMATED
2009-10 0.00
2010-11 0.00
2011-12 0.00
2012-13 0.00
2012-13 0.00
2012-13 0.00
2.88
252.78
386.96
774.80
874.42
278.76
-18.63
264.39
73.47
821.92
164.38
246.58
308.86
272.50
-79.85
100.61
130.39
488.73
293.11
789.67
380.57
1697.33
1169.19
1014.06
0.00
0.00
0.00
0.00
0.00
0.00
-157.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 0.00
0.00 0.00
F. Sub-Total
-157.62
0.00
0.00
0.00
0.00
0.00
Net funds lost (if f is-ve)
-157.62
0.00
0.00
0.00
0.00
0.00
Total fund used (D+E+G)
667.11
1117.88
1359.26
2092.43
1642.87
1404.70
Summary : Long term sources (A+B+F, if F is+ve)
409.82
532.67
1121.55
818.76
1030.73
1097.60
374.00
328.21
978.69
395.10
473.68
390.64
35.82
204.46
142.86
423.66
557.05
706.96
Short term sources (C) Less: short term uses (E)
257.29 293.11
585.21 789.67
237.71 380.57
1273.67 1697.33
612.14 1169.19
307.10 1014.06
Surplus (+)/Shortfall (-)
-35.82
-204.46
-142.86
-423.66
-557.05
-706.96
Decrease in short term bank borrowing Decrease in other current liabilities Increase in Inventory Increase in Receivables Increase in other current assets E.Sub-Total Loss Loss: Inv. allowance Depreciation Balance : Gross funds lost(-) or Gross funds Generated(+) Add: Taxes paid/payables Add: Dividends paid/payables
G.
Less: Long term uses (D+G) Surplus(+)/Shortfall (-)
0.00
0.00
0.00
0.00
0.00
0.00
PRITIKA AUTOCAST PVT. LTD. (Consolidated) ASSESSMENT OF WORKING CAPITAL REQUIREMENTS 1st 2nd Year Year Actuals Provisional 31.03.10 31.03.11 1.
3rd Year Projected 31.03.12
4th Year Projected 31.03.13
5th Year Projected 31.03.14
6th Year Projected 31.03.15
7th Year Projected 31.03.16
8th Year Projected 31.03.17
CURRENT ASSETS 1.
Raw Materials including Stores i Imported (Months Consumption)
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
84.74
187.43
229.23
517.97
608.75
622.09
633.49
604.62
11.93
22.15
20.25
22.28
24.51
26.96
29.66
32.62
261.38
401.27
401.77
685.46
799.60
823.27
841.16
818.06
0.00
0.00
93.75
159.94
186.57
192.10
420.58
409.03
484.06
748.45
821.92
1643.84
1808.22
2054.79
2054.79
2054.79
Export Receiveables(including Bills Purchase/Discounted by bank) (One Month's Export Sales)
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Advances to Suppliers of Raw Materials and Stores/Spares Consumables
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
492.91 1335.02
765.39 2124.69
938.33 2505.26
1173.10 4202.59
1944.14 5371.78
2666.64 6385.85
3193.38 7173.07
4137.22 8056.35
ii Indegenous (45 days) Consumption) 2.
3.
4.
5.
6.
7.
8.
Other Consumbale Spares (45 days months) Stock -in-Process (Months's Cost of Production) (30 days) Finished Goods (Month's Cost of Sales) Receiveables other than Export and Deffered Receiveables (including Bills Purchased/ discounted by banks) (Month's Domestic Sales excluding deffered payment sales) (60 DAYS) PROJECTED
Other current Assets including Cash and Bank balances and deffered receiveables for with in one year (furnish individual details of major items) TOTAL CURRENT ASSETS (I)
PRITIKA AUTOCAST PVT. LTD. 1st Year Actuals 31.03.10 II.
2nd Year Provisional 31.03.11
3rd Year Projected 31.03.12
4th Year Projected 31.03.13
5th Year Projected 31.03.14
6th Year Projected 31.03.15
7th Year Projected 31.03.16
8th Year Projected 31.03.17
CURRENT LIABILITIES 1.
Creditors for purchase of raw materials and stores/ spares/consumables (45 days)
500.23
691.12
689.11
1080.51
1266.51
1298.10
1326.30
1274.49
3.42
9.24
0.00
0.00
0.00
0.00
0.00
0.00
2.
Advance from customers
3.
Accrued Expenses
39.81
58.07
85.43
127.58
149.82
157.20
159.79
162.65
4.
Statutory Liabilities
50.37
53.71
69.80
159.11
212.10
229.25
239.05
248.45
5.
Other Current Liabilities
7.25
34.58
13.32
14.15
15.05
16.04
17.12
18.32
TOTAL CURRENT LIABILITES (II)
601.08
846.72
857.66
1381.34
1643.48
1700.58
1742.27
1703.90
Working Capital Gap (I-II)
733.94
1277.97
1647.59
2821.25
3728.30
4685.26
5430.80
6352.45
IV. Margin for Working Capital
333.75
531.17
626.31
1050.65
1342.95
1596.46
1793.27
2014.09
V.
Bank Borrowing
600.00
923.23
1150.00
1900.00
2250.00
2500.00
2500.00
2500.00
1.
CURRENT ASSETS
1335.02
2124.69
2505.26
4202.59
5371.78
6385.85
7173.07
8056.35
2.
CURRENT LIABILITIES
601.08
846.72
857.66
1381.34
1643.48
1700.58
1742.27
1703.90
3.
WORKING CAPITAL GAP
733.94
1277.97
1647.59
2821.25
3728.30
4685.26
5430.80
6352.45
4.
MARGIN 25% OF CA
333.75
531.17
626.31
1050.65
1342.95
1596.46
1793.27
2014.09
5.
NET WORKING CAPITAL
133.94 400.18
354.74 746.79
497.59 1021.28
921.25 1770.60
1478.30 2385.36
2185.26 3088.80
2930.80 3637.54
3852.45 4338.36
III.
MPBF
PRITIKA AUTOCAST PVT. LTD. (Consolidated) INCOME TAX CALCULATIONS PARTICULARS BOOK PROFIT
2011-12 349.02
2012-13 795.53
2013-14 1060.50
2014-15 1146.23
2015-16 1195.25
2016-17 1242.23
MAT
69.80
159.11
212.10
229.25
239.05
248.45
Total Income Tax
69.80
159.11
212.10
229.25
239.05
248.45
PROVISION FOR DEFFERED TAX LIABILITY PARTICULARS DEPRECIATION AS PER I.T.ACT
2010-11
2011-12
2012-13
2013-14
2014-15
2015-16
2016-17
141.68
182.26
182.26
182.26
180.55
179.43
161.43
DEPRECIATION AS PER SLM
86.59
181.84
153.66
130.72
111.57
95.39
81.64
DIFFERENCE
55.09
0.42
28.60
51.54
68.99
84.04
79.79
DEFFERED TAX LIABILITY/ASSETS +/-
20.24
0.16
10.51
18.94
25.35
30.89
29.32
PRITIKA AUTOCAST PVT. LTD. Unit-1+Unit-2 Schedule of Fixed Assets & Depreciation on SLM sets & DESCRIPTION RATE G BLOCK NO. OF AS ON DEP.% 01/04/10 1 LAND 0.00 44.77 2 BUILDING 3.34 370.37 3 PLANT & MACHINERY 4.75 1458.23 4 PATTERN, JIGS & FIXTURES . 11.31 277.87 5 AIR CONDITIONERS 4.75 0.67 6 FURNITURE & FIXTURES 6.33 4.28 7 OFFICE EQUIPMENTS 4.75 1.72 8 COMPUTERS 16.21 7.11 9 DG SET 4.75 26.03 10 VEHICALS-TRUCK 9.50 7.70 11 CARS 9.50 32.34 12 TUBE WELL 4.75 4.06 13 ELECTRICAL INSTALLATINS 7.07 211.02 14 ELECTRICAL FITTINGS 7.07 0.00 15 WEIGH BRIDGE 4.75 2.78 16 MISC. TOOLS 4.75 0.98 17 CAPITAL WORK IN PROGRES 0.00 0.00 TOTAL:2449.93
IN LAKHS OF Rs. ADDIN DURING 2010-11 0.00 34.20 102.85 37.89 0.43 0.82 0.00 6.03 0.00 0.00 0.91 0.42 3.49 0.00 0.00 0.00 0.00 187.04
G BLOCK AS ON 31/03/11 44.77 404.57 1561.08 315.76 1.10 5.10 1.72 13.14 26.03 7.70 33.25 4.48 214.51 0.00 2.78 0.98 0.00 2636.97
DEP FOR 2010-11 0.00 12.41 72.70 33.93 0.05 0.28 0.08 1.91 1.24 0.73 3.13 0.07 14.97 0.00 0.13 0.05 0.00 141.68
CUM.DEP UP TO 31/03/11 0.00 39.71 224.14 83.43 0.14 1.07 0.28 5.02 5.30 2.69 7.31 0.27 45.13 0.00 0.64 0.17 0.00 415.30
N BLOCK AS ON 31/03/11 44.77 364.86 1336.94 232.33 0.96 4.03 1.44 8.12 20.73 5.01 25.94 4.21 169.38 0.00 2.14 0.81 0.00 2221.67
ADDIN DURING 2011-12 0.00 83.27 613.64 0.00 0.00 0.00 0.00 4.33 0.00 0.00 0.00 0.00 42.18 0.00 0.00 0.00 0.00 743.42
G BLOCK AS ON 31-03-12 44.77 487.84 2174.72 315.76 1.10 5.10 1.72 17.47 26.03 7.70 33.25 4.48 256.69 0.00 2.78 0.98 0.00 3380.39
DEP FOR 2011-12 0.00 16.29 103.30 35.71 0.05 0.32 0.08 2.83 1.24 0.73 3.16 0.21 18.15 0.00 0.13 0.05 0.00 182.26
CUM.DEP UP TO 31-03-12 0.00 56.00 327.44 119.14 0.19 1.39 0.36 7.85 6.54 3.42 10.47 0.48 63.28 0.00 0.77 0.22 0.00 597.56
N BLOCK AS ON 31-03-12 44.77 431.84 1847.28 196.62 0.91 3.71 1.36 9.62 19.49 4.28 22.78 4.00 193.41 0.00 2.01 0.76 0.00 2782.83
ADDIN DURING 2012-13 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.00 0.00 0.00 0.00
G BLOCK AS ON 31/03/13 44.77 487.84 2174.72 315.76 1.10 5.10 1.72 17.47 26.03 7.70 33.25 4.48 256.69 0.00 2.78 0.98 0.00 3380.39
DEP FOR 2012-13 0.00 16.29 103.30 35.71 0.05 0.32 0.08 2.83 1.24 0.73 3.16 0.21 18.15 0.00 0.13 0.05 0.00 182.26
CUM.DEP UP TO 31/03/13 0.00 72.30 430.74 154.85 0.24 1.72 0.44 10.68 7.77 4.15 13.63 0.70 81.43 0.00 0.90 0.26 0.00 779.82
N BLOCK AS ON 31/03/13 44.77 415.54 1743.98 160.91 0.86 3.38 1.28 6.79 18.26 3.55 19.62 3.78 175.26 0.00 1.88 0.72 0.00 2600.57
ADDIN DURING 2013-14 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.00 0.00 0.00 0.00
G BLOCK AS ON 31-03-14 44.77 487.84 2174.72 315.76 1.10 5.10 1.72 17.47 26.03 7.70 33.25 4.48 256.69 0.00 2.78 0.98 0.00 3380.39
DEP FOR 2013-14 0.00 16.29 103.30 35.71 0.05 0.32 0.08 2.83 1.24 0.73 3.16 0.21 18.15 0.00 0.13 0.05 0.00 182.26
CUM.DEP UP TO 31-03-14 0.00 88.59 534.04 190.57 0.30 2.04 0.53 13.52 9.01 4.88 16.79 0.91 99.57 0.00 1.04 0.31 0.00 962.08
N BLOCK AS ON 31-03-14 44.77 399.25 1640.68 125.19 0.80 3.06 1.19 3.95 17.02 2.82 16.46 3.57 157.12 0.00 1.74 0.67 0.00 2418.31
RATE G BLOCK ADDIN OF AS ON DURING DEP.% 1/4/13 2013-14 1 LAND 0.00 44.77 0.00 2 BUILDING 3.34 487.84 0.00 3 PLANT & MACHINERY 4.75 2174.72 0.00 4 P ATTERN, JIGS & FIXTURES . 11.31 315.76 0.00 5 AIR CONDITIONERS 4.75 1.10 0.00 6 FURNITURE & FIXTURES 6.33 5.10 0.00 7 OFFICE EQUIPMENTS 4.75 1.72 0.00 8 COMPUTERS 16.21 17.47 0.00 9 DG SET 4.75 26.03 0.00 10 VEHICALS-TRUCK 9.50 7.70 0.00 11 CARS 9.50 33.25 0.00 12 TUBE WELL 4.75 4.48 0.00 13 ELECTRICAL INSTALLATINS 7.07 256.69 0.00 14 ELECTRICAL FITTINGS 7.07 0.00 0.00 15 WEIGH BRIDGE 4.75 2.78 0.00 16 MISC. TOOLS 4.75 0.98 0.00 17 CAPITAL WORK IN PROGRES 0.00 0.00 0.00 TOTAL:3380.39 0.00
G BLOCK AS ON 31/03/14 44.77 487.84 2174.72 315.76 1.10 5.10 1.72 17.47 26.03 7.70 33.25 4.48 256.69 0.00 2.78 0.98 0.00 3380.39
DEP CUM.DEP FOR UP TO 2013-14 31/03/14 0.00 0.00 16.29 104.89 103.30 637.34 35.71 226.28 0.05 0.35 0.32 2.36 0.08 0.61 2.83 16.35 1.24 10.25 0.73 5.62 3.16 19.95 0.21 1.12 18.15 117.72 0.00 0.00 0.13 1.17 0.05 0.36 0.00 0.00 182.26 1144.34
N BLOCK AS ON 31/03/14 44.77 382.95 1537.38 89.48 0.75 2.74 1.11 1.12 15.78 2.08 13.31 3.36 138.97 0.00 1.61 0.62 0.00 2236.05
ADDIN DURING 2014-15 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.00 0.00 0.00 0.00
G BLOCK DEP AS ON FOR 31/03/15 2014-15 44.77 0.00 487.84 16.29 2174.72 103.30 315.76 35.71 1.10 0.05 5.10 0.32 1.72 0.08 17.47 1.12 26.03 1.24 7.70 0.73 33.25 3.16 4.48 0.21 256.69 18.15 0.00 0.00 2.78 0.13 0.98 0.05 0.00 0.00 3380.39 180.55
CUM.DEP UP TO 31/03/15 0.00 121.18 740.64 261.99 0.40 2.68 0.69 17.47 11.48 6.35 23.10 1.33 135.87 0.00 1.30 0.40 0.00 1324.89
N BLOCK AS ON 31/03/15 44.77 366.66 1434.08 53.77 0.70 2.42 1.03 0.00 14.55 1.35 10.15 3.15 120.82 0.00 1.48 0.58 0.00 2055.50
RATE G BLOCK ADDIN G BLOCK OF AS ON DURING AS ON DEP.% 1/4/15 2015-16 31/03/16 1 LAND 0 44.77 0.00 44.77 2 BUILDING 3.34 487.84 0.00 487.84 3 PLANT & MACHINERY 4.75 2174.72 0.00 2174.72 4 P ATTERN, JIGS & FIXTURES . 11.31 315.76 0.00 315.76 5 AIR CONDITIONERS 4.75 1.10 0.00 1.10 6 FURNITURE & FIXTURES 6.33 5.10 0.00 5.10 7 OFFICE EQUIPMENTS 4.75 1.72 0.00 1.72 8 COMPUTERS 16.21 17.47 0.00 17.47 9 DG SET 4.75 26.03 0.00 26.03 10 VEHICALS-TRUCK 9.5 7.70 0.00 7.70 11 CARS 9.5 33.25 0.00 33.25 12 TUBE WELL 4.75 4.48 0.00 4.48 13 E LECTRICAL INSTALLATINS 7.07 256.69 0.00 256.69 14 ELECTRICAL FITTINGS 7.07 0.00 0.00 0.00 15 WEIGH BRIDGE 4.75 2.78 0.00 2.78 16 MISC. TOOLS 4.75 0.98 0.00 0.98 17 CAPITAL WORK IN PROGRES 0 0.00 0.00 0.00 3380.39 0.00 3380.39
DEP CUM.DEP FOR UP TO 2015-16 31/03/16 0.00 0.00 16.29 137.47 103.30 843.94 35.71 297.70 0.05 0.45 0.32 3.01 0.08 0.77 0.00 17.47 1.24 12.72 0.73 7.08 3.16 26.26 0.21 1.55 18.15 154.02 0.00 0.00 0.13 1.43 0.05 0.45 0.00 0.00 179.43 1504.32
N BLOCK AS ON 31/03/16 44.77 350.37 1330.78 18.06 0.65 2.09 0.95 0.00 13.31 0.62 6.99 2.93 102.67 0.00 1.35 0.53 0.00 1876.07
ADDIN DURING 2016-17 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.00 0.00 0.00 0.00
G BLOCK DEP AS ON FOR 31/03/17 2016-17 44.77 0.00 487.84 16.29 2174.72 103.30 315.76 17.82 1.10 0.05 5.10 0.32 1.72 0.08 17.47 0.00 26.03 1.24 7.70 0.62 33.25 3.16 4.48 0.21 256.69 18.15 0.00 0.00 2.78 0.13 0.98 0.05 0.00 0.00 3380.39 161.43
CUM.DEP UP TO 31/03/17 0.00 153.77 947.23 315.53 0.51 3.33 0.85 17.47 13.95 7.70 29.42 1.76 172.17 0.00 1.56 0.50 0.00 1665.75
N BLOCK AS ON 31/03/17 44.77 334.07 1227.49 0.23 0.59 1.77 0.87 0.00 12.08 0.00 3.83 2.72 84.52 0.00 1.22 0.48 0.00 1714.64
2013-14 182.26
2015-16 179.43
2016-17 161.43
S. NO. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
DESCRIPTION
RATE G BLOCK OF AS ON DEP.% 1/4/12 LAND 0.00 44.77 BUILDING 3.34 487.84 PLANT & MACHINERY 4.75 2174.72 PATTERN, JIGS & FIXTURES . 11.31 315.76 AIR CONDITIONERS 4.75 1.10 FURNITURE & FIXTURES 6.33 5.10 OFFICE EQUIPMENTS 4.75 1.72 COMPUTERS 16.21 17.47 DG SET 4.75 26.03 VEHICALS-TRUCK 9.50 7.70 CARS 9.50 33.25 TUBE WELL 4.75 4.48 ELECTRICAL INSTALLATINS 7.07 256.69 ELECTRICAL FITTINGS 7.07 0.00 WEIGH BRIDGE 4.75 2.78 MISC. TOOLS 4.75 0.98 CAPITAL WORK IN PROGRES 0.00 0.00 TOTAL:3380.39
S. NO.
DESCRIPTION
S. NO.
DESCRIPTION
2010-11 141.68
2011-12 182.26
2012-13 182.26
2014-15 180.55
Schedule of Fixed assets & Depreciation as per I.T.Act. S. DESCRIPTION RATE W.D.V NO. OF AS ON DEP.% 1/4/10 1. LAND 0.00 0.00 2. BUILDING 10.00 77.09 3. PLANT & MACHINERY 15.00 247.66 4 PATTERN, JIGS & FIXTURES . 15.00 24.30 5 AIR CONDITIONERS 10.00 0.00 6 FURNITURE & FIXTURES 10.00 0.00 7 OFFICE EQUIPMENTS 10.00 0.00 8 COMPUTERS 60.00 0.00 9 DG SET 15.00 0.00 10 VEHICALS-TRUCK 15.00 0.00 11 CARS 15.00 0.00 12 TUBE WELL 0.00 0.00 13 ELECTRICAL INSTALLATINS 15.00 60.62 14 WEIGH BRIDGE 15.00 0.00 15 MISC TOOLS 15.00 0.00 TOTAL:409.67
S. NO. 1. 2. 3. 4 5 6 7 8 9 10 11 12 13 14 15
S. NO. 1. 2. 3. 4 5 6 7 8 9 10 11 12 13 14 15
S. NO. 1. 2. 3. 4 5 6 7 8 9 10 11 12 13 14 15
RATE OF DEP.% LAND 0.00 BUILDING 10.00 PLANT & MACHINERY 15.00 PATTERN, JIGS & FIXTURES . 15.00 AIR CONDITIONERS 10.00 FURNITURE & FIXTURES 10.00 OFFICE EQUIPMENTS 10.00 COMPUTERS 60.00 DG SET 15.00 VEHICALS-TRUCK 15.00 CARS 15.00 TUBE WELL 0.00 ELECTRICAL INSTALLATINS 15.00 WEIGH BRIDGE 15.00 MISC TOOLS 15.00 TOTAL:-
ADDIN DURING 2010-11 0.00 34.20 102.85 37.89 0.43 0.82 0.00 6.03 0.00 0.91 0.42 0.00 3.49 0.00 0.00 187.04
TOTAL AS ON 31-03-11 0.00 111.29 350.51 62.19 0.43 0.82 0.00 6.03 0.00 0.91 0.42 0.00 64.11 0.00 0.00 596.71
DEP FOR 2010-11 0.00 11.13 52.58 9.33 0.04 0.08 0.00 3.62 0.00 0.14 0.06 0.00 9.62 0.00 0.00 86.59
W.D.V AS ON 31-03-11 0.00 100.16 297.93 52.86 0.39 0.74 0.00 2.41 0.00 0.77 0.36 0.00 54.49 0.00 0.00 510.12
ADDIN DURING 2011-12 0.00 83.27 613.64 0.00 0.00 0.00 0.00 4.33 0.00 0.00 0.00 0.00 42.18 0.00 0.00 743.42
TOTAL AS ON 31/03/12 0.00 183.43 911.57 52.86 0.39 0.74 0.00 6.74 0.00 0.77 0.36 0.00 96.67 0.00 0.00 1253.54
DEP FOR 2011-12 0.00 18.34 136.74 7.93 0.04 0.07 0.00 4.05 0.00 0.12 0.05 0.00 14.50 0.00 0.00 181.84
W.D.V AS ON 31/03/12 0.00 165.09 774.84 44.93 0.35 0.66 0.00 2.70 0.00 0.66 0.30 0.00 82.17 0.00 0.00 1071.70
DESCRIPTION
W.D.V AS ON 01/04/12 0.00 165.09 774.84 44.93 0.35 0.66 0.00 2.70 0.00 0.66 0.30 0.00 82.17 0.00 0.00 1071.70
ADDIN DURING 2012-13 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.00 0.00
TOTAL AS ON 31-03-13 0.00 165.09 774.84 44.93 0.35 0.66 0.00 2.70 0.00 0.66 0.30 0.00 82.17 0.00 0.00 1071.70
DEP FOR 2012-13 0.00 16.51 116.23 6.74 0.03 0.07 0.00 1.62 0.00 0.10 0.05 0.00 12.33 0.00 0.00 153.66
W.D.V AS ON 31-03-13 0.00 148.58 658.61 38.19 0.31 0.60 0.00 1.08 0.00 0.56 0.26 0.00 69.85 0.00 0.00 918.04
ADDIN DURING 2013-14 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.00 0.00
TOTAL AS ON 31-03-14 0.00 148.58 658.61 38.19 0.31 0.60 0.00 1.08 0.00 0.56 0.26 0.00 69.85 0.00 0.00 918.04
DEP FOR 2013-14 0.00 14.86 98.79 5.73 0.03 0.06 0.00 0.65 0.00 0.08 0.04 0.00 10.48 0.00 0.00 130.72
W.D.V AS ON 31-03-14 0.00 133.72 559.82 32.46 0.28 0.54 0.00 0.43 0.00 0.48 0.22 0.00 59.37 0.00 0.00 787.32
DESCRIPTION
W.D.V AS ON 01/04/14 0.00 133.72 559.82 32.46 0.28 0.54 0.00 0.43 0.00 0.48 0.22 0.00 59.37 0.00 0.00 787.32
ADDIN DURING 2014-15 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.00 0.00
TOTAL AS ON 31-03-15 0.00 133.72 559.82 32.46 0.28 0.54 0.00 0.43 0.00 0.48 0.22 0.00 59.37 0.00 0.00 787.32
DEP FOR 2014-15 0.00 13.37 83.97 4.87 0.03 0.05 0.00 0.26 0.00 0.07 0.03 0.00 8.91 0.00 0.00 111.57
W.D.V AS ON 31-03-15 0.00 120.35 475.85 27.59 0.25 0.48 0.00 0.17 0.00 0.40 0.19 0.00 50.46 0.00 0.00 675.76
ADDIN DURING 2015-16 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.00 0.00
TOTAL AS ON 31-03-16 0.00 120.35 475.85 27.59 0.25 0.48 0.00 0.17 0.00 0.40 0.19 0.00 50.46 0.00 0.00 675.76
DEP FOR 2015-16 0.00 12.03 71.38 4.14 0.03 0.05 0.00 0.10 0.00 0.06 0.03 0.00 7.57 0.00 0.00 95.39
W.D.V AS ON 31-03-16 0.00 108.31 404.47 23.45 0.23 0.44 0.00 0.07 0.00 0.34 0.16 0.00 42.89 0.00 0.00 580.37
DESCRIPTION
W.D.V AS ON 01/04/16 0.00 108.31 404.47 23.45 0.23 0.44 0.00 0.07 0.00 0.34 0.16 0.00 42.89 0.00 0.00 580.37
ADDIN DURING 2016-17 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.00 0.00
TOTAL AS ON 31-03-17 0.00 108.31 404.47 23.45 0.23 0.44 0.00 0.07 0.00 0.34 0.16 0.00 42.89 0.00 0.00 580.37
DEP FOR 2016-17 0.00 10.83 60.67 3.52 0.02 0.04 0.00 0.04 0.00 0.05 0.02 0.00 6.43 0.00 0.00 81.64
W.D.V AS ON 31-03-17 0.00 97.48 343.80 19.94 0.21 0.39 0.00 0.03 0.00 0.29 0.13 0.00 36.46 0.00 0.00 498.73
ADDIN DURING 2017-18 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.00 0.00
TOTAL AS ON 31-03-18 0.00 97.48 343.80 19.94 0.21 0.39 0.00 0.03 0.00 0.29 0.13 0.00 36.46 0.00 0.00 498.73
DEP FOR 2017-18 0.00 9.75 51.57 2.99 0.02 0.04 0.00 0.02 0.00 0.04 0.02 0.00 5.47 0.00 0.00 69.92
W.D.V AS ON 31-03-18 0.00 87.73 292.23 16.95 0.19 0.35 0.00 0.01 0.00 0.25 0.11 0.00 30.99 0.00 0.00 428.81
RATE OF DEP.% LAND 0.00 BUILDING 10.00 PLANT & MACHINERY 15.00 PATTERN, JIGS & FIXTURES . 15.00 AIR CONDITIONERS 10.00 FURNITURE & FIXTURES 10.00 OFFICE EQUIPMENTS 10.00 COMPUTERS 60.00 DG SET 15.00 VEHICALS-TRUCK 15.00 CARS 15.00 TUBE WELL 0.00 ELECTRICAL INSTALLATINS 15.00 WEIGH BRIDGE 15.00 MISC TOOLS 15.00 TOTAL:-
RATE OF DEP.% LAND 0.00 BUILDING 10.00 PLANT & MACHINERY 15.00 PATTERN, JIGS & FIXTURES . 15.00 AIR CONDITIONERS 10.00 FURNITURE & FIXTURES 10.00 OFFICE EQUIPMENTS 10.00 COMPUTERS 60.00 DG SET 15.00 VEHICALS-TRUCK 15.00 CARS 15.00 TUBE WELL 0.00 ELECTRICAL INSTALLATINS 15.00 WEIGH BRIDGE 15.00 MISC TOOLS 15.00 TOTAL:-
2010-11 86.59
2011-12 181.84
2012-13 153.66
2013-14 130.72
2014-15 111.57
2015-16 95.39
2016-17 81.64
2009-10 86.59
2010-11 181.84
2011-12 153.66
2012-13 130.72
2013-14 111.57
2014-15 2015-16 95.39
2016-17
PRITIKA AUTOCAST PVT. LTD. Interest and Repayment of SIDBI Loan-II MORATORIUM REPAYMENT SCHEDULE EQUATED INSTALMENT YEAR OPENING
NIL 7 YEARS
RATE OF 10.5 % AGE INTEREST 82 (Figures in LACs Rs.) 850 LACS For Unit-2 PAYMENTS BALANCE INEREST TOTAL INTT. Loan FOR THE BALANCE DUE YEAR 754.61 30.00 724.61 39.62 724.61 30.00 694.61 38.04 77.66
2011-12
1ST HALF 11ND HAL
2012-13
1ST HALF 11ND HAL
694.61 646.61
48.00 48.00
646.61 598.61
36.47 33.95
70.41
1ST HALF 11ND HAL
598.61 506.51
92.10 92.10
506.51 414.41
31.43 26.59
58.02
1ST HALF 11ND HAL
414.41 322.31
92.10 92.10
322.31 230.21
21.76 16.92
38.68
1ST HALF 11ND HAL
230.21 138.11
92.10 92.10
138.11 46.01
12.09 7.25
19.34
1ST HALF 11ND HAL
46.01 0.00
46.01 0.00
0.00 0.00
2.42 0.00
2.42
2013-14
2014-15
2015-16
2015-16
Total Repayment Interest
2011-12 60.00 77.66
2012-13 96.00 70.41
Interest and Repayment of SIDBI Loan -II MORATORIUM REPAYMENT SCHEDULE EQUATED INSTALMENT YEAR OPENING
2013-14 184.20 58.02
NIL 7 YEARS
2014-15 184.20 38.68
2015-16 184.20 19.34
2016-17 46.01 2.42
RATE OF 13.5 % AGE INTEREST 82 (Figures in LACs Rs.) 50 LACS PAYMENTS BALANCE INTEREST TOTAL INTT. FOR THE DUE YEAR 5.58 24.89 2.06 5.58 19.31 1.68 3.74
2011-12
1ST HALF 11ND HAL
BALANCE 30.47 24.89
2012-13
1ST HALF 11ND HAL
19.31 13.73
5.58 5.58
13.73 8.15
1.30 0.93
2.23
1ST HALF 11ND HAL
8.15 2.57
5.58 2.57
2.57 0.00
0.55 0.17
0.72
1ST HALF 11ND HAL
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00
2013-14
2014-15
Total Repayment Interest
2011-12 11.16 3.74
2012-13 11.16 2.23
2013-14 8.15 0.72
2014-15 0.00 0.00
2015-16
2016-17
Interest and Repayment of SIDBI New Term Loan MORATORIUM NIL REPAYMENT SCHEDULE EQUATED INSTALMENT YEAR OPENING
RATE OF 11.75 % AGE INTEREST 66 (Figures in LACs Rs.) 150 LACS PAYMENTS BALANCE INTEREST TOTAL INTT. FOR THE DUE YEAR 1.65 148.35 8.81 9.90 138.45 8.72 17.53
2011-12
1ST HALF 11ND HAL
BALANCE 150.00 148.35
2012-13
1ST HALF 11ND HAL
138.45 127.95
10.50 13.50
127.95 114.45
8.13 7.52
15.65
1ST HALF 11ND HAL
114.45 100.95
13.50 13.75
100.95 87.20
6.72 5.93
12.65
1ST HALF 11ND HAL
87.20 72.20
15.00 15.00
72.20 57.20
5.12 4.24
9.36
1ST HALF 11ND HAL
57.20 42.20
15.00 15.00
42.20 27.20
3.36 2.48
5.84
1ST HALF 11ND HAL
27.20 12.20
15.00 12.20
12.20 0.00
1.60 0.72
2.31
2013-14
2014-15
2015-16
2016-17
Total Repayment Interest
2011-12 11.55 17.53
2012-13 24.00 15.65
2013-14 27.25 12.65
2014-15 30.00 9.36
2015-16 30.00 5.84
2016-17 27.20 2.31
Interest and Repayment of SIDBI Convertible Term Loan MORATORIUM NIL RATE OF 14 % AGE REPAYMENT SCHEDULE INTEREST EQUATED INSTALMENT 66 (Figures in LACs Rs.) 125 LACS YEAR OPENING PAYMENTS BALANCE INTEREST TOTAL INTT. FOR THE BALANCE DUE YEAR 2011-12 1ST HALF 125.00 0.00 125.00 8.75 11ND HAL 125.00 0.00 125.00 8.75 17.50 2012-13
2013-14
2014-15
2015-16
2016-17
Total Repayment Interest
1ST HALF 11ND HAL
125.00 125.00
0.00 0.00
125.00 125.00
8.75 8.75
17.50
1ST HALF 11ND HAL
125.00 109.40
15.60 15.60
109.40 93.80
8.75 7.66
16.41
1ST HALF 11ND HAL
93.80 78.20
15.60 15.60
78.20 62.60
6.57 5.47
12.04
1ST HALF 11ND HAL
62.60 47.00
15.60 15.60
47.00 31.40
4.38 3.29
7.67
1ST HALF 11ND HAL
31.40 15.80
15.60 15.80
15.80 0.00
2.20 1.11
3.30
2011-12 0.00 17.50
2012-13 0.00 17.50
Interest and Repayment of SIDBI DG Set Loan
2013-14 31.20 16.41
2014-15 31.20 12.04
2015-16 31.20 7.67
2016-17 31.40 3.30
MORATORIUM REPAYMENT SCHEDULE EQUATED INSTALMENT YEAR OPENING
NIL
RATE OF 11 % AGE INTEREST 66 (Figures in LACs Rs.) 25 LACS PAYMENTS BALANCE INTEREST TOTAL INTT. FOR THE DUE YEAR 0.00 25.00 1.38 0.52 24.48 1.38 2.75
2011-12
1ST HALF 11ND HAL
BALANCE 25.00 25.00
2012-13
1ST HALF 11ND HAL
24.48 21.36
3.12 3.12
21.36 18.24
1.35 1.17
2.52
1ST HALF 11ND HAL
18.24 15.12
3.12 3.12
15.12 12.00
1.00 0.83
1.83
1ST HALF 11ND HAL
12.00 8.88
3.12 3.12
8.88 5.76
0.66 0.49
1.15
1ST HALF 11ND HAL
5.76 2.64
3.12 2.64
2.64 0.00
0.32 0.15
0.46
1ST HALF 11ND HAL
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00
2013-14
2014-15
2015-16
2016-17
Total Repayment Interest
2011-12 0.52 2.75
2012-13 6.24 2.52
2013-14 6.24 1.83
Interest and Repayment of Canara Bank Term Loan MORATORIUM ONE YEAR REPAYMENT SCHEDULE 6years EQUATED INSTALMENT YEAR OPENING Additions for unit -2 BALANCE 2011-12 1ST HALF 47.18 11ND HAL 37.16 2012-13
2013-14
2014-15
2014-15 6.24 1.15
2015-16 5.76 0.46
2016-17 0.00 0.00
RATE OF 12.25 % AGE INTEREST (Figures in LACs Rs.) 100 LAC PAYMENTS BALANCE INTEREST TOTAL INTT. FOR THE DUE YEAR 10.02 37.16 2.89 10.02 27.14 2.28 5.17
1ST HALF 11ND HAL
27.14 17.12
10.02 10.02
17.12 7.10
1.66 1.05
2.71
1ST HALF 11ND HAL
7.10 0.00
7.10
0.00 0.00
0.43 0.00
0.43
1ST HALF 11ND HAL
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00
Total Repayment Interest
2011-12 20.04 5.17
2012-13 20.04 2.71
2013-14 7.10 0.43
Interest and Repayment of Canara Bank Term Loan MORATORIUM ONE YEAR REPAYMENT SCHEDULE 6years EQUATED INSTALMENT YEAR OPENING Additions for unit -2 BALANCE 2011-12
2012-13
2013-14
2014-15
Total Repayment Interest
2014-15 0.00 0.00
2015-16
RATE OF 12.25 % AGE INTEREST (Figures in LACs Rs.) 66 LACS PAYMENTS BALANCE INTEREST TOTAL INTT. FOR THE DUE YEAR
1ST HALF 11ND HAL
24.69 18.09
6.60 6.60
18.09 11.49
1.51 1.11
2.62
1ST HALF 11ND HAL
11.49 4.89
6.60 4.89
4.89 0.00
0.70 0.30
1.00
1ST HALF 11ND HAL
0.00 0.00
0.00
0.00 0.00
0.00 0.00
0.00
1ST HALF 11ND HAL
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00
2011-12 13.20 2.62
2012-13 11.49 1.00
2013-14 0.00 0.00
2014-15 0.00 0.00
2015-16
Interest and Repayment of Canara Bank New Term Loan MORATORIUM ONE YEAR RATE OF 11.75 % AGE REPAYMENT SCHEDULE 7 YEARS INTEREST EQUATED INSTALMENT 80 Mthly INST. (Figures in LACs Rs.) YEAR OPENING Additions PAYMENTS BALANCE INTEREST TOTAL INTT. for unit -2 FOR THE BALANCE DUE YEAR 2011-12 1ST HALF 125.00 0.00 125.00 7.34 11ND HAL 125.00 9.00 116.00 7.34 14.69 2012-13
2013-14
2014-15
2015-16
2016-17
Total Repayment Interest
1ST HALF 11ND HAL
116.00 107.00
9.00 12.00
107.00 95.00
6.82 6.29
13.10
1ST HALF 11ND HAL
95.00 83.00
12.00 12.00
83.00 71.00
5.58 4.88
10.46
1ST HALF 11ND HAL
71.00 57.50
13.50 13.50
57.50 44.00
4.17 3.38
7.55
1ST HALF 11ND HAL
44.00 30.50
13.50 13.50
30.50 17.00
2.59 1.79
4.38
1ST HALF 11ND HAL
17.00 3.50
13.50 3.50
3.50 0.00
1.00 0.21
1.20
2011-12 9.00 14.69
2012-13 21.00 13.10
2013-14 24.00 10.46
2014-15 27.00 7.55
2015-16 27.00 4.38
2016-17 17.00 1.20
Interest and Repayment of Mahindera Finance Term Loan MORATORIUM ONE YEAR REPAYMENT SCHEDULE 6 years YEAR
OPENING
Additions for unit -2
RATE OF 16.5 % AGE INTEREST (Figures in LACs Rs.) PAYMENTS BALANCE INTEREST TOTAL INTT. FOR THE DUE YEAR 0.00 560.00 46.20 0.00 560.00 46.20 92.40
2011-12
1ST HALF 11ND HAL
BALANCE 560.00 560.00
2012-13
1ST HALF 11ND HAL
560.00 532.00
28.00 56.00
532.00 476.00
46.20 43.89
90.09
1ST HALF 11ND HAL
476.00 420.00
56.00 56.00
420.00 364.00
39.27 34.65
73.92
1ST HALF 11ND HAL
364.00 308.00
56.00 56.00
308.00 252.00
30.03 25.41
55.44
1ST HALF 11ND HAL
252.00 196.00
56.00 56.00
196.00 140.00
20.79 16.17
36.96
1ST HALF 11ND HAL
140.00 84.00
56.00 56.00
84.00 28.00
11.55 6.93
18.48
1ST HALF 11ND HAL
28.00 0.00
28.00 0.00
0.00 0.00
2.31 0.00
2.31
2013-14
2014-15
2015-16
2016-17
2017-18
Total Repayment Interest
2011-12 0.00 92.40
2012-13 84.00 90.09
INST 2011-12 ICICI BANK
2011-12 127.63 234.72
INTEREST 2011-12 0.72 0.04
INSTL INTEREST TATA MOTORS INSTL INTEREST SBI TRUCK LOAN INSTL INTEREST HDFC Car Loan INSTL INTEREST TOTAL INSTALMENTS Total Interest
Total Loan Rep Interest
2013-14 112.00 73.92
2012-13 275.44 215.78
2014-15 112.00 55.44
INST
2015-16 112.00 36.96
INTEREST
2012-13 2013-14
2016-17 2017-18 112.00 28.00 18.48 2.31
INST 2014-15
INTEREST 2015-16
2016-17
0.95 0.48 0.49 0.15 2.16 0.67
0.95 0.48 0.56 0.08 1.51 0.56
0.95 0.48 0.26 0.01 1.21 0.49
0.00 0.00
0.00 0.00
0.00 0.00
2013-14 401.35 174.94
2014-15 390.64 124.22
2015-16 390.16 74.65
2016-17 233.61 27.72
2017-18 28.00 2.31
1846.83
Repayment & Interest of Unsecured Loans 2011-12 Religare
INSTL INTEREST
2011-12 7.07 2.73
PKF Finance
INSTL INTEREST
7.74 2.75
Mahindera & Mahindera (Swaraj
Repayment Interest
TOTAL INSTALMENTS Total Interest
2012-13 2013-14 2014-15 6.99 3.81 1.37 0.27 8.07 1.11
92.83 26.74
104.60 14.97
107.64 32.22
119.66 17.45
2015-16
2016-17
1.48 0.03 67.04 2.71
72.33 3.01
0.00 0.00
0.00 0.00
0.00 0.00