Ratio Analysis Project Report
Ratio Analysis Project Report
1
        A STUDY ON RATIO ANALYSIS
           WITH REFERENCE TO
GENTING LANCO POWER INDIA PRIVATE LIMITED.
                    2
                                CERTIFICATE
work titled “RATIO ANALYSIS” in partial fulfillment of requirement for the award of
This project is the record of authentic work carried out during the
                                         3
                              DECLARATION
the record of authentic work carried out by me during the academic year 2006 –
2008 and has not been submitted to any other University or Institute towards the
                                       4
                   ACKNOWLEDGEMENT
                                      5
Chapter – 1
INTRODUCTION
              6
                               Introduction
                                       7
Role of Financial Managers:
1. Nature of work
2. Working conditions
3. Employment
5. Job outlook
6. Earnings
7. Related occupations
1. Nature of work
                                     8
             The duties of financial managers vary with their specific titles,
which include controller, treasurer or finance officer, credit manager, cash
manager, and risk and insurance manager. Controllers direct the preparation
of financial reports that summarize and forecast the organization’s financial
position, such as income statements, balance sheets, and analyses of future
earnings or expenses. Regulatory authorities also in charge of preparing
special reports require controllers. Often, controllers oversee the accounting,
audit, and budget departments. Treasurers and finance officers direct the
organization’s financial goals, objectives, and budgets. They oversee the
investment of funds and manage associated risks, supervise cash
management activities, execute capital-raising strategies to support a firm’s
expansion, and deal with mergers and acquisitions. Credit managers oversee
the firm’s issuance of credit. They establish credit-rating criteria, determine
credit ceilings, and monitor the collections of past-due accounts. Managers
specializing in international finance develop financial and accounting
systems for the banking transactions of multinational organizations.
                                       9
employ additional financial managers who oversee various functions, such
as lending, trusts, mortgages, and investments, or programs, including sales,
operations, or electronic financial services. These managers may be required
to solicit business, authorize loans, and direct the investment of funds,
always adhering to State laws and regulations.
                                       10
             The role of the financial manager, particularly in business, is
changing in response to technological advances that have significantly
reduced the amount of time it takes to produce financial reports. Financial
managers now perform more data analysis and use it to offer senior
managers ideas on how to maximize profits. They often work on teams,
acting as business advisors to top management. Financial managers need to
keep abreast of the latest computer technology in order to increase the
efficiency of their firm’s financial operations.
2. Working conditions
3. Employment
                                       11
4. Training, Other qualifications and Advancement
                                      12
who successfully complete courses. Although experience, ability, and
leadership are emphasized for promotion, this type of special study may
accelerate advancement.
                                         13
             Financial managers should be creative thinkers and problem-
solvers, applying their analytical skills to business. They must be
comfortable with the latest computer technology. As financial operations
increasingly are affected by the global economy, financial managers must
have knowledge of international finance. Proficiency in a foreign language
also may be important.
5. Job outlook
                                      14
Financial managers who are familiar with computer software that can assist
them in this role will be needed.
6. Earnings
US$
Treasurer 301,200
Controller/comptroller 268,600
Director 227,200
Manager 167,000
             Large organizations often pay more than small ones, and salary
levels also can depend on the type of industry and location. Many financial
                                     15
managers in both public and private industry receive additional
compensation in the form of bonuses, which also vary substantially by size
of firm. Deferred compensation in the form of stock options is becoming
more common, especially for senior level executives.
7. Related occupations
                                      16
                   NEED FOR THE STUDY
                                 17
                                OBJECTIVES
OBJECTIVES
                                        18
      4.                 To offer appropriate suggestions for the better
      performance of the organization
METHODOLOGY
                                     19
Chapter – 5
RATIO ANALYSIS
              20
                         RATIO ANALYSIS
FINANCIAL ANALYSIS
   • Trade creditors, to identify the firm’s ability to meet their claims i.e.
      liquidity position of the company.
                                      21
