CMA data from s CCP exam

CMA DATA FORMS

What reports are covered ?

It covers following statements:

1. Details of existing and proposed fund limit: In this report, details about your current financial condition, borrowed fund and proposed fund are covered.If the business is new, proposed data is required to be given.

2. Operating statement: You are required to show past 2 years and future 3 years ( Proposed) operating statements. There may be some changes as per loan needed and business nature.The profit and loss account should be presented here.

3. Analysis of balance sheet: Details about your balance sheets of past years are required to show. It is also required to show proposed balance sheet data to show a picture of your future business plan. Details about current assets, fixed assets, current and long-term liabilities are presented in this statement.

4. Comparative statements of current assets and liabilities: This statement describes the viability of your working capital cycle.

5. Calculation of MPBF: Calculation of maximum permissible bank finance. This statement shows the capacity of the borrower to borrow money. It depends on two methods which are dependent on working capital.

6. Fund flow statements: This statement shows the fund flow statements for current and future years. It shows the fund utilisation and sources of funds.The statement is important because it highlights the utilization of fund. To make sure the bank that you are using the fund for the purpose you have borrowed.

7. Ratio analysis: This is also one of the long and important statements of CMA data.It covers key ratios. Some ratios are the current ratio, MPBF, Net worth ratio, quick ratios, turnover ratios, debt-equity ratios, DSCR etc.

 No same report for all businesses:

There are different business types and according to their business nature and size, CMA report is prepared. It is not similar for all businesses. Similarly, CMA report is prepared as per nature of the borrowed funds. The data is different for the working capital loan or for CC or for CMA data for the bank guarantee.

 What is the benefit of submitting CMA report?

By submitting CMA data report with right ratios and proper presentation of usage of funds, your chances of getting the loan has been increased. Provided you follow other procedures and requirements of banks.

 CMA ( Credit Monitoring arrangement) data preparation does not mean only filling data but it requires deep knowledge of finance

Certified credit professionals numericals

Assets
Net Fixed Assets - 800
Inventories - 300
Preliminary Expenses - 100
Receivables - 150
Investment In Govt. Secu - 50
Total Assets - 1400
Liabilities
Equity Capital - 200
Preference Capital - 100
Term Loan - 600
Bank C/C - 400
Sundry Creditors - 100
Total Liabilities – 1400
1. Debt Equity Ratio = ?
a. 1:1
b. 1:2
c. 2:1
d. 2:3
Ans - c
Explanation :
600 / (200+100) = 2 : 1
2. Tangible Net Worth = ?
a. 100
b. 200
c. 300
d. 400
Ans - b
Explanation :
Only equity Capital i.e. = 200
3. Total Liabilities to Tangible Net Worth Ratio = ?
a. 7:2
b. 11:2
c. 13:2
d. 15:2
Ans - b
Explanation :
Total Outside Liabilities / Total Tangible Net Worth : (600+400+100) / 200 = 11 : 2
4. Current Ratio = ?
a. 1:1
b. 1:2
c. 2:1
d. 3:1
Ans - a

Explanation :
(300 + 150 + 50 ) / (400 + 100 ) = 1 : 1

Q.2

Assets

Net Fixed Assets - 265

Cash - 1

Receivables - 125

Stocks - 128

Prepaid Expenses - 1

Intangible Assets - 30

Total - 550

Liabilities

Capital + Reserves - 355

P & L Credit Balance - 7

Loan From S F C - 100

Bank Overdraft - 38

Creditors - 26

Provision of Tax - 9

Proposed Dividend - 15

Total - 550

1. Current Ratio = ?

= (1+125 +128+1) / (38+26+9+15)

= 255/88

= 2.89 : 1

2. Quick Ratio = ?

(125+1)/88

= 1.43 : 11

3. Debt Equity Ratio = ?

= LTL / Tangible NW

= 100 / (362 – 30)

= 100 / 332

= 0.30 : 1

4. Proprietary Ratio = ?

= (T NW / Tangible Assets) x 100

= [(362 - 30 ) / (550 – 30)] x 100

= (332 / 520) x 100

= 64%

5. Net Working Capital = ?

= CA - CL

= 255 - 88

= 167

6. If Net Sales is Rs.15 Lac, then What would be the Stock Turnover Ratio in Times ?

= Net Sales / Average Inventories/Stock

= 1500 / 128

= 12 times approximately

7. What is the Debtors Velocity Ratio if the sales are Rs. 15 Lac?



= (Average Debtors / Net Sales) x 12

= (125 / 1500) x 12

= 1 month

8. What is the Creditors Velocity Ratio if Purchases are Rs.10.5 Lac?

= (Average Creditors / Purchases ) x 12

= (26 / 1050) x 12

= 0.3 months

.............................................



Q.3 Current Ratio of a firm is 1 : 1. What will be the Net Working Capital ?

a. 0

b. 1

c. 100

d. 200

Ans - a

Explanation :

It suggest that the Current Assets is equal to Current Liabilities hence the NWC would be

0

(since NWC = C.A - C.L)

.............................................

Q.4 Suppose Current Ratio is 4 : 1. NWC is Rs.30,000/-. What is the amount of Current

Assets ?

a. 10000

b. 30000

c. 40000

d. 50000

Ans - c

Explanation :

Let Current Liabilities = a

4a - 1a = 30,000

a = 10,000 i.e. Current Liabilities is Rs.10,000

Hence Current Assets would be

4a = 4 x 10,000 = Rs.40,000/-

.............................................

Q.5 The amount of Term Loan installment is Rs.10000/ per month, monthly average interest

on TL is Rs.5000/-. If the amount of Depreciation is Rs.30,000/- p.a. and PAT is

Rs.2,70,000/-. What would be the DSCR ?

a. 1

b. 1.5

c. 2

d. 2.5

Ans - C

Explanation :

DSCR = (PAT + Depr + Annual Intt.) / Annual Intt + Annual Installment

= (270000 + 30000 + 60000 ) / 60000 + 12000

= 360000 / 180000

= 2

.............................................

Q. 6     A Company has Net Worth of Rs.5 Lac, Term Liabilities of Rs.10 Lac. Fixed Assets worth

RS.16 Lac and Current Assets are Rs.25 Lac. There is no intangible Assets or other Non

Current Assets. Calculate its Net Working Capital.

a. 1 lac

b. 2 lac

c. - 1 lac





d. - 2 lac

Ans - c

Explanation :

Total Assets = 16 + 25 = Rs. 41 Lac

Total Liabilities = NW + LTL + CL = 5 + 10 + CL = 41 Lac

Current Liabilities = 41 – 15 = 26 Lac

Therefore Net Working Capital = CA – CL = 25 – 26 = (-) 1 Lac

.............................................

Q. 7  Merchandise costs - Rs. 250000, Gross Profit - Rs. 23000, Net Profit - Rs. 15000. Find

the amount of sales.

a. 227000

b. 235000

c. 265000

d. 273000

Ans - d

Explanation :

Amount of sales = Merchandise costs + Gross Profit

= 250000 + 23000

= 273000

.............................................

Q.8 Total Liabilities of a firm is Rs.100 Lac and Current Ratio is 1.5 : 1. If Fixed Assets and

Other Non Current Assets are to the tune of Rs. 70 Lac and Debt Equity Ratio being 3 :

1. What would be the Long Term Liabilities?

a. 40 Lacs

b. 60 Lacs

c. 80 Lacs

d. 100 Lacs

Ans - b

Explanation :

Total Assets = Total Liabilities = 100 Lac

Current Asset = Total Assets - Non Current Assets

= Rs. 100 L - Rs. 70 L

= Rs. 30 L

If the Current Ratio is 1.5 : 1

then Current Liabilities works out to be Rs. 20 Lac.

That means, Net Worth + Long Term Liabilities = Rs. 80 Lacs.

If the Debt Equity Ratio is 3 : 1,

then Debt works out to be Rs. 60 Lacs and equity Rs. 20 Lacs.

Therefore the Long Term Liabilities would be Rs.60 Lac.

.............................................

Q.9 Current Ratio = 1.2 : 1.

Total of balance sheet being Rs.22 Lac.

The amount of Fixed Assets + Non Current Assets is Rs. 10 Lac.

What would be the Current Liabilities?

a. 10 Lacs

b. b. 12 Lacs

c. 16 Lacs

d. 22 Lacs

Ans - a

Explanation :

Total Assets is Rs.22 Lac.

Fixed Assets + Non Current Assets is Rs. 10 Lac

Then Current Assets = 22 – 10 = Rs. 12 Lac.

Current Ratio = 1.2 : 1

Current Liabilities = Rs. 10 Lac

.............................................


Q.10 M/s Raj&co's balance sheet included the following accounts:

Cash: 10,000

Accounts Receivable: 5,000

Inventory: 5,000

Stock Investments: 1,000

Prepaid taxes: 500

Current Liabilities: 15,000

Find the Quick Ratio

Quick Ratio = Cash + Cash Equivalents + Short Term Investments + Marketable

Securities + Accounts Receivable) / Current Liabilities

= (10000+5000+1000) / 15000

= 16000 / 15000

= 1.07

.................................

Q.11 M/s Raj&co's balance sheet included the following accounts:

Inventory : 5,000

Prepaid taxes : 500

Total Current Assets : 21,500

