BSE: 531694 | NSE: | Construction - Real Estate | Small Cap
Past 10 year’s financial track record analysis by Moneyworks4me indicates that Rainbow Foundations Ltd is a below average quality company.
The key valuation ratios of Rainbow Foundations Ltd's currently when compared to its past seem to suggest it is in the Somewhat Undervalued zone.
The Price Trend analysis by MoneyWorks4Me indicates it is Weak which suggest that the price of Rainbow Foundations Ltd is likely to Fall in the short term. However, please check the rating on Quality and Valuation before investing.
Data adjusted to bonus, split, extra-ordinary income, rights issue and change in financial year end.
| Mar'15 | Mar'16 | Mar'17 | Mar'18 | Mar'19 | Mar'20 | Mar'21 | Mar'22 | Mar'23 | Mar'24 | TTM | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| ROCE % ⓘ | 6.7% | 5.8% | 8% | 11.2% | 4.9% | 5.6% | 4.7% | 2.7% | 4.1% | 5.3% | - |
| Value Creation Index ⓘ | -0.5 | -0.6 | -0.4 | -0.2 | -0.7 | -0.6 | -0.7 | -0.8 | -0.7 | -0.6 | - |
Growth Parameters ⓘGrowth Parameters Colour Code Guide ⓘ | |||||||||||
| Sales ⓘ | 31.2 | 29.7 | 46.4 | 55.4 | 37.8 | 25.9 | 34.6 | 36 | 40.2 | 93.5 | 121 |
| Sales YoY Gr. | - | -4.8% | 56.2% | 19.4% | -31.8% | -31.5% | 33.9% | 4% | 11.7% | 132.3% | - |
| Adj EPS ⓘ | 0.5 | 1.1 | 1.4 | 1.3 | 0.5 | 1.5 | 1 | 0.5 | 0.3 | 0.6 | 1.2 |
| YoY Gr. | - | 107.7% | 25% | -5.2% | -57.8% | 168.5% | -33.1% | -45.4% | -49.1% | 133.3% | - |
| BVPS (₹) ⓘ | 9.3 | 10.4 | 11.8 | 13.1 | 13.6 | 15 | 16 | 34.7 | 13.9 | 14.6 | 15.1 |
| Adj Net Profit ⓘ | 0.6 | 1.3 | 1.6 | 1.5 | 0.6 | 1.7 | 1.1 | 0.3 | 1.4 | 3.1 | 6 |
| Cash Flow from Ops. ⓘ | -33.2 | -51.7 | 33.2 | 19.2 | -53.4 | 13.9 | 25.2 | -39.2 | -112 | -158 | - |
| Debt/CF from Ops. ⓘ | -2.7 | -2.9 | 3.8 | 6.1 | -1.6 | 6 | 9.2 | -7.4 | -3.4 | -3 | - |
CAGR Colour Code Guide ⓘ
| 9 Years | 5 Years | 3 Years | 1 Years | |||||
|---|---|---|---|---|---|---|---|---|
| Sales ⓘ | 13% | 19.9% | 39.3% | 132.3% | ||||
| Adj EPS ⓘ | 2.2% | 3.1% | -13.4% | 133.3% | ||||
| BVPSⓘ | 5.1% | 1.4% | -3.1% | 4.6% | ||||
| Share Price | 14.7% | 25.5% | 42.3% | 72% | ||||
Performance Ratio Colour Code Guide ⓘ
| Mar'15 | Mar'16 | Mar'17 | Mar'18 | Mar'19 | Mar'20 | Mar'21 | Mar'22 | Mar'23 | Mar'24 | TTM | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Return on Equity % ⓘ | 5.8 | 10.9 | 12.2 | 10.3 | 1.6 | 2.7 | 2.8 | 1.5 | 3.1 | 4.4 | 8.2 |
| Op. Profit Mgn % ⓘ | 14.4 | 21.9 | 24.9 | 25.9 | 13.6 | 19.5 | 18.5 | 11.4 | 25.2 | 25 | 25 |
| Net Profit Mgn % ⓘ | 2 | 4.3 | 3.4 | 2.7 | 1.7 | 6.6 | 3.3 | 0.8 | 3.4 | 3.3 | 5 |
| Debt to Equity ⓘ | 8.3 | 12.4 | 9.2 | 7.6 | 1.4 | 1.3 | 12.3 | 15 | 5.6 | 6.5 | 0 |
| Working Cap Days ⓘ | 1,370 | 1,844 | 1,313 | 1,029 | 1,937 | 3,711 | 3,040 | 3,264 | 3,919 | 2,209 | 845 |
| Cash Conv. Cycle ⓘ | 798 | 1,558 | 1,106 | 823 | 1,549 | 2,047 | 1,919 | 2,037 | 2,565 | 1,728 | 93 |
Return on Equity has increased versus last 3 years average to 8.20%
Sales growth is growing at healthy rate in last 3 years 39.25%
Debt to equity has declined versus last 3 years average to 6.52
Sales growth is good in last 4 quarters at 97.74%
Net Profit has been subdued in last 3 years -13.40%
| Standalone | Consolidated | |
|---|---|---|
| TTM EPS (₹) | 1.2 | - |
| TTM Sales (₹ Cr.) | 121 | - |
| BVPS (₹.) ⓘ | 15.1 | - |
| Reserves (₹ Cr.) ⓘ | 25 | - |
| P/BV ⓘ | 1.92 | - |
| PE ⓘ | 23.86 | - |
| From the Market | |
|---|---|
| 52 Week Low / High (₹) | 13.06 / 34.61 |
| All Time Low / High (₹) | 1.72 / 34.61 |
| Market Cap (₹ Cr.) | 144 |
| Equity (₹ Cr.) | 49.6 |
| Face Value (₹) | 10 |
| Industry PE ⓘ | 80.9 |
| Pledged * | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| PARTICULARS | Mar'15 | Mar'16 | Mar'17 | Mar'18 | Mar'19 | Mar'20 | Mar'21 | Mar'22 | Mar'23 | Mar'24 |
|---|---|---|---|---|---|---|---|---|---|---|
| Sales | 31 | 30 | 46 | 55 | 38 | 26 | 35 | 36 | 40 | 93 |
| Operating Expenses ⓘ | 27 | 23 | 35 | 41 | 33 | 21 | 28 | 32 | 30 | 70 |
| Manufacturing Costs | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 |
| Material Costs | 26 | 22 | 34 | 40 | 31 | 19 | 27 | 29 | 27 | 67 |
| Employee Cost | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
| Other Costs ⓘ | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 |
| Operating Profit ⓘ | 4 | 7 | 12 | 14 | 5 | 5 | 6 | 4 | 10 | 23 |
| Operating Profit Margin (%) | 14.4% | 21.9% | 24.9% | 25.9% | 13.5% | 19.5% | 18.4% | 11.4% | 25.2% | 25.0% |
| Other Income ⓘ | 1 | 1 | 1 | 1 | 2 | 3 | 3 | 4 | 5 | 4 |
| Interest ⓘ | 5 | 6 | 10 | 13 | 6 | 6 | 8 | 6 | 14 | 22 |
| Depreciation ⓘ | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 |
| Exceptional Items ⓘ | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Profit Before Tax ⓘ | 1 | 2 | 2 | 2 | 1 | 2 | 2 | 1 | 2 | 4 |
| Tax ⓘ | 0 | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 0 | 1 |
| Profit After Tax | 1 | 1 | 2 | 2 | 1 | 2 | 1 | 0 | 1 | 3 |
| PAT Margin (%) | 2.0% | 4.4% | 3.4% | 2.7% | 1.7% | 6.6% | 3.3% | 0.8% | 3.4% | 3.4% |
| Adjusted EPS (₹) | 0.5 | 1.1 | 1.4 | 1.3 | 0.6 | 1.5 | 1.0 | 0.5 | 0.3 | 0.6 |
| Dividend Payout Ratio (%) | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% |
| PARTICULARS | Mar'15 | Mar'16 | Mar'17 | Mar'18 | Mar'19 | Mar'20 | Mar'21 | Mar'22 | Mar'23 | Mar'24 |
|---|---|---|---|---|---|---|---|---|---|---|
Equity and Liabilities | ||||||||||
| Shareholders Fund | 11 | 12 | 14 | 15 | 61 | 63 | 19 | 19 | 69 | 72 |
| Share Capital ⓘ | 6 | 6 | 6 | 6 | 51 | 51 | 6 | 6 | 50 | 50 |
| Reserves ⓘ | 5 | 7 | 8 | 10 | 10 | 12 | 13 | 14 | 19 | 23 |
| Minority Interest | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Debt | 91 | 152 | 127 | 116 | 88 | 83 | 231 | 241 | 347 | 293 |
| Long Term Debt | 0 | 0 | 0 | 0 | 0 | 13 | 59 | 51 | 81 | 3 |
| Short Term Debt | 91 | 152 | 127 | 116 | 88 | 71 | 172 | 190 | 267 | 290 |
| Trade Payables | 22 | 9 | 19 | 16 | 17 | 29 | 50 | 34 | 70 | 64 |
| Others Liabilities ⓘ | 5 | 6 | 6 | 6 | 85 | 103 | 3 | 52 | 44 | 187 |
| Total Liabilities ⓘ | 129 | 179 | 166 | 153 | 251 | 278 | 303 | 346 | 531 | 616 |
Fixed Assets | ||||||||||
| Gross Block | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 1 | 1 | 2 |
| Accumulated Depreciation | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 |
| Net Fixed Assetsⓘ | 0 | 0 | 1 | 1 | 1 | 2 | 1 | 1 | 1 | 2 |
| CWIP ⓘ | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Investmentsⓘ | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 2 |
| Inventories | 115 | 149 | 135 | 141 | 195 | 215 | 238 | 266 | 383 | 539 |
| Trade Receivables | 7 | 16 | 20 | 5 | 6 | 7 | 3 | 2 | 44 | 61 |
| Cash Equivalents | 1 | 6 | 5 | 1 | 1 | 0 | 0 | 0 | 8 | 1 |
| Others Assetsⓘ | 6 | 8 | 6 | 5 | 49 | 54 | 60 | 76 | 93 | 11 |
| Total Assets ⓘ | 129 | 179 | 166 | 153 | 251 | 278 | 303 | 346 | 531 | 616 |
| PARTICULARS | Mar'15 | Mar'16 | Mar'17 | Mar'18 | Mar'19 | Mar'20 | Mar'21 | Mar'22 | Mar'23 | Mar'24 |
|---|---|---|---|---|---|---|---|---|---|---|
| Cash Flow From Operating Activity ⓘ | -33 | -52 | 33 | 19 | -53 | 14 | 25 | -39 | -112 | -158 |
| PBT ⓘ | 1 | 2 | 2 | 2 | 1 | 2 | 2 | 1 | 2 | 4 |
| Adjustment ⓘ | 4 | 5 | 9 | 12 | 4 | 3 | 5 | 3 | 9 | 19 |
| Changes in Working Capital ⓘ | -38 | -58 | 23 | 6 | -58 | 10 | 19 | -42 | -122 | -181 |
| Tax Paid ⓘ | 0 | 0 | -1 | -1 | 0 | -1 | 0 | -1 | 0 | -1 |
| Cash Flow From Investing Activity ⓘ | 1 | 1 | 0 | 0 | -40 | -4 | -2 | -10 | -10 | 33 |
| Capex | 0 | 0 | 0 | 0 | 0 | -1 | 0 | 0 | 0 | -1 |
| Net Investments | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -1 |
| Others ⓘ | 1 | 1 | 1 | 1 | -40 | -3 | -1 | -10 | -10 | 36 |
| Cash Flow From Financing Activityⓘ | 32 | 56 | -35 | -23 | 93 | -10 | -23 | 50 | 130 | 117 |
| Net Proceeds from Shares ⓘ | 0 | 0 | 0 | 0 | 46 | 0 | 0 | 0 | 49 | 0 |
| Net Proceeds from Borrowing ⓘ | 0 | 0 | 0 | 0 | 0 | 12 | 1 | 38 | 51 | 78 |
| Interest Paid ⓘ | -5 | -6 | -10 | -13 | -6 | -6 | -8 | -6 | -14 | -22 |
| Dividend Paid ⓘ | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Others ⓘ | 36 | 61 | -25 | -11 | 54 | -17 | -17 | 18 | 44 | 62 |
| Net Cash Flow ⓘ | -1 | 5 | -2 | -4 | 0 | 0 | 0 | 0 | 8 | -7 |
| PARTICULARS | Mar'15 | Mar'16 | Mar'17 | Mar'18 | Mar'19 | Mar'20 | Mar'21 | Mar'22 | Mar'23 | Mar'24 |
|---|---|---|---|---|---|---|---|---|---|---|
| Ratios | ||||||||||
| ROE (%) | 5.77 | 11.2 | 12.22 | 10.29 | 4.09 | 10.1 | 6.26 | 1.58 | 3.07 | 4.52 |
| ROCE (%) | 6.65 | 5.77 | 7.99 | 11.15 | 4.92 | 5.58 | 4.69 | 2.7 | 4.05 | 5.33 |
| Asset Turnover Ratio | 0.26 | 0.19 | 0.27 | 0.35 | 0.19 | 0.1 | 0.12 | 0.11 | 0.09 | 0.16 |
| PAT to CFO Conversion(x) | -33 | -52 | 16.5 | 9.5 | -53 | 7 | 25 | N/A | -112 | -52.67 | Working Capital Days |
| Receivable Days | 56 | 136 | 140 | 84 | 54 | 92 | 55 | 24 | 209 | 205 |
| Inventory Days | 1,119 | 1,625 | 1,116 | 908 | 1,624 | 2,894 | 2,385 | 2,550 | 2,941 | 1,799 |
| Payable Days | 399 | 252 | 151 | 159 | 190 | 442 | 538 | 520 | 695 | 367 |
Rainbow Foundation (RFL), established in 1994, is a gigantic construction company with an enviable track record in the real estate scenario of Chennai. The innumerable residential and commercial projects that are executed successfully, have added to its reputation and ranks it among the frontrunners.
The directors of this company have been property promoters in their individual capacity and have a combined exposure of nearly a decade in this industry. They joined hands to pool in their project experiences and building skills and incorporated RFL as a new enterprise in 1994 with sole purpose of identifying and buying highly potential real estates with the objective of developing attractive commercial and residential apartments/Buildings complexes and selling them profitably.
The prime properties of the company include Rainbow Arcade, Rainbow Praveen, Rainbow Nirav, Rainbow Plaza, Rainbow Court, and dozen such commercially attractive properties, which are located in and around Chennai Metropolis
The company has developed 4.4 million square feet of property. Rainbow Foundation’s registered office is located at Subramanian Buildings No 1, Club House Road, Chennai 600002.
The shares of company are listed on Madras Stock Exchange and Bombay Stock Exchange.
Completed Projects - Rainbow Foundation has handled projects like Rainbow Arcade (T Nagar), Rainbow Raj Bhavan (Kilpauk), Rainbow Nirav (West Mamballam) and Rainbow Plaza (Purasaivakkam)
Ongoing Projects - The company is currently working on projects namely Rainbow Abhay (Kilpauk), Rainbow Nest (Perungalathur), Rainbow Courtyard (Velachery), Rainbow Riddhi (Selaiyur) and Navin Nagar (Arakkonam).
Upcoming projects - RFL’s upcoming portfolio comprise Rainbow Park (Raja Anamalai Puram), Independent Houses (Guduvanchery) and Rainbow Towers (General Peters Road).
MoneyWorks4Me rating and ranking of funds for SIP is available to subscribers only. Moneyworks4Me is not a rating and ranking agency, however it is required that users have a way of selecting funds and building a Portfolio. The method used by it are described below to enable users to understand the logic behind the rating and ranking Subscriber will find more details on this in the various content made available from time to time. In case you need more please write to besafe@moneyworks4Me.com
MoneyWorks4Me rates and ranks mutual funds based on the following data-driven system:
Funds ranking in screeners: Performance Consistency and Quality are two parameters used for ranking funds for SIP. The ranking as follows GG, GO, GR, OG, OO, OR, RG, RO and RR.
With the same color-coded funds, the one with the higher Average 3-year rolling returns (over 5 to 10 years), the number that appears in the Performance tag, ranks higher.
Here is the summary:
The third tag Upside Potential is not relevant for SIP. It is relevant for lumpsum investments in Mutual Funds.
Make an informed decision for Stocks
Invest using an intelligent system with powerful data-driven tools that help you identify opportunities and make informed buy-hold-sell decisions
Buy quality Stocks when they are available at reasonable prices and supported by an upward price trend and Sell when they are Overvalued using the Decizen Rating System. Covers 3500+ stocks
Limited to the first 10 users today!
Practical Stock Investing Hand Book
By - Raymond Moses
Founder of MoneyWorks4Me | Consultant | Trainer | Author | TEDx Speaker
Register & Get Instant Access!Don't miss out! First 10 users today get it FREE
With this 4 hrs Masterclass, you’ll be able to:
Download APP
