As you know, the CMA format was evolved or got evolved for the purpose of Working Capital Assessment. The idea is that the unit's figures for a year/ on a date in Company Act format (designed for the shareholders/tax authorities/ statutory requirements etc.) is to be transmuted to a format conducive to Bank Lending. The CMA is filled up and signed by the applicant's representative and is to be checked by us. That's convenient to the lazy DO but initially it's best to try to fill up a big and complicated report into the CMA form- may be Reliance This or That Ltd. or Infosys, just for the fun. The totals, that is size, of the BS will be different as in the earlier form, current liabilities are netted out of current assets. Classification will differ, for instance instalments of term loan payable next year are to be shown as CL in CMA, while in the statutory format, outside debt is either classified as secured or unsecured, noting to do with tenure. To a small extent, the classification will be subjective also. The three step assessment will start hereafter in the Assessment format.
Nowadays the computer based package will generate ratios automatically but that implies that you are going by the subjective, or basically motivated classification of the company- they'll try to classify in order to inflate the current asset or understate the CL, or inflate the NWC. Best is to reclassify the CMA into a format that is used as a standard format and in our bank is often called the A form. The following two tables represent a company's P/L as per CMA and as per form A. The classification is the same as the CMA has also been filled in by the banker.
Essentially, what has been done is that the topline has been converted from Sales to Production. Ratio analysis is to be done based upon Production based figures, as the total year's expenses on various heads including profit (operating) will add up to production, so that if you want to find RMC %, the '100' is the Production and not Sales. This is because on the one hand, some goods produced this year may be left unsold and figure in BS as closing stocks, likely to be sold next year, i.e. will form not form part of this year's sales, whereas the expenses would be incurred this year. It could be the other way round also, goods produced last year, put in BS and sold this year.
In other words, given sales figure for say 2012-13, to arrive at production figures, one has to find out whether some goods produced but unsold in 2011-12 have been sold in 2012-13, in which case the production of 2012-13 will be less to 'that extent' than the Sales of 2012-13. It could be the other way round also. That is, some goods produced in 2012-13 may be left unsold, and the Sales will be less to 'that extent' than the Production.
The figure 'that extent' is called 'Net Inventory' and is arrived at by deducting the red figures from the green ones. In the first case the NI will be negative , and in the second case, positive. It's represented here in yellow.
|4 YEAR CONSEQ.|
|Total Gross Sales||112.15||184.97||281.50||450.40|
|Less : Excise Duty|
|Net Sales (1-2)||112.15||184.97||281.50||450.40|
|Total net Sales||112.15||184.97||281.50||450.40|
|Growth in sales||65%||52%||60%|
|Cost of Sales|
|a. Raw Material (Imported )||38.50||63.53||100.24||161.10|
|b. Raw material (Indigenous)||15.61||25.02||40.10||65.51|
|c. Stores & Spares (Imported)||0.60||1.20||1.56||2.00|
|d. Stores & Spares (Indigenous)||0.40||0.50||0.70||0.90|
|Power & Fuel||0.50||0.50||0.60||0.60|
|Repairs and maintenance|
|Other Mfg. Expenses|
|Add: Opening Stock in Process||0.00||0.00||0.00||0.00|
|Deduct : Closing Stock in Process|
|Cost of Production||74.24||120.28||183.68||295.66|
|Add: Opening Stock of Finished Goods||0.00||12.30||18.42||23.60|
|Deduct : Closing Stock OF Finished Goods||12.30||18.42||23.60||36.80|
|Sub Total ( Total Cost of Sales)||61.94||114.16||178.50||282.46|
|Gross Profit/ Sales||44.77%||38.28%||36.59%||37.29%|
|Operating Profit before interest||23.13||36.10||50.20||80.16|
|a. Interest on CC.||0.00||0.00||0.00||0.00|
|b.Interest on TL||0.00||0.00||0.00||0.00|
|Operating Profit after Interest||23.13||36.10||50.20||80.16|
|Other non operating Incomes|
|b. Other Income|
|Deduct other non operating expenses|
|b. Other Expenses||0.50||0.50||0.54||0.90|
|c.Intangibles written off -1|
|Net of other non operating Income/Expenses||(6.50)||(7.10)||(7.74)||(8.70)|
|Profit before Tax /Loss (PBT)||16.63||29.00||42.46||71.46|
|Provision for Taxes||5.49||9.57||14.01||23.58|
|Net Profit/Loss (PAT)||11.14||19.43||28.45||47.88|
|Dividend paid + IT on Dividend||5.00||16.14|
|26.a Transferred to Reserve||11.14||14.43||12.31||47.88|
CONVERTED TO PRODUCTION TOPLINE FOR RATIO ANALYSIS
|YEAR 1||YEAR 2||YEAR 3||YEAR 4|
|Raw material consumed||55.61||44.68||90.75||47.49||143.20||49.95||230.11||49.64|
|Net profit from operations||16.63||13.36||29.00||15.18||42.46||14.81||71.46||15.41|
|Other non operational expenses||0.00||0.00||0.00||0.00|
|Net profit before tax (11+12-13)||16.63||29.00||42.46||71.46|
|Net profit after tax||11.14||19.43||28.45||47.88|
|Carried to BS||11.14||19.43||28.45||47.88|
Net inventory= ( closing FG+closing SIP ) less (opening FG+opening SIP )
Hereafter will be discussed why a ratio may have changed, whether it's for the good or worse, whether we can deduce anything from the changes, what needs to be done, or what other information is to be sought to protect our interest. For example when the RMC/Production ratio suddenly drops by say 20/30 %, it's likely that the unit is not getting its own orders and is doing job-work. The factors may be internal and external and you then need to personally check the stock statement against the unit's books, and you'll find that the goods never figured in the books, as they belonged to another company's books. Your loan is thus unsecured and irregular and you'd better do something.
We leave ratio trend analysis to the next post.
Please try to formulate your responses to the following observations of the Statutory Auditor- it may happen to you this year:
(i) The stock statement of ABC Ltd. as on 31.03.2012 shows a level of stocks that is different from that in the Audited Balance Sheet as on 31.03.2012. So, the account holder is indulging in manipulation...
(ii) If you deduct unpaid creditors from the stocks, the account will be short of DP and will be unsecured to an extent, maybe fully....
(iii) Account was technically irregular (outstanding exceeds DP) in otherwise good unit. Basically due to delay in granting enhancement. 90 day delinquency on 31.03.2013. However, before date of statutory audit, the the account is regularised by normal and healthy credits. Auditor asks you to classify it as NPA.