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.