Current Liabilities : 15,000

Find the Quick Ratio

Quick Ratio = (Current assets – Inventory - Advances - Prepayments Current Liabilities) /

Current Liabilities

= (21500 - 5000 - 500) / 15000

= 16000 / 15000

= 1.07

.................................



Q.12 XYZ Pvt Ltd has the following assets and liabilities as on 31st March 2015 (in Lakhs) :

Non Current Assets

Goodwill 75

Fixed Assets 75

Current Assets

Cash in hand 25

Cash in bank 50

Short term investments 45

Inventory 25

Receivable 100

Current Liabilities

Trade payables 100

Income tax payables 60

Non Current Liabilities

Bank Loan 50

Deferred tax payable 25

Find the Quick Ratio

Quick Ratio = (Cash in hand + Cash at Bank + Receivables + Marketable Securities) /



Current Liabilities

= (25+50+45+100) / 160

= 220 / 160

= 1.375

.................................





Q.14 GHI Ltd. manufacturers two products :Product G and Product H. The Variable cost of the manufacture is as

follows:

Product G Product H

Direct Material 3 10

Direct Labour (Rs.6 per hour) 18 12

Variable Overhead 4 4

Types of endorsements

Types of Endorsements:-



1) Blank Endorsements: section 16(1) it means endorser only signs his name with adding any words or directions this endorsement makes the instrument payable to bearer.

2) Endorsement in Full: - The endorser added the name of endorsee specifically.

3) Conditional Endorsement: Here the endorser puts some conditions for endorsee Here the binding of conditions is between endorsee and endorser only.

4) San recourse Endorsement: - Endorser added the words without recourse to me.

5) Facultative Endorsement: - Where an endorser waives the condition of notice of dishonour.

6) Endorsement on Bearer Cheque: - The endorsement on bearer cheque is meaning less as the cheque once bearer is always bear.



Crossing:-



General Crossing (Sec.123): Two parallel transverse lines on the face of instruments with or without word ‘Not negotiable’. It is direction to the paying bank that do not pay the cheque across the counter.

Special Crossing (Sec.124): In addition of general crossing the cheque bears the name of collecting bank either with or without the words ‘Not negotiable’.



Collection of cheques:-



Section 131: a banker who has in good faith and without negligence received payment for a customer of a cheque (not available for B/E and P/N) crossed generally or specially. The present section gives protection provided following conditions are fulfilled…



a) The bank must have acted in good faith and without negligence.

b) Bank has received the payment as an agent for collection.

c) Bank has collected the cheque in the duly introduced account of customer only.

d) The cheque collected must be crossed.



Payment of cheques:-



Liability of drawee (paying banker): It is obligation of the banker to honour the cheques of a customer provided there is sufficient balance and the cheque is otherwise in order. Section 31 of NI act provides that “The Drawee of a cheque:



a) Must have sufficient funds in the account.

b) Properly applicable to the payment of such cheque.

c) Must pay the cheque when duly required to do so.

d) In default of such payment, must compensate the drawer for any loss or damage.



Protection for paying banker in case of cheque:-



Regularity of endorsement Section 85(1): Paying banker’s liability is to ensure the regularity of the endorsement and is not concerned with genuineness of endorsement. The genuineness of endorsement is the liability of collecting banker. Therefore, protection is available to the paying banker in case of forged endorsements.



Payment in due course (Section-10):-



a) In accordance with the apparent tenor of the instrument.

b) In good faith and without negligence.

c) To the person in possession of the instrument.

d) Under the circumstances which do not afford a reasonable ground for believing that he is not entitled to receive the payment of the amount mentioned therein.



When bank should not pay:-



a) The death of the drawer in case of individual’s account terminates the contractual relationship.

b) Insane customers: in case of insanity.

c) Insolvent drawers: The bank should stop the operation of such account as if drawer adjudged insolvent and balance in the account vested with official receiver/assignee.

d) Countermanded by drawer: on receipt of valid stop payment instruction by the drawer.

e) Others: when a cheque is post dated, with insufficient balance in the account, cheque is of doubtful legality, or cheque is irregular, ambiguous, materially altered or stale etc.



Dishonour of cheques (Sec. 138-147):-



The payee or holder in due course should give notice to drawer within 30 days of return of cheque with the reason “Insufficient balance” and demanding payment within 15 days of his receiving information of dishonour. Drawee can make payment within 15 days of the receipt of notice and only if he fails to do so prosecution could take place. The complaint is to be made with in one month of the cause of action arising that is expiry of the notice period.



Punishments:



a) Summary proceedings: fine up to Rs. 5000/- and imprisonment up to one year or both.

b) Regular proceedings: fine up to the double the amount of cheque or imprisonment up to 2 years or both.