PLAST
PLAST
PLAST
VIKAS FASHION
VIKAS FASHION
###
###
Detail of the Machinery to be installed
Cost Per
Srn. Particular No. Supplier Name Amount
Machine
Total -
ANNEXURE-2
VIKAS FASHION
BALANCE SHEET AS ON
SOURCE OF FUND
APPLICATION OF FUNDS
FIXED ASSETS
GROSS BLOCK 15.10 15.10 15.10 15.10 15.10
LESS : DEPRECIATION 0.00 2.00 1.50 1.13 0.84
NET BLOCK 15.10 13.10 13.60 13.97 14.26
INCOME
Cost of Production
Finance Charges
Interest on TL (New) 0.00 1.53 1.27 0.99 0.68
Interest on Cash Credit 0.00 0.00 0.50 0.50 0.50
Total Finance Charges 0.00 1.53 1.77 1.49 1.18
DEPRECIATION SCHEDULE
New
15% - - - - - - - - - - - - - - - - -
Machinery
Total - - - - - - - - - - - - - - - - -
ANNEXURE 3
VIKAS FASHION
INCOME `
Other Income 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Total Income a 2.3 16.08 #REF! 15.70 19.63 30.66 #REF! #REF!
Cost of Production
Direct Expenses b 1.05 10.54 #REF! #REF! #REF! #REF! #REF! #REF!
Add: Opening Stock c 0.00 0.00 0.00 3.62 0.11 0.26 #REF! #REF!
Less: Closing stock d 0.00 0.00 3.62 0.11 0.26 #REF! #REF! #REF!
Cost of Production 1.05 10.54 #REF! #REF! #REF! #REF! #REF! #REF!
Gross Profit e=b+c-d 1.25 5.54 #REF! #REF! #REF! #REF! #REF! #REF!
Less: Indirect Exps.
Depreciation f 1.2 #REF! 0.00 0.00 0.00 0.00 0.00
Total Indirect Expenses h=f+g 0.20 2.64 #REF! 3.04 3.34 3.67 4.04 4.45
PBIT i=e-h 1.05 2.9 #REF! #REF! #REF! #REF! #REF! #REF!
Finance Charges
Interest on TL (New) 0.00 0.00 1.29 1.76 #REF! 1.53 1.27 #VALUE!
Interest on TL (Old) 0.00 0.26 0.20 0.17 0.15 0.09 0.00 0.00
Interest on WC 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Total Finance Charges 0.00 0.26 1.49 1.93 #REF! 1.62 1.27 #VALUE!
Profit Before Tax 1.05 2.64 #REF! #REF! #REF! #REF! #REF! #REF!
Tax on Profit 0.00 0.12 #REF! #REF! #REF! #REF! #REF! #REF!
Net Profit 1.05 2.64 #REF! #REF! #REF! #REF! #REF! #REF!
Drawing 0.00 0.5 1.00 1.50 2.00 2.50 3.00
Profit Carried to Capital A/C 1.05 2.64 #REF! #REF! #REF! #REF! #REF! #REF!
VIKAS FASHION
PROJECTED
PARTICULARS
Sl. 2021-22 2022-23 2023-24 2025-26
15.28 0.30 0.77 1.00
1 Raw Material 3.62 0.11 0.26 0.34
2 WIP 3.10 0.10 0.15 0.19
3 Finished Good 8.56 0.10 0.36 0.47
4 Book Debts 22.86 4.37 3.72 4.65
Total 38.14 4.67 4.49 5.65
1 Raw Material 35 35 35 35
2 WIP 30 30 20 20
3 Finished Good 75 30 30 20
4 Book Debts 180 105 88 88
5 Monthly Expenses 30 30 30 30
6 Sundry Creditors 30 30 30 30
VIKAS FASHION
PROJECTED
Sr. PARTICULARS
2021-22 2022-23 2023-24 2025-26
A. SOURCES OF FUND
Net Profit Before Tax & Interest 5.98 7.62 8.80 10.02
Capital & Subsidy
Depreciation 0.00 0.00 0.00 0.00
Fresh Term Loan from Bank 0.00 0.00 0.00 0.00
Increase in W.C. Loan from bank 0.00 0.00 0.00 0.00
Fresh Proprietors contibution 0.00 0.00 0.00 0.00
Increase in Creditors 1.50 0.50 0.26 0.83
Increase in Liability for Exps. 0.20 0.00 0.50 0.25
7.68 8.12 9.56 11.10
B. APPLICATION OF FUNDS
Purchase of Fixed Assets 0.00 0.00 0.00 0.00
Increase in current Assets
Inventory 1.35 1.01 1.89 2.11
Book Debts 0.42 2.40 0.06 1.25
Payment of Term Loan 1.36 2.22 2.45 2.71
Payment of Housing Loan 0.00 0.00 0.00 2.99
Investments 0.00 0.00 0.00 0.00
Interest 0.00 0.00 0.50 0.50
Tax 0.00 0.00 0.00 0.00
3.13 5.63 4.90 9.56
Statement Showing Selling, Distribution & Administrative Expenses for Projected Year
Monthly Annual
Administrative Staff Salary
Staff
Cleark 1 13,000 156,000
Security Staff 1 5,000 60,000
Other Expenses 5,000 60,000
Value in Rs. 276,000
Value in Lacs Rs. 2.76
Note: 1) S & D, Administration Expenses for every year is taken with a 5% increase.
CMA REPORT OF
Name of the Borrower: M/s. Ganesh Plast Mould
Name of Proprietor
4. Calculation of DSCR
FORM I
ASSESSMENT OF WORKING CAPITAL REQUIREMENTS
Name of the Borrower: M/s. Ganesh Plast Mould
ACTUAL PROJECTED
2021-22 2022-23 2023-24 2024-25 2025-26 2026-27 2027-28
1 GROSS INCOME
i) Sales (Net of Returns)
a) Domestic Sales 12.56 15.70 19.63 24.53 30.66 38.33 47.91
b) Export Sales 0.00 0.00 0.00 0.00 0.00 0.00 0.00
c) Sub - Total (a+b) 12.56 15.70 19.63 24.53 30.66 38.33 47.91
d) % age rise [+] or fall [-] in net
COST OF SALES
a) Purchases & Other Trading
Exp 3.62 7.07 9.88 15.48 21.21 27.15 34.51
3 d) Sub Total ( a+b) 3.62 7.07 9.88 15.48 21.21 27.15 34.51
4 Add:- Opening Stock 0.00 0.00 1.35 2.36 4.25 6.36 8.50
5 Less:- Closing Stock 0.00 1.35 2.36 4.25 6.36 8.50 10.27
6 GROSS PROFIT ( 2+5)-(3+4) 8.94 9.98 10.76 10.95 11.57 13.32 15.18
7 Other Income /Expenses 0.12 0.15 0.19 0.23 0.29 0.37 0.46
9 Operating Profit (6-7) 8.65 9.62 10.30 10.38 10.86 12.49 14.19
(before interest and depreciation)
12 Operating Profit (8-9-10) 5.98 7.62 7.27 7.48 8.52 10.68 12.89
13 Extra Ordinary item 0.00 0.00 0.00 0.00 0.00 0.00 0.00
14 Profit Before Tax/Loss (11+12) 5.98 7.62 7.27 7.48 8.52 10.68 12.89
16 Net Profit (13-14) 5.98 7.62 7.27 7.48 8.52 9.57 11.57
17 Drawing During the Year 0.00 0.00 0.00 0.00 0.00 0.00 0.00
18 Retained Profit 5.98 7.62 7.27 7.48 8.52 9.57 11.57
19 Retained Profit / Net Profit 100.00 100.00 100.00 100.00 100.00 100.00 100.00
FORM III - ANALYSIS OF BALANCE SHEET
Name of the Borrower: M/s. Ganesh Plast Mould
Sr.
Particular ACTUAL ESTIMATED PROJECTED
No
2021-22 2022-23 2023-24 2024-25 2025-26 2026-27 2027-28
CURRENT LIABILITIES
i) From Applicant Bank 0.00 0.00 0.00 0.00 0.00 0.00 0.00
ii) From other Banks 0.00 0.00 0.00 0.00 0.00 0.00 0.00
iii) (of which BP and BD) 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Sub Total (A) 0.00 0.00 0.00 0.00 0.00 0.00 0.00
2 Short term borrowings from others 0.00 0.00 0.00 0.00 0.00 0.00 0.00
3 Sundry Creditors (Trade) IND RM 0.00 1.50 2.00 2.26 3.09 5.58 6.27
For Exp. 0.00 0.50 0.75 0.81 0.96 1.13 1.36
5 Provision for Taxation TDS 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Sub Total (B) 0.00 4.71 5.74 8.73 10.20 11.01 8.63
10 TOTAL CURRENT LIABILITIES 0.00 4.71 5.74 8.73 10.20 11.01 8.63
(TOTAL OF 1 TO 9)
TERM LIABILITIES
11 Debentures (not maturing within one yea 0.00 0.00 0.00 0.00 0.00 0.00 0.00
17 TOTAL TERM LIABILITIES 15.45 11.25 13.26 9.95 6.30 5.00 5.00
(Total of 11 to 16)
18 TOTAL OUTSIDE LIABILITIES (10 to 15.45 15.96 19.00 18.68 16.50 16.01 13.63
NET WORTH
22 Investment Allowance Reserves 0.00 0.00 0.00 0.00 0.00 0.00 0.00
25 TOTAL LIABILITIES (18 + 24) 25.68 32.28 37.35 39.78 41.45 45.87 50.36
0.00 0.00 0.00 0.00 0.00 0.00 0.00
CURRENT ASSETS
26 Cash and Bank balances 3.95 2.24 2.43 2.59 2.66 2.73 2.94
30 Inventory:
i) Raw materials (including other items
used
in the process & manufacture)
0.00 0.00 0.00 0.00 0.00 0.00 0.00
i) Work in process 0.00 0.00 0.00 0.00 0.00 0.00 0.00
iii) Finished goods 0.00 1.35 2.36 4.25 6.36 8.50 10.27
32 Advance payment of taxes 0.00 0.00 0.00 0.00 0.00 0.00 0.00
33 Other current assets 0.00 8.54 9.51 9.46 3.41 2.24 2.48
36 Depriciation for the year 0.00 2.00 1.50 1.13 0.84 0.63 0.48
37 NET BLOCK (35-36) 15.10 13.10 13.60 13.97 14.26 14.47 14.62
39 Non - consumable stores and spares 0.00 0.00 0.00 0.00 0.00 0.00 0.00
40 OTHER NON-CURRENT ASSETS: 0.00 0.00 0.00 0.00 0.00 0.00 0.00
P & L Appropriation A/C
41 TOTAL NON-CURRENT ASSETS 2.51 2.51 2.51 2.51 6.51 9.51 10.51
(Total of 38 to 40)
43 TOTAL ASSETS (34+37+41+42) 25.68 32.28 37.35 39.78 41.45 45.88 50.36
44 TANGIBLE NET WORTH (24-42) 10.23 16.31 18.34 21.10 24.94 29.86 36.73
45 NET WORKING CAPITAL 8.07 11.96 15.50 14.57 10.48 10.89 16.60
[(17+24)-(37+41+42) to tally with (34-1 8.07 11.96 15.49 14.57 10.48 10.89 16.60
46 Current Ratio (Items 34/10) 0.00 3.54 3.70 2.67 2.03 1.99 2.92
A. CURRENT ASSETS
10 Creditors for purchase of raw materials, stores & 0.00 1.50 2.00 2.26 3.09 5.58
consumable spares
months purchase: (days) 0.00 0.50 0.75 0.81 0.96 1.13
(crs *365/purchase)
Provision for Taxation 0.00 0.00 0.00 0.00 0.00 0.00
13 Other current liabilities (specify major items) Short term 0.00 0.00 2.71 2.99 3.31 3.65
borrowings,
unsecured loans, dividend payable, installments of TL,
DPG,
Public deposits debenture, etc.
PROJECTED
2027-28
0.00
0.00
0.00
0.00
0.00
8.50
0
8.43
0.00
0.00
4.97
21.90
6.27
1.36
0.00
0.00
0.00
1.30
8.93
FORM V
Name of the Borrower: M/s. Ganesh Plast Mould
COMPUTATION OF MAXIMUM PERMISSIBLE
BANK FINANCE FOR WORKING CAPITAL
1 Total Current assets (9 in form IV) 8.07 6.78 10.72 11.95 15.16 17.52
2 Other current liabilities other than bank borrowing (14 0.00 2.00 5.46 6.06 7.36 10.36
of form IV)
3 Working capital gap (wcg) (1-2) 8.07 4.78 5.26 5.89 7.80 7.16
4 Minimum stipulated net working capital i.e. 25% of 2.02 1.20 1.32 1.47 1.95 1.79
wcg.
(export receivables to be excluded under both
methods)
5 Actual/ projected net working capital (45 in form III) 8.07 11.96 15.50 14.57 10.48 10.89
8 Maximum permissible bank finance Item 6 or 7 0.00 0.00 3.95 4.41 5.00 5.00
whichever is lower
9 Excess borrowings representing short fall in NWC (4- 0.00 0.00 -14.18 -13.10 -8.53 -9.10
5)
1 Total Current assets (9 in form IV) 8.07 6.78 10.72 11.95 15.16 17.52
3 Working capital gap (wcg) (1-2) 8.07 4.78 5.26 5.89 7.80 7.16
4 Minimum stipulated net working capital i.e. 25% of 2.02 1.70 2.68 2.99 3.79 4.38
total current assets
(export receivables to be excluded under both methods)
8 Maximum permissible bank finance Item 6 or 7 0.00 0.00 2.58 2.90 4.01 2.78
whichever is lower
9 Excess borrowings representing short fall in NWC (4- -6.05 -10.27 -12.82 -11.59 -6.69 -6.51
5)
the Borrower: M/s. Ganesh Plast Mould
TATION OF MAXIMUM PERMISSIBLE
FINANCE FOR WORKING CAPITAL
PROJECTED
2027-28
21.90
8.93
12.97
3.24
16.60
9.73
5.00
5.00
-13.36
2027-28
21.90
8.93
12.97
5.48
16.60
7.49
5.00
5.00
-11.13
FORM VI
Name of the Borrower: M/s. Ganesh Plast Mould
FUNDS FLOW STATEMENT
1 SOURCES
A) Net profit (after tax) 3.49 4.98 5.98
E) Decrease in
(i) Fixed Assets 0.00 0.00 0.00
(ii) Other non current assets 0.00 0.00 0.00
(iii) P & P Exp. 0.00 0.00 0.00
2 APPLICATION
D) Increase in:
(I) Fixed assets 0.00 0.00 0.00
(ii) Other non current assets 0.00 0.00 0.00
(iii) P & P exp. 0.00 0.00 0.00
* Break-up of (4)
i) Increase/ Decrease in Raw Materials 0.00 0.00 1.35
* Break-up of (5)
i) Increase/ Decrease in Sundry Creditors 0.00 0.00 1.50
Fixed Cost
S,D & Adminstrative
0.41 0.51 0.64 1.00 1.20 1.44 1.73
Expenses
Interest 0.00 1.53 1.77 1.18 0.83 0.53 4.49
Depreciation 2.67 2.00 1.50 0.84 0.63 0.48 0.20
Total Fixed Cost 4.61 4.29 3.32 2.68 2.36 6.41 1.93
CURRENT RATIO
ESTIMATED PROJECTED
PARTICULARS
2021-22 2022-23 2023-24 2024-25 2025-26 2027-28 2028-29
ESTIMATED PROJECTED
PARTICULARS
2021-22 2022-23 2023-24 2024-25 2025-26 2027-28 2028-29
DEBT
Term Loan 15.45 11.25 8.26 4.95 1.30 0.00 0.00
EQUITY
Share Capital 10.23 16.31 18.34 21.10 24.94 29.86 36.73
Unsecured Loan 0.00 0.00 5.00 5.00 5.00 5.00 5.00
Total 10.23 16.31 23.34 26.10 29.94 34.86 41.73
Debt Equity Ratio NA 0.89 0.73 0.54 0.36 0.21 0.15
Consider unsecured loan as Equity
Term Loan installment will be started after Three month morateriom period from April 2017
ANNEXURE 8 (a)
SUMMARY OF LOAN REPAYMENT
EXCEPT
Advances against Bank Deposits & other Paper Securities, Retail Trade Schemes and Agriculture Advances
ACTIVITY SHEET
ASSESSMENT NOTE FOR LOANS / LIMITS (FUND / NON FUND BASED) FALLING UNDER BRANCH POWERS.
(For Industrial & Conventional Loans (Except Retail Trade Schemes & Agriculture Advances)
Total of C. 0.00
7. “B” Details of Facilities enjoyed by Sister / Allied Concerns : Our Bank / Other Banks.
8. Borrowers Profile :
Office : #REF!
#REF!
#REF!
13. Category : Large & Medium / SSI / Trading / Services / Export / Import / Registration No. in case of
S.M.E
SSI and NBFC s etc.
14. Whether the Concern / its associate /promoter’s names appear in the caution list/ List of Fraudulent
No
Parties circulated by RBI / ECGC / Other Agencies.
15. Whether the Borrower is a defaulter of Our Bank / Any Other Bank ? No
16. Whether Prop / Partner / Director related to any Senior Officer (Scale-lV & above) of the Bank. No
17. A. Names of Prop. / Partners / Directors and their Financial Net Worth :
(Attach separate sheet if required)
Name F.N.W.
As on
31.03-
VIKAS FASHION #REF!
2010
18. Details of Security :
(Information based on Title Deeds and NEC issued by Bank’s Legal Counsel)
Under CGTSME
P.G. OF
Length of Experience in this line of activity : TEJAL NILISHBHAI PATEL has an experience of Three years in. designing, manufa
and marketing.
2. Does the unit have any other man to manage the affairs of the unit, in absence of the main Person behind the show?
Mr. Alpeshbhai Babubhai Ramani who are capable to handle the business affairs of the said firm in the absence of the Proprietor
NILISHBHAI PATEL
Repayments
Achievement
Project Implementation :
Capital Employed
#REF! #REF! #REF!
(A+B)
Bank Borrowing
#REF!
#REF!
#REF!
Total C #REF! #REF! #REF!
Grand Total A+B+C #REF! #REF! #REF!
Give actual figures for the Last 2 Years, Current Year estimates OR Projections in case of New
Units.
Particulars #REF!
1. Gross Sales( Including Jobwork) #REF!
2. Other Income #REF!
2. Interest Subsidy 0.00
3. Net Sales #REF!
4. Cost of Sales #REF!
Opening Stocks #REF!
(+) Purchase #REF!
(-) Closing Stocks #REF!
Raw Material Consumed- Electricity Exp. & Man.Labour & Employee Cost #REF!
The formulas for calculations of levels of Raw Materials, Semi-Finished Goods (Stock in Process) in case of Manufacturing Units ha
given in the Assessment of Working Capital Requirement sheet on page
1. The Tangible Net Worth of the Borrower has improved / gone down from Rs. 7.29 lacs to Rs. 11.91 lacs. Which is a h
sign.
2. The liabilities of the Borrower have Increased / Decreased . The reasons for increase these liabilities are : Total liabilities of the
borrower is decreasing trend.
Term liability include Term loan for purchase of machinery, so it is decreasing accordingly repayment of installment.
3. The level of Creditors have increased from 32 days to 52 days. But this increased due to more credit for high volumes. Reasons f
abnormality, if any: "
5. The Fixed Assets (Gross Block) have increased / decreased. The reasons for such increase /
decreased are : GROSS BLOCK ARE NO CHANGED.
Note : The increased in Fixed Assets should not be from short term sources particularly Bank
Borrowings.
6. Non-Current Assets have increased from Rs. 0.00 Lac to Rs. 0.50 Lac. The
Reasons for such increase are : investment of Rs. 50000 will made on assumption basis
in projected year.
7. Current Assets have increased from Rs. 4.96 Lac to Rs. 9.40 Lac. Reasons for increase and Comments on the Quality of Current
viz. Whether the inventory is turning over and debtors are being paid on time etc.
As The firm has utilided sales capacity for the purchase of computerized Embroidery machine 2009-10 financial year and curr
assets would increase accordingly.
8. Sales of the firm have increased by 201% %. Reasons given by the borrower for increase in Sales are :
9. Operating Profits of the firm have increased /decreased. The Reasons for decrease are :
The quantum of operating profit is increased, but the rate of operating profit is decreased due to utilization of more installed capaci
10. Net Profits of the firm have increased /decreased. The Reasons for decrease are :
The firm will utilized capacity of new purchased machines.
11. Any Other Observation / adverse Comments on the Annexes to the Balance Sheet like lists of Fixed Assets / Debtors / Cre
Qualified Comments in the Auditor Reports etc.
NO ADVERSD OBSERVATIONS.
Limit
Present Outstanding
Maximum Availment
Minimum Availment
Credit summation in the account
Interest earned
Whether Stock Statements, Book Debts
Statements, QIS Submitted Regularly
Nature of Facility UBD
Limit
Present Outstanding
No. & Amount of Bill Purchased
No. & Amount of bill Retired Unpaid
Maximum Availment
Minimum Availment
Commission Earned
Interest Earned
Nature of Facility Import
L/C
Present Outstanding
No. & Amount of L/C / Guarantee Established
No. & Amount of documents not retired under L/C / Guarantee invoked
Whether there are any L/C devolvement
Commission Earned
Nature of Facility Term
Loan-2
Limit
Present Outstanding
Installments Overdue
Interest Received
Brief comments on Availability of Raw Materials, Water, Power, Labour & Transport Facilities :
The unit required only potable waters, manufacturing process does not require water. It is available from municipal supply. Torren
connection is already available. No more power required as connected load. Labour is readily available in local area. Transport is a
from doorstep to market area.
Source of meeting margin money for Term Loan (Name of Bank / Branch / Account No. etc.)
Profitability Projections : (Profitability Projection must be obtained for the proposed repayment period)
3rd Year
Sales 36.64
Net Profit 11.50
The nature of Business in low working capital requirement due to main raw material is water which sources from own bore well.
* In case of existing Units, while accepting the projected sales / Turnover, the past trend in sales
should be carefully analyzed.
*In case of New Units the demand for the product vis a vis orders in hand etc. must be properly
examined.
10
As on
As on 1st Year 2nd Year
Days Amt.
1. Level of Raw Materials Avg.
Stock of RM / Raw Materials
Consumed x 365.
A. Letter Of Credit
11
Recommendation : I
1. Nature of Facility
2. Amount
4. Margin
5. Security : Primary
7. COLLATERAL SECURITIES :
8. PROCESS FEES:
10. EXISTING TERM LOAN O/S RS. -----------------------LACS renew on the existing terms & conditions of the sanctioned.
12
E
(Branch Incumbent)
NATIONAL
Irregularit Asset
y, Classifica
Overdue,i tion
f any
Asset
Classifica
tion
-
Proprietorship Firm
2007
Yes / No YES
N.A.
S.M.E
No
No
No
Shareholding %
100%
s. In Lacs )
Whether Encumbr
any ance if
litigation any
Pending
2008-09 2009-10
#REF! #REF!
#REF! #REF!
#REF! #REF!
0.00 0.00
0.00 0.00
#REF! #REF!
#REF! #REF!
#REF! #REF!
#REF! #REF!
#REF! 0.00
#REF! #REF!
#REF! #REF!
#REF! #REF!
nt of installment.
PC or any
other Pre-
Sales
Working
Capital
Facility
DD
Guarante
es
Term
Loan-3
Bank Finance
#REF! #REF!
#REF! #REF!
#REF! #REF!
- -
#REF! #REF!
#REF! #REF!
#REF! #REF!
#REF! #REF!
#REF! #REF!
#REF! #REF!
#REF!
(Rs. In Lac)
4th Year
38.37
12.03
(Rs. In Lac)
N.A.
As on 3rd Year
Days Amt.
N. A.
he sanctioned.
A. CURRENT LIABILITIES
i. Bank borrowings - - - - -
ii. Term loan installments - - - - -
Due within one year #REF! #REF! #REF! 0.00 #REF!
iii. Deposits/Unsecured Loans #REF! #REF! #REF! 0.00 0.00
iv. Sundry Creditors #REF! #REF! #REF! 0.00 0.00
v. Provisions - - - - -
vi. Other Current Liabilities #REF! #REF! #REF! 0.00 0.00
TOTAL (A) #REF! #REF! #REF! 0.00 #REF!
B. TERM LIABILITIES :-
Term loan :- #REF! #REF! 0.00 0.00 #REF!
Cash Credit :- #REF! #REF! #REF! #REF! #REF!
Total Term Liabilities (B) #REF! #REF! #REF! #REF! #REF!
C. NET WORTH
i. Capital #REF! #REF! #REF! 27.94 10.23
ii. Reserves & Surplus- #REF! #REF! #REF! #REF! #REF!
Cash Subsidy Total (I+II) - C #REF! #REF! #REF! #REF! #REF!
iii. TOTAL LIABILITIES (A+B+C) #REF! #REF! #REF! #REF! #REF!
E. CURRENT ASSETS
I Cash & Bank Balance #REF! 5.50 1.73 4.09 #REF!
ii. Receivables #REF! #REF! #REF! 9.77 4.12
iii. Inventory #REF! #REF! #REF! 9.58 0.00
iv. Loans & Advances - - - - -
v. Other Current Assets - - - - -
TOTAL (E) #REF! #REF! #REF! 23.44 #REF!
F. NET FIXED ASSETS #REF! #REF! #REF! 24.54 15.10
G. ADVANCES / INVESTMENTS
SUBSIDIARY/ASSOCIATE CONCERNS #REF! #REF! #REF! 0.00 2.51
H. OTHER NON-CURRENT ASSETS 0.00 0.00 0.00 0.00 0.00
I. TOTAL ASSETS(E+F+G+H) #REF! #REF! #REF! 47.98 #REF!
J. FINANCIAL PERFORMANCE
i. Net Sales #REF! 15.70 19.63 30.66 #REF!
ii. Gross Profit #REF! #REF! #REF! #REF! #REF!
iii. Depreciation #REF! 0.00 0.00 0.00 0.00
iv. Taxation #REF! #REF! #REF! #REF! #REF!
v. Net Profit #REF! #REF! #REF! #REF! #REF!
vi. Dividend (Drawings)
-Amount - - - - -
-Percentage - - - - -
Vii Profit retained in business #REF! #REF! #REF! #REF! #REF!
K. RATIO ANALYSIS
i. Current Ration #REF! #REF! #REF! 0.00 #REF!
ii. Total Debt/Equity #REF! #REF! #REF! NA #REF!
iii. Gross Profit/Sales (%) #REF! #REF! #REF! #REF! #REF!
iv. Net Profit/Sales (%) #REF! #REF! #REF! #REF! #REF!
v. Debtors/Sales (Days) 180 105 88 #REF! #REF!
vi. Creditors/purchase(Days) 30 30 30 #REF! #REF!
vii. Average debt service Coverage ratio
(in case of fresh term loan/DPG) #REF! #REF! #REF! 0.00 #REF!
viii. Turnover / Current Assets #REF! #REF! #REF! 3.80 #REF!
ix. Interest Coverage Ratio #REF! #REF! #REF! 0.00 #REF!
Projected
31.03.10 31.03.11 31.03.12 31.03.13 31.03.14
a) Balance Sheet Data /
Capital Structure
Paid up Capital
a) Equity Share Capital
b) Preference Share Capital #REF! #REF! #REF! 27.94 10.23
Reserves & Surplus (Excl. Revaluation
reserves and net of intangible assets) #REF! #REF! #REF! #REF! #REF!
Tangible Net worth #REF! #REF! #REF! #REF! #REF!
Term Liabilities #REF! #REF! #REF! #REF! #REF!
Capital Employed #REF! #REF! #REF! #REF! #REF!
Net Block #REF! #REF! #REF! 24.54 15.10
Funds Invested outside Business 0 0 0 0 0
Current Assets #REF! #REF! #REF! 23.44 #REF!
Current Liabilities #REF! #REF! #REF! 0.00 #REF!
Net Current Assets #REF! #REF! #REF! 23.44 #REF!
b) Operational Data
Gross Sales #REF! 15.70 19.63 30.66 #REF!
Less: Excise / Sales Tax 0 0 0 0 0
Net Sales #REF! 15.70 19.63 30.66 #REF!
Of which exports 0 0 0 0 0
Other Income 0 0 0 0 0
Manufacturing expenses #REF! #REF! #REF! #REF! #REF!
Adm. & Selling Expenses 2.76 3.04 3.34 3.67 4.04
Depreciation #REF! 0.00 0.00 0.00 0.00
Interest 1.29 1.76 #REF! 1.53 1.27
Net Profit before Tax #REF! #REF! #REF! #REF! #REF!
Net Profit After Tax #REF! #REF! #REF! #REF! #REF!
Dividend 0 0 0 0 0
Profitability Ratio
(NP/Sales) % #REF! #REF! #REF! #REF! #REF!
Net Profit / Capital Employed #REF! #REF! #REF! #REF! #REF!
Stock Turnover ratio #REF! #REF! #REF! 31.24% #REF!
Debtor Turnover ratio 180 105 88 #REF! #REF!
PAT / TNW
Current Ratio #REF! #REF! #REF! 0.00 #REF!
DE Ratio (Total Term Liabilities /
Tangible Net worth) #REF! #REF! #REF! #REF! #REF!
DE Ratio (Total outside Liabilities /
Tangible Net worth) #REF! #REF! #REF! #REF! #REF!
Financial Year Projected
2007-2008 2008-2009 2009-2010
Sales/ Receipts #REF! 15.70 19.63
Net Profit #REF! #REF! #REF!
Net Worth #REF! #REF! #REF!
ANNEXURE 8 (b)
VIKAS FASHION
Rate of Interest 10.50%
TERM LOAN REPAYMENT SCHEDULE
Principal Total
Sl. Month Interest Installment Balance O/S
Outstanding Instalment
1 Jan-14 850,000 7,438 0 7,438 850,000
2 Feb-14 850,000 7,438 0 7,438 850,000
3 Mar-14 850,000 7,438 0 7,438 850,000
Total 22,313 0 22,313
4 Apr-14 850,000 7,438 3,542 10,979 846,458
5 May-14 846,458 7,407 3,542 10,948 842,917
6 Jun-14 842,917 7,376 3,542 10,917 839,375
7 Jul-14 839,375 7,345 3,542 10,886 835,833
8 Aug-14 835,833 7,314 3,542 10,855 832,292
9 Sep-14 832,292 7,283 3,542 10,824 828,750
10 Oct-14 828,750 7,252 3,542 10,793 825,208
11 Nov-14 825,208 7,221 3,542 10,762 821,667
12 Dec-14 821,667 7,190 3,542 10,731 818,125
13 Jan-15 818,125 7,159 3,542 10,700 814,583
14 Feb-15 814,583 7,128 3,542 10,669 811,042
15 Mar-15 811,042 7,097 3,542 10,638 807,500
Total 87,205 42,500 129,705
16 Apr-15 807,500 7,066 3,542 10,607 803,958
17 May-15 803,958 7,035 3,542 10,576 800,417
18 Jun-15 800,417 7,004 3,542 10,545 796,875
19 Jul-15 796,875 6,973 3,542 10,514 793,333
20 Aug-15 793,333 6,942 3,542 10,483 789,792
21 Sep-15 789,792 6,911 3,542 10,452 786,250
22 Oct-15 786,250 6,880 3,542 10,421 782,708
23 Nov-15 782,708 6,849 3,542 10,390 779,167
24 Dec-15 779,167 6,818 3,542 10,359 775,625
25 Jan-16 775,625 6,787 3,542 10,328 772,083
26 Feb-16 772,083 6,756 3,542 10,297 768,542
27 Mar-16 768,542 6,725 3,542 10,266 765,000
Total 82,742 42,500 125,242
28 Apr-16 765,000 6,694 3,542 10,235 761,458
29 May-16 761,458 6,663 3,542 10,204 757,917
30 Jun-16 757,917 6,632 3,542 10,173 754,375
31 Jul-16 754,375 6,601 3,542 10,142 750,833
32 Aug-16 750,833 6,570 3,542 10,111 747,292
33 Sep-16 747,292 6,539 3,542 10,080 743,750
34 Oct-16 743,750 6,508 3,542 10,049 740,208
35 Nov-16 740,208 6,477 3,542 10,018 736,667
36 Dec-16 736,667 6,446 3,542 9,988 733,125
37 Jan-17 733,125 6,415 3,542 9,957 729,583
38 Feb-17 729,583 6,384 3,542 9,926 726,042
39 Mar-17 726,042 6,353 3,542 9,895 722,500
Total 78,280 42,500 120,780