Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Excel Financial Modeling and Business Analysis: TESLA
Overview of Tesla
Analyzing Teslas Sales Performance (2:23)
Tesla Unveiled (4:05)
Exploring Tesla's Financial Statements
Sourcing Historical Data (6:01)
Consolidated Financial Statements (5:22)
Navigating Teslas Annual Report (3:38)
Revenue Built-Up
Historical Revenue Growth Rate (3:02)
Projecting Teslas Revenue (17:38)
Cost Sheet
Projecting Cost of Sales (18:07)
Color-Coding in Financial Models (2:53)
Forecasting Operating Expenses (9:07)
Working Capital Schedule
Working Capital Ratios (7:14)
Working Capital Projections (12:21)
Depreciation Schedule
CAPEX Projections (3:31)
Calculating Proportion of Assets (5:47)
CAPEX Distribution (2:21)
Using TRANSPOSE Function (4:14)
Calculating Machinery and Equipment Depreciation (8:38)
Completing Ending Net PPE (9:04)
Shareholders Equity Schedule
Common Stock Calculations (5:16)
Retained Earnings Calculations (4:48)
Net Income Attributable to Non-Controlling Interests (7:58)
Provision for Income Taxes (8:21)
Completing The Missing Links
Cash Flow Statement (14:11)
Balance Sheet Linkages (9:09)
Completing cash Flow Linkages (11:59)
Debt Schedule
Cash Available for Debt Repayment (3:03)
Long-Term Debt Payments (6:48)
Income Statement Linkages (11:52)
DCF Valuation
Understanding WACC (4:57)
FCFF Calculations (4:19)
WACC Calculations (12:08)
Terminal Value Explained (7:19)
NPV Calculation Steps (13:14)
Target Share Price Calculations (5:51)
Sensitivity Analysis (7:13)
EPS Calculations
Weighted Average Number of Shares (12:11)
Basic & Diluted EPS (5:13)
EBITDA Calculations (3:57)
Ratio Analysis
Tesla Ratio Analysis (16:26)
Teach online with
Historical Revenue Growth Rate
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock