jagomart
digital resources
picture1_Excel Sheet Download 7257 | Cma Format - Standar Format


 206x       Filetype XLS       File size 0.50 MB       Source: www.fixedincome.global


File: Excel Sheet Download 7257 | Cma Format - Standar Format
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 ...

icon picture XLS Filetype Excel XLS | Posted on 26 Jun 2022 | 3 years ago
Partial file snippet.
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












































Sheet 2: Form-I
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












































- - - -







Sheet 3: Form-II OpStmt
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]
- - - - - - -








The words contained in this file might help you see if this file matches what you are looking for:

...Sheet index cma write the name of applicant even if you in lowercase it will be automatically copied to all other sheets uppercase only egrave start here v contents about this format formi particulars limites amp information associate companies can filled cell e on left is written nowhere else file formii operating statement cells accessed formiii analysis balance liabilities data unlocked assets locked however they or contained cannot modified deleted formiv comparative current may contain either formula reference a hyperlink any which not required formv maximum permissible bank finance for working capital up manually formvi funds flow forms provide based formsi liabilites summary financial statements ratio calculations are automatic by different formulae links efforts have been taken make errorfree chance error ruled out changes come across errors problems while using these kindly inform me same cross check feedback appreciation criticism suggestions advice etc most welcome charts fo...

no reviews yet
Please Login to review.