Years

Historical Financial Statement - STATE BANK OF INDIA

Years Mar-22 Mar-23 Mar-24 LTM
w
# Income Statement
Sales ₹289,972.7 ₹350,844.6 ₹439,188.5 ₹481,410.2
Sales Growth 0.00% 20.99% 25.18% 9.61%

COGS ₹62,677.0 ₹63,239.7 ₹85,135.4 ₹247,014.7

COGS % Sales 21.61% 18.02% 19.38% 51.31%

Gross Profit ₹227,295.7 ₹287,604.9 ₹354,053.1 ₹234,395.5

Gross Margins 78.39% 81.98% 80.62% 48.69%

Selling & General Expenses (+other income) ₹17,671.5 ₹18,529.9 (₹772.2) -

S&G Exp % Sales 6.09% 5.28% -0.18% 0.00%

EBITDA ₹209,624.2 ₹269,075.0 ₹354,825.2 ₹400,213.4

EBITDA Margins 72.29% 76.69% 80.79% 83.13%

Intrest ₹156,194.3 ₹189,980.8 ₹259,736.1 ₹293,360.3

Intrest % Sales 53.87% 54.15% 59.14% 60.94%

Depreciation ₹3,691.3 ₹3,695.6 ₹3,849.1 -

Depreciation % Sales 1.27% 1.05% 0.88% 0.00%

Earning Before Tax ₹49,738.6 ₹75,398.6 ₹91,240.1 ₹106,853.1

EBT % Sales 17.15% 21.49% 20.77% 22.20%

Tax ₹13,382.5 ₹18,840.1 ₹23,101.8 ₹27,508.1

Effective Tax Rate 26.91% 24.99% 25.32% 25.74%

Net Profit ₹36,356.2 ₹56,558.4 ₹68,138.3 ₹79,345.0

 Net Margins 12.54% 16.12% 15.51% 16.48%

No of Equity Shares ₹892.5 ₹892.5 ₹892.5 ₹892.5

EPS ₹40.7 ₹63.4 ₹76.3 ₹88.9

EPS Growth 0.00% 55.57% 20.47% 16.45%

Dividend Per Share ₹7.1 ₹11.3 ₹13.7 -

Dividend Payout Ratio 17.43% 17.83% 17.94% 0.00%

Retained Earnings 82.57% 82.17% 82.06% 100.00%

# Balance sheet
Years Mar-22 Mar-23 Mar-24 LTM
Equity Share Capital ₹892.5 ₹892.5 ₹892.5
Reserves ₹304,695.6 ₹358,038.9 ₹414,046.7
Borrowings ₹449,159.8 ₹521,152.0 ₹639,609.5
Other Liabilities ₹4,606,130.0 ₹5,074,331.2 ₹5,679,206.9

Total Liabilities ₹5,360,877.8 ₹5,954,414.5 ₹6,733,755.6

Fixed Assets Net Block ₹41,032.5 ₹45,879.7 ₹46,071.7

Capital Work in Progress ₹27.6 ₹66.0 ₹42.5
Investments ₹1,776,489.9 ₹1,913,107.9 ₹2,110,548.2
Other Assets ₹3,144,422.8 ₹3,677,049.0 ₹4,250,520.9
Total Non Current Assets ₹4,961,972.7 ₹5,636,102.6 ₹6,407,183.3

Receivables - - -
Inventory - - -
Cash & Bank ₹398,905.1 ₹318,311.9 ₹326,572.3
Total Current Assets ₹398,905.1 ₹318,311.9 ₹326,572.3

Total Assets ₹5,360,877.8 ₹5,954,414.5 ₹6,733,755.6

 Check TRUE TRUE TRUE

# Cash Flow Statements

Years Mar-22 Mar-23 Mar-24
Cash from Operating Activity ₹57,694.9 (₹86,013.7) ₹21,632.4
Cash from Investing Activity (₹2,652.3) (₹965.9) (₹3,475.8)
Cash from Financing Activity (₹3,844.5) ₹6,386.4 (₹9,896.3)
Net Cash Flow ₹51,198.1 (₹80,593.2) ₹8,260.4
 Ratio Analysis - STATE BANK OF INDIA
Years Mar-22 Mar-23 Mar-24 Trend Mean Median

Sales Growth 0.00% 20.99% 25.18% 15.39% 20.99%

EBITDA Growth Err:508 28.36% 31.87% 20.08% 28.36%
EBT Growth Err:508 51.59% 21.01% 24.20% 21.01%
Net Profit Growth Err:508 55.57% 20.47% 25.35% 20.47%
Dividend Growth Err:508 59.15% 21.24% 26.80% 21.24%

Gross Margins 78.39% 81.98% 80.62% 80.33% 80.62%

EBITDA Margin 72.29% 76.69% 80.79% 76.59% 76.69%
EBIT Margin 71.02% 75.64% 79.91% 75.52% 75.64%
EBT Margin 17.15% 21.49% 20.77% 19.81% 20.77%
Net Profit Margin 12.54% 16.12% 15.51% 14.72% 15.51%

Sales Expenses % Sales 6.09% 5.28% -0.18% 3.73% 5.28%

Depreciation % Sales 1.27% 1.05% 0.88% 1.07% 1.05%
Operation Income % Sales 71.02% 75.64% 79.91% 75.52% 75.64%

Return On Capital Employed 27.29% 30.15% 33.28% 30.24% 30.15%

Retained Earnings% 82.57% 82.17% 82.06% 82.27% 82.17%
Return On Equity % 11.90% 15.76% 16.42% 14.69% 15.76%
Self Sustain Growth Rate 9.82% 12.95% 13.47% 12.08% 12.95%
Interest Coverage Ratio 1.32x 1.40x 1.35x 1.36x 1.35x

Debt Turnover Ratio 0.00x 0.00x 0.00x 0.00x 0.00x

Credit Turnover Ratio 0.06x 0.07x 0.08x 0.07x 0.07x
Inventory Turnover 0.00x 0.00x 0.00x 0.00x 0.00x
Fixed Asset Turnover 7.07x 7.65x 9.53x 8.08x 7.65x
Capital Turnover Ratio 0.95x 0.98x 1.06x 0.99x 0.98x

Debtor Days 0 Days 0 Days 0 Days 0 Days 0 Days

Payable Days 5798 Days 5279 Days 4720 Days 5266 Days 5279 Days
Inventory Days 0 Days 0 Days 0 Days 0 Days 0 Days
Cash Conversion Cycle (5798 Days) (5279 Days) (4720 Days) (5266 Days) (5279 Days)

CFO / Sales 19.90% -24.52% 4.93% 0.10% 4.93%

CFO / Total Assets 1.08% -1.44% 0.32% -0.02% 0.32%
CFO / Total Debts 12.85% -16.50% 3.38% -0.09% 3.38%
COMPANY NAME STATE BANK OF INDIA
LATEST VERSION 2.10 PLEAS
CURRENT VERSION 2.10

META
Number of shares 892.46
Face Value 1.00
Current Price 733.15
Market Capitalization 654,308.52

PROFIT & LOSS

Report Date Mar-15 Mar-16 Mar-17 Mar-18
Sales 207,974.34 220,632.75 230,447.10 228,970.28
Raw Material Cost
Change in Inventory
Power and Fuel
Other Mfr. Exp 730.46 797.06 870.96 971.90
Employee Cost 31,123.20 32,533.31 35,700.74 35,417.16
Selling and admin 9,333.86 9,750.12 10,596.89 12,597.96
Other Expenses 55,487.29 66,904.29 98,497.50 120,077.51
Other Income 49,315.17 52,828.39 68,193.17 77,557.39
Depreciation 1,581.49 2,252.21 2,914.68 3,105.07
Interest 133,178.64 143,047.36 149,114.67 146,602.98
Profit before tax 25,854.57 18,176.79 944.83 -12,244.91
Tax 8,337.20 5,433.50 1,335.50 -8,057.50
Net profit 16,994.30 12,224.60 241.23 -4,556.29
Dividend Amount 2,613.00 2,018.33 2,073.11

Quarters
Report Date Sep-22 Dec-22 Mar-23 Jun-23
Sales 84,462.87 91,517.66 98,083.19 101,460.01
Expenses 49,207.81 56,497.58 59,965.34 49,080.20
Other Income 30,319.61 35,701.31 38,769.20 30,872.77
Depreciation
Interest 45,232.19 49,365.99 53,451.48 58,044.94
Profit before tax 20,342.48 21,355.40 23,435.57 25,207.64
Tax 5,325.20 5,685.75 5,092.32 6,471.69
Net profit 14,752.00 15,477.22 18,093.84 18,536.80
Operating Profit 35,255.06 35,020.08 38,117.85 52,379.81
EBITDA 65,309.39 70,528.96 76,637.64 83,053.43

BALANCE SHEET
Report Date Mar-15 Mar-16 Mar-17 Mar-18
Equity Share Capital 746.57 776.28 797.35 892.46
Reserves 160,640.97 179,816.09 216,394.80 229,429.49
Borrowings 244,663.47 361,399.39 336,365.66 369,079.34
Other Liabilities 2,293,109.52 2,530,329.72 2,888,201.70 3,017,037.88
Total 2,699,160.53 3,072,321.48 3,441,759.51 3,616,439.17
Net Block 12,924.20 15,415.21 51,189.24 42,034.79
Capital Work in Progress 400.32 785.70 694.92 925.07
Investments 673,507.48 807,374.58 1,027,280.87 1,183,794.24
Other Assets 2,012,328.53 2,248,745.99 2,362,594.48 2,389,685.07
Total 2,699,160.53 3,072,321.48 3,441,759.51 3,616,439.17
Receivables
Inventory
Cash & Bank 188,481.05 204,559.47 273,197.16 195,289.11
No. of Equity Shares ### ### ### ###
New Bonus Shares
Face value 1.00 1.00 1.00 1.00

CASH FLOW:
Report Date Mar-15 Mar-16 Mar-17 Mar-18
Cash from Operating Activity 26,297.37 14,476.68 77,406.00 -96,507.91
Cash from Investing Activity -3,424.40 -2,746.71 -4,571.83 13,052.70
Cash from Financing Activity -1,553.27 4,348.45 -4,196.48 5,547.16
Net Cash Flow 21,319.70 16,078.42 68,637.69 -77,908.05

PRICE: 267.05 194.25 293.40 249.90

DERIVED:
Adjusted Equity Shares in Cr 746.57 776.28 797.35 892.46
 PLEASE DO NOT MAKE ANY CHANGES TO THIS SHEET

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

253,322.17 269,851.66 278,115.48 289,972.69 350,844.58 439,188.51

1,057.77 1,121.27 1,116.50 1,219.04 1,305.59 1,448.83

43,804.72 48,861.70 54,344.09 61,457.96 61,934.09 83,686.61
12,823.59 13,665.28 14,050.25 15,354.12 17,241.04 18,170.92
108,417.44 109,260.45 123,309.85 119,317.73 123,822.44 136,443.32
77,365.19 98,158.99 107,222.41 117,000.40 122,533.56 155,386.39
3,495.89 3,661.56 3,711.06 3,691.27 3,695.60 3,849.12
155,867.46 161,123.80 156,010.17 156,194.34 189,980.82 259,736.05
5,220.49 30,316.59 32,795.97 49,738.63 75,398.56 91,240.05
2,151.41 12,139.76 8,516.25 13,382.46 18,840.13 23,101.79
2,299.64 19,767.80 22,405.46 35,373.88 55,648.17 67,084.67
3,569.84 6,336.47 10,084.80 12,226.70

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

107,390.78 112,868.34 117,469.38 118,242.45 121,044.68 124,653.66
59,365.26 62,634.87 65,418.48 53,996.50 62,709.31 64,890.43
36,865.34 33,103.30 47,444.98 33,882.60 42,757.70 43,199.91

62,955.15 68,091.94 70,644.02 71,700.78 73,618.76 77,396.74

21,935.71 15,244.83 28,851.86 26,427.77 27,474.31 25,566.40
5,552.53 3,962.17 7,115.39 6,746.97 7,254.69 6,391.05
 16,099.58 11,064.14 21,384.15 19,324.96 19,782.76 18,853.16
48,025.52 50,233.47 52,050.90 64,245.95 58,335.37 59,763.23
84,607.26 83,118.25 99,143.56 97,772.71 100,656.21 102,640.95

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

892.46 892.46 892.46 892.46 892.46 892.46
233,603.20 250,167.66 274,669.10 304,695.58 358,038.86 414,046.71
413,747.66 332,900.67 433,796.21 449,159.78 521,151.95 639,609.50
3,240,216.71 3,613,524.94 4,136,257.07 4,606,130.02 5,074,331.24 5,679,206.93
3,888,460.03 4,197,485.73 4,845,614.84 5,360,877.84 5,954,414.51 6,733,755.60
39,940.76 39,608.41 41,600.44 41,032.49 45,879.72 46,071.69
762.30 469.76 116.35 27.57 66.02 42.45
1,119,269.82 1,228,284.28 1,595,100.27 1,776,489.90 1,913,107.86 2,110,548.23
2,728,487.15 2,929,123.28 3,208,797.78 3,543,327.88 3,995,360.91 4,577,093.23
3,888,460.03 4,197,485.73 4,845,614.84 5,360,877.84 5,954,414.51 6,733,755.60