RATIO ANALYSIS
• Percentages
• Fractions
• Proportion of numbers
   • To compare the calculated ratios with the ratios of the same firm
      relating to the pas6t or with the industry ratios. It facilitates in
      assessing success or failure of the firm.
                                       22
   • Third step is to interpretation, drawing of inferences and report
      writing conclusions are drawn after comparison in the shape of report
      or recommended courses of action.
                                       23
understanding of financial strengths and weaknesses of a firm. There are a
number of ratios which can be calculated from the information given in the
financial statements, but the analyst has to select the appropriate data and
calculate only a few appropriate ratios. The following are the four steps
involved in the ratio analysis.
   • Comparison of the calculated ratios with the ratios of the same firm in
        the past, or the ratios developed from projected financial statements or
        the ratios of some other firms or the comparison with ratios of the
        industry to which the firm belongs.
• Group of ratios
                                        24
   • Historical comparison
• Projected ratios
• Inter-firm comparison
             The calculation of ratios may not be a difficult task but their use
is not easy. Following guidelines or factors may be kept in mind while
interpreting various ratios are
• Selection of ratios
• Use of standards
                                      25
  • Facilitate decision making
• Evaluation of efficiency
• Effective tool
• Differences in definitions
• Limited use
                                   26
   • Personal bias
CLASSIFICATIONS OF RATIOS
1. Traditional Classification
2. Functional Classification
3. Significance ratios
1. Traditional Classification
   • Balance sheet (or) position statement ratio: They deal with the
      relationship between two balance sheet items, e.g. the ratio of current
      assets to current liabilities etc., both the items must, however, pertain
      to the same balance sheet.
   • Profit & loss account (or) revenue statement ratios: These ratios deal
      with the relationship between two profit & loss account items, e.g. the
      ratio of gross profit to sales etc.,
   • Composite (or) inter statement ratios: These ratios exhibit the relation
      between a profit & loss account or income statement item and a
                                        27
       balance sheet items, e.g. stock turnover ratio, or the ratio of total
       assets to sales.
2. Functional Classification
3. Significance ratios
              Some ratios are important than others and the firm may classify
them as primary and secondary ratios. The primary ratio is one, which is of
the prime importance to a concern. The other ratios that support the primary
ratio are called secondary ratios.
1. Liquidity ratio
2. Leverage ratio
3. Activity ratio
4. Profitability ratio
1. LIQUIDITY RATIOS
                                         28
                Liquidity refers to the ability of a concern to meet its current
obligations as & when there becomes due. The short term obligations of a
firm can be met only when there are sufficient liquid assets. The short term
obligations are met by realizing amounts from current, floating (or)
circulating assets The current assets should either be calculated liquid (or)
near liquidity. They should be convertible into cash for paying obligations of
short term nature. The sufficiency (or) insufficiency of current assets should
be assessed by comparing them with short-term current liabilities. If current
assets can pay off current liabilities, then liquidity position will be
satisfactory.
• Current ratio
Current assets
                                        29
Current ratio =
                     Current liabilities
             Quick ratio is a test of liquidity than the current ratio. The term
liquidity refers to the ability of a firm to pay its short-term obligations as &
when they become due. Quick ratio may be defined as the relationship
between quick or liquid assets and current liabilities. An asset is said to be
liquid if it is converted into cash with in a short period without loss of value.
                                         30
Components of quick or liquid ratio
                                       31
creditors are nor accepted to demand cash at the same time and then cash
may also be realized from debtors and inventories.
                                     32
2. LEVERAGE RATIOS
             The leverage or solvency ratio refers to the ability of a concern
to meet its long term obligations. Accordingly, long term solvency ratios
indicate firm’s ability to meet the fixed interest and costs and repayment
schedules associated with its long term borrowings.
             The following ratio serves the purpose of determining the
solvency of the concern.
• Proprietory ratio
                         Shareholders funds
Proprietory ratio =
                           Total assets
                                       33
3. ACTIVITY RATIOS
                                        34
Components of Working Capital
                                      Cost of Sales
Fixed assets turnover ratio =
                                     Net fixed assets
                                        35
      (c) CAPITAL TURNOVER RATIOS
                                      36
      (d) CURRENT ASSETS TO FIXED ASSETS RATIO
                                               Current Assets
Current Assets to Fixed Assets Ratio =
                                               Fixed Assets
                                      37
