Last Updated on: 27 July, 2024
Stock Ticker - BSE: 523796 | NSE: VICEROY
Basic Stock Data
Last Updated: July 27, 2024, 6:02 am
Data Source: screener.in
Competitors of Viceroy Hotels Ltd
Quarterly Result
| Month | Dec 2020 | Mar 2021 | Jun 2021 | Sep 2021 | Dec 2021 | Mar 2022 | Jun 2022 | Sep 2022 | Dec 2022 | Mar 2023 | Jun 2023 | Sep 2023 | Dec 2023 |
|---|
| Sales | 12.52 | 15.33 | 6.53 | 15.64 | 23.19 | 19.89 | 30.72 | 21.50 | 28.77 | 32.17 | 24.78 | 27.38 | 40.20 |
| Expenses | 15.19 | 22.56 | 9.41 | 25.38 | 24.35 | 27.63 | 28.56 | 20.47 | 30.66 | 30.41 | 24.23 | 26.20 | 45.21 |
| Operating Profit | -2.67 | -7.23 | -2.88 | -9.74 | -1.16 | -7.74 | 2.16 | 1.03 | -1.89 | 1.76 | 0.55 | 1.18 | -5.01 |
| OPM % | -21.33% | -47.16% | -44.10% | -62.28% | -5.00% | -38.91% | 7.03% | 4.79% | -6.57% | 5.47% | 2.22% | 4.31% | -12.46% |
| Other Income | 1.29 | 3.44 | 0.89 | 1.63 | 0.97 | 1.99 | 1.43 | 2.84 | 1.62 | 0.96 | 2.68 | 2.05 | 0.55 |
| Interest | 0.04 | 0.46 | 0.02 | 0.17 | 0.09 | 0.47 | 0.01 | 0.41 | 0.00 | 0.45 | 0.03 | 0.48 | 0.01 |
| Depreciation | 2.47 | 2.44 | 2.23 | 2.07 | 2.12 | 2.68 | 2.15 | 2.15 | 2.15 | 2.15 | 2.16 | 2.11 | 2.11 |
| Profit before tax | -3.89 | -6.69 | -4.24 | -10.35 | -2.40 | -8.90 | 1.43 | 1.31 | -2.42 | 0.12 | 1.04 | 0.64 | -6.58 |
| Tax % | 19.02% | 24.51% | 17.45% | -10.05% | -8.33% | 1.12% | 9.09% | 9.92% | -5.37% | 108.33% | 51.92% | -70.31% | -0.46% |
| Net Profit | -3.14 | -5.06 | -3.50 | -11.40 | -2.61 | -8.80 | 1.30 | 1.19 | -2.54 | 0.00 | 0.50 | 1.10 | -6.61 |
| EPS in Rs | -0.74 | -1.19 | -0.83 | -2.69 | -0.62 | -2.08 | 0.31 | 0.28 | -0.60 | 0.00 | 0.12 | 0.26 | -1.56 |
Last Updated: July 10, 2024, 11:14 pm
Profit & Loss - Annual Report
Last Updated: July 10, 2024, 11:14 pm
| Month | Mar 2012 | Mar 2013 | Mar 2014 | Mar 2015 | Mar 2016 | Mar 2017 | Mar 2018 | Mar 2019 | Mar 2020 | Mar 2021 | Mar 2022 | Mar 2023 | TTM |
|---|
| Sales | 110 | 109 | 105 | 110 | 124 | 124 | 118 | 122 | 122 | 35 | 52 | 103 | 125 |
| Expenses | 73 | 77 | 74 | 76 | 92 | 100 | 109 | 126 | 131 | 54 | 87 | 110 | 126 |
| Operating Profit | 37 | 32 | 30 | 34 | 32 | 25 | 9 | -4 | -8 | -20 | -34 | -7 | -2 |
| OPM % | 34% | 29% | 29% | 31% | 26% | 20% | 7% | -3% | -7% | -57% | -66% | -6% | -1% |
| Other Income | -0 | 0 | -123 | -0 | 19 | -4 | -409 | 3 | 5 | 6 | 18 | 17 | 6 |
| Interest | 23 | 24 | 24 | 26 | 27 | 28 | 23 | 2 | 1 | 1 | 1 | 1 | 1 |
| Depreciation | 15 | 15 | 15 | 14 | 13 | 9 | 10 | 11 | 10 | 10 | 9 | 9 | 9 |
| Profit before tax | -1 | -6 | -132 | -6 | 11 | -16 | -433 | -14 | -15 | -24 | -26 | 0 | -5 |
| Tax % | -219% | -7% | 0% | -0% | -0% | -6% | -2% | -14% | -11% | 16% | -2% | 111% | |
| Net Profit | -2 | -7 | -132 | -7 | 11 | -15 | -443 | -16 | -17 | -21 | -26 | -0 | -5 |
| EPS in Rs | -0.52 | -1.63 | -31.18 | -1.60 | 2.58 | -3.44 | -104.55 | -3.72 | -3.98 | -4.85 | -6.20 | -0.01 | -1.18 |
| Dividend Payout % | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | |
Profit & Loss Yearly Chart
YoY Net Profit Growth
| Year | 2012-2013 | 2013-2014 | 2014-2015 | 2015-2016 | 2016-2017 | 2017-2018 | 2018-2019 | 2019-2020 | 2020-2021 | 2021-2022 | 2022-2023 |
|---|
| YoY Net Profit Growth (%) | -250.00% | -1785.71% | 94.70% | 257.14% | -236.36% | -2853.33% | 96.39% | -6.25% | -23.53% | -23.81% | 100.00% |
| Change in YoY Net Profit Growth (%) | 0.00% | -1535.71% | 1880.41% | 162.45% | -493.51% | -2616.97% | 2949.72% | -102.64% | -17.28% | -0.28% | 123.81% |
Balance Sheet
Last Updated: July 10, 2024, 11:14 pm
| Month | Mar 2012 | Mar 2013 | Mar 2014 | Mar 2015 | Mar 2016 | Mar 2017 | Mar 2018 | Mar 2019 | Mar 2020 | Mar 2021 | Mar 2022 | Mar 2023 | Sep 2023 |
|---|
| Equity Capital | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 |
| Reserves | 204 | 197 | 65 | 103 | 123 | 120 | -408 | -423 | -440 | -461 | -487 | -487 | -486 |
| Borrowings | 959 | 953 | 404 | 481 | 488 | 464 | 533 | 540 | 547 | 629 | 634 | 606 | 535 |
| Other Liabilities | 178 | 267 | 172 | 232 | 266 | 301 | 274 | 283 | 280 | 194 | 192 | 198 | 279 |
| Total Liabilities | 1,383 | 1,460 | 684 | 858 | 920 | 927 | 442 | 441 | 429 | 405 | 381 | 359 | 371 |
| Fixed Assets | 374 | 361 | 207 | 177 | 195 | 187 | 282 | 273 | 263 | 249 | 230 | 222 | 217 |
| CWIP | 801 | 896 | 284 | 358 | 408 | 437 | 92 | 92 | 92 | 100 | 100 | 57 | 52 |
| Investments | 47 | 47 | 55 | 125 | 135 | 130 | 0 | 0 | 0 | 0 | 0 | 0 | 14 |
| Other Assets | 161 | 156 | 138 | 198 | 181 | 174 | 68 | 76 | 74 | 56 | 51 | 81 | 88 |
| Total Assets | 1,383 | 1,460 | 684 | 858 | 920 | 927 | 442 | 441 | 429 | 405 | 381 | 359 | 371 |
Reserves and Borrowings Chart
Free Cash Flow
| Month | Mar 2012 | Mar 2013 | Mar 2014 | Mar 2015 | Mar 2016 | Mar 2017 | Mar 2018 | Mar 2019 | Mar 2020 | Mar 2021 | Mar 2022 | Mar 2023 |
|---|
| Free Cash Flow | -922.00 | -921.00 | -374.00 | -447.00 | -456.00 | -439.00 | -524.00 | -544.00 | -555.00 | -649.00 | -668.00 | -613.00 |
Free Cash Flow = Income Generated from Operational Activities - Borrowings - Capital Work in Progress (CWIP)
Consistent positive free cash flow is crucial for businesses as it indicates their ability to generate cash from their core operations. It provides financial flexibility, allowing companies to invest in growth opportunities, pay dividends to shareholders, reduce debt, and weather economic downturns more effectively.
Free Cash Flow Chart
Financial Efficiency Indicators
| Month | Mar 2012 | Mar 2013 | Mar 2014 | Mar 2015 | Mar 2016 | Mar 2017 | Mar 2018 | Mar 2019 | Mar 2020 | Mar 2021 | Mar 2022 | Mar 2023 |
|---|
| Debtor Days | 67 | 64 | 67 | 80 | 70 | 36 | 36 | 41 | 36 | 95 | 39 | 33 |
| Inventory Days | 24 | 21 | 19 | 24 | 26 | 21 | 18 | 23 | 24 | | | |
| Days Payable | 932 | 920 | 659 | 344 | 304 | 292 | 350 | 343 | 345 | | | |
| Cash Conversion Cycle | -841 | -835 | -572 | -240 | -208 | -234 | -296 | -280 | -286 | 95 | 39 | 33 |
| Working Capital Days | -586 | -1,270 | -657 | -776 | -592 | -705 | -636 | -659 | -621 | -2,342 | -1,534 | -762 |
| ROCE % | 2% | 1% | 2% | 4% | 3% | 3% | 1% | -7% | -9% | -15% | -21% | -8% |
Financial Efficiency Indicators Chart
Share Holding Pattern
| Month | Mar 2021 | Jun 2021 | Sep 2021 | Dec 2021 | Mar 2022 | Jun 2022 | Sep 2022 | Dec 2022 | Mar 2023 | Jun 2023 | Sep 2023 | Dec 2023 |
|---|
| Promoters | 14.27% | 14.04% | 13.41% | 13.41% | 13.41% | 13.41% | 13.41% | 13.41% | 13.41% | 13.41% | 13.41% | 95.00% |
| DIIs | 0.02% | 0.02% | 0.02% | 0.02% | 0.02% | 0.02% | 0.02% | 0.02% | 0.02% | 0.02% | 0.02% | 1.58% |
| Public | 85.71% | 85.94% | 86.56% | 86.56% | 86.56% | 86.56% | 86.56% | 86.57% | 86.55% | 86.56% | 86.55% | 3.42% |
| No. of Shareholders | 27,660 | 28,113 | 27,772 | 27,855 | 28,113 | 28,176 | 28,244 | 28,189 | 28,127 | 28,096 | 27,633 | 22,079 |
Shareholding Pattern Chart
This stock is not held by any mutual fund
Key Financial Ratios
| Month | Mar 24 | Mar 23 | Mar 22 | Mar 21 | Mar 20 |
|---|
| FaceValue | 10.00 | 10.00 | 10.00 | 10.00 | 10.00 |
| Basic EPS (Rs.) | 1.41 | -0.01 | -6.20 | -4.85 | -3.98 |
| Diluted EPS (Rs.) | 1.41 | -0.01 | -6.20 | -4.85 | -3.98 |
| Cash EPS (Rs.) | 2.59 | 2.01 | -4.05 | -2.50 | -1.50 |
| Book Value[Excl.RevalReserv]/Share (Rs.) | 10.58 | -105.06 | -106.04 | -98.84 | -94.01 |
| Book Value[Incl.RevalReserv]/Share (Rs.) | 10.58 | -104.88 | -104.86 | -98.66 | -93.82 |
| Revenue From Operations / Share (Rs.) | 21.88 | 24.38 | 12.37 | 8.20 | 28.86 |
| PBDIT / Share (Rs.) | 2.98 | 2.34 | -3.78 | -3.27 | -0.91 |
| PBIT / Share (Rs.) | 0.77 | 0.31 | -5.93 | -5.62 | -3.39 |
| PBT / Share (Rs.) | 0.04 | 0.10 | -6.11 | -5.76 | -3.57 |
| Net Profit / Share (Rs.) | 0.37 | -0.01 | -6.20 | -4.85 | -3.98 |
| NP After MI And SOA / Share (Rs.) | 0.37 | -0.01 | -6.20 | -4.85 | -3.98 |
| PBDIT Margin (%) | 13.64 | 9.59 | -30.60 | -39.92 | -3.17 |
| PBIT Margin (%) | 3.55 | 1.27 | -47.97 | -68.52 | -11.74 |
| PBT Margin (%) | 0.20 | 0.43 | -49.39 | -70.27 | -12.37 |
| Net Profit Margin (%) | 1.72 | -0.05 | -50.16 | -59.16 | -13.77 |
| NP After MI And SOA Margin (%) | 1.72 | -0.05 | -50.16 | -59.16 | -13.77 |
| Return on Networth / Equity (%) | 3.57 | 0.00 | 0.00 | 0.00 | 0.00 |
| Return on Capital Employeed (%) | 1.86 | 1.34 | -18.65 | -15.43 | -7.87 |
| Return On Assets (%) | 0.73 | -0.01 | -6.89 | -5.07 | -3.92 |
| Long Term Debt / Equity (X) | 2.50 | -1.14 | -1.22 | -1.29 | -1.37 |
| Total Debt / Equity (X) | 2.52 | -1.17 | -1.22 | -1.30 | -1.37 |
| Asset Turnover Ratio (%) | 0.40 | 0.31 | 0.14 | 0.07 | 0.25 |
| Current Ratio (X) | 0.91 | 0.21 | 0.11 | 0.11 | 0.15 |
| Quick Ratio (X) | 0.90 | 0.21 | 0.11 | 0.10 | 0.14 |
| Inventory Turnover Ratio (X) | 35.71 | 0.00 | 0.00 | 0.00 | 0.00 |
| Interest Coverage Ratio (X) | 13.09 | 11.39 | -21.49 | -22.84 | -5.03 |
| Interest Coverage Ratio (Post Tax) (X) | 4.86 | 0.93 | -34.24 | -32.85 | -20.86 |
| Enterprise Value (Cr.) | 161.13 | 506.23 | 558.51 | 551.55 | 550.25 |
| EV / Net Operating Revenue (X) | 1.17 | 4.90 | 10.65 | 15.87 | 4.50 |
| EV / EBITDA (X) | 8.55 | 51.06 | -34.80 | -39.74 | -141.82 |
| MarketCap / Net Operating Revenue (X) | 0.16 | 0.09 | 0.25 | 0.25 | 0.02 |
| Price / BV (X) | 0.34 | -0.02 | -0.02 | -0.02 | -0.01 |
| Price / Net Operating Revenue (X) | 0.16 | 0.09 | 0.25 | 0.25 | 0.02 |
| EarningsYield | 0.10 | -0.01 | -1.96 | -2.30 | -4.62 |
Interest Coverage Ratios (%)
Missing data for fair value calculation: Market Cap, Current Price
Strength and Weakness
| Strength | Weakness |
|---|
- The stock has a low average Working Capital Days of -499.83, which is a positive sign.
- The stock has a low average Cash Conversion Cycle of -302.08, which is a positive sign.
| - The stock has a low average ROCE of -3.67%, which may not be favorable.
- The company has higher borrowings (597.92) compared to reserves (-183.08), which may suggest financial risk.
- The company has not shown consistent growth in sales (104.54) and profit (-51.31).
|
Stock Analysis
- Considering all of the following key financial indicators, prospective investors are encouraged to conduct thorough research and seek professional guidance before considering any investment in Viceroy Hotels Ltd:
- ✓ Net Profit Margin: 1.72%
- Net Profit Margin: This metric indicates the percentage of profit a company makes from its total revenue. A higher net profit margin is generally desirable as it reflects better profitability.
- ✗ ROCE: 1.86% (Industry Average ROCE: 11.21%)
- ROCE (Return on Capital Employed): ROCE measures a company's profitability and the efficiency with which its capital is employed. A higher ROCE indicates efficient use of capital.
- ✗ ROE%: 3.57% (Industry Average ROE: 33.46%)
- ROE (Return on Equity): ROE measures a company's profitability relative to shareholders' equity. A higher ROE indicates efficient use of shareholders' funds.
- ✓ Interest Coverage Ratio (Post Tax): 4.86
- Interest Coverage Ratio: The interest coverage ratio measures a company's ability to cover its interest payments on outstanding debt. A ratio greater than 2 is generally considered healthy as it indicates the company can meet its interest obligations comfortably.
- ✗ Quick Ratio: 0.90
- Quick Ratio: The quick ratio assesses a company's ability to cover its short-term liabilities with its most liquid assets. A ratio higher than 1 suggests the company can meet its short-term obligations without relying heavily on inventory.
- ✗ Stock P/E: N/A (Industry average Stock P/E: 60.42)
- Stock P/E (Price-to-Earnings) Ratio: The P/E ratio compares a company's current share price to its earnings per share. A lower P/E ratio relative to industry peers or historical values may indicate that the stock is undervalued.
- ✗ Total Debt / Equity: 2.52
- Total Debt / Equity: This ratio measures a company's financial leverage by comparing its total debt to its total equity. A lower ratio indicates lower financial risk and greater financial stability.
The current analysis is available for review. It's important to conduct thorough research and consider consulting with financial professionals before making any investment decisions.
Stock Rating: ★☆☆☆☆
About the Company
Viceroy Hotels Ltd. is a Public Limited Listed company incorporated on 25/02/1965 and has its registered office in the State of Andhra Pradesh, India. Company’s Corporate Identification Number(CIN) is L55101TG1965PLC001048 and registration number is 001048. Currently company belongs to the Industry of Hotels, Resorts & Restaurants. Company’s Total Operating Revenue is Rs. 46.89 Cr. and Equity Capital is Rs. 42.41 Cr. for the Year ended 31/03/2022.
| Management |
|---|
| Name | Position Held |
|---|
| Mr. Gorinka Jaganmohan Rao | Chairman & Ind.Director |
| Mr. Ravinder Reddy Kondareddy | Managing Director & CEO |
| Mr. Pooja Reddy Konda Reddy | Non Exe.Non Ind.Director |
| Mr. Prabhakar Reddy Solipuram | Non Exe.Non Ind.Director |
| Mr. Puli Venkata Krishna Reddy | Ind. Non-Executive Director |
| Mr. Anirudh Reddy Konda Reddy | Non Exe.Non Ind.Director |
FAQ
What is the latest fair value of Viceroy Hotels Ltd?
The latest fair value of Viceroy Hotels Ltd is ₹161.11.
Disclaimer: This article is for informational purposes only and should not be construed as financial advice. The author is not a
SEBI registered financial advisor and does not have any vested interest in Viceroy Hotels Ltd. Investors are advised to conduct their own due diligence and consult with a financial professional before making any investment decisions. The information provided in this article is based on publicly available data and the author's analysis, but it may not be comprehensive or up-to-date. The author and getaka.co.in are not responsible for any errors or omissions in the content. This article is not intended to promote any particular investment strategy or recommendation, and readers should consult with their own financial advisors before making any investment decisions. Data Source:
NSE 
