SignUp
SignIn
SignIn
SignIn

Analysis of Balance Sheet / Financial Statements

Nov. 15, 2021, 11:15 a.m.

Prof Rajesh Mahajan, ex General Manager, Bank of Baroda

Analysis  of Balance Sheet / Financial Statements

In credit decisions, it is very important to know the financial health of the borrower. To determine the financial health, there is a set of financial statements i.e. Balance Sheet, P&L, Cash flow etc., required to be analysed to know whether borrower is financially sound ,moderate or weak. A brief description of these statements is as under:- 

A balance sheet is a financial statement that summarizes a firm's assets, liabilities and shareholders' equity at a specific point in time. It can be expressed as 

Capital + Liabilities = Assets

Profit & Loss Account is a summary of revenue earned and expenses incurred during a period of time normally a year, which ultimately results in profit or loss to the firm. In the case of a Non-Profit organization, instead of preparing P&L a/c, It prepares Income and expenditure a/c.

Borrowers for this purpose can broadly be divided into two parts i.e. corporate borrowers or Non- corporate borrowers. 

Corporate borrowers include Pvt. Limited companies, public limited companies, Limited liability Partnership, a Single Person liability company.

Non –Corporate borrowers include individuals, Proprietorship firms, Partnership firms, joint borrowers, HUF, Associations, Trusts, clubs etc. 

In case of corporate borrowers, preparation of financial statements is required to be prepared as per provisions of the company’s act 2013.

In case of non- corporate borrowers, there are no such regulations, however ,these borrowers follow the same type of pattern while preparing their financial statements.

Financial statements required to be prepared under company act 2013 include

  • Balance Sheet*, 
  • Profit and loss account/income and expenditure account *, 
  • Cash Flow statement, 
  • Statement of Changes in equity and 
  • any explanatory note annexed to the above.

 * Formats are provided as per schedule III of Company act -2013

Further, Accounting principle and standards required to be followed by corporates are as under:-

In India, we have two different framework for preparing financials statements:

  • Indian GAAP (IGAAP)
  • Indian Accounting Standards (Ind AS)
  • Ind As is applicable to all listed companies and companies having net worth more than Rs. 250 Cr. In the case of Banks ,it has been deferred.

Financial Statement  Analysis - Stakeholders' Perspective

Investors 

Return on their investment in the long run. 

What is dividend paying capacity ?

Capital Appreciation in long run

Employees

Health of the company 

How employees interest is protected

What are the various benefits and incentives available to the employees

Customers

Helps them to take strategic decisions whether to maintain a short term or long term relationship

Suppliers are interested in timely payment of their dues &

Buyers are interested in the credit policy of the firm.

Lenders

Timely  receipt of their dues whether they are funding them short term or long term.

 Lender’s Objective    -Interpretation of Balance Sheet

  • To ascertain the Long -Term solvency
  • Short Term Liquidity position
  • Long Term Debt Servicing Capacity
  • Earning Assets in total balance sheet
  • Whether long term assets are financed by long term sources & Short term assets are financed by short term sources and partly by long term sources
  • Earning Capacity of the firm

Analysis of Financial Statements

For the purpose of  financial analysis by credit analysts , Balance Sheet received from borrower is regrouped as under :- 

Liabilities

Assets

NET  WORTH/EQUITY/OWNED FUNDS

Share Capital/Partner’s Capital/Paid up Capital/ Owners Funds

Reserves ( General, Capital, Revaluation & Other Reserves) 

Credit Balance in P&L A/c

FIXED ASSETS : LAND & BUILDING, PLANT & MACHINERIES  

Original Value Less Depreciation

Net Value or Book Value or Written down value

LONG TERM LIABILITIES/BORROWED FUNDS  :  Term Loans (Banks &  Institutions)

Debentures/Bonds, Unsecured Loans, Fixed Deposits, Other Long Term Liabilities

NON CURRENT ASSETS

Investments in quoted shares & securities

Old stocks or old/disputed book debts

Long Term Security Deposits

Other Misc. assets which are not current or fixed in nature

CURRENT LIABILITIES

Bank Working  Capital Limits such as CC/OD/Bills/Export Credit

Sundry /Trade Creditors/Creditors/Bills Payable, Short duration loans or deposits

Expenses payable & provisions against various items

CURRENT ASSETS : Cash & Bank Balance, Marketable/quoted Govt. or other securities, Book Debts/Sundry Debtors, Bills Receivables, Stocks & inventory (RM,SIP,FG) Stores & Spares, Advance Payment of Taxes, Prepaid expenses, Loans and Advances recoverable within 12 months

INTANGIBLE ASSETS

Patent, Goodwill, Debit balance in P&L A/c, Preliminary or Preoperative expenses

 

After regrouping the balance sheet items try to ascertain the following :-

  • What is the capital structure of the business? Is it appropriate? Have the owners of the business put sufficient capital into the business?
  • What are the short term and long term liabilities of the business? Are they properly structured? Is it possible to relate each source of finance to a particular item?
  • What is the credit period provided by trade suppliers? Did the suppliers alter trade terms?
  • What are the taxation and other statutory  liabilities outstanding ?
  • What is the quantum of fixed assets and are they put to optimum use?
  • What is the level of stocking required and what are the stock management policies, in broader terms?
  • What is the level of trade debtors? 
  • Adjusting Inventory Valuations, if required.
  • Reassessing the Values of Balance Sheet Variables
  • Converting off balance sheet items into One-Sheet items
  • Dividends Payable
  • Intangible Assets
  • Unsubordinated shareholders Loan
  • Dues from/to related parties
  • Any auditor’s remark have implication on P/L or NW 

