Finance Final

Download as xls, pdf, or txt
Download as xls, pdf, or txt
You are on page 1of 22

BALANCE SHEET OF DELTA CORP 

(in Rs. Cr.) Mar-21 Mar-20 Mar-19 Mar-18 Mar-17


12 mths 12 mths 12 mths 12 mths 12 mths
EQUITIES AND LIABILITIES
SHAREHOLDER'S FUNDS
Equity Share Capital 26.68 27.09 27.09 26.76 23.16
TOTAL SHARE CAPITAL 26.68 27.09 27.09 26.76 23.16
Reserves and Surplus 1,951.41 1,889.92 1,907.95 1,644.48 930.96
TOTAL RESERVES AND SURPLUS 1,951.41 1,889.92 1,907.95 1,644.48 930.96
TOTAL SHAREHOLDERS FUNDS 2,012.51 1,917.01 1,935.04 1,671.24 954.12
NON-CURRENT LIABILITIES
Long Term Borrowings 21.32 19.87 24.98 0.97 24.08
Deferred Tax Liabilities [Net] 17.86 12.68 16.67 10.62 0
Other Long Term Liabilities 1.12 2.38 0 0 0
Long Term Provisions 0.98 0.82 1.41 1.43 2.22
TOTAL NON-CURRENT LIABILITIES 19.96 15.88 18.08 13.01 26.3
CURRENT LIABILITIES
Short Term Borrowings 0 0 0 0.59 19.88
Trade Payables 11.05 13.18 8.45 9.34 5.73
Other Current Liabilities 23.46 20.19 34.35 200.09 46.82
Short Term Provisions 27.95 8.32 6.51 6.7 5.61
TOTAL CURRENT LIABILITIES 62.46 41.69 49.31 216.72 78.04
TOTAL CAPITAL AND LIABILITIES 2,094.93 1,974.58 2,002.43 1,900.97 1,058.47
ASSETS
NON-CURRENT ASSETS
Tangible Assets 320.52 334.63 323.78 330.97 205.36
Intangible Assets 0.34 0.66 4.42 3.69 0.31
Capital Work-In-Progress 4.24 4.85 3.28 0.87 0.13
Other Assets 0 0 0 0 0
FIXED ASSETS 325.15 340.14 334.68 336.27 205.8
Non-Current Investments 960.22 957.1 960.34 621.47 327.21
Deferred Tax Assets [Net] 0 0 0 0 9.18
Long Term Loans And Advances 0 0 0 0 0
Other Non-Current Assets 44.39 41.83 22.15 16.08 20.07
TOTAL NON-CURRENT ASSETS 1,329.76 1,339.07 1,317.17 973.83 562.27
CURRENT ASSETS
Current Investments 447.71 392.27 389.73 364.67 93.15
Inventories 33 13.12 11.92 12.77 11.78
Trade Receivables 2.71 0.85 6.55 7.5 3.57
Cash And Cash Equivalents 21.72 54.76 27.81 62.94 20.85
Short Term Loans And Advances 261.96 155.6 191.62 456.82 322.7
OtherCurrentAssets 17.71 18.91 57.63 22.45 44.15
TOTAL CURRENT ASSETS 765.17 635.51 685.26 927.14 496.2
TOTAL ASSETS 2094.93 1,974.58 2,002.43 1,900.97 1,058.47

working Capital 702.71 593.82 635.95 710.42 418.16


net worth 2,012.51 1,917.01 1,935.04 1,671.24 954.13
YOY CHANGE 2017-18 2018-19 2019-20 2020-21

0.1554404145 0.012332 0 -0.015135


0.1554404145 0.012332 0 -0.015135
0.7664346481 0.160215 -0.0094499332 0.032536
0.7664346481 0.160215 -0.0094499332 0.032536
0.7516035719 0.157847 -0.0093176368 0.049817

-0.959717608 24.75258 0 0
0.56968 -0.2393521296 0.408517
0 0 0 -0.529412
-0.3558558559 -0.013986 -0.4184397163 0.195122
-0.5053231939 0.3897 -0.1216814159 0.256927

