With any intrinsic value model, there are shortcomings and disadvantages. Even with this version of the discounted cash flow spreadsheet, there are disadvantages to using the DCF model, but it is logical and reasonable.
Before moving on, I also created a free Graham formula spreadsheet that may interest you.
This free DCF spreadsheet utilizes the Discounted Cash Flow method, which I believe is a very logical method of valuing a stock and estimating its fair value.
This free discounted cash flows spreadsheet is based off FWallStreet and is an enhanced version of the original spreadsheet available from fwallstreet.com.
The underlying calculations are the same but many tweaks have been made to the formula and variables.
The full version of the stock value calculator includes an entire suite of valuation models to help you value stocks quickly and accurately.
To download the free DCF spreadsheet, simply enter your email in the form at the bottom of the page. Once you have entered your email, you will automatically receive, not just the DCF spreadsheet but eight more spreadsheets for your own use. You will also be able to get articles such as this directly to your inbox.
I’ve tried to make it as user friendly and simple to understand.
In order to get it working though, you MUST install the plugin for excel which is described in the spreadsheet. It is a free plugin that allows excel to automatically retrieve financial data from the internet.
Feel free to check out this free version and then when ready, go to the stock valuation software page and review what you will get with the premium.
The premium version includes several valuation models as well as fundamental analysis data, historical data, charts and competitor comparison features. Just by entering one ticker, you can immediately get all that information on your favorite stock which will save you hours in your analysis.
Professor Damodaran’s Page includes a discounted cash flow spreadsheet.
Macabus also has a good DCF spreadsheet, but requires a lot of inputs.