ONGC Project
ONGC Project
INTRODUCTION
Financial activities deal with not only the procurement and utilization of funds but also
with the assessing of needs for funds, raising required finance, capital budgeting, distribution of
surplus, financial controls, etc.
Financial management is a body of business concerned with the efficient and effective
use of either equity capital, borrowed cash or any other business funds as well as taking the right
decision for profit maximization and value addition of an entity. - Kepher Petra
Finance management not only for the business, but also for every expenses. Like its for
the home base expenses or the government expenses. The government also need to manage the
finance for the develop of the country and the household also need to manage their expenses
properly -Vinod Verma
1
Objectives of Financial Management:
Main objective of financial management is wealth maximization.
Maximization of owners’ wealth is possible when the capital invested initially increases
over a period of time.
Wealth maximization means maximizing the market value of investment in shares of the
company.
In order to maximize wealth, financial management must achieve the following objectives:
2
Scope
The scope of financial management has undergone far reaching changes over time. The
finance function assumes a lot of significance in the modern days in view of the increased size of
business operations and growing complexities associates thereto. The scope of financial
management can be studied in two broad categories i.e.,
scope
Traditional Approach
As per this approach, the following aspects only were included in the scope of financial
management:
3
Modern Approach
Since 1950s, the approach and utility of financial management has started
Financial management is considered as vital and an integral part of overall management.
The emphasis of Financial Management has been shifted from raising of funds to the
effective and judicious utilization of funds.
The modern approach is analytical way of looking into the financial problems of the
firm.
the finance manger is required to look into the financial implications of every decision to
be taken by the firm.
The functions of financial management can be broadly classified into three major decisions
1. Investment Decisions
2. Financing Decisions
3. Dividend Decisions
4
1. Investment Decisions:
The Investment Decision is Concerned with the selection of assets
The assets of business firm includes long term assets ( fixed assets) and short term assets
( current assets).
Long term assets will yield a return over a period of time in future, whereas short term
assets are those assets which are easily convertible into cash within an accounting period
The long term investment decision is known as Capital Budgeting and short term
investment decision is identified as Working Capital Management.
2. Financing Decisions:
It is the second important decision is financing decision.
The financing decision is concerned with capital mix (Financing-mix) or capital structure
of a firm.
The term capital structure refers to the proportion of debenture capital (debt) and equity
share capital.
3. Dividend Decisions:
5
The Functional areas of Modern Financial Management:
6
The Traditional Phase
This phase has lasted for about four decades. Its finest expression was shown in the
scholarly work of Arthur S.Dewing in his book tilted the financial policy of corporation in
1920’s.Inthise phase the focus of financial management was on four selected aspects.
It treats the entire subject of finance from the outsider’s point of view rather than the
financial decision maker in the firm
It places much importance of corporation finance and too little on the financing problems
of non-financial corporate enterprises
The sequence of treatment was on certain episodic events like formation. Issuance of
capital major expansion, merger, reorganization and liquidation during the life cycle of an
enterprise
It laid heavy emphasis on long-term financing, institutions, instrument, procedures used
in capital markets and legal aspects of financial events. That is it lacks emphasis on the
problems of working capital management.
7
Difference Between Profit Maximization and Wealth Maximization: (Table :1.1)
Advantages Disadvantages
i. Guide for Future Activities: i. Setting of Standards:
Financial control provides the base for future One of the important tasks of financial control
financial activities. It provides guidance to is to compare the actual performance with the
finance manager about how to perform a standard performance but determination of
financial activity. standard performance for a job is a difficult
8
Profit Maximisation Vs Wealth Maximisation:
Total profits are not as important as earnings per share.
Even maximisation of earnings per share is not enough because it does not specify the
timing or duration of expected returns.
Further, it does not consider the risk of uncertainty of the future earnings. Hence, wealth
maximisation is appropriate and it is possible by maximising the market price per share.
According to Prof. Ezra Soloman, wealth maximisation also maximises the achievement
of other objectives.
9
PROFIT MAXIMIZATION WEALTH MAXIMIZATION
Profit Maximization is based on the increase of Wealth Maximization is based on the cash
sales and profits of the organization. flows into the organization.
Focused On
Risk
Profit Maximization ignore the risk and Wealth Maximization considers the risk and
uncertainty. uncertainty.
Reliability
10
Introduction to Ratio Analysis
Meaning of Ratio: - A ratio is simple arithmetical expression of the relationship of one
number to another. It may be defined as the indicated quotient of two mathematical expressions.
Ratio Analysis: - Ratio analysis is the process of determining and presenting the relationship
of items and group of items in the statements. According to Batty J. Management Accounting
“Ratio can assist management in its basic functions of forecasting, planning coordination, control
and communication”.
It is helpful to know about the liquidity, solvency, capital structure and profitability of an
organization. It is helpful tool to aid in applying judgement, otherwise complex situations.
Ratio analysis can represent following three methods.
Ratio may be expressed in the following three ways:
1. Pure Ratio or Simple Ratio: - It is expressed by the simple division of one number by
another. For example, if the current assets of a business are Rs. 200000 and its current liabilities
are Rs. 100000, the ratio of ‘Current assets to current liabilities’ will be 2:1.
2. ‘Rate’ or ‘So Many Times :- In this type , it is calculated how many times a figure is,
in comparison to another figure. For example, if a firm’s credit sales during the year are Rs.
200000 and its debtors at the end of the year are Rs. 40000, its Debtors Turnover Ratio is
200000/40000 = 5 times. It shows that the credit sales are 5 times in comparison to debtors.
3. Percentage: - In this type, the relation between two figures is expressed in hundredth. For
example, if a firm’s capital is Rs.1000000 and its profit is Rs.200000 the ratio of profit capital, in
term of percentage, is 200000/1000000*100 = 20%
11
ADVANTAGE OF RATIO ANALYSIS
12
NEED FOR THE STUDY
Finance manager must know the impact of financial decision on financial conditions and
profitability of the firm.
The tools of financial analysis serve as had made to management for determining the
impact of his decisions.
The present study is helpful to the company to know the deficiencies in the ratio analysis
practices of ONGC Ltd. So the necessary steps will be taken to improve asset position.
The study given the solvency/liquidity position of the company and the optimum cash
balance to meet the day to day requirements of the company which is really helpful to the
finance department of ONGC Ltd.
13
SCOPE OF THE STUDY
14
OBJECTIVES OF THE STUDY
15
METHODOLOGY OF THE STUDY
The study is carried on with the co-operation of the management who permitted to carry
out the study and provided the required data. The data is collected both from primary and
secondary resources.
Primary Data
The data is mainly collected by personnel discussions and interviews with the relevant
persons of the company.
Secondary Data
The secondary data is mainly collected from journals, magazines and books available on
the subject, profile of the company and financial statements.
Data Collection
The data collection from the company files, financial assets, balance sheets, and from
library books and other articles from the websites.
Data Analysis
The analyses used in the study are tabulation of charts, graphs and mathematical tools for
representation and schedule of ratios, common size statement, and comparative analysis.
16
LIMITATIONS OF THE STUDY
Since the study is based on ratios instant price level changes cannot be reflected.
The study is conducted with the secondary data which is taken from the ONGC Ltd.
annual reports.
The ratios are generally calculated from the fast financial statements and there are no
indicators of future.
Since the period of study is short, it also forms one of the above limitation
Ratio analysis is based on accounting data not economic data.
17
CHAPTER – II
PROFILE OIL AND GAS INDUSTRY IN INDIA
Introduction
The oil and gas sector is among the six core industries india
In 1997–98, the New Exploration Licensing Policy (NELP) was envisaged to fill the
ever-increasing gap between India’s gas demand and supply.
The Government of India has adopted several policies to fulfil the increasing demand.
The government has allowed 100 per cent Foreign Direct Investment (FDI) in many
segments of the sector,
Oil and gas industry in Ukraine has long history, the first historical data on oil production
in Western Ukraine appeared in the14th century.
Ukraine was the first country in the world to deliver natural gas to other countries
In the 1820s, the commercial production of oil started in the Boryslav, Pre-Carpathian
region.
At the beginning of the 20th century the volume of production reached 2 million tons per
year.
After World War II, oil and gas industry of Ukraine developed rapidly as a result of the
discovery of significant hydrocarbon
In 1972 the industry reached the peak level of oil and gas condensate production (14.4
million tons), and in 1975, the peak level of natural gas production (68.7 bcm).
18
Major sources of energy in the world
Commercial energy is used by production sector while almost whole of the non-conmercial
energy is consumed by the household sector.
To meet this type of use of energy there are so many sources of energy some of them are
sources
19
Sources of Energy
1. Coal:
Coal is the main source of energy in India and it accounts
for about 67% of country’s commercial requirements. In
2005-06,
2. Petroleum:
Petroleum consumption has been increasing faster than
the petroleum production in India.
3. Natural Gas:
20
4. Hydro Power:
In countries like Norway and Brazil its contribution is more
than 90% in their total electricity generation.
5. Atomic Energy:
India is now one of the few countries which have made
considerable progress in the field of atomic energy.
Atomic energy can be produced by using uranium and thorium. Monazite is the source of
thorium. It is found in Kerala, Karnataka and Bihar.
6. Solar Energy:
21
Renewable and Non-Renewable Natural Resources
All resources of living and non-living provided by nature are called natural resources.
Hence land, water, air, minerals, forest, all forms of energy,
Resources means“the interaction of matter and energy for the functioning of organisms,
populations and ecosystems”.
Natural resources are necessary for the fulfilment of physiological and socio-economic
needs of individual and community as a whole.
Depending on the origin and sustainability, natural resources are divided into two types. These
are:
1. Renewable resources:
Resources which are reproducible are called Renewable resources.
Natural vegetation, wildlife, soil, water, wind energy etc. are in this category.
2. Non-renewable resources:
Resources which cannot be replaced if used once are called non-renewable.
Nature has provided limited supply of these resources. Continuous use of these resources
depletes its stock and future demands cannot be fulfilled as these resources are not
replaceable.
22
World oil and gas reserves country wide
1. VENEZUELA
Proven oil reserves in 2013 (billion barrels): 297.6. Total oil supply in 2012 (thousand barrels
per day): 2,489.2
Venezuela surpassed Saudi Arabia last year to become the holder of the largest oil reserves in the
world..
2. SAUDI ARABIA
Proven oil reserves (billion barrels): 267.91. Total oil supply in 2012 (thousand barrels per day):
11,545.7
Saudi Arabia has almost one-fifth of the world’s proven oil reserves and ranks as the largest
producer and exporter of oil in the world.
3. CANADA
Proven oil reserves: 173.105. Total oil supply in 2012 (thousand barrels per day): 3,854.4
Canada’s oil sands are a significant contributor to the recent growth in the world’s liquid fuel
supply and comprise the vast majority of the country’s proven oil reserves.
4. IRAN
Proven oil reserves: 154.58. Total oil supply in 2012 (thousand barrels per day): 3,538.4
International sanctions have drastically impacted Iran’s energy sector – the country’s oil
production fell dramatically in 2012,
5. IRAQ
Proven oil reserves: 141.35. Total oil supply in 2012 (thousand barrels per day): 2,986.6
Despite having large proven oil reserves, increases in oil production have fallen behind
ambitious targets because of infrastructure constraints and political disputes, says EIA.
23
6. KUWAIT
Proven oil reserves: 104. Total oil supply in 2012 (thousand barrels per day): 2,796.8
Kuwait boasts the second largest oil reserves in the GCC, behind Saudi Arabia and is also among
the world’s top 10 largest exporters of total oil products.
Proven oil reserves: 97.8. Total oil supply in 2012 (thousand barrels per day): 3,213.2
Enhanced oil recovery techniques continue to underpin strong crude oil production totals and are
an important strategy for extending the life of the country’s aging oil fields, states EIA.
8. RUSSIA
Proven oil reserves: 80. Total oil supply in 2012 (thousand barrels per day): 10,397
Russia, which also holds the world’s largest natural gas reserves and the second-largest coal
reserves, is the second biggest oil supplier in the world after Saudi Arabia.
9. LIBYA
Proven oil reserves: 48.01. Total oil supply in 2012 (thousand barrels per day): 1,483
The holder of Africa’s largest proven oil reserves, Libya saw a disruption in oil production due
to conflict, but the country has recovered, and subsequently, has begun to increase supplies.
10. NIGERIA
Proven oil reserves: 37.2. Total oil supply in 2012 (thousand barrels per day): 2,524.1
Nigeria’s hydrocarbon resources are the mainstay of the country’s economy, but EIA states that
development of the sector is often constrained by instability in the Niger Delta.
24
Government Initiatives
Some of the major initiatives taken by the Government of India to promote oil and gas sector are:
The Government of India plans to merge state oil companies to create an integrated oil
major that could compete globally, and utilise the synergy between various state entities
for achieving efficiency and cost competitiveness in order to create more value for all
shareholders.
The Government of India plans to unveil a new policy for renewing and extending the
lease of 28 oil and gas blocks in the country, with a view to attract more investments into
these fields.
The Cabinet Committee on Economic Affairs, Government of India, has approved the
awarding of contracts on 23 onshore and 8 offshore contract areas of discovered small oil
and gas fields that earlier belonged to Oil and Natural Gas Corporation (ONGC) and Oil
India Limited (OIL).
India and Russia have agreed to enhance their bilateral engagement by signing three
Memorandum of Understanding (MoU) on October 15, 2016 for co-operation in the field
of hydrocarbons sector during the India-Russia Annual Summit held at Goa.
The Ministry of Mines plans to restart operations in several hundred mines across the
country in order to raise the share of mining and quarrying industry in India’s Gross
Value Addition (GVA) by one percentage point from 2.4 per cent at present, over the
next two-to-three years.
The Union Cabinet has approved the National Mineral Exploration Policy (NMEP),
which will pave the way for auction of 100 prospective mineral blocks to attract private
sector in exploration, besides involving state-run agencies.
25
Energy consumption pattern by source wise
World energy consumption is the total energy used by the entire human civilization.
Typically measured per year
It involves all energy harnessed from every energy source applied towards humanity's
endeavours across every single industrial and technological sector,
Institutions such as the International Energy Agency (IEA), the U.S. Energy Information
Administration (EIA), and the European Environment Agency record and publish energy
data periodically.
Improved data and understanding of World Energy Consumption may reveal systemic
trends and patterns,
26
Market Share of Oil and Gas
Companies
11% 1%
IOCL
28%
18% ONGC
OPEC Countries
Iraq, Kuwait, Saudi Arabia and Venezuela. The five Founding Members were later joined
by ten other Members:
27
Those Countries are
1) Saudi Arabia
2) Iran
3) Iraq
4) Kuwait
5) Venezuela
6)Qatar
7)Indonesia
8)Libya
10)Algeria
11)Nigeria
12)Angola
Upstream" and "downstream" are business terms applicable to the production processes.
Industries that commonly use this terminology include the metals industry, oil, gas,
biopharmaceutical and biotechnology industries.
Upstream, downstream and midstream make up the stages of the production process for
these and other industries.
Upstream
The upstream stage of the production process involves searching for and extracting raw
materials.
28
The upstream part of the production process does not do anything with the material itself,
such as processing the material.
Thus, any industry that relies on the extraction of raw materials commonly has an
upstream stage in its production process.
In the petroleum industry, locating underground or underwater oil reserves characterizes the
upstream process. Additionally, the upstream process in this industry involves bringing oil and
gas to the surface.
Downstream
The downstream stage in the production process involves processing the materials
collected during the upstream stage into a finished product.
The downstream stage further includes the actual sale of that product to other businesses,
governments or private individuals.
The type of end user will vary depending on the finished product.
In the oil and gas industry, the downstream process consists of converting crude oil into other
products and then selling those products to customers. Thus, oil refineries represent structures
that operate within the downstream process.
29
Oilfields (Regulation and Development) Act, 1948
• Basic enabling statute for licensing and leasing of petroleum and gas blocks by the
appropriate government. Covers mineral oils which are defined as including natural gas
and petroleum [S.3(c)]. Mining lease is defined exhaustively to cover all forms of
exploring and exploiting mineral oils and all purposes connected thereto [S.3(d)]
• Empowers central government to make rules with regard to mining leases [S.5]
• Also empowers central government to make rules for the development of mineral oil
• The law deals with the acquisition of land for Public purpose. The Act is a general Act
which deals with the procedure and the conditions under which a land can be acquired.
• The only requirement is that the land can only be acquired for public purpose as per
Section 3(f) of the Act.
• The act deals with import, transport, storage, production, refining, and blending of
petroleum. The Act is one of the oldest acts in the oil and gas sector. Earlier to this act the
rules regarding the above specified activities were separate for separate States.
• The Petroleum Minerals Pipelines (Acquisition of Right of users in Land) Act, 1962
The global oil and gas industry is in the midst of one of the severest downturns in 30
years, as the perfect storm of overproduction and geopolitical tensions have seen oil prices
plunge. However, the fact remains that the industry has produced some of the largest companies
in known history.
30
Top 10 oil and gas companies in the world
31
Oil & Gas Industry in India
Oil supply and demand in India
Oil consumption is estimated to expand at a CAGR of 3.3 per cent during FY2008–16E to reach
4.0 mbpd by 2016
Due to the expected strong growth in demand, India’s dependency on oil imports is likely to
increase further
Rapid economic growth is leading to greater outputs, which in turn is increasing the demand of
oil for production and transportation
32
Conclusion:
• The Indian oil and gas sector is one of the six core industries in India and has very
significant forward linkages with the entire economy. Government has taken many steps
to regulate it. The Steps are also taken to increase the Indigenous oil and gas reserves.
• Although there are few loopholes which should be taken care of as soon as possible, one
major drawback in the E&P sector is that the Regulatory Body (DGH) does not have any
statutory value. The decisions of the DGH are merely advisory in nature and the
Government is not to follow them.
33
CHAPTER-III
PROFILE OF ONGC LIMITED
Introduction:
Maharatna ONGC is the largest producer of crude oil and natural gas in India,
contributing around 70 per cent of Indian domestic production.
The crude oil is the raw material used by downstream companies like IOC, BPCL, HPCL
to produce petroleum products like Petrol, Diesel, Kerosene, Naphtha, Cooking Gas-LPG
ONGC is India’s Top Energy Company and ranks 20th among global energy majors
(Platts).
ONGC ranks 14th in ‘Oil and Gas operations’ and 220th overall in Forbes Global 2000.
Acclaimed for its Corporate Governance practices, Transparency International has ranked
ONGC 26th among the biggest publicly traded global giants.
It is one of the most valued public enterprise in India, and one of the highest profit-
making and dividend-paying.
ONGC has a unique distinction of being a company with in-house service capabilities in
all areas of Exploration and Production of oil & gas and related oil-field services.
Winner of the Best Employer award, a dedicated team of over 33,927 professionals toil
round the clock in challenging locations.
Its wholly-owned subsidiary ONGC Videsh Limited (OVL) is the biggest Indian
multinational in the energy space,
34
Vision and mission
Vision
To be global leader in integrated energy business through sustainable growth, knowledge
excellence and exemplary governance practices.
Mission
World Class
Dedicated to excellence by leveraging competitive advantages in R&D and technology with
involved people.
Imbibe high standards of business ethics and organizational values.
Abiding commitment to safety, health and environment to enrich quality of community life.
Foster a culture of trust, openness and mutual concern to make working a stimulating and
challenging experience for our people.
Strive for customer delight through quality products and services.
35
ONGC Organogram:
36
History of ONGC
1947 – 1960
During pre-independence, the Assam Oil Company in the North-Eastern and Attack Oil
company in North-Western part of undivided India
Until 1955, private oil companies mainly carried out exploration of hydrocarbon
resources of India.
In 1955, Government of India decided to develop the oil and natural gas resources in the
various regions of the country as part of Public Sector development.
With this objective, an Oil and Natural Gas Directorate was set up in 1955 under the then
Ministry of Natural Resources and Scientific Research.
1961 – 1990
37
After 1990
After the conversion of business of the erstwhile Oil & Natural Gas Commission to that
of Oil & Natural Gas Corporation Limited in 1993, the Government disinvested 2 per
cent of its shares through competitive bidding.
Subsequently, ONGC expanded its equity by another 2 per cent by offering shares to its
employees.
Exploration
Discovered six out of seven producing Basins in India. Located 8.78 billion tonnes of Oil & Oil
Equivalent in Indian Basins with over 400 discoveries
ONGC is the largest exploration acreage and mining lease holder in India
83% of established reserves (out of 10.9 BT) in the country has been discovered by ONGC.
Reserve Replenishment Ratio (RRR) for the last ten years has been more than One (3P
Reserves)
38
Production
ONGC has been able to arrest decline in majority of its matured fields (of vintage 30-50 years)
that contribute 72% of the company’s O+OEG production through its majorly successful
technology-intensive IOR and EOR.
1184 oil wells and 151 gas wells in offshore and 4735 oil wells and 606 gas wells in onshore as
on April 1, 2015
Western Offshore production up by 7.5% (16.20 MMT in FY’15 against 15.54 MMT in FY’14)
ONGC accounts 69% of Crude oil & 70% of Natural Gas production
Arrested decline in 14 major fields producing for over 30 years, vis-a-vis global decline rate of
7% from matured fields
Competitive strength
All crudes are sweet and most (76%) are light, with sulphur percentage ranging from 0.02-0.10,
API gravity range 26°-46° and hence attract a premium in the market.
Maximum number of Exploration Licenses, including competitive NELP rounds. ONGC has
bagged 121 of the 235 Blocks (more than 50%) awarded in the 8 rounds of NELP.
ONGC owns and operates more than 26,600 kilometers of pipelines in India, including sub-sea
pipelines. No other company in India operates even 50 per cent of this route length
39
Corporate social responsibility
In recognition of its role as a 'responsible leader', ONGC continues its quest to make
positive, tangible difference in the lives of the vulnerable and disadvantaged, especially in and
around its operational areas. With a business paradigm that is based on an interconnected vision -
of people's welfare, societal growth and environmental conservation, ONGC continues to cater to
the developmental needs across the following focus areas:
ONGC bags ICC PSE Excellence Awards 2015 in multiple categories -07 July 2016
ONGC receives Bhamashah Award for setting up Smart Classes -02 July 2016
Former Director U N Bose gets Outstanding Achievement Award for E&P contributions
ONGC receives Scope Excellence award from Hon’ble President -11 April 2016
40
Financial And Operation Highlights Of Company
Operation Highlights
41
Financial Highlights
42
Company Presence , Locations, Branches
43
ASSETS/ PLANTS BASINS INSTITUTES
44
SWOT Analysis for ONGC
45
CHAPTER- IV
THEORETICAL FRAMEWORK OF RATIO ANALYSIS
Financial statements contain many information (figures) relating to profit or loss and
financial position of the business.
Ratio analysis is used to evaluate various aspects of a company’s operating and financial
performance such as its efficiency, liquidity, profitability and solvency.
The trend of these ratios over time is studied to check whether they are improving or
deteriorating.
Ratio is used to describe significant relationships which exist between figures shown in a
balance sheet, in a profit and loss account or in any other part of the accounting
organization.
“ratio analysis is largely a study of relationship among the various financial factors in
business as disclosed by a single set of statements and a study of the trend of these factors as
shown in a series of statements.
- MYRERS
46
Nature of the Ratio Analysis
a) External Analysis :-It is made by those who do not have access to the detailed
records of the company, this group, which has to depend almost entirely on published
financial statements, includes investors, credit agencies and governmental agencies
regulating a business in nominal way. The position of the external analyst has been
improved in recent times owing to the governmental regulations requiring business
undertaking to make available detailed information to the public through audited
accounts.
d) Vertical Analysis:-It is frequently used for referring to ratios developed for one date
or for one accounting period. Vertical analysis is also called ‘Static Analysis’. This is not
very conducive to proper analysis of the firm’s financial position and its interpretation as
it does not enable to study data in perspective. This can only be provided by a study
conducted over a number of years so that comparisons can be affected. Therefore,
vertical analysis is not very useful.
47
Objectives of Ratio Analysis
Ratio Analysis is very much helpful in assessing the financial position and profitability of
a concern. The man objectives of analyzing the financial statements are as follows.
1. The comparative study in regard to one firm with another firm or one department with
another department is possible by the analysis of financial statements.
2. Analysis of past results in respects of earning and financial position of the enterprise is of
great help in forecasting the future results. Hence it helps in preparing budgets.
4. The analysis would enable the present and the future earning capacity and the
profitability of the concern.
5. The operational efficiency of the concern as a whole as well as department wise can be
assessed. Hence the management can easily locate the areas of efficiency and
inefficiency.
6. The solvency of the firm, both short-term and long-term, can be determined with the help
of financial statement analysis which is beneficial to trade creditors and debenture
holders.
7. The long-term liquidity position of funds can be assessed by the analysis of financial
statements.
The trend in costs, sales, profits and other facts can be known by computing ratios of
relevant accounting figures of last few years. This trend analysis with the help of ratios may be
useful for forecasting and planning future business activities.
48
2. Budgeting:
ratios help to estimate budgeted figures. For example, sales budget may be prepared with the
help of analysis of past sales.
assets. Different activity ratios indicate the operational efficiency. In fact, solvency of a firm
depends upon the sales revenues generated by utilizing its assets.
4. Communication:
Ratios are effective means of communication and play a vital role in informing the
position of and progress made by the business concern to the owners or other parties.
6. Inter-firm Comparison:
Comparison of performance of two or more firms reveals efficient and inefficient firms,
thereby enabling the inefficient firms to adopt suitable measures for improving their efficiency.
The best way of inter-firm comparison is to compare the relevant ratios of the organisation with
the average ratios of the industry.
firm. Liquidity ratios indicate the ability of the firm to pay and help in credit analysis by banks,
creditors and other suppliers of short-term loans.
49
8. Signal of Corporate Sickness:
A company is sick when it fails to generate profit on a continuous basis and suffers a
severe liquidity crisis. Proper ratio analysis can give signal of corporate sickness in advance so
that timely measures can be taken to prevent the occurrence of such sickness.
9. Aid to Decision-making:
Ratio analysis helps to take decisions like whether to supply goods on credit to a firm,
whether bank loans will be made available etc.
health of a firm. But it has some limitations which must not be lost sight of before undertaking
such analysis.
financial statements suffer from a number of limitations and may, therefore, affect the quality of
ratio analysis.
2. Historical Information:
Financial statements provide historical information. They do not reflect current
conditions. Hence, it is not useful in predicting the future.
50
3. Different Accounting Policies:
Different accounting policies regarding valuation of inventories, charging depreciation
etc. make the accounting data and accounting ratios of two firms non-comparable.
be ideal if current assets are twice the current liabilities. But this conclusion may not be
justifiable in case of those concerns which have adequate arrangements with their bankers for
providing funds when they require, it may be perfectly ideal if current assets are equal to or
slightly more than current liabilities.
5. Quantitative Analysis:
Ratios are tools of quantitative analysis only and qualitative factors are ignored while
computing the ratios. For example, a high current ratio may not necessarily mean sound liquid
position when current assets include a large inventory consisting of mostly obsolete items.
6. Window-Dressing:
The term ‘window-dressing’ means presenting the financial statements in such a way to
show a better position than what it actually is. If, for instance, low rate of depreciation is
charged, an item of revenue expense is treated as capital expenditure etc. the position of the
concern may be made to appear in the balance sheet much better than what it is. Ratios computed
from such balance sheet cannot be used for scanning the financial position of the business.
51
9. Ratios Account for one Variable:
Since ratios account for only one variable, they cannot always give correct picture since
several other variables such Government policy, economic conditions, availability of resources
etc. should be kept in mind while interpreting ratios.
business. For example, an umbrella company maintains high inventory during rainy season and
for the rest of year its inventory level becomes 25% of the seasonal inventory level. Hence,
liquidity ratios and inventory turnover ratio will give biased picture.
Types of Ratios
. • Liquidity ratio
.
• Leverage ratio
. • Activity ratio.
. • Profitability ratio.
52
Short term solvency position of ONGC:/Liquid ratios
Liquidity ratio refers to the ability of a firm its obligation in the short run, usually one
year. The short – term obligations are met by realizing amounts from current, floating or
circulating assets. Liquidity ratios are generally based on the relationship between current assets
and current liabilities. The sufficiency or insufficiency of current assets should reassessed by
comparing them with current liabilities.
The important liquidity ratios are
Current ratio
Quick ratio
Absolute ratio
Liquidity
ratio
Absolute
Current ratio Quick ratio
ratio
CURRENT RATIO
Current ratio is an indicator of the firm’s commitment of its short term liabilities. This
ratio is an index of the concern financial stability since it show the extent of the working capital
which is derived by the current assets with the current liabilities.
Current Assets
Curent Ratio =
Current Liabilities
53
Advantages of the Current Ratio
It often tells how fast the products sell, thus the company can optimize its production.
Companies with fast selling products, that is, one with a high Current ratio figure, can
utilize the just-in-time production system,
A product may sell fast, but it may generate large losses to the company.
It does not tell whether the production cost are too high, or sales prices are too low, or
possibly a combination of the two.
Standard ratio: - According to accounting principles, a current ratio of 2:1 are supposed to
be an ideal ratio.
It means that current assets of a business should, at least, be twice of its current
liabilities. The higher ratio indicates the better liquidity position; the firm will be able to pay its
current liabilities more easily. If the ratio is less than 2:1, it indicates lack of liquidity and
shortage of working capital.
QUICK RATIO
Quick ratio is also termed as acid ratio. Current assets include inventories and prepaid
expenses which are not easily convertible into cash within a short period. If an asset is liquid it
can be converted into cash immediately or reasonably soon without a loss of value. It measures
the firm’s capacity to pay off current obligations immediately and is more rigorous test of
liquidity than current ratio.
54
Standard ratio: - An ideal quick ratio is said to be 1:1. If it is more, it is considered to be
better. This ratio is a better test of short-term financial position of the company.
55
Debt – equity ratio
Debt ratio
Capital gearing ratio
Interest – coverage ratio
Proprietary ratio
Inventories to net working capital
LEVERAGE
RATIOS
Capital Inventories to
net working
gearing ratio capital
It measures the ratio of Long-term debt to share holder’s funds. Idle Ratio usually
recommended is 2:1 As such if the debt is less than two times the equity. The logical conclusion
is that the financial structure of the concern is sound. On the other hand if the debt is more than
two times the equity, the conclusion is the financial structure of the undertaking is weak.
56
Standard ratio
It measures the ratio of Long-term debt to share holder’s funds. Idle Ratio usually
recommended is 2:1 As such if the debt is less than two times the equity. The logical conclusion
is that the financial structure of the concern is sound. On the other hand if the debt is more than
two times the equity, the conclusion is the financial structure of the undertaking is weak.
DEBT RATIO
Debt ratio analysis is the long term solvency of a firm. It indicates the preparation of the
interest being debt in the capital structure.
Total Debt
Debt Ratio =
Net Assets
Total Debt Includes
Short and long term borrowings from financial institutions, debentures / bonds deferred
payment for buying capital equipments, bank borrowings public deposits and any other interest
bearing loans. (Secured and UN secured loans)
PROPRIETARY RATIO
It indicates the extent to which assets are financed by owner’s funds. The ratio
established the relationship between shareholders funds and the total assets of the firm. The ratio
of proprietor’s funds to total funds is an important ratio for determining long term solvency of a
firm.
57
Standard ratio
This ratio should be 33% or more than that. A higher proprietary ratio is generally treated an
indicator of sound financial position from long-term point of view, because it means that the firm
is less dependent on external sources of finance.
If the ratio is low, it indicates that long-term loans are less secured and they face the risk
of losing their money.
58
Debtor’s turnover ratio
Working capital turnover ratio
Capital turnover ratio.
Fixed assets turnover ratio
Total assets turnover ratio
Accounts receivable turnover ratio or debtor’s turnover ratio indicates the number of
times the debtors are turned over a year.
The higher the value of debtor’s turnover the more efficient is the management of
debtors or more liquid the debtors are.
59
Similarly, low debtors turnover ratio implies inefficient management of debtors or less
liquid debtors.
It is the reliable measure of the time of cash flow from credit sales.
Net Sales
Working Capital Turnover Ratio =
Working Capital
Significance
The working capital turnover ratio measures the efficiency with which the working
capital is being used by a firm. A high ratio indicates efficient utilization of working capital and
a low ratio indicates otherwise. But a very high working capital turnover ratio may also mean
lack of sufficient working capital which is not a good situation
Net Sales
Capital Turnover Ratio =
Capital
60
TOTAL ASSETS TURNOVER RATIO
Total assets turnover ratio is also known as sales to total assets ratio. This ratio measures
the efficiency and profit earning capacity of the concern. Higher the ratio, greater is the intensive
utilization of fixed assets. Lower ratio means under utilization of fixed assets.
Net Sales
Total Assets Turnover Ratio =
Total Assets
Net Sales
Fixed Assets Turnover Ratio =
Fixed Assets
Significance: -
This ratio is particular importance in manufacturing concerns where the investment in
fixed asset is quit high. Compared with the previous year, if there is increase in this ratio, it will
indicate that there is better utilization of fixed assets. If there is a fall in this ratio, it will show
that fixed assets have not been used as efficiently, as they had been used in the previous year.
61
Net profit ratio
Operating profit ratio
Earning per ratio
Rate of return on investment
Return on shareholders’ equity
Net Profit
Net Profit Ratio = X 100
Net Sales
Significance:
NP ratio is used to measure the overall profitability and hence it is very useful to
proprietors. The ratio is very useful as if the net profit is not sufficient, the firm shall not be able
to achieve a satisfactory return on its investment.
This ratio also indicates the firm's capacity to face adverse economic conditions such as
price competition, low demand, etc. Obviously, higher the ratio the better is the profitability. But
while interpreting the ratio it should be kept in minds that the performance of profits also is seen
in relation to investments or capital of the firm and not only in relation to sales.
62
Total earnings
Rate Of Return on Investments =
Capital Employed
Significance: - This ratio helpful in the determining of the market price of the equity share of
the company. The ratio is also helpful in estimating the capacity of the company to declare
dividends on equity shares.
63
CHAPTER-V
DATA ANALYSIS & INTERPRETATION
CURRENT RATIO
Current ratio is an indicator of the firm’s commitment of its short term liabilities. This
ratio is an index of the concern financial stability since it show the extent of the working capital
which is derived by the current assets with the current liabilities.
Current Assets
Curent Ratio =
Current Liabilities
64
Graph -5.1
CURRENT RATIO
3.54
1.74
1.56 1.57
1.31
Interpretation :
The Current ratio of ONGC Company is showed in Table 5.1 the current ratio
showed a decreasing trend during the study period of 2012-2013 to 2016-2017. The highest
value of current ratio is 3.54 in the year 2012-2013 and the lowest value of current ratio is 1.31
in the year 2016-2017. The average ratio is 1.94.The ideal norm of current ratio is 2:1. The ratio
showed good sign in the year 2012-2013 only.
65
QUICK RATIO
Graph- 5.2
QUICK RATIO
2.8
1.41
1.25 1.26
1.04
66
ABSOLUTE LIQUID RATIO
Absolute Liquid Assets
Absolute Liquid Ratio =
Current Liabilities
Graph – 5.3
ABSOLUTE RATIO
1.84
0.75
0.56
0.47
0.14
Interpretation
The Absolute Liquidity Ratio of ONGC Ltd. is showed in Table 5.3. The Absolute Liquidity
Ratio shows a decreasing trend from 1.84 in 2012-13 to 0.47 in the year 2016-17. The average
ratio showed during the study period is 0.75.The standard ratio of Absolute liquidity is 0.75:1.
From the above observation, The Absolute liquidity of ONGC Ltd reaches the standard, so it is a
good sign. But for the year between 2014-15 to 2016-17 the ratio is less than the standard ratio.
67
DEBT – EQUITY RATIO
Graph- 5.4
0.3
0.29 0.29
Interpretation
From the above table 5.4,Debt equity Ratio of ONGC ltd from 2012-13 to 2016-17. The
trend of the ratio is in fluctuating trend. The highest value of the ratio is 0.31 in the year 2014-15
and 2016-17.lowest value of the ratio is 0.29 in the year 2012-13 and 2013-14. The average
value of the ratio is 0.30.
68
DEBT RATIO
Total Debt
Debt Ratio =
Net Assets
Graph – 5.5
Debt Ratio
0.4
Interpretation
The above table 5.5 shows Debt Ratio of ONGC ltd from 2012-13 to 2016-17. The trend of the
ratio is in fluctuating trend. The highest value of the ratio is 0.40 in the year 2012-13 lowest
value of the ratio is 0.33 in the year 2013-14 and 2015-16. The average value of the ratio is 0.35.
69
PROPRIETARY RATIO
Graph- 5.6
Proprietary Ratio
0.69 0.69 0.69
0.68
0.65
The above table 5.6 shows Proprietary Ratio of ONGC ltd from 2012-13 to 2016-17.
The trend of the ratio is in fluctuating trend. The highest value of the ratio is 0.69 in 3 years.
lowest value of the ratio is 0.65 in the year 2012-13. The average value of the ratio is 0.68. i.e.,
more than the standard ratio. So we can conclude that ONGC is financially sound in long term
point of view.
70
INVENTORY TO WORKING CAPITAL RATIO
Inventory
Inventory to Working Capital ratio =
net working capital
Graph – 5.7
Interpretation
The above table 5.7 shows Inventory to Working Capital ratio of ONGC ltd from 2012-
13 to 2016-17. The trend of the ratio is in increasing trend. The highest value of the ratio is 0.86
in 2016-17. lowest value of the ratio is 0.44 in the year 2013-14. The average value of the ratio is
0.59.
71
DEBTORS TURNOVER RATIO
Net Credit Sales
Debtors Turnover Ratio =
Average Debtors
Graph- 5.8
15.61
11.71 11.04
7.71 8.3
Interpretation :
The above table 5.8 shows the analysis of Debtors Turnover Ratioof ONGC ltd. during
the study period from 2012-13 to 2016-17. The analysis of Debtors Turnover Ratio showed
andecreasing trend for the first year and then next year showed increasing trend and then after
decreasing trend. The highest value of the ratio is 15.61 in the year 2015-16 and lowest value of
the ratio is 7.71 in the year 2014-15.
72
WORKING CAPITAL TURNOVER RATIO
Net Sales
Working Capital Turnover Ratio =
Working Capital
Table – 5.9 (Rs. In millions)
YEARS 𝐍𝐞𝐭 𝐒𝐚𝐥𝐞𝐬 𝐖𝐨𝐫𝐤𝐢𝐧𝐠 𝐂𝐚𝐩𝐢𝐭𝐚l RATIO
2012-13 765151 100846 7.58
2013-14 830053 129529 6.40
2014-15 838903 107635 7.80
2015-16 828710 109898 7.54
2016-17 783681 65788 11.91
SOURCE: Annual Reports and accounts of the ONGC Co. Ltd. from 2012-13 to 2016-17
Graph – 5.9
11.91
Interpretation:
The above table 5.9 shows Working Capital turnover ratio of ONGC ltd from 2012-13 to
2016-17. The trend of the ratio is in fluctuating trend. The highest value of the ratio is 11.91 in
2016-17. Lowest value of the ratio is 6.4 in the year 2013-14. The average value of the ratio is
8.24.
73
CAPITAL TURNOVER RATIO
Net Sales
Capital Turnover Ratio =
Capital
Table – 5.10 (Rs. In millions)
YEARS 𝐍𝐞𝐭 𝐂𝐫𝐞𝐝𝐢𝐭 𝐒𝐚𝐥𝐞𝐬 𝐂𝐚𝐩𝐢𝐭𝐚𝐥 RATIO
2012-13 765151 1460797 0.52
2013-14 830053 1606528 0.52
2014-15 838903 1802086 0.46
2015-16 828710 1889064 0.43
2016-17 783681 1892680 0.44
SOURCE: Annual Reports and accounts of the ONGC Co. Ltd. from 2012-13 to 2016-17
Graph – 5.10
0.52 0.52
0.46 0.44
0.43
Interpretation:
The capital turnover ratio of ONGC Company is showed in Table 5.10 the capital
turnover ratio showed a fluctuating trend during the study period of 2012-2013 to 2016-2017.
The highest value of capital turnover ratio is .052 in the year 2013-2014 and the lowest value of
capital turnover ratio is 0.43 in the year 2015-2016. The average ratio is 0.46.. The ratio showed
good sign in the year 2012-2013 and 2013-14.
74
TOTAL ASSETS TURNOVER RATIO
Net Sales
Total Assets Turnover Ratio =
Total Assets
Graph – 5.11
0.44 0.46
0.42 0.4
0.36
Interpretation
The above table shows Total Assets Turnover Ratio of ONGC ltd from 2012-13 to 2016-
17. The Total Assets Turnover Ratio showed decreasing trend in last four years from 2013-
2014 to 2016-17 and in starting two year showed an increasing trend. The highest value 0.46 in
the year 2013-14.The lowest value 0.36 in the year 2016-17. The average ratio of selected
company during the study period is 0.416.
75
FIXED ASSETS TURNOVER RATIO
Net Sales
Fixed Assets Turnover Ratio = Fixed Assets
Graph – 5.12
0.8 0.79
0.69 0.653
0.57
The above table 5.12 shows Fixed Assets Turnover Ratio of ONGC ltd from 2012-13 to
2016-17. The Fixed Assets Turnover Ratio showed decreasing trend in last five years from
2012-2013 to 2016-17. The highest value 0.80 in the year 2012-13.The lowest value 0.57 in the
year 2016-17. The average ratio of selected company during the study period is 0.70.
76
NET PROFIT RATIO
Net Profit
Net Profit Ratio = X 100
Net Sales
Table – 5.13 (Rs. In millions)
YEARS 𝐍𝐞𝐭 𝐏𝐫𝐨𝐟𝐢𝐭 𝐍𝐞𝐭 𝐬𝐚𝐥𝐞𝐬 RATIO
2012-13 251230 765151 32.8%
2013-14 209257 830053 25.2%
2014-15 220948 838903 26.3%
2015-16 177330 828710 21.3%
2016-17 160036 783681 20.4%
SOURCE: Annual Reports and accounts of the ONGC Co. Ltd. from 2012-13 to 2016-17
Graph – 5.13
25.20% 26.30%
21.30% 20.40%
77
RATE OF RETURN ON INVESTMENT
Total earnings
Rate Of Return on Investments =
Capital Employed
Graph – 5.14
19% 17.90%
14%
11%
Interpretation
From the above table shows the return on investment ratio of ONGC ltd. during the study
period from 2012-13 to 2016-17. The return on investment ratio is showed in decreasing trend
during the study period. The highest value of the ratio is 25% in the year 2012-13 and the lowest
value of the ratio is 11% in the year 2016-17. The average of the ratio is 17.38%.
78
EARNINGS PER SHARE (E.P.S.)
profit after tax −Dividend on Preference Shares
Earnings Per Share =
No.of Equity Shares
Graph – 5.15
79
CHAPTER-VI
FINDINGS
The current ratio of The Oil and Natural Gas Corporation Ltd, Rajamundry is less than the
norm 2:1 from 2013-14 to 2016-17. It means that the short term solvency position of the
company is not at good sign.
In General, the quick ratio has been representing the standard norm of 1:1. The short term
solvency position regarding the quick ratio of this company during the period 2012-13 is
satisfying the standard norm. It means that The Oil and Natural Gas Corporation Ltd,
Rajamundry, performance of liquidity position is in good sign.
Absolute Liquid Ratio was less than the standard i.e., 0.75:1. It was decreased due to lower
profit. Working Capital funds were not invested properly and not utilized well for the sake
of the company. Therefore company is advised to not invest its liquid fund on long term
assets.
The net profit of Oil and Natural Gas Corporation Ltd, Rajamundry is declined due to the
excess payments of indirect expenditure.
The debtor’s turnover ratio during 2012-13 to 2016-17 was fluctuating. There was a
decreasing trend in this ratio which indicated that the credit facility allowed by the company
was not properly utilized by the customers. The decreasing trend is because of two reasons:
decrease in debtors and increase in cash sales. This impacted the debtor’s turnover.
The inventory to working capital ratio was not good during the study period. Due to high
value of inventory there is insufficient coverage of working capital in the company.
Therefore, an immediate increase in sales or additional capital into the company is necessary
in order to continue its operations.
80
It must be carefully planned as it affects the company’s capacity to maintain a uniform
dividend policy during difficult trading periods. It reveals the suitability of company’s
capitalization.
The proprietary ratio of the company showed fluctuating trend during in the span of study
period, which meant that the company was using outsider’s liability in the total assets.
As the net profit is declining from year to year and is represents low inventory turnover.
The cash turnover ratio explains the speed with which cash is turned over. The higher the
turn over, the less the cash balances required for any given level of sales; and other things
remaining constant, it implies greater efficiency.
81
SUGGESTIONS
It is suggested that the company has make investments on current assets to strengthen short
term solvency and to meet the short term creditor’s position regarding their Maintenance of
adequate liquidity throughout the future
.
The company has provided credit facility and it was not properly utilized by the customers.
Therefore, the company has faced the problem of inadequacy of working capital.
EBIT should be improved for the purpose of improving debt service coverage.
It is suggested to ONGC Ltd to decrease debt equity volume because it is going to get greater
risk.
It is suggested that ONGC Ltd should increase the usage of existing fixed assets with full of
extent to get maximum profitability
The finished goods turnover ratio of the Company is fluctuated and not up to the mark. It is
suggested that the company has to increase the cost of goods sold.
It is suggested that the management should try to utilize their production capacity fully in
order to reduce factory overheads and to utilize their fixed assets properly.
To strengthen the financial efficiency, long-term funds have to be used to finance core
current assets and a part of temporary current assets. It is better if the company can reduce
the over sized short- term loans and advances eliminates the risk arranging finance regularly.
82
CONCLUSION
I have done my project in Oil and Natural Gas Corporation Ltd, Rajamundry. I have
made an analysis of the overall financial position of the company. My focus of attention was in
the areas of Liquidity, Profitability, and analysis of receivables and cash management. Through
the analysis, I observed some findings and for which I have made few suggestions which will
help the company for the maintenance of adequate liquidity position in the company to make
progress in its activities and thus to reach its goal.
83
BIBLIOGRAPHY
Books
WEBSITES
www.google.com
www.moneycontrol.com
84