Being who I am, I had to make a spreadsheet. I expected it to be trivial but I soon realized that there are a bucket of assumptions and subjective matters that go in to assigning values
I decided to share the spreadsheet to hear comments and to offer it up as a template for anyone who wants a head start on something similar. To make it your own so you can edit, make a copy.
- Depreciation value ?
- Model 3 to Model Y value ?
- Interim model improvements values ?
- Include taxes, cost of lost mods ?
- ... there is a long list
I decided to share the spreadsheet to hear comments and to offer it up as a template for anyone who wants a head start on something similar. To make it your own so you can edit, make a copy.