Form - II : Opearting Statement Assesment of Working Capital Requirements (Rs.

in
lacs)
NAME : M/s
As per Profit & Loss Account actuals/estimates for the year ended/ending
March 31' 06 March 31' 07 March 31' 08 March 31' 09 March 31' 10 March 31' 11
Last year's Current Year Following Following Following Following
Audited Estimated Year-Projec. Year-Projec. Year-Projec. Year-Projec.
1 2 3 4 5 6
1. Gross sales - (i) Domestic sales 303.97 350.00 425.00 530.00 675.00 875.00
(ii) Export sales - - - - - -
(iii) Other Revenue Income - - - - - -
Add other revenue income
Total 303.97 350.00 425.00 530.00 675.00 875.00
Less excise duty - - - - - -
3. Net sales(item 1 - item 2) 303.97 350.00 425.00 530.00 675.00 875.00
4. % age rise (+) or fall (-) in net sales as compared to
previous year (annualised) 0.00% 15.14% 21.43% 24.71% 27.36% 29.63%
5. Cost of sales
i) Raw materials(including stores & spares and 267.44 301.00 365.50 455.80 580.50 752.50
other items used in the process of manufacture
(a) Imported - - - - - -
(b) Indigenous - - - - - -
ii) Other spares - - - - - -
(a) Imported - - - - - -
(b) Indigenous - - - - - -
iii)Power and fuel 13.70 15.75 19.13 23.85 30.38 39.38
iv) Direct labour(Factory wages & salary) 4.99 7.00 8.50 10.60 13.50 17.50
v) Other mfg. expenses 10.61 14.00 29.75 37.10 47.25 61.25
Vi) job Work charges - - - - - -
vi) Depreciation 0.83 0.83 1.90 1.90 1.90 1.90
vii) SUB-TOTAL (i to vi) 297.57 338.58 424.78 529.25 673.53 872.53
viii) Add:Opening stocks-in-process 103.61 100.38 101.50 127.50 159.00 202.50
Sub-total 401.18 438.96 526.28 656.75 832.53 1,075.03
ix) Deduct:Closing stocks-in-process 100.38 101.50 127.50 159.00 202.50 262.50
x) Cost of Production 300.80 337.46 398.78 497.75 630.03 812.53
xi) Add : Opening stock of Fini.goods - - - - - -
Sub-total 300.80 337.46 398.78 497.75 630.03 812.53
xii) Deduct closing stock of fini.goods - - - - - -
xiii) SUB-TOTAL (Total cost of sales) 300.80 337.46 398.78 497.75 630.03 812.53
Gross Profit 3.17 12.54 26.23 32.25 44.98 62.47
6. Selling, general & adm. expenses 0.21 3.50 6.38 8.48 11.48 15.75
7. SUB-TOTAL (5+6) 301.01 340.96 405.15 506.23 641.50 828.28
8. Operating profit before interest(3-7) 2.96 9.04 19.85 23.77 33.50 46.72
9. Interest 0.79 1.38 5.76 5.76 5.76 5.76
10.Operating profit after interest(8-9) 2.17 7.66 14.09 18.01 27.74 40.96
11. (i) Add other non-operating income
(a) Export Incentives
(b) Trading sales (Exports) - - - - - -
(c) Trading stock (net) - - - - - -
(d) Other Income - 0.02 0.02 0.04 0.06 0.06
Sub-total (income) - 0.02 0.02 0.04 0.06 0.06
(ii) Deduct other non-operating exp.
(a) Pre. Expenses (w.off) 0.38 0.38 0.38 - - -
(b) Loss on sale of fixed assets - - - - - -
(c) Loss in investment - - - - - -
(d) Bad debts written off - - - - - -
Sub-total(expenses) 0.38 0.38 0.38 - - -
(iii) Net of other non-operating income/expenses (0.38) (0.36) (0.36) 0.04 0.06 0.06
12. Profit before tax/loss {10+11(iii)} 1.79 7.30 13.73 18.05 27.80 41.02
13. Provision for taxes 0.35 1.11 3.28 4.73 8.01 12.46
Provision for deffered tax 0.25 0.35 0.45 0.55 0.65 0.75
FBT 0.11 0.12 0.14 0.16 0.20 0.26
14. Net profit/loss (12-13) 1.08 5.72 9.86 12.61 18.94 27.55
15. (a) Dividend & Dividend Tax - - - - - -
(b) Rate 0% 10% 0% 0% 0% 0%
16. Retained profit (14-15) 1.08 5.72 9.86 12.61 18.94 27.55
17. Retained profit/Net profit (% age) 100% 100% 100% 100% 100% 100%
 FORM - III
ANALYSIS OF BALANCE SHEET (Rs.in lacs)
0.00 As per Balance sheet as at
LIABILITIES March 31' 06 March 31' 07 March 31' 08 March 31' 09 March 31' 10 March 31' 11
Last year's Current Year Following Following Following Following
Audited Estimated Year-Projec. Year-Projec. Year-Projec. Year-Projec.
CURRENT LIABILITIES 1 2 3 4 5 6
1.Short-term borrowings from banks(incld.bills purchased
discounted & excess borrwoing placed on repayment basis)
(i) From applicant bank 4.99 25.00 40.00 55.00 70.00 90.00
(ii) From other banks 17.68 - - - - -
(iii) (of which BP & BD)
(i) From applicant bank - - - - - -
(ii) From other banks - - - - - -
Sub total (A) 22.67 25.00 40.00 55.00 70.00 90.00
2. Sundry creditors- Capital Goods and Spares - 2.00 - - - -
3. Sundry creditor 42.35 39.13 43.86 54.70 69.66 82.78
4. Advance payments from customers/dep. from dealers 113.91 90.30 109.65 125.26 172.00 225.75
5. Provision for taxation 0.46 1.23 3.42 4.89 8.21 12.72
6. Dividend payable - - - - - -
7. Other statutory liabilities (due within one year) - - 0.02 0.02 0.02 0.02
8. Deposits/Instalments of term loans/DPGs/Debentures, etc 0.00 - 3.00 3.00 3.00 3.00
(due within one year)
9. Other current liabilities & provisions (due in 1yr.) 0.09 0.08 0.10 0.10 0.10 0.10
(Specify major items)
b. Other Current Liab(repayment of unsecured loans) - - - - - -
Other Current Liabilities [Sub-total (B)] 156.81 132.74 160.05 187.97 252.99 324.37
10. Total Current Liabilities(total of 1 to 9 excl 1(iii) 179.48 157.74 200.05 242.97 322.99 414.37
TERM LIABILITIES
11.Debentures (not maturing within 1 yr.) - - - - - -
12.Prefrence shares(redeemable after1yr.) - - - - - -
13.Term loans(excld instalments payable within 1 yr.) - 27.00 24.00 21.00 18.00 15.00
14.Deferred Payment Credit excluding instt.due within 1 yr.) 3.81 3.21 2.61 2.01 1.41 0.81
15.Term deposits (repayable after 1 yr.) 53.30 60.00 70.00 85.00 90.00 100.00
16.Other term liabilities(unsecured loans) 2.31 1.10 1.10 1.10 1.10 1.10
17. TOTAL TERM LIABILITIES 59.42 91.31 97.71 109.11 110.51 116.91

18. Total Outside Liabilities(item 10 +17) 238.90 249.05 297.76 352.08 433.50 531.28
NET WORTH
19.Share Capital 11.89 15.00 20.00 25.00 25.00 25.00
20.General reserve 2.29 4.78 10.50 20.36 32.97 51.91
21. Reserve for deffered tax liability - - - - - -
22.Other reserves(excluding provisions) - - - - - -
23.Surplus(+) or deficit(-) in P&L account 1.08 5.72 9.86 12.61 18.94 27.55
23(a).Others - Share Premium - - - - - -
23(b). Deferred tax 0.40 0.60 0.80 1.00 1.20 1.40
24. NET WORTH 15.66 26.10 41.16 58.97 78.11 105.86
25. TOTAL LIABILITIES 254.56 275.15 338.92 411.05 511.61 637.14

FORM - III (Continued)

ANALYSIS OF BALANCE SHEET (Rs.in lacs)
0.00 As per Balance sheet as at
ASSETS March 31' 06 March 31' 07 March 31' 08 March 31' 09 March 31' 10 March 31' 11
Last year's Current Year Following Following Following Following
Audited Estimated Year-Projec. Year-Projec. Year-Projec. Year-Projec.
CURRENT ASSETS (2) (3) (4) (4) (4) (4)
26.Cash and bank balances 0.90 0.01 0.70 0.85 1.10 2.10
27.Investments(other than long term investments) - - - - - -
(i) Government & other Trustee securities - - - - - -
(ii)Fixed deposits with bank & Others 2.42 2.03 2.30 2.30 4.30 4.30
28.(i) Receivables other than defered & export 130.13 128.29 160.50 197.00 250.00 313.04
( including bills purchased and dicounted by banks) -
(ii)Export receivables(incld bills purchased & dis.by bank) - - - - - -
29.Instalments of deferred receivables(due within 1 yr.) - - - - - -
30.Inventory: 100.38 101.50 127.50 159.00 202.50 262.50
(i) Raw materials(including stores & other items - - - - - -
used in the process of manufacture)
a)Imported - - - - - -
b)Indigenous - - - - - -
(ii) Works-in-process 100.38 101.50 127.50 159.00 202.50 262.50
(iii)Finished goods - - - - - -
(iv) Other consumable spares - - - - - -
a)Imported - - - - - -
b)Indigenous - - - - - -
31.Advances to suppliers of raw materials & stores/spares - 0.55 1.42 0.80 2.51 2.80
32.Advance payment of taxes - 0.27 0.40 0.40 0.40 0.50
33.Other current assets - - - - - -
- stock of traded goods - - - - - -
- Others 0.78 0.50 0.50 0.50 0.50 1.50
34. TOTAL CURRENT ASSETS(total of 26 to 33) 234.61 233.15 293.32 360.85 461.31 586.74
FIXED ASSETS
35.Gross Block(land & building,machinery,work-in-process) 21.29 46.29 51.29 56.29 58.29 60.29
36.Depreciation to date 1.34 4.29 6.19 8.09 9.99 11.89
37. NET BLOCK (35-36) 19.95 42.00 45.10 48.20 48.30 48.40
OTHER NON-CURRENT ASSETS
38.Investments/book debts/adv./deposits which are not - - 0.50 2.00 2.00 2.00
Current Assets
(i) a)Investments in subsidiary companies/affiliates - - - - - -
b)Others - - 0.50 2.00 2.00 2.00
(ii)Advances to suppliers of capital goods & contractors - - - - - -
(iii)Defferred receivables - - - - - -
(iv)Others-Debtors >6 months - - - - - -
-Security deposit - - - - - -
-Loans & advances for others - - - - - -
39.Non-consumables stores & spares
40.Other non-current assets incl.dues from directors - - - - - -
41. TOTAL OTHER NON-CURR.ASSETS - - 0.50 2.00 2.00 2.00
42.Intangible assets(patents, goodwill, prelim. exp.
bad/doubtful expenses not provided for, etc.) - - - - - -
43. TOTAL ASSETS (34+37+41+42) 254.56 275.15 338.92 411.05 511.61 637.14
- - (0.00) (0.00) (0.00) (0.00)
44. TANGIBLE NET WORTH (24-42) 15.66 26.10 41.16 58.97 78.11 105.86
45. NET WORKING CAPITAL(17+24)-(37+41+42) 55.13 75.41 93.27 117.88 138.32 172.37
46. Current Ratio 1.50 1.76 1.83 1.92 1.82 1.81
47. Total Outside Liabilities/ Tangible Net Worth 15.26 9.54 7.23 5.97 5.55 5.02
48. Total Term Liabilities/Tangible Net Worth 3.79 3.50 2.37 1.85 1.41 1.10
 FORM - IV
Comparative statement of Current assets & Current Liabilities

0.00 As per Balance sheet as at

I. CURRENT ASSETS March 31' 06 March 31' 07 March 31' 08 March 31' 09 March 31' 10 March 31' 11
Last year's Current Year Following Following Following Following
Audited Audited Estimated Year-Projec. Year-Projec. Year-Projec.
(2) (3) (4) (4) (4) (4)
1.Raw materials including stores & other items used in
the process of manufacturing
(a) Imported : Amount - - - - - -
: Month's consumption - - - - - -
(b) Indigenous : Amount - - - - - -
: Month's consumption - - - - - -
2. Other consumable spares, excldg. those included in(1) above
(a) Imported : Amount - - - - - -
: Month's consumption - - - - - -
(b) Indigenous : Amount - - - - - -
: Month's consumption - - - - - -
3. Stocks-in-process : Amount 100.38 101.50 127.50 159.00 202.50 262.50
: Month's cost of Sales (4.00) (3.61) (3.84) (3.83) (3.86) (3.88)
4. Finished goods : Amount - - - - - -
: Month's cost of Sales - - - - - -
5. Receivables other than export & defered receivables
( Incldg. bills purchased & discounted by bank)
: Amount 130.13 128.29 160.50 197.00 250.00 313.04
: Month's Domestic Sales( includg. defered payment sales) (5.14) (4.40) (4.53) (4.46) (4.44) (4.29)
6. Export receivables(incldg. bills purchased & disc.)
: Amount 0.00 0.00 0.00 0.00 0.00 0.00
: Month's export Sales - - - - - -
7. Advance to suppliers of materials & stores/spares,consumable 0.00 0.55 1.42 0.80 2.51 2.80
8. Other current assets includg. cash & bank balances & defered 0.90 0.28 1.10 1.25 1.50 2.60
receivables due within one year(speciy major items)
: Cash & bank balances 0.90 0.01 0.70 0.85 1.10 2.10
: Investment except long-term investment of def. receivales 0.00 0.00 0.00 0.00 0.00 0.00
: Others 0.00 0.27 0.40 0.40 0.40 0.50
9. TOTAL CURRENT ASSETS 231.41 230.62 290.52 358.05 456.51 580.94

II. CURRENT LIABILITIES

(Other than bank borrowing for working capital)

10. Creditors for purchase of raw materials,stores & consumable

spares : Amount 42.35 39.13 43.86 54.70 69.66 82.78
: Month's purchase (1.90) (1.56) (1.44) (1.44) (1.44) (1.32)
11. Advance from customers 113.91 90.30 109.65 125.26 172.00 225.75
12. Statutory liabilities - - 0.02 0.02 0.02 0.02
13. Other current liabilities-specify major items
a) S.Creditors for Capital Goods - 2.00 - - - -
b) Dividend payable - - - - - -
c) Instalments of TL, DPS & public deposits - - 3.00 3.00 3.00 3.00
d) Other current liabilities & provisions 0.09 0.08 0.10 0.10 0.10 0.10
14. TOTAL 156.81 132.74 160.05 187.97 252.99 324.37

