Investing

This page contains our best articles on the subject of value investing and investment behaviour.

If you wish to receive these and all future such articles straight into your email, subscribe below to my free newsletter - The Safal Niveshak Post - that offers practical, time-tested insights to help you navigate stock market with confidence. Subscribers call it a "gold mine" for investors, and it's read by 80,000+ people across 120+ countries.

* No charge. No spam. Only wisdom.

Stock Analysis Excel Template Version 4.0

Whether you’re training for a marathon or going on an adventure trip, being ready can make a world of difference.

The same is true for the stock market. It’s important to be prepared with a watchlist of fundamentally sound stocks ready to be bought at the right prices. Whether the market is in rally mode or in a phase of correction, being prepared with a watchlist is key.

Here is Version 4.0 of my Stock Analysis Excel Sheet that will help you with exactly that – identify high-quality businesses to create your watchlist and buy them when the prices are right.

Download this sheet on your computer, read carefully through the instructions to follow a few simple steps, and then analyze not just the past performance of a company but also arrive at its approximate intrinsic value range.

Click Here to Download Stock Analysis Excel Template Version 4.0

Like the previous version 3.0, this latest version feeds in data automatically from Screener.in website, which subsequently feeds into my sheets on financial analyses and intrinsic value calculations. So, please thank Screener’s creators and my friends Ayush and Pratyush before thanking me. 🙂

If you have been into financial modeling in the past, this excel file may seem like a child’s play. But, if my 15+ years of experience as an analyst is anything to go by, this is most of all you require to “quantitatively” analyze stocks…not models running into hundreds of rows and tens of sheets.

Saving Your Retirement from a Stock Market Crash

Disclaimer: I am not a financial advisor. The advice given below is not a financial advice even though my excitement might make it look like such. In fact, what follows below are just my thoughts, those of an ordinary person who works hard, and tries to save and invest as sensibly as he can.

I received a call from a 59-year old gentleman, a distant relative, yesterday. We have not met in the past two decades, so the sudden call was surprising. But not after the first minute of our talk when he asked, “I’ve heard from your aunt that you work in the stock market. I wanted to discuss my investments. Can you please help?”

“Hmmm…sure,” I said, “almost sensing that he wanted to discuss his stock portfolio with me.”

But he started talking about his upcoming retirement – planned for 2019 – and about a plot of land sitting in his hometown waiting to build his retirement home next year.

He said he had been saving and investing as much money as he could for his retirement and for building this home.

How to Deal With the Harsh Reality of a Stock Market Crash

Short practical advice (may skip) – If you cannot withstand losing a bit of your money in a stock market crash (where things easily go from bad to worse to brutal), please stay away from stocks. But if you are fine with the risk of losing some money in the short run in return of wealth creation in the long run, keep owing your good stocks and/or good mutual funds. Buy more (and keep buying) if you believe the quoted (now lower after the crash) prices offer great value in the long run. Then, once you are with your chosen good investments, just get going with other more important things in life like family, work, and self-development…and let go of the outcome of your investments. Accept that whatever happens, happens.

Slightly long theoretical advice (must read) – I read a nice article earlier today on dealing with life’s harsh realities – sharp fall in stock prices is one such reality for most investors – and here is an excerpt from the same…

…the only intelligent thing to do when such turbulent change occurs is for us to sit back and realize that we are only to be witnesses to change, and to respond to it rather than to react to it — much like we would watch a movie unfold on the screen and laugh at the funny bits and cry at the sad bits, while always knowing that what is happening before our eyes is unreal.

Modern quantum physics after Einstein also points us this way — it says that what occurs depends upon the observer, and not on what is observed. So, in effect, as a witness, I am free to choose my response, and therefore the reality I actually experience.

3 Iron Rules of Life and Investing

You seem to be stressed out today?” asked my Yoga teacher, a gentleman in his late fifties.

“Oh, not really!” I said.

“No, you look a bit stressed. Are you unwell?”

“Not at all. Just feeling a bit confused.”

“May I help?”

“Knowing you, I think you can.”

“Shoot!”

“You see, I have been a stock market investor for many years now, and now also don the role of a teacher trying to help people make saner and better investment decisions. But I am often faced with a dissonance.”

“And what’s that?”

On Stories We Tell

For my twin toddlers, the instant attention-grabbing words are — Once upon a time. They drop everything and dash to whoever uttered those words.

It’s my only weapon to break their fights and tantrums. But once those words slip out then there is no escape.

