Analysis of Balance Sheet
Audited Audited Provisional Provisional Estimated Projected Accepted Accepted
LIABILITIES 31.03.08 31.03.09 31.03.10 31.03.11 31.03.12 31.03.11 31.03.12
Capital Authorised
Capital Paid Up - -
Reserve & Surplus - -
Less Integible Assets - -
Deferred Tax Liabilities - -
Tangible Net Worth - - - - - - - -
Unsecured Loans - -
Secured Loans - -
Total Long Term Funds - - - - - - - -
- -
Bank Borrowing - -
S. Creditors - Trade - -
S. Creditors - Capital Goods - -
S. Creditors - Non Trade - -
Total Creditors - - - - - - - -
Adv. From Buyers - -
Expenses Payable - -
Other current Liabilities - -
Total Current Liabilities - - - - - - - -
Total Liabilities - - - - - - - -
- -
Fixed Assets - Net - -
Investments - -
Security Deposits - -
Adv. For Fixed Assets - -
Margin Money for NFB - -
Total Long Term Outlay - - - - - - - -
- -
Stocks in Hand- Raw Material - -
Stocks in Hand- S.I.P. - -
Stocks in Hand- Finished Goods - -
Stocks in Hand- Total - - - - - - - -
S. Debtors Inland - -
S. Debtors Export - -
Debtors Total - - - - - - - -
Advance to Suppliers - -
Cash & Bank Bl. - -
Other Current Assets - -
Total Current Assets - - - - - - - -
Non Current Assets - -
- -
Total Assets - - - - - - - -
- - - - - - - -
31.03.08 31.03.09 31.03.10 - 31.03.11 31.03.12 31.03.11 31.03.12
Sales - Inland - -
Sales - Export - -
Income Receipts Others - -
Gross Sales/ Receipts - - - - - - - -
Profit Before Tax - -
Tax - -
Profit After Tax - - - - - - - -
Intt. on capital + Partner salaries - -
Depriciation - -
Cash Accrual - Post Tax - - - - - - - -
Net Worth - - - - - - - -
Net Working Capital - - - - - - - -
Current Ratio #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Debt Equity Ratio #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
TOL/TNW #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Other Data
Consumption of Raw Material - -
Cost of Production - -
Cost of Sales - -
Flow of NWC
2010-11 2011-12
Opening Balance of NWC - -
Add
Change in Capital - -
Change in Reserve &
Surplus - -
Change in Intengible
Assets - -
Change in Deferred tax
Liabilities - -
Change in Unsecured
Loans - -
Fresh Term Loans
Depriciation - -
Sub Total - - -
MINUS
Addition in fixed assets - -
Change in Investments - -
Change in Security
Deposits - -
Change in Adv. for fixed
assets - -
Repayment of bank term
loans - -
Change in Margin
Money for NFB limits - -
Change in Non Current
Assets - -
Closing Balance of
NWC - -
- -
- -
TOL - - -
TNW - - -
TOL/TNW #DIV/0! #DIV/0! #DIV/0!
Long Term Sources - - -
Long Term Uses - - -
Surplus / Deficit - - -
Short Term Sources - - -
Short Term Uses - - -
Deficit - - -
Calculation of PBF under Traditional Method of Lending
The Trend of Sales is as under:-
Audited Audited Provisional
31.03.08 31.03.09 31.03.10
Sales - Inland - - -
Sales - Export - - -
Income Receipts Others - - -
Gross Sales/ Receipts - - -
%age Growth #DIV/0! #DIV/0!
Basic Data Per Month
Actual for two years Estimated Projected
31.03.09 31.03.10 31.03.11 31.03.12
Sales - Inland - - - -
Sales - Export - - - -
Income Receipts Others - - - -
Gross Sales/ Receipts - - - -
Consumption of Raw Material - - - -
Cost of Production - - - -
Cost of Sales - - - -
Creditors - - - -
Accepted Norms
Particulars Last accepted Actual for Actual for Estimates for Projection for
(Month)
31.03.09 31.03.10 31.03.11 31.03.12
Raw material #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Stock-in-process #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Finished goods #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Receivables
- Domestic #DIV/0! #DIV/0! #DIV/0! #DIV/0!
- Export #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Sundry creditors #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Chargeable Current Assets
Particulars Norm Accepted for Norm Accepted Value accepted Value accepted
for
Particulars
31.03.11 31.03.12 31.03.11 31.03.12
Raw material #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Stock-in-process #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Finished goods #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Receivables - - - -
- Domestic #DIV/0! #DIV/0! #DIV/0! #DIV/0!
- Export #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Total Chargeable Current
Assets #DIV/0! #DIV/0!
Other Current Assets
Particulars Last accepted Actual for Actual for Estimates for Projection for
31.03.09 31.03.10 31.03.11 31.03.12
Advance to Suppliers - - - -
Cash & Bank Bl. - - - -
Other Current Assets - - - -
Total OCA - - - - -
Other Current Liabilities
Particulars Last accepted Actual for Actual for Estimates for Projection for
31.03.09 31.03.10 31.03.11 31.03.12
Adv. From Buyers - - - -
Expenses Payable - - - -
Other current Liabilities - - - -
Total OCA - - - - -
Calculation of PBF
Estimated Projected Accepted
31.03.11 31.03.12 31.03.11
Chargeable current assets - - #DIV/0!
Other current assets - - -
Total Current Assets - - #DIV/0!
Minus Creditors - - #DIV/0!
Minus OCL - - -
Working Capital Gap (A) - - #DIV/0!
Minimum required NWC
(25 % of CCA other than
Export Receivables) - B - - #DIV/0!
Projected NWC ( C ) - - -
Item A minus B - - #DIV/0!
Item A minus C - - #DIV/0!
MPBF Accepted - - #DIV/0!
( Amt. In lac)
Provisional Estimated Projected Accepted Accepted
- 31.03.11 31.03.12 31.03.11 31.03.12
- - - - -
- - - - -
- - - - -
- - - - -
#DIV/0! #DIV/0! #DIV/0! #DIV/0!
Accepted Accepted
31.03.11 31.03.12
- -
- -
- -
- -
- -
- -
- -
- -
Norm Accepted Norm Value accepted Value
for Accepted for accepted
31.03.11 31.03.12 31.03.11 31.03.12
#DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0!
Accepted for Accepted for
31.03.11 31.03.12
- -
- -
- -
- -
Accepted for Accepted for
31.03.11 31.03.12
- -
- -
- -
- -
Accepted for
31.03.12
#DIV/0!
-
#DIV/0!
#DIV/0!
-
#DIV/0!
#DIV/0!
-
#DIV/0!
#DIV/0!
#DIV/0!
