# Introducing: The DCF Calculator

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.

DCF Calculator :

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.

Vishal Khandelwal is the founder of Safal Niveshak. He works with small investors to help them become smart and independent in their stock market investing decisions. He is a SEBI registered Research Analyst. Connect with Vishal on Twitter.

1. Hi Vishal,

This was much needed.

Thanks for creating it.

• Thanks Sham!

2. Akshay says:

Thank you vishal
Appreciate the effort as always

Regards

• Thanks Akshay! No downloadable version as of now. But I will soon create a single page for this and all future calculators. Regards.

3. Gundeep says:

Hi Vishal,

You are doing commendable work in the field of investor education. Please keep it up.

Have always learnt something on every visit to your site.

Cheers!

Gundeep

4. Great work! Thanks Vishal for such an effort.
I observed that the above DCF calculator does not work for decimal numbers. i.e., it would work if all the values are whole numbers (1,2,3,4, etc) but not when any of the value is fraction (2.21, -4.65, etc).

• Anshul Khare says:

Hey Abhijit,

As Munger says, “Its better to be approximately right than precisely wrong” ðŸ™‚

Still, if you do want to use fractional values, you can use absolute values in all the rupee fields (instead of cr). So if you want to enter 4.57 cr. as Initial FCF, 10.5 cr as shares outstanding and, 7.62 cr. as net debt; you can instead enter 45700000 as initial FCF, 105000000 as shares outstanding and 76200000 as net debt.

So all the Rs. values have to be entered in the same denomination (Cr./Lacs/million). The final result of DCF value per share will always be in rupees.

5. Saurabh says:

Thanks Vishal! This is of great value!! Might I suggest that you put all your resources such as the stock analysis excel and these calculators on a separate tab right at the top for ease of access.