You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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.
The text was updated successfully, but these errors were encountered:
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.
The text was updated successfully, but these errors were encountered: