Sunday, February 24, 2013

CMA- Part 2: Arithmetics

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.
                                        


Operating Statement                                     
4 YEAR CONSEQ.                                       



Sales
Total Gross Sales112.15184.97281.50450.40
Less : Excise Duty
Net Sales (1-2)112.15184.97281.50450.40
Jobwork receipts
Total net Sales112.15184.97281.50450.40
Growth in sales65%52%60%
Cost of Sales
a. Raw Material (Imported )38.5063.53100.24161.10
b. Raw material (Indigenous)15.6125.0240.1065.51
c. Stores & Spares (Imported)0.601.201.562.00
d. Stores & Spares (Indigenous)0.400.500.700.90
Power & Fuel0.500.500.600.60
Direct Labour15.6325.7835.2359.55
Repairs and maintenance
Other Mfg. Expenses
Depreciation 3.003.755.256.00
Sub Total74.24120.28183.68295.66
Add: Opening Stock in Process0.000.000.000.00
Sub Total74.24120.28183.68295.66
Deduct : Closing Stock in Process
Cost of Production 74.24120.28183.68295.66
Add: Opening Stock of Finished Goods0.0012.3018.4223.60
Sub Total74.24132.58202.10319.26
Deduct : Closing Stock OF Finished Goods12.3018.4223.6036.80
Sub Total ( Total Cost of Sales)61.94114.16178.50282.46
Gross profit50.2170.81103.00167.94
Gross Profit/ Sales44.77%38.28%36.59%37.29%
Selling Expenses8.226.009.0217.12
Administrative Expenses18.8628.7143.7870.66
Sub Total 89.02148.87231.30370.24
Operating Profit before interest 23.1336.1050.2080.16
a. Interest on CC.0.000.000.000.00
b.Interest on TL 0.000.000.000.00
c.Other interests 0.000.000.000.00
Total Interest0.000.000.000.00
Operating Profit after Interest23.1336.1050.2080.16
Other non operating Incomes
  a.Interest/Dividend/Royalties etc..
  b. Other Income
Sub Total0.000.000.000.00
Deduct other non operating expenses
a.Interest/Dividend/Royalties etc..6.006.607.207.80
b. Other Expenses0.500.500.540.90
c.Intangibles written off  -1
Sub Total6.507.107.748.70
Net of other non operating Income/Expenses(6.50)(7.10)(7.74)(8.70)
Profit before Tax /Loss (PBT)16.6329.0042.4671.46
Provision for Taxes5.499.5714.0123.58
Net Profit/Loss (PAT)11.1419.4328.4547.88
Cash Accruals14.1423.1833.7053.88
Dividend paid + IT on Dividend5.0016.14
Retained Profit11.1414.4312.3147.88
26.a Transferred to Reserve11.1414.4312.3147.88



CONVERTED TO PRODUCTION TOPLINE FOR RATIO ANALYSIS


YEAR 1YEAR 2YEAR 3YEAR 4
AbsolutePercentAbsolutePercentAbsolutePercentAbsolutePercent
Net Sales112.15184.97281.50450.40
Net Inventory12.306.125.1813.20
PRODUCTION 124.45100191.09100286.68100463.60100
Raw material consumed55.6144.6890.7547.49143.2049.95230.1149.64
Direct Expenses15.6312.5625.7813.4935.2312.2959.5512.85
Admnistrative Expenses18.8615.1528.7115.0243.7815.2770.6615.24
Selling Expenses8.226.616.003.149.023.1517.123.69
Interest6.004.826.603.457.202.517.801.68
Bank charges0.500.400.500.260.540.190.900.19
Depreciation3.002.413.751.965.251.836.001.29
Net profit from operations16.6313.3629.0015.1842.4614.8171.4615.41
Other income0.000.000.000.00
Other non operational expenses0.000.000.000.00
Net profit before tax (11+12-13)16.6329.0042.4671.46
Tax5.499.5714.0123.58
Net profit after tax11.1419.4328.4547.88
Dividend
Carried to BS11.1419.4328.4547.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. 

EXERCISE:

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. 

Monday, February 18, 2013

CMA -Part 1


