Sales 151% 158% 155% 143% 131% 133% 135% 137% 133%

Expenses 151% 112% 124% 125% 137% 129% 134% 138% 139%
Operating Profit 150% 243% 182% 153% 128% 136% 136% 136% 131%
Net profit 264% 276% 165% 145% 122% 125% 142% 144% 144%
BAJAJ FINANCE LTD SCREENER.IN

Narration Mar-09 Mar-10 Mar-11 Mar-12 Mar-13 Mar-14 Mar-15 Mar-16 Mar-17 Mar-18 Trailing Best Case Worst Case 1.01
Sales 584.06 880.23 1,392.73 2,163.48 3,092.46 4,041.60 5,392.24 7,298.50 9,966.35 13,289.63 14,819.85 17,951.23 18,231.31 1.42
Expenses 378.46 572.55 643.68 798.59 997.72 1,361.90 1,751.71 2,353.44 3,247.66 4,503.71 4,638.63 5,618.75 6,295.29 1.32
Operating Profit 205.60 307.68 749.05 1,364.89 2,094.74 2,679.70 3,640.53 4,945.06 6,718.69 8,785.92 10,181.22 12,332.47 11,936.02 1.52
Operating Profit % 35.20 34.95 53.78 63.09 67.74 66.30 67.51 67.75 67.41 66.11 68.70 68.70 65.47 1.07
Other Income 15.33 35.90 13.40 8.43 17.15 32.32 25.75 34.63 22.62 39.22 64.21 - - 1.11
Other Income % 7% 12% 2% 1% 1% 1% 1% 1% 0% 0% 1% 0% 0% 0.73
EBIDT 220.93 343.58 762.45 1,373.32 2,111.89 2,712.02 3,666.28 4,979.69 6,741.31 8,825.14 10,245.43 12,332.47 11,936.02 1.51
EBIDT % 37.83 39.03 54.74 63.48 68.29 67.10 67.99 68.23 67.64 66.41 69.13 68.70 65.47 1.06
Depreciation 5.57 7.64 9.64 11.77 19.56 29.19 35.60 56.34 71.16 101.96 116.56 116.56 116.56 1.38
Interest 164.35 201.67 382.94 759.33 1,220.73 1,591.67 2,273.74 2,958.78 3,852.63 4,666.82 5,088.30 5,088.30 5,088.30 1.45
Interest Coverage Ratio 1.25 1.53 1.96 1.80 1.72 1.68 1.60 1.67 1.74 1.88 2.00 2.42 2.35 1.05
Profit before tax 51.01 134.27 369.87 602.22 871.60 1,091.16 1,356.94 1,964.57 2,817.52 4,056.36 5,040.57 7,127.61 6,731.16 1.63
Profit before tax % 8.73 15.25 26.56 27.84 28.18 27.00 25.16 26.92 28.27 30.52 34.01 39.71 36.92 1.15
Tax 17.10 44.86 122.91 195.78 280.29 372.15 459.07 686.05 980.97 1,409.66 1,776.97 35% 35% 1.63
Tax % 33.52 33.41 33.23 32.51 32.16 34.11 33.83 34.92 34.82 34.75 35.25 0.00 0.01 1.00
Net profit 33.91 89.41 246.96 406.44 591.31 719.01 897.87 1,278.52 1,836.55 2,646.70 3,263.60 4,614.89 4,358.20 1.62
Net profit % 5.81 10.16 17.73 18.79 19.12 17.79 16.65 17.52 18.43 19.92 22.02 25.71 23.91 1.15
EPS 0.75 1.98 5.46 8.54 11.41 13.83 17.26 23.73 33.40 45.79 56.47 79.85 75.41 1.58
Price to earning 10.96 18.25 12.61 9.85 10.33 12.92 24.89 29.62 37.32 41.59 46.04 46.04 23.13 1.16
Price 8.22 36.07 68.84 84.15 117.85 178.68 429.72 703.02 1,246.30 1,904.50 2,599.55 3,675.89 1,743.83 1.83
#DIV/0!
RATIOS: #DIV/0!
Dividend Payout 21.59% 24.56% 14.83% 12.20% 12.57% 11.07% 10.02% 10.47% 10.72% 8.69% 0.90
OPM 35.20% 34.95% 53.78% 63.09% 67.74% 66.30% 67.51% 67.75% 67.41% 66.11% 68.70% 1.07

Price/Sales 1.41%
TRENDS: 10 YEARS 7 YEARS 5 YEARS 3 YEARS RECENT BEST WORST
Sales Growth 41.51% 38.02% 33.86% 35.08% 33.35% 35.08% 33.35%
OPM 65.47% 66.81% 66.94% 66.93% 68.70% 68.70% 65.47%
Price to Earning 23.13 26.57 32.06 38.64 46.04 46.04 23.13
Sales 102% 115% 99% 106% 108% 117% 96%
Expenses 101% 115% 115% 105% 95% 120% 93%
Operating Profit 103% 115% 92% 107% 115% 115% 98%
Net profit 96% 136% 81% 102% 130% 129% 97%
BAJAJ FINANCE LTD SCREENER.IN

Narration Jun-16 Sep-16 Dec-16 Mar-17 Jun-17 Sep-17 Dec-17 Mar-18 Jun-18 Sep-18
Sales 2,280.17 2,335.50 2,688.23 2,661.81 2,826.55 3,042.06 3,554.44 3,428.72 3,791.34 4,045.35
Expenses 730.96 740.87 852.01 976.62 1,026.47 974.54 1,169.43 1,087.54 1,176.95 1,204.71
Operating Profit 1,549.21 1,594.63 1,836.22 1,685.19 1,800.08 2,067.52 2,385.01 2,341.18 2,614.39 2,840.64
Other Income 1.61 5.58 11.70 7.91 0.82 15.50 -11.15 22.47 4.85 48.04
Depreciation 15.98 17.75 17.72 19.71 21.88 24.07 26.76 29.25 28.70 31.85
Interest 883.31 956.16 980.20 983.69 1,072.76 1,140.55 1,170.88 1,195.06 1,294.17 1,428.19
Profit before tax 651.53 626.30 850.00 689.70 706.26 918.40 1,176.22 1,139.34 1,296.37 1,428.64
Tax 227.54 218.54 294.35 240.55 249.86 324.83 409.41 396.56 462.64 508.36
Net profit 423.99 407.76 555.65 449.15 456.40 593.57 766.81 742.78 833.73 920.28

OPM 68% 68% 68% 63% 64% 68% 67% 68% 69% 70%
BAJAJ FINANCE LTD SCREENER.IN

Narration Mar-09 Mar-10 Mar-11 Mar-12 Mar-13 Mar-14 Mar-15 Mar-16 Mar-17 Mar-18
Equity Share Capital 36.60 36.60 36.63 41.32 49.54 49.75 50.00 53.55 109.37 115.03
Reserves 1,052.14 1,115.94 1,321.48 1,970.93 3,302.44 3,941.11 4,749.70 7,271.06 9,490.94 16,403.26
Total Shareholder Funds 1,088.74 1,152.54 1,358.11 2,012.25 3,351.98 3,990.86 4,799.70 7,324.61 9,600.31 16,518.29
Borrowings 1,611.40 3,226.76 6,703.35 10,226.43 13,133.23 19,749.59 26,654.70 37,024.70 49,249.65 61,567.03
Other Liabilities 316.21 213.74 461.46 694.06 1,330.05 889.62 1,338.12 2,639.00 4,899.86 5,558.66
Total 3,016.35 4,593.04 8,522.92 12,932.74 17,815.26 24,630.07 32,792.52 46,988.31 63,749.82 83,643.98
Debt/Equity Ratio 1.48 2.80 4.94 5.08 3.92 4.95 5.55 5.05 5.13 3.73
Current Ratio 0.13 0.10 1.89 0.09 0.31 0.87 0.17 0.50 0.07 0.04
Net Block 20.20 50.45 102.60 138.79 176.21 219.87 249.18 287.00 361.13 464.66
Capital Work in Progress - - - - - - - - - -
Investments 273.91 301.83 5.61 5.48 5.26 28.21 332.29 1,034.07 4,074.70 3,660.46
Other Assets 2,722.24 4,240.76 8,414.71 12,788.47 17,633.79 24,381.99 32,211.05 45,667.24 59,313.99 79,518.86
Total 3,016.35 4,593.04 8,522.92 12,932.74 17,815.26 24,630.07 32,792.52 46,988.31 63,749.82 83,643.98