225,512.26 254,315.26 347,707.04 398,905.12 318,311.91 326,572.30

### ### ### ### ### ###

1.00 1.00 1.00 1.00 1.00 1.00

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

29,556.01 23,928.53 89,918.93 57,694.85 -86,013.68 21,632.43
219.51 -555.05 -3,669.83 -2,652.25 -965.91 -3,475.76
447.64 5,429.52 7,142.67 -3,844.51 6,386.38 -9,896.28
30,223.16 28,803.00 93,391.77 51,198.09 -80,593.21 8,260.39

320.75 196.85 364.30 493.55 523.75 752.35

892.46 892.46 892.46 892.46 892.46 892.46

STATE BANK OF INDIA 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 207,974.34 220,632.75 230,447.10 228,970.28 253,322.17 269,851.66 278,115.48 289,972.69 350,844.58 439,188.51 481,410.17 549,777.76 480,880.49
Expenses 96,674.81 109,984.78 145,666.09 169,064.53 166,103.52 172,908.70 192,820.69 197,348.85 204,303.16 239,749.68 247,014.72 282,094.58 305,878.81
Operating Profit 111,299.53 110,647.97 84,781.01 59,905.75 87,218.65 96,942.96 85,294.79 92,623.84 146,541.42 199,438.83 234,395.45 267,683.18 175,001.68
Other Income 49,315.17 52,828.39 68,193.17 77,557.39 77,365.19 98,158.99 107,222.41 117,000.40 122,533.56 155,386.39 167,285.19 - -
Depreciation 1,581.49 2,252.21 2,914.68 3,105.07 3,495.89 3,661.56 3,711.06 3,691.27 3,695.60 3,849.12 - - -
Interest 133,178.64 143,047.36 149,114.67 146,602.98 155,867.46 161,123.80 156,010.17 156,194.34 189,980.82 259,736.05 293,360.30 293,360.30 293,360.30
Profit before tax 25,854.57 18,176.79 944.83 -12,244.91 5,220.49 30,316.59 32,795.97 49,738.63 75,398.56 91,240.05 108,320.34 -25,677.12 -118,358.62
Tax 8,337.20 5,433.50 1,335.50 -8,057.50 2,151.41 12,139.76 8,516.25 13,382.46 18,840.13 23,101.79 27,508.10 25% 25%
Net profit 16,994.30 12,224.60 241.23 -4,556.29 2,299.64 19,767.80 22,405.46 35,373.88 55,648.17 67,084.67 79,345.03 -19,156.38 -88,301.29
EPS 22.76 15.75 0.30 -5.11 2.58 22.15 25.11 39.64 62.35 75.17 88.91 -21.46 -98.94
Price to earning 11.73 12.34 969.79 -48.95 124.48 8.89 14.51 12.45 8.40 10.01 8.25 9.78 8.25
Price 267.05 194.25 293.40 249.90 320.75 196.85 364.30 493.55 523.75 752.35 733.15 -209.85 -815.91

RATIOS:
Dividend Payout 15.38% 16.51% 859.39% 0.00% 0.00% 0.00% 15.93% 17.91% 18.12% 18.23%
OPM 53.52% 50.15% 36.79% 26.16% 34.43% 35.92% 30.67% 31.94% 41.77% 45.41% 48.69%

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

Sales Growth 8.66% 9.65% 11.63% 16.45% 25.18% 25.18% 8.66%
OPM 38.81% 36.39% 38.14% 40.61% 48.69% 48.69% 36.39%
Price to Earning 118.08 26.71 10.42 9.78 8.25 9.78 8.25
STATE BANK OF INDIA SCREENER.IN

Narration Sep-22 Dec-22 Mar-23 Jun-23 Sep-23 Dec-23 Mar-24 Jun-24 Sep-24 Dec-24
Sales 84,462.87 91,517.66 98,083.19 101,460.01 107,390.78 112,868.34 117,469.38 118,242.45 121,044.68 124,653.66
Expenses 49,207.81 56,497.58 59,965.34 49,080.20 59,365.26 62,634.87 65,418.48 53,996.50 62,709.31 64,890.43
Operating Profit 35,255.06 35,020.08 38,117.85 52,379.81 48,025.52 50,233.47 52,050.90 64,245.95 58,335.37 59,763.23
Other Income 30,319.61 35,701.31 38,769.20 30,872.77 36,865.34 33,103.30 47,444.98 33,882.60 42,757.70 43,199.91
Depreciation - - - - - - - - - -
Interest 45,232.19 49,365.99 53,451.48 58,044.94 62,955.15 68,091.94 70,644.02 71,700.78 73,618.76 77,396.74
Profit before tax 20,342.48 21,355.40 23,435.57 25,207.64 21,935.71 15,244.83 28,851.86 26,427.77 27,474.31 25,566.40
Tax 5,325.20 5,685.75 5,092.32 6,471.69 5,552.53 3,962.17 7,115.39 6,746.97 7,254.69 6,391.05
Net profit 14,752.00 15,477.22 18,093.84 18,536.80 16,099.58 11,064.14 21,384.15 19,324.96 19,782.76 18,853.16

OPM 42% 38% 39% 52% 45% 45% 44% 54% 48% 48%

EBITDA 65309.39 70528.96 76637.64 83053.43 84607.26 83118.25 99143.56 97772.71 100656.21 102640.95
STATE BANK OF INDIA 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 746.57 776.28 797.35 892.46 892.46 892.46 892.46 892.46 892.46 892.46
Reserves 160,640.97 179,816.09 216,394.80 229,429.49 233,603.20 250,167.66 274,669.10 304,695.58 358,038.86 414,046.71
Borrowings 244,663.47 361,399.39 336,365.66 369,079.34 413,747.66 332,900.67 433,796.21 449,159.78 521,151.95 639,609.50
Other Liabilities 2,293,109.52 2,530,329.72 2,888,201.70 3,017,037.88 3,240,216.71 3,613,524.94 4,136,257.07 4,606,130.02 5,074,331.24 5,679,206.93
Total 2,699,160.53 3,072,321.48 3,441,759.51 3,616,439.17 3,888,460.03 4,197,485.73 4,845,614.84 5,360,877.84 5,954,414.51 6,733,755.60

Net Block 12,924.20 15,415.21 51,189.24 42,034.79 39,940.76 39,608.41 41,600.44 41,032.49 45,879.72 46,071.69
Capital Work in Progress 400.32 785.70 694.92 925.07 762.30 469.76 116.35 27.57 66.02 42.45
Investments 673,507.48 807,374.58 1,027,280.87 1,183,794.24 1,119,269.82 1,228,284.28 1,595,100.27 1,776,489.90 1,913,107.86 2,110,548.23
Other Assets 2,012,328.53 2,248,745.99 2,362,594.48 2,389,685.07 2,728,487.15 2,929,123.28 3,208,797.78 3,543,327.88 3,995,360.91 4,577,093.23
Total 2,699,160.53 3,072,321.48 3,441,759.51 3,616,439.17 3,888,460.03 4,197,485.73 4,845,614.84 5,360,877.84 5,954,414.51 6,733,755.60

Working Capital -280,780.99 -281,583.73 -525,607.22 -627,352.81 -511,729.56 -684,401.66 -927,459.29 -1,062,802.14 -1,078,970.33 -1,102,113.70
Debtors - - - - - - - - - -
Inventory - - - - - - - - - -

Debtor Days - - - - - - - - - -
Inventory Turnover - - - - - - - - - -

Return on Equity 11% 7% 0% -2% 1% 8% 8% 12% 16% 16%

Return on Capital Emp 34% 27% 23% 26% 31% 29% 28% 32% 36%
STATE BANK OF INDIA 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 26,297.37 14,476.68 77,406.00 -96,507.91 29,556.01 23,928.53 89,918.93 57,694.85 -86,013.68 21,632.43
Cash from Investing Activity -3,424.40 -2,746.71 -4,571.83 13,052.70 219.51 -555.05 -3,669.83 -2,652.25 -965.91 -3,475.76
Cash from Financing Activity -1,553.27 4,348.45 -4,196.48 5,547.16 447.64 5,429.52 7,142.67 -3,844.51 6,386.38 -9,896.28
Net Cash Flow 21,319.70 16,078.42 68,637.69 -77,908.05 30,223.16 28,803.00 93,391.77 51,198.09 -80,593.21 8,260.39
cash flow data
Mar-13 Mar-14 Mar-15 Mar-16 Mar-17 Mar-18
Cash from Operating Activity - 22,163 36,151 35,531 37,900 30,199 23,857
Profit from operations 24,406 36,303 43,397 38,626 28,840 33,312
Receivables -5,177 445 -3,179 -2,223 -4,152 -10,688
Inventory -2,656 -2,853 -3,692 -5,743 -6,621 -3,560
Payables 8,132 4,694 3,598 3,947 9,301 7,320
Loans Advances 0 0 0 -520 0 0
Other WC items -303 1,870 -398 5,852 4,727 494
Working capital changes -3 4,157 -3,672 1,313 3,254 -6,434
Direct taxes -2,240 -4,308 -4,194 -2,040 -1,895 -3,021
Cash from Investing Activity - -22,969 -27,991 -36,232 -36,694 -39,571 -25,139
Fixed assets purchased -18,863 -26,975 -31,962 -31,503 -16,072 -35,079
Fixed assets sold 37 50 74 59 53 30
Investments purchased 73 -429 -5,461 -4,728 -6 -329
Investments sold 34 4 42 89 1,965 2,381
Interest received 713 653 698 731 638 690
Dividends received 95 40 80 58 620 1,797
Investment in group cos 0 0 -160 0 -107 -4
Redemp n Canc of Shares 0 0 0 0 0 14
Acquisition of companies 0 -185 0 -111 0 0
Inter corporate deposits 45 0 0 0 0 0
Other investing items -5,103 -1,149 456 -1,289 -26,663 5,360
Cash from Financing Activity - -1,692 -3,883 5,201 -3,795 6,205 2,012
Proceeds from shares 1 0 0 7,433 5 0
Redemption of debentures -97 -658 -744 0 0 0
Proceeds from borrowings 27,863 33,258 36,363 19,519 33,390 37,482
Repayment of borrowings -20,395 -29,141 -23,332 -24,924 -21,732 -29,964
Interest paid fin -4,666 -6,171 -6,307 -5,716 -5,336 -5,411
Dividends paid -1,551 -722 -720 -108 -121 -96
Financial liabilities 0 0 0 0 0 0
Other financing items -2,849 -450 -57 0 0 0
Net Cash Flow -2,499 4,277 4,500 -2,589 -3,167 730
Mar-19 Mar-20 Mar-21 Mar-22 Mar-23 Mar-24
18,891 26,633 29,001 14,283 35,388 67,915
28,771 23,352 31,198 26,943 41,694 65,106
-9,109 9,950 -5,505 185 -2,213 -1,875
2,069 2,326 3,814 472 -5,665 -7,265
-4,692 -8,085 5,748 -7,012 6,945 13,706
0 0 0 0 0 0
4,512 875 -4,150 -4,396 -2,194 2,760
-7,221 5,065 -93 -10,750 -3,127 7,325
-2,659 -1,785 -2,105 -1,910 -3,179 -4,516
-20,878 -33,115 -25,672 -4,444 -15,417 -22,782
-35,304 -29,702 -20,205 -15,168 -19,230 -31,414
67 171 351 230 285 231
-130 -1,439 -7,530 -3,008 -50 -74
5,644 21 226 104 6,895 10,820
761 1,104 428 653 973 2,493
232 21 18 32 46 47
-9 -606 -10 0 0 -150
533 0 0 0 19 108
-8 -27 0 -98 0 0
0 0 0 0 0 -24
7,335 -2,659 1,051 12,813 -4,357 -4,817
8,830 3,390 9,904 -3,380 -26,243 -37,006
0 3,889 2,603 19 20 82
0 0 0 0 0 0
51,128 38,297 46,641 46,578 43,934 18,747
-35,198 -29,847 -29,709 -42,816 -62,557 -47,332
-7,005 -7,518 -8,123 -9,251 -9,336 -9,332
-95 -57 -30 -100 -141 -1,059
0 -1,346 -1,477 -1,559 -1,517 -1,924
0 -29 0 3,750 3,355 3,812
6,843 -3,092 13,232 6,459 -6,272 8,128
 Historical Financial Statement - STATE BANK OF INDIA
Years Mar-15 Mar-16 Mar-17 Mar-18 Mar-19 Mar-20 Mar-21 Mar-22 Mar-23 Mar-24 LTM
w
# Income Statement

# Balance sheet

# Cash Flow Statements

 Historical Financial Statement - STATE BANK OF INDIA
Years Mar-15 Mar-16 Mar-17 Mar-18 Mar-19 Mar-20 Mar-21 Mar-22 Mar-23 Mar-24 LTM
f
# Income Statement
Sales ₹207,974.3 ₹220,632.8 ₹230,447.1 ₹228,970.3 ₹253,322.2 ₹269,851.7 ₹278,115.5 ₹289,972.7 ₹350,844.6 ₹439,188.5 ₹481,410.2
Sales Growth - 6.09% 4.45% -0.64% 10.64% 6.53% 3.06% 4.26% 20.99% 25.18% 9.61%

COGS ₹31,853.7 ₹33,330.4 ₹36,571.7 ₹36,389.1 ₹44,862.5 ₹49,983.0 ₹55,460.6 ₹62,677.0 ₹63,239.7 ₹85,135.4 ₹247,014.7
COGS % Sales 15.32% 15.11% 15.87% 15.89% 17.71% 18.52% 19.94% 21.61% 18.02% 19.38% 51.31%

Gross Profit ₹176,120.7 ₹187,302.4 ₹193,875.4 ₹192,581.2 ₹208,459.7 ₹219,868.7 ₹222,654.9 ₹227,295.7 ₹287,604.9 ₹354,053.1 ₹234,395.5
Gross Margin 84.68% 84.89% 84.13% 84.11% 82.29% 81.48% 80.06% 78.39% 81.98% 80.62% 48.69%

Selling Exp ,General Exp & Other Exp. ₹114,136.3 ₹129,482.8 ₹177,287.6 ₹210,232.9 ₹198,606.2 ₹221,084.7 ₹244,582.5 ₹251,672.3 ₹263,597.0 ₹310,000.6
S&G Exp % Sales 54.88% 58.69% 76.93% 91.82% 78.40% 81.93% 87.94% 86.79% 75.13% 70.58%

EBITDA ₹61,984.4 ₹57,819.6 ₹16,587.8 (₹17,651.6) ₹9,853.5 (₹1,216.0) (₹21,927.6) (₹24,376.6) ₹24,007.9 ₹44,052.4 ₹400,213.4
EBITDA % Sales 29.80% 26.21% 7.20% -7.71% 3.89% -0.45% -7.88% -8.41% 6.84% 10.03% 83.13%

Intrest ₹133,178.6 ₹143,047.4 ₹149,114.7 ₹146,603.0 ₹155,867.5 ₹161,123.8 ₹156,010.2 ₹156,194.3 ₹189,980.8 ₹259,736.1 ₹293,360.3
Intrest % Sales 64.04% 64.84% 64.71% 64.03% 61.53% 59.71% 56.10% 53.87% 54.15% 59.14% 60.94%

Depreciation ₹1,581.5 ₹2,252.2 ₹2,914.7 ₹3,105.1 ₹3,495.9 ₹3,661.6 ₹3,711.1 ₹3,691.3 ₹3,695.6 ₹3,849.1 -
Depreciation % Sales 0.76% 1.02% 1.26% 1.36% 1.38% 1.36% 1.33% 1.27% 1.05% 0.88% 0.00%

Ernings Befor Tax (₹72,775.8) (₹87,480.0) (₹135,441.5) (₹167,359.7) (₹149,509.9) (₹166,001.4) (₹181,648.9) (₹184,262.2) (₹169,668.6) (₹219,532.7) ₹106,853.1
EBT % Sales -34.99% -39.65% -58.77% -73.09% -59.02% -61.52% -65.31% -63.54% -48.36% -49.99% 22.20%

Tax ₹8,337.2 ₹5,433.5 ₹1,335.5 (₹8,057.5) ₹2,151.4 ₹12,139.8 ₹8,516.3 ₹13,382.5 ₹18,840.1 ₹23,101.8 ₹27,508.1
Effective Tax Rate -11.46% -6.21% -0.99% 4.81% -1.44% -7.31% -4.69% -7.26% -11.10% -10.52% 25.74%

Net Profit (₹81,113.0) (₹92,913.5) (₹136,777.0) (₹159,302.2) (₹151,661.3) (₹178,141.2) (₹190,165.1) (₹197,644.6) (₹188,508.7) (₹242,634.5) ₹79,345.0
Net Margins -39.00% -42.11% -59.35% -69.57% -59.87% -66.01% -68.38% -68.16% -53.73% -55.25% 16.48%

No of Equity Shares ₹746.6 ₹776.3 ₹797.4 ₹892.5 ₹892.5 ₹892.5 ₹892.5 ₹892.5 ₹892.5 ₹892.5 ₹892.5

Earning Per Share (₹108.6) (₹119.7) (₹171.5) (₹178.5) (₹169.9) (₹199.6) (₹213.1) (₹221.5) (₹211.2) (₹271.9) ₹88.9
EPS Growth % 10.16% 43.32% 4.06% -4.80% 17.46% 6.75% 3.93% -4.62% 28.71% -132.70%

Dividend per Share ₹3.5 ₹2.6 ₹2.6 - - - ₹4.0 ₹7.1 ₹11.3 ₹13.7 -
Dividend payout ratio -3.22% -2.17% -1.52% 0.00% 0.00% 0.00% -1.88% -3.21% -5.35% -5.04% 0.00%
 Retained Earnings 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 100.00%

# Balance Sheet

Equity Share Capital ₹746.6 ₹776.3 ₹797.4 ₹892.5 ₹892.5 ₹892.5 ₹892.5 ₹892.5 ₹892.5 ₹892.5
Reserves ₹160,641.0 ₹179,816.1 ₹216,394.8 ₹229,429.5 ₹233,603.2 ₹250,167.7 ₹274,669.1 ₹304,695.6 ₹358,038.9 ₹414,046.7
Borrowings ₹244,663.5 ₹361,399.4 ₹336,365.7 ₹369,079.3 ₹413,747.7 ₹332,900.7 ₹433,796.2 ₹449,159.8 ₹521,152.0 ₹639,609.5
Other Liabilities ₹2,293,109.5 ₹2,530,329.7 ₹2,888,201.7 ₹3,017,037.9 ₹3,240,216.7 ₹3,613,524.9 ₹4,136,257.1 ₹4,606,130.0 ₹5,074,331.2 ₹5,679,206.9
Total Liabilities ₹2,699,160.5 ₹3,072,321.5 ₹3,441,759.5 ₹3,616,439.2 ₹3,888,460.0 ₹4,197,485.7 ₹4,845,614.8 ₹5,360,877.8 ₹5,954,414.5 ₹6,733,755.6

Fixed Assets Net Block ₹12,924.2 ₹15,415.2 ₹51,189.2 ₹42,034.8 ₹39,940.8 ₹39,608.4 ₹41,600.4 ₹41,032.5 ₹45,879.7 ₹46,071.7
Capital Work in Progress ₹400.3 ₹785.7 ₹694.9 ₹925.1 ₹762.3 ₹469.8 ₹116.4 ₹27.6 ₹66.0 ₹42.5
Investments ₹673,507.5 ₹807,374.6 ₹1,027,280.9 ₹1,183,794.2 ₹1,119,269.8 ₹1,228,284.3 ₹1,595,100.3 ₹1,776,489.9 ₹1,913,107.9 ₹2,110,548.2
Other Assets ₹1,823,847.5 ₹2,044,186.5 ₹2,089,397.3 ₹2,194,396.0 ₹2,502,974.9 ₹2,674,808.0 ₹2,861,090.7 ₹3,144,422.8 ₹3,677,049.0 ₹4,250,520.9
Total Non Current Assets ₹2,510,679.5 ₹2,867,762.0 ₹3,168,562.4 ₹3,421,150.1 ₹3,662,947.8 ₹3,943,170.5 ₹4,497,907.8 ₹4,961,972.7 ₹5,636,102.6 ₹6,407,183.3

Receivables - - - - - - - - - -
Inventory - - - - - - - - - -
Cash & Bank ₹188,481.1 ₹204,559.5 ₹273,197.2 ₹195,289.1 ₹225,512.3 ₹254,315.3 ₹347,707.0 ₹398,905.1 ₹318,311.9 ₹326,572.3
Total Current Assets ₹188,481.1 ₹204,559.5 ₹273,197.2 ₹195,289.1 ₹225,512.3 ₹254,315.3 ₹347,707.0 ₹398,905.1 ₹318,311.9 ₹326,572.3

Total Assets ₹2,699,160.5 ₹3,072,321.5 ₹3,441,759.5 ₹3,616,439.2 ₹3,888,460.0 ₹4,197,485.7 ₹4,845,614.8 ₹5,360,877.8 ₹5,954,414.5 ₹6,733,755.6

Check 1 TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE

# Cash Flow Statements

Cash from Operating Activities ₹26,297.4 ₹14,476.7 ₹77,406.0 (₹96,507.9) ₹29,556.0 ₹23,928.5 ₹89,918.9 ₹57,694.9 (₹86,013.7) ₹21,632.4
Cash from Operating Activities (₹3,424.4) (₹2,746.7) (₹4,571.8) ₹13,052.7 ₹219.5 (₹555.1) (₹3,669.8) (₹2,652.3) (₹965.9) (₹3,475.8)
Cash from Investing Activities (₹1,553.3) ₹4,348.5 (₹4,196.5) ₹5,547.2 ₹447.6 ₹5,429.5 ₹7,142.7 (₹3,844.5) ₹6,386.4 (₹9,896.3)
Net Cash Flow ₹21,319.7 ₹16,078.4 ₹68,637.7 (₹77,908.1) ₹30,223.2 ₹28,803.0 ₹93,391.8 ₹51,198.1 (₹80,593.2) ₹8,260.4
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
s… do ANYTHING.