Discounted Cash Flow Analysis Model & Video Tutorial

Ever wondered how professional investors decide to buy or sell a stock? How about when a business owner decides to sell their company and they negotiate a successful multi-million dollar sale? Or maybe you've wondered what terms like "cash flow" or "valuation" or "enterprise value" are thrown around on shows like Shark Tank, and you're not quite sure what they mean? If you've ever wondered these things, then this is the file for you.

In this spreadsheet and video tutorial, I cover what a discounted cash flow analysis is, the definitions of terms and concepts used in a discounted cash flow analysis, and how to use the model itself. This comprehensive and in depth guide provides a basic crash course in how to conduct a discounted cash flow analysis, where to get the data, how to think about assumptions used in the model, and what the results mean. This file can be used to help guide investment decisions, help business owners get a clear financial understanding of what they have built, or maybe you're a bit rusty on your Excel skills and don't want to go through the headache of building a DCF model yourself. From professional MBAs to people who are brand new to finance, anybody can find use out of this file. Enjoy!