Financial Analysis of Pakistan Refinery
Financial Analysis of Pakistan Refinery
Submitted by
Dr. Sehrish Illyas
DEPARTMENT OF MANAGEMENT SCIENCES
BBA-6th
2021-25
LAHORE COLLEGE FOR WOMEN UNIVERSITY, LAHORE
----------------------------------------------------------------------------------------------------
Prepared by
Khadija Khalid (40)
Sammar Nasir (59)
Jayesha Khan (37)
Laiba Nawaz (41)
Executive summary
Interpretation
Non- current assets show a growth according to trend except the right-of-use assets
which are showing the negative growth i.e., -12.12% and in all other years as well
but intangible assets shown a good performance in 2023.This intangible asset is
goodwill of company which are not much reduced. Current assets shown a good
performance accept short-term prepayments which is not a good signal but it
shows a increase in the receivable in large amount it means that assets is inventory
is converting to cash and this is positive sign because the company its receivables
this year. As a whole if we see our balance sheet than it shown that our assets our
increasing very fast and due to which receivable are increases. Total equity amount
is much more in 2022 as compared to all other years but decreased by almost 45%
which is not a good signal. Non-current liabilities show a decline means company
pay off their liabilities so that’s why company is showing a negative growth in
non-current liabilities current liabilities are in positive percentage but are less as
compare to previous year it means company pay off many current liabilities during
2022 to 2023. Total equity and liabilities show a positive growth but less then
previous year because last year liabilities are in positive growth so they increase
the percentage of total equity and liabilities and in this year, liabilities increase so
the percentage also increase which shows a not much good sign for company.
Horizontal Analysis of Income Statement
2023 vs 2022 vs 2021 vs
2022 2021 2020
Revenue from contracts with customers 36.87% 107.76% 1.72%
Cost of sales 48.83% 92.52% -6.38%
Gross Profit/(Loss) -63.99% 525.50% -174.19%
Distribution cost -100.00% 20.65% 29.20%
Selling Expenses 100.00% 0.00% 0.00%
Administration expenses 76.62% 15.32% 4.14%
1281.75
Other operating expenses 0.42% % 309.11%
Other income 660.34% -16.03% 288.61%
Operating Profit/(Loss) -57.44% 491.89% -160.18%
Finance cost 157.45% 20.43% -34.27%
Share of loss/income of associate-accounted for using the equity method 182.79% -46.32% 95.33%
Profit/ (Loss) before income tax -78.82% 871.62% -123.74%
Taxation -53.73% 376.55% 2.37%
1242.39
Profit/loss for the period -85.49% % -112.35%
Interpretation
Horizontal analysis is used to measure the growth of items of financial statement.
The horizontal analysis of income statement shows that sales are growing with
good percentage but from 2022 to 2023 it is decreasing which means revenue is
decreasing it means the company is in a stable position to sell but have to improve
them. COGS also increases because when sales increase it shows that more units
were produced so more unit acquire more cost that’s why cost also increases with
the sales. Gross shows a decline in 2020 to 2021 but after that it shows growth
which is quite satisfactory but again decrease in them. After that all expenses also
rise because production increases cost and expenses also increase but operating
expenses are increasing year to year which means more outflow. company has a
negative net profit in 2020 to 2021 but again increases and again decreases which
is not a good signal.
Vertical analysis
Vertical analysis of Balance Sheet
2020 2021 2022 2023
ASSETS
Non-current
assets
Property, plant and equipment 59.82% 49.80% 31.87% 26.97%
Right-of-use-
asset 0.46% 0.36% 0.14% 0.11%
Intangible
assets 0.00% 0.00% 0.00% 0.01%
Investment accounted for using the equity
method 0.18% 0.14% 0.06% 0.04%
Long-term deposits and
loans 0.07% 0.07% 0.03% 0.03%
Employee benefit prepayments 0.09% 0.06% 0.04% 0.02%
Deferred tax
asset 0.00% 0.00% 0.00% 0.15%
60.62% 50.43% 32.14% 27.33%
Current
Assets
Inventories 22.47% 25.41% 26.45% 33.62%
Trade
receivables 10.34% 16.07% 12.43% 18.88%
Trade deposits, loans, advances, and short-term
prepayments 0.14% 0.18% 0.25% 0.17%
Other
receivables 0.02% 7.50% 2.84% 8.94%
Taxation- payment less provisions 0.23% 0.23% 0.00% 0.00%
Cash and bank balances 6.18% 0.18% 25.88% 11.07%
39.38% 49.57% 67.86% 72.67%
100.00% 100.00% 100.00% 100.00%
Equity &
Liabilities
EQUITY
Share capital 8.89% 15.37% 4.94% 5.97%
Subscription money against rights
issue 5.48% 0.00% 0.00% 0.00%
Accumulated
loss 51.80% 44.36% 14.34% 17.30%
Special
reserve 5.48% 6.78% 11.96% 16.10%
Revaluation surplus on property, plant and equipment 31.45% 27.20% 15.94% 19.27%
Other
reserves 0.01% 0.00% 0.00% 0.00%
-0.49% 4.99% 47.18% 24.04%
LIABILITIES
Non-current liabilities
Long-term borrowings 11.89% 0.72% 0.00% 1.90%
Long-term lease liability 0.43% 0.36% 0.11% 0.13%
Deferred tax liabilities 0.03% 0.01% 0.22% 0.00%
Employee benefit
obligations 1.27% 0.92% 0.46% 0.60%
13.62% 2.01% 0.79% 2.63%
Current
liabilities
Trade and other
payables 50.87% 50.03% 36.31% 44.02%
Short-term borrowings 35.54% 42.87% 14.82% 28.29%
Unearned
revenue 0.40% 0.04% 0.01% 0.00%
Current portion of long-term lease liability 0.01% 0.01% 0.01% 0.01%
Taxation- provision less payments 0.06% 0.00% 0.87% 1.00%
Unclaimed dividend 0.00% 0.05% 0.02% 0.02%
86.88% 93.00% 52.02% 73.33%
100.49% 95.01% 52.82% 75.96%
Contingencies and commitments
100.00% 100.00% 100.00% 100.00%
Interpretation
The vertical analysis of the balance sheet provides insight into the relative
proportion of each item on the balance sheet as a percentage of total assets or
liabilities and equity. This analysis is useful for understanding the composition of
the balance sheet and identifying trends in the financial position of the company.
Current assets represent the largest proportion of the company's assets and this
proportion has increased over the years to years. The largest component of current
assets is cash and cash equivalents which have increased as a percentage of total
assets. This could indicate that the company has been accumulating more cash,
possibly to find investment or to maintain liquidity. Accounts receivable and
inventory also represent a significant portion of current assets, but their proportion
has remained relatively stable over the years. Property, plant, and equipment
represent the largest portion of the noncurrent assets. The portion of this asset
fluctuated over the years 2022 to 2023.
Regarding liabilities, the proportion of current liabilities over the years 2020 to
2023 is a decrease from one year to year, indicating that the company has been
able to manage its short-term debt effectively but not much. However, the short-
term loans decreased significantly, which could indicate that the company has been
repaying its debt or refinancing it with long-term finance. The proportion of long-
term loans has decreased over the year 2020 to 2021 which shows good response
and the company has been able to manage short-term debt effectively. Overall, the
vertical analysis Shows that the company has been able to improve its financial
position by increasing its current assets, reducing short debt, and maintaining a
healthy proportion of long-term financing. This analysis also highlights the
importance of managing cash flow effectively and investing in fixed assets
prudently.
Vertical analysis of income statement
Earnings/loss per share- basic and diluted 17.74 1.52 19.96 2.9
Interpretation
Vertical analysis is used to measure the relative change in accounts of the company
over the years 2019 to 2022. The Vertical analysis of the Income Statement shows
that sales are 100 percent. COGS is 97.21 % of this sales in 2023. The cost of
goods sold is 90% for all years but more in 2020, showing consistency in the
company's ability to manage its production cost. The gross profit margin first
increases and then decreases in 2023. Selling expenses fell to zero due to a change
in production strategy. Administrative expenses is 0.51% in the first two years but
due to changes in production strategy, they increased in 2022 and 2023. Operating
expenses increased but decreased over the years 2020 to 2023. It indicates that the
company has managed its operating expenses well, maintaining consistent
expenditure relative to its sales revenue. The income tax expense was 0.76% in the
first two years but increased in 2022 and then decreased in 2023. But the company
has positive growth in net profit but negative in 2020 which shows the company in
satisfactory condition.
Ratio Analysis
1. Liquidity Analysis
Current ratio=Current Assets /Current Liabilities
2020 2021 2022 2023
Current Assets 13,959,688 20,320,752 61,715,187 76,645,664
Current ratio
1.2
0.8
0.6
0.4
0.2
0
2020 2021 2022 2023
Series1 Series2
Interpretation
The Current Ratio of 2020 = 0.453, 2021: Current Ratio = 0.533, 2022: Current Ratio =
0.930 2023: Current Ratio = 0.991
The current rate of PRL from 2020 year to 2023 year are 0.453, 0.533, 0.930, 0.991
Trend: Positive improvement in liquidity from 2020 to 2023.
Current State: Still slightly below ideal liquidity, indicating some risk, but much better
than previous years. Continued focus on improving liquidity is recommended.
Quick ratio = current assets - inventory / current liabilities
2020 2021 2022 2023
Numerator 5,995,296 9,905,345 37,658,272 41,184,780
Denominator 30,799,362 38,122,408 66,337,719 77,345,091
Quick ratio
0.6
0.5
0.4
0.3
0.2
0.1
0
2020 2021 2022 2023
Interpretation
The quick ratio of 2020 is 0.195 2021: Quick Ratio = 0.260 2022: Quick Ratio = 0.568
2023: Quick Ratio = 0.532
The quick rate of PRL from 2020 year to 2023 year are 0.195, 0.260 0.568, 0.532
Trend: Gradual improvement in liquidity from 2020 to 2023.
Current State: Ratios are below 1.0, indicating some liquidity risk remains.
Implications: The company needs to continue improving liquidity to ensure it can meet
short-term liabilities without relying on inventory.
2. Activity Ratios
Inventory turnover = COGS /Inventory
2020 2021 2022 2023
Numerator 94,892,607 88,843,085 171,043,647 254,559,762
Inventory turnover
12
10
0
2020 2021 2022 2023
Interpretation
The Inventory turnover of 2020 = 11.915, 2021: Inventory turnover = 8.530, 2022:
Inventory turnover= 7.2110, 2023: Inventory turnover= 7.179
The inventory turnover of PRL from 2020 year to 2023 year are 11.915, 8.530, 7.2110,
7.179
Trend: Declining inventory turnover from 2020 to 2023 suggests worsening efficiency in
managing inventory.
Current State: Slower turnover could imply excess inventory or decreasing sales
efficiency.
Implications: The company should focus on improving inventory management to increase
turnover and reduce holding costs.
Interpretation
The average collection period of 2020 = 15.012, 2021: average collection period =
38.595, 2022: average collection period = 26.938, 2023: average collection period =
41.139
The average collection period of PRL from 2020 year to 2023 year are 15.012, 38.595,
26.938, 41.139
Trend: Inconsistent collection periods over the years.
Current State: Fluctuations may impact cash flow and liquidity.
Implications: Review of credit policies and collection procedures recommended to
maintain healthy cash flow.
Average payment period=account payable/average purchases per day
2020 2021 2022 2023
Numerator 18,036,132 20,509,338 46,297,714 46,432,882
100
80
60
40
20
0
2020 2021 2022 2023
Interpretation
The average payment period of 2020 = 74.095, 2021: average payment period = 85.414,
2022: average payment period = 95.855, 2023: average payment period = 67.198
The average payment period of PRL from 2020 year to 2023 year are 74.095, 85.414,
95.855, 67.198
Trend: Payment periods fluctuate over the years.
Current State: Variability may impact vendor relationships and cash flow.
Implications: Optimization of payment processes recommended for maintaining healthy
supplier relationships
2.5
1.5
0.5
0
2020 2021 2022 2023
Interpretation
3. Debt ratios
Debt ratio=Total liabilities/Total assets
2020 2021 2022 2023
Numerator 35,627,201 38,947,022 67,350,528 80,114,663
Debt ratio
1.2
0.8
0.6
0.4
0.2
0
2020 2021 2022 2023
Time Interest Earned Ratio = EBIT / Interest
2020 2021 2022 2023
Numerator (4,913,347) 2,956,772 17,500,927 7,448,177
10
0
2020 2021 2022 2023
-2
-4
Fixed payment coverage ratio = EBIT + lease payment /Int. + Lease Pay. (Prin. + Pref.
Div.) * (1/(1-T)
The fixed payment coverage ratio is zero as we have not given the value of preferred dividend in
the financial report.
4. Profitability ratios
Gross profit margin= Gross profits / Sales
2020 2021 2022 2023
Numerator (4,368,347) 3,241,005 20,272,408 7,300,642
10%
8%
6%
4%
2%
0%
2020 2021 2022 2023
-2%
-4%
-6%
Operating profit margin = operating profit / sales
2020 2021 2022 2023
Numerator (4,913,347) 2,956,772 17,500,927 7,448,177
Operating -5% 3% 9% 3%
profit margin
6%
4%
2%
0%
2020 2021 2022 2023
-2%
-4%
-6%
-8%
-10%
Earning per share = earning available for common stock holders/number of shares
outstanding
2020 2021 2022 2023
Numerator (7,590,726,000) 937,156,000 12,580,282,000 1,824,967,000
20
10
0
2020 2021 2022 2023
-10
-20
-30
Return on total asset = earning available for common stock holders / total assets
2020 2021 2022 2023
Numerator (7,590,726,000) 937,156,000 12,580,282,000 1,824,967,000
0.15
0.1
0.05
0
2020 2021 2022 2023
-0.05
-0.1
-0.15
-0.2
-0.25
Return on equity = earning available for common stockholder / common stock equity
2020 2021 2022 2023
Numerator (7,590,726,000) 937,156,000 12,580,282,000 1,824,967,000
Return on equity(ROE)
50
45
40
35
30
25
20
15
10
5
0
2020 2021 2022 2023
5. Market ratios
Price/earning ratio = market price per share of common stock /EPS
2020 2021 2022 2023
P/E ratio 0 16.2 0.9 4.7
Price/earnings(P/E) ratio
18
16
14
12
10
8
6
4
2
0
2020 2021 2022 2023
Market / book ratio= market price per share of common stock/book value per share
2020 2021 2022 2023
Numerator 11.4 24.7 17.9 13.6
Denominator 65.36 33.1 45.27 44.1
M/B ratio 0.174 0.75 0.4 0.31
Market/book(M/B) ratio
0.8
0.7
0.6
0.5
0.4
0.3
0.2
0.1
0
2020 2021 2022 2023
Appendix
Income statement
Balance Sheet
2020 2021 2022 2023
(Rupees in thousand)
ASSETS
Non-
current
assets