Financial Statement Analysis
Financial Statement Analysis
CHAPTER 1
INTRODUCTION
METHODOLOGY
CHAPTER 2
COMPANY PROFILE
CHAPTER 3
THEORETICAL FRAMEWORK OF
CHAPTER 4
CHAPTER 5
FINDINGS
BIBILOGRAPHY
INTRODUCTION
These are prepared at the end of a given period of time. They are
the indicators of profitability and financial soundness of the business concern.
The term financial analysis is also known as analysis and interpretation of
financial statements. It refers to the establishing meaningful relationship
between various items of the two financial statements i.e. Income statement and
Position statement. It determines financial strength and weakness of the firm.
Analysis of financial statements is an attempt to assess the efficiency and
performance of an enterprise. Thus, the analysis and interpretation of financial
statements is very essential to measure the efficiency, profitability , financial
soundness and future prospects of the business units. Financial analysis serves
the following purposes.
METHODOLOGY
Primary data
Secondary data
PRIMARY DATA
3. From the people who are directly involved with the transaction of
the firm.
Secondary data
Study has been taken from secondary sources i.e. published annual
reports of the company editing, classifying and tabulation of the financial data.
For this purpose performance data of CHAITANYA FINANCE PIN CREDIT
PRIVATE LIMITED for the years 2007-2008 to 2009-2010 has been used.
Scope of study
The scope and period of the study is being restricted to the following.
2. The information is obtained from the primary and secondary data was
limited to the CHAITANYA FINANCE PIN CREDIT PRIVATE
LIMITED.
3. The profit and loss, the balance sheet was on the last six years.
Limitations of study
2. As most of the data is from the secondary sources, hence the accuracy is
limited.
COMPANY PROFILE
CHAITANYA FINANCE PIN CREDIT PRIVATE LIMITED
VISION:
MISSION:
VALUES:
5. Team playing.
6. Zeal to excel.
GROWTH:
PROFITABILITY:
TECHNOLOGY:
IMAGE:
The strength, weakness, opportunities and threats which are being experienced
by CHAITANYA FINANCE PIN CREDIT PRIVATE LIMITED as a growing
concern have been summarized up in the following lines.
STRENGTH’S
WEAKNESS
4. No financial package
THREATS
4. Poor infrastructure.
PRODUCTS OF CHAITANYA FINANCE PIN CREDIT PRIVATE
LIMITED
1. Gas turbines
2. Steam turbines
3. Compressors
4. Turbo generators.
5. Pumps
6. Pulverizes
7. Switchgears
8. Oil rigs
10. Telecommunication.
THEORITICAL
FRAMEWORK OF
FINANCIAL STATEMENT
ANALYSIS
INTRODUCTION TO FINANCE:
SCOPE:
PRODUCTION
MARKETING
FINANCE
FUNCTION:
5. Informed decision.
SCOPE OF THE STUDY:
2. The information obtained from the primary and secondary data was
limited to the CHAITANYA FINANCE PIN CREDIT PRIVATE
LIMITED
4. The profit and loss, the balance sheet was on the last 3 years.
LIMITATIONS OF STUDY:
METHODOLOGY:
1. PRIMARY DATA
2. SECONDARY DATA
PRIMARY DATA COLLECTION:
3. From the people who are directly involved with the transaction of the
firm.
Study has been taken from secondary sources i.e. published annual
report of the company. Editing. Classifying and tabulation of the
financial data for this purpose performance data of CHAITANYA
FINANCE PIN CREDIT PRIVATE LIMITED or the yeary2007-2008 to
2009-2010 have been used.
(A)DEFINITIONS:
(C)CONVENTIONS:
The financial statements are mirrors which reflect the financial position and
operating strength’s or weaknesses of the concern. These statements are useful
to management, investors, creditors, bankers, workers, government and public
at large. George O May points of the following measure used of financial
statements:
As a basis for taxation.
1. Potential investors
3. Debenture holders
5. Employee customers who wish to make along standing contact with the
company.
7. Members.
1. A balance sheet
2. An income statement
BALANCE SHEET:
The term owners equity refers in the claims of the owners of the
business against the assets of the firm. It consist of two elements.
1. Paid up share capital i.e. the initial amount of funds invested by the
shareholders.
The basic financial statement i.e. the balance sheet and profit and loss
account and income statement of a business reveals the net effect of various
transactions on the operational position of the company. But there are many
transactions that do not operate through profit and loss account. Those for a
better understanding another statement of changes in financial position has to be
prepared to show the changes in assets and liabilities from the end of another
point of time. The statement of changes in financial position may take any of
the two forms. They are:
Funds statements
Absolute figures
TREND ANALYSIS:
Trend percentages:
RATIO ANALYSIS:
TYPES OF RATIOS
Liquidity ratio
Profitability ratio
Activity ratio.
1. Current ratio
3. Cash ratio
1.Current ratio: Current ratio is the ratio of current assets to current liabilities.
Current assets are the assets that are expected to be realized in cash or sold or
consumed during the normal operating cycle of the business or with in one year,
which ever is longer, they include cash in hand and bank, bills receivable, net
sundry debtors, stock of raw materials, finished goods and working in progress,
prepaid expenses, outstanding incomes, assured incomes and short term or
temporary investments. Current liabilities are the liabilities that are to be repaid
within a period of one year. They include bills payable, sundry creditors, bank
overdrafts, outstanding expenses, income receivable in advance, proposed
dividend, provision for taxation, unclaimed dividends and short term loans and
advanced repayable within one year. Any instalment of long-term liability
payable within the next 12 months is also current liability.
2. ACID TEST/QUICK RATIO: the acid test ratio is the ratio between quick
current assets and current liabilities and calculated by dividing the quick assets
by current liabilities. Quick assets mean those which can be converted into cash
immediately by exclusion of inventory and prepaid expenses from current
assets.
3. CASH RATIO: The cash ratio is the ratio of cash and bank balance, it is
calculated dividing cash and bank balance by current liabilities.
2. Proprietary Ratio
1.Debt Equity Ratio : It reflects the relative claim of creditors and shareholders
against the assets of the business. Debt usually refers to long-term liability.
Equity includes equity and preference share capital and reserves.
2.Propreitary ratio: It expresses the relationship between the net worth and total
assets. A high proprietary ratio is indicative of strong financial position of
business.
Capital Gearing Ratio = funds bearing fixed interest and fixed dividend/equity
. share holder’s funds
Funds bearing fixed interest and capital=Debentures + term loans +preference .
. share capital.
4.Fixed Assets Ratio: This ratio indicates the mode of financial the fixed assets.
It is calculated as
5.Interest Coverage Ratio: This ratio is called as “debt service ratio”. This ratio
indicates whether a business is earning sufficient profits to pay the interest
charges. It is calculated as
Generally greater the ratio, the better is the servicing ability of company.
1.Gross Profit Ratio: Gross profit is one of the most commonly used ratios. It
reveals the result of trading operations of the business. In other words, it
indicates to us the profitability of the business. It is calculated as
Generally the higher the ratio, the better will be the performance of the
company.
5.EXPENSES RATIO: Expenses ratios are the ratios that supplement the
information given by the operating ratio. Each of the expense rations highlights
the relationship given by the particular expense and net sales. For example,
factory expenses ratio is of factory expenses to net sales any expenditure can be
shown as a ratio to sales. All such ratios fall under the broad head of expenses
ratios.
ROA=PAT/TOTAL SALES
6.Dividends per share (DPS): It is the amount of dividend payable to the holder
of one equity share. It is calculated as
DPS=Dividend on equity share capital/number of equity shares
Generally from investors point of view, the higher the ratio, the happier the
investor.
7.DIVIDEND PAY OUT RATIO: It is the ratio of dividend per share to earning
per share. It is calculated as
10.BOK VALUE: It is the fraction of the net worth of the business as depicted
in the balance sheet, which is attributable to one equity share of the business . it
is calculated as
Generally higher the book value of the share, the more strong the business is
assumed to be.
2.DEBTORS TURN OVER RATIO: Debtors Turn Over Ratio expresses the
relationship between debtors and net credit sales. It is calculated as
Generally the ratio between 10-12 an ideal value for the company.
3.CREDITORS TURN OVER RATIO: Creditors turn over ratio expresses the
relationship between creditors and net credit purchases. It is calculated as
Generally higher the ratio, the greater is the ability of the firm to utilize the
investments in the business.
DATA ANALYSIS
AND
INTERPRETATION
Current Asset Liability Ratio
year current assets current liability Ratios
2001-02 155792 73129 2.13
2002-03 166669 74427 2.23
2003-04 155652 84990 1.83
2004-05 192697 116644 1.65
2005-06 235062 143200 1.64
2006-07 276062 208869 1.32
2007-08 310002 243220 1.27
2008-09 453597 376332 1.2
2009-10 580804 397574 1.46
2010-11 771519 502024 1.54
800000
700000
600000
100000
0
2001- 2002- 2003- 2004- 2005- 2006- 2007- 2008- 2009- 2010-
02 03 04 05 06 07 08 09 10 11
Interpretation –The ideal ratio for the concern is 2:1 i.e. current assets doubled
for the current liabilities considered to be satisfactory. The current ratio of
CHAITANYA FINANCE PIN CREDIT PRIVATE LIMITED is less than !
.Thus it has to maintain its efficient current assets.
Acid Test Ratio
Year Liquid assets Liquid liabilities Ratio
2001-02 898 73129 0.012
2002-03 1281 74427 0.017
2003-04 472 84990 0.005
2004-05 2094 116644 0.018
2005-06 4643 143200 0.032
2006-07 12 208869 0.00005
2007-08 14 243220 0.00003
2008-09 15 376332 0.00003986
2009-10 1475 397574 0.00371
2010-11 1415 502024 0.002818
600000
500000
400000
100000
0
2001- 2002- 2003- 2004- 2005- 2006- 2007- 2008- 2009- 2010-
02 03 04 05 06 07 08 09 10 11
The ideal quick ratio is 1:1 which is considered satisfactory for the concern. The
company is maintaining the ratio above the standard norm , thus the
management of CHAITANYA FINANCE PIN CREDIT PRIVATE LIMITED
is label to meet its current obligations.
Net working capital
Net working Capital
year capital employed Ratios
2001-02 82663 90522 0.9131
2002-03 92242 99337 0.93
2003-04 70662 79114 0.8931
2004-05 76053 85026 0.894
2005-06 91862 102462 0.89
2006-07 67193 79459 0.84
2007-08 96410 107986 0.89
2008-09 77265 96894 0.797
2009-10 183230 207051 0.884
2010-11 269495 305907 0.881
350000
300000
250000
200000
Net working capital
150000 Capital employed
Ratios
100000
50000
0
2001- 2002- 2003- 2004- 2005- 2006- 2007- 2008- 2009- 2010-
02 03 04 05 06 07 08 09 10 11
3500
3000
2500
500
0
2001-02 2002-03 2003-04 2004-05 2005-06 2006-07 2007-08 2008-09 2009-10 2010-11
350000
300000
250000
200000
Fixed assets
150000 Capital employed
`
Ratios
100000
50000
0
2001- 2002- 2003- 2004- 2005- 2006- 2007- 2008- 2009- 2010-
02 03 04 05 06 07 08 09 10 11
Fixed Assets Ratio = Fixed Assets / Capital Employed
Generally financially well managed company will have its fixed assets financed
by long term funds. There fore , the fixed assets ratio should never be more than
!.A ratio of .67 is considered ideal. The results for CHAITANYA FINANCE
PIN CREDIT PRIVATE LIMITED is much less at 0.11
120000
100000
80000
PBIT
60000 Interest
Ratio
40000
20000
0
2001- 2002- 2003- 2004- 2005- 2006- 2007- 2008- 2009- 2010-
02 03 04 05 06 07 08 09 10 11
Gross profit
year Gross profit Net sales Ratios
2001-02 13500 153205 0.088
2002-03 13420 137838 0.097
2003-04 15821 174490 0.07
2004-05 33122 174668 0.189
2005-06 60867 267217 0.227
2006-07 63290 289241 0.218
2007-08 68916 310235 0.2224
2008-09 68478 414816 0.165
2009-10 86483 500342 0.172
2010-11 130330 665323 0.196
700000
600000
500000
400000
Gross profit
300000 Net sales
Ratio
200000
100000
0
2001- 2002- 2003- 2004- 2005- 2006- 2007- 2008- 2009- 2010-
02 03 04 05 06 07 08 09 10 11
Generally the higher gross profit ratio , the better for the performance of the
concern .In CHAITANYA FINANCE PIN CREDIT PRIVATE LIMITED , the
company has started to increase from the year on year which is a very good
sign for the company.
Operating ratio
year Operating cost Net sales Ratios
2001-02 131006 153205 0.85
2002-03 116708 137838 0.84
2003-04 149823 174490 0.85
2004-05 136630 174668 0.78
2005-06 201962 267217 0.75
2006-07 221227 289491 0.76
2007-08 234677 310235 0.76
2008-09 338382 414816 0.81
2009-10 404647 500342 0.8
2010-11 524531 665323 0.79
700000
600000
500000
100000
0
2001-02 2002-03 2003-04 2004-05 2005-06 2006-07 2007-08 2008-09 2009-10 2010-11
Generally the lower the Operating Cost , the better for the concern. The ratio
should be below1 which is satisfactory for the concern.
350000
300000
250000
200000
PBIT
150000 Capital employed
Ratios
100000
50000
0
2001- 2002- 2003- 2004- 2005- 2006- 2007- 2008- 2009- 2010-
02 03 04 05 06 07 08 09 10 11
The higher the ROCE ratio , the better for the concern. The company has been
keeping up the good performance is increasing at the rapid phase which in turn
is a good sign for the company.
700000
600000
500000
400000
Net credit sales
300000 Average debtors
Ratio
200000
100000
0
2001- 2002- 2003- 2004- 2005- 2006- 2007- 2008- 2009- 2010-
02 03 04 05 06 07 08 09 10 11
120000
100000
80000
20000
0
2001- 2002- 2003- 2004- 2005- 2006- 2007- 2008- 2009- 2010-
02 03 04 05 06 07 08 09 10 11
700000
600000
500000
100000
0
2001-02 2002-03 2003-04 2004-05 2005-06 2006-07 2007-08 2008-09 2009-10 2010-11
At high fixed assets turnover ratio indicates better utilization of the firms fixed
assets. A ratio around 5 is considered ideal for the concern .In CHAITANYA
FINANCE PIN CREDIT PRIVATE LIMITED it is more than 22.This is a very
good sigh for the company.
3500
3000
2500
2000
Total debt
1500 Equity
Ratio
1000
500
0
2001- 2002- 2003- 2004- 2005- 2006- 2007- 2008- 2009- 2010-
02 03 04 05 06 07 08 09 10 11
The Total Assets turnover ratio of the CHAITANYA FINANCE PIN CREDIT
PRIVATE LIMITED is below 1 . This shows greater ability of the firm to
utilize the investment in the business
TURNOVER-
CHAITANYA FINANCE
1106 400
PIN CREDIT PRIVATE
LIMITED -706 -63.83%
- NON-
CHAITANYA FINANCE
499236 664923
PIN CREDIT PRIVATE
LIMITED 165687 33.19%
TOTAL TURNOVER 500342 665323 164981 32.97%
CHANGES IN WIP 49447 -25439 -74886 -151.45%
CHANGES IN FG -9622 -9622
EXPORT INCENTIVES 690 669 -422 -21.00%
GROSS TURNOVER 540857 640553 99696 18.43%
EXCISE DUTY 16859 33288 16429 97.44%
GTO LESS ED 523998 607265 83267 15.89%
DIRECT MATERIALS 340315 342167 1852 0.544%
SUB-CONTRACT
1356 1682
PAYMENT 378 24.04%
POWER AND FUEL 1746 1693 -53 -3.04%
TRANSFER IN
806 681
SERVICE -125 -15.51%
TOTAL OF `C' 344223 346223 2000 0.58%
VALUE ADDED 179775 261042 81267 42.20%
PERSONNEL
62236 69941
PAYMENTS 7795 12.38%
INDIRECT MATERIALS 3902 5861 2059 52.76%
OTHER EXPENSES -
CHAITANYA FINANCE
7101 8583
PIN CREDIT PRIVATE
LIMITED 1482 20.87%
OTHER EXPENSES -
NON CHAITANYA
26301 27410
FINANCE PIN CREDIT
PRIVATE LIMITED 1109 4.22%
PROVISIONS -226 38565 %
PROV.EXCH.VAR. 894 -1523 %
LESS:MISC.INCOME 11522 23356 11834 102.71%
TOTAL OF `E' 88686 125481 36795 41.49%
GROSS MARGIN
91089 135561
(PBIDT) 44472 48.82%
DEPRECIATION 4606 5231 625 13.57%
DRE ON VRS 0
GROSS PROFIT (PBIT) 86483 130330 43847 50.70%
INTEREST -7101 -2905 -10006 -140.91%
PROFIT BEFORE TAX 93584 133235 39651 42.37%
GTO LESS ED 523998 607265 83267 15.90%
0
OPERATING COST 404647 524531 119884
Comparative income statement 2008-09 & 2009-10
DESCRIPTION
2008- 2009-
09 10 Increase/Decrease Increase/Decrease%
TURNOVER- CHAITANYA
FINANCE PIN CREDIT 779 1106
PRIVATE LIMITED 327 41.98%
- NON-
CHAITANYA FINANCE
414037 499236
PIN CREDIT PRIVATE
LIMITED 85199 20.58%
TOTAL TURNOVER 414816 500342 85526 20.62%
CHANGES IN WIP 10637 49447 38810 364.86%
CHANGES IN FG 4938 -9622 %
EXPORT INCENTIVES 1112 690 -422 -37.95%
GROSS TURNOVER 431503 540857 109354 25.34%
EXCISE DUTY 24537 16859 -7678 -31.29%
GTO LESS ED 406966 523998 117032 28.76%
DIRECT MATERIALS 259592 340315 86723 33.41%
SUB-CONTRACT
978 1356
PAYMENT 378 38.65%
POWER AND FUEL 1925 1746 -169 -8.78%
TRANSFER IN SERVICE 1347 806 -541 -40.16%
TOTAL OF `C' 263842 344223 80381 30.46%
VALUE ADDED 143124 179775 36651 25.61%
PERSONNEL PAYMENTS 58365 62236 3871 6.63%
INDIRECT MATERIALS 4560 3902 -658 -14.43%
OTHER EXPENSES -
CHAITANYA FINANCE
6436 7101
PIN CREDIT PRIVATE
LIMITED 665 10.33%
OTHER EXPENSES - NON
CHAITANYA FINANCE
15402 26301
PIN CREDIT PRIVATE
LIMITED 10899 70.76%
PROVISIONS 142 -226
PROV.EXCH.VAR. -324 894
LESS:MISC.INCOME 13913 11522 -2391 -17.18%
TOTAL OF `E' 70668 88686 18018 25.50%
GROSS MARGIN (PBIDT) 72456 91089 18633 25.72%
DEPRECIATION 3978 4606 628 15.79%
DRE ON VRS 0
GROSS PROFIT (PBIT) 68478 86483 18005 26.29%
INTEREST -6826 -7101
PROFIT BEFORE TAX 75304 93584 18280 24.27%
GTO LESS ED 406966 523998 117032 28.76%
0
OPERATING COST 338382 404647 66265
TURNOVER- CHAITANYA
FINANCE PIN CREDIT 667 779
PRIVATE LIMITED 112 16.79%
- NON-
CHAITANYA FINANCE PIN
309568 414037
CREDIT PRIVATE
LIMITED 104469 33.74%
TOTAL TURNOVER 310235 414816 104581 33.71%
CHANGES IN WIP 17781 10637 -7108 -39.97%
CHANGES IN FG 4591 4938 347 7.56%
EXPORT INCENTIVES 2283 1112 -1171 -51.29%
GROSS TURNOVER 334890 431503 96613 28.85%
EXCISE DUTY 27236 24537 -2699 -9.91%
GTO LESS ED 307654 406966 99312 32.28%
DIRECT MATERIALS 183845 259592 75747 41.20%
SUB-CONTRACT
790 978
PAYMENT 188 23.80%
POWER AND FUEL 1840 1925 85 4.62%
TRANSFER IN SERVICE 1394 1347 -47 -11.93%
TOTAL OF `C' 187869 263842 75973 40.44%
VALUE ADDED 119785 143124 23339 19.48%
PERSONNEL PAYMENTS 36001 58365 22364 62.12%
INDIRECT MATERIALS 4039 4560 521 12.90%
OTHER EXPENSES -
CHAITANYA FINANCE PIN
6125 6436
CREDIT PRIVATE
LIMITED 311 5.08%
OTHER EXPENSES - NON
CHAITANYA FINANCE PIN
12848 15402
CREDIT PRIVATE
LIMITED 2554 19.88%
PROVISIONS 1805 142 -1663 -92.13%
PROV.EXCH.VAR. -1524 -324 %
LESS:MISC.INCOME 11746 13913 2227 18.96%
TOTAL OF `E' 47548 70668 23120 48.63%
GROSS MARGIN (PBIDT) 72237 72456 219 0.303%
DEPRECIATION 3321 3978 657 19.78%
DRE ON VRS 0
GROSS PROFIT (PBIT) 68916 68478 -438 -0.64%
INTEREST -5870 -6826 %
PROFIT BEFORE TAX 74786 75304 518 0.69%
GTO LESS ED 307654 406966 99312 32.28%
0
OPERATING COST 234677 338382 103705 44.19%
FINDINGS
1. The net working capital was Rs 91021 lac’s in 2000-2001. This decreased
to Rs 82663 lac’s in the year 2001-2002. In the year 2006-2007 the net
working capital is Rs 67193 lac’s.
3. The organization is able to maintain both current ratio and quick ratio
above the standard norms. i.e. the ideal current ratio for the concern is 2:1
and the quick ratio is 1:1 but the cash ratio is fluctuating.
7. The debtors turnover ratio has decreased from the year 2001-2002 to
2002-2003. It was 2.10 in the year 2003-2004. There was decrease in
debtors turnover ratio till the financial year.
CONCLUSIONS AND SUGGESTIONS:
4. The debtors constitute nearly 50% of the Total Current Assets. For the
Company it is difficult to manage the accounts receivables. The company
should collect debts as quickly as possible.
6. The debtors turn over ratio in 2005-2006 is 1.97. the ratio has increased
than previous years except for 2003-2004, which had 2.10. the decreasing
ratio shows the inefficient management. They should concentrate more on
the collection of the debts.
BIBILOGRAPHY:
http://www.studyfinance.com/lessons/workcap
www.bizsearchpapers.com
http://www.antiessays.com/free-essays/9076.html
http://www.Chaitanya finance pin credit private
limitedhyderabad.com/Chaitanya finance pin credit private
limited_hyderabad_unit.htm
http://en.wikipedia.org/wiki/Bharat_Heavy_Electricals_Limited