Bug in "Max cash deployable"
przemator opened this issue · 0 comments
przemator commented
There is a bug in tab "Monte Carlo Valuation" cell C84. "Max cash deployable" for 2020 is sourced from tab "Tesla Valuation", where it is calculated using "Percent of factory-build debt-funded" of 60%. Then this value is used in "Gross property, plant and equipment" for 2021 (cell D73), but using the debt percent of 95%. This leads to totally overblown growth in PPE in 2021 and car production in 2022 (cell E53, growth from 0.7m to 5.7m in 1 year).
As you can see in the screenshot, PP&E grows by far more than we allow in the first year. This leads to some very high numbers of total cars sold by the end of 2025, even as high as 100 million.
