YEARS Mar-15 Mar-16 Mar-17 Mar-18 Mar-19 Mar-20

Sales growth _ -27.19% 11.51% 28.58% 45.42% 4.99%

EBITDA Growth 11.57% 10.83% 38.89% 31.00% 5.95% -9.50%
EBT Growth 17.44% 16.16% 28.38% 18.36% -3.81% -26.66%
Net profit growth 16.79% 16.78% 27.17% 19.92% -0.38% -0.01%
Dividend Growth 5.03% 4.80% 12.06% 8.34% 6.96% 16.79%

Gross margin 14% 21% 20% 23% 23% 25%

EBITDA Margin 0.10 0.15 0.15 0.16 0.15 0.15
EBIT Margin 7% 11% 11% 12% 11% 11%
EBT Margin 6% 10% 10% 10% 8% 8%
Net profit margin 4% 6% 7% 7% 6% 5%

Sales expenses % sales 4% 6% 5% 6% 8% 10%

Depreciation %sales 3% 4% 4% 4% 4% 4%
Operating income% sal 6% 10% 10% 10% 8% 8%

Return on capital employed

Retained earnings%
Return on equity%
Self sustained growth rate
Interest coverage ratio

Debtor turnover ratio

Credit turnover ratio
Inventory turnover ratio
Fixed asset turnover
Capital turnover

Debtor days
Payable days
Inventory days
Cash conversion cycle
 Mar-21 Mar-22 Mar-23 Mar-24 LTM

-21.85% 49.83% 25.44% 2.81% 2255264.54%

36.89% 28.68% 13.99% -100.00% 0.00%
100.47% 24.51% 7.08% -188.88% -100.00%
59.44% 24.34% 0.82% -100.00% 0.00%
12.41% 12.50% 11.11% -100.00% 0.00%

30% 25% 25% 32% 100%

0.17 0.16 0.16 0.18 0.00
12% 12% 12% 12% 0%
7% 9% 9% 10% 0%
7% 7% 7% 7% 0%
6257600% 0%

12% 9% 9% 14% 0%
6% 4% 5% 6% 0%
7% 9% 9% 10% 0%
YEAR WeigYear Sales Sales growth
1 Mar-15 374372
2 Mar-16 292563 -22%
3 Mar-17 -1483 -100.5%
4 Mar-18 13261 -994.2%
5 Mar-19 8914 -32.8%
6 Mar-20 6262 -29.8%
7 Mar-21 12548 100.4%
8 Mar-22 1892 -84.9%
9 Mar-23 8528 350.7%
10 Mar-24 11547 35.4%
 HISTORICAL FINANCIAL STATEMENT RELIANCE INDUSTRIES LTD
YEARS Mar-15 Mar-16
INCOME STATEMENT
Sales ₹ 374,372.00 ₹ 272,583.00
Sales growth _ -27.19%

COGS ₹ 322,483.00 ₹ 215,234.00

COGS % SALES 86.14% 78.96%

GROSS PROFIT ₹ 51,889.00 ₹ 57,349.00

Gross profit % sales 13.86% 21.04%

SELLING & GENERAL EXPENSES ₹ 14,440.00 ₹ 15,568.00

S&G EXP SALES % 3.86% 5.71%

EBITDA ₹ 37,449.00 ₹ 41,781.00

EBITDA % Margin 10.00% 15.33%

Interest 3316 3691

Interest % Sales 0.89% 1.35%

Depreciation 11547 11565

Depreciation % Sales 3.08% 4.24%

Earnings before taxes ₹ 22,586.00 ₹ 26,525.00

EBT % Sales 6.03% 9.73%

Tax 7474 8876

Effecative Tax rate 33.09% 33.46%

Net Profit ₹ 15,112.00 ₹ 17,649.00

Net profit margins 4.04% 6.47%

No. of equity Shares 690.28 691.28

EPS ₹ 21.89 ₹ 25.53

Dividend per share 4.26 4.48

Dividend payout ratio 19.47% 17.54%

Retained earnings 81% 82%

# Balance sheet
Equity shares capital ₹ 2,943 ₹ 2,948
Reserves ₹ 215,556 ₹ 228,608
Borrowings ₹ 168,251 ₹ 194,714
 Other Liabilities ₹ 117,736 ₹ 172,727
Total Liabilities ₹ 504,486 ₹ 598,997

Fixed assets net block ₹ 156,458 ₹ 184,910