FORM - V
 ASSESSED BANK FINANCE - PROJECTED BALANCE SHEET METHOD (Rs. in Cr)
0.00 As per Balance sheet as at
March 31' 07 March 31' 08 March 31' 09 March 31' 10 March 31' 11 #REF!
Current Year Following Following Following Following #REF!
Audited Estimated Year-Projec. Year-Projec. Year-Projec. #REF!
(2) (3) (3) (3) (3) (3)
1. Total Current Assets 233.15 293.32 360.85 461.31 586.74 #REF!
2. Other Current Laibilities 132.74 160.05 187.97 252.99 324.37 #REF!
3. Working Capital Gap 100.41 133.27 172.88 208.32 262.37 #REF!
4. Net Working Capital (Actual/Projected) 75.41 93.27 117.88 138.32 172.37 #REF!
5. Assessed Bank Finance 25.00 40.00 55.00 70.00 90.00 #REF!
5. NWC/TCA (%) 32.34 31.80 32.67 29.98 29.38 #REF!
6. OCL/TCA (%) 56.94 54.56 52.09 54.84 55.28 #REF!
7. S.Creditors/TCA (%) 16.78 14.95 15.16 15.10 14.11 #VALUE!
8. ABF/TCA (%) 10.72 13.64 15.24 15.17 15.34 #REF!
9. Inventory/N.Sales (Days) 105.85 109.50 109.50 109.50 109.50 #VALUE!
10. Receivables/G.Sales (Days) 133.79 137.84 135.67 135.19 130.58 #VALUE!
11. S.Creditors/Purchases (Days) 47.45 43.80 43.80 43.80 40.15 #VALUE!

Computation Maximum Permissible Bank Finance for Working Capital

NAME :

1. Total Current Assets (9 in Form

2. Other Current Laibities

(Other than Bank Borrowing )14 of form-IV)

3. Wokring Capital Gap (WCG (1-2)

4. Min Stpulated Working Capital i.e. 25% of Working Capital Gap

(Export recevable to be excluted under both methods

5. Actual / Propected Net Working Capital (45 form III)

6. Item 3 Minus Items 4

7. Item 3 Minus Item 5

8. Maximum Permissable Bank Finance (Item 6-7 withover is lower)

9. Excess borrowings represerning Shortal in MMC (4-5)

FIRST METHOD OF LENDING

1. Total Current Assets (9 in Form IV)

2. Other Current Laibities

(Other than Bank Borrowing )14 of form-IV)

3. Wokring Capital Gap (WCG (1-2)

4. Min Stpulated Working Capital i.e. 25% of Working Capital Gap

(Export recevable to be excluted under both methods

5. Actual / Propected Net Working Capital (45 form III)

6. Item 3 Minus Items 4

7. Item 3 Minus Item 5

8. Maximum Permissable Bank Finance (Item 6-7 withover is lower)

9. Excess borrowings represerning Shortal in MMC (4-5)

FORM - VI FUND FLOW STATEMENT (Rs. lancs).

0.00 As per Balance sheet as at
March 31' 06 March 31' 07 March 31' 08 March 31' 09 March 31' 10 March 31' 11
Last year Current Year Following Following Following Following
Actuals Audited Estimated Year-Projec Year-Projec Year-Projec
(1) (2) (3) (3) (3) (3)

1. SOURCES
a) Net profit (after tax) 1.08 5.72 9.86 12.61 18.94 27.55
b) Depreciation 0.83 0.83 1.90 1.90 1.90 1.90
c) Increase in capital
d) Increase in term liabilities,including public deposits 56.98 31.89 6.40 11.40 1.40 6.40
e) Decrease in : i ) Fixed assets 0.00 0.00 0.00 0.00 0.00 0.00
ii) Other non-current assets 0.07 0.00 0.00 0.00 0.00 0.00
f) Others 0.89 4.72 5.20 5.20 0.20 0.20
g) TOTAL 59.85 43.16 23.36 31.11 22.44 36.05

2. USES
a) Net loss
b) Decrease in term liabilities,including public deposits 0.00 0.00 0.00 0.00 0.00 0.00
c) Increase in : i ) Fixed asset 12.41 25.00 5.00 5.00 2.00 2.00
ii ) Depreciation adjustment 2.39 -2.12 0.00 0.00 0.00 0.00
iii) Other non-current assets 0.00 0.00 0.50 1.50 0.00 0.00
d) Dividend payment 0.00 0.00 0.00 0.00 0.00 0.00
e) Others 0.00 0.00 0.00 0.00 0.00 0.00
f) TOTAL 14.80 22.88 5.50 6.50 2.00 2.00
3. Long term surplus / deficit 45.05 20.28 17.86 24.61 20.44 34.05
4. Increase / Decrease in current assets* 79.52 (0.02) 28.38 30.56 47.42 62.78
(as per details given below)
5. Increase / Decrease in current liabilities 153.66 (24.07) 27.30 27.92 65.02 71.38
other then bank borrowings
6. Increase / Decrease in working capital gap (74.14) 24.05 1.08 2.64 (17.60) (8.60)
7. Net surplus(+) / deficit(-) 119.19 (3.77) 16.79 21.97 38.04 42.65
8. Increase / Decrease in Bank borrowings 8.81 2.33 15.00 15.00 15.00 20.00
INCREASE / DECREASE IN NET SALES 256.99 46.03 75.00 105.00 145.00 200.00

*Break-up of (4) 128.00 (1.44) 31.79 36.97 53.04 62.65

i ) Increase / decrease in Raw materials (5.10) - - - - -
ii ) Increase / decrease in Stock -in-process 93.58 1.12 26.00 31.50 43.50 60.00
iii ) Increase / decrease in Finished goods (3.44) - - - - -
iv) Increase / decrease in Receivables (a) Domestic - - - - - -
v ) Increase / decrease in Stores & spares (3.44) - - - - -
vi) Increase / decrease in Other current assets (1.14) (1.07) 0.69 (0.47) 1.96 1.39
vIi) Increase / decrease in Cash & Bank Balances (0.94) (0.07) 1.69 (0.47) 1.96 1.39
Total 79.52 (0.02) 28.38 30.56 47.42 62.78
 COMPUTATION OF DSCR FOR TERM-LOAN

2006-07 2007-08 2008-09 2009-10 2010-11 2011-12

A.Sources
Net Sales 303.97 350.00 425.00 530.00 675.00 875.00
PAT 1.08 5.72 9.86 12.61 18.94 27.55
Depreciation 0.83 0.83 1.90 1.90 1.90 1.90
less investment
Sub-Total 1.91 6.55 11.76 14.51 20.84 29.45
Interest 0.25 2.86 2.56 2.26 1.96 1.66
Total(A) 2.16 9.41 14.33 16.77 22.80 31.11

B.Repayment
TL Repayment 0.00 3.00 3.00 3.00 3.00 3.00
Sub-Total 0.00 3.00 3.00 3.00 3.00 3.00
Interest 0.25 2.86 2.56 2.26 1.96 1.66
Total (B) 0.25 5.86 5.56 5.26 4.96 4.66

Net DSCR 0.00 2.18 3.92 4.84 6.95 9.82

Gross DSCR 8.64 1.60 2.58 3.19 4.59 6.67
Average DSCR for 6 yrs 4.62

SECURITY MARGIN 2006-07 2007-08 2008-09 2009-10 2010-11 2011-12

WDV OF FIXED ASSETS 19.95 42.00 45.10 48.20 48.30 48.40

AGGREGATE TL OUTSTANDING 30.00 27.00 24.00 21.00 18.00 15.00
MARGIN AVAILABLE -10.05 15.00 21.10 27.20 30.30 33.40
%OF MARGIN -50.38 35.71 46.78 56.43 62.73 69.01
Average MARGIN AVAILABLE 30.26
 CALCULATION OF INTEREST ON TERM LOAN

Rate of Interest taken 10%

Year-2006-2007
[Rs.in lacs]
Months Availment Op.Bal. Install Intt. Total Closing

Jan-07 10.00 0.00 0.00 0.00 0.00 10.00

Feb-07 10.00 10.00 0.00 0.08 0.08 20.00
Mar-07 10.00 20.00 0.00 0.17 0.17 30.00 27.00

Total 0.00 0.25 0.25

Year-2007-2008
[Rs.in lacs]
Months Op.Bal. Install Intt. Total Closing
Apr-07 30.00 0.25 0.25 0.50 29.75
May-07 29.75 0.25 0.25 0.50 29.50
June-07 29.50 0.25 0.25 0.50 29.25
July-07 29.25 0.25 0.24 0.49 29.00
Aug-07 29.00 0.25 0.24 0.49 28.75
Sep-07 28.75 0.25 0.24 0.49 28.50
Oct-07 28.50 0.25 0.24 0.49 28.25
Nov-07 28.25 0.25 0.24 0.49 28.00
Dec-07 28.00 0.25 0.23 0.48 27.75
Jan-08 27.75 0.25 0.23 0.48 27.50
Feb-08 27.50 0.25 0.23 0.48 27.25
Mar-08 27.25 0.25 0.23 0.48 27.00 24.00

Total 3.00 2.86 5.86

 Year-2008-2009
[Rs.in lacs]
Months Op.Bal. Install Intt. Total Closing
Apr-08 27.00 0.25 0.23 0.48 26.75
May-08 26.75 0.25 0.22 0.47 26.50
Jun-08 26.50 0.25 0.22 0.47 26.25
July-08 26.25 0.25 0.22 0.47 26.00
Aug-08 26.00 0.25 0.22 0.47 25.75
Sep-08 25.75 0.25 0.21 0.46 25.50
Oct-08 25.50 0.25 0.21 0.46 25.25
Nov-08 25.25 0.25 0.21 0.46 25.00
Dec-08 25.00 0.25 0.21 0.46 24.75
Jan-09 24.75 0.25 0.21 0.46 24.50
Feb-09 24.50 0.25 0.20 0.45 24.25
Mar-09 24.25 0.25 0.20 0.45 24.00 21.00