Working Capital 2,406.03 4,027.02 7,953.25 12,094.41 16,303.74 23,492.37 30,872.93 43,028.24 54,414.13 73,960.20
Debtors - - - - - - - - - -
Inventory - - - - - - - - - -

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

Return on Equity 3% 8% 18% 20% 18% 18% 19% 17% 19% 16%
Return on Capital Emp 8% 6% 8% 9% 11% 10% 10% 10% 10% 10%
BAJAJ FINANCE LTD SCREENER.IN

Narration Mar-09 Mar-10 Mar-11 Mar-12 Mar-13 Mar-14 Mar-15 Mar-16 Mar-17 Mar-18
Cash from Operating Activity -132.33 -1,559.89 -2,841.97 -4,568.06 -3,250.87 -6,086.57 -7,147.14 -9,870.83 -10,439.98 -17,091.82 -62,989.46 1.72
Cash from Investing Activity 42.58 -66.09 -59.38 -50.91 -56.37 -95.81 -365.42 -685.90 -3,048.24 405.49 -3,980.05 1.28
Cash from Financing Activity -57.45 1,606.56 3,457.88 3,807.13 3,663.78 6,542.82 6,953.19 11,656.20 12,515.94 16,588.95 66,735.00 -1.88
Net Cash Flow -147.20 -19.42 556.53 -811.84 356.54 360.44 -559.37 1,099.47 -972.28 -97.38 -234.51

Net profit 33.91 89.41 246.96 406.44 591.31 719.01 897.87 1278.52 1836.55 2646.7 8,746.68 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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
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: screener.feedback@dalal-street.in
… do ANYTHING.

dalal-street.in
COMPANY NAME BAJAJ FINANCE LTD
LATEST VERSION 2.10 PLEASE
CURRENT VERSION 2.10

META
Number of shares 57.80
Face Value 2
Current Price 2599.55
Market Capitalization 150245.77

PROFIT & LOSS

Report Date Mar-09 Mar-10 Mar-11 Mar-12
Sales 584.06 880.23 1,392.73 2,163.48
Raw Material Cost
Change in Inventory
Power and Fuel
Other Mfr. Exp
Employee Cost 71.57 97.78 144.72 190.35
Selling and admin 93.50 122.27 182.89 296.84
Other Expenses 213.39 352.50 316.07 311.40
Other Income 15.33 35.90 13.40 8.43
Depreciation 5.57 7.64 9.64 11.77
Interest 164.35 201.67 382.94 759.33
Profit before tax 51.01 134.27 369.87 602.22
Tax 17.10 44.86 122.91 195.78
Net profit 33.91 89.41 246.96 406.44
Dividend Amount 7.32 21.96 36.63 49.58

Quarters
Report Date Jun-16 Sep-16 Dec-16 Mar-17
Sales 2,280.17 2,335.50 2,688.23 2,661.81
Expenses 730.96 740.87 852.01 976.62
Other Income 1.61 5.58 11.70 7.91
Depreciation 15.98 17.75 17.72 19.71
Interest 883.31 956.16 980.20 983.69
Profit before tax 651.53 626.30 850.00 689.70
Tax 227.54 218.54 294.35 240.55
Net profit 423.99 407.76 555.65 449.15
Operating Profit 1549.21 1594.63 1836.22 1685.19
BALANCE SHEET
Report Date Mar-09 Mar-10 Mar-11 Mar-12
Equity Share Capital 36.6 36.6 36.63 41.32
Reserves 1052.14 1115.94 1321.48 1970.93
Borrowings 1611.4 3226.76 6703.35 10226.43
Other Liabilities 316.21 213.74 461.46 694.06
Total 3,016.35 4,593.04 8,522.92 12,932.74
Net Block 20.2 50.45 102.6 138.79
Capital Work in Progress
Investments 273.91 301.83 5.61 5.48
Other Assets 2722.24 4240.76 8414.71 12788.47
Total 3,016.35 4,593.04 8,522.92 12,932.74
Receivables
Inventory
Cash & Bank 41.79 22.37 871.67 59.83
No. of Equity Shares 36597076 36597076 36630076 41320076
New Bonus Shares
Face value 10 10 10 10

