This course was created with the
course builder. Create your online course today.
Start now
Create your course
with
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)
Cash Flow Statement
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock