Financial Analysis Project 1
Financial Analysis Project 1
Financial Analysis Project 1
Financial
Ananlysis
National Refinery Limited.
Farman Ali
1
Financial Analysis of NRL
FIANANCIAL ACCOUNTING
INSTRUCTOR: ANNIE AHMAD
FARMAN ALI
Contents
Overview of the Industry...................................................................................3
National Refinery Limited.................................................................................4
LIQUIDITY RATIOs...........................................................................................5
1) Current Ratio:...............................................................................................5
2) Quick Ratio:.................................................................................................6
PROFITABILITY RATIOs:.................................................................................6
Gross Profit Margin:..........................................................................................6
Net Profit Margin:.............................................................................................7
Return on Total Assets:.....................................................................................8
Return on Common Equity:...............................................................................9
MARKET VALUE RATIOs:.............................................................................10
Market to Book Ratio:.....................................................................................10
2
Financial Analysis of NRL
3
Financial Analysis of NRL
thousand barrels per day (mbd) in 2019 to 1,214 mbd in 2023, according to a
report by Global data.
In addition to this, six more oil refineries are at different stages of completion to
boost up the crude oil refining capacity by 5 % with Government offering them
‘unprecedented’ incentives to downstream sector to meet growing energy
demand.
Our Focal Company for this analysis is National (Six new refineries to boost oil
production by 1.1mln barrels/day, 2021) Refinery Limited and its competitors
are Attock Refinery Limited, Pakistan Refinery Limited and BYCO Petroleum
Limited.
National Refinery Limited (NRL) was formed on 19th August 1963 as a public
Limited company. As per the Economic Reforms Order, 1972 under the
Ministry of Production, Government of Pakistan took over the control of it. It
has the second largest capacity refinery in Pakistan in terms of crude oil
processing facilities and only lube oil refinery present in Pakistan.
Many products are offered by National Refinery to meet the rising demand of
people and the country. However, it specializes in Naphtha, Jet A-1, and
Liquefied Petroleum Gas (LPG). Since it’s a refinery so crude oil is refined and
made usable to be consumed.
Refinery is constantly working to improve the existing plant so increase the
production and efficiency and for those two projects are in consideration which
are Hydrocracker and CCR
4
Financial Analysis of NRL
5
Financial Analysis of NRL
LIQUIDITY RATIOs
Liquidity ratios measure ability of a company to pay off short-term liabilities.
Most commonly used two liquidity ratios are as under:
1) Current Ratio:
Current ratio measures whether a company has enough current assets to pay off
its short-term financial obligations.
TREND ANALYSIS:
National Refinery Limited: Current ratio decreases 20% in 2017 as compared
to 2016, this can be explained by looking at the vertical analysis. There is a
decrease of 36.6% in current asset but there is only 5% decrease in current
liabilities. In 2018 we can se a
sudden decrease of 26.08% in 2017 2018 2019 2020 2021
current ratio, as we can see 1.84 1.36 1.24 0.89 0.65
that decrease in current asset
and current liabilities was Current Rati o
18.8% and 3% respectively in 2.00
Current Ratio
1.50
vertical analysis. Further in 1.00
0.50
2019 the graph continues to 0.00
decline which was a result of 2017 2018 2019 2020 2021
Years
8.8% decrease in current ratio.
This decline can be explained
Industry average National Refinary
by looking at vertical analysis
figures. There is a hike of 6.6% in current liabilities for 2019 because short
term debts have been secured to meet short term funding requirements through
running finance under mark-up arrangements.
The decreasing trend continues in 2020 and 2021 as the current ratio decreases
to 0.89 and 0.65 respectively. Analyzing the vertical analysis we conclude that
the current liabilities increase 21.3% in 2020 and minor decrease of 3% in 2021
but there is 16% decrease in current assets.
Du to the pandemic the company borrowed short term loans to pay salaries to
the employees.
• The aggregate facilities for short term running finance available from
various banks amounted to Rs. 21.65 billion.
6
Financial Analysis of NRL
Overall trend for Current ratio is decreasing and there are major changes.
Although overall current assets decrease with successive years but at same time
current liabilities slightly decrease as well.
2) Quick Ratio:
Quick ratio determines ability of a company to meet current liabilities using
short term quick assets.
TREND ANALYSIS: 2017 2018 2019 2020 2021
1.00
of 0.45 in Quick ratio can be 0.50
observed in 2018. This is 0.00
2017 2018 2019 2020 2021
because of increase in Years
inventory and the company
took short term borrowing Industry Average National Refinary
PROFITABILITY RATIOs:
Gross Profit Margin:
TREND ANALYSIS:
National Refinery Limited: Trend is decreasing. GPM increase by 7.16% as
the price of crude oil was drastically lower as compared to 2016 and then
declines 2% in 2018 because
7
Financial Analysis of NRL
10.00%
1) Higher prices of crude oil and 5.00% Industry Average
0.00% 'National Refinery Lim-
continues devaluation of Pak -5.00%
20172018201920202021
ited'!
rupee against Us Dollar -10.00%
increased cost of sales. years
8
Financial Analysis of NRL
9
Financial Analysis of NRL
TREND ANALYSIS:
2017 2018 2019 2020 2021
National Refinery Limited:
Return on Common Equity 20.88% 18.56% 4.09% - -
(ROCE) increases Return On Common25.66% Equity13.62%
10
Financial Analysis of NRL
National Refinery Limited: Trend for earnings per share is same as that of net
profit margin as number share
2017 2018 2019 2020 2021
issued is same for 2017-2021 and
only net profit changes. EPS 96.14 100.61 22.14 (108.70) (50.82)
increase in 2017 then goes through Earning per Share
a slight increase in 2018. The 150
capitalization has decreased but the proportion by which net profit has declined
is way much higher and thus resulting in very high P/E ratio. Net profit in 2019
declines because:
1. Higher prices of crude oil and continues devaluation of Pak rupee against
Us Dollar increased cost of sales
12
Financial Analysis of NRL
TREND ANALYSIS:
National Refinery Limited: Dividend yield ratio trend is decreasing till
2019. This is due to the market
value per share is higher while the 2017 2018 2019 2020 2021
dividend per share is lower. 4.21 3.10 2.26 0.00 0.00
In 2020 and 2021 dividend yield
ratio is zero because the company Dividend Yield Ratio
did not paid dividends to its
Divident Yield Ratio
200000.00
shareholders. This was because the 150000.00 Industry Average
100000.00
company faced huge loss. 50000.00
'National Refinery Lim-
ited'!
0.00
2017 2018 2019 2020 2021
Years
13
Financial Analysis of NRL
14
Financial Analysis of NRL
2017 2018 2019 2020 2021
National Refinery
4.81 4.47 2.21 0 0
Limited:
As dividend cover is
reciprocal of dividend Dividend Cover
payout the pattern for 50000.00
Dividend Cover
0.00
trend is same but increase -50000.00 2017 2018 2019 2020 2021
and then decrease. Major -100000.00
-150000.00
decline can be seen in -200000.00
2019 due to same reasons Years
that contributed to rise in
dividend payout in 2019. Industry Average 'National Refinery Limited'!
20.00
0.00
0.29 between FY15 and FY17. 2017 2018 2019 2020 2021
-20.00
and increase was till FY 2021. -40.00
Total assets decreased by -60.00
8.93% while total debt Years
15
Financial Analysis of NRL
16
Financial Analysis of NRL
3.00
Turnover ratio sees major increase in 2.00
1.00
from 2017 to 2019. This is due to 0.00
increased in cost of sales and decreased -1.00 2017 2018 2019 2020 2021
-2.00
in inventory. During 2019 -3.00
Industry Average Years
National Refinary
Increase in cost of sales is 94% from base year i.e. from Rs. 141610.76 million
to Rs.133172.93 million. Due to Poor political scenario and depreciation of Pak
rupee cost of crude oil and other raw materials increased in the market. As a
result, piled up inventory is sold promptly due to which inventory decreases
leading to higher inventory turnover. However, in the FY 2020, the inventory
17
Financial Analysis of NRL
turnover ratio was balanced back to its average. In comparison to its previous
year, there was an inventory buildup which resulted into such a drop in this
figure for NRL and the company also incurred a loss of Rs. 8.69 billion due to
different economic pressures including lower demand for furnace oil that led to
a decline in its sales. (NRL, 2020) These pressures did not only affect NRL as
could be seen that the industry average also suffered due to lower demand,
government regulations and availability of alternate energy. BYCO’s inventory
turnover ratio also decreased from 7.18 to 6.36 this year.
ITO decreases because inventory during 2020 increases by around 33.7%. At
the same time cost of sales also increases by 17.8% in 2020.
18
Financial Analysis of NRL
Payable turnover
to 2021. The lowest payable 5.00 'Industry Averages'!
National Refinery Lim-
turnover ratio among the five 0.00 ited'!
2017 2018 2019 2020 2021
years was observed in FY 2017, -5.00
this is related to the fact that Yeaes
TREND ANALYSIS:
National Refinery Limited:
As shown in graph above the Total Assets Turnover of NRL is little bit higher
compared to that of Industry. This means that NRL is utilizing its total assets
more efficiently compared to most of the other companies in industry. Between
2016 and 2017 NRL purchased new Property, Plant and Equipment which
19
Financial Analysis of NRL
3.00
2.50
2.00 Industry Average
1.50 National Refinary
201.00
0.50
0.00
2017 2018 2019 2020 2021
yeras
Financial Analysis of NRL
21
Financial Analysis of NRL
REERENCES:
http://www.nrlpak.com/pdf/FinancialReport/2020-20/
NRL_AR_2021_High.pdf
http://www.nrlpak.com/pdf/FinancialReport/2019-19/
NRL_Annual_Reoprt_2020_HighFINAL.pdf
http://www.nrlpak.com/pdf/FinancialReport/2018-
18/National_Refinery_Limited_Annual_Report_2019_final.pdf
http://www.nrlpak.com/pdf/FinancialReport/2017-17/NRL-AR-2018-2-10-
2018.pdf
http://www.nrlpak.com/pdf/FinancialReport/2016-16/NRL_ANNUAL_RE
PORT_2017.pdf
22