RELAXO
RELAXO
RELAXO
including major brands like Relaxo, Flite, Sparx and Bahamas. The company sells its products through ~50,000
manufacturing facilities, five in Bahadurgarh (Haryana), two in Bhiwadi (Rajasthan) and one in Haridwar (Uttar
NIFTY and Sensex. Before getting into details about Relaxo Footwears let us look at the Industry trend first..
Currently exports contributes 4% of its revenue and E Retail contributes 10% of revenue. Relaxo have strong br
global average of 4 shoes thus there is a very long run growth left for Relaxo Footwears.
ISIN INE131B01039
Industry Footwears
Sector Footwears
revenue. Relaxo have strong brand , able management and superior business . Currently Indian Footwear are less penetrated . 1.
otwears.
Relaxo - Footwears
Revenue 1,478.4 1,715.6
YOY growth % 16.0%
Change in CC %
Relaxo-Scrap Sales
Revenue 5.3 5.0
% of Revenue 0.4% 0.3%
Within India
Outside India
31-Mar-17 31-Mar-18 31-Mar-19 31-Mar-20 31-Mar-21 31-Mar-22 31-Mar-23
Y Y Y Y Y Y Y
Act Act Act Act Est Est Est
2,180.7 2,291.4
85.8 91.6
31-Mar-24 31-Mar-25
Y Y
Est Est
4,037.7 4,663.5
15.5% 15.5%
26.46 29.10
10.0% 10.0%
152.6 160.2
5.0% 5.0%
20.2 23.3
0.5% 0.5%
4,057.9 4,686.8
15.5% 15.5%
4,057.9 4,686.8
15.5% 15.5%
99.5% 99.5%
0.5% 0.5%
Relaxo Footwears Limited 31-Mar-15 31-Mar-16
P&L Y Y
(in INR Crores) Act Act
Cost Assumptions
ASSETS
Cash and cash equivalents 4.5 2.2 3.5 3.1
Bank Balances and Other Cash 0.0 0.1 0.1 0.9
Trade and other receivables 82.1 108.7 123.2 192.4
Loans 14.1 0.3 0.3 0.9
Inventories 248.7 285.8 290.2 313.9
Current tax assets 0.0 0.0 0.0 0.0
Other Financial Assets 0.0 6.2 2.4 1.3
Other Current Assets 5.8 21.3 26.0 68.2
Total current assets 355.2 424.7 445.73 580.6
LIABILITIES
Trade and other payables 92.6 122.4 125.7 174.9
Forward exchange contracts 0.0 0.0 0.0 0.0
Loans and borrowings 66.5 89.6 60.9 86.1
Deffered tax liabilities 0.0 2.8 1.2 2.6
Other Financial Liability 0.0 90.4 99.4 92.6
Provisions 22.1 4.7 2.4 6.8
Other Current Liability 113.4 60.2 70.3 70.5
Lease Liability 0.0 0.0 0.0 0.0
Total current liabilities 294.62 370.05 359.87 433.48
EQUITY
Share capital 6.0 12.0 12.0 12.0
Reserves 260.8 355.3 470.6 590.2
Retained earnings 101.1 122.3 122.8 159.0
Total equity 367.8 489.6 605.4 761.2
Check 0 0 0 0
Debt schedule
Finance Expenses
Finance Income
Accumulated dep
Opening bal (154.5) (188.8) (227.3) (266.9)
Depreciation (37.9) (41.0) (42.8) (45.6)
as % of avg assets 6.5% 6.1% 6.0% 6.0%
Others 3.6 2.5 3.1 0.5
Closing Bal (188.8) (227.3) (266.9) (312.0)
Accumulated Amortization
Opening bal (5.3) (7.3) (14.0) (22.5)
Amortization (2.0) (6.7) (8.7) (13.7)
as % of avg assets 16.6% 14.1% 10.5% 14.6%
Impairment (0.1) 0.0 0.0 (10.8)
Others 0.0 0.0 0.3 0.0
Closing Bal. (7.3) (14.0) (22.5) (47.0)
Net Book Amount 5.6 68.2 61.7 56.2
- - - -
Right of Use Assets
Gross Assets
Opening bal.
Additions
as % of revenue
Closing Bal.
Accumulated Dep.
Opening bal.
Depreciation
% of average assets
Closing Bal.
Drivers
Payable Days(current) 56 68 66 76
Payable Days(current) 0 0 0 0
0 0 0 0 0 0 0
36 26 26 26 26 26 26
0 0 0 0 0 0 0
62 72 72 70 70 70 70
0 0 0 0 0 0 0
0.0 0.0
Source of
Funds
CFO 428.1
Debt 10.8
Application of
Funds Amount
CAPEX 129.7
Interest 17.8
Dividends 57.0
Source of Fund
2% CFO
Debt
98%
31-Mar-23 31-Mar-24 31-Mar-25
Y Y Y
Est Est Est
Application of Funds
28% CAPEX
Interest
Dividends
63%
28% CAPEX
Interest
Dividends
9% 63%
Relaxo Footwears Limited
DCF 2021 2022
(in INR Crores) Annual Annual
Est Est
-0.05 31%
1.12 30%
1.21 30%
0.65 39%
27%
on of WACC Sensitivity Table
Terminal Growth Rate
1,347.0 5% 6% Err:522 Err:522 Err:522
Err:522 Err:522 Err:522 Err:522 Err:522 Err:522
8% Err:522 Err:522 Err:522 Err:522 Err:522 Err:522
WACC
7.0%
Mirza Sreeleathers Khadim
Date BSE RELAXO BATA INDIA International Ltd Ltd India Ltd
FY-08 17287.310547 2.159757 81.617722 15.153367
FY-09 11403.25 1.498532 55.341518 8.324496
FY-10 17558.710938 15.533596 127.156937 13.208925
FY-11 19135.960938 13.80973 199.542877 20.141947
FY-12 17318.810547 15.990966 412.944458 16.725742
FY-13 19504.179688 29.252022 351.132599 19.083601
FY-14 22417.800781 74.928764 506.513397 26.350361
FY-15 27011.310547 180.47821 486.389954 78.685867
FY-16 25606.619141 241.06171 560.60083 99.102417
FY-17 29918.400391 244.32045 562.970947 101.952438
FY-18 35160.359375 354.11319 779.813171 132.161102 764.73755
FY-19 39031.550781 437.70557 1426.360107 52.566082 397.72208
FY-20 29468.490234 596.07434 1352.298462 41.650002 123.6 93.300003
FY-21 51246 878 1476.150024 51.400002 145.35 148.35001
Liberty
Shoes Ltd Super House Ltd
2.57% 13.35%
3.8% 10.8%
-6.0% -4.8%
1.1% 3.9%
33.0% 67.9%
5 YEAR EBITDA
COMPANIES MARKET CAP P/E P/B ATIO MARGIN
Relaxo Footwears Ltd 21757.32 96.31 17.13 15.43%
Bata India Ltd 19009.22 57.26 9.95 18.17%
Mirza International Ltd 619.58 12.92 0.98 16.06%
Sreeleathers Ltd 347.55 12.7 1.13 23.57%
Khadim India Ltd 274.13 -8.56 1.15 9.36%
Liberty Shoes Ltd 236.52 21.61 1.28 8.28%
Super House Ltd 136.65 5.28 0.39 9.41%
STO
BSE-Sensex R
Sreeleathers Ltd K
53.59% 49.3%
22.97% 13.6%
13.35% 11.5% 11.9% 10.8%
8.07% 9.12%
2.57% 3.8%
Many Companies tried entering into Footwear Industry but they have lost considerable market
share over the years . Even Big International Brands have failed to maintain market share
0.18
0.16
0.14
0.12
0.1
0.08
0.06
0.04
0.02
0
1995-96 1996-97 1997-98 1998-99 1999-00 2000-01 2001-02 2002-03 2003-04 2004-05 2
HHI Index is very low which shows that the market is highly competitive and over the years It has become mor
HHI Index is very low which shows that the market is highly competitive and over the years It has become mor
REVENUE OF B
3500
3000
2500
2000
1500
1000
500
0
1995-96 1996-97 1997-98 1998-99 1999-00 2000-01 2001-02 2002-03 2003-04 2004-05 2005-06
Bata
FOOTWEA
Produc
20.19921 26.36749
23.00957 23.07342 20.0301
20.45431 19.80505
18.92708 16.94494
16.21121
11.82904 13.33017
0.3
0.25
0.2
RELAXO VS BATA INDIA EBITDA MARGIN
0.35
0.3
0.25
0.2
0.15
0.1
0.05
0
FY 2012 FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 FY 202
0.6
0.5
0.4
0.3
0.2
0.1
0
FY 2012 FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020
0.12
0.1
0.08
0.06
0.04
0.02
0
FY 2012 FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020
Net Income as % of Revenue of RELAXO Net Income as % of Total Revenue of BATA INDIA
CASH
5 Y AVG NET PROFIT 5Y AVG LONG TERM DEBT CONVERSION INTEREST COVERAGE
5 YEAR AVG ROA MARGIN ROCE TO EQUITY CYCLE IN DAYS RATIO
12.79% 7.91% 17.59% 9.41% 129.22 16.00
11.46% 8.91% 16.49% 54.67% 108.56 4.79
7.58% 6.43% 12.52% 2.87% 216.38 2.41
7.58% 15.22% 7.92% 0.00% 48.76 245.31
4.57% 2.65% 10.95% 63.79% 102.35 -0.04
1.87% 1.50% 7.99% 1.19% 140.10 2.24
2.98% 2.99% 7.72% 5.72% 195.17 2.58
% 29.2% 26.1%
21.3%
1.9% 10.8% 11.4% 9.5%
3.8% 1.2% 1.1% 3.9%
-6.0%
-4.8% -0.7%
-12.8%
-28.0%
AR RETURN 5 YEAR RETURN 3 YEAR RETURN
1.99
2.15
2.53
1.99
2.15
2.53
8.1
siderable market Relaxo have consistently increased their market share currently they are almost at par Imports as a
arket share with Bata . But since it is a highly competitive industry maintaining profitability is a shows that e
challenge . There is low pricing power . Relaxo is ablo to increase market share on consumers fo
account of robust technology and cheap labour sign as Intern
Herfindahl Index
2002-03 2003-04 2004-05 2005-06 2006-07 2007-08 2008-09 2009-10 2010-11 2011-12 2012-13 2013-14 2014-15 2015-16
03 2003-04 2004-05 2005-06 2006-07 2007-08 2008-09 2009-10 2010-11 2011-12 2012-13 2013-14 2014-15 2015-16 2016-17
0.045
0.04
0.035
0.03
0.025
0.02
0.015
0.01
0.005
0
FY 2012 FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020
0.8
0.6
0.4
0.2
0
FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020
-0.2
-0.4
FY 2019 FY 2020
EPS Growth Rate EPS Growth rate of BATA INDIA
of BATA INDIA
FREE
5 YEAR HISTORICAL CASHFLOW
EPS GROWTH YIELDS FII DII MF
16.26% 0.93% 3.67% 7.05% 7.05%
7.29% 2.61% 5.55% 26.08% 14.09%
-6.41% 25.62% 0.04% 0.04% 0.00%
27.75% 8.28% 3.16% 0.00% 0.00%
14.78% 0.04% 15.53% 10.84%
-8.27% 10.66% 0.00% 0.00% 0.00%
-0.03% 31.93% 0.00% 0.01% 0.00%
73.9%
67.9%
59.0%
47.3%
23.4% 33.0%
17.6%
9.2%
1.1% 3.9%
-28.0%
ETURN 1 YEAR RETURN
020( %)
8.1
10.46
Share of Imports
18
16
14
12
10
8
6
4
2
0
96 97 98 99 00 01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17 18 19
95- 96- 97- 98- 99- 00- 01- 02- 03- 04- 05- 06- 07- 08- 09- 10- 11- 12- 13- 14- 15- 16- 17- 18-
19 19 19 19 19 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20
2018-19 2019-20
A
A
Y 2019 FY 2020
FY 2019 FY 2020
FY 2020
Comparable Valuation
Valuation metrics
Price (INR) 241.0 244.0 354.0 437.0
Share outstanding 12.1 12.3 12.1 24.9
Market Capitalization 2,916.1 2,989.0 4,283.4 10,890.0
Enterprise Value (EV) 3,192.7 3,180.6 4,510.4 11,155.4
PE (x) 24.1 24.4 26.5 61.9
P/BV (x) 5.9 4.9 5.6 9.8
Price/Sales (x) 0.1 0.1 0.2 0.2
EV/EBITDA (x) 13.0 13.8 14.9 34.4
EV/Sales (x) 1.9 1.9 2.3 4.9
Du Point Analysis
Growth Ratios
Revenue Growth Rate 16% -5% 19% 17%
EBITDA Growth 22% -6% 31% 7%
PAT Growth 17% 0% 34% 9%
Operating Cash Growth 48% 13% -14% -20%
Free Cashflow Growth L to P 265% -50% -31%
31-Mar-20 31-Mar-21 31-Mar-22 31-Mar-23 31-Mar-24 31-Mar-25
Y Y Y Y Y Y
Est Est Est Est Est Est
Du Point
Criteria Not
Complied
ASSETS
Cash and cash equivalents 3.5 3.1
Trade and other receivables 123.2 192.4
Other current assets 316.5 383.0
Total current assets 445.7 580.6
EQUITY
Share capital 12.0 12.0
Reserves 470.6 590.2
Retained earnings 122.8 159.0
Total equity 605.4 761.2
Key Ratios
FY17 FY18
Profitability & Growth
Gross Margin % 54.4% 54.4%
EBITDA Margin % 14.1% 15.5%
EBIT Margin % 11.7% 12.9%
EBT Margin % 10.9% 12.5%
FY22E FY23E
Revenue 2,904.5 3,513.3
Cost of Sales - Raw Materials (1,248.9) (1,510.7)
Gross Profit 1,655.6 2,002.6
Operating Expense (ex D&A) (1,132.8) (1,299.9)
EBITDA 522.8 737.8
Depreciation & Amortisation (122.7) (139.2)
EBIT 400.1 598.6
Net Interest Expense / (Income) (18.3) (24.3)
Profit before taxation 381.8 574.4
Tax Expense (95.5) (143.6)
Net profit for the year 286.4 430.8
Basic EPS (INR) 11.6 17.4
Diluted EPS (INR) 11.6 17.4
DPS (INR) 5.8 10.5
ASSETS
Cash and cash equivalents 26.1 110.7
Trade and other receivables 206.9 250.3
Other current assets 609.8 733.1
Total current assets 872.4 1,123.6
EQUITY
Share capital 24.9 24.9
Reserves 1,045.0 1,045.0
Retained earnings 513.5 685.8
Total equity 1,584 1,755.8
Consolidated Cash Flow (INR Crores) FY22E FY23E
Profitability Ratios
Gross margin 57.0% 57.0%
EBITDA margin 18.0% 21.0%
EBIT margin 13.8% 17.0%
PBT margin 13.2% 16.4%
Net margin 9.9% 12.3%
FY24E
4,057.9
(1,744.9)
2,313.0
(1,460.8)
852.1
(142.1)
710.0
(33.5)
676.5
(169.1)
507.4
20.5
20.5
13.3
FY24E
163.5
289.1
854.4
1,336.5
799.8
39.8
628.7
1,472.5
2,809.0
307.4
180.0
173.4
660.7
0.0
190.0
214.8
214.8
875.5
1,933
24.9
1,045.0
863.4
1,933
FY24E
682.1
0.0
142.1
35.8
860.0
(118.4)
(170.5)
571.1
(251.6)
0.0
0.0
0.0
(251.6)
0.0
80.0
0.0
(12.8)
(127.9)
(60.6)
258.8
391.1
0.0
650.0
FY24E
97.8
28.7
34.5
20.7
57.0%
21.0%
17.5%
16.8%
12.6%
FY24E
16.9%
23.0%
29.1%
23.8
19.9
567.8
1.1
0.8
0.5
17%
Charts
INR Crores
10.0%
2,000 400
5.0%
1,500 300
1,000 0.0% 200
500 -5.0% 100
0 -10.0% 0
FY17 FY18 FY19 FY20 FY21E FY22E FY23E FY17 FY18 FY19 FY
INR Crores
8.0%
250 10
200 6.0% 8
150 4.0% 6
100 4
2.0%
50 2
0 0.0% 0
FY17 FY18 FY19 FY20 FY21E FY22E FY23E FY17 FY18 FY19 FY
10.0% 10.0%
FY17 FY18 FY19 FY20 FY21E FY22E FY23E FY17 FY18 FY19 F
60% 0.0%
FY17 FY18 FY19 FY
40% -20.0%
20% -40.0%
0%
FY17 FY18 FY19 FY20 FY21E FY22E FY23E -60.0%
Margin An
25.0%
20.0%
15.0%
10.0%
5.0%
0.0%
FY17 FY18 FY19 FY
400
0
10.0% 300
0
0 200
5.0%
0 100
0 0.0% 0
FY17 FY18 FY19 FY20 FY21E FY22E FY23E FY17 FY18 FY19 FY20 FY21E FY22E FY2
INR Crores
0 0.0% 10
8 8
6 -20.0% 6
4 -40.0% 4
2 2
0 -60.0% 0
FY17 FY18 FY19 FY20 FY21E FY22E FY23E FY17 FY18 FY19 FY20 FY21E FY22E FY23
Basic EPS (reported) EPS growth (RHS) Diluted EPS (reported) EPS growth (RHS)
30.0%
25.0%
20.0%
15.0%
10.0%
FY17 FY18 FY19 FY20 FY21E FY22E FY23E FY17 FY18 FY19 FY20 FY21E FY22E
3.0%
2.5%
2.0%
1.5%
0.5%
0.0%
FY17 FY18 FY19 FY20 FY21E FY22E
Margin Analysis
d) EBIT margin
PS Analysis
60.0%
40.0%
PS Analysis
60.0%
40.0%
20.0%
0.0%
-20.0%
-40.0%
-60.0%
FY20 FY21E FY22E FY23E
Analysis
d Analysis
Earnings revisions
A$mn FY20A FY21E
Old New % chg Old New % chg
Revenue 2,394.7 #DIV/0! 2,357.6 #DIV/0!
EBIDTA 409.0 #DIV/0! 518.7 #DIV/0!
EBIT 308.2 #DIV/0! 408.4 #DIV/0!
Net Profit 226.3 #DIV/0! 285.1 #DIV/0!
EPS 9.1 #DIV/0! 11.5 #DIV/0!
Results Preview Table - Full Year A
Act vs Cons. FY21E
Revenue 2,357.6
Cost of goods sold (966.6)
Gross Profit 1,391.0
EBIDTA 518.7
Depreciation and Amortization (110.3)
Other Income 0.0
EBIT 408.4
Finance income - interest 0.1
Finance expense - interest (17.8)
FY22E
Old New % chg
2,904.5 #DIV/0!
522.8 #DIV/0!
415.7 #DIV/0!
301.3 #DIV/0!
12.2 #DIV/0!
Results Preview Table - Full Year Analysis
FY20A YoY Cons Est. Our est vs Cons.
2,394.7 -1.6%
(1,039.3) -7.0%
1,355.4 2.6%
(962.2) -6.9%
15.8 49.3%
409.0 26.8%
(109.4) 0.8%
8.6
308.2 32.5%
0.4 -88.1%
(16.9) 5.7%
291.7 33.9%
(65.5) 61.1%
22.4% 20.3%
226.3 26.0%
Preliminary checks on the financial model
Model Mechanics
Timing
Sensitivity Analysis
Company Name: Marsden maritime Holdings Limited (MMH)
Financial model File name: Marsden Maritime Holdings Limited (MMH) Financial Model
Updated on: 11/07/2020
► Model uses a consistent color scheme; Hardcoded Numbers - Blue; Formula - Black
► There are no errors in the model (worksheets and named ranges)
► There are no links to external files
► Inputs are separated from Calculations and Results
► Uniform column structure across all worksheets
► The units of measurement of each element in the financial model are clearly defined
► Use of unique formulas across rows
► Rows for error checks included
► There are no circularities in the model
► Model include output calculations such as financial statements ratios and valuation calculations
► Model include a summary sheet containing key model inputs and outputs and charts
► There are no hidden or password protected sheets or macros
► Key dates like financial opening and close date are captured
► Years of financial projections = 5
► The financial model contains the 3 financial statements: Cash flow, Income and Balance sheet
► Does the balance sheet balances
Check Comment
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1