Code Monkey home page Code Monkey logo

ark-invest-tesla-valuation-model's Introduction

ARK-Invest-Tesla-Valuation-Model

The information presented reflects the views and assumptions of the authors at the time of publication. Please note that this research is at least one year old and the authors' current views may materially differ from those presented without notice. The results will not be updated as ARK's internal models change, or any information upon which ARK relies upon changes.

Update 4/21/23: Added additional columns to our Monte Carlo Output tab, edited a column in our output tab to pull Autonomous Revenue in 2027 (v. 2026), and edited a formula to round our autonomous penetration rate according to fractional years between now and 2027. Changes have no effect on our price target for the 2027 year.

V7 published 04/20/23

This file “Tesla 2027 Valuation Extract for Github” includes an extract of our 2027 price target model for Tesla. Please read ARK’s blog https://ark-invest.com/articles/valuation-models/arks-tesla-price-target-2027/ for a more detailed discussion of our assessment, updates since our last published model, and key components of the model. ARK used a Monte Carlo simulation to arrive at our estimated price target for Tesla as well as our bull and bear price targets. A description of each worksheet in the file:

“Tesla Example Valuation” worksheet allows users to provide their own inputs for a fundamental-based valuation of Tesla. Users can change the 5 key drivers of the model in cells J12-J17, as well as 36 other inputs in cells H19-60. Note that because our price target is derived from a Monte Carlo analysis, there is no one single bear and bull case, but ARK has given example inputs for a bull and bear case in columns L and M.

The “Valuation ASP Tables” worksheet allows the user to change both vehicle average selling price and addressable market at each price point. One can also change the price per mile for an autonomous robotaxi, as well as the inputs for the adoption curve for the percent of Tesla’s fleet that is operating in the ride-hail network. This worksheet feeds into both the “Tesla Valuation” tab and the “Monte Carlo Single Simulation” tab.

The “Tesla Valuation Inputs” worksheet allows users to adjust the minimum, bear case, bull case, and maximum inputs for each variable. All variables are modeled as normally distributed with the bear and bull case inputs determining the values one standard deviation below/above the mean. The maximum and minimum inputs are used to exclude all distributions falling outside of the normal range from the analysis. Note that the “probability that robotaxis launch” row is the only binary input. When changing variables in this worksheet it may be necessary to wait to allow the simulation to calculate. Clicking immediately on another cell within the worksheet could cut the simulation short and provide inaccurate results. The output of the model is a probabilistic range of values.

A single simulated outcome is visible on the “Monte Carlo Single Simulation” worksheet; and a collection of all the simulations is visible on the “Monte Carlo Simulation Output” worksheet. A static example of 5,000 simulations using ARK’s inputs and assumptions is included in the “Example 5,000 Simulations” tab.

We will welcome all questions and constructive criticism and feedback.

V6 published 4/14/22

This file “Tesla 2026 Valuation Extract for Github” includes an extract of our 2026 price target model for Tesla. Please read ARK’s blog for or a more detailed discussion of our assessment, updates since our last published model, and key components of the model.

ARK used a Monte Carlo simulation to arrive at our estimated price target for Tesla as well as our bull and bear price targets.

A description of each worksheet in the file:

“Tesla Example Valuation” worksheet allows users to provide their own inputs for a fundamental-based valuation of Tesla. Users can change the 5 key drivers of the model in cells H12-H17, as well as 32 other inputs in cells H19-55. Note that because our price target is derived from a Monte Carlo analysis, there is no one single bear and bull case, but ARK has given example inputs for a bull and bear case in columns K and L.

The “Valuation ASP Tables” worksheet allows the user to change both vehicle average selling price and addressable market at each price point. One can also change the price per mile for an autonomous robotaxi, as well as the inputs for the adoption curve for the percent of Tesla’s fleet that is operating in the ride-hail network. This worksheet feeds into both the “Tesla Valuation” tab and the “Monte Carlo Valuation” tab.

