Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Financial Forecasting and Modeling
Section 1: Course Introduction
Introduction to the Course (3:43)
Uses of Financial Forecasts and the Reliability Question (8:57)
DOWNLOAD ME: Exercise Files
DOWNLOAD ME: Course Files
Section 2: Strategic Role of Financial Forecasting
Financial Components to Determine Business Health (10:39)
Role of Forecasting in Strategic Planning (12:20)
Understanding the Business (Part 1 of 2) (14:24)
Understanding the Business (Part 2 of 2) (11:05)
Exercise 01 (3:02)
Going through ABC’s Balance Sheet (9:24)
Going through ABC’s Income Statement (7:04)
Going through ABC’s Cash Flow Statement (7:37)
Section 3: Planning Your Financial Forecast
Defining Your Forecasting Objectives (7:08)
Identifying Our Forecasting Approach and Assessing Timeframes (9:58)
Exercise 02 (1:10)
Identifying Key Variables and Drivers (Part 1 of 3) (8:06)
Identifying Key Variables and Drivers (Part 2 of 3) (7:28)
Identifying Key Variables and Drivers (Part 3 of 3) (9:54)
Key Points to Consider (8:00)
Section 4: Creating Your Financial Forecast
Forecasting Revenues (Part 1 of 2) (13:16)
Forecasting Revenues (Part 2 of 2) (14:41)
Forecasting Expenses (Part 1 of 2) (9:33)
Forecasting Expenses (Part 2 of 2) (7:56)
Forecasting Working Capital (Part 1 of 2) (9:52)
Forecasting Working Capital (Part 2 of 2) (9:43)
Forecasting Depreciation and Capital Expenditures (capex) (Part 1 of 2) (8:25)
Forecasting Depreciation and Capital Expenditures (capex) (Part 2 of 2) (8:59)
Forecasting Intangibles (7:41)
Forecasting Shareholders' Equity (12:11)
Forecasting Long-term Assets & Liabilities (7:15)
Finalizing the Debt Schedule (10:31)
Building a Forecasted Cash Flow Statement (10:30)
Building a Forecasted Balance Sheet (7:28)
Section 5: Analyzing Your Financial Forecast
Rolling Forecasts and Variance Analysis (7:04)
Key Financial Ratios to Analyze Financials (7:09)
Analyzing Financial Forecasts Using Ratio Analysis (8:22)
Exercise 03 (1:41)
Section 6- Key Trends in Forecasting
How Profitability and Risk Affect Financial Forecasting (7:24)
Future Trends in Forecasting (4:38)
Conclusion (1:09)
Course Quiz and Certificate of Completion
Role of Forecasting in Strategic Planning
Complete and Continue