4. PROFITABILITY RATIOS
• Return on investments
                                       38
Net Profit after Tax = Net Profit (–) Depreciation (–) Interest (–) Income Tax
                                Net profit
Return on assets =
                               Total assets
                                          39
      (c) RESERVES AND SURPLUS TO CAPITAL RATIO
                                            Reserves& surplus
Reserves & surplus to capital =
                                                Capital
                                       40
      (e) OPERATING PROFIT RATIO
                      Operating cost
Operation ratio =
                           Net sales
                              Operating profit
Operating profit ratio =
                                   Sales
                                       41
      (f) PRICE - EARNING RATIO
             Price earning ratio is the ratio between market price per equity
share and earnings per share. The ratio is calculated to make an estimate of
appreciation in the value of a share of a company and is widely used by
investors to decide whether (or) not to buy shares in a particular company.
                                            42
      (g) RETURN ON INVESTMENTS
                                     43
Chapter – 6
DATA ANALYSIS
              44
LIQUIDITY RATIO
1. CURRENT RATIO
(Amount in Rs.)
Current Ratio
Interpretation
             In the year 2006, the cash and bank balance is reduced because
that is used for payment of dividends. In the year 2007, the loans and
advances include majorly the advances to employees and deposits to
                                          45
government. The loans and advances reduced because the employees set off
their claims. The other current assets include the interest attained from the
deposits. The deposits reduced due to the declaration of dividends. So the
other current assets decreased.
GRAPHICAL REPRESENTATION
CURRENT RATIO
       8.00    7.41
       7.00
       6.00
                               4.48
       5.00                                    3.82
 Ratio 4.00
                       2.19            1.94
       3.00                                                Ratio
       2.00
       1.00
       0.00
              2003    2004    2005    2006    2007
                              Years
                                                      46
2. QUICK RATIO
(Amount in Rs.)
Quick Ratio
Interpretation
             Quick assets are those assets which can be converted into cash
with in a short period of time, say to six months. So, here the sundry debtors
which are with the long period does not include in the quick assets.
                                      47
GRAPHICAL REPRESENTATION
QUICK RATIO
       8.00    7.41
       7.00
       6.00
       5.00                    4.35           3.81
 Ratio 4.00
       3.00                            1.90           Ratios
                       1.65
       2.00
       1.00
       0.00
              2003    2004    2005    2006    2007
                              Years
                                                     48
3. ABOSULTE LIQUIDITY RATIO
(Amount in Rs.)
Interpretation
                The current assets which are ready in the form of cash are
considered as absolute liquid assets. Here, the cash and bank balance and the
interest on fixed assts are absolute liquid assets.
                In the year 2006, the cash and bank balance is decreased due to
decrease in the deposits and the current liabilities are also reduced because
of the payment of dividend. That causes a slight increase in the current
year’s ratio.
                                          49
GRAPHICAL REPRESENTATION
                                                     50
LEVERAGE RATIOS
4. PROPRIETORY RATIO
(Amount in Rs.)
Proprietory Ratio
Interpretation
             Total assets, includes fixed and current assets. The fixed assets
are reduced because of the depreciation and there are no major increments in
the fixed assets. The current assets are increased compared with the year
                                       51
2006. Total assets are also increased than precious year, which resulted an
increase in the ratio than older.
GRAPHICAL REPRESENTATION
PROPRIETORY RATIO
          0.90    0.86
                                  0.79             0.75
          0.80
          0.70           0.60
                                          0.53
          0.60
          0.50
 Ratios
          0.40
                                                               Ratios
          0.30
          0.20
          0.10
          0.00
                 2003    2004   2005     2006    2007
                                Years
                                                          52
ACTIVITY RATIOS
(Amount in Rs.)
Interpretation
              The income from services is raised and the current assets are
also raised together resulted in the decrease of the ratio of 2007 compared
with 2006.
                                        53
GRAPHICAL REPRESENTATION
                                                      54
6. FIXED ASSETS TURNOVER RATIO
(Amount in Rs.)
Interpretation
             Fixed assets are used in the business for producing the goods to
be sold. This ratio shows the firm’s ability in generating sales from all
financial resources committed to total assets. The ratio indicates the account
of one rupee investment in fixed assets.
                                        55
GRAPHICAL REPRSENTATION
          1.00
          0.00
                 2003    2004    2005    2006    2007
                                 Years
                                                         56
7. CAPITAL TURNOVER RATIO
(Amount in Rs.)
Interpretation
                                       57
GRAPHICAL REPRESENTATION
                                  1.04
        1.04
        1.03
        1.02             1.01
        1.01
                                                 1.00
        1.00
                                         0.98
 Ratios 0.99     0.98
        0.98                                                 Ratios
        0.97
        0.96
        0.95
        0.94
               2003     2004    2005     2006   2007
                                Years
                                                        58
8. CURRENT ASSETS TO FIXED ASSETS RATIO
(Amount in Rs.)
Interpretation
                                      59
GRAPHICAL REPRESENTATION
          9.00                                    8.17
          8.00
          7.00                            6.07
          6.00
          5.00                    4.20
 Ratios                   3.74
          4.00    2.93
                                                              Ratios
          3.00
          2.00
          1.00
          0.00
                 2003    2004    2005    2006    2007
                                 Years
                                                         60
PROFITABILITY RATIOS
                                                             (Amount in Rs.)
                              Net Profit Ratio
Interpretation
             The net profit ratio is the overall measure of the firm’s ability to
turn each rupee of income from services in net profit. If the net margin is
inadequate the firm will fail to achieve return on shareholder’s funds. High
net profit ratio will help the firm service in the fall of income from services,
rise in cost of production or declining demand.
                                       61
GRAPHICAL REPRESENTATION
0.50 0.42
        0.40                            0.33
                        0.30
 Ratios 0.30                    0.23
                                                            Ratios
        0.20
0.10
        0.00
               2003    2004    2005    2006    2007
                               Years
                                                       62
10. OPERATING PROFIT
                                                            (Amount in Rs.)
                                Operating Profit
Interpretation
                                        63
GRAPHICAL REPRESENTATION
                                                      64
11. RETURN ON TOTAL ASSETS RATIO
                                                                  (Amount in Rs.)
                         Return on Total Assets Ratio
Interpretation
             This is the ratio between net profit and total assets. The ratio
indicates the return on total assets in the form of profits.
                                          65
GRAPHICAL REPRESENTATION
          0.35
                                                  0.31
          0.30    0.27
          0.25
                          0.18    0.19
          0.20                            0.17
 Ratios
          0.15                                                Ratios
          0.10
0.05
          0.00
                 2003    2004    2005    2006    2007
                                 Years
                                                         66
12. RESERVES & SURPLUS TO CAPITAL RATIO
                                                            (Amount in Rs.)
                    Reserves & Surplus To Capital Ratio
Interpretation
             The reserves & surplus is decreased in the year 2006, due to the
payment of dividends and in the year 2007 the profit is increased. But the
capital is remaining constant from the year 2004. So the increase in the
reserves & surplus caused a greater increase in the current year’s ratio
compared with the older.
                                       67
GRAPHICAL REPRESENTATION
          35.00     31.54
          30.00
          25.00
          20.00
 Ratios
          15.00
                                                             Ratios
          10.00
                                 2.75            4.19
                         1.85            2.02
           5.00
            -
                  2003   2004   2005    2006    2007
                                Years
                                                        68
OVERALL PROFITABILITY RATIOS
                                                                 (Amount in Rs.)
                               Earnings Per Share
Interpretation
             Earnings per share ratio are used to find out the return that the
shareholder’s earn from their shares. After charging depreciation and after
payment of tax, the remaining amount will be distributed by all the
shareholders.
                Net profit after tax is increased due to the huge increase in the
income from services. That is the amount which is available to the
shareholders to take. There are 1,871,928 shares of Rs.10/- each. The share
capital is constant from the year 2004. Due to the huge increase in net profit
the earnings per share is greaterly increased in 2007.
                                          69
GRAPHICAL REPRESENTATION
          120.00
                    101.56
          100.00
