• Stress Testing Reliance Industries in Excel: What Will Happen When Things Go Wrong?

    Most investors look at RIL’s Rs. 10.5 lakh crore revenue and assume the company is untouchable. But when I ran it through a structured Excel-based stress test, the results were genuinely surprising. A mere 5% fall in revenue, combined with a 3% rise in costs, caused RIL’s net profit to collapse by 90% and free cash flow to turn deeply negative. I am going to show you exactly how I did this analysis, step by step, with real numbers. [Downloadable Excel Template is available for subscribers].

  • Net Current Asset Value Per Share (NCAVPS): A Method To Value Stocks

    If you like to estimate intrinsic value of a stock, then start with Net Current Asset Value Per Share (NCAVPS). Why? Because it is the easiest to calculate and is most reliable of all. Yes, for me it is even more reliable than DCF method. But the big problem with NCAVPS method is that, its…

  • Hindustan Zinc Share Price Analysis

    Hindustan Zinc is the 27th biggest stock in Indian stock market in terms of its market capitalisation (Rs.1,04,661 Crore). Another feature of Hindustan Zinc which makes it my favourite is it being an almost ‘debt free’ company. There are many debt free companies in India. But as Hindustan Zinc being in the metal space, staying…

  • Aluminium Price is Falling due to trade war. Which stock to buy?

    On one side aluminium price is falling globally. On the other side the cost of Alumina (raw material) is rising. But this increase in raw material cost is not visible in aluminium’s market price. Why Aluminium price is falling? Because of the import duties imposed by USA. Donald Trump has been in sorts of trade…

  • Engineers India Ltd- Stock Analysis

    Engineers India ltd is a Government of India Enterprise. Its main business is “Engineering Consultancy” and EPC (Turnkey Projects) services. Engineers India Ltd (EIL) comes under the Ministry of Petroleum and Natural Gas. The consultancy and EPS services rendered by EIL caters mainly to Oil and Gas and Petrochemical sector. The revenue break-up of Engineers…