CASH FLOW:
Report Date Mar-09 Mar-10 Mar-11 Mar-12
Cash from Operating Activity -132.33 -1,559.89 -2,841.97 -4,568.06
Cash from Investing Activity 42.58 -66.09 -59.38 -50.91
Cash from Financing Activity -57.45 1,606.56 3,457.88 3,807.13
Net Cash Flow -147.20 -19.42 556.53 -811.84

PRICE: 8.22 36.07 68.84 84.15

DERIVED:
Adjusted Equity Shares in Cr 45.23 45.23 45.25 47.60
 PLEASE DO NOT MAKE ANY CHANGES TO THIS SHEET

Mar-13 Mar-14 Mar-15 Mar-16 Mar-17 Mar-18

3,092.46 4,041.60 5,392.24 7,298.50 9,966.35 13,289.63

245.15 340.81 450.73 629.63 931.67 1,401.43

352.54 463.67 577.95 682.03 789.78 1,041.32
400.03 557.42 723.03 1,041.78 1,526.21 2,060.96
17.15 32.32 25.75 34.63 22.62 39.22
19.56 29.19 35.60 56.34 71.16 101.96
1,220.73 1,591.67 2,273.74 2,958.78 3,852.63 4,666.82
871.60 1,091.16 1,356.94 1,964.57 2,817.52 4,056.36
280.29 372.15 459.07 686.05 980.97 1,409.66
591.31 719.01 897.87 1,278.52 1,836.55 2,646.70
74.31 79.60 90.00 133.88 196.87 230.06

Jun-17 Sep-17 Dec-17 Mar-18 Jun-18 Sep-18

2,826.55 3,042.06 3,554.44 3,428.72 3,791.34 4,045.35
1,026.47 974.54 1,169.43 1,087.54 1,176.95 1,204.71
0.82 15.50 -11.15 22.47 4.85 48.04
21.88 24.07 26.76 29.25 28.70 31.85
1,072.76 1,140.55 1,170.88 1,195.06 1,294.17 1,428.19
706.26 918.40 1,176.22 1,139.34 1,296.37 1,428.64
249.86 324.83 409.41 396.56 462.64 508.36
456.40 593.57 766.81 742.78 833.73 920.28
1800.08 2067.52 2385.01 2341.18 2614.39 2840.64
Mar-13 Mar-14 Mar-15 Mar-16 Mar-17 Mar-18
49.54 49.75 50 53.55 109.37 115.03
3302.44 3941.11 4749.7 7271.06 9490.94 16403.26
13133.23 19749.59 26654.7 37024.7 49249.65 61567.03
1330.05 889.62 1338.12 2639 4899.86 5558.66
17,815.26 24,630.07 32,792.52 46,988.31 63,749.82 83,643.98
176.21 219.87 249.18 287 361.13 464.66

5.26 28.21 332.29 1034.07 4074.7 3660.46

17633.79 24381.99 32211.05 45667.24 59313.99 79518.86
17,815.26 24,630.07 32,792.52 46,988.31 63,749.82 83,643.98

416.37 776.81 228.62 1329.15 325.8 228.73

49778334 50142300 50147259 53872190 549890090 577968388
269360950
10 10 10 10 2 2

Mar-13 Mar-14 Mar-15 Mar-16 Mar-17 Mar-18

-3,250.87 -6,086.57 -7,147.14 -9,870.83 -10,439.98 -17,091.82
-56.37 -95.81 -365.42 -685.90 -3,048.24 405.49
3,663.78 6,542.82 6,953.19 11,656.20 12,515.94 16,588.95
356.54 360.44 -559.37 1,099.47 -972.28 -97.38

117.85 178.68 429.72 703.02 1,246.30 1,904.50

51.83 52.01 52.01 53.87 54.99 57.80