First things first. I had a wonderful workshop in Pune last Sunday. And here are the amazing tribe members who attended it…
My upcoming Workshops would be in Chennai, Delhi, and Mumbai, and you will get an update on the same soon.
Anyways, let me now focus on today’s topic. Ever since I shared my stock analysis excel a couple of years back, I have received innumerable questions from people who’ve found it difficult to handle the excel. 🙂
If you have been facing a similar problem, don’t worry, because I’m working on a few simple online calculators – like the one on DCF or discounted cash flow method below – that can help you analyze the financials of businesses and also value them.
Now, before you praise me for my tech skills which I don’t have, let me share that this calculator has been developed by my good friend and tribe member Anshul Khare, who is also working with me on other such calculators. Thanks Anshul!
Before you work on the calculator below, read this post I did on how to value stocks using DCF to understand the basics of sensible DCF usage, and how to avoid its misuse.
And after you work on the calculator below and arrive at DCF values for your chosen stocks, remember that your results will be proven wrong in the future (all valuations are wrong, you see!). 🙂
A tool like calculator or excel must only be used for approximate estimation, and never to seek perfection. What matters more is whether the business is simple to understand and whether you understand it or not.
So, please focus on decisions, and not on outcomes of these tools.
Now, try out this DCF Calculator (please use only absolute values, i.e., without decimals and percentage signs). Hover on the “Help” links to understand what a specific term/field means.
If you can’t see the calculator below, click here.
I’ll soon be sharing a few other calculators to perform financial analysis and stock valuations. So your questions and feedback on this DCF calculator and other relevant suggestions will be very helpful.
You can share the same in the Comments section below.