Financial Modeling
Example Course Schedule
A 16-week schedule covering all core financial modeling topics — chapters, quizzes, assignments, and exams.
19
Chapters
4
Assignments
3
Exams
Wk01
Introduction & Excel Essentials
- Introduction to Financial Modeling
- Essential Excel Skills
Wk02
Excel Bootcamp
- Intermediate Excel Skills
Quiz: Excel Bootcamp · 30 pts
Wk03
Financial Statement Mechanics
- The Balance Sheet
- The Income Statement
Quiz: Financial Statement Mechanics · 30 pts
Wk04
Cash Flows & Forecasting
- The Statement of Cash Flows
Quiz: Statement of Cash Flows · 30 ptsAssignment: Three-Statement Model 📊 · 30 pts
Wk05
Exam 1 · 100 pts
Wk06
Financial Statement Forecasting
- Income Statement Projections
- Balance Sheet Projections
Quiz: Financial Statement Forecasting · 30 pts
Wk07
Bond Valuation
- Bond Fundamentals
Quiz: Bond Fundamentals · 30 pts
Wk08
Bond Characteristics
- Bond Characteristics
Quiz: Bond Characteristics · 30 ptsAssignment: Bond Pricing Dashboard 🔢 · 30 pts
Wk09
Reading Week
Wk10
Exam 2 · 100 pts
Wk11
Stock Valuation
- Valuing Stocks
- Stock Markets
Quiz: Stock Valuation · 30 pts
Wk12
Capital Investment Decisions
- Capital Budgeting & NPV
- Internal Rate of Return
Quiz: Capital Investment Decisions · 30 ptsAssignment: Capital Project Analysis 🏗️ · 30 pts
Wk13
Risk & Return
- Risk & Return
Quiz: Risk & Return · 30 pts
Wk14
Diversification & CAPM
- Diversification
- Beta, SML & CAPM
Quiz: Diversification & CAPM · 30 ptsAssignment: Portfolio Optimizer 📈 · 30 pts
Wk15
Cost of Capital
- Weighted Average Cost of Capital
- Applying WACC
Quiz: Cost of Capital · 30 pts
Wk16
Comprehensive Final Exam · 150 pts