Free Discounted Cash Flow Spreadsheet

March 24th, 2008 | Comments (25)

Written by

Jae Jun

follow me on

Facebook

Twitter

Discounted Cash Flow Spreadsheet

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.

How to Value a Stock with the DCF Spreadsheet

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.

How to Download the Free DCF Spreadsheet

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.

How To Use The Free Spreadsheet

I’ve tried to make it as user friendly simple to understand.

The spreadsheet requires manual inputs for the required data.

Follow the instructions in the spreadsheet to use it properly.

Premium Stock Valuation Spreadsheets

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.

Go now and see for yourself why people rave about the spreadsheets.

DCF Excel Spreadsheet Screenshot

More Resources

Professor Damodaran’s Page includes a discounted cash flow spreadsheet.

Macabus also has a good DCF spreadsheet, but requires a lot of inputs.

About Jae Jun


Jae Jun is the founder of Old School Value. He is on a mission to provide practical and actionable value investing tools, tutorials and educational material to help empower the individual investor. Keep in touch with Jae via any of the methods linked below.

Get Tips and Strategies to Achieve Higher Returns
Bonus: Get 9 FREE Investing Spreadsheet Calculators
  • Andrei

    Hey Jae,

    Awesome job with the blog. It is really great–mostly the spreadsheets–now if only you could help me get them to work–I am having the hardest time getting the add-ins to work. I thought I managed but then I put in a symbol ODP and I got a bunch of #NAME! things to come up on the statements tab of the Valuation Spreadsheet…Please help. Thanks.

  • http://one2imagine.com Luis

    Jae,

    To add on to Andrei, why dont financial’s work with your sheet?

  • http://www.oldschoolvalue.com Jae Jun

    @Andrei,

    It still seems like the function isnt being called properly. Did you unzip the files to the proper folder and then point excel to the file in the folder you unzipped to?

    @Luis,

    if you take a look at the financial statements for financial companies such as AXP, you’ll notice that the statements are different to the regular companies. Since the template for the statements tab only applies to non-financials, I would have to create another statements tab for financials. But, I won’t be doing that because I dont know how to determine the intrinsic value for banks etc.

  • Aurelien

    Hi Jae,

    This spreadsheet is very nice looking and I was excited to see it for JNJ. However, it seems to freeze when I put in another stock symbol to get information. I have a fast internet connection, so I don’t think that’s the issue. Could it be the Morningstar site, or is there something wrong with the sheet, or does it simply take a long time in general?

    Thanks

  • http://www.oldschoolvalue.com Jae Jun

    Hi Aurelien,

    The spreadsheet freezes because it has to access the Morningstar database and then run the commands on each cell to pull the commands.

    Although Morningstar loads quickly in a web browser, the excel sheet has to request the information from Morningstar for every cell. Basically it’s asking the same thing about 200 times.

    That’s the cause for the delay. If you look in the bottom right corner, it will tell you the % complete.

  • Aurelien

    To update on my previous post: The sheet is working fine, it was just slower then expected.

    Very cool. I’ve already found a company that seems to be quite undervalued and also has a 10% dividend yield. MAS.

    Will look more into it tomorrow.

  • http://www.oldschoolvalue.com Jae Jun

    Great. Hope you find heaps of opportunities with it

  • Aurelien

    Hi Jae,

    The spreadsheet is suddenly only giving me error’s in the cells. Have you heard anything about Morningstar changing their data display, or any other reason for this?

    Thanks,

    Aurelien

  • http://www.oldschoolvalue.com Jae Jun

    I too have been getting the same error. I’m not quite sure what the error is but it seems to work again after I restart excel several times or try writing the ticker in both lower and upper case.

  • spike

    I’m running Excel on a Mac – so there is no c:/ for me to download to.
    I put the files in Applications/Microsoft Office 2004/Office/Add-Ins/SMF, but I get a compile error ‘Expected: end of statement’

    Can you help?

  • http://www.oldschoolvalue.com Jae Jun

    Spike,

    It wont run on Mac. You’d have to run it off a Windows OS.
    http://www.oldschoolvalue.com/intrinsic-value-spreadsheets/

  • Mario

    Hi

    I downloaded the free version of the DCF valuation spreadsheet. On the DCF Valuation sheet, cell C6 has a Note saying that it should use CROIC for Growth but the IF formula within cell C6 points to J32 (the median for Free Cash Flow). Based on the Note inbedded in C6, should the formula be pointing to J33 instead?

    Thanks.

  • http://www.oldschoolvalue.com Jae Jun

    Mario,

    I first used FCF, then changed to CROIC and then reverted back to FCF.
    I found CROIC was sometimes much too high. Since we are looking for good companies, the managers at these companies have very good performance and money allocation skills which is what you want in an investment.
    However, the growth was far to high to predict 10 years.

    Which is why I changed back to FCF and also included a FCF override feature in the premium spreadsheet.

  • bruc

    Will your spreadsheets work with office 2000?

  • http://www.oldschoolvalue.com Jae Jun

    No you should have at least excel 2002.
    Office 2000 is a 10 year old product and doesn’t support many things.

  • Smith

    I can’t download the Free Excel Discounted Cash Flow Investing Spreadsheet as well as the others free tools such as “Benjamin Graham Stock Valuation Spreadsheet “,”Randy’s SMF Excel Add-in “, etc.

    Are they still available?

  • http://www.oldschoolvalue.com Jae Jun

    What do you mean? I can download them perfectly fine. Just click and follow the links.

  • Ryan

    I just get name errors on this one. Your other spread sheets work fine for me. Do I need to delete smf files and try again? Thanks and great site.

  • Steven

    Hello,

    When I click the spreadsheet install link. It is linked to a page with an error message: Error-404

    Is there anywhere I can go to get the install instructions?

    Thank you for your time,
    Steven

  • http://www.oldschoolvalue.com Jae Jun

    link has been fixed.

  • Ming

    Does the spreadsheet only work for US stock?
    How about stock in other countries ?

  • http://www.oldschoolvalue.com Jae Jun

    Yes only US stocks.

  • Ryan

    I received the email and some of the free spreadsheets links (DCF, Beneish M Score,Competitor Comparison, Financial Statements) are no longer working. Note: It works for the other spreadsheets. Please let me know where I can find the missing spreadsheets.

  • James

    Why isn’t the DCF link still working Jae?

  • http://www.oldschoolvalue.com Jae Jun

    I upgrade the DCF spreadsheet and moved it to a lite version which you can purchase for a cheap price.

x
Receive Email Tips and Strategies on Achieving Higher Stock Returns

Bonus: FREE Set of 9 Investing Spreadsheets