DCF Lesson

Loading...

Sign in or sign up now!
Alert icon
Upgrade to the latest Flash Player for improved playback performance. Upgrade now or more info.
4,176
Loading...
Alert icon
Sign in or sign up now!
Alert icon

Uploaded by on Apr 22, 2009

A colleague wanted an update on how to run a DCF calculation in Excel. This is the best way to evaluate a project or a business, which is the sum of its projects. Obviously this one simply scratches the surface of what can be done.

Or find me on Linked In - there's only one David James in Poland afaik, and when you link in to me you'll see it on my filebox in my profile.
If you want the Excel file here, then respond to me with your e-mail so that I can send it to you.

Category:

Education

Tags:

License:

Standard YouTube License

  • likes, 0 dislikes

Link to this comment:

Share to:

Uploader Comments (usenetposts)

  • Careful in using only one approach, such as a DCF - you need a holistic approach to valuation. Check out investmentquality.co.uk to see their approach.

  • @TheValuationsExpert I never used only one approach and I never advised the use of only one approach. Personally I use a weighted average of several approaches, but always the highest weighting goes to DCF and how high it is depends upon the quality of the forecast - the appropriateness of the assumptions and their verifiableness, as well as a check over the maths in the forecast.

    This gives you what a business will be worth in the future but nobody would pay that. There has to be a margin.

  • could you please email me the file. Thanks.

  • @sanjargulyamov I've added some instructions for getting that table into the description. I cannot publicise the original file with the internet sources I'm using, and I don't have the ability to email it unless I have an email address. That's why I added it to huliganov tv blog, and hopefully you can copy-paste that table into excel.

  • can you please send me the file as well? thank you

  • @titika2010 See huliganov dot TV in the section "Answers to your Questions". TY.

see all

All Comments (10)

Sign In or Sign Up now to post a comment!
  • please send me a copy of the file. thank you

  • could you please email me the file, thanks

  • please email me the file. thanks

Loading...

Alert icon
0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more