CMA format for Bank Loans in Excel format free

1. Gross Sales i) Domestic Sales ii) Export Sales TOTAL SALES 2. Less Excise duty – 3. NET SALES – 4. % age rise or fall in net sales as compared to previous year 5. COST OF SALES i) Raw materials(including stores & other items used in the process of manufacture a. Imported b. Indigenous SUB – TOTAL ii) Other spares a. Imported b. Indigenous SUB – TOTAL iii) Power & fuel iv) Direct labour (factory wages & salaries) v) other mfg expenses vi) Depreciation SUB – TOTAL ADD: Opening stocks in process LESS: Closing stocks in process – COST OF PRODUCTION = = NAME OF THE COMPANY : = – – PARTICULARS – ADD: Opening stocks of F.Goods LESS: Closing stocks of F.Goods TOTAL COST OF SALES 6. Selling, general & administrative expences 7. SUB TOTAL (5+6) 8. OPERATING PROFIT before Interest 9. Interest 10. OPERATING PROFIT after Interest 11. i) Add other non operating income a. Exchange gain b. Other Misc. Income SUB TOTAL (income) ii) Deduct other non- operating expences a. MTM Loss/FCCB Reinstatement b. Prov. For bad debt c. Others SUB TOTAL (expenses) Net of other non operating income/expenses 12. PROFIT BEFORE TAX/LOSS 13. Provision for taxes – 14. NET PROFIT/LOSS – 15. a. Equity dividend paid b. Dividend rate 16. Retained profit 17. Retained profit/Net Profit (%) =

ANALYSIS OF BALANCE SHEET = NAME OF THE COMPANY = – PARTICULARS – LIABILITIES =========== CURRENT LIABILITIES ——————- 
1. Short term borrowings from banks (inclg. BP/BD and the excess borrowings placed on repayment basis but exclude bills drawn under LCs) i) From applicant bank ii) From other banks iii) (of which BP & BD ) – SUB TOTAL (A) – 2. Short term borrowings from others /ICDs taken 3. Sundry creditors (trade) 4. Advances payments from customers, deposits from dealers 5. Provision for taxes 6. Dividend payable 7. Other statutory liabilities (due within one year) 8. Deposits/Instalments of term loans/DPGs/debentures etc (due within one year) 9. Other current liabilities & provisions(due within one year) specify major items a. Other liab. & provisions b. ;Advertisement c miscellaneous –

Dont get confusion, just download below attachment. and enjouy feature

CLICK HERE TO DOWNLOAD CMA FORMAT FOR BANK LOANS EXCEL FILE

Leave a Comment