Autoplay
Autocomplete
Previous Lesson
Complete and Continue
360° Financial Modeling and Valuation
Downloadable Practice Sheet
Practice Problem
OVERVIEW OF FINANCIAL MODELING
Course Introduction (4:01)
Financial Statement Analysis- Breaking Down (3:46)
Working with Financial statements - Part 1 (6:02)
Activity - Basic Level (5:39)
Working with Financial statements - Part 2 (1:49)
Activity - Advance Level (5:05)
Ratio Analysis Overview (10:35)
Valuation Overview (6:02)
Relative Valuation Overview (5:59)
INCOME STATEMENT
Creating an Income Statement (5:16)
Continuing with assumptions (3:57)
Building the format of the Income Statement (4:25)
Building Formulas to Forecast Tax Expense and Minority Interest line Item (2:37)
Working with CAGR Calculation (4:17)
REVENUE MODEL
Overview of the Revenue Model (6:25)
Building a Revenue Model (5:55)
Calculating Average Revenue Per Store (5:47)
360° Financial Modeling and Valuation Feedback
BALANCE SHEET
Constructing Balance Sheet Format_1 (5:03)
Developing Balance Sheet and its Elements (7:10)
Working with CAGR and Trend Analysis Calculation (5:43)
Building Assumption for the Asset Side of the Balance Sheet (9:41)
Forecasting the Balance Sheet for the Liability Side (6:40)
Other Liability Items (10:29)
CASH FLOW STATEMENT
Introduction to the Cash Flow Statement (10:08)
Designing and Structuring the Cash Flow Statement (6:31)
Linking the Line Items in the cashflow (6:52)
Add End 03 (0:14)
WORKING CAPITAL AND CAPEX & DEPREICIATION
Dealing with Working Capital, Capex, and Depreciation (WCCD) (6:57)
Getting the Format Ready - Approach 1 (3:53)
Building Formula for Each Line Item (4:37)
Getting the Format Ready - Approach 2 (5:55)
Forecasting Current Assets (10:59)
Creating a Waterfall Formula (2:48)
Forecasting Line items in the Working Capital Calculations (6:13)
Forecasting Working Captical Schedule (6:00)
Forecasting Capex and Depreciation Schedule (11:44)
DCF VALUATION
Introduction to DCF Method (5:11)
Forecasting of the Dividend Schedule (3:49)
Valuation (6:08)
Compounding, Discounting and Layers of Complexity of the DCF (4:16)
Calculating the Cost of Each Capital (10:02)
Building the Valuation Sheet (10:41)
Calculating the Cash Flows Related to DCF (5:49)
Building Sensitivity Analysis and Schedule of Valuation (8:15)
Session Conclusion (11:45)
360° Financial Modeling and Valuation Feedback
Designing and Structuring the Cash Flow Statement
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock