206x Filetype XLS File size 0.50 MB Source: www.fixedincome.global
Sheet 1: INDEX
CMA | CMA | ||||||||||||||||||||||
Write the name of the applicant. Even if you write the name in lowercase, it will be automatically copied to all other sheets in UPPERCASE only. | |||||||||||||||||||||||
ÈSTART HERE | |||||||||||||||||||||||
Name: | |||||||||||||||||||||||
Name: | |||||||||||||||||||||||
v2 | |||||||||||||||||||||||
CONTENTS | About this CMA format | ||||||||||||||||||||||
1 | Form-I | Particulars of Limites & Information about Associate Companies | 1 | Name of the applicant can be filled only in this sheet (in cell E7 on the left). Even if it is written in lowercase, it will be automatically copied in other sheets in UPPERCASE only. Nowhere else in this file, it can be written. | |||||||||||||||||||
2 | Form-II | Operating Statement | 2 | All the cells in all the sheets can be accessed. | |||||||||||||||||||
3 | Form-III | Analysis of Balance Sheet - Liabilities | 3 | Data can be filled only in unlocked cells. | |||||||||||||||||||
4 | Form-III | Analysis of Balance Sheet - Assets | 4 | Locked cells can be accessed. However, they or the information contained in the locked cells cannot be modified or deleted. However, it can be modified in the unlocked file. | |||||||||||||||||||
5 | Form-IV | Comparative Statement of Current Assets & Current Liabilities | 5 | Locked cells may contain either formula or reference to information in other cells or a hyperlink or any other information which is not required to be modified. | |||||||||||||||||||
6 | Form-V | Maximum Permissible Bank Finance for Working Capital | 6 | Data is required to be & can be filled up manually in Form-I to Form-III (assets & liabilities) in the unlocked cells only. | |||||||||||||||||||
7 | Form-VI | Funds Flow Statement | 7 | Data is not required to be & cannot be filled up manually in other Forms or sheets. They provide information based on data in Forms-I to Form-III (assets & liabilites). | |||||||||||||||||||
8 | Summary of Financial Statements for Ratio Analysis | 8 | All calculations in all other Forms & sheets are automatic by different formulae & links to other sheets | ||||||||||||||||||||
9 | Ratio Analysis | 9 | All efforts have been taken to make all the Forms & statements error-free. However, chance of error cannot be ruled out. | ||||||||||||||||||||
10 | Statement of Changes in Working Capital | 10 | If you come across any errors or problems while using these Forms & statements, kindly inform me about the same. | ||||||||||||||||||||
11 | Cross Check for errors, if any | 11 | Feedback, appreciation, criticism, suggestions, advice etc are most welcome. | ||||||||||||||||||||
12 | Charts | ||||||||||||||||||||||
FORM - I | ||||||||||||||
Particulars of Existing / Proposed Limits from the Banking System | ||||||||||||||
(Limits from all Banks and Financial Institutions as on date of application) | ||||||||||||||
Name: | ||||||||||||||
Sr. No. | Name of Bank / Financial Institution | Nature of Facility | Existing Limits | Extent to which Limits were utilised during last 12 months | Balance outstanding as on | Limits now requested | ||||||||
31-Mar-08 | 2008-09 | |||||||||||||
Maximum | Minimum | |||||||||||||
A. | Working Capital Limits: | |||||||||||||
1 | Fund based | |||||||||||||
Cash Credit | - | - | - | - | - | |||||||||
2 | Non-fund based | Letter of Credit | - | - | - | - | - | |||||||
- | - | - | - | |||||||||||
B. | Term Loans/DPGS excluding Working Capital Loans | Term Loan | - | |||||||||||
Total: - | - | - | - | - | - | |||||||||
Information about Associate Companies | ||||||||||||||
(Companies / Firms / Concerns in which Directors / Partners / Proprietor and / or their family members or the brorower Company is / are asssociated with the other Unit as Directors / Partners / Proprietor or has / have furnishted guarantees). | ||||||||||||||
Name: | #REF! | |||||||||||||
Sr. No. | Name of the Associate Company & Activity | Annual makeup of A/c | Limits from all Banks and financial institutions | Overdues, if any | ||||||||||
Name of Bank / Financial Institution | Working Capital | Term Loan & DPG | ||||||||||||
Date of Balance Sheet | Fund based | Non-fund based | ||||||||||||
1 | - | - | - | - | ||||||||||
2 | - | - | - | - | ||||||||||
3 | - | - | - | - | ||||||||||
4 | ||||||||||||||
5 | ||||||||||||||
- | - | - | - |
FORM II : OPERATING STATEMENT | ||||||||||||||||||
Name: | ||||||||||||||||||
Sr. No. | Particulars | Actuals as per audited accounts | Current Year Estimated | Following years Projected | ||||||||||||||
31-Mar-12 | 31-Mar-13 | 31-Mar-14 | 31-Mar-15 | 31-Mar-16 | 31-Mar-17 | 31-Mar-18 | ||||||||||||
Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | ||||||||||||
A | Quantities: | |||||||||||||||||
i | Raw Material Consumption | - | - | - | - | - | - | - | ||||||||||
ii | Sales | - | - | - | - | - | - | - | ||||||||||
iii | Rejects and Scraps | - | - | - | - | - | - | - | ||||||||||
1 | Gross Income | |||||||||||||||||
a | Sales (net of returns) | |||||||||||||||||
i | Domestic Sales | - | - | - | - | - | - | - | ||||||||||
ii | Export Sales | - | - | - | - | - | - | - | ||||||||||
T1 | Sub-total | [ a(i+ii) ] | - | - | - | - | - | - | - | |||||||||
iii | Less: Excise Duty | - | - | - | - | - | - | - | ||||||||||
T2 | Net Sales | [ T1-iii ] | - | - | - | - | - | - | - | |||||||||
iv | % rise or fall in sales turnover [compared to previous year] | {0.00%} | {0.00%} | {0.00%} | {0.00%} | {0.00%} | {0.00%} | {0.00%} | ||||||||||
b | Other Income | |||||||||||||||||
i | - | - | - | - | - | - | - | |||||||||||
ii | - | - | - | - | - | - | - | |||||||||||
iii | - | - | - | - | - | - | - | |||||||||||
iv | - | - | - | - | - | - | - | |||||||||||
v | - | - | - | - | - | - | - | |||||||||||
T3 | Total Other income | [ b(i to iv) ] | - | - | - | - | - | - | - | |||||||||
T4 | Total Gross Income | [ T2+T3 ] | - | - | - | - | - | - | - | |||||||||
2 | Cost of Production & Cost of Sales | |||||||||||||||||
a | Raw Materials [Including Stores and other | |||||||||||||||||
items used in the process of manufacture) | ||||||||||||||||||
i | Imported | - | - | - | - | - | - | - | ||||||||||
ii | Indegenous | - | - | - | - | - | - | - | ||||||||||
T5 | sub-total | [ a(i+ii) ] | - | - | - | - | - | - | - | |||||||||
b | Other Consumable Spares | |||||||||||||||||
i | Imported | - | - | - | - | - | - | - | ||||||||||
ii | Indegeneous | - | - | - | - | - | - | - | ||||||||||
T6 | sub-total | [ b(i+ii) ] | - | - | - | - | - | - | - | |||||||||
c | Direct Expenses | |||||||||||||||||
i | - | - | - | - | - | - | - | |||||||||||
ii | - | - | - | - | - | - | - | |||||||||||
iii | - | - | - | - | - | - | - | |||||||||||
iv | - | - | - | - | - | - | - | |||||||||||
v | - | - | - | - | - | - | - | |||||||||||
vi | - | - | - | - | - | - | - | |||||||||||
vii | - | - | - | - | - | - | - | |||||||||||
viii | - | - | - | - | - | - | - | |||||||||||
ix | - | - | - | - | - | - | - | |||||||||||
x | Depreciation | - | - | - | - | - | - | - | ||||||||||
T7 | Total Direct Expenses | [ c(i to x) ] | - | - | - | - | - | - | - | |||||||||
T8 | sub-total | [ T5+T6+T7 ] | - | - | - | - | - | - | - | |||||||||
d | Add : Opening stock of W.I.P. | - | - | - | - | - | - | - | ||||||||||
T9 | Sub-total | [ T8+2(d) ] | - | - | - | - | - | - | - | |||||||||
e | Less : Closing Stock W.I.P. | - | - | - | - | - | - | - | ||||||||||
T10 | Total Cost of Production | [ T9-2(e) ] | - | - | - | - | - | - | - | |||||||||
f | Add : Opening stock of Finished Goods | - | - | - | - | - | - | - | ||||||||||
T11 | sub-total | [ T10+2(f) ] | - | - | - | - | - | - | - | |||||||||
g | Less : Closing Stock of Finished Goods | - | - | - | - | - | - | - | ||||||||||
T12 | Total Cost of Sales | [ T11-2(g) ] | - | - | - | - | - | - | - | |||||||||
3 | General, Administrative & Selling Expenses | |||||||||||||||||
i | - | - | - | - | - | - | - | |||||||||||
ii | - | - | - | - | - | - | - | |||||||||||
iii | - | - | - | - | - | - | - | |||||||||||
iv | - | - | - | - | - | - | - | |||||||||||
v | - | - | - | - | - | - | - | |||||||||||
vi | - | - | - | - | - | - | - | |||||||||||
vii | - | - | - | - | - | - | - | |||||||||||
viii | - | - | - | - | - | - | - | |||||||||||
ix | - | - | - | - | - | - | - | |||||||||||
x | - | - | - | - | - | - | - | |||||||||||
T13 | Total General, Administrative & | |||||||||||||||||
Selling Expenses | [ 3(i to x) ] | - | - | - | - | - | - | - | ||||||||||
4 | Operating Profit before Interest | [ T4-T12-T13 ] | - | - | - | - | - | - | - | |||||||||
5 | Finance Charges | |||||||||||||||||
i | - | - | - | - | - | - | - | |||||||||||
ii | - | - | - | - | - | - | - | |||||||||||
iii | - | - | - | - | - | - | - | |||||||||||
iv | - | - | - | - | - | - | - | |||||||||||
v | - | - | - | - | - | - | - | |||||||||||
T14 | Total Finance Charges | [ 5(i to v) ] | - | - | - | - | - | - | - | |||||||||
6 | Operating Profit after Interest | [ 4-T14 ] | - | - | - | - | - | - | - | |||||||||
7 | Non-Operating Income | |||||||||||||||||
i | - | - | - | - | - | - | - | |||||||||||
ii | - | - | - | - | - | - | - | |||||||||||
iii | - | - | - | - | - | - | - | |||||||||||
T15 | Total Non-Operating Income | [ 7(i to iii) ] | - | - | - | - | - | - | - | |||||||||
8 | Non-Operating Expenses | |||||||||||||||||
i | - | - | - | - | - | - | - | |||||||||||
ii | - | - | - | - | - | - | - | |||||||||||
iii | - | - | - | - | - | - | - | |||||||||||
9 | T16 | Total Non-Operating Expenses | [ 8(i to iii) ] | - | - | - | - | - | - | - | ||||||||
T17 | Net Non-Operating Income (+) / | |||||||||||||||||
Expenses (-) | [ T15-T16 ] | - | - | - | - | - | - | - | ||||||||||
10 | Net Profit before Tax / (Loss) PBT | [ 6+/(-)T17 ] | - | - | - | - | - | - | - | |||||||||
11 | Provision for Taxes | - | - | - | - | - | - | - | ||||||||||
12 | Net Profit / Loss after Tax PAT | [ 10-11 ] | - | - | - | - | - | - | - | |||||||||
PAT to Net Sales % | [ 12/T2 ] % | {0.00%} | {0.00%} | {0.00%} | {0.00%} | {0.00%} | {0.00%} | {0.00%} | ||||||||||
13 | Equity Dividend & Dividend Tax | - | - | - | - | - | - | - | ||||||||||
Dividend Rate % | {0.00%} | {0.00%} | {0.00%} | {0.00%} | {0.00%} | {0.00%} | {0.00%} | |||||||||||
Dividend Distribution Tax % | {0.00%} | {0.00%} | {0.00%} | {0.00%} | {0.00%} | {0.00%} | {0.00%} | |||||||||||
14 | Retained Profit | [ 12-13 ] | - | - | - | - | - | - | - | |||||||||
15 | Retained Profit / PAT % | [ 14/12 ] % | {0.00%} | {0.00%} | {0.00%} | {0.00%} | {0.00%} | {0.00%} | {0.00%} | |||||||||
16 | Additional Data: | |||||||||||||||||
Break-up of Total Gross Income | ||||||||||||||||||
Domestic Sales: | ||||||||||||||||||
i | 1st Quarter | - | - | - | - | - | - | - | ||||||||||
ii | 2nd Quarter | - | - | - | - | - | - | - | ||||||||||
iii | 3rd Quarter | - | - | - | - | - | - | - | ||||||||||
iv | 4th Quarter | - | - | - | - | - | - | - | ||||||||||
T18 | sub-total | [i to iv] | - | - | - | - | - | - | - | |||||||||
T19 | Export Sales | - | - | - | - | - | - | - | ||||||||||
T20 | Total [T18+T19] to agree with T4] | - | - | - | - | - | - | - |
no reviews yet
Please Login to review.