How to Value a Stock with This Simple Model
Learn how to value a stock with this simple stock valuation model in Google Sheets. I will explain one way how to value a stock, analyze three stocks using this spreadsheet model, and teach you how to build this value stock model for yourself.
This is a value-packed video for you so I have added some navigation timestamps you can use for future reference. You will get the most value out of the video if you are able to fully watch until the end and learn how to build and use the model for yourself.
Part 1: Model Explanation
00:00 Model context
01:03 Model introduction and explanation
03:21 Mini-lesson on discounting cash flows
04:31 Notes on model inputs
Part 2: Using the Model to Value Stocks
05:29 Analyzing and valuing Facebook stock (FB)
06:22 Understanding growth rate assumptions
07:34 Analyzing and valuing GameStop stock (GME)
08:33 How to test for a margin of safety
09:49 Analyzing and valuing Newell Brands stock (NWL)
Part 3: Building the Model
10:59 How to build the model yourself
11:40 Setting the years
12:06 Calculating the future earnings
14:22 Calculating the discounted earnings
17:36 Checking your model
18:11 What to do if you need help?
DISCLAIMER: This video is a resource for educational and general informational purposes and does not constitute actual financial advice. No one should make any investment decision without first consulting his or her own financial advisor and/or conducting his or her own research and due diligence. There is no guarantee or other promise as to any results that may be obtained from using this content. Investing of any kind involves risk and your investments may lose value.
CREDITS
Outro: / vibin-kevatta-x-saib
Saib: / saib_eats
Kevatta: / kevatta