Integrated Financial Statement Modeling, Forecasting, Valuation, Risk Analysis, and Data Visualization
Master financial modeling, forecasting, valuation, risk analysis, and data visualization to become a highly effective financial analyst.
...
Share
Foundations of Integrated Financial Statement Modeling
Unit 1: Financial Statement Fundamentals
Linking the Statements
Income Statement Deep Dive
Balance Sheet Breakdown
Cash Flow Statement
Unit 2: Excel Modeling Best Practices
Model Structure
Formula Fundamentals
Error Prevention
Documentation
Unit 3: Building the Integrated Model
Setting Up Assumptions
Income Statement Model
Balance Sheet Model
Cash Flow Statement Model
Linking the Model
Unit 4: Scenario and Sensitivity Analysis
Scenario Planning
Sensitivity Analysis
Advanced Forecasting Techniques
Unit 1: Regression Analysis for Forecasting
Regression Intro
Simple Regression
Multiple Regression
Expense Forecasting
Regression Pitfalls
Unit 2: Time Series Analysis for Financial Forecasting
Time Series Intro
Moving Averages
ARIMA: The Basics
ARIMA: Implementation
ARIMA: Limitations
Unit 3: Integrating Macroeconomic Factors and Sensitivity Analysis
Macro Factors
Industry Trends
Scenario Setup
Sensitivity Tables
Tornado Charts
Discounted Cash Flow (DCF) Valuation
Unit 1: DCF Valuation Fundamentals
Intro to DCF Valuation
Forecasting Free Cash Flow
FCF Growth Rate Drivers
Unit 2: Calculating the Discount Rate (WACC)
Cost of Equity Explained
Calculating Cost of Debt
WACC: The Weighted Average
Unit 3: Terminal Value Calculation
Gordon Growth Model
Exit Multiple Method
Perpetuity Growth
Which Terminal Value?
Unit 4: DCF Model Refinement
Present Value Calculation
From Enterprise to Equity
DCF Sensitivity Analysis
DCF Best Practices
Common DCF Mistakes
Relative Valuation and Precedent Transaction Analysis
Unit 1: Understanding Relative Valuation
Relative Valuation Intro
Common Multiples: P/E
Common Multiples: EV/EBITDA
Other Key Multiples
Finding Comparable Cos
Unit 2: Applying Relative Valuation
Gathering the Data
Calculating Multiples
Applying Multiples
Common Pitfalls
Unit 3: Precedent Transaction Analysis
Precedent Transactions Intro
Finding Transactions
Transaction Details
Adjusting Multiples
Unit 4: Reconciling Valuation Methods
Reconciling Valuations
Presenting Valuation
Scenario Planning and Monte Carlo Simulation
Unit 1: Introduction to Scenario Planning
Scenario Planning Intro
Identifying Key Drivers
Developing Scenarios
Scenario Impact on Models
Scenario Analysis Output
Unit 2: Introduction to Monte Carlo Simulation
Monte Carlo: The Basics
Probability Distributions
Setting Up the Simulation
Running the Simulation
Analyzing Simulation Data
Unit 3: Advanced Monte Carlo Techniques
Correlation Matters
Sensitivity Analysis
Stress Testing
Decision Making
Model Validation
Data Visualization and Financial Dashboards
Unit 1: Data Visualization Principles
Data Viz: The Essentials
Chart Types: A Quick Tour
Color Theory for Finance
Layout & Design Basics
Unit 2: Excel for Financial Data Visualization
Excel Charts: Core Skills
Advanced Excel Charts
Excel Sparklines
Excel Tables & Formatting
Unit 3: Power BI for Financial Dashboards
Power BI: First Steps
Power BI: Visualizations
DAX Basics
Interactive Dashboards
Power BI: Best Practices
Advanced Risk Analysis and Mitigation Strategies
Unit 1: Identifying and Assessing Financial Risks
Intro to Risk Analysis
Credit Risk: Basics
Market Risk: An Overview
Operational Risk Defined
Risk Interdependencies
Unit 2: Developing Risk Mitigation Strategies
Credit Risk Mitigation
Market Risk Hedging
Operational Risk Controls
Insurance for Risk
Diversification
Unit 3: Risk Management in Financial Planning and Communication
Risk Appetite Frameworks
Risk-Adjusted Return
Risk Communication
Stress Testing
Risk Reporting