G.C. Pipara - Taxmann's Balance Sheet Decoded (2021)
G.C. Pipara - Taxmann's Balance Sheet Decoded (2021)
G.C. Pipara - Taxmann's Balance Sheet Decoded (2021)
Read
About the Author
His trainings to the officers of the bank on analysis of the financial statement, is
one of the most sought after training, for enhancement of credit skills. In the last
7 years, large number of such trainings spanning over 2 to 3 days, have been pro-
vided to various banks, including State Bank of India, Punjab National Bank, Bank
of Baroda, Punjab & Sind Bank etc. All such trainings have been very well received.
He also has experience of working with two International Organizations, in the
field of re-writing e-Learning Modules for them, which are used in India for the
purpose of Credit Certification Programme, as mandated by the Reserve Bank of
India. He has also been invited by the various foreign countries, to impart training
on “Analysis of Financial Statements” and to deliberate on issues relating to NPAs.
He has also written large number of manuals and materials to be used for the
purpose of training on credit.
Considering the importance of the financial statement, in the year 2016 “Center
for Correct and Accurate Balance Sheet Analysis (CABSA)” has been set up by him
for the purpose of research in the field of analysis of the financial statement. The
said center is registered with the Securities and Exchange Board of India under
Research Analysts Regulation, as “Research Analyst”.
Currently, he is a practicing Chartered Accountant, as well as Trainer and Research
Analyst.
The overwhelming response of his maiden book on “BALANCE SHEET DECODED
- Keys to Unlock Balance Sheet Secrets”, speaks about depth of the book on the
various chapters relating to analysis of financial statement. The said book was
published by TAXMANN’S in the month of July-2018 and considering the response
and the feedbacks received, the revised and updated edition of the very same title
is released, in less than a year, in 2019.
He is also the author of book-“Forensic Audit Decoded - Unlocking the Secrets of
Financial Accounting and Investigation”, published by Taxmann in September, 2020.
He can be reached on the following address:
G.C. PIPARA
Centre for Correct and Accurate
Balance Sheet Analysis (CABSA)
Pipara Corporate House,
Law Garden, Netaji Marg,
Ahmedabad - 380 006, Gujarat, India.
Ph. +079-40370370
Mobile: +91 98250 38930
Email: [email protected]
Twitter: @GYANPIPARA
Instagram: gyan_pipara
Preface
all changes made in the Companies Act and latest position as at end of
March 2021 has been considered in this book.
The 38 years of my practice as Chartered Accountant, research analyst
and fraud investigation has improved my skills for analysis of financial
statements. But it was Mr. Pratip Chaudhuri, former chairman of State
Bank of India, who invited me in 2012 to share my experience and
knowledge of analysing balance sheets with his senior officers. Since
then, I have not looked back and have imparted numerous trainings to
the various banks and organisations on credit and analysis of financial
statement. These trainings and interaction with the participants have also
helped in sharpening my knowledge. The overwhelming response of the
training and my commitment to spread the knowledge and experience of
analysis and reading the financial statements, as well as, improvement
in the quality of assets of the bank by reducing NPAs and frauds, has
prompted me to pen down this book for those who see accounting as both
a science and an art that keeps the heart of commerce beating without
any falter.
PAGE
About the Author I-5
Preface I-7
List of Abbreviations I-17
Methodology I-21
Introduction I-29
I-13
I-14 Contents
1. Introduction
The concept of the audit, what is contained in the audi-
tor’s report, importance of the auditor’s report, the legal
framework as applies to audit in India and newly introduced
report on internal financial controls over financial reporting,
has been explained.
As discussed, it is the opinion of the auditor on the finan-
cial statements, which is provided in the auditor’s report.
The “opinion” is the heart of the auditor’s report. What
opinion is provided on the financial statements by the au-
ditor is most relevant to be seen for the purpose of analysis
of auditor’s report and so as to financial statements.
In this part, how to read and decode such opinion, what is
the meaning of such opinion, when such opinion is modified
or qualified is explained?
What is the impact of such opinion provided by the auditor
on the financial statements is also equally relevant, as the
financial statement accompanied to the auditor’s report is
subject to such opinion and therefore, for decoding the bal-
ance sheet, the secrets of auditor’s report needs to be known.
2. Type of opinion
Since it is his opinion, which is expressed by the auditor in
the auditor’s report, therefore, based on the nature of such
opinion, the auditor’s report can be classified as:
291
CHAPTER 24
292 Analysis of Opinion
Auditor’s Report
Disclaimer Since the auditor has not expressed his opinion, such financial state-
report ments are required to be outright rejected and fresh opinion should
be obtained after correcting the mistakes.
5. Case Analysis-42
Explaining how to read and analyse the opinion of the auditor
5.1 This case analysis pertains to a leading energy company, listed on NSE and
BSE. Though this pertains to FY 2011, this is being selected as case analysis
considering the importance of the issue referred to in the auditor’s report
(qualified opinion) the amount involved, and for correlating the note with the
actual fact of subsequent years.
The purpose of this case analysis is manifold:
(a) to explain the importance of such qualified opinion,
(b) how to analyse such opinion,
(c) for the purpose of analysis, what treatment is to be given to such opinion;
and
(d) how to read between the lines of the report
5.2 The relevant portion relating to the qualified opinion of this case analysis
for FY 2011, included in auditor’s report is as per Box 104.
BOX 104
vi. Without qualifying our opinion, we draw attention to note 4(c), Schedule P in the
financial statements regarding non-provision of proportionate premium on re-
demption of US$ 479.04 million (` 2,136.27 crores as at March 31, 2011), foreign
currency convertible bonds amounting to ` 579.21 crores which has been consi-
dered by the company as a contingent liability. Since the ultimate outcome of the
matter cannot be presently ascertained, no provision for the above liability that
may result in future has been made in the accompanying financial statements.
Analysis
u While giving the qualified opinion, the auditor has drawn attention to
note 4(c) of Schedule P, relating to the issue about not making provision
of proportionate premium amounting to ` 579 crore as on March 31,
2011, on the FCCB, which has been considered as a contingent liability.
u For the purpose of analysis of the opinion, the note which has been
referred in the auditor’s report requires to be read in its entirety.
The said note being note 4(c) of Schedule P, as referred by the auditors in the
Auditor’s Report is shown in Box 105.
CHAPTER 24
Analysis of Opinion 295
BOX 105
Schedule-P
Note 4(c) - Foreign Currency Convertible Bonds
(a) Initial terms of issue
On June 11, 2007 the Company made an issue of zero coupon convertible bonds
aggregating USD 300 million (` 1,223.70 crore) [Phase I bonds]. Further, on Octo-
ber 10, 2007, the Company made an additional issue of zero coupon convertible
bonds aggregating USD 200 million (` 786.20 crore) [Phase II bonds] and on July
24, 2009, the company made an additional issue of zero coupon convertible bonds
aggregating USD 93.87 million (` 452.64 crore) at an issue price of 104.30% of the
principal amount of USD 90.00 million.
The key terms of these bonds at the time of issue were as follows:
Particulars Phase I Phase II Phase III
Issue size (USD) 300 million 200 million 90 million
Face value per bond (in USD) 1,000 1,000 1,000
No. of equity shares per bond 113.50 107.30 533.2762
Initial conversion price per 359.68 371.55 90.38
share (` )
Fixed exchange rate (` /USD) 40.83 39.87 48.1975
Redemption amount as a % of 145.23 144.88 134.198
principal amount (%)
Maturity date June 12, 2012 October 11, 2012 July 18, 2014
(b) Restructuring of Phase I and Phase II bonds
i. During the year 2009-10, the Company restructured Phase I and II Zero Cou-
pon Convertible Bonds with an approval of the Reserve Bank of India (‘RBI’)
wherein the bondholders were offered the following options as part of the
restructuring;
u Buyback of bonds @ 54.55% of the face value of US $ 1000 per bond.
u Issue of new bonds (‘Phase I New Bonds’ in case of Phase I Bonds
and ‘Phase II New Bonds’ in case of Phase II Bonds) in place of old
bonds at a fixed rate of 3:5 (60 cents to dollar) bearing a coupon of
7.5 per cent per annum, payable semi-annually. Unless previously
deemed, converted or purchased and cancelled, the Company will
redeem each Phase I New Bond at 150.24 per cent of its principal
amount and each Phase II New Bond at 157.72 per cent of its prin-
cipal amount on the relevant Maturity Date. The conversion price
is set of ` 76.68 per share. These bonds do not have any financial
covenants and are of the same maturity as the old bonds
(Box Contd.)
CHAPTER 24
296 Analysis of Opinion
Therefore, in case analysis 43, the financials of the very said company, for next
FY 2012 are analysed.
Case Analysis-43
In Box 106, the auditor’s report for FY 2012, on the said issue is given.
BOX 106
Auditor’s Report as at March 31st, 2012
Without qualifying our opinion we draw attention to Note 4 of the accompanying financial
statements regarding the existence of certain liabilities on account of foreign currency
convertible bonds (‘FCCB’) which are due for redemption during June 2012 and October
2012 having an aggregate redemption value of USD 568.96 million (` 2,894.58 crore). The
Company is in the process of tying up funds for redemption of these FCCB Liabilities and
consequently, there exists a material uncertainty that may cast significant doubt about
the Company’s ability to continue as a going concern, which is dependent on generating
the required funds before the redemption date. Management’s plans for raising funds for
such redemption have been more fully discussed in Note 4 to the accompanying financial
statements, in view of which the accompanying financial statements have been prepared
under the going concern assumption, and consequently, no adjustments have been made
to the carrying values or classification of balance sheet accounts.
Analysis of above observation in auditor’s report
From the above observation of the auditors in the auditor’s report of the
subsequent year March 31, 2012, it is interesting to note that:
(a) now auditors are admitting about liability relating to FCCB bonds which
are due for redemption;
(b) it is also clarified by the auditors that, the company is in the process of
tying up for funds for the redemption of the bonds liability; and
(c) the auditor has also expressed doubt about the company’s ability to
continue as a going concern.
Conclusion
5.4 It is important to note that in FY 2011, the auditor at the outset has not
qualified the opinion relating to interest, but started the note “without qualifying
our opinion”, whereas, it is a qualified opinion. It has become very clear that by
not providing the proportionate premium in the profit & loss account, sufficient
funds have not been reserved for the redemption of the bonds. Profits of the
company have been inflated and the proportionate premium has wrongly been
considered by the company as a contingent liability, which is in fact a provision.
CHAPTER 24
300 Analysis of Opinion
5.5 In order to conclude the issue logically, the financials of the said company
for the years ending March 31, 2013 and March 31, 2014, were also looked into.
Case Analysis-44
The auditor in the auditor’s report in FY 2013 has observed as per Box 107.
BOX 107
Auditor’s Report as at March 31st, 2013
“Emphasis of Matter
5. We draw attention to Note 5 of the accompanying financial statements in respect
of material uncertainty about the Company’s ability to continue as a going concern
which is in part dependent on the successful outcome of the discussions with the
FCCB holders. Our opinion is not qualified in respect of this matter.”
Auditor’s Report as at March 31st, 2014
“Emphasis of Matter
5. We draw attention to Note 5 of the accompanying financial statements in respect
of material uncertainty about the Company’s ability to continue as a going concern
which is in part dependent on the successful outcome of the discussions with the
FCCB holders and Company’s ability to generate sufficient funds to support its
operations. Our opinion is not qualified in respect of this matter.”
u Thus, on the basis of analysis it is clear that in earlier years the company
had defaulted in not making provision in the financials, for the propor-
tionate premium on the bonds and same was wrongly considered as a
contingent liability, resulting into higher profit.
u The auditor has also erred in not issuing a modified opinion and was
wrong in considering the said FCCB bond interest, as contingent liability.
u The auditor should have clearly stated that the company has not pro-
vided the interest and as a result the profit is overstated to the extent
of such interest.
BOX 108
BASIS OF QUALIFIED OPINION
Reference is invited to Note 49 to the consolidated financial statements according to
which an amount of ` 7,718,890,401 (Previous year ` 9,248,788,996) is outstanding
which is comprised of advances towards purchase of land, projects pending commence-
ment, advances paid to joint ventures entities and collaborators. The management
has explained that such advances have been given in the normal course of business
to land owning companies, collaborators, projects and for purchase of land. As per in-
formation made available to us and explanation given ` 1,529,898,595 (Previous year
` 6,825,516,966) have been recovered/adjusted during the current financial year. The
management, based on internal assessments and evaluations, have represented that
these advances are recoverable/adjustable and that no provision is necessary as at bal-
ance sheet date. The management has further represented that as significant amounts
have been recovered/adjusted during the previous and current financial year and since
constructive and sincere efforts are being put in recovery of the said advances, it is
confident of appropriately adjusting/recovering significant portions of the remaining
outstanding balance of such amounts in the foreseeable future. However, we are un-
able to ascertain whether all the remaining outstanding advances, as above, are fully
recoverable/adjustable since the outstanding balances as at balance sheet date are out-
standing/remained unadjusted for long period of time, and further that, neither the
amount recovered nor rate of recovery of such long outstanding amounts in the current
year, clearly indicate, in our opinion, that all of the remaining outstanding amounts are
fully recoverable, consequently, we are unable to ascertain whether all of the remaining
balances as at balance sheet date are fully recoverable. Accordingly, we are unable to
ascertain the impact, if any, that may arise in case any of these remaining advances are
subsequently determined to be doubtful of recovery.
CHAPTER 24
302 Analysis of Opinion
Description
This book aims to explain the readers how to read, understand, analyse and
interlink the voluminous information available in the financial statement with
the help of charts, case analysis, etc. In other words, this book provides in-depth
analysis, stepwise approach with the use of case analysis, to understand & decode
the financial statements. This book extensively deals with the following issues
& suggests on how they can be mitigated through proper analysis of financial
statements:
Laxity in credit risk appraisal and loan monitoring in banks
Lack of appraisal skills for projects that need specialised skills, resulting in ac-
ceptance of inflated cost or aggressive projections etc.
How to find out frauds, wilful default, diversion of funds
How to find out early warning signs based on proper analysis of financial state-
ments
The entire concept of decoding of financial statement has been divided into six
keys:
Key #1 deals with Statement of Profit & Loss
Key #2 deals with Balance Sheet
Key #3 deals with Concept of Audit and Auditor’s Report
Key #4 relates to Companies Auditor’s Report Order
Key #5 is used for decoding Connecting Statements, and
Key #6 is the Master Key
ORDER NOW