-0.9703219316 -1 0 0
0.630017452 -0.095289 0.5597633136 -0.161608
3.2736010252 -0.828327 -0.4122270742 0.161961
0.1942959002 -0.028358 0.2780337942 2.359375
1.7770374167 -0.772471 -0.1545325492 0.498201
0.7959602067 0.053373 -0.0139081017 0.06095

0.6116575769 -0.021724 0.0335104083 -0.042166


10.903225806 0.197832 -0.850678733 -0.484848
5.6923076923 2.770115 0.4786585366 -0.125773
0 0 0 0
0.6339650146 -0.004728 0.0163140911 -0.04407
0.8993001436 0.545272 -0.0033738051 0.00326
-1 0 0 0
0 0 0 0
-0.1988041854 0.377488 0.8884875847 0.0612
0.7319615132 0.352567 0.0166265554 -0.006953

2.9148684917 0.06872 0.0065173325 0.141331


0.084040747 -0.066562 0.1006711409 1.515244
1.1008403361 -0.126667 -0.8702290076 2.188235
2.018705036 -0.558151 0.969075872 -0.60336
0.4156182213 -0.580535 -0.1879762029 0.683548
-0.4915062288 1.567038 -0.6718722887 -0.063458
0.8684804514 -0.260888 -0.072600181 0.204025
0.7959602067 0.053373 -0.0139081017 0.06095
PROFIT & LOSS ACCOUNT OF DELTA CORP (in Rs. Cr.)

INCOME
REVENUE FROM OPERATIONS [GROSS]
Less: Excise/Sevice Tax/Other Levies
REVENUE FROM OPERATIONS [NET]
TOTAL OPERATING REVENUES
Other Income
TOTAL REVENUE
EXPENSES
Cost Of Materials Consumed
Purchase Of Stock-In Trade
Operating And Direct Expenses
Changes In Inventories Of FG,WIP And Stock-In Trade
Employee Benefit Expenses
Finance Costs
Depreciation And Amortisation Expenses
Other Expenses
TOTAL EXPENSES
PROFIT/LOSS BEFORE EXCEPTIONAL, EXTRAORDINARY ITEMS AND TAX
Exceptional Items
PROFIT/LOSS BEFORE TAX
TAX EXPENSES-CONTINUED OPERATIONS
Current Tax
Less: MAT Credit Entitlement
Deferred Tax
Tax For Earlier Years
TOTAL TAX EXPENSES
PROFIT/LOSS AFTER TAX AND BEFORE EXTRAORDINARY ITEMS
PROFIT/LOSS FROM CONTINUING OPERATIONS
PROFIT/LOSS FOR THE PERIOD
OTHER ADDITIONAL INFORMATION
EARNINGS PER SHARE
Basic EPS (Rs.)
Diluted EPS (Rs.)
VALUE OF IMPORTED AND INDIGENIOUS RAW MATERIALS STORES, SPARES AND LOOSE TOOLS
Imported Raw Materials
Indigenous Raw Materials
STORES, SPARES AND LOOSE TOOLS
Imported Stores And Spares
Indigenous Stores And Spares
DIVIDEND AND DIVIDEND PERCENTAGE
Equity Share Dividend
Tax On Dividend
Equity Dividend Rate (%)
Mar-21 Mar-20 Mar-19 Mar-18 Mar-17 YOY Change 2017-18 2018-19 2019-20
12 mths 12 mths 12 mths 12 mths 12 mths

247.75 559.74 582.26 443.71 277.93 0.5964811283 0.3122534989 -0.03867688


45.94 101.39 106.94 67.91 0 0 0.574731262 -0.051898261
201.81 458.35 475.32 375.8 277.93 0.3521390278 0.2648217137 -0.035702264
201.81 458.35 475.32 375.8 277.93 0.3521390278 0.2648217137 -0.035702264
26.7 34 66.28 24.1 4.86 3.9588477366 1.7502074689 -0.487024744
228.51 492.35 541.6 399.9 282.79 0.4141235546 0.3543385846 -0.090934269