Total 3.00 2.56 5.56

Year-2009-2010
[Rs.in lacs]
Months Op.Bal. Install Intt. Total Closing
Apr-09 24.00 0.25 0.20 0.45 23.75
May-09 23.75 0.25 0.20 0.45 23.50
Jun-09 23.50 0.25 0.20 0.45 23.25
July-09 23.25 0.25 0.19 0.44 23.00
Aug-09 23.00 0.25 0.19 0.44 22.75
Sep-09 22.75 0.25 0.19 0.44 22.50
Oct-09 22.50 0.25 0.19 0.44 22.25
Nov-09 22.25 0.25 0.19 0.44 22.00
Dec-09 22.00 0.25 0.18 0.43 21.75
Jan-10 21.75 0.25 0.18 0.43 21.50
Feb-10 21.50 0.25 0.18 0.43 21.25
Mar-10 21.25 0.25 0.18 0.43 21.00 18.00

Total 3.00 2.26 5.26

 Year-2010-2011
[Rs.in lacs]
Months Op.Bal. Install Intt. Total Closing

Apr-10 21.00 0.25 0.18 0.43 20.75

May-10 20.75 0.25 0.17 0.42 20.50
Jun-10 20.50 0.25 0.17 0.42 20.25
July-10 20.25 0.25 0.17 0.42 20.00
Aug-10 20.00 0.25 0.17 0.42 19.75
Sep-10 19.75 0.25 0.16 0.41 19.50
Oct-10 19.50 0.25 0.16 0.41 19.25
Nov-10 19.25 0.25 0.16 0.41 19.00
Dec-10 19.00 0.25 0.16 0.41 18.75
Jan-11 18.75 0.25 0.16 0.41 18.50
Feb-11 18.50 0.25 0.15 0.40 18.25
Mar-11 18.25 0.25 0.15 0.40 18.00 15.00

Total 3.00 1.96 4.96

Year-2011-2012
[Rs.in lacs]
Months Op.Bal. Install Intt. Total Closing

Apr-11 18.00 0.25 0.15 0.40 17.75

May-11 17.75 0.25 0.15 0.40 17.50
Jun-11 17.50 0.25 0.15 0.40 17.25
July-11 17.25 0.25 0.14 0.39 17.00
Aug-11 17.00 0.25 0.14 0.39 16.75
Sep-11 16.75 0.25 0.14 0.39 16.50
Oct-11 16.50 0.25 0.14 0.39 16.25
Nov-11 16.25 0.25 0.14 0.39 16.00
Dec-11 16.00 0.25 0.13 0.38 15.75
Jan-12 15.75 0.25 0.13 0.38 15.50
Feb-12 15.50 0.25 0.13 0.38 15.25
Mar-12 15.25 0.25 0.13 0.38 15.00 12.00

Total 3.00 1.66 4.66

 Year-2012-2013
[Rs.in lacs]
Months Op.Bal. Install Intt. Total Closing

Apr-12 15.00 0.25 0.13 0.38 14.75

May-12 14.75 0.25 0.12 0.37 14.50
Jun-12 14.50 0.25 0.12 0.37 14.25
July-12 14.25 0.25 0.12 0.37 14.00
Aug-12 14.00 0.25 0.12 0.37 13.75
Sep-12 13.75 0.25 0.11 0.36 13.50
Oct-12 13.50 0.25 0.11 0.36 13.25
Nov-12 13.25 0.25 0.11 0.36 13.00
Dec-12 13.00 0.25 0.11 0.36 12.75
Jan-13 12.75 0.25 0.11 0.36 12.50
Feb-13 12.50 0.25 0.10 0.35 12.25
Mar-13 12.25 0.25 0.10 0.35 12.00 9.00

Total 3.00 1.36 4.36

Year-2013-2014
[Rs.in lacs]
Months Op.Bal. Install Intt. Total Closing
Apr-13 12.00 0.25 0.10 0.35 11.75
May-13 11.75 0.25 0.10 0.35 11.50
Jun-13 11.50 0.25 0.10 0.35 11.25
July-13 11.25 0.25 0.09 0.34 11.00
Aug-13 11.00 0.25 0.09 0.34 10.75
Sep-13 10.75 0.25 0.09 0.34 10.50
Oct-13 10.50 0.25 0.09 0.34 10.25
Nov-13 10.25 0.25 0.09 0.34 10.00
Dec-13 10.00 0.25 0.08 0.33 9.75
Jan-14 9.75 0.25 0.08 0.33 9.50
Feb-14 9.50 0.25 0.08 0.33 9.25
Mar-14 9.25 0.25 0.08 0.33 9.00 6.00

Total 3.00 1.06 4.06

 Year-2014-2015
