A discounted cash flow analysis (DCF) is one of the most widely used methods of calculating the intrinsic value of a business. This often involves spreadsheets that aren't the easiest to use, having to look at multiple places to find the data, or online calculators that over simplify the process by simply adding a multiplier to previous free cash flows.
That is why I created this calculutor, which shows you the last 5 years of data (green section below, you can hide/show it by the click of a button) , allows you to quickly and easily change specific variables, and finally shows you the entire picture on what your chosen variables mean for the company. It calculates the intrinsic value per share (based on your inputs), as well as shows you a table (yellow section below) that show what your growth rates mean in terms of future revenue/earnings over the next 10 years for the company. This allows you to quickly do a sensitivity analysis, as well as make sure the numbers make sense for the sector your company is in.
We are working on a guide on how to do a discounted cash flow calculation with this calculator: DCF Guide. Alternatively you can check one of my many personal valuations, where I breakdown how I personally value companies using this calculator.
I have based this off Professor Aswath Damodaran's teachings, with some slight modifications. Aswath Damodaran is a professor at Stern School of Business at New York University. He is known as the 'dean of valuation'. I would highly recommend reading some of his books on valuation if you haven't yet. I have suggested a few of my favourites below.
Please enter the stock ticker. Add .to for Canadian stocks.
|Cost of Capital
|Cumulated Discount Factor
|PV of FCFF