Capital work in progess ₹ 166,462 ₹ 228,697
Investments ₹ 76,451 ₹ 84,015
other assets ₹ 34,007 ₹ 39,396
Total non current assets ₹ 433,378 ₹ 537,018

Receivables ₹ 5,315 ₹ 4,465

Inventory ₹ 53,248 ₹ 46,486
Cash and bank ₹ 12,545 ₹ 11,028
Total current assets ₹ 71,108 ₹ 61,979

Total Assets ₹ 504,486 ₹ 598,997

# CASH FLOW STATEMENT

Operating activities
Profit from operations 38994 38887
Receivables 1097 -6880
Inventory 3472 6758
Payables -2754 7951
Working capital changes 1815 7829
Direct taxes -6435 -8582
Other operating items 0 0

Cash flow from operating activiti 36189 45963

Investing activities
Fixed assets purchased -63364 -46898
Fixed assets sold 402 344
Investments purchased -678241 -715334
Investments sold 666383 721182
Interest received 6055 2942
Dividends received 548 732
Other investing items 3511 846

Cash flow from investing activiti -64706 -36186

Financing Activity -
Proceeds from shares 343 288
Proceeds from borrowings 29413 34673
Repayment of borrowings -11909 -21693
Interest paid fin -6149 -9224
Dividends paid -3268 -7259
Financial liabilities 0 0
Share application money 17 8
Other financing items -3 -3

Cash flow from financing activity 8444 -3210

NET CASH FLOW -₹ 20,073.00 ₹ 6,567.00

 Mar-17 Mar-18 Mar-19 Mar-20 Mar-21 Mar-22

₹ 303,954.00 ₹ 390,823.00 ₹ 568,337.00 ₹ 596,679.00 ₹ 466,307.00 ₹ 698,672.00

11.51% 28.58% 45.42% 4.99% -21.85% 49.83%

₹ 241,848.00 ₹ 301,249.00 ₹ 436,202.00 ₹ 445,847.00 ₹ 328,419.00 ₹ 523,763.00

79.57% 77.08% 76.75% 74.72% 70.43% 74.97%

₹ 62,106.00 ₹ 89,574.00 ₹ 132,135.00 ₹ 150,832.00 ₹ 137,888.00 ₹ 174,909.00

20.43% 22.92% 23.25% 25.28% 29.57% 25.03%

₹ 15,799.00 ₹ 25,259.00 ₹ 47,885.00 ₹ 61,566.00 ₹ 57,098.00 ₹ 64,314.00

5.20% 6.46% 8.43% 10.32% 12.24% 9.21%

₹ 46,307.00 ₹ 64,315.00 ₹ 84,250.00 ₹ 89,266.00 ₹ 80,790.00 ₹ 110,595.00

15.23% 16.46% 14.82% 14.96% 17.33% 15.83%

3849 8052 16495 22027 21189 14584

1.27% 2.06% 2.90% 3.69% 4.54% 2.09%

11646 16706 20934 22203 26572 29797

3.83% 4.27% 3.68% 3.72% 5.70% 4.26%

₹ 30,812.00 ₹ 39,557.00 ₹ 46,821.00 ₹ 45,036.00 ₹ 33,029.00 ₹ 66,214.00

10.14% 10.12% 8.24% 7.55% 7.08% 9.48%

10201 13346 15390 13726 1722 16297

33.11% 33.74% 32.87% 30.48% 5.21% 24.61%

₹ 20,611.00 ₹ 26,211.00 ₹ 31,431.00 ₹ 31,310.00 ₹ 31,307.00 ₹ 49,917.00

6.78% 6.71% 5.53% 5.25% 6.71% 7.14%

693.62 675.7 676.13 676.19 633.94 676.49

₹ 29.72 ₹ 38.79 ₹ 46.49 ₹ 46.30 ₹ 49.38 ₹ 73.79

4.69 5.26 5.70 6.09 7.12 8.00

15.79% 13.56% 12.26% 13.16% 14.41% 10.84%

84% 86% 88% 87% 86% 89%

₹ 2,959 ₹ 5,922 ₹ 5,926 ₹ 6,339 ₹ 6,445 ₹ 6,765

₹ 260,750 ₹ 287,584 ₹ 381,186 ₹ 442,827 ₹ 693,727 ₹ 772,720
₹ 217,475 ₹ 239,843 ₹ 307,714 ₹ 355,133 ₹ 278,962 ₹ 319,158
₹ 225,618 ₹ 277,924 ₹ 302,804 ₹ 358,716 ₹ 340,931 ₹ 399,979
₹ 706,802 ₹ 811,273 ₹ 997,630 ₹ 1,163,015 ₹ 1,320,065 ₹ 1,498,622

₹ 198,526 ₹ 403,885 ₹ 398,374 ₹ 532,658 ₹ 541,258 ₹ 627,798

₹ 324,837 ₹ 187,022 ₹ 179,463 ₹ 109,106 ₹ 125,953 ₹ 172,506
₹ 82,899 ₹ 82,862 ₹ 235,635 ₹ 276,767 ₹ 364,828 ₹ 394,264
₹ 40,389 ₹ 54,857 ₹ 75,427 ₹ 120,005 ₹ 169,943 ₹ 136,458
₹ 646,651 ₹ 728,626 ₹ 888,899 ₹ 1,038,536 ₹ 1,201,982 ₹ 1,331,026

₹ 8,177 ₹ 17,555 ₹ 30,089 ₹ 19,656 ₹ 19,014 ₹ 23,640

₹ 48,951 ₹ 60,837 ₹ 67,561 ₹ 73,903 ₹ 81,672 ₹ 107,778
₹ 3,023 ₹ 4,255 ₹ 11,081 ₹ 30,920 ₹ 17,397 ₹ 36,178
₹ 60,151 ₹ 82,647 ₹ 108,731 ₹ 124,479 ₹ 118,083 ₹ 167,596

₹ 706,802 ₹ 811,273 ₹ 997,630 ₹ 1,163,015 ₹ 1,320,065 ₹ 1,498,622

44170 62765 83319 85347 80129 113726

-8511 -21991 -40136 -13792 959 -14180
-6899 -10474 -6724 -6342 -7769 -24983
30873 51003 18078 38050 -43148 39888
15463 18538 -28782 17916 -49958 725
-10083 -9844 -12191 -8386 -3213 -3797
0 0 0 0 0 0

65013 89997 13564 112793 -23000 111379

-78109 -73953 -93626 -76517 -105837 -100145

1482 999 849 964 2319 3137
-654760 -533984 -1107439 -1156843 -689866 -667878
663990 537504 1103615 1174796 642551 668137
1110 1310 972 1441 8400 5933
345 1021 501 78 26 19
-259 -1089 621 -16416 22 -18365

-66201 -68192 -94507 -72497 -142385 -109162

811 406 230 129 5 5

31728 36970 106701 53760 46421 99105
-18542 -19813 -20245 -18179 -116921 -49493
-12920 -17669 -23338 -28508 -18340 -26349
-53 -3916 -4282 -4592 -3921 -4297
0 0 0 -1062 -1022 -2132
 4 15 2 1 0 0
7589 2006 -3162 -4090 195682 450

8617 -2001 55906 -2541 101904 17289

₹ 7,429.00 ₹ 19,804.00 -₹ 25,037.00 ₹ 37,755.00 -₹ 63,481.00 ₹ 19,506.00

 Mar-23 Mar-24 LTM

₹ 876,396.00 ₹ 901,064.00 ₹ 20,322,277,969.24

25.44% 2.81% 2255264.54%

₹ 658,075.00 ₹ 611,022.00 ₹ 0.00

75.09% 67.81% 0.00%

₹ 218,321.00 ₹ 290,042.00 ₹ 20,322,277,969.24

24.91% 32.19% 100.00%

₹ 76,003.00 ₹ 127,809.00
8.67% 14.18% 0.00%

₹ 142,318.00 ₹ 162,233.00
16.24% 18.00% 0.00%

19571 23118 78462

2.23% 2.57% 0.00%

40303 50832 0
4.60% 5.64% 0.00%

₹ 82,444.00 ₹ 88,283.00 -₹ 78,462.00

9.41% 9.80% 0.00%

20376 25707 78462

24.71% 29.12% -100.00%

₹ 62,068.00 ₹ 62,576.00
7.08% 6.94% 0.00%

676.56 676.57 0
₹ 91.74 ₹ 92.49 #DIV/0!

9.00 10.00 0.00

9.81% 10.81% #DIV/0!

90% 89% 0%

₹ 6,766 ₹ 6,766 ₹0
₹ 709,106 ₹ 786,715 ₹0
₹ 451,664 ₹ 346,142 ₹0
 ₹ 438,346 ₹ 616,363 ₹0
₹ 1,605,882 ₹ 1,755,986

₹ 724,805 ₹ 966,458 ₹0
₹ 293,752 ₹ 152,382 ₹0
₹ 235,560 ₹ 225,672 ₹0
₹ 114,645 ₹ 129,851 ₹0 0
₹ 1,368,762 ₹ 1,474,363 ₹0

₹ 28,448 ₹ 31,628 ₹0
₹ 140,008 ₹ 152,770 ₹0
₹ 68,664 ₹ 97,225 ₹0
₹ 237,120 ₹ 281,623 ₹0

₹ 1,605,882 ₹ 1,755,986 ₹0

140963 164383 0
13194 -15674 0
-32228 -12756 0
-600 34796 0
-19634 6366 0
-6297 -11961 0
0 0 0

95398 165154 0

-140988 -152883 0
9186 15307 0
-471822 -514380 0
501266 531355 0
11103 10648 0
20 75 0
-1766 -4423 0

-93001 -114301 0

479 20915 0
67134 69610 0
-29059 -60348 0
-21650 -37173 0
-5083 -6089 0
-1406 -4966 0
 0 0 0
40 1405 0

10455 -16646 0

₹ 12,852.00 ₹ 34,207.00 ₹ 0.00

 Mar-15 Mar-16
Cash from Operating Activity - 34,374 38,134
Profit from operations 38,994 38,887
Receivables 1,097 -6,880
Inventory 3,472 6,758
Payables -2,754 7,951
Working capital changes 1,815 7,829
Direct taxes -6,435 -8,582
Other operating items 0 0
Cash from Investing Activity - -64,706 -36,186
Fixed assets purchased -63,364 -46,898
Fixed assets sold 402 344
Investments purchased -678,241 -715,334
Investments sold 666,383 721,182
Interest received 6,055 2,942
Dividends received 548 732
Other investing items 3,511 846
Cash from Financing Activity - 8,444 -3,210
Proceeds from shares 343 288
Proceeds from borrowings 29,413 34,673
Repayment of borrowings -11,909 -21,693
Interest paid fin -6,149 -9,224
Dividends paid -3,268 -7,259
Financial liabilities 0 0
Share application money 17 8
Other financing items -3 -3
Net Cash Flow -21,888 -1,262
 Mar-17 Mar-18 Mar-19 Mar-20 Mar-21 Mar-22
49,550 71,459 42,346 94,877 26,958 110,654
44,170 62,765 83,319 85,347 80,129 113,726
-8,511 -21,991 -40,136 -13,792 959 -14,180
-6,899 -10,474 -6,724 -6,342 -7,769 -24,983
30,873 51,003 18,078 38,050 -43,148 39,888
15,463 18,538 -28,782 17,916 -49,958 725
-10,083 -9,844 -12,191 -8,386 -3,213 -3,797
0 0 0 0 0 0
-66,201 -68,192 -94,507 -72,497 -142,385 -109,162
-78,109 -73,953 -93,626 -76,517 -105,837 -100,145
1,482 999 849 964 2,319 3,137
-654,760 -533,984 -1,107,439 -1,156,843 -689,866 -667,878
663,990 537,504 1,103,615 1,174,796 642,551 668,137
1,110 1,310 972 1,441 8,400 5,933
345 1,021 501 78 26 19
-259 -1,089 621 -16,416 22 -18,365
8,617 -2,001 55,906 -2,541 101,904 17,289
811 406 230 129 5 5
31,728 36,970 106,701 53,760 46,421 99,105
-18,542 -19,813 -20,245 -18,179 -116,921 -49,493
-12,920 -17,669 -23,338 -28,508 -18,340 -26,349
-53 -3,916 -4,282 -4,592 -3,921 -4,297
0 0 0 -1,062 -1,022 -2,132
4 15 2 1 0 0
7,589 2,006 -3,162 -4,090 195,682 450
-8,034 1,266 3,745 19,839 -13,523 18,781
 Mar-23 Mar-24
115,032 158,788
140,963 164,383
13,194 -15,674
-32,228 -12,756
-600 34,796
-19,634 6,366
-6,297 -11,961
0 0
-93,001 -114,301
-140,988 -152,883
9,186 15,307
-471,822 -514,380
501,266 531,355
11,103 10,648
20 75
-1,766 -4,423
10,455 -16,646
479 20,915
67,134 69,610
-29,059 -60,348
-21,650 -37,173
-5,083 -6,089
-1,406 -4,966
0 0
40 1,405
32,486 27,841
RELIANCE INDUSTRIES LTD SCREENER.IN

Narration Mar-15 Mar-16 Mar-17 Mar-18 Mar-19 Mar-20 Mar-21 Mar-22 Mar-23 Mar-24 Trailing Best Case Worst Case
Sales 374,372.00 272,583.00 303,954.00 390,823.00 568,337.00 596,679.00 466,307.00 698,672.00 876,396.00 901,064.00 901,064.00 1,122,320.44 926,426.33
Expenses 336,923.00 230,802.00 257,647.00 326,508.00 484,087.00 507,413.00 385,517.00 588,077.00 734,078.00 738,831.00 738,831.00 920,251.10 780,334.47
Operating Profit 37,449.00 41,781.00 46,307.00 64,315.00 84,250.00 89,266.00 80,790.00 110,595.00 142,318.00 162,233.00 162,233.00 202,069.35 146,091.86
Other Income 8,528.00 12,212.00 9,222.00 9,869.00 8,406.00 8,570.00 22,432.00 17,928.00 12,020.00 16,444.00 16,444.00 - -
Depreciation 11,547.00 11,565.00 11,646.00 16,706.00 20,934.00 22,203.00 26,572.00 29,797.00 40,303.00 50,832.00 50,832.00 50,832.00 50,832.00
Interest 3,316.00 3,691.00 3,849.00 8,052.00 16,495.00 22,027.00 21,189.00 14,584.00 19,571.00 23,118.00 23,118.00 23,118.00 23,118.00
Profit before tax 31,114.00 38,737.00 40,034.00 49,426.00 55,227.00 53,606.00 55,461.00 84,142.00 94,464.00 104,727.00 104,727.00 128,119.35 72,141.86
Tax 7,474.00 8,876.00 10,201.00 13,346.00 15,390.00 13,726.00 1,722.00 16,297.00 20,376.00 25,707.00 25,707.00 25% 25%
Net profit 23,566.00 29,745.00 29,901.00 36,075.00 39,588.00 39,354.00 49,128.00 60,705.00 66,702.00 69,621.00 69,621.00 96,670.30 54,433.43
EPS 34.14 43.03 43.11 53.39 58.55 58.20 77.50 89.74 98.59 102.90 102.87 142.83 80.43
Price to earning 10.99 11.04 13.92 15.02 21.16 17.39 23.71 26.93 21.69 28.88 27.63 27.63 19.85
Price 375.31 474.91 600.18 802.15 1,238.85 1,012.12 1,837.56 2,417.01 2,138.41 2,971.70 2,842.15 3,946.39 1,596.64

RATIOS:
Dividend Payout 12.49% 10.41% 10.89% 9.85% 9.73% 10.47% 9.18% 8.92% 9.13% 9.72%
OPM 10.00% 15.33% 15.23% 16.46% 14.82% 14.96% 17.33% 15.83% 16.24% 18.00% 18.00%

TRENDS: 10 YEARS 7 YEARS 5 YEARS 3 YEARS RECENT BEST WORST

Sales Growth 10.25% 16.79% 9.66% 24.56% 2.81% 24.56% 2.81%
OPM 15.77% 16.31% 16.54% 16.77% 18.00% 18.00% 15.77%
Price to Earning 19.85 22.80 24.37 26.28 27.63 27.63 19.85
RELIANCE INDUSTRIES LTD SCREENER.IN

Narration Dec-21 Mar-22 Jun-22 Sep-22 Dec-22 Mar-23 Jun-23 Sep-23 Dec-23 Mar-24
Sales 185,027.00 207,375.00 218,855.00 229,409.00 216,737.00 212,834.00 207,559.00 231,886.00 225,086.00 236,533.00
Expenses 155,321.00 176,009.00 181,157.00 198,438.00 181,728.00 174,478.00 169,466.00 190,918.00 184,430.00 194,017.00
Operating Profit 29,706.00 31,366.00 37,698.00 30,971.00 35,009.00 38,356.00 38,093.00 40,968.00 40,656.00 42,516.00
Other Income 7,016.00 2,602.00 2,275.00 3,656.00 3,377.00 2,996.00 3,889.00 3,899.00 4,022.00 4,634.00
Depreciation 7,683.00 8,001.00 8,942.00 9,726.00 10,183.00 11,452.00 11,775.00 12,585.00 12,903.00 13,569.00
Interest 3,812.00 3,556.00 3,997.00 4,554.00 5,201.00 5,819.00 5,837.00 5,731.00 5,789.00 5,761.00
Profit before tax 25,227.00 22,411.00 27,034.00 20,347.00 23,002.00 24,081.00 24,370.00 26,551.00 25,986.00 27,820.00
Tax 4,688.00 4,390.00 7,591.00 4,835.00 5,196.00 2,754.00 6,112.00 6,673.00 6,345.00 6,577.00
Net profit 18,549.00 16,203.00 17,955.00 13,656.00 15,792.00 19,299.00 16,011.00 17,394.00 17,265.00 18,951.00

OPM 16% 15% 17% 14% 16% 18% 18% 18% 18% 18%
RELIANCE INDUSTRIES LTD SCREENER.IN

Narration Mar-15 Mar-16 Mar-17 Mar-18 Mar-19 Mar-20 Mar-21 Mar-22 Mar-23 Mar-24
Equity Share Capital 2,943.00 2,948.00 2,959.00 5,922.00 5,926.00 6,339.00 6,445.00 6,765.00 6,766.00 6,766.00
Reserves 215,556.00 228,608.00 260,750.00 287,584.00 381,186.00 442,827.00 693,727.00 772,720.00 709,106.00 786,715.00
Borrowings 168,251.00 194,714.00 217,475.00 239,843.00 307,714.00 355,133.00 278,962.00 319,158.00 451,664.00 346,142.00
Other Liabilities 117,736.00 172,727.00 225,618.00 277,924.00 302,804.00 358,716.00 340,931.00 399,979.00 438,346.00 616,363.00
Total 504,486.00 598,997.00 706,802.00 811,273.00 997,630.00 1,163,015.00 1,320,065.00 1,498,622.00 1,605,882.00 1,755,986.00

Net Block 156,458.00 184,910.00 198,526.00 403,885.00 398,374.00 532,658.00 541,258.00 627,798.00 724,805.00 966,458.00
Capital Work in Progress 166,462.00 228,697.00 324,837.00 187,022.00 179,463.00 109,106.00 125,953.00 172,506.00 293,752.00 152,382.00
Investments 76,451.00 84,015.00 82,899.00 82,862.00 235,635.00 276,767.00 364,828.00 394,264.00 235,560.00 225,672.00
Other Assets 105,115.00 101,375.00 100,540.00 137,504.00 184,158.00 244,484.00 288,026.00 304,054.00 351,765.00 411,474.00
Total 504,486.00 598,997.00 706,802.00 811,273.00 997,630.00 1,163,015.00 1,320,065.00 1,498,622.00 1,605,882.00 1,755,986.00

Working Capital -12,621.00 -71,352.00 -125,078.00 -140,420.00 -118,646.00 -114,232.00 -52,905.00 -95,925.00 -86,581.00 -204,889.00
Debtors 5,315.00 4,465.00 8,177.00 17,555.00 30,089.00 19,656.00 19,014.00 23,640.00 28,448.00 31,628.00
Inventory 53,248.00 46,486.00 48,951.00 60,837.00 67,561.00 73,903.00 81,672.00 107,778.00 140,008.00 152,770.00

Debtor Days 5.18 5.98 9.82 16.40 19.32 12.02 14.88 12.35 11.85 12.81
Inventory Turnover 7.03 5.86 6.21 6.42 8.41 8.07 5.71 6.48 6.26 5.90

Return on Equity 11% 13% 11% 12% 10% 9% 7% 8% 9% 9%

Return on Capital Emp 10% 10% 11% 12% 10% 9% 10% 10% 11%
RELIANCE INDUSTRIES LTD SCREENER.IN

Narration Mar-15 Mar-16 Mar-17 Mar-18 Mar-19 Mar-20 Mar-21 Mar-22 Mar-23 Mar-24
Cash from Operating Activity 34,374.00 38,134.00 49,550.00 71,459.00 42,346.00 94,877.00 26,958.00 110,654.00 115,032.00 158,788.00
Cash from Investing Activity -64,706.00 -36,186.00 -66,201.00 -68,192.00 -94,507.00 -72,497.00 -142,385.00 -109,162.00 -93,001.00 -114,301.00
Cash from Financing Activity 8,444.00 -3,210.00 8,617.00 -2,001.00 55,906.00 -2,541.00 101,904.00 17,289.00 10,455.00 -16,646.00
Net Cash Flow -21,888.00 -1,262.00 -8,034.00 1,266.00 3,745.00 19,839.00 -13,523.00 18,781.00 32,486.00 27,841.00
How to use it?
You can customize this workbook as you want.
You can add custom formating, add conditional formating, add your own formulas… do ANYTHING.
Please don't edit the "Data Sheet" only.

After customization, you can upload this back on Screener.

Upload on: https://www.screener.in/excel/

Download your customized workbooks now onwards.

Now whenever you will "Export to excel" from Screener, it will export your customized file.

TESTING:
This is a testing feature currently.
You can report any formula errors on the worksheet at: support@screener.in
COMPANY NAME RELIANCE INDUSTRIES LTD
LATEST VERSION 2.10 PLEAS
CURRENT VERSION 2.10

META
Number of shares 676.80
Face Value 10.00
Current Price 2,842.15
Market Capitalization 1,923,564.70

PROFIT & LOSS

Report Date Mar-15 Mar-16 Mar-17 Mar-18
Sales 374,372.00 272,583.00 303,954.00 390,823.00
Raw Material Cost 292,563.00 186,254.00 217,518.00 276,076.00
Change in Inventory -1,483.00 -2,560.00 5,218.00 8,610.00
Power and Fuel 13,261.00 10,741.00 11,251.00 14,569.00
Other Mfr. Exp 8,914.00 8,272.00 9,909.00 9,691.00
Employee Cost 6,262.00 7,407.00 8,388.00 9,523.00
Selling and admin 12,548.00 18,808.00 18,520.00 29,111.00
Other Expenses 1,892.00 -3,240.00 -2,721.00 -3,852.00
Other Income 8,528.00 12,212.00 9,222.00 9,869.00
Depreciation 11,547.00 11,565.00 11,646.00 16,706.00
Interest 3,316.00 3,691.00 3,849.00 8,052.00
Profit before tax 31,114.00 38,737.00 40,034.00 49,426.00
Tax 7,474.00 8,876.00 10,201.00 13,346.00
Net profit 23,566.00 29,745.00 29,901.00 36,075.00
Dividend Amount 2,943.00 3,095.40 3,254.90 3,553.20

Quarters
Report Date Dec-21 Mar-22 Jun-22 Sep-22
Sales 185,027.00 207,375.00 218,855.00 229,409.00
Expenses 155,321.00 176,009.00 181,157.00 198,438.00
Other Income 7,016.00 2,602.00 2,275.00 3,656.00
Depreciation 7,683.00 8,001.00 8,942.00 9,726.00
Interest 3,812.00 3,556.00 3,997.00 4,554.00
Profit before tax 25,227.00 22,411.00 27,034.00 20,347.00
Tax 4,688.00 4,390.00 7,591.00 4,835.00
Net profit 18,549.00 16,203.00 17,955.00 13,656.00
Operating Profit 29,706.00 31,366.00 37,698.00 30,971.00
BALANCE SHEET
Report Date Mar-15 Mar-16 Mar-17 Mar-18
Equity Share Capital 2,943.00 2,948.00 2,959.00 5,922.00
Reserves 215,556.00 228,608.00 260,750.00 287,584.00
Borrowings 168,251.00 194,714.00 217,475.00 239,843.00
Other Liabilities 117,736.00 172,727.00 225,618.00 277,924.00
Total 504,486.00 598,997.00 706,802.00 811,273.00
Net Block 156,458.00 184,910.00 198,526.00 403,885.00
Capital Work in Progress 166,462.00 228,697.00 324,837.00 187,022.00
Investments 76,451.00 84,015.00 82,899.00 82,862.00
Other Assets 105,115.00 101,375.00 100,540.00 137,504.00
Total 504,486.00 598,997.00 706,802.00 811,273.00
Receivables 5,315.00 4,465.00 8,177.00 17,555.00
Inventory 53,248.00 46,486.00 48,951.00 60,837.00
Cash & Bank 12,545.00 11,028.00 3,023.00 4,255.00
No. of Equity Shares ### ### ### ###
New Bonus Shares ###
Face value 10.00 10.00 10.00 10.00

CASH FLOW:
Report Date Mar-15 Mar-16 Mar-17 Mar-18
Cash from Operating Activity 34,374.00 38,134.00 49,550.00 71,459.00
Cash from Investing Activity -64,706.00 -36,186.00 -66,201.00 -68,192.00
Cash from Financing Activity 8,444.00 -3,210.00 8,617.00 -2,001.00
Net Cash Flow -21,888.00 -1,262.00 -8,034.00 1,266.00

PRICE: 375.31 474.91 600.18 802.15

DERIVED:
Adjusted Equity Shares in Cr 690.28 691.28 693.62 675.70
 PLEASE DO NOT MAKE ANY CHANGES TO THIS SHEET

Mar-19 Mar-20 Mar-21 Mar-22 Mar-23 Mar-24

568,337.00 596,679.00 466,307.00 698,672.00 876,396.00 901,064.00
399,167.00 410,288.00 301,765.00 496,369.00 618,746.00 590,226.00
4,680.00 5,048.00 9,064.00 21,457.00 30,263.00 4,883.00
17,029.00 15,098.00 13,214.00 17,902.00 25,062.00
12,198.00 11,434.00 7,687.00 12,174.00 19,658.00
12,488.00 14,075.00 14,817.00 18,775.00 24,872.00 25,679.00
50,221.00 62,622.00 56,154.00 63,557.00 75,230.00
-2,336.00 -1,056.00 944.00 757.00 773.00 127,809.00
8,406.00 8,570.00 22,432.00 17,928.00 12,020.00 16,444.00
20,934.00 22,203.00 26,572.00 29,797.00 40,303.00 50,832.00
16,495.00 22,027.00 21,189.00 14,584.00 19,571.00 23,118.00
55,227.00 53,606.00 55,461.00 84,142.00 94,464.00 104,727.00
15,390.00 13,726.00 1,722.00 16,297.00 20,376.00 25,707.00
39,588.00 39,354.00 49,128.00 60,705.00 66,702.00 69,621.00
3,851.90 4,120.35 4,511.50 5,412.00 6,089.40 6,766.00

Dec-22 Mar-23 Jun-23 Sep-23 Dec-23 Mar-24

216,737.00 212,834.00 207,559.00 231,886.00 225,086.00 236,533.00
181,728.00 174,478.00 169,466.00 190,918.00 184,430.00 194,017.00
3,377.00 2,996.00 3,889.00 3,899.00 4,022.00 4,634.00
10,183.00 11,452.00 11,775.00 12,585.00 12,903.00 13,569.00
5,201.00 5,819.00 5,837.00 5,731.00 5,789.00 5,761.00
23,002.00 24,081.00 24,370.00 26,551.00 25,986.00 27,820.00
5,196.00 2,754.00 6,112.00 6,673.00 6,345.00 6,577.00
15,792.00 19,299.00 16,011.00 17,394.00 17,265.00 18,951.00
35,009.00 38,356.00 38,093.00 40,968.00 40,656.00 42,516.00
Mar-19 Mar-20 Mar-21 Mar-22 Mar-23 Mar-24
5,926.00 6,339.00 6,445.00 6,765.00 6,766.00 6,766.00
381,186.00 442,827.00 693,727.00 772,720.00 709,106.00 786,715.00
307,714.00 355,133.00 278,962.00 319,158.00 451,664.00 346,142.00
302,804.00 358,716.00 340,931.00 399,979.00 438,346.00 616,363.00
997,630.00 1,163,015.00 1,320,065.00 1,498,622.00 1,605,882.00 1,755,986.00
398,374.00 532,658.00 541,258.00 627,798.00 724,805.00 966,458.00
179,463.00 109,106.00 125,953.00 172,506.00 293,752.00 152,382.00
235,635.00 276,767.00 364,828.00 394,264.00 235,560.00 225,672.00
184,158.00 244,484.00 288,026.00 304,054.00 351,765.00 411,474.00
997,630.00 1,163,015.00 1,320,065.00 1,498,622.00 1,605,882.00 1,755,986.00
30,089.00 19,656.00 19,014.00 23,640.00 28,448.00 31,628.00
67,561.00 73,903.00 81,672.00 107,778.00 140,008.00 152,770.00
11,081.00 30,920.00 17,397.00 36,178.00 68,664.00 97,225.00
### ### ### ### ###
###
10.00 10.00 10.00 10.00 10.00 10.00

Mar-19 Mar-20 Mar-21 Mar-22 Mar-23 Mar-24

42,346.00 94,877.00 26,958.00 110,654.00 115,032.00 158,788.00
-94,507.00 -72,497.00 -142,385.00 -109,162.00 -93,001.00 -114,301.00
55,906.00 -2,541.00 101,904.00 17,289.00 10,455.00 -16,646.00
3,745.00 19,839.00 -13,523.00 18,781.00 32,486.00 27,841.00

1,238.85 1,012.12 1,837.56 2,417.01 2,138.41 2,971.70

676.13 676.19 633.94 676.49 676.56 676.57