HISTORICAL FINANCIAL STATEMENT - BATA INDIA LTD

Years Dec-13 Mar-15 Mar-16 Mar-17 Mar-18 Mar-19 Mar-20 Mar-21 Mar-22 Mar-23 LTM

# Income Statement
Sales ₹ 2,065.18 ₹ 2,694.00 ₹ 2,422.70 ₹ 2,474.26 ₹ 2,634.17 ₹ 2,931.10 ₹ 3,056.11 ₹ 1,708.48 ₹ 2,387.72 ₹ 3,451.57 ₹ 3,466.71
Sales Growth - 30.45% -10.07% 2.13% 6.46% 11.27% 4.26% -44.10% 39.76% 44.56% 0.44%

COGS ₹ 1,237.02 ₹ 1,633.35 ₹ 1,484.15 ₹ 1,523.43 ₹ 1,574.93 ₹ 1,694.97 ₹ 1,754.83 ₹ 1,230.30 ₹ 1,524.76 ₹ 2,003.86 ₹ 2,678.08
COGS % Sales 60% 61% 61% 62% 60% 58% 57% 72% 64% 58% 77%

Gross Profit ₹ 828.16 ₹ 1,060.65 ₹ 938.55 ₹ 950.83 ₹ 1,059.24 ₹ 1,236.13 ₹ 1,301.28 ₹ 478.18 ₹ 862.96 ₹ 1,447.71 ₹ 788.63
Gross Profit Margin 40% 39% 39% 38% 40% 42% 43% 28% 36% 42% 23%

Selling & General Expenses ₹ 490.49 ₹ 709.46 ₹ 644.79 ₹ 655.03 ₹ 695.59 ₹ 746.29 ₹ 455.09 ₹ 309.23 ₹ 435.60 ₹ 643.53 ₹ 0.00
S&G Exp % Sales 24% 26% 27% 26% 26% 25% 15% 18% 18% 19% 0%

EBITDA ₹ 337.67 ₹ 351.19 ₹ 293.76 ₹ 295.80 ₹ 363.65 ₹ 489.84 ₹ 846.19 ₹ 168.95 ₹ 427.36 ₹ 804.18 ₹ 788.63
EBITDA Margin 16% 13% 12% 12% 14% 17% 28% 10% 18% 23% 23%

Interest ₹ 13.12 ₹ 17.77 ₹ 15.79 ₹ 14.99 ₹ 14.82 ₹ 14.28 ₹ 128.71 ₹ 108.12 ₹ 99.43 ₹ 118.24 ₹ 111.10
Interest % Sales 1% 1% 1% 1% 1% 0% 4% 6% 4% 3% 3%

Depriciation ₹ 59.22 ₹ 79.28 ₹ 78.82 ₹ 65.04 ₹ 60.45 ₹ 64.05 ₹ 295.80 ₹ 264.75 ₹ 241.96 ₹ 294.78 ₹ 306.53
Depriciation % Sales 3% 3% 3% 3% 2% 2% 10% 15% 10% 9% 9%
 Earnings Before Tax ₹ 265.33 ₹ 254.14 ₹ 199.15 ₹ 215.77 ₹ 288.38 ₹ 411.51 ₹ 421.68 (₹ 203.9) ₹ 85.97 ₹ 391.16 ₹ 371.00
EBT %Sales 13% 9% 8% 9% 11% 14% 14% -12% 4% 11% 11%

Tax ₹ 91.96 ₹ 97.59 ₹ 79.16 ₹ 74.91 ₹ 116.53 ₹ 148.69 ₹ 158.29 -₹ 27.32 ₹ 36.71 ₹ 106.83 ₹ 103.13
Effective Tax Rate 35% 38% 40% 35% 40% 36% 38% 13% 43% 27% 28%

Net Income ₹ 173.37 ₹ 156.55 ₹ 119.99 ₹ 140.86 ₹ 171.85 ₹ 262.82 ₹ 263.39 -₹ 176.60 ₹ 49.26 ₹ 284.33 ₹ 267.87
Net Margins 8% 6% 5% 6% 7% 9% 9% -10% 2% 8% 8%

No of Equity Shares ₹ 12.85 ₹ 12.85 ₹ 12.85 ₹ 12.85 ₹ 12.85 ₹ 12.85 ₹ 12.85 ₹ 12.85 ₹ 12.85 ₹ 12.85 ₹ 0.00

Earnings Per Share ₹ 13.49 ₹ 12.18 ₹ 9.34 ₹ 10.96 ₹ 13.37 ₹ 20.45 ₹ 20.50 -₹ 13.74 ₹ 3.83 ₹ 22.13 ₹ 0.00
EPS Growth -10% -23% 17% 22% 53% 0% -167% -128% 477% -100%

Dividend Per Share ₹ 3.25 ₹ 3.25 ₹ 3.50 ₹ 3.50 ₹ 4.00 ₹ 6.25 ₹ 4.00 ₹ 4.00 ₹ 54.51 ₹ 13.50 ₹ 0.00
dividend Payout Ratio 24% 27% 37% 32% 30% 31% 20% -29% 1422% 61%

Retained Earinigs 76% 73% 63% 68% 70% 69% 80% 0% 0% 39% 0%

# Balance Sheet
Equity Share Capital ₹ 64.26 ₹ 64.26 ₹ 64.26 ₹ 64.26 ₹ 64.26 ₹ 64.26 ₹ 64.26 ₹ 64.26 ₹ 64.26 ₹ 64.26
Reserves ₹ 775.61 ₹ 956.92 ₹ 1,156.66 ₹ 1,260.06 ₹ 1,410.43 ₹ 1,677.58 ₹ 1,829.66 ₹ 1,693.83 ₹ 1,750.39 ₹ 1,373.95
Borrowings ₹ 0.00 ₹ 0.00 ₹ 0.00 ₹ 0.00 ₹ 0.00 ₹ 1,249.11 ₹ 1,032.28 ₹ 1,094.21 ₹ 1,246.45
Other Liabilities ₹ 542.15 ₹ 615.80 ₹ 512.14 ₹ 598.81 ₹ 666.71 ₹ 732.24 ₹ 589.43 ₹ 542.08 ₹ 616.29 ₹ 587.00
Total Liabilities ₹ 1,382.02 ₹ 1,636.98 ₹ 1,733.06 ₹ 1,923.13 ₹ 2,141.40 ₹ 2,474.08 ₹ 3,732.46 ₹ 3,332.45 ₹ 3,525.15 ₹ 3,271.66

Fixed Aseets Net Block ₹ 248.30 ₹ 308.71 ₹ 304.10 ₹ 267.95 ₹ 296.43 ₹ 316.51 ₹ 1,369.43 ₹ 1,119.51 ₹ 1,225.90 ₹ 1,391.84
Capital Work in Progress ₹ 23.71 ₹ 48.17 ₹ 19.04 ₹ 29.84 ₹ 12.12 ₹ 17.25 ₹ 19.86 ₹ 33.61 ₹ 5.18 ₹ 3.77
Investments ₹ 0.00 ₹ 0.00 ₹ 0.00 ₹ 0.00 ₹ 0.00 ₹ 0.50
Other Assets ₹ 220.65 ₹ 306.92 ₹ 311.10 ₹ 320.09 ₹ 387.14 ₹ 394.28 ₹ 442.30 ₹ 394.86 ₹ 382.66 ₹ 357.24
Total Non Current Assets ₹ 492.66 ₹ 663.80 ₹ 634.24 ₹ 617.88 ₹ 695.69 ₹ 728.04 ₹ 1,831.59 ₹ 1,547.98 ₹ 1,613.74 ₹ 1,753.35
 Receivables ₹ 50.92 ₹ 58.42 ₹ 71.00 ₹ 69.41 ₹ 89.35 ₹ 66.35 ₹ 63.27 ₹ 79.37 ₹ 71.72 ₹ 82.55
Inventory ₹ 582.69 ₹ 704.70 ₹ 685.35 ₹ 713.80 ₹ 765.17 ₹ 839.37 ₹ 873.68 ₹ 608.28 ₹ 870.91 ₹ 904.56
Cash & Bank ₹ 255.75 ₹ 210.06 ₹ 342.47 ₹ 522.04 ₹ 591.19 ₹ 840.32 ₹ 963.92 ₹ 1,096.82 ₹ 968.78 ₹ 531.20
Total Current Aseets ₹ 889.36 ₹ 973.18 ₹ 1,098.82 ₹ 1,305.25 ₹ 1,445.71 ₹ 1,746.04 ₹ 1,900.87 ₹ 1,784.47 ₹ 1,911.41 ₹ 1,518.31

Total Aseets ₹ 1,382.02 ₹ 1,636.98 ₹ 1,733.06 ₹ 1,923.13 ₹ 2,141.40 ₹ 2,474.08 ₹ 3,732.46 ₹ 3,332.45 ₹ 3,525.15 ₹ 3,271.66

Check TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE

# Cash Flow Statement

