Hi sifus, I just wanna inquire if anyone has any experience in using tool/ calculator/ software to calculate the intrinsic value of a stock?

What tool/ calculator/ software would you suggest?

You can use:
Free google spreadsheet x1
Calculator x1
Human Brain x1

Advantage:
You can almost certain your calculation is always correct in comparison with those out there which claim can calculate the IV in just a few empty cells for you to fill up. You can alter your parameters freely if the company has decided to jump on the PPE wagon and divert their business

Disadvantages:
You wont be able to do all that above without properly using your brain, so if you don't have a brain and also lazy, you won't yield sensible result.

Spreadsheet provided in the link.
Might be a little heavy for those without accounting and finance background.


This post has been edited by Yggdrasil: Aug 15 2020, 10:38 AM

Thank you all for the input. FYI, I was only asking for my elderly friend who wanted to do value investing. I have prepared a intrinsic value calculation template in spreadsheet for him - he just needs to extract the relevant data from the annual reports. However, he finds it troublesome and wanted something easier/ less time consuming. I'm not sure if there's any intrinsic value calculator/ tool available in the market and hence, seeking help here.

Please let me know if you come across any tool that meets his need

If he's near retirement age, he shouldn't be speculating on individual stocks. Even if he wants to, he should limit it to 10% of his portfolio.

No matter how much he analyses a stock, there is a risk that he's wrong. He should stick to fixed income (e.g. bonds) or ETFs. I know someone (80+ years old) who lost few millions in Maybank stock during the 2008 financial crisis. Thankfully it's only a small percentage of his wealth.

Although it's not too late to learn about investing at this age, it takes time. Even Warren Buffett makes terrible decisions (see Tesco and Kraft) and his company underperformed the index quite a number of times.

To answer your question:
Some websites extract data and tabulate for you, however they extract 1000+ companies so there's bound to be mistakes. Even Bloomberg Terminal (costs thousands per month) sometimes doesn't have the latest info/wrong numbers.

Best is to extract from their recent quarterly reports. Do note that quarterly reports are not audited and can have errors/fake numbers. Even audited annual reports cannot be trusted if the auditor is a small fry who probably takes bribe from the directors.