Market Cap 3126 cr Latest Corporate Action

Bajaj Consumer Care - Listing Of

167803 Shares

The Company has received approval for the

listing of 167803 shares allotted to the eligible
employee on March 1, 2024 under Employee
Restricted Stock Unit Plan pursuant to exercise
of options granted earlier.
 Historical Financial Statement -Bajaj Consumer Care
Years Mar-18 Mar-19 Mar-20 Mar-21 Mar-22 Mar-23

# Income Statement
Sales ₹ 25,209.93 ₹ 30,357.63 ₹ 29,918.65 ₹ 27,741.08 ₹ 33,144.71 ₹ 36,455.38
Sales Growth 20.42% -1.45% -7.28% 19.48% 9.99%
14.73%
Other Income ₹ 1,403.72 ₹ 2,027.83 ₹ 1,832.38 ₹ 1,569.68 ₹ 2,671.30 ₹ 1,702.70
% of sales 5.57% 6.68% 6.12% 5.66% 8.06% 4.67%

Total Income ₹ 26,613.65 ₹ 32,385.46 ₹ 31,751.03 ₹ 29,310.76 ₹ 35,816.01 ₹ 38,158.08

COGS ₹ 18,060.51 ₹ 22,546.68 ₹ 21,823.68 ₹ 20,298.10 ₹ 25,274.11 ₹ 26,987.40

COGS % Sales 71.64% 74.27% 72.94% 73.17% 76.25% 74.03%

Gross Profit ₹ 8,553.14 ₹ 9,838.78 ₹ 9,927.35 ₹ 9,012.66 ₹ 10,541.90 ₹ 11,170.68

Gross Margin 33.93% 32.41% 33.18% 32.49% 31.81% 30.64%

Selling & General Exp ₹ 2,303.62 ₹ 2,613.03 ₹ 2,985.63 ₹ 2,505.20 ₹ 2,611.80 ₹ 3,003.34
S&G Exp % Sales 9.14% 8.61% 9.98% 9.03% 7.88% 8.24%

EBITDA ₹ 6,249.52 ₹ 7,225.75 ₹ 6,941.72 ₹ 6,507.46 ₹ 7,930.10 ₹ 8,167.34

