Valuation spreadsheet using Tesla as an example

There are many textbooks covering how to used discounted cash flow calculations to value an investment like a stock, but it seemed valuable to post a spreadsheet showing how this applies to projecting the implied future cash earnings of a high-growth company like Tesla Motors.

Here is a link to the spreadsheet for your reference. Β Please note the disclaimer tab showing this spreadsheet is a tool for turning one set of numbers into another and is not investment advice.

Screen Shot 2017-09-04 at 1.03.30 PM