[Rs.in lacs]
Months Op.Bal. Install Intt. Total Closing
Apr-14 9.00 0.25 0.08 0.33 8.75
May-14 8.75 0.25 0.07 0.32 8.50
Jun-14 8.50 0.25 0.07 0.32 8.25
July-14 8.25 0.25 0.07 0.32 8.00
Aug-14 8.00 0.25 0.07 0.32 7.75
Sep-14 7.75 0.25 0.06 0.31 7.50
Oct-14 7.50 0.25 0.06 0.31 7.25
Nov-14 7.25 0.25 0.06 0.31 7.00
Dec-14 7.00 0.25 0.06 0.31 6.75
Jan-15 6.75 0.25 0.06 0.31 6.50
Feb-15 6.50 0.25 0.05 0.30 6.25
Mar-15 6.25 0.25 0.05 0.30 6.00 3.00

Total 3.00 0.76 3.76

Year-2015-2016
[Rs.in lacs]
Months Op.Bal. Install Intt. Total Closing
Apr-15 6.00 0.25 0.05 0.30 5.75
May-15 5.75 0.25 0.05 0.30 5.50
Jun-15 5.50 0.25 0.05 0.30 5.25
July-15 5.25 0.25 0.04 0.29 5.00
Aug-15 5.00 0.25 0.04 0.29 4.75
Sep-15 4.75 0.25 0.04 0.29 4.50
Oct-15 4.50 0.25 0.04 0.29 4.25
Nov-15 4.25 0.25 0.04 0.29 4.00
Dec-16 4.00 0.25 0.03 0.28 3.75
Jan-16 3.75 0.25 0.03 0.28 3.50
Feb-16 3.50 0.25 0.03 0.28 3.25
Mar-16 3.25 0.25 0.03 0.28 3.00 0.00

Total 3.00 0.46 3.46

 Year-2016-2017
[Rs.in lacs]
Months Op.Bal. Install Intt. Total Closing
Apr-15 3.00 0.25 0.03 0.28 2.75
May-15 2.75 0.25 0.02 0.27 2.50
Jun-15 2.50 0.25 0.02 0.27 2.25
July-15 2.25 0.25 0.02 0.27 2.00
Aug-15 2.00 0.25 0.02 0.27 1.75
Sep-15 1.75 0.25 0.01 0.26 1.50
Oct-15 1.50 0.25 0.01 0.26 1.25
Nov-15 1.25 0.25 0.01 0.26 1.00
Dec-16 1.00 0.25 0.01 0.26 0.75
Jan-16 0.75 0.25 0.01 0.26 0.50
Feb-16 0.50 0.25 0.00 0.25 0.25
Mar-16 0.25 0.25 0.00 0.25 0.00 NA

Total 3.00 0.16 3.16

 PERFORMANCE AND FINANCIAL INDICATORS.

PARTICULARS March 31' 06 March 31' 07 March 31' 08 March 31' 09 March 31' 10 March 31' 11 #REF!
Last year's Current Year Following Following Following Following #REF!
Audited Estimated Year-Projec. Year-Projec. Year-Projec. Year-Projec. #REF!
Net Sales 303.97 350.00 425.00 530.00 675.00 875.00 #REF!
PBT 1.79 7.30 13.73 18.05 27.80 41.02 #REF!
PAT 1.08 5.72 9.86 12.61 18.94 27.55 #REF!
PAT/N.Sales (%) 0.36 1.63 2.32 2.38 2.81 3.15 #REF!
Paidup Capital 11.89 15.00 20.00 25.00 25.00 25.00 #REF!
TNW 15.66 26.10 41.16 58.97 78.11 105.86 #REF!
TOL/TNW 15.26 9.54 7.23 5.97 5.55 5.02 #REF!
CR 1.50 1.76 1.83 1.92 1.82 1.81 #REF!
PBT/TTA(%) 0.70 2.65 4.05 4.39 5.43 6.44 #REF!
N.Sales/TTA (times) 1.19 1.27 1.25 1.29 1.32 1.37 #REF!
Optg. Exp/N.Sales (%) 99.29 97.81 96.68 96.60 95.89 95.32 #VALUE!
BB/TTA (%) 8.91 9.09 11.80 13.38 13.68 14.13 #REF!
Inv+Rec/N.Sales (Days) 276.79 239.64 247.34 245.17 244.69 240.08 #REF!
TTA 254.56 275.15 338.92 411.05 511.61 637.14 #VALUE!
Optg.Exp 301.80 342.34 410.91 511.99 647.26 834.04 #VALUE!
Inv+Rec 230.51 229.79 288.00 356.00 452.50 575.54 #VALUE!
BB 22.67 25.00 40.00 55.00 70.00 90.00 #REF!
 ASSESSMENT OF WORKING CAPITAL REQUIREMENTS UNDER PBS METHOD