Like much else, Bank Credit was also rationed in our economy for a long time. The RBI had introduced the CAS or Credit Authorisation Scheme in 1965 under which Banks were required to seek RBI approval for release of working capital limits of Rs. 1.00 crore and above . In fact we were required to get the limit sanctioned by the Competent Authority, viz the Board, and then forward a set of papers to RBI for the said permission.

Much of the credit dispensation set up in India and even branches of Indian banks abroad owes to the Tandon Committee and the Chore Committee appointed by RBI to go into the Working Capital Lending system of the banking sector.(We are not talking about rotation methods like Nayak Committee approach for small units.)In the past, Banks were supposed to assist units for working capital requirements, to the exclusion of term loans, as their liability portfolio was basically short term and demanding of liquidity. If you recall, the word ‘bank’ is the equivalent of ‘bench’ where merchants in middle age Europe used to wait before the ‘deposit shops’ where they would deposit their collections for safe-keeping, and the next step in evolution of banking was the practice of lending by these safe keepers, consequent upon the observation that some money would always be available with them for lending, for under normal circumstances, all the merchants were not expected to run for their money to the bank. Thus the banks could earn and pay interest to the depositors instead of charging for safe-keeping. However, the banks needed to ensure safety and liquidity for their clientele’s primary need was this. The safety of a term loan depends on the success of the project, that is whether or not it generates cash surpluses and when. However, a working capital loan simply intervenes in or bridges the working cycle of the business, money comes and goes regardless of profit or loss question, and as long as the unit is working to maybe 50-60% capacity, and a reasonable degree of long term funds are involved in the working cycle, any day the flow could be arrested by the banker, and their limits got vacated, at least theoretically the possibilities are there. Thus the safety of funds of a commercial bank is of a higher order. However today the funds requirements are basically for investment purposes, esp infrastructure and moreover the working capital requirements show a declining trend with companies becoming ‘lean and mean’(less of inventory and receivables). To that extent, the banks’ term loans are today in excess of working capital loans and correspondingly the NPAs and risks are going up and repeated re-capitalisation is called for.

RBI introduced Credit Monitoring Arrangement (CMA) after discontinuing Credit Authorisation Scheme (CAS) in 1988. Under CMA system, RBI prescribed two sets of formats viz. (i) Assessment of working capital requirements and (ii) Monitoring through Quarterly Information System (QIS)-later renamed FFR, to cover borrowers i.e. ‘General Category’ and ‘Traders & Merchant Exporters’. The first set of formats refers to those required for assessing need, and the second is required for validating the assumptions of the first set, and for checking end use of funds.

It is to be noted that all these systems and forms addressed the need of the hour of the Indian economy at that point of time and are not immutable like the laws of Physics. The Indian economy had been severely hit by the oil shock of 1973 and as oil prices reached $ 100 per barrel, the deficit finance model the Govt was following for industrial development- increase spending, print notes- growth comes at the cost of inflation. The only way was to restrict the country’s ambitions, ration credit, and settle for lower growth rate. In such a scenario question of quantum of loan to be given to a unit was important, but so was end-use of funds- for instance if a family has only Rs. 100 today, it would rather spend on food than movies. Today the system is flush with funds, but since the lending system laid down by Tandon (he was a very capable man-the first Indian head of Hindustan Levers from 1961 to 1968, later PNB Chairman) worked in a certain era, it became a holy cow for all times to come. Today the ability to pay should receive more attention than putting it to the stipulated use. For example, if the unit borrows some funds from the bank for manufacturing ornaments, and increases raw material inventory from 2 months mentioned in the CMA, to 6 months in anticipation of price rise, the credit expert in an Indian bank will cry ‘murder’. What we are saying is that this act could have objectionable in the rationing environment, but today the situation is different and all we should concentrate is the repayment capacity. Unfortunately we have not infused fresh blood in our credit manpower and the expert who learnt 100/75= 1.33 fears losing his importance. He will ask silly questions at the consortium meetings, and the rookie analyst will be put on a false trail. As everybody knows, in the developed world, you get term funds for short and medium tenures at quoted rates with simple covenants, and time-to-time, the facilities are renewed. But RBI looks at itself as Lady Justice with eyes blind-folded, and assumes that the Banks will never address the borrower’s periodically rising needs if it doesn’t prescribe annual renewal of working capital limits. In the process the borrower is the party which suffers, because in absence of paper renewal the account becomes an NPA and the bargaining power of the bank vis-a-vis the borrower further increases.

The Credit Monitoring Arrangement (CMA) under which banks were required to report to RBI the details of credit facilities sanctioned to large borrowers from the banking system for post sanction scrutiny was also discontinued in December 1997 and in lieu thereof a new reporting system for statistical use was put in its place. In all spheres of banking where the Central Bank had earlier much to prescribe and control, be it Forex or Credit, the trend has been towards deregulation and leaving the thing the wisdom of commercial banks. We hope the trend continues and we move away from the cash credit system. Anyway…

Some clarifications on assessment system:

·      Is it like covenants ?: First of all, as the CMA is supposed to be signed by the party or its authorized representative, the financials therein are in the nature of covenants between the bank and borrower, and should be taken in spirit, but not one can hold the other party to the figures if the variations are not inspired, or are explainable on grounds of business.

·         Next year projections: what is ‘next year’ will be determined by how many months of current year have passed:  in February 2013, next year will be 2013-14, but if assessment is being done in November 2013, the projections required will be those of 2013-14 and 2014-15 and maybe two limits as per date sanctioned.

·         Level of current assets: No norms prescribed now, but better check up actual levels of unit in recent past, other units in same situation, reason for change in assumptions which would lead to request for change in level, if any to be ascertained.

·         Remark that ‘the projected sales are increasing only by (say) 20%, then why 100% rise in facilities demanded: there could be some merit in the query, but the comparison has to be of corresponding figures that is, the next year projections of sales and levels of current assets ABF is to be compared to current asset levels and ABF assumed at the time of last assessment, and not those of last audited results.

·         There is no increase shown in projected sales. An enhancement is requested for substitution of current liability, mainly sundry creditors. Is it permissible?
Ans: it is ok if the reasons are convincing and substitution    will do good to the business.
·   
        What is NWC? : Please remember you should not say :it’s the excess of current assets over current liability, or (CA-CL),though that’s the way we compute it. Net Working Capital is the long term fund deployed in current assets. This is how to understand it. In the figure 1, NWC= (purple)- (pink)is arithmetically correct, but you’ll understand the concept  better if you say NWC= (yellow+brown) – (green+blue).


LIABILITIES                                                                                                                                  ASSETS
BANK WORKING CAP LOANS
CURRENT ASSETS 




]NWC
OTHER CURRENT LIAB
TERM LOAN
FIXED ASSETS
CAPITAL FUNDS
MISC ASSETS

FIGURE 1: TYPICAL MFG CONCERN BALANCE SHEET
·        
  Slip-back of current ratio, whether permissible: again, if due to higher than projected profit or any other reason, there is an unexpected rise in current ratio, it is likely that NWC will have risen beyond projected level. In case higher capacity utilization or expansion or modernization is envisaged, the dilution to level earlier settled may be permitted. Slip-back can be considered otherwise also, looking into overall circumstances, for example it may be acceded to in case the promoter needs to pay for a personal house and will charge the property to us.

·     Classification of Current Assets and Liabilities: We saw that in the system of assessment first one estimates next year sales, then level of current assets required for the achieving the same, then who will arrange for the funding. The basis for the above estimated figures of all kinds will be largely objective, but the classification of balance sheet items into current and non-current was considered a subjective matter by the RBI and the CAS/CMA system would provide very strict guidelines for the classification of current assets and current liabilities. The system is now dispensed with, though the accountancy principles are to be followed. For example, on how to classify relatively a very small item, you may classify it ‘anywhere’ on principle of ‘materiality’. The test of any item being classified as current or non-current is whether it is a part of the working cycle or not, not the period of retention, as explained earlier (case of shipyard). If the analyst feels, even debts over 180 days can be considered current if they are considered recoverable in the BS period remaining. Sufficient flexibility is provided to the analyst.
I
    In the next post we discuss the figures part of the CMA formats