Jae Jun
Free Excel Discounted Cash Flow Spreadsheet
Previously I put up a Ben Graham formula investment spreadsheet.
As with any intrinsic value model, there are shortcomings and disadvantages. Even with this version of the DCF spreadsheet, there are disadvantages but it is logical and reasonable.
This free DCF stock valuation spreadsheet utilizes the Discounted Cash Flow method, which I believe to be one of the most logical methods of valuing a business and estimating its fair value.
How to Value a Stock
The discounted cash flow intrinsic value calculation is based off FWallStreet’s method. The original spreadsheet can be downloaded from his post on JNJ.
This free version is just an enhanced version of the original spreadsheet. The underlying calculations are the same but many tweaks have been made to the formula and variables.
The full version of the stock valuation spreadsheet includes an entire suite of valuation models at great value. Buyers receive 1 year of free updates as well.
How to Use this Excel DCF Spreadsheet
If you have read the AAPL stock analysis post, you would have seen the screen shots of what it looks like. If you have personally used either the Benjamin Graham valuation spreadsheet or the portfolio tracking spreadsheet you will know how much time you save with the automated downloading of data.
Once you have the valuation spreadsheets working, just be sure to enter the ticker in the ticker box only. Everything starts from there.
Other Points
Since this stock valuation calculator is free, if you enjoy this spreadsheet, consider buying the best stock valuation spreadsheet available on the internet.
IMPORTANT!
Please read the installation guide and FAQ.
To date, I’ve been spending hours helping people with simple excel issues on a free product rather than anything spreadsheet related.
So for all excel and install problems, place all questions in the comment sections below. That way I won’t have to answer the same question again and again.
How to Download
The download has now moved.
To download the spreadsheet, you must go to the main page of Old School Value and sign up with your email to receive a list of free spreadsheets.
The list includes nine free spreadsheets, the add-in required to download data from the internet as well as all the installation help material.
Premium Spreadsheets
Feel free to check out the 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.
Go now and see for yourself why people rave about the spreadsheets.
DCF Excel Spreadsheet Screenshot