Particulars March 31' 06 March 31' 07 March 31' 08 March 31' 09 March 31' 10 March 31' 11 #REF!
Total Current Assets 234.61 233.15 293.32 360.85 461.31 586.74 #REF!
Other Current Liabilities 156.81 132.74 160.05 187.97 252.99 324.37 #REF!
Working Capital Gap 77.80 100.41 133.27 172.88 208.32 262.37 #REF!
NWC(Actual/Proj) 55.13 75.41 93.27 117.88 138.32 172.37 #REF!
ABF 22.67 25.00 40.00 55.00 70.00 90.00 #REF!
NWC/TCA (%) 23.50 32.34 31.80 32.67 29.98 29.38 #REF!
OCL/TCA (%) 66.84 56.94 54.56 52.09 54.84 55.28 #REF!
S.Creditors/TCA (%) 18.05 16.78 14.95 15.16 15.10 14.11 #VALUE!
ABF/TCA (%) 9.66 10.72 13.64 15.24 15.17 15.34 #REF!
Inventories/N.Sales (Days) 75.52 105.85 109.50 109.50 109.50 109.50 #REF!
Receivables/G.Sales (Days) 156.26 133.79 137.84 135.67 135.19 130.58 #REF!
S.Crs/Purchases (Days) 57.80 47.45 43.80 43.80 43.80 40.15 #REF!
PBDIT/Intt (Times) 4.80 7.15 3.78 4.46 6.15 8.44 #VALUE!
PAT/N.Sales (%) 0.36 1.63 2.32 2.38 2.81 3.15 #REF!
ROCE (%) 1.49 3.59 6.42 6.24 6.92 7.63 #VALUE!
N.Sales 303.97 350.00 425.00 530.00 675.00 875.00 #REF!
G.Sales 303.97 350.00 425.00 530.00 675.00 875.00 #REF!
Receivables 130.13 128.29 160.50 197.00 250.00 313.04 #VALUE!
Inventory 100.38 101.50 127.50 159.00 202.50 262.50 #REF!
Purchases 267.44 301.00 365.50 455.80 580.50 752.50 #REF!
S.Creditors 42.35 39.13 43.86 54.70 69.66 82.78 #REF!
PBDIT 3.79 9.87 21.75 25.67 35.40 48.62 #VALUE!
Interest 0.79 1.38 5.76 5.76 5.76 5.76 #REF!
TTA 254.56 275.15 338.92 411.05 511.61 637.14 #VALUE!
Cash Accruals 1.91 6.55 11.76 14.51 20.84 29.45 #REF!
PBT/NS (%) 0.59 2.09 3.23 3.41 4.12 4.69 #REF!
 BREAK EVEN SALES

2005-06 2006-07 2007-08 2008-09

SALES 45.00 65.00 88.00 95.00

Variable Expenses
Raw Material 34.17 54.22 73.60 75.55
Power & Fuel 0.19 0.22 0.40 0.50
Direct Labour 45% 0.11 0.19 0.36 0.50
Other Manufacturing Exp. 0.95 1.13 1.87 2.30
Selling Gene.Administrative 50% 1.73 2.40 2.65 2.90

Total of Variable Expenses 37.15 58.16 78.88 81.75

Contribution 7.85 6.84 9.12 13.25

Fixed Expesnes Direct Labour 55% 0.14 0.24 0.44 0.60

Depreciation 0.70 1.05 1.64 1.64
Selling Gene.Administrative 50% 1.74 2.40 2.65 2.90
Interest on Term Loan 0.00 0.31 1.04 0.74

Total of Fixed Expesnes 2.58 4.00 5.77 5.88

B.E.P. FIXED COST/CONTRIBUTION 0.33 0.58 0.63 0.44

If increase in cost of raw material

by 5%
Contribution [as above] 7.85 6.84 9.12 13.25
Less: Effect of r/m change 1.71 2.71 3.68 3.78
Revised Contribution 6.14 4.13 5.44 9.47

Revised B.E.P. 0.42 0.97 1.06 0.62

IF SALES DECREASE BY 5% Contribution [as above] 7.85 6.84 9.12 13.25

less: effect of change 2.25 3.25 4.40 4.75
Revised Contribution 5.60 3.59 4.72 8.50

Revised B.E.P. 0.46 1.11 1.22 0.69

 GOYAL & VERMA ASSOCIATES

FINANCIAL PROPOSAL

Regd. Office : PACHORE, DISTT.-RAJGARH (M.P.)

Admn. Office :
 June 30' 04 March 31' 06 March 31' 07 March 31' 08 March 31' 09
Cross Checks Yr .Before Last year's Current Year Following Following
Last-Audited Audited Estimated Year-Projec. Year-Projec.
Difference in Balance Sheet 0.00 0.00 0.00 0.00 0.00

Diff between SIP in P& L and in Balance sheet 0.00 0.00 0.00 0.00 0.00

Diff between FG in P& L and in Balance sheet 0.00 0.00 0.00 0.00 0.00

Diff between Dep in P& L and in Balance sheet 2.39 (2.12) 0.00 0.00

Diff between P& L Balane & Inc in Retained Earnings (0.89) (4.72) (5.20) (5.20)
March 31' 10 March 31' 11 #REF!
Following Following #REF!
Year-Projec. Year-Projec. #REF!
0.00 0.00 #VALUE!

0.00 0.00 #VALUE!

0.00 0.00 #VALUE!

0.00 0.00 #VALUE!

(0.20) (0.20) #VALUE!