EBITDA % Sales (Marg 24.79% 23.80% 23.20% 23.46% 23.93% 22.40%

Interest ₹ 1.31 ₹ 4.48 ₹ 3.16 ₹ 6.66 ₹ 8.66 ₹ 39.51

Interest % Sales 0.01% 0.01% 0.01% 0.02% 0.03% 0.11%
0.02%
Depriciation ₹ 314.80 ₹ 265.69 ₹ 246.43 ₹ 259.37 ₹ 269.76 ₹ 285.85
Depriciation % Sales 1.25% 0.88% 0.82% 0.93% 0.81% 0.78%
0.90%
Earnings Before Tax ₹ 5,933.41 ₹ 6,955.58 ₹ 6,692.13 ₹ 6,241.43 ₹ 7,651.68 ₹ 7,841.98
EBT % Sales 23.54% 22.91% 22.37% 22.50% 23.09% 21.51%

Tax ₹ 1,714.47 ₹ 2,027.98 ₹ 1,480.22 ₹ 1,384.41 ₹ 1,485.81 ₹ 1,781.77

Effective Tax Rate 28.90% 29.16% 22.12% 22.18% 19.42% 22.72%
22.72%
Net Profit ₹ 4,218.94 ₹ 4,927.60 ₹ 5,211.91 ₹ 4,857.02 ₹ 6,165.87 ₹ 6,060.21
Net Margin 16.74% 16.23% 17.42% 17.51% 18.60% 16.62%

No of Equity Shares 28.94 28.94 28.94 28.94 28.94 28.30

Earnings Per Share ₹ 145.78 ₹ 170.27 ₹ 180.09 ₹ 167.83 ₹ 213.06 ₹ 214.14

EPS Growth 16.80% 5.77% -6.81% 26.95% 0.51%
 Divedend Paid 1736.22 1736.22 3472.44 4051.18 4051.18 3961.44
Dividend Per Share ₹ 59.99 ₹ 59.99 ₹ 119.99 ₹ 139.99 ₹ 139.99 ₹ 139.98
Dividend Payout Ratio 41.15% 35.23% 66.63% 83.41% 65.70% 65.37%
Median 53.35%
Retained Earnings 58.85% 64.77% 33.37% 16.59% 34.30% 34.63%
₹ 2,482.72 ₹ 3,191.38 ₹ 1,739.47 ₹ 805.84 ₹ 2,114.69 ₹ 2,098.77
# Balance Sheet
EQUITIES AND LIABILITIES
SHAREHOLDER'S FUNDS
Equity Share Capital ₹ 14.75 ₹ 14.75 ₹ 14.75 ₹ 14.75 ₹ 14.75 ₹ 14.75
Reserves and Surplus ₹ 487.02 ₹ 490.61 ₹ 470.37 ₹ 659.60 ₹ 765.78 ₹ 822.66
Employees Stock Opti ₹ 0.00 ₹ 0.00 ₹ 0.00 ₹ 2.83 ₹ 0.93 ₹ 1.76
Total Shareholders F ₹ 501.77 ₹ 505.36 ₹ 485.12 ₹ 677.18 ₹ 781.46 ₹ 839.17

NON-CURRENT LIABILITIES
Other Long Term Liabil ₹ 0.00 ₹ 0.00 ₹ 0.00 ₹ 0.00 ₹ 1.18 ₹ 3.67
Total Non-Current Liabi ₹ 0.00 ₹ 0.00 ₹ 0.00 ₹ 0.00 ₹ 1.18 ₹ 3.67
TOTAL NON-CURRENT L ₹ 0.00 ₹ 0.00 ₹ 0.00 ₹ 0.00 ₹ 2.36 ₹ 7.34

CURRENT LIABILITIES
Short Term Borrowing ₹ 15.00 ₹ 13.49 ₹ 25.00 ₹ 20.00 ₹ 5.00 ₹ 0.00
Trade Payables ₹ 39.83 ₹ 59.72 ₹ 72.20 ₹ 80.92 ₹ 68.74 ₹ 45.34
Other Current Liabiliti ₹ 35.44 ₹ 38.04 ₹ 38.67 ₹ 57.02 ₹ 59.23 ₹ 67.13
Short Term Provisions ₹ 0.24 ₹ 0.22 ₹ 0.58 ₹ 0.11 ₹ 0.00 ₹ 0.00
Total Current Liabiliti ₹ 90.50 ₹ 111.47 ₹ 136.46 ₹ 158.05 ₹ 132.97 ₹ 112.47

Total Capital And Liabi ₹ 592.27 ₹ 616.83 ₹ 621.58 ₹ 835.23 ₹ 916.79 ₹ 958.98

ASSETS
NON-CURRENT ASSETS ₹ 3.27
Capital Work-In-Progr ₹ 0.03 ₹ 5.86 ₹ 7.74 ₹ 7.05 ₹ 7.08 ₹ 1.36
Fixed Assets (Net Bloc ₹ 169.79 ₹ 181.89 ₹ 193.65 ₹ 198.12 ₹ 194.50 ₹ 207.07
Long Term Loans And ₹ 0.91 ₹ 1.29 ₹ 2.62 ₹ 3.67 ₹ 0.00 ₹ 0.00
Other Non-Current As ₹ 1.24 ₹ 1.05 ₹ 0.52 ₹ 0.59 ₹ 3.84 ₹ 4.54
₹ 4.20
Total Non-Current Ass ₹ 171.97 ₹ 190.09 ₹ 204.53 ₹ 209.43 ₹ 205.42 ₹ 212.97

CURRENT ASSETS
Current Investments ₹ 338.54 ₹ 307.17 ₹ 250.88 ₹ 446.29 ₹ 584.55 ₹ 611.64
Inventories ₹ 42.48 ₹ 42.78 ₹ 59.28 ₹ 61.98 ₹ 42.45 ₹ 55.37
Trade Receivables ₹ 25.50 ₹ 38.87 ₹ 41.20 ₹ 28.60 ₹ 26.07 ₹ 20.03
Cash And Cash Equiva ₹ 13.78 ₹ 37.92 ₹ 65.69 ₹ 88.93 ₹ 58.30 ₹ 58.97
Total Current Assets ₹ 420.30 ₹ 426.74 ₹ 417.05 ₹ 625.80 ₹ 711.37 ₹ 746.01
 Total Assets ₹ 592.27 ₹ 616.83 ₹ 621.58 ₹ 835.23 ₹ 916.79 ₹ 958.98

₹ 1.00 ₹ 1.00 ₹ 1.00 ₹ 1.00 ₹ 1.00 ₹ 1.00

Capex - ₹ 12.10 ₹ 11.76 ₹ 4.47 -₹ 3.62 ₹ 12.57

Net working capital ₹ 316.01 ₹ 277.35 ₹ 214.91 ₹ 378.82 ₹ 520.10 ₹ 574.57
Depriciation ₹ 314.80 ₹ 265.69 ₹ 246.43 ₹ 259.37 ₹ 269.76 ₹ 285.85

# Cash Flow Statements

Operating Activities
Profit from operations ₹ 263.00 ₹ 254.00 ₹ 277.00 ₹ 206.00 ₹ 242.00 ₹ 175.00
Receivables -₹ 3 -₹ 5.00 -₹ 6.00 ₹ 11.00 ₹ 3.00 ₹ 2.00
Inventory ₹ 8.00 -₹ 4.00 -₹ 14.00 -₹ 2.00 ₹ 20.00 -₹ 14.00
Payables ₹ 3.00 ₹ 22.00 ₹ 11.00 ₹ 29.00 -₹ 11.00 -₹ 8.00
Loans Advances ₹ 0.00 ₹ 0.00 ₹ 0.00 ₹ 0.00 ₹ 0.00 ₹ 0.00
Other WC items -₹ 1.00 -₹ 27.00 -₹ 30.00 -₹ 17.00 ₹ 29.00 ₹ 6.00
Working capital chang ₹ 7.00 -₹ 14.00 -₹ 39.00 ₹ 21.00 ₹ 41.00 -₹ 14.00
Direct taxes -₹ 58.00 -₹ 59.00 -₹ 61.00 -₹ 48.00 -₹ 46.00 -₹ 33.00
Cash Flow From Operat ₹ 219.00 ₹ 167.00 ₹ 138.00 ₹ 200.00 ₹ 278.00 ₹ 114.00

Investing Activities
Fixed assets purchase -₹ 35.58 -₹ 18.91 -₹ 12.31 -₹ 7.01 -₹ 2.69 -₹ 10.88
Fixed assets sold ₹ 0.20 ₹ 0.81 ₹ 2.49 ₹ 1.26 ₹ 0.25 ₹ 0.41
Investments purchase -₹ 52.51 ₹ 0.00 ₹ 0.00 -₹ 194.41 -₹ 136.55 -₹ 24.45
Investments sold ₹ 0.00 ₹ 27.73 ₹ 49.13 ₹ 0.00 ₹ 0.00 ₹ 0.00
Interest received ₹ 27.97 ₹ 27.33 ₹ 23.14 ₹ 28.33 ₹ 32.43 ₹ 35.08
Other investing items ₹ 44.59 -₹ 0.25 ₹ 5.78 -₹ 1.21 ₹ 0.31 ₹ 0.26
Cash Flow From Investi -₹ 15.33 ₹ 36.71 ₹ 68.23 -₹ 173.04 -₹ 106.25 ₹ 0.42

Financing Activities
Proceeds from borrow ₹ 5.00 ₹ 0.00 ₹ 12.00 ₹ 0.00 ₹ 0.00 ₹ 0.00
Repayment of borrow ₹ 0.00 ₹ 0.00 ₹ 0.00 -₹ 5.00 -₹ 15.00 -₹ 5.00
Interest paid fin -₹ 1.00 -₹ 1.00 -₹ 1.00 -₹ 4.00 -₹ 1.00 -₹ 1.00
Dividends paid -₹ 170.00 -₹ 177.00 -₹ 206.00 ₹ 0.00 -₹ 118.00 -₹ 118.00
Financial liabilities ₹ 0.00 ₹ 0.00 ₹ 0.00 ₹ 0.00 ₹ 0.00 ₹ 0.00
Other financing items -₹ 35.00 -₹ 38.00 -₹ 42.00 ₹ 0.00 ₹ 0.00 ₹ 0.00
Cash Flow From Financ -₹ 201.00 -₹ 216.00 -₹ 237.00 -₹ 9.00 -₹ 134.00 -₹ 124.00

Net Cash Flow ₹ 2.67 -₹ 12.29 -₹ 30.77 ₹ 17.96 ₹ 37.75 -₹ 9.58

tatement -Bajaj Consumer Care Ltd
Mar-24 LTM Mar/24 Mar-25 Mar-26 Mar-27 Mar-28

₹ 44,870.43 ₹ 35,652.35 ₹ 51,481.49 ₹ 59,066.60 ₹ 63,201.26 ₹ 67,941.36 ₹ 73,036.96

23.08% -20.54% 14.73% 14.73% 7.00% 7.50% 7.50%

₹ 1,700.49 ₹ 39.00 ₹ 39.58 ₹ 40.18 ₹ 40.78 ₹ 41.39

3.79% 0.08% 1.50% 1.50% 1.50% 1.50%

₹ 46,570.92 ₹ 35,652.35 ₹ 51,520.49 ₹ 59,106.19 ₹ 63,241.44 ₹ 67,982.14 ₹ 73,078.35

₹ 32,775.60 ₹ 28,582.75 ₹ 580.00 ₹ 575.00 ₹ 590.00 ₹ 630.00 ₹ 680.00

73.04% 80.17% 1.13% 0.97% 0.93% 0.93% 0.93%
73.62%
₹ 13,795.32 ₹ 7,069.60 ₹ 50,940.49 ₹ 58,531.19 ₹ 62,651.44 ₹ 67,352.14 ₹ 72,398.35
30.74% 19.83% 98.95% 99.09% 99.13% 99.13% 99.13%

₹ 3,330.15 ₹ 273.00 ₹ 279.00 ₹ 292.00 ₹ 300.00 ₹ 310.00

7.42% 0.00% 0.5% 0.5% 0.5% 0.4% 0.4%

₹ 10,465.17 ₹ 7,069.60 ₹ 50,667.49 ₹ 58,252.19 ₹ 62,359.44 ₹ 67,052.14 ₹ 72,088.35

23.32% 19.83% 98.42% 98.62% 98.67% 98.69% 98.70%

₹ 60.36 ₹ 95.24 ₹ 1.32 ₹ 1.40 ₹ 1.40 ₹ 1.40 ₹ 1.40

0.13% 0.27% 0.00% 0.00% 0.00% 0.00% 0.00%

₹ 364.77 ₹ 372.55 ₹ 7.54 ₹ 7.00 ₹ 7.00 ₹ 8.00 ₹ 8.00

0.81% 1.04% 0.01% 0.01% 0.01% 0.01% 0.01%

₹ 10,040.04 ₹ 6,601.81 ₹ 50,658.63 ₹ 58,243.79 ₹ 62,351.04 ₹ 67,042.74 ₹ 72,078.95

22.38% 18.52% 98.40% 98.61% 98.65% 98.68% 98.69%

₹ 2,331.80 ₹ 2,413.88 ₹ 2,861.61 ₹ 3,511.79 ₹ 4,309.70 ₹ 5,288.90 ₹ 6,490.59

23.23% 36.56% 5.65% 6.03% 6.91% 7.89% 9.00%

₹ 7,708.24 ₹ 4,187.93 ₹ 47,797.02 ₹ 54,732.00 ₹ 58,041.34 ₹ 61,753.83 ₹ 65,588.36

17.18% 11.75% 92.84% 92.66% 91.84% 90.89% 89.80%

27.92 28.08 14.62 14.62 14.62 14.62

₹ 276.08 ₹ 1,702.17 ₹ 3,743.64 ₹ 3,970.00 ₹ 4,223.93 ₹ 4,486.21

28.93% 516.54% 119.93% 133.23% 12.83% 13.00%
 2233.44 ₹ 25,499.08 ₹ 29,198.80 ₹ 30,964.29 ₹ 32,944.86 ₹ 34,990.52
₹ 79.99
28.97% 53.35% 53.35% 53.35% 53.35% 53.35%

71.03% 46.65% 46.65% 46.65% 46.65% 46.65%

₹ 5,474.80 ₹ 0.00 ₹ 22,297.94 ₹ 25,533.20 ₹ 27,077.05 ₹ 28,808.98 ₹ 30,597.84

₹ 14.26 ₹ 28.08 ₹ 14.62 ₹ 14.62 ₹ 14.62 ₹ 14.62

₹ 804.02 ₹ 6,278.82 ₹ 28,576.76 ₹ 54,109.96 ₹ 81,187.01 ###
₹ 2.58 ₹ 0.00 ₹ 0.16 ₹ 0.16 ₹ 0.16 ₹ 0.16 ₹ 0.16
₹ 820.86 ₹ 0.00 ₹ 6,307.06 ₹ 28,591.54 ₹ 54,124.74 ₹ 81,201.79 ###

₹ 9.90
₹ 9.90
₹ 19.80 ₹ 0.00 ₹ 11.74 ₹ 13.46 ₹ 14.41 ₹ 15.49 ₹ 16.65

₹ 0.00 ₹ 0.00 ₹ 0.00 ₹ 0.00 ₹ 0.00 ₹ 0.00 ₹ 0.00

₹ 44.79 ₹ 91.59 ₹ 105.08 ₹ 112.43 ₹ 120.86 ₹ 129.92
₹ 74.09 ₹ 70.58 ₹ 70.58 ₹ 70.58 ₹ 70.58 ₹ 70.58

₹ 118.87 ₹ 162.17 ₹ 175.66 ₹ 183.01 ₹ 191.44 ₹ 200.50

₹ 959.53 ₹ 0.00 ₹ 6,481 ₹ 28,781 ₹ 54,322 ₹ 81,409 ₹ 110,228

₹ 1.36 ₹ 3.27 ₹ 3.27 ₹ 3.27 ₹ 3.27 ₹ 3.27

₹ 223.20 ₹ 226.00 ₹ 341.78 ₹ 365.70 ₹ 393.13 ₹ 422.62
₹ 0.00 ₹ 0.00 ₹ 0.00 ₹ 0.00 ₹ 0.00 ₹ 0.00 ₹ 0.00
₹ 4.21 ₹ 4.20 ₹ 4.20 ₹ 4.20 ₹ 4.20 ₹ 4.20

₹ 228.77 ₹ 0.00 ₹ 233.46 ₹ 349.24 ₹ 373.17 ₹ 400.60 ₹ 430.08

5%
₹ 575.04 ₹ 603.79 ₹ 633.98 ₹ 633.98 ₹ 665.68 ₹ 665.68
₹ 49.56 ₹ 0.00 ₹ 78.01 ₹ 89.50 ₹ 95.76 ₹ 102.94 ₹ 110.65
₹ 30.81 ₹ 46.71 ₹ 53.58 ₹ 57.33 ₹ 61.63 ₹ 66.25
₹ 75.35 ₹ 105.11 ₹ 128.48 ₹ 193.15 ₹ 239.01 ₹ 326.30
₹ 730.76 ₹ 0.00 ₹ 833.62 ₹ 905.55 ₹ 980.22 ₹ 1,069.26 ₹ 1,168.89
₹ 959.53 ₹ 0.00 ₹ 1,067 ₹ 1,255 ₹ 1,353 ₹ 1,470 ₹ 1,599

₹ 1.00 ₹ 1.00 ₹ 0.00 ₹ 0.00 ₹ 0.00 ₹ 0.00 ₹ 0.00

₹ 16.13 -₹ 223.20 ₹ 2.80 ₹ 115.78 ₹ 23.92 ₹ 27.43 ₹ 29.48

₹ 536.53 ₹ 0.00 ₹ 566.34 ₹ 601.41 ₹ 604.07 ₹ 638.81 ₹ 642.09
₹ 364.77 ₹ 7.54 ₹ 7.00 ₹ 7.00 ₹ 8.00 ₹ 8.00

#DIV/0!

₹ 143.00
-₹ 10.00
₹ 6.00
₹ 4.00
₹ 0.00
-₹ 12.00
-₹ 12.00
-₹ 30.00
₹ 89.00

-₹ 6.41
₹ 0.36
₹ 0.00
₹ 34.91
₹ 37.79
-₹ 3.08
₹ 63.57

₹ 0.00
₹ 0.00
₹ 0.00
-₹ 59.00
-₹ 3.00
-₹ 100.00
-₹ 162.00

-₹ 9.43
 Ratio Analysis -Bajaj Consumer Care Ltd
Years Mar-18 Mar-19 Mar-20 Mar-21 Mar-22

Fixed Assets To Sales 0.64% 0.56% 0.61% 0.68% 0.54%

Recivables Turnover Ratio 1043.67 833.17 770.66 1024.85 1373.84
Payables Turnover Ratio 668.18 542.29 439.76 362.22 521.04
Inventory Turnover Ratio 626.50 757.02 535.61 472.91 843.72

Recivable Days 0 0 0 0 0
Payble Days 1 1 1 1 1
Inventory Days 1 0 1 1 0

NCL/Sales 0.00% 0.00% 0.00% 0.00% 0.01%

CL/Sales 0.34% 0.34% 0.43% 0.54% 0.37%
NCA/Sales 0.65% 0.59% 0.64% 0.71% 0.57%
TA/Sales 2.23% 1.90% 1.96% 2.85% 2.56%
Bajaj Consumer Care Ltd
Mar-23 Mar-24 Mean

0.54% 0.48% 0.58%

1905.05 1511.55
841.60 1039.76
689.15 939.69

0 0 0
0 0 1
1 0 1

0.02% 0.04% 0.02%

0.29% 0.26% 0.37%
0.56% 0.49% 0.60%
2.51% 2.06% 2.30%
Regression Beta

Bajaj Consumer Care LTD NIFTY Small Cap 250 Returns

Date Closing Price Returns Date Closing Price Returns
31-Mar-23 151.95 31-Mar-23 8787.9
3-Apr-23 153.65 1.12% 3-Apr-23 8857.3 0.79%
5-Apr-23 152.75 -0.59% 5-Apr-23 8916.9 0.67%
6-Apr-23 153.45 0.46% 6-Apr-23 8983.15 0.74%
10-Apr-23 151.8 -1.08% 10-Apr-23 8998.7 0.17%
11-Apr-23 154.2 1.58% 11-Apr-23 9040.05 0.46%
12-Apr-23 154.55 0.23% 12-Apr-23 9074.5 0.38%
13-Apr-23 157.2 1.71% 13-Apr-23 9074.5 0.00%
17-Apr-23 156.75 -0.29% 17-Apr-23 9116.8 0.47%
18-Apr-23 154.9 -1.18% 18-Apr-23 9123.35 0.07%
19-Apr-23 155.1 0.13% 19-Apr-23 9123.4 0.00%
20-Apr-23 155.9 0.52% 20-Apr-23 9148.3 0.27%
21-Apr-23 154.1 -1.15% 21-Apr-23 9130.8 -0.19%
24-Apr-23 154 -0.06% 24-Apr-23 9174.1 0.47%
25-Apr-23 155.5 0.97% 25-Apr-23 9205.05 0.34%
26-Apr-23 158.1 1.67% 26-Apr-23 9255.55 0.55%
27-Apr-23 156.9 -0.76% 27-Apr-23 9300.85 0.49%
28-Apr-23 158.15 0.80% 28-Apr-23 9392.6 0.99%
2-May-23 162.6 2.81% 2-May-23 9452.85 0.64%
3-May-23 164.6 1.23% 3-May-23 9465.75 0.14%
4-May-23 171.5 4.19% 4-May-23 9546.9 0.86%
5-May-23 174.6 1.81% 5-May-23 9494.25 -0.55%
8-May-23 175.25 0.37% 8-May-23 9564.4 0.74%
9-May-23 173.5 -1.00% 9-May-23 9524 -0.42%
10-May-23 172.25 -0.72% 10-May-23 9572.35 0.51%
11-May-23 172.1 -0.09% 11-May-23 9640.65 0.71%
12-May-23 172.85 0.44% 12-May-23 9603.3 -0.39%
15-May-23 176.4 2.05% 15-May-23 9673.25 0.73%
16-May-23 176.3 -0.06% 16-May-23 9676.95 0.04%
17-May-23 176.15 -0.09% 17-May-23 9718.3 0.43%
18-May-23 178.3 1.22% 18-May-23 9678.55 -0.41%
19-May-23 180.95 1.49% 19-May-23 9674.85 -0.04%
22-May-23 186.45 3.04% 22-May-23 9713.55 0.40%
23-May-23 185.15 -0.70% 23-May-23 9725.45 0.12%
24-May-23 181.05 -2.21% 24-May-23 9729.5 0.04%
25-May-23 179.95 -0.61% 25-May-23 9759.15 0.30%
26-May-23 183 1.69% 26-May-23 9804.15 0.46%
29-May-23 183.1 0.05% 29-May-23 9831.8 0.28%
30-May-23 186.75 1.99% 30-May-23 9836.9 0.05%
31-May-23 185.85 -0.48% 31-May-23 9913.4 0.78%
1-Jun-23 184.6 -0.67% 1-Jun-23 9995.35 0.83%
2-Jun-23 188.4 2.06% 2-Jun-23 10043.45 0.48%
5-Jun-23 185.65 -1.46% 5-Jun-23 10071.25 0.28%
6-Jun-23 188.4 1.48% 6-Jun-23 10125.7 0.54%
7-Jun-23 187.55 -0.45% 7-Jun-23 10239.2 1.12%
8-Jun-23 185.8 -0.93% 8-Jun-23 10170.75 -0.67%
9-Jun-23 185.65 -0.08% 9-Jun-23 10164.25 -0.06%
12-Jun-23 186.4 0.40% 12-Jun-23 10229.85 0.65%
13-Jun-23 185.7 -0.38% 13-Jun-23 10304.9 0.73%
14-Jun-23 185.55 -0.08% 14-Jun-23 10334.45 0.29%
15-Jun-23 183.25 -1.24% 15-Jun-23 10366.7 0.31%
16-Jun-23 183.8 0.30% 16-Jun-23 10450.1 0.80%
19-Jun-23 194.15 5.63% 19-Jun-23 10482.5 0.31%
20-Jun-23 192.2 -1.00% 20-Jun-23 10524.9 0.40%
21-Jun-23 189.55 -1.38% 21-Jun-23 10531.85 0.07%
22-Jun-23 186.05 -1.85% 22-Jun-23 10454.45 -0.73%
23-Jun-23 187.2 0.62% 23-Jun-23 10345.25 -1.04%
26-Jun-23 190.2 1.60% 26-Jun-23 10415.8 0.68%
27-Jun-23 193.6 1.79% 27-Jun-23 10473.8 0.56%
28-Jun-23 193.65 0.03% 28-Jun-23 10493.3 0.19%
30-Jun-23 193.8 0.08% 30-Jun-23 10544.2 0.49%
3-Jul-23 191.8 -1.03% 3-Jul-23 10637.9 0.89%
4-Jul-23 191.7 -0.05% 4-Jul-23 10652.4 0.14%
5-Jul-23 195.75 2.11% 5-Jul-23 10718.9 0.62%
6-Jul-23 195.7 -0.03% 6-Jul-23 10808.9 0.84%
7-Jul-23 194.55 -0.59% 7-Jul-23 10777.35 -0.29%
10-Jul-23 192.65 -0.98% 10-Jul-23 10742.35 -0.32%
11-Jul-23 196.1 1.79% 11-Jul-23 10843.95 0.95%
12-Jul-23 196.25 0.08% 12-Jul-23 10897.45 0.49%
13-Jul-23 195.95 -0.15% 13-Jul-23 10820.35 -0.71%
14-Jul-23 195.9 -0.03% 14-Jul-23 10962.95 1.32%
17-Jul-23 198.15 1.15% 17-Jul-23 11048.9 0.78%
18-Jul-23 205 3.46% 18-Jul-23 10969.35 -0.72%
19-Jul-23 205.7 0.34% 19-Jul-23 11049.25 0.73%
20-Jul-23 210.1 2.14% 20-Jul-23 11079.2 0.27%
21-Jul-23 212.35 1.07% 21-Jul-23 11110.55 0.28%
24-Jul-23 207.55 -2.26% 24-Jul-23 11136.85 0.24%
25-Jul-23 209.15 0.77% 25-Jul-23 11141.85 0.04%
26-Jul-23 209.9 0.36% 26-Jul-23 11178.75 0.33%
27-Jul-23 210.2 0.14% 27-Jul-23 11193.8 0.13%
28-Jul-23 211.15 0.45% 28-Jul-23 11239.1 0.40%
31-Jul-23 216.45 2.51% 31-Jul-23 11355 1.03%
1-Aug-23 219.85 1.57% 1-Aug-23 11377.65 0.20%
2-Aug-23 220.2 0.16% 2-Aug-23 11232.1 -1.28%
3-Aug-23 223.1 1.32% 3-Aug-23 11247.5 0.14%
4-Aug-23 226.05 1.32% 4-Aug-23 11317.75 0.62%
7-Aug-23 228.95 1.28% 7-Aug-23 11353.1 0.31%
8-Aug-23 222.8 -2.69% 8-Aug-23 11371.55 0.16%
9-Aug-23 230.1 3.28% 9-Aug-23 11435.95 0.57%
10-Aug-23 227.35 -1.20% 10-Aug-23 11406.8 -0.25%
11-Aug-23 230.05 1.19% 11-Aug-23 11376.5 -0.27%
14-Aug-23 234.55 1.96% 14-Aug-23 11302.85 -0.65%
16-Aug-23 241.8 3.09% 16-Aug-23 11350.2 0.42%
17-Aug-23 251.75 4.11% 17-Aug-23 11370.95 0.18%
18-Aug-23 244.05 -3.06% 18-Aug-23 11338.05 -0.29%
21-Aug-23 238.7 -2.19% 21-Aug-23 11432.65 0.83%
22-Aug-23 241.6 1.21% 22-Aug-23 11509.7 0.67%
23-Aug-23 250.95 3.87% 23-Aug-23 11591.55 0.71%
24-Aug-23 253.8 1.14% 24-Aug-23 11576.95 -0.13%
25-Aug-23 251.65 -0.85% 25-Aug-23 11548.9 -0.24%
28-Aug-23 249.95 -0.68% 28-Aug-23 11627.3 0.68%
29-Aug-23 251.55 0.64% 29-Aug-23 11705.25 0.67%
30-Aug-23 258.05 2.58% 30-Aug-23 11807.9 0.88%
31-Aug-23 256.9 -0.45% 31-Aug-23 11931.2 1.04%
1-Sep-23 257.4 0.19% 1-Sep-23 12017.15 0.72%
4-Sep-23 252.3 -1.98% 4-Sep-23 12139.85 1.02%
5-Sep-23 247.55 -1.88% 5-Sep-23 12216.25 0.63%
6-Sep-23 251.8 1.72% 6-Sep-23 12223.3 0.06%
7-Sep-23 245.35 -2.56% 7-Sep-23 12291.95 0.56%
8-Sep-23 241.7 -1.49% 8-Sep-23 12367 0.61%
11-Sep-23 243.75 0.85% 11-Sep-23 12487.55 0.97%
12-Sep-23 234.65 -3.73% 12-Sep-23 12003 -3.88%
13-Sep-23 237.35 1.15% 13-Sep-23 12121.2 0.98%
14-Sep-23 237.9 0.23% 14-Sep-23 12269.6 1.22%
15-Sep-23 233.2 -1.98% 15-Sep-23 12301.65 0.26%
18-Sep-23 231.7 -0.64% 18-Sep-23 12241.25 -0.49%
20-Sep-23 229.9 -0.78% 20-Sep-23 12171.7 -0.57%
21-Sep-23 227.6 -1.00% 21-Sep-23 12036.7 -1.11%
22-Sep-23 232.15 2.00% 22-Sep-23 12038.45 0.01%
25-Sep-23 223.95 -3.53% 25-Sep-23 12048.95 0.09%
26-Sep-23 228 1.81% 26-Sep-23 12100.75 0.43%
27-Sep-23 226.7 -0.57% 27-Sep-23 12188.45 0.72%
28-Sep-23 224 -1.19% 28-Sep-23 12150.25 -0.31%
29-Sep-23 225.2 0.54% 29-Sep-23 12230.4 0.66%
3-Oct-23 232.3 3.15% 3-Oct-23 12307.95 0.63%
4-Oct-23 225.95 -2.73% 4-Oct-23 12168.7 -1.13%
5-Oct-23 229.85 1.73% 5-Oct-23 12238.55 0.57%
6-Oct-23 231.65 0.78% 6-Oct-23 12316.75 0.64%
9-Oct-23 220.9 -4.64% 9-Oct-23 12116.45 -1.63%
10-Oct-23 220.55 -0.16% 10-Oct-23 12252.25 1.12%
11-Oct-23 225 2.02% 11-Oct-23 12336.85 0.69%
12-Oct-23 233.75 3.89% 12-Oct-23 12425.2 0.72%
13-Oct-23 235.2 0.62% 13-Oct-23 12407.45 -0.14%
16-Oct-23 230.7 -1.91% 16-Oct-23 12446.75 0.32%
17-Oct-23 233.75 1.32% 17-Oct-23 12530.4 0.67%
18-Oct-23 242.9 3.91% 18-Oct-23 12482.35 -0.38%
19-Oct-23 243.15 0.10% 19-Oct-23 12500.6 0.15%
20-Oct-23 238.6 -1.87% 20-Oct-23 12400.3 -0.80%
23-Oct-23 229 -4.02% 23-Oct-23 11930.4 -3.79%
25-Oct-23 247.2 7.95% 25-Oct-23 11853.7 -0.64%
26-Oct-23 238.4 -3.56% 26-Oct-23 11797.15 -0.48%
27-Oct-23 240 0.67% 27-Oct-23 12024.9 1.93%
30-Oct-23 242.85 1.19% 30-Oct-23 12033.85 0.07%
31-Oct-23 232.3 -4.34% 31-Oct-23 12023.75 -0.08%
1-Nov-23 230.95 -0.58% 1-Nov-23 12000.5 -0.19%
2-Nov-23 234.85 1.69% 2-Nov-23 12130.3 1.08%
3-Nov-23 235.25 0.17% 3-Nov-23 12253.6 1.02%
6-Nov-23 239.85 1.96% 6-Nov-23 12384.35 1.07%
7-Nov-23 241.4 0.65% 7-Nov-23 12456.05 0.58%
8-Nov-23 238.25 -1.30% 8-Nov-23 12530.65 0.60%
9-Nov-23 219.85 -7.72% 9-Nov-23 12494.35 -0.29%
10-Nov-23 226.05 2.82% 10-Nov-23 12547.05 0.42%
12-Nov-23 227.7 0.73% 12-Nov-23 12705.5 1.26%
13-Nov-23 225.1 -1.14% 13-Nov-23 12736.75 0.25%
15-Nov-23 221.2 -1.73% 15-Nov-23 12878 1.11%
16-Nov-23 221.3 0.05% 16-Nov-23 12933.85 0.43%
17-Nov-23 225.65 1.97% 17-Nov-23 12976.9 0.33%
20-Nov-23 222.7 -1.31% 20-Nov-23 12981.5 0.04%
21-Nov-23 224.45 0.79% 21-Nov-23 13006.55 0.19%
22-Nov-23 221.3 -1.40% 22-Nov-23 12896.2 -0.85%
23-Nov-23 222.05 0.34% 23-Nov-23 12962.4 0.51%
24-Nov-23 223 0.43% 24-Nov-23 12984.95 0.17%
28-Nov-23 222.55 -0.20% 28-Nov-23 13013.9 0.22%
29-Nov-23 222.8 0.11% 29-Nov-23 13112.1 0.75%
30-Nov-23 221.05 -0.79% 30-Nov-23 13252 1.07%
1-Dec-23 221.55 0.23% 1-Dec-23 13326.6 0.56%
4-Dec-23 225.85 1.94% 4-Dec-23 13489.05 1.22%
5-Dec-23 222.75 -1.37% 5-Dec-23 13509.05 0.15%
6-Dec-23 220.8 -0.88% 6-Dec-23 13545.4 0.27%
7-Dec-23 220.55 -0.11% 7-Dec-23 13586.2 0.30%
8-Dec-23 218.8 -0.79% 8-Dec-23 13470.8 -0.85%
11-Dec-23 218.55 -0.11% 11-Dec-23 13546.35 0.56%
12-Dec-23 218.4 -0.07% 12-Dec-23 13529.6 -0.12%
13-Dec-23 215.45 -1.35% 13-Dec-23 13616.7 0.64%
14-Dec-23 217.7 1.04% 14-Dec-23 13722.75 0.78%
15-Dec-23 220.55 1.31% 15-Dec-23 13820.45 0.71%
18-Dec-23 217.9 -1.20% 18-Dec-23 13877.85 0.42%
19-Dec-23 218.8 0.41% 19-Dec-23 13888.95 0.08%
20-Dec-23 214.2 -2.10% 20-Dec-23 13425.25 -3.34%
21-Dec-23 214.45 0.12% 21-Dec-23 13652.5 1.69%
22-Dec-23 214.65 0.09% 22-Dec-23 13792 1.02%
26-Dec-23 211.2 -1.61% 26-Dec-23 13833 0.30%
27-Dec-23 210.9 -0.14% 27-Dec-23 13874.4 0.30%
28-Dec-23 209.45 -0.69% 28-Dec-23 13956.55 0.59%
29-Dec-23 219.6 4.85% 29-Dec-23 14041.3 0.61%
1-Jan-24 227.15 3.44% 1-Jan-24 14129.7 0.63%
2-Jan-24 225.7 -0.64% 2-Jan-24 14124.25 -0.04%
3-Jan-24 226.2 0.22% 3-Jan-24 14141 0.12%
4-Jan-24 228.15 0.86% 4-Jan-24 14286.3 1.03%
5-Jan-24 227.5 -0.28% 5-Jan-24 14382.4 0.67%
8-Jan-24 227.9 0.18% 8-Jan-24 14298.2 -0.59%
9-Jan-24 228.45 0.24% 9-Jan-24 14350.9 0.37%
10-Jan-24 227 -0.63% 10-Jan-24 14379.85 0.20%
11-Jan-24 227.8 0.35% 11-Jan-24 14498.55 0.83%
12-Jan-24 226.3 -0.66% 12-Jan-24 14552.75 0.37%
15-Jan-24 223.75 -1.13% 15-Jan-24 14589 0.25%
16-Jan-24 221.5 -1.01% 16-Jan-24 14549.05 -0.27%
17-Jan-24 220 -0.68% 17-Jan-24 14396.6 -1.05%
18-Jan-24 223.05 1.39% 18-Jan-24 14394.95 -0.01%
19-Jan-24 221.85 -0.54% 19-Jan-24 14548.55 1.07%
20-Jan-24 219.85 -0.90% 20-Jan-24 14614.2 0.45%
23-Jan-24 213.75 -2.77% 23-Jan-24 14217.35 -2.72%
24-Jan-24 217 1.52% 24-Jan-24 14467.35 1.76%
25-Jan-24 216.75 -0.12% 25-Jan-24 14543.8 0.53%
29-Jan-24 216.05 -0.32% 29-Jan-24 14730.25 1.28%
30-Jan-24 215.15 -0.42% 30-Jan-24 14749.95 0.13%
31-Jan-24 219.2 1.88% 31-Jan-24 15063.5 2.13%
1-Feb-24 220 0.36% 1-Feb-24 15084.2 0.14%
2-Feb-24 221.45 0.66% 2-Feb-24 15175.9 0.61%
5-Feb-24 223.65 0.99% 5-Feb-24 15168.4 -0.05%
6-Feb-24 216.05 -3.40% 6-Feb-24 15310.15 0.93%
7-Feb-24 213.55 -1.16% 7-Feb-24 15390.45 0.52%
8-Feb-24 215.15 0.75% 8-Feb-24 15323 -0.44%
9-Feb-24 212.25 -1.35% 9-Feb-24 15128.35 -1.27%
12-Feb-24 206.4 -2.76% 12-Feb-24 14589.05 -3.56%
13-Feb-24 205.2 -0.58% 13-Feb-24 14641.05 0.36%
14-Feb-24 214.05 4.31% 14-Feb-24 14829.25 1.29%
15-Feb-24 216.3 1.05% 15-Feb-24 15002.05 1.17%
16-Feb-24 212.05 -1.96% 16-Feb-24 15098.9 0.65%
19-Feb-24 219.55 3.54% 19-Feb-24 15171 0.48%
20-Feb-24 228.35 4.01% 20-Feb-24 15110.7 -0.40%
21-Feb-24 241.2 5.63% 21-Feb-24 14992.15 -0.78%
22-Feb-24 241.1 -0.04% 22-Feb-24 15083.55 0.61%
23-Feb-24 239.3 -0.75% 23-Feb-24 15169.5 0.57%
26-Feb-24 238.3 -0.42% 26-Feb-24 15143.4 -0.17%
27-Feb-24 240.15 0.78% 27-Feb-24 15181.95 0.25%
28-Feb-24 236.3 -1.60% 28-Feb-24 14895.25 -1.89%
29-Feb-24 234.65 -0.70% 29-Feb-24 14965.05 0.47%
1-Mar-24 238.7 1.73% 1-Mar-24 15061.35 0.64%
2-Mar-24 238.95 0.10% 2-Mar-24 15168.15 0.71%
4-Mar-24 235.3 -1.53% 4-Mar-24 15077.1 -0.60%
5-Mar-24 232.8 -1.06% 5-Mar-24 14979.6 -0.65%
6-Mar-24 228.2 -1.98% 6-Mar-24 14684.2 -1.97%
7-Mar-24 227.6 -0.26% 7-Mar-24 14803.2 0.81%
11-Mar-24 220.4 -3.16% 11-Mar-24 14507.15 -2.00%
12-Mar-24 220.35 -0.02% 12-Mar-24 14208.65 -2.06%
13-Mar-24 210 -4.70% 13-Mar-24 13473.2 -5.18%
14-Mar-24 216.8 3.24% 14-Mar-24 13892.7 3.11%
15-Mar-24 213.45 -1.55% 15-Mar-24 13922.35 0.21%
18-Mar-24 219.2 2.69% 18-Mar-24 13882.25 -0.29%
19-Mar-24 218.3 -0.41% 19-Mar-24 13718.4 -1.18%
20-Mar-24 220.35 0.94% 20-Mar-24 13733.55 0.11%
21-Mar-24 218.65 -0.77% 21-Mar-24 14047.3 2.28%
22-Mar-24 219.1 0.21% 22-Mar-24 14161.4 0.81%
26-Mar-24 214.3 -2.19% 26-Mar-24 14167.85 0.05%
27-Mar-24 215.5 0.56% 27-Mar-24 14283.6 0.82%
28-Mar-24 212.05 -1.60% 28-Mar-24 14330.5 0.33%
TRUE Covariance (Bajaj, Market) = 0.00006443
TRUE Variance (Market) = 0.00008705
TRUE Regression beta = 0.74
TRUE Regression beta (Slope)= 0.74
TRUE
TRUE Tax 22.72%
TRUE
TRUE Levered beta = Unlevered beta * (1 + (1-tax rate) D/E)
TRUE Levered beta 0.77
TRUE
TRUE
TRUE Market cap (Cr.) Debt (Cr.)
TRUE Bajaj Consumer 3,024.38 150.9
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
ax rate) D/E)

D/E
0.050
 Cost Of Equity
Levered beta (βL) 0.77
10-year Govt bond rate 7.05% https://www.bloomberg.com/markets/rates-bonds
Adjusted default spread 2.39% https://pages.stern.nyu.edu/~adamodar/New_Home_Page/datafile/ctrypr
Equity risk premium (Rm - Rf) 7.81% https://pages.stern.nyu.edu/~adamodar/New_Home_Page/datafile/ctrypr
Risk free rate (Rf) 4.66%
Cost of equity, E(R) = Rf + βL*( 10.7%

Cost of Debt
Long Term Debt 19.80 WACC 10.40%
Interest Exp 1.320
interest Cost 6.67%
Tax 22.72%
Kd 5.15%
Weightage
Debt ratio = D/(D+E) 5%
Equity ratio = E/(D+E) 95%

Market cap (Cr.) Debt (Cr.) D/E

Bajaj Consumer 3,024.38 150.9 0.050
s/rates-bonds
dar/New_Home_Page/datafile/ctryprem.html
dar/New_Home_Page/datafile/ctryprem.html
Years Mar/24 Mar-25 Mar-26
1 2 3
PAT ₹ 47,797.02 ₹ 54,732.00 ₹ 58,041.34
Interest ₹ 1.32 ₹ 1.40 ₹ 1.40
Interest*(1-t) ₹ 1.02 ₹ 1.08 ₹ 1.08
Unleverd Income ₹ 47,798.04 ₹ 54,733.08 ₹ 58,042.42
Add back: Depreciation ₹ 7.54 ₹ 7.00 ₹ 7.00
NOPAT ₹ 47,805.58 ₹ 54,740.08 ₹ 58,049.42
Less: Change in working capital ₹ 29.80 ₹ 35.07 ₹ 2.66
Less: Capital expenditure ₹ 2.80 ₹ 115.78 ₹ 23.92
FCFF ₹ 47,772.98 ₹ 54,589.23 ₹ 58,022.84
Discount Factor 0.95 0.86 0.78
Present Value ₹ 45,466.83 ₹ 47,059.12 ₹ 45,306.49

Present Value Explicit Period ₹ 223,474.62 Growth

Terminal Value (₹ 222,990.95) WACC
Present Value of Terminal Value (₹ 142,855.78)
Enterprise Value ₹ 80,618.84
Add: Cash and cash equivalent as on Mar 2023 ₹ 75.35
Value of the Firm ₹ 80,694.19
Less: Debt -₹ 19.80
Value of the Equity ₹ 80,674.39
Shares Outstanding 14.26
Value per share ₹ 5,657.39
 Mar-27 Mar-28 1-TAX
4 5
₹ 61,753.83 ₹ 65,588.36 77.28%
₹ 1.40 ₹ 1.40
₹ 1.08 ₹ 1.08 Current Assets 730.76 833.62
₹ 61,754.92 ₹ 65,589.44 Current Liabilities 118.87 162.17
₹ 8.00 ₹ 8.00 Cash 75.35 105.11
₹ 61,762.92 ₹ 65,597.44 Net working Capital 536.54 566.34
₹ 34.75 ₹ 3.28 Change in working capital 29.80
₹ 27.43 ₹ 29.48
₹ 61,700.74 ₹ 65,564.68
0.71 0.64
₹ 43,639.16 ₹ 42,003.02

14.73%
10.40%

kaushiksaha.iimc@gmail.com
905.55 980.22 1069.26 1168.89
175.66 183.01 191.44 200.50
128.48 193.15 239.01 326.30
601.41 604.07 638.81 642.09
35.07 2.66 34.75 3.28
COMPANY NAME BAJAJ AUTO LTD
LATEST VERSION 2.10
CURRENT VERSION 2.10

META
Number of shares 27.92
Face Value 10.00
Current Price 9,485.05
Market Capitalization 264,803.39

PROFIT & LOSS

Report Date Mar-15 Mar-16 Mar-17 Mar-18
Sales 21,595.44 22,573.69 21,754.72 25,209.93
Raw Material Cost 14,907.89 14,993.41 14,667.83 17,400.41
Change in Inventory 56.46 -63.45 43.68 -9.68
Power and Fuel 114.80 120.66 96.46 100.26
Other Mfr. Exp 655.78 644.19 547.54 550.16
Employee Cost 901.30 920.01 999.83 1,072.59
Selling and admin 707.58 795.66 699.73 852.82
Other Expenses 236.15 243.36 358.38 378.21
Other Income 228.50 1,194.15 1,467.61 1,403.72
Depreciation 267.46 307.16 307.29 314.80
Interest 6.49 1.05 1.40 1.31
Profit before tax 4,082.95 5,678.89 5,587.55 5,933.41
Tax 1,271.05 1,617.65 1,508.07 1,714.47
Net profit 3,025.63 4,061.24 4,079.49 4,218.95
Dividend Amount 1,446.85 1,591.54 1,591.54 1,736.22

Quarters
Report Date Mar-22 Jun-22 Sep-22 Dec-22
Sales 7,974.84 8,004.90 10,202.71 9,318.54
Expenses 6,614.16 6,718.51 8,453.07 7,561.25
Other Income 666.19 319.64 531.98 270.53
Depreciation 69.83 67.56 67.48 74.82
Interest 2.88 4.34 10.92 8.48
Profit before tax 1,954.16 1,534.13 2,203.22 1,944.52
Tax 428.00 370.80 483.78 471.82
Net profit 1,526.16 1,163.33 1,719.44 1,472.70
Operating Profit 1,360.68 1,286.39 1,749.64 1,757.29
EBITDA 2,027.82

BALANCE SHEET
Report Date Mar-15 Mar-16 Mar-17 Mar-18
Equity Share Capital 289.37 289.37 289.37 289.37
Reserves 10,805.95 13,730.94 17,567.20 20,135.87
Borrowings 112.35 117.86 119.90 120.77
Other Liabilities 4,757.93 3,102.20 3,661.15 4,594.99
Total 15,965.60 17,240.37 21,637.62 25,141.00
Net Block 2,448.03 2,025.67 2,001.79 1,878.33
Capital Work in Progress 254.94 52.24 42.17 56.47
Investments 8,985.25 11,067.23 15,477.04 18,894.57
Other Assets 4,277.38 4,095.23 4,116.62 4,311.63
Total 15,965.60 17,240.37 21,637.62 25,141.00
Receivables 716.96 717.93 953.29 1,491.87
Inventory 814.15 719.07 728.38 742.58
Cash & Bank 592.74 867.03 301.36 792.66
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 2,113.80 3,689.85 3,267.36 4,327.84
Cash from Investing Activity -379.66 -67.52 -3,609.68 -1,954.48
Cash from Financing Activity -1,644.18 -3,384.08 -190.09 -1,885.26
Net Cash Flow 89.96 238.25 -532.41 488.10

PRICE: 2,016.60 2,405.95 2,805.45 2,744.70

DERIVED:
Adjusted Equity Shares in Cr 28.94 28.94 28.94 28.94
 Bajaj Consumer Care Ltd

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

30,357.63 29,918.65 27,741.08 33,144.71 36,455.38 44,870.43
21,854.10 21,071.29 19,829.13 24,141.86 26,221.58 31,969.57
56.42 63.01 219.48 -187.96 100.33 76.34
115.01 116.57 91.34 108.01 122.60 147.94
633.99 698.83 597.11 836.28 743.55 734.43
1,260.32 1,395.00 1,296.07 1,366.00 1,488.10 1,631.06
940.92 1,020.98 654.86 644.90 852.61 999.37
411.79 569.65 554.27 600.90 662.63 699.72
2,027.83 1,832.38 1,569.68 2,671.30 1,702.70 1,700.49
265.69 246.43 259.37 269.76 285.85 364.77
4.48 3.16 6.66 8.66 39.51 60.36
6,955.58 6,692.13 6,241.43 7,651.68 7,841.98 10,040.04
2,027.98 1,480.22 1,384.41 1,485.81 1,781.77 2,331.80
4,927.61 5,211.91 4,857.02 6,165.87 6,060.21 7,708.24
1,736.22 3,472.44 4,051.18 4,051.18 3,961.44 2,233.44

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

8,929.23 10,311.91 10,838.24 12,165.33 11,554.95 11,932.07
7,272.02 8,379.64 8,708.11 9,750.43 9,270.69 9,561.63
594.66 351.10 552.25 356.33 443.93 335.32
75.99 87.23 91.82 92.91 92.81 95.01
15.77 12.09 6.54 12.10 29.63 46.97
2,160.11 2,184.05 2,584.02 2,666.22 2,605.75 2,563.78
455.37 539.91 563.97 633.60 594.32 621.99
 1,704.74 1,644.14 2,020.05 2,032.62 2,011.43 1,941.79
1,657.21 1,932.27 2,130.13 2,414.90 2,284.26 2,370.44
2,251.87 2,283.37 2,682.38 2,771.23 2,728.19 2,705.76

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

289.37 289.37 289.37 289.37 282.96 279.18
22,944.44 21,372.71 26,984.06 29,570.28 29,078.58 28,683.23
124.52 125.59 121.46 122.77 124.23 1,911.74
5,476.08 4,722.35 6,206.82 5,128.79 5,650.68 8,469.54
28,834.41 26,510.02 33,601.71 35,111.21 35,136.45 39,343.69
1,763.94 1,699.02 1,667.55 1,836.05 2,842.24 3,217.37
48.02 60.19 15.98 77.21 85.27 35.10
20,602.85 19,913.58 24,686.65 26,634.12 26,182.91 28,086.68
6,419.60 4,837.23 7,231.53 6,563.83 6,026.03 8,004.54
28,834.41 26,510.02 33,601.71 35,111.21 35,136.45 39,343.69
2,559.69 1,725.10 2,716.85 1,516.38 1,752.43 2,075.53
961.51 1,063.50 1,493.89 1,230.51 1,563.55 1,688.75
933.07 316.34 538.84 958.06 690.48 955.32
### ### ### ### ### ###

10.00 10.00 10.00 10.00 10.00 10.00

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

2,486.86 3,850.44 3,119.88 4,197.21 5,277.42 6,558.16
-272.77 1,765.83 -2,869.15 276.20 1,211.21 -71.97
-2,074.05 -6,246.51 -19.52 -4,056.33 -7,180.70 -6,167.36
140.04 -630.24 231.21 417.08 -692.07 318.83

2,911.10 2,022.35 3,670.60 3,653.00 3,884.75 9,148.15

28.94 28.94 28.94 28.94 28.30 27.92

### ###
 Mar-17 Mar-18 Mar-19 Mar-20 Mar-21 Mar-22
Cash from Operating Activity - 212 180 176 179 237 129
Profit from operations 263 254 277 206 242 175
Receivables -3 -5 -6 11 3 2
Inventory 8 -4 -14 -2 20 -14
Payables 3 22 11 29 -11 -8
Loans Advances 0 0 0 0 0 0
Other WC items -1 -27 -30 -17 29 6
Working capital changes 7 -14 -39 21 41 -14
Direct taxes -58 -59 -61 -48 -46 -33
Cash from Investing Activity - -15 37 68 -173 -106 0
Fixed assets purchased -35.58 -18.91 -12.31 -7.01 -2.69 -10.88
Fixed assets sold 0.2 0.81 2.49 1.26 0.25 0.41
Investments purchased -52.51 0 0 -194.41 -136.55 -24.45
Investments sold 0 27.73 49.13 0 0 0
Interest received 27.97 27.33 23.14 28.33 32.43 35.08
Other investing items 44.59 -0.25 5.78 -1.21 0.31 0.26
Cash from Financing Activity - -200 -216 -238 -9 -134 -124
Proceeds from borrowings 5 0 12 0 0 0
Repayment of borrowings 0 0 0 -5 -15 -5
Interest paid fin -1 -1 -1 -4 -1 -1
Dividends paid -170 -177 -206 0 -118 -118
Financial liabilities 0 0 0 0 0 0
Other financing items -35 -38 -42 0 0 0
Net Cash Flow -3 1 6 -3 -3 5
Mar-23
101
143
-10
6
4
0
-12
-12
-30
64
-6.41
0.36
0
34.91
37.79
-3.08
-163
0
0
0
-59
-3
-100
2
 19 20 21 22
EQUITIES AND LIABILITIES Column1 Column2 Column3 Column4
SHAREHOLDER'S FUNDS
Equity Share Capital 14.75 14.75 14.75 14.75
Total Share Capital 14.75 14.75 14.75 14.75
Reserves and Surplus 470.37 659.6 765.78 822.66
Total Reserves and Surplus 470.37 659.6 765.78 822.66
Employees Stock Options 0 2.83 0.93 1.76
Total Shareholders Funds 485.12 677.18 781.47 839.18
NON-CURRENT LIABILITIES
Other Long Term Liabilities 0 0 1.18 3.67
Total Non-Current Liabilities 0 0 1.18 3.67
CURRENT LIABILITIES
Short Term Borrowings 25 20 5 0
Trade Payables 72.2 80.92 68.74 45.34
Other Current Liabilities 38.67 57.02 59.23 67.13
Short Term Provisions 0.58 0.11 0 0
Total Current Liabilities 136.46 158.05 132.97 112.47
Total Capital And Liabilities 621.58 835.23 915.62 955.32
ASSETS
NON-CURRENT ASSETS
Tangible Assets 47.36 44.49 40.79 45.17
Intangible Assets 0.3 0.24 1.96 1.22
Capital Work-In-Progress 7.74 7.05 7.08 1.36
Intangible Assets Under Development 0 2.16 0 0
Fixed Assets 55.4 53.94 49.82 47.76
Non-Current Investments 138.25 144.18 144.68 159.31
Long Term Loans And Advances 2.62 3.67 0 0
Other Non-Current Assets 0.52 0.59 3.84 4.54
Total Non-Current Assets 196.79 202.38 198.34 211.61
CURRENT ASSETS
Current Investments 250.88 446.29 584.55 611.64
Inventories 59.28 61.98 42.45 55.37
Trade Receivables 41.2 28.6 26.07 20.03
Cash And Cash Equivalents 13.71 11.45 8.74 12.46
Short Term Loans And Advances 0.13 0.35 0 0
OtherCurrentAssets 59.59 84.18 55.47 44.22
Total Current Assets 424.79 632.85 717.28 743.71
Total Assets 621.58 835.23 915.62 955.32
23
Column5 Column6

14.26
14.26
804.02
804.02
2.58
820.86

9.9
9.9

0
44.79
74.09
0
118.87
949.64

54.65
0.63
1.36
0
56.65
166.55
0
4.21
227.41

575.04
49.56
30.81
13.86
0
52.96
722.23
949.64
CoColumn2 Column3 Column4 Column5
EQUITIES AND LIABILITIES Column3 Column2
SHAREHOLDER'S FUNDS
Equity Share Capital 14.75 14.75
Total Share Capital 14.75 14.75
Reserves and Surplus 487.02 490.61
Total Reserves and Surplus 487.02 490.61
Total Shareholders Funds 501.77 505.36
NON-CURRENT LIABILITIES
Long Term Borrowings 0 0
Total Non-Current Liabilities 0 0
CURRENT LIABILITIES
Short Term Borrowings 15 13.49
Trade Payables 39.83 59.72
Other Current Liabilities 35.44 38.04
Short Term Provisions 0.24 0.22
Total Current Liabilities 90.5 111.47
Total Capital And Liabilities 592.28 616.82
ASSETS
NON-CURRENT ASSETS
Tangible Assets 53.4 51
Intangible Assets 0.37 0.23
Capital Work-In-Progress 0.03 5.86
Fixed Assets 53.8 57.1
Non-Current Investments 115.99 124.79
Long Term Loans And Advances 0.91 1.29
Other Non-Current Assets 1.24 1.05
Total Non-Current Assets 171.94 184.23
CURRENT ASSETS
Current Investments 338.54 307.17
Inventories 42.48 42.78
Trade Receivables 25.5 38.87
Cash And Cash Equivalents 9.62 12.65
Short Term Loans And Advances 0.25 0.24
OtherCurrentAssets 3.93 30.89
Total Current Assets 420.33 432.59
Total Assets 592.28 616.82