80.00
 Ratios    60.00
                                                              Ratios
           40.00                                     21.68
                             8.61
                                     9.04    9.75
           20.00
            0.00
                   2003   2004      2005    2006    2007
                                    Years
                                                             70
14. PRICE EARNINGS (P/E) RATIO
                                                         (Amount in Rs.)
                       Price Earning (P/E) Ratio
Interpretation
                                      71
GRAPHICAL REPRESENTATION
P/E RATIO
          4.50                     4.15
          4.00
                          3.30
          3.50                             3.09
          3.00                                     2.39
          2.50
 Ratios
          2.00
                                                               Ratios
          1.50
          1.00
                  0.32
          0.50
          0.00
                 2003    2004    2005     2006    2007
                                 Years
                                                          72
15. RETURN ON INVESTMENT
                                                              (Amount in Rs.)
                           Return on Investment
Interpretation
             This is the ratio between net profits and shareholders funds. The
ratio is generally calculated as percentage multiplying with 100.
                                        73
GRAPHICAL REPRESENTATION
          0.45                                    0.42
          0.40
                  0.31                    0.32
          0.35            0.30
          0.30                    0.24
          0.25
 Ratios
          0.20
                                                              RatioS
          0.15
          0.10
          0.05
          0.00
                 2003    2004    2005    2006    2007
                                 Years
                                                         74
Chapter – 7
                75
FINDINGS OF THE STUDY
The fixed assets turnover ratio is in increasing trend from the year 2003 – 07
(1.26, 1.82, 4.24, 3.69, and 6.82). It indicates that the company is efficiently
utilizing the fixed assets.
                                       76
7.                                      The current assets to fixed
assets ratio is increasing gradually from 2003 – 07 as 2.93, 3.74, 4.20,
6.07 and 8.17. It shows that the current assets are increased than fixed
assets.
                                77
13.                                    Price Earnings ratio is reduced
when compared with the last year. It is reduced from 3.09 to 2.39,
because the earnings per share is increased.
                               78
SUMMARY
   2) The company profits are huge in the current year; it is better to declare
      the dividend to shareholders.
   3) The company is utilising the fixed assets, which majorly help to the
      growth of the organisation. The company should maintain that
      perfectly.
   4) The company fixed deposits are raised from the inception, it gives the
      other income i.e., Interest on fixed deposits.
CONCLUSION
                                       79
BIBLIOGRAPHY
REFFERED BOOKS
INTERNET SITE
• www.ercap.org
• www.wikipedia.com
• www.nwda.gov.in
                        80
   APPENDIX
(Amount in Rs.)
                                              81
Profit and Loss Account for the period ended on 31st March 2007
                                                                   (Amount in Rs.)
                            Particulars                          2006 - 07    2005 – 06
I.INCOME
Income from Services                                           96,654,902    55,550,649
Other Income                                                    2,398,220     2,285,896
                                                       TOTAL   99,053,122    57,836,545
II.EXPENDITURE
Administrative and Other Expenses                              81,334,750    75,599,719
                                                               81,334,750    75,599,719
Less: Expenditure Reimbursable under Operations
and Maintenance Agreement                                      49,474,305    49,349,892
                                                    TOTAL      31,860,445    26,249,827
III. PROFIT BEFORE DEPRECIATION AND TAXATION                   67,192,677    31,586,718
Provision for Depreciation                                      2,183,576     2,279,917
IV. PROFIT BEFORE TAXATION                                     65,009,101    29,306,801
Provision for Taxation
  - Current                                                    24,292,000    10,680,440
    - Deferred                                                   (315,922)      (67,359)
  - Fringe Benefits                                               446,663       434,140
V. PROFIT AFTER TAXATION                                       40,586,359    18,259,580
Surplus brought forward from Previous Year                     26,699,257    44,951,851
VI. PROFIT AVAIALABLE FOR APPROPRIATIONS                       67,285,617    63,211,431
Transfer to General Reserve                                        -          4,495,185
Interim Dividend Rs.15 per equity Share (2005- NIL)                -         28,078,920
Provision for Dividend Distribution Tax                            -          3,938,069
VII. BALANCE CARRIED TO BALANCE SHEET                          67,285,617    26,699,257
82