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

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s