Profit & Loss A/c analysis 

  • Some Situations require recasting of P/L also
  • To give effect to the crystallization of a contingent liability.
  • To reverse capitalization of a certain expenditure
  • To provide for certain expenses or to make extra provisioning write down or write up certain asset / liability values, disclosed in the balance sheet.
  • To assess the impact of auditor’s remark on P/L

RBI Ground Rules for classification of B/s 

Investment made in shares & advances  

Non- Current Assets

Security deposits  and deposit of long tenure

Non- current assets

Slow moving / Obsolete items of inventory

Non Current assets ( except spare parts )

Bills discounted by banks

If shown contingent liability then to be added back to Balance sheet

Work in progress

If construction company or turnkey project than current assets

Contingent liabilities that may crystalize

Current liability

Deposits received from others

Term liability- if from dealers and payable after termination of agency

Otherwise current liabilities

Advance /progress payment received from customers

Current liabilities

Disputed statutory liabilities

Various from situation to situation 

Let us understand the above from a case Study 

Balance Sheet of ABC Pvt. Ltd.  As on 31.03.2015

Liabilities

Assets

Authorised Capital                      100000

(10000 equity shares of Rs.10/-  each)

 

Fixed assets (Gross)

32000

Paid up Capital 

(Subscribed and fully paid up )    

80000

Investments  (Quoted)                         3000

                         (Unquoted)                    4000

7000

Depreciation Reserve Fund             

10400

Deposits 

5000

Revaluation Reserve

5000

Stock

12000

Term loan from bank

10000

Receivables

16000

Long term loan from directors

5000

Royalty

3200

Cash credit

15000

Prepaid  expenses

1200

Bills purchased

6000

Loans and Advances 

(Receivable in cash or in kind)

9000

Bills Payable

40000

Cash in hand and at bank

74000

Sundry Creditors for expenses

6000

P & L (Accumulated loss)

22000

Provisions 

4000

   
 

181400

 

181400

 Additional Informations

  1. Term loan is repayable in 4 Quarterly installments of Rs.500 each.
  2. The company and directors have given an undertaking that no interest on long term loan from directors will be paid and the loan will not be paid till the dues to the bank are totally repaid. 
  3. Bills receivable consists of Inland receivables of Rs. 10000/- and Export receivables of Rs. Rs.6000/-.
  4. Prepaid expenses of Rs.1200 /- consists of Insurance premium of Rs.1000/- for the year 2015 – 16 and Rs. 200/- for the year 2016-17.
  5. Deposit of Rs.5000/- pertains to deposit kept with the Electricity Board.
  6. Cash in hand and at Bank consists of fixed Deposits of Rs.15000/- given as security for the term loan and cash credit availed from the bank.   

As a credit analyst , one is required to recast the above balance sheet along with additional information as mentioned above.

First step is to regroup the balance sheet items as per above format.

Liabilities

Assets

NET  WORTH/EQUITY/OWNED FUNDS

PAID UP CAPITAL                              Rs 80000

Loan From Directors                        Rs    5000

Less Accumulated Loss                   Rs   22000

                                                                 -----------

                                                                   63000

FIXED ASSETS : 

Gross Block                              Rs.32000

Less Deprecation                     Rs .10400

Less Revaluation Reserve        Rs   5000 

Net  Block                                  Rs.16600 ACHINERIES  

LONG TERM LIABILITIES/BORROWED FUNDS  :  

Bank Borrowings                                   Rs. 8000

                                                                       --------

                                                                        8000




NON CURRENT ASSETS


Investment ( Unquoted)             Rs. 4000

Prepaid Expenses (NCA)         Rs.   200

Fixed Deposits                           Rs.!5000 

Security Electricity Board           Rs  5000 

                                                             24200 

CURRENT LIABILITIES 

Term Loan Installments 

Payable in one year                           Rs.  2000

Cash Credit                                          Rs.  15000

Bills Purchased                                   Rs.   6000

Bills Payable                                       Rs  40000 

Sundry Creditors for Expenses       Rs    6000   

Provisions                                           Rs.   4000                      

                                                       ----------

                                                                    73000

CURRENT ASSETS


Stock                                        Rs.12000   

Receivable  Inland                 Rs.10000 

Receivable  Foreign               Rs.  6000

Cash in Hand & at Bank        Rs.59000

Prepaid Expenses CA           Rs.  1000  

Investment (quoted)             Rs. 3000

Loans & Advances                  Rs  9000

                                                   

                                                    100000

INTANGIBLE ASSETS


Royalty                                       Rs. 3200      

Total                                       !44000

                                  !44000

 If you examine the difference between the two balance sheets, it may be observed that

  1. Unsecured loans of Rs.5000/- are taken as part of net worth because the borrower has undertaken that it shall not repay the same during the currency of the bank’s loan and no interest shall be paid on such loans . (Pease note such item can be considered as quasi capital only if undertaking from borrower is obtained)
  2. Accumulated losses appearing in the balance sheet as part of Asset are to be deducted from the Net worth/capital, 
  3. Term loan instalments due in next year are required to be shown as current liabilities. You may observe from the additional information that the quarterly payment of the term loan of Rs. 500/- per quarter. Therefore, Rs. 2000/- to consider in Current Assets and remaining Rs. 8000/ - to be shown as Term Loan.
  4. From Gross Block amount of depreciation reserve and revaluation reserve to be deducted to arrive at the net block.
  5. Net worth is shown as Rs. 63000/- in redesigned balance sheet and 
  6. Tangible Net worth shall be Rs. 63000/-  minus Rs. 3200/-  = 59.800/-
  7.  Please note that the above redesigning balance sheet is to be used for assessing working capital and term loan requirement of the borrower within bank norms.

Comments (0)

Please login to post a comment