About this course
Set up essential tools and foundational knowledge for financial modelling.
Prerequisites & Readiness Check
2 Parts
- 0:40 Hr
Prerequisites for Mastering Financial Modelling & Valuation (Beginner)
15 Min
Tool Setup
25 Min
Chapter 1: Financial Statements and Analysis
5 Parts
- 2:00 Hr
Introduction to Financial Modelling
20 Min
Income Statement
25 Min
Balance Sheet
25 Min
Cash Flow Statement
25 Min
Basic Financial Analysis
25 Min
Chapter 2: Accounting and Corporate Finance Basics
2 Parts
- 0:50 Hr
Accounting Principles
25 Min
Time Value of Money
25 Min
Chapter 3: Excel for Financial Modelling
2 Parts
- 1:00 Hr
Excel Formulas and Functions
30 Min
Excel-Based Financial Calculations
30 Min
Chapter 4: Integrated 3-Statement Models
2 Parts
- 1:00 Hr
Model Structure
30 Min
Debt and Working Capital
30 Min
Chapter 5: Forecasting and Financial Analysis
2 Parts
- 0:50 Hr
Revenue Forecasting
25 Min
Financial Ratio Analysis
25 Min
Chapter 6: Introduction to Valuation
3 Parts
- 1:25 Hr
DCF Valuation
30 Min
Comparable Company Analysis
30 Min
ESG in Valuation
25 Min
Chapter 7: Industry Analysis and Project Planning
2 Parts
- 0:50 Hr
Industry Analysis
25 Min
Project Planning
25 Min
Capstone Project 1
1 Parts
- 1:40 Hr
Beginner T-Shirt Startup Financial Model & Valuation
100 Min
Capstone Project 2
1 Parts
- 1:40 Hr
Retail Chain 3-Statement Forecast & Break-Even Analysis
100 Min
No Reviews Yet
