Projected Income Statement: Lemon Tree Hotels Limited

Forecast Balance Sheet: Lemon Tree Hotels Limited

Fiscal Period: March 2021 2022 2023 2024 2025 2026 2027 2028
Net Debt 1 14,269 20,677 21,484 18,354 15,794 13,361 11,929 7,331
Change - 44.91% 3.9% -14.57% -13.95% -15.4% -21.15% -38.54%
Announcement Date 15/06/21 27/05/22 30/05/23 29/05/24 29/05/25 28/05/26 - -
1INR in Million
Estimates

Cash Flow Forecast: Lemon Tree Hotels Limited

Fiscal Period: March 2021 2022 2023 2024 2025 2026 2027 2028
CAPEX 1 704.4 675.5 1,620 3,312 957.8 1,383 1,581 1,758
Change - -4.11% 139.89% 104.38% -71.08% 44.43% 39.68% 11.15%
Free Cash Flow (FCF) 1 -294.3 677.5 2,228 1,338 4,458 4,033 5,231 5,669
Change - 330.21% 228.87% -39.93% 233.1% -9.54% 15.07% 8.37%
Announcement Date 15/06/21 27/05/22 30/05/23 29/05/24 29/05/25 28/05/26 - -
1INR in Million
Estimates

Forecast Financial Ratios: Lemon Tree Hotels Limited

Fiscal Period: March 2021 2022 2023 2024 2025 2026 2027 2028

Profitability

        
EBITDA Margin (%) 24.34% 33.29% 51.75% 48.85% 49.31% 47.85% 48.98% 50.21%
EBIT Margin (%) -18.39% 7.35% 40.7% 38.38% 38.48% 36.72% 40.04% 41.8%
EBT Margin (%) -85.31% -36.21% 20.39% 20.15% 23.05% 24.86% 31.17% 35.22%
Net margin (%) -50.48% -21.74% 13.11% 13.86% 15.29% 15.72% 19.93% 22.69%
FCF margin (%) -11.69% 16.84% 25.49% 12.49% 34.66% 27.92% 32.15% 31.55%
FCF / Net Income (%) 23.16% -77.49% 194.48% 90.13% 226.77% 177.58% 161.27% 139.03%

Profitability

        
ROA -3.35% - 3.11% 3.82% 4.84% 5.43% 11.87% 13.25%
ROE -14.6% -10% 13.6% 16.31% 18.45% 17.77% 19.89% 20.6%

Financial Health

        
Leverage (Debt/EBITDA) 23.29x 15.44x 4.75x 3.51x 2.49x 1.93x 1.5x 0.81x
Debt / Free cash flow -48.48x 30.52x 9.64x 13.71x 3.54x 3.31x 2.28x 1.29x

Capital Intensity

        
CAPEX / Current Assets (%) 27.98% 16.79% 18.54% 30.92% 7.45% 9.58% 9.72% 9.78%
CAPEX / EBITDA (%) 114.97% 50.44% 35.82% 63.29% 15.1% 20.01% 19.84% 19.48%
CAPEX / FCF (%) -239.36% 99.7% 72.73% 247.45% 21.49% 34.3% 30.23% 31.01%

Items per share

        
Cash flow per share 1 0.5197 1.718 4.862 5.887 6.839 6.845 6.56 7.965
Change - 230.54% 183.04% 21.1% 16.17% 0.08% 14.31% 21.41%
Dividend per Share 1 - - - - - 0.7748 0.6494 0.7555
Change - - - - - - -16.18% 16.34%
Book Value Per Share 1 11.61 10.51 10.78 12.21 14.69 17.58 21.38 25.97
Change - -9.45% 2.6% 13.22% 20.34% 19.63% 22.32% 21.47%
EPS 1 -1.61 -1.11 1.45 1.88 2.48 2.87 4.067 5.038
Change - 31.06% 230.63% 29.66% 31.91% 15.73% 25.51% 23.87%
Nbr of stocks (in thousands) 7,88,412 7,88,948 7,90,760 7,91,098 7,91,848 7,91,848 7,91,848 7,91,848
Announcement Date 15/06/21 27/05/22 30/05/23 29/05/24 29/05/25 28/05/26 - -
1INR
Estimates
2026 2027 *
P/E 35x 28.1x
PBR 5.71x 5.34x
EV / Sales 6.43x 6.29x
Yield 0.68% 0.57%

EPS & Dividend

Y-o-Y evolution of P/E

Year-on-year evolution of the Yield

Trader
Investor
Global
Quality
ESG MSCI
-
Sell
Consensus
Buy
Mean consensus
BUY
Number of Analysts
21
Last Close Price
114.12INR
Average target price
155.71INR
Spread / Average Target
+36.45%

Quarterly revenue - Rate of surprise

  1. Stock Market
  2. Stocks
  3. LEMONTREE Stock
  4. Financials Lemon Tree Hotels Limited