“Tell me the story, Papa. Please tell me the story.” To their relentless prodding, I give in every time.

It doesn’t matter how interesting or boring the story is. Neither does it matter if I am telling them the same narrative for the hundredth time. Fed up they’re not. Any pause to catch my breath is cut short by an impatient stare demanding an exciting twist in the tale. Their eyes widen as if it’s not the ears but eyes they’re listening with.

Kids are suckers for stories. So are adults. Aren’t we?

The content may change but the fascination for stories is deeply ingrained trait that evolution has bestowed on the human brain.
[Read more…] about On Stories We Tell

What Are You Afraid Of?

I am in Chennai for my Value Investing Workshop that happened yesterday.

After my session, I went to meet a friend in the evening. His residential society had organized a bicycle race for kids. I saw more than 50 kids out there jostling for space meant for not more than 10 cyclists. Worse, most of them were without a helmet.

Now, letting your child cycle without a helmet may be ten times riskier than feeding him a course of dangerous non-steroidal anti-inflammatory drugs. And a thousand times riskier than flying in an airplane.

Moving in the front seat of a car without a seatbelt (which most people, especially teens, do when the policeman is not watching) is hundred times riskier than many common and ‘scary’ diseases in India, like swine flu.

Yet we obsess about the low probability events and take big chances with the high probability ones. Why?

The Tyranny of Screening Tests: From Medicine to Investing

A few months back I had written a post on Benford’s Law. It’s a fraud detection method to estimate if a given financial statement could be fake. In other words, it tells you if the numbers in a document are cooked up or real. When I first learned about Benford’s Law, I was like a kid with a new toy. I wanted to play with it immediately. Being a programmer, I wrote a small piece of code to extract the numbers from an annual report and test those numbers against Benford’s rule.

The next logical thought was to use my code and run it on the annual reports of all the publicly listed companies. This way, I could immediately identify all the companies which could be faking numbers. Wouldn’t that be cool? For some time, I even dreamed of floating a startup with this killer fraud detection product. I was going to be rich.

Now, instead of building my million dollar startup, I am writing this post. That should already give you a hint how that story turned out.
[Read more…] about The Tyranny of Screening Tests: From Medicine to Investing

Meditations on Mortality in Life and Investing

There is a story, not often told, in Mahabharata where the eldest of the Pandavas, Yudhishthira, comes upon a lake and finds that his brothers lay dead on its banks.

Before beginning the search into his brothers’ murder, the prince in exile finds himself burning with thirst and reaches into the lake to drink, not knowing that it was drinking from the lake that brought his brothers’ end.

At that moment a celestial appears, a Yaksha, no god or angel but instead a presence of power presiding over the lake. The Yaksha warns Yudhisthira not to drink lest he suffers the fate of his brothers.

He has an alternative: Yudhisthira can instead answer Yaksha’s questions. There are said to be eighteen questions that Yaksha asked Yudhisthira, but here is the one that concerns what I am writing today.

Investing and the Art of Stillness

This is the fourth issue of Outside the Box newsletter, and is authored by my friend Arpit Ranka.

In this post, Arpit talks about how we, as investors, need to embrace the good, bad, and ugly side of every investment thesis/strategy and be willing to live through all the seasons, if we have to stand a chance to succeed in the long run. Over to him.

The Art of Stillness
by Arpit Ranka

The noted English singer and songwriter John Lennon said, “Life is what happens while you are busy making plans.”

As an investor, I can tweak this thought to — “Investing is what happens when you are busy pursuing the next big investment idea.”

No doubt that ideation is a very integral part of any investment process but then equally central is to develop a mindset, which allows us to capitalize on the full potential of that investment strategy.

Remembering the 2008 Crisis, and A Few Lessons Learned

It seems like yesterday, but it was ten years ago. I was in the US for a conference and, on 15th September 2008, was visiting the Wall Street to check out the heart (maybe, the dark underbelly) of the global financial system.

I had just reached there after a visiting the site of the World Trade Center, which was tragically brought down on 11th September seven years ago.

Now, another tragedy was about to happen just five miles from where I was. This time it wasn’t about loss of lives but of livelihood.

Lehman Brothers declared bankruptcy and the world financial system was on the verge of collapsing. It was, and remains, the largest bankruptcy filing in the US history, with Lehman holding over US$ 600 billion in assets, supported by less than US$ 25 billion of own capital. That’s around 23-times debt to equity. In such a highly leveraged structure, a 4-5% percent decline in asset values would wipe out all capital, which it did.