Connect with us

Hi, what are you looking for?

News

Tesla Can Deliver More Than Cars (NASDAQ:TSLA)

Thesis

In the complex landscape of Tesla, Inc. (NASDAQ:TSLA) valuation, a thorough exploration of various scenarios reveals intriguing prospects for investors. As we calculate an average fair value of $251.5, closely mirroring the current stock price of $260.5, it suggests

TABLE OF ASSUMPTIONS
(Current data)
Assumptions Part 1
Equity Value 51,130.00
Debt Value 5,810.00
Cost of Debt 2.46%
Tax Rate 8.72%
10y Treasury 4.80%
Beta 1.51
Market Return 10.50%
Cost of Equity 13.41%
Assumptions Part 2
EBIT
Tax 1,165.00
D&A 4,145.00
CapEx 7,794.00
Capex Margin 8.29%
Assumption Part 3
Net Income 12,195.00
Interest 143.00
Tax 1,165.00
D&A 4,145.00
Ebitda 17,648.00
D&A Margin 4.41%
Interest Expense Margin 0.15%
Revenue 94,028.0

Revenue Net Income Plus Taxes Plus D&A Plus Interest
2023 $99,670.0 $12,289.31 $13,360.95 $17,754.66 $17,906.24
2024 $126,810.0 $15,635.67 $16,999.11 $21,392.83 $21,544.41
2025 $164,853.0 $20,326.37 $22,098.85 $29,366.00 $29,616.71
2026 $214,308.9 $26,424.29 $28,728.50 $38,175.80 $38,501.72
2027 $278,601.6 $34,351.57 $37,347.05 $49,628.54 $50,052.24
2028 $362,182.0 $44,657.05 $48,551.17 $64,517.10 $65,067.91
^Final EBITA^

D&A Projection Interest Projection
2023 4,393.714 151.58
2024 4,393.714 151.58
2025 7,267.151 250.71
2026 9,447.296 325.93
2027 12,281.485 423.70
2028 15,965.931 550.81

Average Sales Price (In USD) Units Sold (Thousands of cars) Change in price % Change in Units Sold %
2019 55.0 367.2 -17.3% 50.4%
2020 48.0 499.0 -12.7% 35.9%
2021 61.0 935.5 27.0% 87.5%
2022 58.0 1,313.86 -4.9% 40.4%
2023 40.2 1,800.00 -30.6% 37.0%
2024 38.1 4,400.00 -5.3% 144.4%
2025 36.1 7,000.00 -5.3% 59.1%
2026 34.1 9,600.00 -5.3% 37.1%
2027 32.3 12,200.00 -5.3% 27.1%
2028 30.6 14,800.00 -5.3% 21.3%
2029 29.0 17,400.00 -5.3% 17.6%
2030 25.0 20,000.00 -13.7% 14.9%

Sales of Vehicles Service & Other Solar
2023 $72,432.0 $7,243.0 $5,112.0
2024 $167,627.8 $9,633.2 $5,464.7
2025 $252,479.8 $12,812.1 $5,841.8
2026 $327,819.8 $50,000.0 $6,244.9
2027 $394,420.1 $100,000.0 $6,675.8
2028 $452,998.0 $150,000.0 $7,136.4

Revenue Net Income Plus Taxes Plus D&A Plus Interest
2023 $84,787.0 $10,454.24 $11,365.85 $15,103.49 $15,232.43
2024 $182,725.7 $22,530.08 $24,494.71 $28,232.35 $28,361.29
2025 $271,133.7 $33,430.79 $36,345.97 $48,298.26 $48,710.61
2026 $384,064.7 $47,355.17 $51,484.57 $68,415.14 $68,999.24
2027 $501,095.9 $61,785.12 $67,172.82 $89,262.44 $90,024.52
2028 $610,134.4 $75,229.57 $81,789.63 $108,685.95 $109,613.86
^Final EBITA^

D&A Projection Interest Projection
2023 3,737.633 128.95
2024 3,737.633 128.95
2025 11,952.284 412.35
2026 16,930.574 584.09
2027 22,089.617 762.08
2028 26,896.318 927.91

Average Sales Price (In thousands of USD) Units Sold (Thousands of cars) Change in price % Change in Units Sold %
2019 55 367.2 -17.3% 50.4%
2020 48 499.0 -12.7% 35.9%
2021 60.98 935.5 27.0% 87.5%
2022 58 1,313.86 -4.9% 40.4%
2023 40.24 1,800.00 -30.6% 37.0%
2024 38.09 2,421.00 -5.3% 34.5%
2025 35.95 3,256.25 -5.6% 34.5%
2026 33.81 4,379.65 -6.0% 34.5%
2027 31.67 5,890.63 -6.3% 34.5%
2028 29.52 7,922.90 -6.8% 34.5%
2029 27.38 10,656.29 -7.3% 34.5%
2030 25.24 14,332.72 -7.8% 34.5%

Revenue Net Income Plus Taxes Plus D&A Plus Interest
2023 $84,787.0 $10,454.24 $11,365.85 $15,103.49 $15,232.43
2024 $105,475.6 $13,005.15 $14,139.20 $17,876.83 $18,005.78
2025 $131,641.3 $16,231.38 $17,646.76 $23,449.85 $23,650.06
2026 $164,768.5 $20,315.96 $22,087.52 $29,350.95 $29,601.54
2027 $206,746.6 $25,491.86 $27,714.77 $36,828.70 $37,143.12
2028 $259,980.5 $32,055.60 $34,850.86 $46,311.49 $46,706.87
^Final EBITA^

Sales of Vehicles Service & Other Solar
2023 $72,432.0 $7,243.0 $5,112.0
2024 $92,233.4 $7,777.5 $5,464.7
2025 $117,448.0 $8,351.5 $5,841.8
2026 $149,555.8 $8,967.9 $6,244.9
2027 $190,441.2 $9,629.7 $6,675.8
2028 $242,503.8 $10,340.4 $7,136.4

D&A Projection Interest Projection
2023 3,737.633 128.95
2024 3,737.633 128.95
2025 5,803.094 200.20
2026 7,263.428 250.58
2027 9,113.932 314.43
2028 11,460.621 395.38

Read the full article here

Click to comment

Leave a Reply

Your email address will not be published. Required fields are marked *

You May Also Like

Videos

Watch full video on YouTube

News

This week’s Fed meeting is extraordinary, and it could shock investors in a way we haven’t seen since 2008. So, I’m doing the weekly...

News

This article was written by Follow Leo Nelissen is an analyst focusing on major economic developments related to supply chains, infrastructure, and commodities. He...

Videos

Watch full video on YouTube