I often see posts with questions about the valuation of a company. I wanted to share a spreadsheet I built which provides tools for estimating a valuation target for a company using the Discounted Cash Flow (DCF) method, which uses projected future cash flows.
The spreadsheet:
- takes input from a company's financial statements,
- calculates key ratios,
- allows you to change pro-forma (forecast) assumptions,
- Provides a valuation based on Discounted Cash Flow (DCF) method using populated pro-forma data
It's available on GitHub. Feel free to download and modify as you like.
(Note: The document contains TSLA data as an example for the model. I find it instructive because it highlights how much growth assumptions affect the valuation. This is not meant to be a Tesla debate!)
Submitted May 23, 2019 at 03:24PM by vol_trader http://bit.ly/2K5B3BM