The “Tesla Valuation Inputs” worksheet the user can adjust the minimum, bear case, bull case, and maximum inputs for each variable. All variables are modeled as normally distributed with the bear and bull case inputs determining the values one standard deviation below/above the mean. The maximum and minimum inputs are used to exclude all distributions falling outside of the normal range from the analysis. Note that the “probability that robotaxis launch” row is the only binary input. When changing variables in this worksheet it may be necessary to wait to allow the simulation to calculate. Clicking immediately on another cell within the worksheet could cut the simulation short and provide inaccurate results. The output of the model is a probabilistic range of values. A single simulated outcome is visible on the “Monte Carlo Single Simulation” worksheet; and a collection of all the simulations is visible on the “Monte Carlo Simulation Output” worksheet. A static example of 5,000 simulations using ARK’s inputs and assumptions is included in the “Example 5,000 Simulations” tab.

We will welcome all questions and constructive criticism and feedback.

V5 published 3/19/21

This file “Tesla 2025 Valuation Extract for Github_3.18.21” includes our 2025 price target model for Tesla. Please read ARK’s blog (https://ark-invest.com/articles/analyst-research/tesla-price-target-2/) for or a more detailed discussion of our assessment, updates since our last published model, and key components of the model. ARK used a Monte Carlo simulation to arrive at our estimated price target for Tesla as well as our bull and bear price targets.

A description of each worksheet in the file:

“Tesla Valuation” worksheet allows users to provide their own inputs for a fundamental-based valuation of Tesla. Users can change the 5 key drivers of the model in cells H12-H17, as well as 28 other inputs in cells H19-51. Note that because our price target is derived from a Monte Carlo analysis, there is no one single bear and bull case, but ARK has given example inputs for a bull and bear case in columns J and K.

The “Valuation ASP Tables” worksheet allows the user to change both vehicle average selling price and addressable market at each price point. One can also change the price per mile for an autonomous robotaxi.

The “Monte Carlo Inputs” worksheet the user can adjust the minimum, bear case, bull case, and maximum inputs for each variable. All variables are modeled as normally distributed with the bear and bull case inputs determining the values one standard deviation below/above the mean. The maximum and minimum inputs are used to exclude all distributions falling outside of the normal range from the analysis. Note that the “probability that robotaxis launch” row is the only binary input. When changing variables in this worksheet it may be necessary to wait to allow the simulation to calculate. Clicking immediately on another cell within the worksheet could cut the simulation short and provide inaccurate results. The “Monte Carlo ASP Tables” worksheet allows the user to change both vehicle average selling price and addressable market at each price point. One can also change the price per mile for an autonomous robotaxi. The output of the model is a probabilistic range of values. A single simulated outcome is visible on the “Monte Carlo Valuation” worksheet; and a collection of all the simulations is visible on the “Monte Carlo Simulations” worksheet. A static example of 5,000 simulations using ARK’s inputs and assumptions is included in the “Example 5,000 Simulations” tab.

We will welcome all questions and constructive criticism and feedback.


V4 published 3/25/20

Update 3/19/20: We adjusted our Tesla valuation to account for the estimated impact of COVID-19. We have added an input that allows users to adjust factory utilization and realized average selling price (ASP) assumptions for 2020. Note that these changes have adjusted our bear, bull, and expected value price targets for Tesla in 2024.

This file “Tesla 2024 Valuation Extract for Github_3.25.20_v4” contains three different Tesla valuation extracts for users to experiment with their own inputs. The first model assumes ARK’s current research and underlying inputs are correct, but that our probabilities of events occurring, like autonomous robotaxis launching, are subject to change. The second model allows the user to change the underlying inputs but does not provide a probabilistic outcome. The third model allows the user to change both probabilities and inputs. Please read ARK’s blog (https://ark-invest.com/research/tesla-price-target) for or a more detailed discussion of our assessment of the key drivers determining.

ARK Invest Tesla Scenario Probability Model [“Probabilities” worksheet]

This model allows users to input their own probabilities for each of the following:

• Autonomous Capability – Will Tesla launch a fully autonomous taxi service successfully?

• Capital Efficiency – Will Tesla scale factories capital efficiently?

• Gross Margins – Will Tesla’s cost of manufacturing vehicles continue to fall in line with Wright’s Law?

• Access to Capital Markets – If Tesla is unable to lower costs, launch an autonomous taxi network, or become capital efficient, will it also be denied access to the capital markets?

• Black Swan Event – Will Tesla go bankrupt?

The output is a probability weighted average price for Tesla in the year 2024, as well as a bull and bear case. Note that user inputs will adjust the probability at which each scenario occurs while using ARK’s estimated price targets for each probability weighted scenario in column H to calculate bull, bear, and probability weighted average price. Read ARK's Blog with further explanation of our assumptions and thoughts on Tesla here https://ark-invest.com/research/tesla-price-target

Tesla Bottom Up Model [Tesla Valuation and Valuation ASP Tables worksheets]

This model allows users to provide their own inputs for a fundamental-based valuation of Tesla. The “key drivers” are the inputs ARK described in detail in the blog linked above. We have included a representative set of inputs for these variables for ARK’s current bear and bull cases for reference. The “Valuation ASP Tables” worksheet allows the user to change both vehicle average selling price and addressable market at each price point. One can also change the price per mile for an autonomous robotaxi.

The output of the model is a probability weighted average value and financial metrics in the year 2024.

Tesla Monte Carlo Model [Monte Carlo Inputs, Monte Carlo ASP Tables, Monte Carlo Valuation, and Monte Carlo Simulation worksheets]

This model allows users to provide a range of inputs for a bottom up valuation of Tesla. On the “Monte Carlo Inputs” worksheet the user can adjust the minimum, bear case, bull case, and maximum inputs for each variable. All variables are modeled as normally distributed with the bear and bull case inputs determining the values one standard deviation below/above the mean. The maximum and minimum inputs are used to exclude all distributions falling outside of the normal range from the analysis. Note that the “probability that robotaxis launch” row is the only binary input. When changing variables in this worksheet it may be necessary to wait to allow the simulation to calculate. Clicking immediately on another cell within the worksheet could cut the simulation short and provide inaccurate results. The “Monte Carlo ASP Tables” worksheet allows the user to change both vehicle average selling price and addressable market at each price point. One can also change the price per mile for an autonomous robotaxi.

The output of the model is a probabilistic range of values. Relevant charts are on the “Monte Carlo Inputs” worksheet; a single simulated outcome is visible on the “Monte Carlo Valuation” worksheet; and a collection of all the simulations is visible on the “Monte Carlo Simulations” worksheet.

Note, the distribution of price targets arising from the Monte Carlo simulation would imply a narrower bull vs bear outcome-range than our manual tuning would suggest. We still believe that the broader dispersion of outcomes is a more likely outcome due to capital markets reflexivity—if things are going poorly for Tesla then the debt markets will treat them more skeptically, and vice versa—whereas the Monte Carlo simulation treats capital markets receptiveness independently of financial performance.

We will welcome all questions and constructive criticism and feedback.


ARK’s Old 2023 Tesla Valuation Model (file “Tesla Valuation for Github_5.27.19_v3.5“):

V1 published 5/22/19. Read ARK’s corresponding blog with further explanation of our assumptions and thoughts on Tesla here: https://ark-invest.com/research/tesla-valuation-model

V2 published 5/23/19 fixes: 2018 ASP (was previously just Model 3 ASP), slight correction on 2018 sales units, and fix of EBITDA margin formula

V3 published 5/27/19 Performed a broader extraction of balance sheet feed-throughs from the underlying model to allow the extract to more intuitively respond to different capital intensity expectations and unit sales expectations. Minor formula fix on 5/29/19. Updated debt from 2019 capital raise 5/30/19.

Authors: Sam Korus, Tasha Keeney, Brett Winton

Disclosure: This work is licensed under a Creative Commons Attribution-Non-Commercial 4.0 International License. You may not use the material for commercial purposes without first obtaining written permission.

2020, ARK Investment Management LLC. All content is original and has been researched and produced by ARK Investment Management LLC (“ARK”) unless otherwise stated herein.

This material is for informational purposes only and does not constitute, either explicitly or implicitly, any provision of services or products by ARK. Nothing contained herein constitutes investment, legal, tax or other advice and is not to be relied on in making an investment or other decision. Investors should determine for themselves whether a particular service or product is suitable for their investment needs or should seek such professional advice for their particular situation.

This material is intended only to provide observations and views of the author(s) at the time of writing, both of which are subject to change at any time without prior notice. Certain of the statements contained herein are statements of future expectations and other forward-looking statements that are based on ARK's current views and assumptions and involve known and unknown risks and uncertainties that could cause actual results, performance or events to differ materially from those expressed or implied in such statements. Past performance is no guarantee of future results. Equities may decline in value due to both real and perceived general market, economic, and industry conditions.

ARK's statements are not an endorsement of any company or a recommendation to buy,sell, or hold any security. For a list of all purchases and sales made by ARK for client accounts during the past year that could be considered by the SEC as recommendations, please go to https://ark-invest.com/wp-content/trades/ARK_Trades.pdf. It should not be assumed that recommendations made in the future will be profitable or will equal the performance of the securities in this list. For full disclosures, please go to https://ark-invest.com/terms-of-use.

While ARK’s current assessment of the subject company may be positive, please note that it may be necessary for ARK to liquidate or reduce position sizes prior to the company attaining any indicated valuation prices due to a variety of conditions including, but not limited to, client specific guidelines, changing market conditions, investor activity, fundamental changes in the company’s business model and competitive landscape, headline risk, and government/regulatory activity. Additionally, ARK does not have investment banking, consulting, or any type of fee-paying relationship with the subject company.

ark-invest-tesla-valuation-model's People

Contributors

arkinvest avatar brettwinton avatar

Stargazers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

Watchers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

ark-invest-tesla-valuation-model's Issues

Feedback: Why wouldn't diluted share count be used to project future shares outstanding?

Under "shares outstanding," the model projects 964M shares outstanding in 2025. Currently Tesla has 990M shares outstanding, adding 30M since the end of Q4 2020. 1.119B diluted shares are currently outstanding. The enterprise value estimate implies that little -if any- capital will be allocated to Share buybacks. There appears to be a very large discrepancy, in both quantity and trajectory, between the modeled share count and actual share count, significantly altering the price target. Am I missing something here?

2018 Units and ASPs need updating

I realize the 2018 numbers aren't critical to the model but I have observed different values for the Units Sold, Automotive Revenue, and (derived) ASP.

Cars Sold
Cars Sold in E9 says '239,475'.
I think that should say '245,240'
Source: https://ir.tesla.com/news-releases/news-release-details/tesla-q4-2018-vehicle-production-deliveries-also-announcing-2000.

Note that the Revenue figure listed in E11 is for Total Revenue, not Automotive Sales revenue which was $17,631,522 for CY18.

Derived ASP
Total Automotive Revenue / Units Delivered = $17,631,522 / 245,240 = $71.9k

Violation in Monte Carlo model

The Monte Carlo model implicitly assumes that the multivariate normal distribution that is built from the individual assumptions has independent factors and not with a copula. This is easily seen to be violated in practice and is a material risk. For example if costs are in the bear case we expect other "negative" assumptions to have correlation with costs going up. For this reason the bear case is very optimistically valued.

Interest Rate Impact

In the Tesla Valuation Tab changing the interest rate cell (H28) has close to zero impact on tesla price (cell K8) for example rates at 0 give price of 4135 while rates at 100% gives price of 4013$
Given Stock price moved sharply down with 10Y interest rising recently I find it surprising
thanks for your insight

Confirming EV/EBIT, pre-tax margins, pre-tax dollars and market cap to pre-tax dollar valuation

Hello ARK Invest,

Thank you for putting up part of your model. I would like to confirm the calculations I made from it.

                                                                   BULL       BEAR

EV to EBIT 118 59
PRE-TAX MARGIN 7% 2% (Gross margin-SG&A-R&D)
PRE-TAX DOLLARS $10,792 $2,014 (Revenue x Pre-tax margin)
MARKET CAP TO PRE-TAX DOLLARS 125 57

Which then leads to these calculations:

PRE-TAX DOLLAR MULTIPLE 20 20 (my multiple assumption)
VALUE $215,833 $40,280 (Pre-tax dollars x 20)
VALUE PER SHARE $942 $198 (Value/# of shares)

If I am correct then assuming a multiple of 20x the Bull case gives a share price of $942 and the Bear case of $198 is close to the current $190.

Chuck Jones

P.S. I'm not sure the numbers line up for the BULL and BEAR case when you look at it. I apologize for any formatting that doesn't look right.

Detail review notes

Cell F19 you typed in 19,000 but should have typed in 19,000,000,000 consistent with E19 and G19. The impact of the error is that the depreciation of 15% works out to only $2,850 rather than $2.85bn like it should. After correcting this you will get a stock price of $6,007 as your EBITDA will be higher by $2.85bn.

I also agree with the other commenter that you should have a billable % on the miles driven as there are definitely a large percentage of non-billable miles required to get the vehicle to the customer, get it to its charging station, etc.

Overall you did a great job! Thanks for sharing!

TE?

Have you considered adding a TE component to the model? Storage is expected to triple this year which should get it to the $1B range, and is expected to grow faster than automotive. Elon has said on several occasions that he expects storage to be roughly the same size as auto eventually (presumably excluding robotaxi revenue).

bear case needs human taxi service

Your valuations hinge upon the 1.7m and the robotaxis. Both could happen if there is enough demand&no hard production problems. I think you should include the taxi service w humans in the bear case and use a lower production number.

If 5% add their car to a human driven fleet priced at 2.5$/mile an with 20% margin, then the growth in the bear case would be approximately the same as you have now except I assume 1 mil cars produced/year and 2.5 million cumulative by 2023.

And your bull case supposes most will add their car to an autonomous fleet. Not so sure myself.

Tesla.Valuation.for.Github_5.23.19_new.xlsx

"Bear Case" issues

Long term debt in the bear case is far too low. Reducing debt from 12.57BN to 5.15BN would necessitate them paying off 7.42BN in debt, when its seemingly likely that they will have to actually take on more debt just to continue operations.
While they could also fund operations and pay back debt at maturity by raising more equity, the "bear case" cannot seriously assume a weighted avg market cap for an equity raise to be more than double the current market cap ($70BN vs $33BN) .
Furthermore, using a gross margin of 25% (which is what the company guides to) in the bear case is also overly bullish. The point of a bear case is to put in pessimistic assumptions, and taking the word of the company in this case, when they have a history of overpromising, as a pessimistic estimate is wrong.
Further, the usage of EV/EBITDAR&D as the valuation metric is unrealistic for the "bear case". When making intentionally pessimistic assumptions, the pessimism should carry over into your estimate of how the company is valued by the market in 2023. While I can see the argument for EV/EBITDAR&D in the bull case, I think it makes sense to value it on EV/EBITDA or EV/EBIT in the bear case.
Furthermore, the unit sales in the bear case is also not pessimistic enough. It uses the same estimate for EV market size as the bull case and only adjusts TSLA's market share. To construct a proper bear case the market size estimate should be lower than in the bull case.

Model does not consider non-ergodicity

Tesla might post great 2023 numbers but, if it bankrupts on the way there, its (current) stock goes to $0.

The current price of CDS imply a >40% chance of bankruptcy over the next 5 years.

I do not see it priced at all in your model.

A good way to implement it would be to take the share price as computed from 2023 operations and to weigh it with a 40% possibility of having it stuck to $0.

Utility Storage, Home Storage and Solar Roof

Is this model for Tesla's automotive business only, or the entirety of the enterprise?

If the latter, than utility storage in the form of the Power Pack, which has been previously described as being as big an opportunity as automotive, Powerwall home storage, and Solar Roof should also be factored into the model?

Bug in "Max cash deployable"

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.

image

Tesla is an energy company - think GE

Tesla is an energy company. Their sales opportunity will be driven by battery production. Cars, trucks, semis, Megapacks, etc. are all products that demand high density energy storage. Much like General Electric started building everything that could use electricity over 100 years ago - Tesla will be branching out into other product lines within 5 years. Boring Company is build on electric boring machines. Tesla might start selling those! I would love to see a model that shows Tesla production of power cells as the basis of available growth. The more gigawatts of batteries they produce, the more products they will sell whether it is a car, truck, semi, power pack, boring machine, you name it. That was the GE model. They built power plants and the items in your home to use electricity. Tesla is doing the same. Tesla should be compared to the GE of 1900-2000, not current incarnations of car companies.

By the way - I love the analysis and the support of Tesla. As an electrical engineer I can see Tesla making anything from a car to a leaf blower if they wanted to. I see the class 8 vehicles as the biggest threat to the planet. I could see Tesla really making a push into that industry once the dust settles on the model 3 production. I would suggest that Tesla needs the new battery technology to get the power density where he wants it for mass production of the semi. Wall street is having a hard enough time digesting Tesla as a car company. He will totally disrupt the trucking industry overnight when Tesla Semi starts to ship.

When Tesla Semi begins to ship I also anticipate the release of autonomous trucking. Again - it will take time for most people to adjust to the idea of autonomy on big trucks, but they will probably be safer. This is where I could see Tesla insurance coming into play as well. Who is going to insure a driver-less truck in the current insurance market?

Missing income from IP

Tesla filed many many patents. they will generate lots of income when more and more car maker start making EVs.

Why Assume the ASP Does Not Go Down?

Both the Bull and Bear case assume an ASP of $48,250 thru 2023, which does not seem logical considering two facts: the price curve of EVs declines, following the decline of battery pack costs; and that in order to sell 3m or 1.7m vehicles, you will probably need to lower the sale price in order to expand the potential market.

For Tesla specifically, it is also Elon's stated aim to achieve a $35k base price. That is extremely challenging at current battery and operating costs, but will be achievable within the next 4 years as battery pack costs / SG&A% declines.

At least the Bear case should assume a lower ASP?

Missing percentage of billable miles

Line 28, missing the percentage of miles that are billable, I think Elon said something around 50% of miles billable (amount of miles with an actual customer on the car and not the car going to recharge or back home or driving around because no car park).

Bull Case needs many Giga factories?

The Bull case indicates an Autonomous fleet of 7,200,000 cars in 2023. I worked out an annual production to get to this amount, using 3,000,000 cars sold in 2023. Other than Freemont, it looks like five Giga factories will be needed to achieve this fleet size. This seems aggressive considering when models will be introduced and factories can be brought up to full production, such as for Model 3, Model Y, Model '2', and Pickup. (Although, the China Giga3 is being built at remarkable speed).

Would a Bull case fleet of 5,000,000 be more appropriate?

Giga factories needed for Fleet

Is the valuation completely ignoring storage and solar or is it accounted for but not modelled somehow?

I see this note in their article:

Note: We do not model Tesla’s utility energy storage or solar business in our models. We also have not modeled bitcoin assumptions in our model. For ARK’s work on bitcoin as corporate cash, please download our latest Big Ideas presentation.

Does that mean their valuations here are not even taking into account energy storage and solar? or are you accounting for it somehow without fully modelling it e.g. by using someone else's forecasts for storage and solar?

Formula error - Monte Carlo inputs

Formula in cells C8, D8, E8 of "Monte Carlo Inputs" tab should read from range S5:S5004 of "Monte Carlo simulations" (reflecting 5000 simulations) . Currently it reads from just S5:S504 (uses only first 500 simulations - thereby not completely reflecting output from all the runs)

Wrong Reference in 'Monte Carlo Valuation'!N15

In the file Tesla 2025 Valuation Extract for Github_3.18.21.xlsx, Sheet Monte Carlo Valuation, Cell N15, the formula is

=('Monte Carlo Inputs'!D43-'Monte Carlo Inputs'!C43)/2+'Monte Carlo Inputs'!C43

which is the "Tesla platform cut in China".
However, this value is used in Cell H15, with values from row 14 of the input sheet ('Monte Carlo Inputs'!D14 etc.), and is about the "% of cars sold into human driven ride-hail network in 2025".

The formula should probably be:

=('Monte Carlo Inputs'!D14-'Monte Carlo Inputs'!C14)/2+'Monte Carlo Inputs'!C14

Model does not consider non-ergodicity

Tesla might post great 2023 numbers but, if it bankrupts on the way there, its (current) stock goes to $0.

The current price of CDS imply a >40% chance of bankruptcy over the next 5 years.

I do not see it priced at all in your model.

A good way to implement it would be to take the share price as computed from 2023 operations and to weigh it with a 40% possibility of having it stuck to $0.

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.