Operating Activities
Profit from operations ₹ 354.0 ₹ 384.0 ₹ 352.0 ₹ 269.0 ₹ 360.0 ₹ 481.0 ₹ 837.0 ₹ 194.0 ₹ 422.0 ₹ 804.0
Receivables (₹ 6.0) (₹ 8.0) (₹ 18.0) ₹ 6.0 (₹ 22.0) ₹ 23.0 - (₹ 17.0) ₹ 7.0 (₹ 18.0)
Inventory (₹ 121.0) (₹ 122.0) ₹ 19.0 (₹ 28.0) (₹ 51.0) (₹ 74.0) (₹ 34.0) ₹ 265.0 (₹ 263.0) (₹ 34.0)
Payables ₹ 91.0 ₹ 89.0 (₹ 23.0) ₹ 82.0 ₹ 71.0 ₹ 34.0 ₹ 4.0 (₹ 64.0) ₹ 16.0 (₹ 47.0)
Loans Advances (₹ 15.0) (₹ 39.0) ₹ 4.0 - ₹ 3.0 (₹ 6.0) (₹ 13.0) - - -
Other WC items (₹ 10.0) (₹ 43.0) (₹ 24.0) (₹ 7.0) (₹ 86.0) ₹ 28.0 (₹ 24.0) ₹ 35.0 ₹ 35.0 ₹ 21.0
Working capital changes (₹ 61.0) (₹ 122.0) (₹ 41.0) ₹ 53.0 (₹ 84.0) ₹ 5.0 (₹ 68.0) ₹ 220.0 (₹ 204.0) (₹ 78.0)
Direct taxes (₹ 111.0) (₹ 144.0) (₹ 108.0) (₹ 65.0) (₹ 115.0) (₹ 141.0) (₹ 187.0) ₹ 47.0 (₹ 7.0) (₹ 97.0)
Cash From Operating Activities ₹ 121.00 (₹ 5.0) ₹ 161.00 ₹ 310.00 ₹ 76.00 ₹ 350.00 ₹ 515.00 ₹ 680.00 ₹ 6.00 ₹ 551.00

Investing Activities
Fixed assets purchased (₹ 82.0) (₹ 146.0) (₹ 40.0) (₹ 51.0) (₹ 78.0) (₹ 82.0) (₹ 86.0) (₹ 37.0) (₹ 49.0) (₹ 95.0)
Fixed assets sold ₹ 3.0 ₹ 13.0 ₹ 1.0 ₹ 4.0 ₹ 2.0 - - ₹ 1.0 ₹ 1.0 ₹ 6.0
Investments sold - - - - - - - - ₹ 3.0 -
Interest received ₹ 12.0 ₹ 20.0 ₹ 18.0 ₹ 26.0 ₹ 40.0 ₹ 49.0 ₹ 64.0 ₹ 75.0 ₹ 47.0 ₹ 32.0
Other investing items (₹ 51.0) ₹ 48.0 (₹ 93.0) (₹ 208.0) (₹ 76.0) (₹ 245.0) (₹ 167.0) (₹ 92.0) ₹ 91.0 ₹ 496.0
Cash From Investing Activities (₹ 118.0) (₹ 65.0) (₹ 114.0) (₹ 229.0) (₹ 112.0) (₹ 278.0) (₹ 189.0) (₹ 53.0) ₹ 93.00 ₹ 439.00

Financing Activities
Proceeds from borrowings - - - - - - - - - -
Interest paid fin (₹ 1.0) (₹ 2.0) (₹ 2.0) (₹ 2.0) (₹ 2.0) (₹ 1.0) (₹ 1.0) (₹ 1.0) (₹ 90.0) (₹ 106.0)
Dividends paid (₹ 38.0) (₹ 42.0) (₹ 42.0) (₹ 45.0) (₹ 45.0) (₹ 51.0) (₹ 80.0) (₹ 51.0) (₹ 51.0) (₹ 699.0)
Financial liabilities - - - - - - (₹ 336.0) (₹ 315.0) (₹ 200.0) (₹ 206.0)
Other financing items (₹ 7.0) (₹ 7.0) (₹ 8.0) (₹ 9.0) (₹ 9.0) (₹ 11.0) (₹ 18.0) (₹ 1.0) - -
Cash From Financing Activities (₹ 46.0) (₹ 51.0) (₹ 52.0) (₹ 56.0) (₹ 56.0) (₹ 63.0) (₹ 435.0) (₹ 368.0) (₹ 341.0) (₹ 1,011.0)

Net Cash Flow (₹ 43.0) (₹ 121.0) (₹ 5.0) ₹ 25.00 (₹ 92.0) ₹ 9.00 (₹ 109.0) ₹ 259.00 (₹ 242.0) (₹ 21.0)