16.6 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 33.15 29.66 24.57 17.13 0.4343257443 0.2071632072 0.1176668914
-0.46 -0.74 -0.08 -0.45 0.2 -3.25 -0.822222222 8.25
51.65 71.63 77.23 62.89 39.52 0.5913461538 0.2280171728 -0.072510682
0.86 1.51 0.8 4.63 13.55 -0.658302583 -0.827213823 0.8875
15.94 19.38 16.18 14.64 12.05 0.2149377593 0.1051912568 0.1977750309
103.29 162.17 157.96 132.38 123.94 0.0680974665 0.193231606 0.026652317
187.88 287.1 281.75 238.65 206.4 0.15625 0.1805992039 0.018988465
40.63 205.25 259.85 161.25 76.39 1.1108783872 0.6114728682 -0.210121224
55.95 -55.95 0 -1.02 0.02 -52 -1 0
96.58 149.3 259.85 160.23 76.41 1.0969768355 0.6217312613 -0.425437753

6.4 49.35 74.2 50.11 22.6 1.2172566372 0.4807423668 -0.33490566


0 0 0 0 0 0 0 0
5.01 0.81 2.2 5.72 1.42 3.0281690141 -0.615384615 -0.631818182
-1.58 -0.42 0.13 -0.16 -0.24 -0.333333333 -1.8125 -4.230769231
9.83 49.74 76.53 55.67 23.79 1.3400588483 0.3747081013 -0.3500588
86.75 99.56 183.32 104.56 52.62 0.987077157 0.7532517215 -0.456905957
86.75 99.56 183.32 104.56 52.62 0.987077157 0.7532517215 -0.456905957
86.75 99.56 183.32 104.56 52.62 0.987077157 0.7532517215 -0.456905957

3.24 3.67 6.8 3.98 2.28 0.7456140351 0.7085427136 -0.460294118


3.24 3.67 6.79 3.98 2.28 0.7456140351 0.7060301508 -0.459499264
0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0

0 58.25 43.35 9.35 4.62 1.0238095238 3.6363636364 0.3437139562


0 10.79 0 1.9 0.94 1.0212765957 -1 0
100 150 125 100 35 1.8571428571 0.25 0.2
2020-21

-0.557384
-0.546898
-0.559703
-0.559703
-0.214706
-0.535879

0
0
-1
-0.378378
-0.278933
-0.430464
-0.177503
-0.363076
-0.345594
-0.802046
-2
-0.353115

-0.870314
0
5.185185
2.761905
-0.802372
-0.128666
-0.128666
-0.128666

-0.117166
-0.117166
0
0
0
0
0
0

-1
-1
-0.333333
CASH FLOW OF DELTA CORP (in Rs. Cr.) Mar-21 Mar-20 Mar-19
12 mths 12 mths 12 mths
NET PROFIT/LOSS BEFORE EXTRAORDINARY ITEMS A 96.58 149.3 259.85
Net CashFlow From Operating Activities 54.61 182.3 128.59
Net Cash Used In Investing Activities -47.07 -81.85 -115.76
Net Cash Used From Financing Activities -42.88 -73.84 -48.15
Foreign Exchange Gains / Losses 0 0 0
Adjustments On Amalgamation Merger Demerger Ot 0 0 0
NET INC/DEC IN CASH AND CASH EQUIVALENTS -35.34 26.61 -35.32
Cash And Cash Equivalents Begin of Year 53.7 27.09 62.41
Cash And Cash Equivalents End Of Year 18.36 53.7 27.09
Mar-18 Mar-17 YOY 2017-18 2018-19 2019-20 2020-21
12 mths 12 mths
160.23 76.41 1.09698 0.62173 -0.4254 -0.3531
132.05 81.71 0.61608 -0.0262 0.41768 -0.7004
-577.81 -53.95 9.7101 -0.7997 -0.2929 -0.4249
487.78 -21.35 -23.847 -1.0987 0.53354 -0.4193
0 0 0 0 0 0
0.03 0 0 -1 0 0
42.05 6.41 5.56006 -1.84 -1.7534 -2.3281
20.36 13.95 0.4595 2.06532 -0.5659 0.98228
62.41 20.36 2.06532 -0.5659 0.98228 -0.6581
Financial Ratios Mar-21 Mar-20 Mar-19 Mar-18 Mar-17

Liquidity Ratios:
Current Ratio 12.25 15.24 13.90 4.28 6.36
Quick Ratio 28.82 43.32 36.48 6.60 9.28

Efficiency Ratios:
Inventory Turnover Ratio 6.12 34.94 39.88 29.43 23.59
Accounts Receivable Turnover Ratio 74.47 539.24 72.57 50.11 77.85
Average Collection Period 4.90 0.68 5.03 7.28 4.69
Fixed Asset Turnover Ratio 0.62 1.35 1.42 1.12 1.35
Total Asset Turnover Ratio 0.10 0.23 0.24 0.20 0.26

Coverage Ratios:
The Times Interest Earned Ratio 0.73 -3.67 #DIV/0! -158.09 3819.50
The Cash Coverage Ratio 2.57 -6.57 #DIV/0! -287.87 10016.50

Leverage Ratios:
Total Debt Ratio 99% 99% 99% 99% 98%
Long Term Debt Ratio 80% 73% 92% 4% 104%
Long Term Debt to Total Capitalization Ratio 34 14.12 12.92 13.77 12.78
Debt Equity Ratio 78.52 72.89 73.92 71.04 45.70
Long Term Debt to Equity Ratio 0.80 0.73 0.92 0.04 1.04

Profitability Ratios:
Gross Profit Margin 42.99% 2172.14% 3856.77% 2782.33% 1893.28%
The Operating Profit Margin 20% 45% 55% 43% 27%
The Net Profit Margin 43% 22% 39% 28% 19%
Return on Assets (ROA) 4% 5% 9% 6% 5%
Return on Equity (ROE) 325% 368% 677% 391% 227%
UNIT

Times
Times

Times
Times
Days
Times
Times

Times
Times
z
altman score(20
2017 2018 2019 2020 2021 coeff 17)
altam coef*ratio

Net
Workin
g 0.34 0.30 0.32 0.37 0.40
X1 = X1 =
Capital
/ Total
Assets
6.5 2.18

Retaine
d
Earning 0.93 0.96 0.95 0.87 0.88
X2 = X2 =
s/
Total
Assets
3.26 3.04

EBIT /
X3 = Total X3 = 0.04 0.05 0.09 0.06 0.05
Assets 6.72 0.28

Net
Worth / 24.42 33.30 28.71 7.27 9.14
X4a = X4a =
Total
Debt
1.05 25.64
Z score 31.13
safe
2018 2019 2020 2021
altam coef*ratio

1.95 2.06 2.43 2.57

3.12 3.11 2.82 2.87

0.34 0.62 0.37 0.33

34.96 30.15 7.64 9.60


40.37752 35.93548 13.26 15.3709
safe safe safe safe
Net Working
Capital / Total
Assets
2.18
Chart Title
Retained 30.00
Earnings / Total
Assets 3.04
25.00

EBIT / Total 20.00


Assets 0.28
15.00

Net Worth / 10.00


Total Debt
25.64 5.00

0.00
0.5 1 1.5 2 2.5
Chart Title

5 2 2.5 3 3.5 4 4.5


Net Working
Capital / Total
Assets
1.95476
Chart Title
Retained 40
Earnings / Total 35
Assets
3.120228 30

25
EBIT / Total
Assets 20
0.338828
15

10
Net Worth /
5
Total Debt
0
34.96371 0.5 1 1.5 2 2.5 3 3.5 4
3 3.5 4 4.5
Net Working
Capital / Total
Assets
2.064329
Chart Title
Retained 35
Earnings / Total
Assets 30
3.106184
25
EBIT / Total
Assets 20
0.615208
15
Net Worth /
Total Debt 10
30.14976
5

0
0.5 1 1.5 2 2.5 3 3.5 4
3 3.5 4 4.5
Net Working
Capital / Total
Assets
2.429144

Retained Chart Title


9
Earnings / Total
Assets 2.820142
8

7
EBIT / Total 6
Assets 0.369624 5
Net Worth / 4
Total Debt 7.638541
3

0
0.5 1 1.5 2 2.5 3 3.5 4
3 3.5 4 4.5
Net Working
Capital / Total
Assets
2.567895

Retained Chart Title


Earnings / 12
Total Assets
2.86728 10
EBIT / Total
Assets 0.334073 8

Net Worth / 6
Total Debt
9.601653 4

0
0.5 1 1.5 2 2.5 3 3.5 4
3 3.5 4 4.5

You might also like