Question
How does Tesla's implied value change across valuation methods, capital assumptions, and scenario weights?
Context
Why this mattered
A team-built academic spreadsheet using public sources and explicit assumptions to compare relative valuation, discounted cash flow, and free-cash-flow-to-equity methods.
Approach
From ambiguity to evidence
Organized source data, assumptions, and risk considerations in a traceable workbook.
Built relative valuation, WACC, FCFE, and DCF model sections.
Compared methods through weighted scenarios and sensitivity analysis.
Findings
What the analysis surfaced
Different valuation methods respond differently to growth, discount-rate, and capital-structure assumptions.
A summary view helps make the weighting logic and range of modeled outcomes visible.
The workbook is an academic model based on assumptions, not investment advice or a current price target.
Contribution
What I owned
Finance analyst; contributed research, model inputs, valuation analysis, and the summary narrative.