Tesla Financial Model
Automotive Company Financials Example (Free Excel Download)
Tesla, Inc. designs, develops, manufactures, and sells fully electric vehicles, energy generation systems, and energy storage products.
professionals from Deloitte
Used by professionals from
About this model
This model provides a comprehensive equity valuation and scenario planning tool to determine whether Tesla's rapidly growing Energy segment and investments in autonomous driving can offset near-term margin compression and volume stagnation in its core Automotive business.
Tesla, Inc. designs, develops, manufactures, and sells fully electric vehicles, energy generation systems, and energy storage products. The company also offers software services, including its Full Self-Driving (FSD) capability, and operates a global network of Superchargers.
Business segments include:
- Automotive (approximately 79% of FY2024 revenue)
- Energy Generation and Storage (approximately 10% of FY2024 revenue)
- Services and Other (approximately 11% of FY2024 revenue)
Key geographies include the United States, China, and Europe. The business model is a vertically integrated manufacturer with an expanding, high-margin software and services tail. Tesla holds a market-leading competitive position in battery electric vehicles globally, though it faces intense price competition from Chinese manufacturers like BYD and legacy automakers. Recent major events include a massive ramp in AI compute capital expenditure, the completion of the Megafactory in Shanghai, and a strategic pivot towards a planned Robotaxi network.
The downloadable Tesla financial model includes SEC-sourced historical financials, forecast assumptions, core operating schedules, and valuation outputs in an Excel workbook built for review and scenario analysis.
A turnkey financial model
Live formulas, no hardcoded values
Outputs are driven by live formulas, so the workbook updates from its assumptions instead of relying on hardcoded results.
All assumptions in one tab
Inputs are clearly marked in the Assumptions tab and separated from calculations, making it clear what to change and what to leave intact.
Statements always balancing
For integrated-statement models, the balance sheet, cash flow, and supporting schedules tie through properly.
Distinct schedules for clarity
Debt, working capital, taxes, and cash flow can get messy quickly. We group calculations in clear schedules, not across disconnected tabs.
No hidden macros or external links
There are no unexplained external workbook links or macros to undermine auditability or portability.
Changes flow through the model
Update a key driver and see the impact carry through the forecast, financing, and return outputs. We never use hardcoded numbers in formulas.
Historicals & AssumptionsTesla financial modelCompany, Historicals & Assumptions used
Source: SEC EDGAR · values in USD
| Line item | FY2021 | FY2022 | FY2023 | FY2024 | FY2025 |
|---|---|---|---|---|---|
| Revenue | $53.82B | $81.46B | $96.77B | $97.69B | $94.83B |
| Gross profit | $13.61B | $20.85B | $17.66B | $17.45B | $17.09B |
| Operating income | $6.52B | $13.66B | $8.89B | $7.08B | $4.36B |
| Net income | $5.52B | $12.56B | $15.00B | $7.09B | $3.79B |
Forecast assumptions
Defaults used in the downloadable model. Forecast horizon: FY2026–FY2030.
See 8 moreSee less
How to build a detailed financial model for Tesla
A complete walkthrough of every driver, margin, working-capital input, and capital-allocation assumption used in the downloadable model.
Revenue Deep Dive
Automotive Sales
- Segment name: Automotive sales
- Revenue driver formula: Total Deliveries x Average Selling Price (ASP)
- Historical growth rate: Declined 8% in FY2024 after years of 30-50% CAGR
- Key growth levers and headwinds: Levers include new model introductions and financing incentives. Headwinds include high interest rates, macroeconomic pressure, and fierce competition in China.
- Pricing dynamics: Highly dynamic spot pricing. Tesla frequently adjusts vehicle prices to manage inventory and demand.
- Revenue recognition notes: Recognised upon delivery to the customer. FSD software revenue is partially deferred and recognised over time as new features are released.
- Seasonality: Q4 is typically the strongest quarter for deliveries.
Automotive Regulatory Credits
- Segment name: Automotive regulatory credits
- Revenue driver formula: Credits Sold x Price per Credit
- Historical growth rate: Highly volatile, typically ranging between $1.5 billion and $2.5 billion annually.
- Key growth levers and headwinds: Driven by other automakers failing to meet emissions standards. Headwinds include legacy automakers producing more of their own EVs.
- Pricing dynamics: Spot market and bilateral contractual agreements.
- Revenue recognition notes: Recognised when credits are sold and transferred.
- Seasonality: Lumpy and unpredictable, depending on when contracts are executed.
Automotive Leasing
- Segment name: Automotive leasing
- Revenue driver formula: Leased Vehicles x Average Lease Revenue per Vehicle
- Historical growth rate: Stable, low single-digit growth.
- Key growth levers and headwinds: Driven by consumer preference for leasing versus buying, heavily influenced by interest rates.
- Pricing dynamics: Contractual monthly payments.
- Revenue recognition notes: Recognised linearly over the lease term.
- Seasonality: Mirrors broader automotive delivery seasonality.
Energy Generation and Storage
- Segment name: Energy generation and storage
- Revenue driver formula: Storage Deployments (GWh) x Revenue per GWh + Solar Deployments (MW) x Revenue per MW
- Historical growth rate: 67% revenue growth in FY2024 (deployments grew 114% to 31.4 GWh).
- Key growth levers and headwinds: Driven by utility-scale Megapack demand and grid stabilisation needs. Headwinds include supply chain constraints for battery cells.
- Pricing dynamics: Contractual for large utility projects, spot for residential Powerwall.
- Revenue recognition notes: Recognised upon installation or transfer of control.
- Seasonality: Q4 is generally the strongest for installations.
Services and Other
- Segment name: Services and other
- Revenue driver formula: Cumulative Fleet Size x Average Services Revenue per Vehicle
- Historical growth rate: 27% growth in FY2024.
- Key growth levers and headwinds: Driven by the cumulative number of Tesla vehicles on the road requiring out-of-warranty service, Supercharging, and insurance.
- Pricing dynamics: Spot pricing for charging and repairs, regulated pricing for insurance.
- Revenue recognition notes: Recognised as services are rendered.
- Seasonality: Summer months often see higher Supercharging revenue due to travel.
Cost Structure
Variable Costs / COGS
- Line-by-line breakdown: Direct materials (battery cells, steel, aluminium), direct labour, manufacturing overhead, inbound freight, and warranty provisions.
- Gross margin range: Automotive gross margin (including credits) was 18.4% in FY2024, down from 23.3% in FY2023. Energy gross margin expanded to 26.2% in FY2024.
- Key input costs and commodity exposures: Lithium, nickel, cobalt, aluminium, and semiconductor chips.
- How COGS scales with revenue: Step-function operating leverage. COGS per vehicle drops as new factories (Gigafactories) scale up and reach optimal utilisation. COGS per vehicle reached a record low of under $35,000 in Q4 2024.
Operating Expenses
- R&D: Typically 4-5% of revenue. Covers vehicle engineering, battery development, and massive investments in AI compute for autonomous driving. Tesla generally expenses R&D as incurred.
- SG&A: Typically 4-5% of revenue. Driven by the expansion of company-owned stores, service centres, and corporate headcount.
- Depreciation & Amortisation: Embedded largely in COGS for manufacturing equipment, but corporate D&A sits in operating expenses.
- Stock-Based Compensation: Material expense, often exceeding $1.5 billion annually, impacting all operating lines.
- Restructuring / one-time charges: Tesla incurred $684 million in restructuring charges in FY2024 due to global headcount reductions.
Margin Profile
- Gross margin: Consolidated gross margin was 17.9% in FY2024, down from 18.2% in FY2023.
- EBITDA margin: Typically ranges from 12% to 18%.
- Operating margin: Compressed to 7.2% in FY2024 from 9.2% in FY2023.
- Margin trend: Compressing in the core automotive segment due to price cuts, but expanding rapidly in the energy storage segment.
Balance Sheet Structure
- Total assets: Approximately $100 billion.
- Key asset categories: Cash and short-term investments ($36.6 billion in FY2024), Property, Plant and Equipment (Gigafactories), and Inventory.
- Goodwill & intangibles: Very low (under 1% of assets), as Tesla relies on organic growth rather than acquisitions.
- Working capital profile:
- DSO: Typically 15-20 days.
- DIO: Typically 60-75 days.
- DPO: Typically 70-85 days.
- Net working capital: Tesla operates with negative working capital, meaning it collects cash from customers before it pays its suppliers. This provides a structural cash flow advantage during periods of growth.
- PP&E: Consists of vehicle tooling, robotics, Gigafactory buildings, and Supercharger infrastructure. Useful lives range from 3 to 30 years.
- Right-of-use assets: Material, representing leases for retail locations and service centres.
Capital Expenditure & Investment
- Capex as % of revenue: Typically 8-10%.
- Maintenance vs. growth capex: Over 80% is growth capex.
- Major capex programmes: AI training compute clusters (Nvidia GPUs), next-generation vehicle platform development, and expansion of the Nevada and Shanghai Megafactories.
- Capitalised software: Minimal compared to hardware investments.
- M&A pattern: Organic grower. Tesla rarely makes material acquisitions.
- Typical acquisition multiple paid: Not applicable.
Debt & Capital Structure
- Total debt: Very low recourse corporate debt. Most debt is non-recourse vehicle and energy product financing.
- Debt/EBITDA ratio: Near zero (massive net cash position).
- Credit rating: Investment grade (Baa3/BBB).
- Key debt instruments: Asset-backed securities for the leasing portfolio.
- Maturity profile: Well-laddered, mostly tied to underlying lease durations.
- Interest rate profile: Mostly fixed-rate asset-backed notes.
- Covenants: Standard asset-backed facility covenants; no restrictive corporate financial covenants.
- Share repurchase programme: Inactive.
- Dividend policy: No dividend paid.
Cash Flow Characteristics
- Operating cash flow conversion: Very strong. OCF was approximately $15 billion in FY2024.
- Free cash flow margin: Typically 3-5% of revenue, pressured recently by heavy AI capital expenditures.
- Major non-cash items: Depreciation, stock-based compensation, and deferred revenue recognition.
- Working capital cash flow impact: Acts as a source of cash when deliveries are growing, but becomes a use of cash if inventory builds up or sales contract.
- Capex intensity: High. Tesla spent heavily on AI infrastructure in FY2024.
- Cash tax rate: Lower than the statutory rate due to valuation allowances, R&D tax credits, and stock-based compensation deductions.
Sheet Structure
- Assumptions: Hardcoded drivers for deliveries, pricing, margins, and macroeconomic factors.
- Scenarios: Toggle for Bull, Base, and Bear cases affecting delivery volumes and ASPs.
- Operating Metrics: Row-level detail for vehicle production, vehicle deliveries (Model 3/Y, Other Models), and energy deployments (GWh).
- Revenue Build: Calculates Automotive Sales, Automotive Regulatory Credits, Automotive Leasing, Energy Generation and Storage, and Services and Other.
- Cost Build: Calculates COGS per segment and operating expenses (R&D, SG&A, Restructuring).
- Income Statement: Consolidated view mirroring the 10-K, down to Net Income and EPS.
- Balance Sheet: Assets, Liabilities, and Equity. Must track the massive cash and short-term investments balance.
- Cash Flow Statement: Operating, Investing, and Financing cash flows.
- Working Capital: Schedules for Accounts Receivable, Inventory, Accounts Payable, and Deferred Revenue.
- PP&E & Capex: Roll-forward of gross PP&E, accumulated depreciation, and capital expenditures.
- Debt Schedule: Tracking of non-recourse financing and interest income on the cash balance.
- DCF Valuation: Unlevered free cash flow calculation, WACC, terminal value, and implied share price.
Key Financial Relationships
- Automotive Sales Revenue = Total Vehicle Deliveries x Automotive Blended ASP
- Automotive COGS = Total Vehicle Deliveries x COGS per Vehicle (tracked at <$35,000 in Q4 2024)
- Automotive Gross Margin (ex-credits) = (Automotive Sales Revenue - Automotive COGS) / Automotive Sales Revenue
- Energy Generation Revenue = Energy Storage Deployments (GWh) x Revenue per GWh
- Energy COGS = Energy Generation Revenue x (1 - Energy Gross Margin)
- Services and Other Revenue = Cumulative Vehicles Delivered (Fleet Size) x Average Service Revenue per Vehicle
- Total R&D Expense = Base R&D + AI Compute Capex Depreciation
- Interest Income = Average Cash and Short-Term Investments Balance x Weighted Average Interest Rate
- Operating Income = Total Revenue - Total COGS - R&D - SG&A - Restructuring Charges
- Free Cash Flow = Operating Cash Flow - Capital Expenditures
Cross-Sheet Dependencies
The Operating Metrics sheet is the critical engine of the model. Vehicle deliveries feed directly into the Revenue Build (Automotive Sales) and the Cost Build (Automotive COGS). Energy deployments feed the Energy segment revenue. The Revenue Build and Cost Build feed the Income Statement. Net Income from the Income Statement drives the top of the Cash Flow Statement. Capital expenditures from the PP&E & Capex sheet feed the investing section of the Cash Flow Statement and determine the depreciation expense on the Income Statement. A minor circularity exists between the Cash Flow Statement (which determines the ending cash balance) and the Income Statement (which calculates interest income based on average cash balances).
Sign Convention
All revenues, expenses, assets, and liabilities should be entered as positive numbers in their respective schedules. On the Income Statement, expenses are subtracted from revenues. On the Cash Flow Statement, cash inflows are positive and cash outflows (such as capital expenditures) are negative. Contra-asset accounts (like accumulated depreciation) should be entered as positive numbers but subtracted from gross assets to calculate net assets.
Things Most Likely to Go Wrong
- Automotive gross margin calculations often incorrectly include regulatory credits. The model must isolate "Automotive gross margin excluding regulatory credits" as this is the primary metric investors track.
- Regulatory credits are highly unpredictable. Hardcoding a linear growth rate will distort out-year profitability.
- Tesla operates with negative working capital. If the model projects a decline in revenue, working capital will become a massive drain on cash. The builder must ensure the DPO and DIO logic correctly captures this dynamic.
- Stock-based compensation is a massive non-cash expense. Excluding it from operating margin calculations will artificially inflate profitability.
- Interest income is now a material contributor to the bottom line due to the $36.6 billion cash pile. The model must accurately calculate interest income based on prevailing short-term rates.
- Energy storage deployments are growing at triple digits (114% in FY2024). Applying historical automotive growth rates to the energy segment will severely understate future revenue.
- Capital expenditure is heavily skewed towards AI compute, which has a shorter useful life than factory buildings. Depreciation schedules must reflect this mix shift.
- Deferred revenue from FSD software recognition can cause sudden spikes in automotive gross margin. The model should hold deferred revenue release rates constant to avoid artificial margin volatility.
Validation Checks
- Automotive gross margin (excluding credits) should remain between 14% and 20%. Flag if it drops below 14%.
- Energy segment gross margin should remain between 20% and 30% based on recent Megapack performance.
- Total cash and investments must not drop below zero.
- Operating cash flow to net income conversion should remain above 1.5x due to heavy depreciation and SBC add-backs.
- Capital expenditures should not fall below $8 billion annually, reflecting stated management guidance for AI and factory investments.
- The balance sheet must balance: Total Assets = Total Liabilities + Equity in every forecasted period.
- Interest income should be roughly 4-5% of the average cash and short-term investments balance.
Key Assumptions (Default Values)
| Assumption | Default Value | Unit | Rationale |
|---|---|---|---|
| Vehicle Deliveries Growth | 2.0 | % | Reflects stagnant near-term growth seen in FY2024 (-1% YoY) |
| Automotive ASP | 42,500 | USD | Reflects recent price cuts and shift towards cheaper Model 3/Y variants |
| Auto Gross Margin (ex-credits) | 16.5 | % | Reflects FY2024 margin compression due to pricing pressure |
| Regulatory Credits | 2,000 | USD Millions | Historical average run-rate |
| Energy Deployments Growth | 50.0 | % | Conservative step-down from the 114% growth seen in FY2024 |
| Energy Gross Margin | 26.2 | % | Matches actual FY2024 reported energy margin |
| Services Gross Margin | 5.8 | % | Matches actual FY2024 reported services margin |
| R&D as % of Revenue | 4.5 | % | Reflects heavy ongoing investment in AI and robotics |
| SG&A as % of Revenue | 4.5 | % | Historical average |
| Capex as % of Revenue | 9.0 | % | Reflects massive infrastructure and compute investments |
| Effective Tax Rate | 12.0 | % | Historical average reflecting valuation allowances and credits |
| Interest Rate on Cash | 4.5 | % | Reflects current yield on short-term treasury investments |
| WACC | 10.5 | % | Standard discount rate for a high-beta, volatile automotive/tech equity |
| Terminal Growth Rate | 3.0 | % | Long-term GDP growth plus slight premium for energy transition |
Data Sources & Benchmarks
- Filings: Tesla Investor Relations website (ir.tesla.com) and SEC EDGAR for the FY2024 Form 10-K.
- Key Peers: BYD (1211.HK), Ford (F), General Motors (GM), Rivian (RIVN).
- Industry Data: CleanTechnica for EV delivery market share, Wood Mackenzie for utility-scale battery storage deployments.
- Consensus Estimates: Bloomberg Terminal or Visible Alpha for forward-looking delivery and margin consensus.
Sources
- Tesla Q4 and Full Year 2024 Earnings Release and Webcast (ir.tesla.com)
- Tesla FY2024 Form 10-K filed with the SEC
- The Guardian: Tesla Q4 2024 Earnings Report Coverage
- Captide.ai: Tesla Q4 2024 Earnings Analysis
- Medium: Tesla Full Year 2024 Analysis
- TradingView: Tesla, Inc. SEC 10-K Report Summary
- Stock-Analysis-On.net: Tesla Inc. Analysis of Reportable Segments
Do more with the Tesla model
Frequently asked
What does Tesla, Inc. do?+
Tesla, Inc. designs, develops, manufactures, and sells fully electric vehicles, energy generation systems, and energy storage products. The company also offers software services, including its Full Self-Driving capability, and operates a global network of Superchargers.
What are Tesla's main revenue drivers?+
Tesla's primary revenue driver is its Automotive segment, which constituted approximately 79% of FY2024 revenue. Significant additional revenue comes from its Energy Generation and Storage segment, and Services and Other segments.
What is Tesla's capital expenditure strategy?+
Tesla's capital expenditure typically represents 8-10% of its revenue, with over 80% allocated to growth initiatives. Major programs include investments in AI training compute clusters, next-generation vehicle platform development, and the expansion of its Megafactories.
How does Tesla's financial model account for future growth and profitability?+
The financial model incorporates a revenue growth assumption of 0.2 and specific percentages for COGS, R&D, and SGA relative to revenue. Its purpose is to determine if the rapidly growing Energy segment and autonomous driving investments can offset near-term margin compression and volume stagnation in the core Automotive business.
How does Tesla's working capital profile impact its cash flow?+
Tesla operates with negative net working capital, which means it collects cash from customers before paying its suppliers. This structural cash flow advantage is particularly beneficial during periods of growth for the company.
Can I download a financial model for Tesla (TSLA)?+
Yes, a comprehensive Excel financial model for Tesla is available for download. This model serves as an equity valuation and scenario planning tool, with a forecast horizon extending from FY2026 through FY2030.
Have more financial modelling questions? Contact us
Created by ex-finance professionals
Hey, I’m Alex and I created Finamodel.
Over my years in the finance industry I kept building the same models over and over again. Same structure, same assumptions, different logo. So I started building frameworks to turn them into clean, reusable templates.
Every model here is one I’d actually use for a client, and I personally vet each one before it goes up.
I’m not an expert in every industry, but I’ve built enough models to know what belongs in one. And when something is completely foreign to me, I reach out to my network for experts to work on our models with us.
Having a template library on hand cuts a first build from hours to minutes.
Need help finding your model? You’ll find me in the Finamodel app!
Other Automotive Company Financial Models
Browse another company in the same sector.
Aptiv
Aptiv PLC is a global technology company that designs and manufactures vehicle components, focusing on active safety, autonomous driving technologies, and smart vehicle connectivity.
AutoZone
AutoZone is the leading retailer and distributor of automotive replacement parts and accessories in the Americas.
Ford Motor
Ford Motor Company designs, manufactures, markets, and services a full line of connected, increasingly electrified passenger and commercial vehicles.
General Motors
General Motors Company is a global automotive manufacturer that designs, builds, and sells trucks, crossovers, cars, and automobile parts.
Genuine Parts
Genuine Parts Company (GPC) is a leading global distributor of automotive and industrial replacement parts.
O’Reilly Automotive
O'Reilly Automotive is a leading specialty retailer of automotive aftermarket parts, tools, supplies, equipment, and accessories in North America.
Paccar
PACCAR Inc is a global leader in the design, manufacture, and customer support of high-quality premium light, medium, and heavy-duty trucks under the Kenworth, Peterbilt, and DAF nameplates.
Explore more Consumer financial model templates.
